Convert Bank Statements to Excel for Saudi VAT & ZATCA

For a business registered in Saudi Arabia, clean transaction data is the foundation of every VAT return and every Zakat or tax filing you submit to ZATCA. The problem is that the data usually arrives as a PDF. Converting a bank statement to Excel in Saudi Arabia turns that locked document into a working ledger you can tag, total and reconcile — the practical starting point for accurate bookkeeping.

This is general guidance to help you organise your records, not tax advice. For how VAT and Zakat rules apply to your business, consult a qualified Saudi tax adviser or ZATCA directly.

Why ZATCA filings start with your bank statement

The Zakat, Tax and Customs Authority (ZATCA) administers VAT, Zakat and corporate income tax in the Kingdom. Whichever obligation applies to you, the authority expects records that are complete, accurate and reconcilable. Your bank statement is where that trail begins: it is the independent record of money that actually entered and left the business.

Tax invoices remain the primary evidence for VAT — the tax is driven by invoices, not by cash movements. But invoices only tell you what should have happened. The statement tells you what did happen. Comparing the two is how you catch a sale that was invoiced but never booked, an expense whose input VAT you forgot to claim, or a duplicate that would distort your return. To run that comparison, the statement has to be in a spreadsheet, not a PDF.

Converting Saudi bank statement PDFs

Most banks in the Kingdom — Al Rajhi, SNB (Saudi National Bank), Riyad Bank, SABB, Alinma and others — issue statements as PDFs. Copying rows by hand is slow and introduces errors exactly where you can least afford them.

A converter reads the document and rebuilds the transaction table for you. BayanSheet does this entirely in your browser and outputs Excel or CSV, with one transaction per row: date, description, debit, credit and running balance. Because major Saudi banks are supported, the columns land in the right place rather than collapsing into a single messy field.

Two details specific to Saudi statements deserve attention.

Arabic and bilingual layouts. Many statements are issued in Arabic, or in a mixed Arabic-English format that reads right to left. The converter preserves the description text and keeps each transaction aligned to the correct row, so an Arabic narration does not push the amounts out of place.

Arabic-Indic numerals. Saudi statements often print figures in Arabic-Indic digits (٠١٢٣٤٥٦٧٨٩) rather than the Western digits Excel expects. BayanSheet reads those numerals and writes standard numeric values into the output. That matters because a figure stored as text will not sum — you would get a total of zero, or a silent gap, in a column you assumed was adding up.

The 15% VAT workflow

With the statement in Excel, the VAT work becomes a structured pass over your own data:

1. Export the period. Download PDF statements covering your VAT return period — monthly or quarterly depending on your registration — for every business account.
2. Convert to Excel. Produce a clean transaction table you can sort and filter.
3. Reconcile each account. Confirm that opening balance plus debits and credits equals the closing balance. This proves you are working from a complete set of transactions. BayanSheet runs this reconciliation check automatically, so you know nothing was dropped in extraction.
4. Tag the VAT treatment. Add a column marking each line standard-rated (15%), zero-rated, exempt or out of scope — for both income and expenses.
5. Calculate 15%. For standard-rated lines, compute the VAT amount: output VAT on sales received, input VAT on purchases paid.
6. Match to invoices. Tie deposits to sales invoices and payments to purchase invoices. Any statement line with no matching invoice is a flag to investigate before you file.

A pivot table by VAT treatment then gives you the output and input VAT subtotals in seconds. Keep amounts as numbers and dates as real dates so those totals stay reliable.

Your client data stays in your browser

Bank statements are among the most sensitive documents an accountant handles, and confidentiality is not optional when you hold client data. BayanSheet processes the file in-browser: the conversion happens on your device and the statement is not uploaded to a server. For a bookkeeper managing several clients ahead of a ZATCA deadline, that means faster preparation without moving confidential records through a third party.

Make it a monthly habit

Reconciling once a quarter under deadline pressure is where mistakes appear. Convert and reconcile each month instead, and the return becomes a quick review rather than a scramble. The same clean ledger that supports your VAT return also feeds Zakat and corporate tax calculations, so the work is never wasted.

If you also handle clients across the Gulf, the tuned converter pages on the UAE banks hub extract those statements just as accurately. And if you are new to the process, our guide on how to convert a bank statement to Excel walks through it step by step. Start with your own statement — the first 10 pages are free — and see the ledger before you rely on it.