Bank statements

Where the bank statement enters Clix. Upload the file your bank exports, tell Clix once which column is which, and the lines become the material for reconciliation. Written for the accountant; an Admin can do everything here too.

What you see

1. Upload Statement, top right.
2. Bank accounts: every account Clix knows, shown as its nickname and the last four digits of the account number. Mapping saved marks an account whose column mapping Clix remembers. An Admin also sees Re-map next time on it.
3. The statements list: one row per statement, with the columns Bank Statement (the account), Period and Import. Import shows how the statement arrived (Upload), Verified or Not verified, and the counts, for example "8 imported · 0 skipped". An Admin sees a bin icon, Delete, at the end of the row.
4. Click a row to open Statement Details: the account, the period, Total Credits, Total Debits and the lines. Download downloads the file you uploaded.

Status on a line in Statement Details	Meaning
Reconciled	the line is reconciled
Matched	the line is linked to an invoice or a purchase
Pending	neither yet

The lines are worked on the Bank reconciliation tab of Payments.

From upload to matching

Tasks

• Export the statement from your bank
• Upload a statement
• Map the columns the first time
• Re-map an account
• Finish an upload in one sitting
• Close a line that is not invoice money
• Delete a statement

Export the statement from your bank

Clix reads CSV and Excel (.xlsx) files, up to 10 MB and 20,000 rows. It does not read PDF or the old .xls format. In your bank's business portal, export the account statement for the period as CSV if offered, otherwise Excel. The upload dialog says why: "CSV keeps Arabic text intact." If your bank gives only PDF, tell support.

Upload a statement

Who. Admin, Accountant. Seen on the sandbox 2026-09-29.

1. Click Upload Statement, the button at the top right of the page.
2. Leave Bank account on Read it from the file for a bank export that prints the account number above the lines. Otherwise pick the account from the list, or pick New account….
3. Drop the file on Drag & drop a file here, or click to select, or click Choose File.
4. Click Upload. It stays disabled until a file is chosen.

If the file carries no account number, the dialog says so: "This file carries no account number. Choose the account it belongs to." Pick an account, or pick New account… and enter the Account number and, if you like, a Nickname (optional). Then click Continue.

Result. For an account with a saved mapping the lines import at once. For a new account, or a file whose layout Clix does not recognise, the Map the columns step opens.

Map the columns the first time

Mapping tells Clix which column in your bank's file holds the date, the description, the amounts and the balance. You do it once per bank account; Clix remembers it for the next upload.

Why. Every bank lays out its export differently and none publishes the layout. You tell Clix once per account: "Tell Clix which column is which. It is saved for this account and asked once." No ZATCA rule covers the mapping itself. But ZATCA lists bank statements among the records it may ask to see (Tax Invoicing guideline §8.2), so the imported lines should match the bank's own figures. The balance check below proves that they do.

Who. Admin, Accountant.

1. For an Excel file with several sheets, choose the Sheet. The file is read again.

2. Check the header row. Clix shows the top of the file as a grid with each row numbered, and marks the rows above the header Preamble. Those rows are only read for the account number and IBAN. Each column is labelled Date, Hijri date, Text or Amount. Use Header row up and Header row down to move the header if Clix picked the wrong row.

   

3. Under Columns, pick a file column for each field. Clix fills in the ones whose names it recognises, such as Date, Description, Debit, Credit and Balance; check them:

   • Posting date, required. A Hijri column is greyed out here.
   • Date format, asked only when the dates are ambiguous: "03-05-2026 is both 3 May and 5 March". Choose DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD or DD-MMM-YYYY.
   • Description, required.
   • Hijri date, Time, Remarks or second description and Reference or channel, optional. They are kept with each line.
   • Balance, optional but worth mapping: "Enables the balance chain: every row is checked against the previous balance."
   • A column the file does not have stays on Not in the file.
4. Under Amounts, choose Debit and Credit columns and pick Debit and Credit. If the file has one signed column, choose One amount column, pick Amount, and under Sign convention choose Negative means money out or Negative means money in.

5. Read the Preview of the first rows. Under it Clix says Balance chain passes, names the row where the balance breaks, or says Not verified — no Balance column mapped. While the balance breaks, Continue stays disabled.

   Without a Balance column Clix cannot check the direction of the money, so it asks you to. Under Check the direction before importing it lists a few lines in plain words — Money in 34500.00, Money out 25.00 — and holds Continue until you tick These are the right way round. If a bank fee or a salary reads as money in, the mapping is backwards: change the Sign convention, or swap Debit and Credit, in step 4. Changing any column clears the tick.

   

   

6. Leave Save this mapping for the account ticked: "Next month's upload skips this step."

7. Click Continue.

Result. The dialog closes and the page confirms, for example: "Bank statement uploaded successfully · 6 lines imported, 0 skipped · Verified". Verified means every line's balance equalled the previous balance plus its credit and minus its debit. The next upload for this account skips the mapping step.

If the balance does not add up, the Preview says so before anything is imported, and Continue stays disabled. The usual cause is Debit and Credit swapped:

Swap them back and the check passes.

An account with a saved mapping skips this step, so there is no preview. If its balance does not add up, nothing is imported and the dialog names the row, for example: "Row 0: balance 37080.50, expected 49600.00. Nothing was imported — check which columns are Debit and Credit." Row 0 means the first line did not follow from the opening balance printed above the lines. Either the saved mapping has Debit and Credit the wrong way round, or the export's own opening balance does not match its first line. For the first, an Admin clicks Re-map next time and you upload the file again.

For every other message, see Bank statement upload problems.

Next. Reconcile your bank · Re-map an account · Bank statement upload problems

Re-map an account

Why. The bank changed its export layout.

Who. Admin.

1. On Bank Statements, find the account under Bank accounts.
2. Click Re-map next time.

Result. The page says "Mapping cleared. You will map the columns on the next upload." The next upload for that account asks for the mapping again. Statements already imported are untouched.

Finish an upload in one sitting

Why. Clix holds a file that stopped at the account step or the mapping step for 30 minutes, and only while the dialog is open.

Who. Admin, Accountant.

Finish the account and mapping steps before you close the dialog. If you click Cancel, or the 30 minutes pass, nothing is imported. Upload the file again.

See your bank accounts

Who. Admin, Accountant.

Clix keeps an account per account number it has seen in a statement header. Each carries its account number, its IBAN, a nickname you choose, and whether it has a saved column mapping — which is what decides whether the next upload imports directly or stops to ask.

Close a line that is not invoice money

Why. Bank fees, salaries, tax payments, transfers between your own accounts and loan instalments are not payments on any invoice. Closing them with a reason is how the statement reaches "every line explained".

Who. Admin, Accountant, Create invoice.

1. Open Payments.
2. Click the Bank reconciliation tab.
3. Choose the statement. Open lines show their suggestions and buttons directly; there is nothing to expand.
4. Click Not an invoice.
5. Choose the Reason: Bank fee, Salary, VAT or tax payment, Transfer between own accounts, Loan or Other.
6. Add a Note (optional) if useful.
7. Click Close line.

Result. The line's status becomes Not invoice and it leaves the open count. Reopen undoes it. This is the same action as on the Bank reconciliation tab.

Delete a statement

Who. Admin.

1. On Bank Statements, click the bin icon, Delete, at the end of the statement's row.
2. Confirm: "Are you sure you want to delete this bank statement?"

Result. The statement and its lines are removed, and the same file can be uploaded again. If it was the account's last statement and the account has no saved mapping, the account goes too. A statement with a line linked to a payment cannot be deleted, and the app has no action to unlink a payment from a line.

Statuses

On the statement	Meaning
Verified	every line's balance equalled the previous balance plus its credit and minus its debit
Not verified	no Balance column was mapped, so the check could not run
n imported · m skipped	m lines were already in Clix from an earlier upload of the same account and were left as they were

On a line, in Bank reconciliation	Meaning
Open	not explained yet
Matched	a payment links to it
Not invoice	closed with a reason

Limits and plans

Upload is on every plan. A file may be up to 10 MB and 20,000 rows.

Action	Admin	Accountant	Create invoice	View invoice
Upload, list, open statements	yes	yes
Close or reopen a line	yes	yes	yes
Re-map an account, delete a statement	yes

Questions

I uploaded the same month twice. The same file is refused: "This file was already uploaded.", with Open the earlier statement. A new export that overlaps an earlier one imports only the new lines, and the confirmation says so, for example "2 lines imported, 3 skipped · Verified". Lines you already matched stay matched.

The file has a Hijri date column and a Gregorian one. Map the Gregorian one as Posting date and the other as Hijri date. The Hijri date is kept with each line.

Arabic descriptions came out as symbols. Delete that statement, export the period again as CSV, and upload the CSV. Delete first: a line whose description changed is not recognised as the same line, so it would import twice.

The bank only gives me a PDF. Clix cannot read it. Ask the bank for CSV or Excel from the business portal, and tell support which bank it is.

ZATCA sources

Rule	Document	Section	Page
Bank statements are among the records ZATCA may review	Guideline for Tax Invoicing and Records under VAT Provisions, v3, May 2026	§8.2	p. 40

Where the English and Arabic texts differ, ZATCA says the Arabic prevails.

Related

• Reconcile your bank — the next step after upload
• Payments
• Money, payments and due dates
• Bank statement upload problems