How to Edit a Reconciliation in QuickBooks Online

To edit a reconciliation in QuickBooks Online, review your reconciliation report, locate the incorrect transactions, and adjust their details directly in your account register. Whether you need to fix a wrong date, change an amount, or unreconcile a specific entry, QuickBooks makes it simple to make corrections without undoing the entire reconciliation.

Review Your Reconciliation Report

Before making any edits, review your reconciliation report to identify the issue.

1. Go to Reports in the left-hand menu.
2. Search for and select Reconciliation Reports.
3. Choose the account and the reconciliation period you want to review.
4. Check for discrepancies such as:
   
   • Transactions that shouldn’t be reconciled.
   • Duplicate entries.
   • Incorrect dates or amounts.

Example: If your ending balance doesn’t match your bank statement, review deposits and withdrawals that may have been cleared accidentally or entered twice.

Access the Reconciled Transactions

Once you know which transaction needs correction:

1. Click Accounting from the left-hand menu.
2. Select Chart of Accounts.
3. Find the account you reconciled and click View register.
4. Look for the transaction you need to edit — reconciled transactions are marked with an “R” in the ✔ (Reconcile) column.

You can filter by date or type to find specific transactions faster.

Edit the Transaction Details

If the transaction has the wrong details (like date or amount), you can edit it directly from the register.

1. Click on the transaction to expand it.
2. Choose Edit.
3. Make the necessary changes — for example, adjust the date, payee, or category.
4. Save the changes.

Important: If the transaction is linked to other areas (like invoices or bills), ensure the edit doesn’t affect your financial reports.

Example: You might find that a vendor bill payment was recorded under the wrong account — fixing it here ensures your expenses are properly categorized.

Unreconcile and Reconcile the Transaction Again

If the error is related to the reconciliation status rather than the transaction details, you’ll need to unreconcile and then reconcile it again.

1. In the account register, locate the transaction.
2. Click the “R” under the ✔ (Reconcile) column to change it to blank — this will unreconcile the transaction.
3. Once corrected, go back to Reconcile under Bookkeeping → Transactions → Reconcile.
4. Re-add the transaction to your reconciliation by selecting it again.

This ensures that your records stay aligned with your bank statement.

Adjust and Reconcile Again (If Needed)

After making edits, you may need to reconcile again to ensure everything matches perfectly.

1. Go to Bookkeeping → Transactions → Reconcile.
2. Select the correct account.
3. Enter the ending balance and ending date from your bank statement.
4. Review and match transactions again until the difference is $0.00.

If the difference doesn’t reach zero, revisit your edits — a small typo or missing transaction may still be affecting the balance.

Keep Your Accounting Data Synced with DepositFix

If you accept online payments through tools like DepositFix, you can simplify your reconciliation process. DepositFix integrates with QuickBooks Online, automatically syncing customer payments, invoices, and deposits. This helps reduce manual data entry, minimize reconciliation errors, and keep your financial records accurate.