Reconcile QuickBooks Desktop: A Beginner’s Guide

To reconcile an account in QuickBooks Desktop, compare the transactions recorded in the company file with the bank or credit-card statement for the same period. Enter the statement ending date and balance, verify the beginning balance, mark only transactions that cleared, investigate every difference, and complete the reconciliation when the difference reaches zero.

Reconciliation is a control, not a button-clicking exercise. A zero difference shows the selected ledger activity agrees to that statement. It does not prove every transaction has the correct account, customer, job, tax treatment, or business purpose, so classification review remains necessary.

Before you begin

Use a complete bank or card statement showing the account identity, statement period, beginning balance, ending balance, and transactions. Enter valid activity through the closing date, including checks, deposits, transfers, fees, interest, refunds, card payments, and corrections.

Current Intuit guidance recommends backing up the company file before reconciling in QuickBooks Desktop. Confirm the backup can be located and restored under the business’s retention process. Limit changes to prior reconciled periods while the current reconciliation is in progress.

First reconciliation and opening balance

The opening balance establishes where QuickBooks begins tracking the account. It should be supported by a bank statement, conversion trial balance, or other reliable record at a defined date. An unexplained opening balance entry can make the first reconciliation appear to work while equity or prior-period results remain wrong.

If the account has older unreconciled history, decide whether to enter individual historical transactions, a supported opening position, or a controlled conversion entry. Preserve the source, date, included items, preparer, reviewer, and relationship to the prior system.

Step-by-step Desktop reconciliation

1. Make a current backup of the company file.
2. Open the reconciliation function and select the correct bank or credit-card account.
3. Enter the statement date and exact ending balance.
4. Confirm the displayed beginning balance agrees to the statement.
5. Review checks and payments against the withdrawal section of the statement.
6. Review deposits and other credits against the deposit section.
7. Mark only items that cleared by the statement date.
8. Record supported fees, interest, service charges, and other missing statement activity.
9. Investigate duplicates, wrong dates, wrong signs, transpositions, and transactions in another account.
10. Confirm the difference is zero, complete the reconciliation, and save the final report and statement.

QuickBooks menus can differ by Desktop edition and release. Use current Intuit instructions for the screen path, but keep the accounting objective unchanged.

How to read the reconciliation screen

The beginning balance represents the prior reconciled position. The statement ending balance is the external control amount you enter. Cleared deposits and cleared payments update the QuickBooks cleared balance. The difference compares the cleared book position with the statement.

Do not mark a transaction merely because it is near the statement date. Match date, amount, payee or source, and transaction nature. One bank amount may represent a group of checks or a deposit batch, so compare supporting detail when exact one-to-one matches do not exist.

Beginning balance is wrong

A wrong beginning balance often means a previously reconciled transaction was edited, deleted, moved, duplicated, or changed from reconciled to uncleared. It may also reflect an incorrect opening balance or an adjustment from a prior reconciliation.

Review the prior reconciliation report and Intuit’s discrepancy tools or reports. Identify the underlying transaction and compare it with source evidence before changing anything. Restoring a supported transaction is better than creating an unexplained journal entry that hides the history.

Ending difference is not zero

Symptom	Likely cause	Research step
Difference equals one transaction	Missing, duplicate, or wrong account	Search exact amount and date range
Difference is divisible by nine	Possible transposed digits	Compare amounts digit by digit
Deposits differ	Batching, fees, returns, or duplicate receipt	Tie deposit detail to bank amount
Payments differ	Outstanding item, wrong sign, or card payment error	Trace statement section and source
Beginning balance changed	Prior reconciled activity was altered	Review discrepancy and audit history

Work in sections rather than randomly checking and unchecking items. First confirm statement date and balance. Then compare cleared deposits, cleared payments, fees and interest, and prior-period changes. Recalculate after every correction.

Outstanding checks and deposits

Valid outstanding checks are recorded in QuickBooks but have not cleared the statement date. Deposits in transit are recorded receipts not yet shown by the bank. They remain uncleared and should appear in the reconciliation support.

Review aged items. A check may be stale, voided, lost, duplicated, or subject to unclaimed-property rules. A deposit may have failed, been returned, entered twice, or posted to a different account. Document ownership and expected resolution rather than carrying unexplained items indefinitely.

Credit-card reconciliation

For a credit-card account, compare purchases, cash advances, fees, interest, refunds, statement credits, and payments. A card payment normally transfers value from cash to reduce the credit-card liability. It is not a second expense if the underlying purchases were already recorded.

If several employee cards roll into one master statement, follow the issuer’s statement structure and the QuickBooks account design. Confirm every subaccount or employee-card total is included once and the master payment is not duplicated.

Should you enter a reconciliation adjustment?

An adjustment should not be the first response to a difference. Search for missing and duplicate items, wrong accounts, wrong dates, changed prior activity, fees, interest, and opening-balance problems. If a real residual remains, document its source, materiality, account treatment, approver, and effect.

Frequent adjustments indicate a broken process. Track them by cause and improve transaction entry, bank-feed matching, cutoff, review, or access controls.

After the difference reaches zero

Complete the reconciliation and retain the statement, final reconciliation report, outstanding-item list, corrections, and reviewer signoff. Current Intuit guidance describes viewing prior reports through the Reports Center and choosing a summary, detail, or both, subject to product version.

Then scan reconciled activity for classification errors. Deposits may be loans, owner contributions, transfers, customer advances, or sales. Payments may include loan principal, assets, distributions, transfers, or prepaid costs. Bank agreement does not determine these categories.

Illustrative difference investigation

Suppose QuickBooks is $1,890 above the bank. First confirm the ending balance and date. Search for $1,890, then compare deposits and payments separately. If the difference consists of a $2,000 transfer recorded as income, a $125 service charge omitted, and a $15 interest credit omitted, correct each item from source evidence.

The transfer should connect the two balance-sheet accounts, the charge should use its supported category, and the interest should be recorded in the proper period. Recalculate and confirm zero. A single $1,890 adjustment would hide three distinct events and could misstate revenue and expense.

Users, permissions, and closed periods

Limit who can delete, void, re-date, or change reconciled transactions. Use individual logins where supported, review audit information, and define who may reopen a closed period. If a prior reconciled entry must change, record the reason, evidence, approver, affected reports, and any required amended reconciliation.

Maintain a reconciliation calendar listing every account, statement source, assigned preparer, reviewer, expected completion date, and storage location. Track open differences and old outstanding items until resolved, even after the current statement reaches zero.

Monthly reviewer checklist

• Correct company, account, statement, and period were used.
• Beginning and ending balances agree to the statement.
• The final difference is zero without unsupported adjustments.
• Outstanding items are valid, current, and assigned for follow-up.
• Prior-period changes are explained and approved.
• Transfers, debt, owner activity, and unusual deposits are classified correctly.
• The report, statement, backup, and correction evidence are retained.

For the general bank control, review how to reconcile a bank statement. For recurring Desktop cleanup and close support, review QuickBooks services.