Automated Bank Reconciliation: Handling MDR, Service Fees & 15% VAT Recovery

Ask any corporate accountant or business owner in Saudi Arabia or the UAE what they dread most about month-end closing, and the answer is almost always the same: bank reconciliation.

While matching known customer receipts and supplier payments is straightforward, every bank statement inevitably contains dozens of unrecorded line items:

• Point-of-Sale (POS) Merchant Discount Rates (MDR): Bank commission deducted on Mada, Visa, and Mastercard card swipes before net funds hit your corporate account.
• Domestic & International Transfer Charges: SWIFT charges and SARIE interbank transfer commissions.
• Monthly Account Maintenance Fees: Minimum balance penalties, digital banking portal charges, and payroll SIF processing fees.
• Direct Debit Utilities & Taxes: Automatic debits for electricity, telecoms, or government service fees.

In legacy systems, resolving these statement lines is an agonizing multi-step process: you leave the reconciliation screen, open a separate manual journal entry form, look up the GL codes, calculate the tax, post the journal, and then return to the reconciliation window to match the line.

Worse still, many businesses simply lump all these small bank deductions into a generic "Bank Expenses" bucket—completely missing the 15% input VAT tax credits they are legally entitled to recover.

The Hidden Money in Bank Fees: 15% Recoverable Input VAT

Under Saudi ZATCA and UAE FTA regulations, bank service charges, transfer commissions, and merchant card processing fees are standard-rated financial services subject to VAT.

When Al Rajhi, SNB, Riyad Bank, or Emirates NBD charges your business an electronic transfer fee or POS commission, that fee includes statutory VAT.

If your company pays SAR 5,000 a month in payment gateway commissions, point-of-sale terminal fees, and interbank transfer costs:

• That represents approximately SAR 750 / month in recoverable input VAT.
• Over a full fiscal year, that is SAR 9,000 in legitimate tax credits that reduce your quarterly VAT tax liability payable to the tax authority.

When accountants fail to record bank fees as formal tax invoices or proper VAT vouchers, this tax credit is forfeited.

How BIZA Simplifies Bank Reconciliations

BIZA provides an interactive Bank Reconciliation Workspace (/accounting/bank-reconciliation) designed to make reconciling digital bank feeds and posting adjustment vouchers effortless.

1. Ingest Any Statement Format

Upload your monthly statement directly from your online banking portal. BIZA supports:

• Official electronic formats: CSV, Excel, OFX, QIF, and CAMT.053 XML.
• Digital PDF bank statements: BIZA's extraction engine reads statement transaction dates, reference descriptions, withdrawals, deposits, and closing balances into an interactive data grid.

2. Intelligent Rule-Based Matching

The workspace arranges bank lines on the left and your General Ledger transactions on the right:

• Exact Reference & Amount Match: Automatically pairs cheque numbers, transfer references, and exact currency amounts.
• Configurable Date Windows: Matches transactions within a customizable date tolerance (e.g., ±3 business days) to account for clearing delays.
• Batch Receipt Splitting: One-click matching allows pairing a single lump-sum bank deposit against multiple individual customer invoices.

3. In-Workspace Instant Adjustment Vouchers (CreateAdjustmentDialog)

When a line item exists solely on the bank statement (such as a POS machine rental fee or wire commission):

1. Click Create Adjustment directly next to the statement line.
2. An inline modal appears with the date, description, and currency amount already pre-filled.
3. BIZA automatically detects transaction direction:
   • Money Out: Pre-credits the Bank Account and prompts for the expense account (6010 — Bank Charges & Commission).
   • Money In: Pre-debits the Bank Account and prompts for the income account (4800 — Finance & Interest Income).
4. Automated 15% VAT Recovery: Toggle tax recovery to automatically split the line item: 85% to the expense account and 15% directly into 1150 — Input Tax Recoverable, ensuring full tax deduction on your ZATCA VAT Return.
5. The draft journal entry is created and matched instantaneously—without ever navigating away from the reconciliation screen.

Zero Differences, Spotless Audit Trails

When the calculated difference between your bank statement balance and your cleared General Ledger balance reaches SAR 0.00, you click Sign-Off Statement.

The statement period is locked as Reconciled. All linked vouchers are tagged, preventing accidental double-reconciliation in future periods, and a permanent reconciliation summary audit certificate is preserved for external financial auditors.