A bank feed pulls transactions into your accounting software automatically — but a feed alone is not bookkeeping, and unreconciled feeds are the single most common reason UAE SMEs pay more at VAT and corporate tax time. The workflow below is the one we run for UAE businesses in 2026: connect the feed, clear the coding backlog, reconcile on a weekly rhythm, close the month on a fixed checklist, and keep the audit trail the FTA expects. The decision that separates clean books from a year-end scramble is cadence, not software.
TL;DR
- A bank feed imports transactions automatically; reconciliation — matching each entry to an invoice, receipt or payroll run — is what turns the feed into books that satisfy UAE record-keeping rules.
- The workflow has five stages with different cadences: connect once, set rules once, code weekly, reconcile weekly, close monthly.
- Reconciled monthly books make VAT returns a 30-minute review instead of a reconstruction job, and corporate tax a filing exercise instead of a forensic one.
- Corporate tax records supporting the return must be kept for seven years from the end of the tax period (Article 56, Federal Decree-Law No. 47 of 2022; FTA guidance, tax.gov.ae, 27 August 2025) — automated feeds plus a coded ledger are the cheapest way to hold that trail.
What a bank feed does — and does not do
A feed is a read-only connection between your bank and your ledger. In 2026 the major UAE banking groups expose statement data to the main accounting platforms — Xero, Zoho Books, QuickBooks — either directly or through a feed provider, and transactions typically arrive within one business day.
What a feed does not do:
- Code the transaction. A feed entry says "CARD PURCHASE 12,500.00"; it does not say whether that is a supplier payment, a drawing or a prepaid expense.
- Match the counterpart. A customer payment lands as a bank line; until it is matched to the invoice, receivables are overstated on one side and the bank on the other.
- Spot duplicates and splits. Card authorizations settle days later; without a matching rule the same purchase can appear twice.
- Handle fees and FX. Transfer charges and currency conversion differences need their own treatment or the bank balance never ties out.
So the automation is real but partial: feeds remove data entry, not judgement.
The 2026 workflow, stage by stage
| Stage | Cadence | What happens | Output |
|---|---|---|---|
| 1. Connect feeds | Once, then re-authenticate when the bank rotates credentials | Link every account — operating, savings, cards, gateway settlement, WPS payroll account — not just the main current account | Transactions land daily |
| 2. Set bank rules | Once per recurring pattern | Standing rules for rent, salaries, WPS files, telecom and repeat card merchants; auto-suggestions for the rest | Roughly 60–80% of lines pre-coded |
| 3. Code the remainder | Weekly | Match payments to invoices and bills, attach receipts, park unknowns in a suspense account | No backlog older than a week |
| 4. Reconcile | Weekly | Ledger balance vs bank statement to the fils; investigate every difference immediately | Zero unexplained items |
| 5. Close the month | Monthly | Accruals, prepayments, depreciation, VAT control account tie-out, management pack | Signed-off trial balance |
The weekly rhythm that makes it work
One session, 20–40 minutes for a typical SME:
- Review the auto-suggestions. Accept a rule only where the counterparty and VAT treatment are certain.
- Match receivables. Every customer payment to its invoice; shortfalls go to the deductions you can evidence — read the VAT treatment of discounts and credit notes before writing anything off.
- Clear the suspense account. Suspense is a parking spot, not a category; anything older than two weeks gets escalated.
- Reconcile to zero. If the balance ties, stop. If it does not, find the item now — a difference found on Monday costs minutes; the same difference found in month nine costs a forensic day.
The monthly close checklist
- Bank, card and gateway accounts reconciled to the statement.
- VAT control account tied to what the return claims — the return itself is due within 28 days of the period end (how to file VAT returns in the UAE).
- Payroll reconciled to the WPS salary files actually submitted (the payroll-to-WPS connection covers the file format and deadlines).
- Accruals, prepayments and depreciation posted.
- Management pack: P&L vs budget, cash runway, aged debtors, VAT and corporate tax provisions.
Why feeds fail: the five recurring gaps
- Feeds on some accounts only. The savings account nobody linked is where the reconciliation breaks.
- Card settlements treated as new expenses. Match them to the authorization, or expenses double-count.
- VAT coded from the bank line. The feed shows the gross payment; input VAT recovery belongs to the underlying bill — recover it per the invoice, not the payment.
- Related-party transfers left uncoded. Shareholder transfers and inter-company movements need their own accounts, or the corporate tax return disclosure schedule becomes guesswork.
- No feed suspension during cleanups. Fix the opening balance first, then let the feed resume — otherwise the reconciliation inherits the same error every day.
What reconciled books unlock
- VAT filing becomes review, not archaeology. The VAT treatment of bad debts and input recovery fall out of the ledger instead of a spreadsheet hunt.
- Corporate tax preparation collapses in cost. A return built on reconciled books is materially cheaper to prepare than one reconstructed from bank statements — the corporate tax filing cost breakdown shows where the money actually goes.
- An audit trail that survives seven years. Corporate tax records must be kept seven years from the end of the tax period (Article 56, Federal Decree-Law No. 47 of 2022; FTA record-keeping guidance, tax.gov.ae, checked September 2026).
- Credit and audit readiness. Auditors, banks and free zone regulators ask for reconciled statements; free zone specifics are in the free zone bookkeeping guide.
Books that close themselves
Finanshels runs feeds, rules, weekly reconciliation and the monthly close end to end — with a real accountant owning your numbers.
FAQ
Do bank feeds make reconciliation automatic?
No. Feeds import transactions and support matching rules, but VAT treatment, invoice matching and unusual items still need review — a feed without reconciliation is an import log, not books.
How often should a UAE SME reconcile?
Weekly coding and reconciliation, with a fixed monthly close. Weekly keeps items traceable; monthly is the minimum a VAT or corporate tax filing can stand on.
How long must we keep the records the feeds produce?
Corporate tax records must be kept for seven years from the end of the tax period (Article 56, Federal Decree-Law No. 47 of 2022; FTA guidance checked September 2026).
Which accounts should be connected?
Every account the business controls: current, savings, cards, gateway settlement accounts and the WPS payroll account. One unreconciled account defeats the whole ledger.
Do reconciled books change how much tax we pay?
They change what you can evidence: input VAT recovered, expenses deducted and related-party disclosures all depend on coded, matched transactions — not on the feed itself.
