Bank reconciliation, step by step and in your control.
Reconciliation in DataFlow is a review, not an investigation. Receipts, payments, charges and card takings all reach the ledger through the Cash Book or a journal, then the Reconcile Accounts page sets the bank statement against what DataFlow has posted so you can match, resolve and close.
The problem
When reconciliation becomes an investigation.
If the bank statement and the ledger are kept apart, the monthly reconciliation turns into guesswork about which side is right.
Re-keying the bank statement
Every receipt and payment gets typed in a second time to make the books agree with the bank — slow, and a fresh chance to introduce an error.
The cash book and bank never agree
The two sides drift apart over the month, and nobody is sure which entry is missing or duplicated until someone works back through both.
An afternoon of guesswork each month
Reconciliation slips to a month-end chore that swallows an afternoon, because the matching is done by eye across two disconnected lists.
Bank errors surface too late
A duplicated charge or a payment taken at the wrong value only comes to light months later, once the statement trail has gone cold and the money is hard to recover.
Overview
One page, both sides of the account.
Postings go in through the Cash Book or a journal, then you reconcile against the bank.
Get every bank posting into the ledger
Customer receipts and supplier payments via the Cash Book, with allocations. Charges, interest and transfers posted by journal.
Cash Bookreceipts and payments with allocations
AutoSagePay card receipts posted
Open the Reconcile Accounts page — both sides in view
The bank-statement view of what cleared the account. The DataFlow-posted view of what the ledger holds.
Two gridsbank statement and posted entries
One pageboth sides of the account
Match — automatic first, then manual
Matched pairs reconcile against each other. With Open Banking, auto-match runs first and the rest drop to manual.
Auto-matchruns first with Open Banking
Manualfor the entries left over
Resolve the differences and close the reconciliation
Post any bank-only entry the ledger has not yet recorded. Leave DataFlow-only entries as reconciling items to investigate.
Bank-onlyentries posted before close
Per currencymulti-currency accounts reconcile
In their words
Order processing, stock and accounts sit on one system, so the whole team works from the same picture.
MatconManufacturing & engineering
Explore more
More capabilities.
Bank reconciliation is one of the capabilities that keep the cash position honest — explore the others it works alongside.
Customer receipts and supplier payments post through the Cash Book with their allocations, charges, interest and transfers post via journals, and SagePay card receipts are posted automatically. Every posting goes through the Cash Book or a journal.
Does the Open Banking integration post entries for me?
No. Open Banking pre-matches your statement so auto-match can run first, but it never auto-posts. Every entry still reaches the ledger through the Cash Book or a journal, so you stay in control.
What happens to entries that do not match?
With Open Banking, auto-match runs first and unmatched entries drop to manual matching. You then post any bank-only entry the ledger has not recorded, and leave DataFlow-only entries as reconciling items to investigate.
Can it reconcile accounts held in other currencies?
Yes. Multi-currency accounts reconcile in their own currency on the Reconcile Accounts page, alongside the bank-statement view and the DataFlow-posted view.
See it on your accounts
Make reconciliation a review, not an investigation.
