When a reconciliation won't balance
If the status stubbornly stays In Progress or Not Balanced, it almost always comes down to a few statement lines or a balance figure that needs a second look. This article walks you through the usual causes so you can get to Balanced with confidence.
Clear the unmatched lines
Open the statement under Banking → Bank Accounts and look at the Status column. Every line should end up Matched, Manually Matched, or Excluded. For each Unmatched line:
- Choose Manual Match and enter the Ledger Entry ID of the record it belongs to.
- If there's no such record — for example a bank fee or interest you haven't booked yet — add it in your books first, then come back and match the line.
- If the line is a duplicate or genuinely doesn't belong, choose Exclude.
Check your excluded lines
Excluding is meant for duplicates or lines that aren't yours — not as a shortcut for "I'll deal with it later". If your balance is off, scan the Excluded lines: anything excluded by mistake is money the bank counted but your books didn't. Re-import the statement to start the lines fresh if you need to revisit several at once.
Re-check the balance figures
If every line is handled but the Adjusted Balance still doesn't match, revisit the figures on the reconciliation:
- Confirm the Statement Closing Balance matches your paper or PDF statement exactly.
- Make sure the Book Balance is as at the same Statement Date.
- Use Outstanding Deposits and Outstanding Payments for amounts in your books that haven't reached the statement yet — a common reason the two sides differ.
Choose Save Balances and watch the Adjusted Balance update.
A note on completed reconciliations
Once a reconciliation is Completed it's locked, and records dated before its closing date can't be changed afterwards. That's a deliberate safeguard for your audit trail — so always reconcile in date order, and finish each period before moving to the next.
Related Articles
Importing a bank statement in NexerIQ
What importing does Importing a bank statement brings your real transactions into NexerIQ so you can match them against your records. It's the first half of reconciling — once the transactions are in, NexerIQ even tries to match them for you. ...
Reconciling your bank account in NexerIQ
What reconciling means Reconciling is simply checking that your records agree with your bank. You match each line on the statement to a record in your books, then balance to the statement's closing figure. It's how you catch missed entries, bank ...
Setting up bank accounts in NexerIQ
Why add your bank accounts Adding your bank accounts to NexerIQ lets you track where money comes in and goes out, import statements, and reconcile — so your books always match your real-world balances. Each bank account is linked to a ledger account ...
Customer account activity in NexerIQ: balance, AR aging, and transactions
When you need to know where a customer stands financially — how much they owe, how overdue it is, and what's moved through their account — you don't have to leave the customer record. The Account tab gives you a clear, at-a-glance picture of the ...
Supplier contacts and bank accounts
Beyond a supplier's name and terms, NexerIQ keeps two practical lists on each supplier record: the people you deal with, and the bank accounts you pay into. Keeping these up to date means the right person gets the call and payments land in the right ...