How to Convert an NBK Statement to Excel (Kuwait Guide)

There is a particular kind of morning in a Kuwait City accounting office: client folders open, an audit file half-built, and an NBK statement PDF on screen that holds every number you need and hands over none of them in a form you can calculate with. So it gets retyped, row by row, three decimal places at a time.

This guide covers the whole path — getting the statement out of NBK, the password, converting to Excel or CSV, verifying the numbers survived — plus the detail that defeats most generic converters on a Kuwaiti statement: the third decimal place.

⚠️ One honest note up front. BayanSheet ships hand-tuned templates for exactly four banks: Emirates NBD, FAB, ADCB and Dubai Islamic Bank. NBK is not one of them. NBK statements are read through layout auto-detection — the engine reads the structure of your PDF, handles Arabic and English narration and Arabic-Indic numerals (٠١٢٣), works out the currency scale, and still runs the full reconciliation check. That works well, and it is not the same claim as a tuned template. So give your first NBK file a one-minute sample review — and if you want it tuned properly, email me a sample and I will do it myself.

The three-decimal problem, first — because it changes everything else

Most currencies split into 100 minor units. The Kuwaiti dinar splits into 1,000 fils, so KWD amounts print to three decimals: one dinar and 250 fils appears as 1.250, a balance as 12,480.625.

Almost every PDF-to-Excel tool was built against two-decimal money. Feed it a KWD statement and 1,250.375 becomes 1,250.38. Two halves to that failure, the second worse:

1. The exported number is wrong — in the last digit, on every row, in a file you are about to classify and file.
2. The rounding then contaminates the check. Each row drifts by a fraction of a fils, so the tool either flags a difference on a perfectly correct statement or, if its tolerance sits in the wrong scale, absorbs the error it introduced and reports a clean pass.

BayanSheet's engine treats decimal places as a question to answer, not an assumption. KWD is one of seven codes it holds as three-decimal (with BHD, OMR, JOD, IQD, LYD and TND), read off the statement itself — Latin KWD or the Arabic د.ك, since an Arabic-only label used to leave the scale unresolved and round every printed 12.345 to 12.35. The bank you pick is a second source: the registry records NBK as a KWD bank. Where page and label disagree, the printed decimals win, but only upwards — over-stating precision is harmless (12.300), under-stating destroys a digit nothing recovers — and a contradiction is warned about, not resolved quietly.

The decimal separator is settled the same way, from evidence across the whole document, and flagged when the page does not settle it. A misread 1,250 — one thousand two hundred fifty, or one and a quarter dinars — is wrong uniformly: every amount and balance inflated by the same factor, so the running-balance chain and the closing-balance equation stay internally consistent and reconciliation reports a pass, difference zero, over figures a thousand times wrong.

🔎 Verify that in your output rather than trusting it. It is what the code does, not a guarantee about your file: NBK is not tuned, and we have not had a real NBK PDF to test. On your first conversion, open the sheet beside the PDF — does a fils-level amount still carry all three digits? If it does and the reconciliation passes, the scale is right.

Step 1 — Download the statement as a PDF

You want the bank's own PDF, not a screenshot and not a printed-then-scanned page. A native PDF carries a real text layer, which is what makes clean extraction possible; a scan is only an image, so BayanSheet refuses it rather than guessing at the pixels — there is no OCR step in this product. To tell which you have, open the PDF and try to select a transaction line: if nothing highlights it is an image, and you need a fresh download from the bank or a digital copy on request.

Channel	Rough path	Note
NBK Online Banking	Accounts → the account → Statements	The cleanest source for conversion
NBK Mobile Banking	Account → Statements / Documents	May email the file to your registered address
NBK business banking	Accounts → Statements & Reports	For corporate and multi-user accounts
Branch request	Printed or emailed statement, often stamped	When a certified copy is needed by a third party

Menu labels move between app releases and business banking differs from retail, so treat those paths as the shape rather than the wording — look for Statements or Documents under the account.

Two habits worth forming. Pull whole statement cycles rather than custom date ranges, because a full cycle prints its own opening and closing balances — what the reconciliation checks against. And if your channel offers a spreadsheet too, take the spreadsheet. Wider regional view: our Qatar, Kuwait, Oman and Bahrain converter guide.

Step 2 — Handle the password-protected PDF

If the PDF asks for a password, that is the bank's encryption rather than a corrupted download, and no converter can read the table until it is unlocked.

Gulf banks encrypt emailed statements so a compromised inbox does not hand over an account history, deriving the password from details the customer already holds. The formula is stated in the covering email — take it from there rather than guessing. Common ingredients:

Ingredient	Typical form
Date of birth	DDMMYYYY or DDMM
Civil ID number	Full or last digits
Account number	Last 4–6 digits
Name	First few letters, often uppercase
Mobile number	Last digits

Once you can open it, two routes:

• Convert it as-is. BayanSheet accepts encrypted PDFs and asks for the password locally in your browser. Neither the file nor the password is transmitted anywhere.
• Save an unlocked copy via Print → Save as PDF. This can rasterise the document, turning selectable text into an image — and an image-only PDF gets refused rather than guessed at — so prefer the original, or take a fresh download from online banking.

Fuller treatment: converting password-protected bank statements.

🔒 Never email the password in the same thread as the statement. It defeats the entire point of the encryption. If both must reach a colleague, use two channels.

Step 3 — Convert to Excel or CSV

1. Open BayanSheet in your browser.
2. Drag the NBK PDF onto the page, or use the file picker.
3. If the file is encrypted, enter the password when prompted. It stays on your machine.
4. Auto-detection maps the date, description, debit/withdrawal, credit/deposit and balance columns — Arabic or English — turning Arabic-Indic numerals into values Excel can sum.
5. The reconciliation check runs automatically and flags any row that does not add up.
6. Download as Excel (.xlsx) or CSV.

Nothing is uploaded: the parsing runs as JavaScript inside the tab you already have open, which you can prove by switching off your Wi-Fi and converting anyway. General mechanics: how to convert a bank statement to Excel. One glance worth taking on a Kuwaiti corporate statement: many carry two date columns, posting and value. Pick the one your ledger uses and stay consistent all year.

Step 4 — Verify the output before it touches your ledger

The costly extraction error is rarely the loud one. It is the silent one: a dropped row, a decimal read wrong, a withdrawal in the deposit column. The table looks immaculate, and the problem surfaces weeks later as a reconciliation that will not close.

The governing equation:

Opening balance + total credits − total debits = closing balance

Check	What to look for	Why it matters
Three decimals intact	A fils-level amount still shows all three digits	The Kuwait-specific failure — check this first
Balances reconcile	Opening + credits − debits = printed closing (KWD)	Catches dropped rows and misread decimals
Row completeness	Row count matches the PDF	Missing or duplicated transactions
Debit / credit split	Two distinct columns, correct signs	A merged amount column inverts your net movement
Descriptions intact	A wrapped narration stays on one row	Split descriptions create phantom transactions
Arabic narration	Arabic text and numerals arrived as text and numbers	Text amounts will not sum in Excel
Dates correct	Day and month not transposed	Wrong dates land transactions in the wrong period

BayanSheet runs this reconciliation automatically after every conversion — the closing-balance equation plus a per-row running-balance check — and marks rows that do not balance rather than exporting them quietly. That is arithmetic, not a promise. A converter that hands you rows and advises you to review them carefully has transferred the checking work back to you. Our five-test method for any converter, this one included: how to verify a bank statement converter.

Step 5 — Kuwaiti record-keeping, and why this matters without VAT

Let us be precise, because plenty of Gulf content is not. Kuwait has not implemented VAT. It signed the GCC VAT framework agreement in 2017 with the other Gulf states, but the legislation was never enacted; as at mid-2026 the framework remained under discussion in Parliament with a draft law in preparation. So there is no VAT return to tie your statement back to, and no input/output VAT columns to code.

What Kuwait has instead is narrower and sharper:

• Corporate income tax at a flat 15% on foreign corporate bodies doing business in Kuwait, directly or through an agent. Companies wholly owned by Kuwaiti or GCC nationals sit outside it; mixed-ownership companies are taxed in proportion to the foreign share.
• A domestic minimum top-up tax of 15% for large multinational groups (the €750 million Pillar Two threshold), executive regulations published 30 June 2025.
• Records are kept in Kuwait and inspected. An assessment is generally finalised only after the tax department has inspected them — so the statement is an inspection document, and inspection comes after filing, sometimes long after.

With no VAT regime there is no VAT retention period to quote: keep statements across your whole inspection, audit and statutory-books exposure, and confirm the applicable period with the Ministry of Finance or your tax adviser rather than a blog post, including this one.

📁 Ground rule: the Excel file is a working copy, not a replacement for the original record. The NBK PDF remains the record of authority. Keep both.

A layout that pays off later: name files consistently (NBK_account-no_2026-Q1.pdf plus a matching .xlsx); keep the balance column after classifying; and add classification columns rather than editing the original narration.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Two habits prevent most import failures: standardise the date format across the column before exporting (DD/MM/YYYY is the Gulf convention, and a mismatch is the commonest CSV rejection), and keep debit and credit separate — if the software wants one signed column, derive it with a positive/negative formula.

Then the Kuwaiti extra step: check how your package stores KWD. Some software formats every currency to two decimals by default, rounding your third digit away at the import boundary even though the CSV was correct. Import one month, open a fils-level transaction, confirm the digit survived.

• Xero — Accounting → Bank accounts → the account → Import a Statement: importing into Xero.
• Zoho Books — Banking → the account → Import Statement; save the mapping for next month.
• QuickBooks Online — Transactions → Bank transactions → Upload from file: importing into QuickBooks. Confirm dates parsed as dates, not text.

Mapping in general: importing bank statements into accounting software, plus a Tally walkthrough in importing bank statements into Tally.

Common mistakes

• Assuming a two-decimal converter is fine for a three-decimal currency.
• Converting a screenshot instead of the original PDF.
• Skipping the reconciliation check because the table "looks fine".
• Mixing posting date and value date in the same ledger period.
• Keeping only the Excel file and deleting the PDF — it surfaces during an inspection, years later.
• Skipping the first-file review. NBK is not tuned, so that minute is the whole difference.

Conclusion

Converting an NBK statement to Excel removes hours of manual entry, but the value concentrates in two checks: the third decimal place survived, and the balances reconcile. Download the original PDF, unlock it if needed, convert, verify, then import — and keep the PDF as the record of authority.

Try it on a single statement at the converter and compare the output against the PDF in front of you — the first 10 pages are free, no card required, and purchased credits never expire. If the layout needs work, email me a sample and I will tune it; I answer support myself. More guides: the BayanSheet blog, plus the monthly method in bank reconciliation from PDF statements.