A Xero statement balance that is wrong after an import has one of three causes. The opening balance is wrong, the import brought in too many or too few statement lines, or some amounts carry the wrong sign. Compare Xero's figure with your bank's balance on one date, find the first day they part, and fix that day's lines.
What does the Xero statement balance add up after an import?
The Statement Balance is Xero's running total of everything your bank reported. Xero's article on the two balances defines it as the opening bank balance plus the sum of all bank statements imported into the account, whether they arrived by feed or by manual import. Every imported line moves it.
So the figure has exactly two inputs: one opening balance and a list of statement lines. If the Statement Balance disagrees with your bank, one of those two inputs is wrong. Invoices and bills do not change it. The one exception Xero's comparison guide names is a transaction marked as reconciled by hand, which creates a manual statement line.
The date shown beside the Statement Balance is the date of the last statement line in the account. Xero's article notes that this date does not change when a feed refreshes and brings nothing newer. Always compare the balance with your bank's figure for that same date, not for today.
Statement Balance or Balance in Xero: which figure is off?
Xero shows two balances for a bank account, and they go wrong for different reasons. The Statement Balance comes from imported statement lines. The Balance in Xero comes from the transactions you recorded. After an import, check the Statement Balance against your bank first, because the Balance in Xero can only be right once the statement side is.
Xero's article describes the Balance in Xero as the opening balance plus the account transactions created in Xero. That is the figure on your Balance Sheet. It differs from the Statement Balance whenever lines are imported but not yet reconciled, or transactions are entered but have no matching line yet.
A difference between the two is normal halfway through a reconciliation. A difference between the Statement Balance and your bank is not, and that is the subject of this post. Xero's article puts the order plainly: check the Statement Balance matches your actual bank balance before you reconcile all the lines.
Is the opening balance behind the wrong Xero statement balance?
Check the opening balance first, because it is the quickest input to rule out. If it is wrong, every later balance is wrong by the same amount. A Statement Balance that was off from the very first imported line, by a steady figure that never changes, points to the opening balance rather than to the import.
Xero's guide to comparing the statement balance with your actual bank balance says a mismatch means either the opening balance in Xero is wrong or there is an error in the statement lines. Its first step is to check the opening bank balance is entered correctly and saved.
A typical slip is an opening balance taken from the wrong date. The opening balance should be the bank's balance at the end of the day before your first statement line. A figure copied from the end of the first statement, or from the bank's website on a later day, already includes some of the lines you go on to import, so they count twice.
Missing and extra statement lines from an overlapping import
Most import errors are about which lines arrived, not what they say. An import whose dates overlap the feed or an earlier file adds the shared lines twice, raising or lowering the balance by their total. A file that stops short of the next one leaves a gap, and the balance misses that span.
Extra lines are the more common result. Someone imports a CSV to cover the weeks before a bank feed started, but the file runs a few days into the feed's range. Every line in those days is now there twice. Deleting the extra copies brings the balance back. Xero's guide to deleting or restoring a bank statement line says to delete a line only when it is a duplicate, because deleting changes the Statement Balance, and it allows a whole statement imported twice in error to be deleted at once.
Missing lines show up as a balance that drifts by exactly the value of the days not covered. Import a file for the missing span only, with its first and last dates chosen so it touches neither neighbour.
The same overlap happens in QuickBooks Online. If you keep a second set of books in it, see undoing a bank upload in QuickBooks Online to back out a repeated file, and deleting imported transactions in QuickBooks Online for records that already landed.
Flipped signs in the imported statement file
A line with the wrong sign moves the balance twice its own value in the wrong direction. A deposit of 300.00 imported as a payment takes 300.00 off instead of adding it, so the gap is 600.00. When a gap is exactly twice one transaction, look for that transaction first.
Worked example: tracing a gap to one flipped deposit
The values below are an example. A CSV for April was imported. At the end of April, the bank shows 8,940.00, and Xero's Statement Balance shows 8,040.00. The gap is 900.00, which is twice 450.00.
| Date (example) | Line | Bank statement balance | Xero Statement Balance | Gap |
|---|---|---|---|---|
| 31 Mar | Opening balance | 7,500.00 | 7,500.00 | 0.00 |
| 7 Apr | After first week of lines | 8,120.00 | 8,120.00 | 0.00 |
| 14 Apr | After second week, including a 450.00 customer deposit | 8,410.00 | 7,510.00 | 900.00 |
| 30 Apr | Closing | 8,940.00 | 8,040.00 | 900.00 |
The gap opens in the second week and stays fixed at 900.00, so one line in that week is reversed. The 450.00 customer deposit came in as a payment. Correct the file, delete that one line and import the corrected line, or delete the statement and import the whole fixed file, depending on how much else has been reconciled.
A whole file with reversed signs looks different: the gap grows week by week instead of stepping once. Rebuilding the file is quicker than fixing lines one at a time. SimpleBankConvert is being built to produce a CSV for Xero's statement import, with deposits and withdrawals in one amount column and money out as a minus. It is not open yet, and the get started page collects names for the first invitations.
Finding the date the Xero statement balance went wrong
The fastest way to find the bad line is to find the day it entered. Xero's comparison guide makes this its second step: identify when the error happened, then identify the error. Compare Xero's figure with your bank's printed balance at a few dates and halve the range each time.
- Note the bank's balance on the statement's closing date and compare it with Xero's Statement Balance on the same date.
- If they differ, compare at the statement's midpoint. The gap is either before or after that date.
- Keep halving the half with the gap until you reach one day.
- List that day's statement lines in Xero next to the same day on the bank statement.
- Look for the extra line, the missing line or the line whose sign is reversed.
- Fix it, then compare the closing balance again.
Write each comparison down as you go, with the date, both balances and the gap. The gap itself is a clue: a figure that matches one line on the bank statement, or twice one line, often names the culprit before you reach a single day. A gap that matches no line or pair of lines usually means several small errors, such as a run of duplicated card purchases, and the halving still finds where the first one entered. A month of daily statements takes about five comparisons to pin down a single day. Banks that print a running balance on every line make each comparison quick, because you read the bank's figure straight off the page.
Pending bank items that make the Xero balance look wrong
Sometimes nothing is wrong. Your bank's website often shows an available balance that includes pending card purchases and holds. Those have not posted, so they are not on any statement and not in Xero. Comparing Xero's Statement Balance with that live figure produces a gap that disappears once the items post.
Compare with a posted balance instead: the closing balance on a finished statement, or the ledger balance for a date in the past. If the gap goes away, the difference was timing, not an import error. The guide to pending transactions in the QuickBooks Online bank feed explains why pending items stay out of accounting files, and the reasoning holds for Xero too.
Xero's article on the two balances mentions a related timing case on the transaction side. If you recorded future-dated transactions, the Balance in Xero can differ from the Statement Balance even after reconciling every line. It says that is fine when the matching lines will arrive in the next statement or two.