Reconciling Bank and Credit Card Accounts in QuickBooks for Mac

Reconciliation is where the ledger meets the outside world. The bank statement is independent evidence, and the reconcile window is where you prove the two agree. This article walks through the practice in QuickBooks for Mac, with attention to the judgement calls that decide whether a reconciliation is clean or merely closed.

What to settle before you open the reconcile window

Do four things first. Back up the company file, because a reconciliation writes changes you may want to unwind. Confirm the beginning balance is correct. Confirm every transaction for the statement period is already entered. Have the bank or credit card statement in front of you.

The beginning balance deserves a moment. QuickBooks for Mac pulls it from the ending balance of your last reconciliation. If that figure does not match the opening balance printed on this month's statement, something changed after the last close: an edited or deleted reconciled transaction, a backdated entry, or a prior reconciliation that was undone. Stop and investigate before ticking anything. Reconciling over a wrong beginning balance just buries the error.

Setting up the reconciliation

From Banking, choose Reconcile and select the account. The statement date fills in automatically, usually 30 or 31 days after the previous statement date. Adjust it to match the statement you are holding; the date controls which transactions the window presents.

Enter the ending balance exactly as the statement shows it. Then enter service charges and interest earned from the statement, but only if you have not already posted them. If you entered the bank fee when you paid it, or interest when you noticed it, entering it again here creates a duplicate. Review the fields and confirm.

Working through the ticks

Mark each transaction that appears on the statement, and mark it on the paper statement too. A pencil on the statement is old-fashioned but effective: anything unmarked on the paper at the end is either missing from QuickBooks or missing from the bank's view of the world.

Watch the difference figure as you go. It should trend toward zero. When it lands there, the account is reconciled, and QuickBooks posts any service charge or interest entries you supplied.

When the difference will not reach zero

Small residuals usually have ordinary causes: a transposed digit in the ending balance, a bank fee entered twice, a cheque recorded at the wrong amount, or a transaction dated just outside the period. Fix the posting, not the reconciliation. Editing a reconciled transaction can change the next beginning balance, so note anything you touch.

A difference that equals a recognisable transaction points to that transaction. A difference that is exactly half of one suggests it was entered and later reversed with the sign flipped. These patterns save real time.

When it stops being bookkeeping

Some situations are not reconciliation problems at all. If the beginning balance shifts with no matching edit in the audit trail, if reconciled transactions vanish or change on their own, or if the same fault appears in a sample file as well as the live one, the company file itself may be damaged. That is a data repair question, not a close question.

Before anyone touches the file, preserve your evidence: the backup, the statements, and a note of the difference. Then hand it to a specialist rather than attempting repair inside the ledger. If you also run QuickBooks Online and see the same class of fault there, the same rule applies: protect the evidence first, and let a dedicated repair service handle the file itself.

A clean reconciliation is the strongest single piece of evidence that a ledger is trustworthy. It is worth the discipline.