Bank reconciliation¶
Reconciling checks your books against your bank, one statement line at a time. For each line the bank shows, you say what it is in your books: a payment you've recorded, a bank fee, a transfer. When every line is reconciled and your books' balance equals the bank's, your bank account is right, and you can lock the period.
Reconcile a bank account from its page under Accounting › Bank accounts: click Reconcile. You'll need its statement in first: see Bank accounts.
Who can do this
Reconcile Bank, which works only for someone who sees every client. Paying invoices straight from a bank line also needs Pay Invoices. With View Books alone you can look at the lines, but each one says Reconciling bank lines needs the Reconcile Bank right. See User rights.
How payments reach the bank in your books¶
When you record a payment without saying which bank account the money went into, the payment goes into Undeposited Funds: money you've received that isn't in the bank yet. (If you pick the bank account it was deposited to, it goes straight there, and you match it to the bank line in the same way.)
When you reconcile the bank line it arrived in, the payment moves from Undeposited Funds into the bank, on the date of the bank line. That's also how a deposit of several checks, or a card payout that covers a week of payments, ends up as one line on your statement and still matches every payment in it.
Online payments work the same way. If your chart has an account named exactly Stripe Clearing or Paystack Clearing, payments taken through that gateway go there instead of Undeposited Funds, so you can see what the gateway still owes you.
Reconcile a line¶
The screen lists the lines still to reconcile, oldest first, 50 at a time (Load more for the rest). Search by description, reference or amount, or narrow them by From and To dates. Lines dated before your books start are left out, because your opening balances already count them: the screen says how many, and Show them brings them back (to ignore them, say).
Each line is two cards. On the left is your bank statement line: the date, who it was from or to, the reference, and the amount Spent or Received. On the right is what it is in your books, with a tab for each way to answer:
| Tab | Use it when |
|---|---|
| Match | The money is already in your books (a payment you recorded, a transaction you entered), or it pays an open invoice. |
| Create | It isn't: a bank fee, a card purchase, interest. Create spend or receive money from the line. |
| Transfer | It moved between two of your own bank accounts. |
| Discuss | You need to ask about it, or answer a question about it. See Discuss a line. |
Ignore is for a line that needs nothing in your books (see Ignore a line).
A line BaseCloud found a suggestion for opens on Match. A line it found nothing for opens on Create, ready to book. A line with a note opens on Discuss.
When the card on the right is ready (a match is found, an account is picked, or the bank account to transfer to is chosen), an OK button shows between the two cards. Click it, or press Enter on the line, and the next line is ready.
Match¶
BaseCloud suggests what each line might be, best first, and says why under each suggestion (for example "The line names INV1024 and is exactly what it owes."):
- One payment for exactly the line's amount, in the same direction, dated within 7 days of the line. One with the same reference (or no reference on either) comes first. One whose reference isn't on the bank line is still offered, lower, and says so: banks often drop or shorten references.
- Several payments that add up to the line: a deposit of several checks, or a payout from your payment gateway. It looks at payments in a row, by date, from one gateway (or from Undeposited Funds), in the 14 days before the line. A payout can be a single payment less its fee, and takes in the gateway's refunds, which a payout nets off (marked Refund).
- A transaction already in this bank account for exactly the amount, within 7 days: spend or receive money, a transfer, or a manual journal.
- An open invoice the money pays, for money in: first one that owes exactly the line's amount and whose number (INV1024, or just 1024) or client's name is in the bank's description or reference; then the only open invoice owing exactly the amount; then one the line names that owes more (the line pays part of it, however old the invoice). When several open invoices owe exactly the amount and the line names none, BaseCloud doesn't guess: it says … open invoices owe this amount. Choose the one this line pays, lists the nearest by date first, and you click Choose on the right one. Dates and amounts in the description, like 2026-11-05 or 1024.50, are never read as invoice numbers. A client's name counts when the whole name is there as words and is at least 5 letters, not just a word banks use, like "Payment" or "Transfer". When the line is more than the invoice owes, the suggestion says how much is kept as the client's credit. When a payment you've already recorded matches the line, no invoice is suggested: that money is already in your books, and is matched, not recorded twice.
- A bank rule that fits the line (see Bank rules).
Only payments in the bank account's currency, and dated on or after your books' start date, are offered or can be matched. A payment from before the start date is already in your opening balances.
When a payment you match was recorded after the line's date (the bank shows the money before you recorded it), the move into the bank is dated on the payment's date, because money can't be banked before it was received.
If the suggestion is right, click OK. The line is reconciled.
If it's nearly right, click Change what is matched: the search opens with the suggestion already ticked, so you can add or take something off. If it's wrong, or there's no suggestion, click Find something else (or Find a match):
- Search by contact, reference or amount, and change the From and To dates. Payments and transactions are listed nearest the line's date first; open invoices of any date are listed too. Show more loads more.
- Tick everything that makes up the line: payments, transactions, open invoices, or a mix. What you've ticked stays at the top under Ticked while you search for the rest.
- BaseCloud shows what you've Picked and whether it's over or short of the line. When it adds up exactly, click Reconcile. Back to the suggestion returns to what BaseCloud suggested.
The payments and transactions you pick must add up to the line exactly, apart from fees (below). If a customer paid $1,000.00 on a $1,000.25 invoice, record the $1,000.00 they paid (and write off the $0.25), then match.
Pay invoices straight from the bank line¶
When a customer paid by bank transfer and you haven't recorded the payment yet, match the line to the invoice itself. This is how you'd do it in Xero.
- The suggestion: "Pay INV1024 · Acme Corp", with what it owes and when it was due. Click OK. The invoice is paid and the line is reconciled in one step.
- Find something else: search by client, invoice number or amount. Under Open invoices, tick the invoices this money pays. Each one starts with what it owes (or what's left of the line, when that's less); change it for a part payment. Paying shows how much of the line is used, and anything left over says is kept as … 's credit. Click Reconcile.
BaseCloud records the payment, dated on the bank line's date, straight into this bank account, with the bank's reference. It's applied to the invoices you ticked, and what's left over is the client's credit. The client gets a note, and the automations for a paid invoice and a payment received run, as they do when you record a payment by hand.
- One deposit paying several clients (two customers' payments banked together): tick each client's invoices. BaseCloud records one payment per client, for what their invoices take. If money is left over, pick Who keeps the other … as credit.
- Only money in can pay an invoice, and only from a bank account in your books' currency.
- With your books on, invoices are reconciled by matching their payments to bank lines here, not by a tick on the Accounting page. An invoice an older Recon tick still locks can't take a payment until that tick is removed.
- Paying an invoice records a payment, so it needs Pay Invoices. Without it, an invoice suggestion has no OK and says Paying invoices from a bank line records a payment, which needs the Pay Invoices right. You can still match the line to a payment someone else has recorded.
Don't use Create for money from a customer
Receive money can't pay an invoice, so the invoice would still show as owed and your income would be counted twice. On Create, a money-in line reminds you, and when you pick a client with open invoices it lists them with a Pay button. Match the line to the invoice instead (above), or to the payment if you've already recorded it.
Payouts and their fees¶
Stripe and Paystack pay you a batch of payments at once, less their fees. A $1,000.00 batch with $29.30 in fees reaches your bank as $970.70.
When the payments add up to a little more than the line (by no more than 6%), the suggestion says so: "Less $29.30 bank or merchant fees", with the fee as a percentage. Clicking OK matches the payments and records the fee. In Find something else, when what you've picked is more than the line, tick Record the difference of … as bank or merchant fees and pick the Fees account.
The fee goes to an expense account named Merchant Fees or Bank Fees when your chart has one, or to the account you pick.
Create¶
For money with no invoice behind it. A line in becomes Receive money, a line out Spend money, for the whole amount of the line.
Everything goes on one row: who, what, why and the tax.
- Under Received from or Paid to, type to find a client (Enter takes the first match), or add one with New contact. Leave it empty and the bank's payee is used as the name.
- Type the account under Received for or Spent on (Bank Fees, Office Supplies, Interest Income…): type part of its name or code, and press Enter or Tab to take the first match. When you click Create, the account search is already open, so you can start typing. The account's default Tax rate is filled in; change it if you need to, and edit the Description.
- Split splits the line: one card purchase between supplies and meals, say. Each part gets a row with its own account and Amount; BaseCloud shows what's Still to split.
- More details adds a Reference, and Or a name to type a name other than the payee without making a client.
- Tick Make a bank rule, and give the rule a name, to have the next line like it filled in for you. See Bank rules.
Click OK between the cards: the transaction is created, posted, and matched to the line in one step. If a bank rule fits the line, it fills these in for you (Filled in by the bank rule). Check it and click OK.
BaseCloud also remembers how you coded each payee on this bank account. When no bank rule fits, a line from a payee you have coded before is filled in the same way: the client (or the name you typed), the account and the tax rate. It says Filled in as you coded … on …. Change anything that's different. When you OK a line, the other lines from the same payee on the screen are filled in straight away. A line with no payee, such as a Stripe or Paystack fee, is remembered by its description. Money in and money out are remembered apart, and a line you split over several accounts isn't used. To have it done without checking each time, make a bank rule.
In the US, sales tax you pay on a purchase is part of what it cost: enter the whole amount with no tax. A sales tax rate can't be used on money spent, nor a purchase rate on money received. See Sales tax and VAT.
Transfer¶
For money moved between your own accounts: from checking to savings, or paying off the business credit card. Pick the other bank account under Transferred to (or Transferred from) and, if you like, a reference, then click OK. A transfer is created and matched to this line.
If you already made the transfer from the other account's line, this line is matched to it instead of making it twice. If the other account isn't in BaseCloud yet, add it first.
Discuss a line¶
Discuss keeps a note on a line for whoever reconciles it: a question for the business ("What does this relate to?"), or an answer to one ("Not on CRM"). Type the note and click Save note. The tab shows Discuss * on a line with a note, and the line opens on it. The note shows who wrote it and when. Clear the box and click Remove note to take it off. A note changes nothing in your books, and it needs Reconcile Bank, as reconciling does.
Ignore a line¶
Ignore a line that needs nothing in your books: one that's already part of your opening balances, or one the bank listed twice. An ignored line still counts in the statement balance, but nothing is posted for it.
Reconcile many lines at once¶
Tick lines (or Tick all) and:
- OK the … ticked OKs each ticked line's suggestion. A line that needs a choice, such as several invoices owing its amount, is left for you.
- Ignore them ignores them all.
- Put them on one account: pick an Account and a Tax rate and click Record the … ticked. Each ticked line becomes money spent or received on that account, with the tax taken out of its amount. A line the tax doesn't suit is left, saying why.
OK all … rule lines OKs every line on the screen that one of your bank rules fills in.
Unmatch a line¶
To undo a reconciliation, find the line under Statement lines on the bank account and click Unmatch (or Restore for an ignored line). Before anything is undone, BaseCloud says what will happen: which payments the match recorded and are removed, and which invoices owe again. Click Unmatch to go ahead. The line goes back to the lines to reconcile.
Anything the match moved into the bank is reversed: payments go back to Undeposited Funds, and a payout's fee entry is reversed. The payments themselves aren't removed, except one the match recorded when you paid invoices from the line: that payment is removed too, so the invoices owe again, and the automations for an invoice marked unpaid run.
Because that takes payments off invoices, unmatching such a line needs the Pay Invoices right as well as Reconcile Bank, and you must be able to see the invoices' clients, as removing a payment by hand does. The same goes for voiding a transaction made for a client you can't see.
If that payment left credit which has since paid another invoice (credit is used on a client's new invoices by itself), the line can't be unmatched yet: BaseCloud names the invoice. Take the payment off it first, from that invoice's payments list, then unmatch the line.
If you created a transaction from the line, tick Also void the transaction created from this line to void it too. Leave it unticked to keep it and match it again.
If a bank feed changed the line after you reconciled it, unmatching gives the line the bank's new figures. Reconcile it again with those. A line marked The bank removed this line can be deleted once it's unmatched.
Removing a matched payment
A payment matched to a bank line can't be removed until you unmatch the line. Once a period is reconciled, the payments in it stay put.
The reconciliation summary¶
The bank account's page shows, as at a day you choose:
| Figure | What it is |
|---|---|
| Statement balance | The statement opening balance plus every line the bank has given you. |
| Balance in your books | The bank account's balance in your books. |
| Still to reconcile | The lines not yet matched or ignored, how many and what they add up to. |
| Difference | The statement balance less the balance in your books. |
The difference comes from two things: lines the bank shows that you haven't reconciled yet, and entries in your books the bank hasn't shown yet (a check you wrote that hasn't cleared). When every line is reconciled and the difference is what your uncleared items add up to, usually zero, the account is reconciled.
Ignored lines are listed separately: they count in the statement balance but need nothing in your books. To check the statement lines themselves against your bank's own balance, see Check against your bank's balance.
For a report to keep or hand to your accountant, add the Bank reconciliation card on the Reports page: it lists every line not yet in your books and everything in your books not yet on the statement, and the difference to look into. See The bank reconciliation report.
Locked periods¶
A line dated before your books' start date, or on or before your lock date, can't be reconciled, because that would post into closed books. You can still Ignore it. A reconciliation in a locked period can't be unmatched.
Month end¶
Reconciling every bank account to the last day of the month is the heart of closing a month. See Month end.
Related¶
- Bank accounts: add an account and bring in its statement.
- Bank rules: reconcile everyday lines in one click.
- How invoices post: what a match posts.
- Books reports: the bank reconciliation report.