How to Convert a Riyad Bank Statement to Excel (Saudi Guide)

Riyad Bank is one of the oldest and most widely held banks in the Kingdom, and it is especially common on commercial and corporate accounts — which means its statement crosses almost every Saudi bookkeeper's desk sooner or later. And it arrives in the same awkward shape every time: pages laid out to be read by a person, not calculated with. Between that PDF and a sortable, classifiable, importable Excel sheet sit hours of manual re-entry that nobody needs to do.

This guide walks the whole path: getting the statement out of Riyad Bank, dealing with the password, converting it to Excel or CSV, verifying that the numbers survived the trip, and importing the result into Xero, Zoho Books or QuickBooks.

⚠️ One honest note up front. BayanSheet does not ship a hand-tuned template for Riyad Bank. Instead the engine uses smart auto-detection — it reads the layout of your PDF, copes with Arabic-Indic numerals (٠١٢٣) and bilingual Arabic/English statements, maps the columns it finds, and still runs the full reconciliation check on the result. That works well, and it is not the same claim as a tuned template — so give your first Riyad Bank file a one-minute sample review.

Step 1 — Download the statement as a PDF

You want the bank's own PDF, not a mobile screenshot and not a printed-then-scanned page. A native PDF carries a real text layer, which is what makes clean extraction possible. Screenshots and scans force OCR, and OCR is always less accurate.

Channel	Rough path	Note
Riyad Online	Accounts → Account Statement → select period → PDF	The cleanest source for conversion
Riyad Mobile app	Accounts → Account Statement → period → PDF	Convenient for quick statements on the phone
Branch or customer service	Request an official stamped statement	For formal purposes, not for conversion

📌 Practical tip: download the original PDF — not a photo and not a screenshot from your phone. The PDF Riyad Bank issues carries a text layer, and that layer is what makes the conversion accurate. Screenshots and scanned pages need optical character recognition, and OCR results are always less reliable.

And if you are assembling files for a VAT return or an external auditor, pull the whole period into one file rather than downloading month by month. A full period means one reconciliation check instead of twelve separate ones.

Step 2 — Handle the password-protected PDF

Statements that arrive by email from Riyad Bank are encrypted to protect your data, and no converter can read one until it is decrypted.

🔐 The steps, in order

1. Read the bank's covering email — the password formula is spelled out there (often your national ID, or part of your account number).
2. Open the file in a PDF reader on your own machine and enter the password.
3. Choose Print → Save as PDF and write out a fresh, unprotected copy.
4. Convert the new copy.

Fastest route: skip the emailed copy entirely and download the statement straight from Riyad Online or the Riyad Mobile app.

One caution: some readers turn the page into an image when you print to PDF, which destroys the text layer. If the result looks poor, go back to the copy downloaded directly from the digital channel. You can also convert the encrypted original as-is — BayanSheet asks for the password locally in your browser, and neither the file nor the password is transmitted. There is a fuller treatment in our guide to 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 you must send both to a colleague, use separate channels.

Step 3 — Convert the statement to Excel or CSV

With the PDF in hand:

1. Open BayanSheet in your browser.
2. Drag the Riyad Bank 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. Smart auto-detection reads the transaction table and maps the date, description, debit/withdrawal, credit/deposit and balance columns — in Arabic or English — converting Arabic-Indic numerals to values Excel can sum.
5. The reconciliation check runs automatically and flags any row that does not add up.
6. Download the result as Excel (.xlsx) or CSV, depending on what your accounting software wants.

Nothing is uploaded at any point in that sequence. The parsing runs as JavaScript inside the browser tab you already have open.

Because Riyad Bank is auto-detected rather than tuned, take one minute on the first file of a given format: open the converted sheet next to the PDF and spot-check a sample of rows and the totals. Once you have confirmed the mapping, subsequent statements in the same layout behave the same way. The general mechanics are covered in how to convert a bank statement to Excel.

⚡ Client data privacy: the conversion happens entirely inside your browser, so the statement is never uploaded to any server. To check it yourself, disconnect your internet and convert a file anyway. If it still works, the processing really is local — and nothing can leak from a copy that was never stored.

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 single dropped row, a decimal read wrong, or a withdrawal that landed in the deposit column. The table looks perfect, and the problem surfaces three weeks later as a reconciliation that will not close or a VAT return that will not tie out.

The governing equation:

Opening balance + total credits − total debits = closing balance

Run these checks on the converted file:

Check	What to look for	Why it matters
Balances reconcile	Opening + credits − debits = closing (SAR)	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-Indic numerals	Amount columns read as numbers, not text	Text amounts will not sum in Excel
Dates correct	Day and month not transposed	Wrong dates land transactions in the wrong VAT period

BayanSheet runs the reconciliation automatically after every conversion — the statement's own printed opening and closing balances, plus a running-balance check on each row — and marks the rows that do not add up, down to a one-riyal difference. That is arithmetic, not a promise, and it is worth being precise about what it can and cannot see: it will catch a lost row, a transposed digit or an inverted debit, because those break the totals. It cannot tell you that a description was misread, because a wrong narration still balances. That is what the one-minute sample review is for.

Our five-test method for evaluating any converter, including this one, is in how to verify a bank statement converter. If you handle more than one Saudi bank, the same logic applies across them — see the Al Rajhi guide and the SNB guide.

Step 5 — Saudi record-keeping and VAT via ZATCA

For a business registered for VAT with ZATCA (the Zakat, Tax and Customs Authority), the bank statement is a core supporting document: it is where declared sales are matched against receipts, and where supplier payments tied to input VAT are traced.

📁 Ground rule: the Excel file is a working copy, not a replacement for the original record. Saudi record-keeping rules require accounting books and supporting documents to be retained for the statutory period, and the original Riyad Bank PDF remains the document of authority in a ZATCA audit. Keep both: the PDF as the record, the spreadsheet as the tool.

A layout that pays off later:

• Name files consistently: RiyadBank_account-no_2026-Q1.pdf with a matching .xlsx.
• Keep the balance column in the spreadsheet even after classifying — it is the fastest way to trace any discrepancy.
• Add a tax-treatment column (standard-rated, exempt, out of scope) rather than editing the original narration.
• Do not delete non-VAT rows; keep them so the sheet still ties back to the statement.

There is more on assembling the return itself in bank statements to Excel for a Saudi VAT return.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Each package wants a slightly different shape, but the same two habits prevent most failures: standardise the date format across the whole column before exporting (DD/MM/YYYY is the usual Gulf convention, and a mismatch here is the single most common CSV rejection), and keep debit and credit separate — if the software wants one signed amount column, derive it with a simple positive/negative formula.

• Xero — Accounting → Bank accounts → the account → Import a Statement, then map date, description and the amount columns.
• Zoho Books — Banking → the account → Import Statement, map the columns, and save the mapping so Zoho reuses it next month.
• QuickBooks Online — Transactions → Bank transactions → Upload from file; confirm dates parsed as dates, not text, before accepting the batch.

Also strip any repeated page headers and footers if they show up as rows in the output, and import one month first and reconcile it before batching a whole year. If the mapping is wrong, you would much rather find out across 40 rows than 500.

Common mistakes

• Converting a screenshot instead of the original PDF.
• Skipping the reconciliation check because the table "looks fine".
• Keeping only the Excel file and deleting the original PDF — a mistake that shows up in an audit.
• Editing original transaction data instead of adding new classification columns.
• Skipping the first-file review on an auto-detected bank. Riyad Bank is not tuned, so that one minute on a new statement format is the difference between confidence and a surprise at close.

Conclusion

Converting a Riyad Bank statement to Excel saves hours of manual entry, but the real value is in step four: verifying that the balances reconcile before the numbers reach your ledger. Download the original PDF, unlock it if needed, convert, verify, then import — and always 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 and no card is required. For more accounting guides, browse the BayanSheet blog, or start with the Al Rajhi guide.