Product guides

Reconciling an account against the closing balance

Reconciliation compares what Spendix computes with what your statement says. Learn how to run it, read its figures and record the result.

Editorial illustration for Reconciling an account against the closing balance

A tracker is only as trustworthy as its balances. You can have beautifully categorised transactions and still be off by a few hundred units because something is missing. Reconciliation is the check: does the balance computed from your transactions agree with the closing balance on the bank statement? Spendix has a reconcile screen for each account that does the arithmetic.

Starting a reconciliation

Open the account and choose the reconcile option. Pick the period you want to check: this month, last month, or the current statement cycle. The screen presents the figures for that period.

If nothing has been imported for that period, there may be no statement closing balance on file, and the screen says there is nothing to compare against. Importing the statement for the period supplies one.

Reading the figures

The reconcile screen sets out a small sum.

  • **Opening balance:** where the account stood at the start of the period.
  • **Credits in:** money received during the period.
  • **Debits out:** money paid during the period.
  • **Computed closing:** opening plus credits minus debits, according to your records.
  • **Statement closing:** the balance printed on the bank statement.
  • **Difference:** the gap between the two.

If the difference is zero, the screen tells you Spendix and the statement agree for this period. That is the good outcome, and it means your records for the account are complete for those dates.

Marking it reconciled

When the figures agree, you can mark the period as reconciled. The screen explains that marking is an audit entry: Spendix records who reconciled which period and when. It is a record of an action, not a lock on the data. Use it as a checkpoint to show that you verified the period.

Why it is worth doing

Reconciliation catches errors that nothing else does. A missing transaction, a duplicate, a wrong amount or a wrong date all produce a difference. Without the check, those errors sit quietly inside totals and reports. With it, you find them while the statement is still fresh.

A good rhythm

Reconcile each account monthly, shortly after the statement is available. The task is quickest when it is regular, because there are few transactions to examine if a difference appears. Leaving it for a year turns a ten-minute check into a forensic investigation.

ResultMeaningNext step
Difference of zeroRecords match the statementMark reconciled
Small differenceA missing or mis-keyed itemInvestigate; see the next article
No statement balanceNothing imported for the periodImport the statement

Preparing before you start

Reconciliation is quickest when the groundwork is done. Import the statement for the period, process the review queue, and clear any duplicates first. Then open the reconcile screen. Arriving with tidy records means a difference, if one remains, is more likely to be a real discrepancy than a leftover chore.

Credit cards need a different eye

On a credit card, the statement closing balance is the amount owed. A computed closing that differs from it points to the same causes as a bank account, but check payments too. A card bill payment recorded in the wrong account, or not at all, leaves the card balance higher than it should be. Matching the payment on both sides is part of reconciling a card.

Keep the evidence

Save each statement file with the account name and month in the filename. If you ever need to defend a figure, the file and the audit entry together make the case cleanly.

What reconciliation does not prove

Agreement on the total does not guarantee that every transaction is correct. Two errors can cancel each other. Reconciliation shows that the total is right, and a quick scan of categories and large items covers the rest. Even so, a matching balance is a strong signal that the account's records are sound.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports