Skip to main content

Why won't my reconciliation balance?

Find and fix the difference when a bank reconciliation won't reach $0.00: a beginning balance that doesn't match, a wrong ending balance, missing or duplicate entries, deposits that don't line up, and changes to earlier months.

You will need the Bank Reconciliations permission, plus Full Write Accounting, to work on a reconciliation.

A reconciliation can only be finished when the Difference in the Overview box is $0.00. The Difference is your Cleared Balance minus the Expected ending balance from your statement. If you can't get there, one of the causes below is almost always the reason. Work through them in order.


Start with the balances

The Beginning Balance doesn't match your statement

The Beginning Balance can't be typed over. It comes from the ending balance of your last reconciliation, or for a first reconciliation, the starting balance in your chart of accounts. If it differs from the beginning balance on your bank statement, the problem is in an earlier month, not this one.

  • A transaction in an earlier reconciliation was changed or voided after it was reconciled.

  • An earlier reconciliation was undone and finished again with different items. When it is finished again, its new ending balance is copied to the reconciliation that follows it.

  • The starting balance on the account doesn't match the bank on the day you started.

Open the previous month's reconciliation on the Reconciliations tab under Accounting > Banking and compare it with that month's statement. To redo an earlier month, see How do I undo a reconciliation?

The ending balance or date was entered wrong

Compare Expected with the ending balance on your statement, and the statement ending date in the Details box with your statement. If either is wrong, delete this reconciliation and start a new one with the right figures. Deleting a reconciliation doesn't delete any transactions.

Then look at the transactions

Something on the statement isn't in One Church Software

Bank fees, interest, automatic payments and transfers are easy to miss. Click Add New at the top of the reconciliation to record the missing entry. It appears in the list, ready to check.

Something is in One Church Software twice

A transaction entered by hand and then added again from the bank feed shows up twice. Void the extra one from its 3-dots menu. To stop it happening, match bank transactions to entries you already recorded. See How do I match a bank transaction to an existing entry? and How do I edit, void or delete a posted entry?

A deposit doesn't match the bank

Online giving reaches your bank net of fees, and one bank deposit can cover more than one batch. See How do I reconcile One Church Giving deposits with my bank?

Items from other months

Check only the items that appear on this statement. A check written last month that cleared this month should be checked now. A check written near the end of the month that hasn't cleared yet should be left unchecked until it shows on a statement.

Use the Difference as a clue

  • If the Difference equals one transaction's amount, that item is missing or checked by mistake.

  • If it equals twice a transaction's amount, that item was entered as a payment instead of a deposit, or the other way round.

  • If it divides evenly by 9, look for two digits typed in the wrong order, such as $54 entered as $45.

Still stuck?

Your checkmarks save as you go, so you can leave and come back. Use the Notes tab to record what you found, and contact support if you need help. See How do I contact support?

Other Helpful Articles

Did this answer your question?