Reconciling Bank and Credit Card Accounts in QuickBooks for Mac
A walkthrough of the reconciliation workflow in QuickBooks Desktop for Mac, from matching statements to resolving discrepancies and clearing data-damage-related issues.
Account reconciliation is one of those routine bookkeeping tasks that QuickBooks Desktop for Mac handles well — provided the company file is healthy and every transaction for the statement period has already been entered. When the process stalls or the numbers refuse to tie out, the cause usually falls into one of two camps: a step was missed in the reconciliation workflow itself, or underlying data damage is throwing the figures off. Here is what the community has established as the proper reconciliation procedure for QuickBooks for Mac, along with the accepted fixes when things go sideways.
Before You Begin
The reconciliation window in QuickBooks for Mac depends on a few prerequisites being in place. Back up the company file first — this gives you a restore point if a reconciliation needs to be undone later. Confirm that the beginning balance shown in QuickBooks matches the beginning balance on the bank or credit card statement; if it does not, a previously cleared transaction was likely edited or deleted after the last reconciliation. Make sure every transaction for the statement period — checks, payments, deposits, charges, and any bank fees or interest — has already been entered. Have a copy of the bank or credit card statement on hand. A pencil for marking items off the physical statement as you go is useful as well.
Starting the Reconciliation
From the Banking menu, select Reconcile. Choose the bank or credit card account you want to reconcile from the account list. QuickBooks automatically fills in the statement date, typically defaulting to 30 or 31 days after the previous reconciliation’s statement date. Adjust it to match the actual statement date if needed.
The beginning balance is also entered automatically — QuickBooks pulls this from the ending balance of the last completed reconciliation. Enter the ending balance as it appears on the statement. If the statement includes a service charge or interest earned, enter those amounts in the designated fields, but only if those transactions have not already been recorded in QuickBooks separately. Review all fields for accuracy and select OK to proceed to the main reconciliation screen.
Matching Transactions
The reconciliation window displays all uncleared transactions that QuickBooks has on file, organized into two sections. For bank accounts, these are Deposits and Other Credits and Checks and Payments. For credit card accounts, the sections are labeled Charges and Cash Advances (for purchases) and Payments and Credits (for payments made to the card issuer).
Go through the statement line by line and check off each matching transaction in QuickBooks. As you select items, the cleared balance updates in real time. A search field lets you locate specific transactions by name, amount, account, date, check number, or payee — handy when a statement lists dozens of entries and you need to find one quickly.
A summary panel tracks the total count and dollar amount of deposits and checks marked cleared so far. If the bank statement provides a similar subtotal, comparing the two can help pinpoint where a discrepancy begins. Two convenience buttons — Mark All and Unmark All — let you select or deselect every transaction at once. For users who reconcile regularly and keep transactions current, marking all at once and then unchecking the few exceptions can save time. There is also an option to hide transactions dated after the statement’s end date, which keeps the list uncluttered.
If you need to step away, selecting Leave exits the reconciliation window without losing progress — the transactions already checked remain marked when you return. Once every transaction on the statement has been matched and the difference reads zero, select Reconcile Now.
Generating the Reconciliation Report
After completing the reconciliation, QuickBooks prompts you to choose a report type and detail level. Options include Summary, Detailed, Both, or None. The detailed report is generally the most useful for record-keeping, as it lists every transaction included in the reconciliation. Select Done to finish.
When Reconciliation Discrepancies Appear
If the numbers will not balance, or if the beginning balance has changed unexpectedly since the last reconciliation, the cause may be a transaction that was edited, deleted, or added to a prior period after that period was already reconciled. QuickBooks for Mac offers a Reconciliation Discrepancy Report — found under Reports > Banking — that surfaces changes made to previously reconciled transactions. Reviewing this report helps isolate which entries shifted.
Two accepted approaches address discrepancies. The first is to undo reconciliations from the point where the discrepancy first appeared forward, then re-reconcile each subsequent period. The second is to run a special reconciliation targeting only the affected transactions, which can resolve the gap without disturbing the rest of the reconciliation history.
When the Problem Is Data Damage
If reconciliation issues appear across multiple company files — including QuickBooks sample files — the problem is likely not with the data entry but with the QuickBooks installation itself. In that scenario, performing a clean reinstall of QuickBooks for Mac Desktop is the recommended course of action. Removing the existing installation entirely before reinstalling ensures that corrupted program files are replaced rather than carried over.
For reconciliation problems that persist in a single company file despite correct data entry and a clean installation, the file itself may have structural data damage that needs to be repaired before the account will reconcile properly.