Skip to main content
GullySystem
Finance & Accounting · Solutions

Match the books to the bank statement and review only the differences.

Bank reconciliation lines your books up against the bank statement and leaves only the entries that do not match. Cheques that never cleared, charges nobody recorded and a transfer with no name against it sit on one short list. The month closes on what the bank actually did, and not on what somebody meant to record.

What it is

Reconciliation is often done by printing the statement and ticking it against the ledger with a pencil. It takes a day or two, so it happens once a quarter. With every round the gap carried forward grows, and nobody wants to open it.

Import the statement instead. Amount, date and reference pair themselves, and what is left is a handful of lines. You name the customer behind an unexplained credit, post a bank charge, and flag the cheque that went nowhere.

What it replaces

What your team uses today.

The module takes over these, one at a time, so nothing has to stop while it is set up.

  • An Excel sheet of highlighted ticks
  • Passbook entries ticked off in pen
  • A monthly difference carried forward in a note
Where it goes wrong today

The problems this is meant to ease.

Statement and books disagree

The bank shows a balance and the ledger shows another. The gap is a total with no list behind it. Each month starts with a hunt.

Cheques lost track of

A cheque is written, handed over and forgotten. Weeks later it clears, or it does not, and nobody has noted which.

Charges nobody booked

Interest, fees and penalties appear only on the statement. They reach the books late. They arrive in a lump, under a vague head.

Gateway payouts that do not add up

A settlement arrives as a lone credit although it covers many orders and a fee. Matching means opening each order in turn. It eats a day.

Matching held in a lone head

Only the person who matches knows why an entry was left open. When they are away, the close waits.

Inside the module

What bank reconciliation does.

Statement import

The Excel or CSV file your bank provides is read in, one account at a time, with duplicates from an overlapping date range ignored.

Matching on amount, date and reference

Obvious pairs are matched without review. The rest are offered as likely matches for a person to accept.

Rules for regular entries

Bank charges, loan repayment debits and gateway settlements that arrive every month are matched by a rule you write once.

Cheques in transit

Cheques issued but not presented, and cheques deposited but not credited, are kept as their own list with dates.

Gateway settlements split back

A gateway pays a day’s collections as one credit, minus its charge. That credit is broken back into the bills behind it.

The difference on any date

Book balance, bank balance and what stands between them, for a date your accountant picks.

Where it gets used

What this looks like in a working week.

Illustrative scenarios, written to show the shape of the work. They are not accounts of client systems.

Month-end statement import

The accounts assistant uploads the statement file. Most lines match on amount and reference without a touch, and the few that remain wait on someone to decide.

A cheque deposited late

A customer cheque goes in on the final day of the month. It shows as in transit. The gap is explained and the books are not forced to agree.

A gateway settlement

A credit lands for a day of online orders. It is split back into orders, fees and tax. Each part is matched to its own record.

A question from the auditor

The auditor wants to see an earlier day. What stands between book and bank appears with its unmatched entries, and a reason is written against each.

Who touches it

The people who open this every day.

Accounts assistant

Runs the match, clears the easy lines, and leaves the questions for somebody who knows the customers.

Your accountant or auditor

Opens the unmatched list at closing and sees the reason written against each entry.

Owner

Sees the real cash position, without counting a cheque from a customer who has stopped answering.

How it is set up

From first conversation to daily use.

  1. Agree the bank accounts

    List each account and the format its statement arrives in. A note comes back. It names the accounts to set up and the import route for each.

  2. Set the matching rules

    Describe regular entries such as rent, loan instalments and charges. The rules are loaded. Test them against a month you have already closed.

  3. Trial on a closed month

    Provide a statement with the books for a closed month. The accountant sees matched lines, unmatched lines and the final difference. Nothing is hidden.

  4. Train the finance group

    The accounts assistant and the accountant sit down with their own data. Questions are logged and answered in writing.

  5. Live month

    The next statement is imported on arrival. The close is reviewed together, and rules are adjusted from what the team found.

Measuring it

How you would know it is working.

Record where you stand before it goes live, so the change is measured against your own figures.

  • Unmatched lines at month close, by bank account
  • Cheques in transit, by age
  • Bank charges posted from the statement, by head
  • Gateway settlements matched back to orders
  • Dates on which books and bank last agreed, by account
How it fits

It is one part of a system, not an island.

A module earns its place by what it passes to the next one. These are the connections we set up most often.

  • Receipts management
  • Expense tracking
  • Payment gateway settlements
  • Finance and accounting reporting
  • Your accounting software
Common questions

Questions owners ask about bank reconciliation.

Does it connect to our bank directly?

Usually not. A live feed needs a corporate banking arrangement that your bank has to agree to, and most small businesses do not have one. Downloading the statement and importing it takes a minute and works with every bank.

Our accounting software already reconciles. Why do this here?

If everything you bill and spend is already entered in your accounting software, do it there. This is for businesses whose collections, gateway settlements and site expenses live in an operations system. Tell us how your settlements and site expenses are recorded today, and we can place you on one side or the other.

How far back can we clean up?

As far back as you have statements, though somebody has to decide what the old unmatched entries were. Software can pair figures. It cannot remember who paid you in 2023.

What about cash taken at the counter?

Cash sits outside this. The module reconciles bank accounts, and counter cash is checked against the day’s collection entries instead.

What pushes bank reconciliation cost up or down?

The count of bank accounts, the formats of their statements and any payment gateways. Branches with accounts of their own add setup. A lone account with a plain file is lighter. We read your scope first, then the quotation shows each item separately. The gateway split can be removed.

How quickly can the accounts team begin matching?

As soon as statement files and a closed month are in hand. Import, matching and a list of leftovers go live first. Rules for regular entries and gateway splits come after, and the proposal sets out when each arrives.

Talk to us

Tell us how you handle bank reconciliation today.

A spreadsheet, a register or another system: say which, and we will tell you plainly what is worth changing.

What happens after you share your requirements

  1. A senior engineer reads your answers. Nobody phones first.
  2. Within one business day you get a written note: what we understood, what we would start with, and the questions we still have.
  3. If it fits, a proposal follows with the order of work, what we need from you and what you receive at each step.
  4. No call is booked and nothing is paid until you have read the note. Your details stay with us.

Start with your requirements

Seven short steps that tell us what you need. A senior engineer reads them before anyone gets in touch.

Share your requirements