Enter an adjusting entry for a reconciliation in QuickBooks Online

Adjusting entries in QuickBooks Online help to maintain record integrity. QuickBooks Online reconciliation adjustment entry can rectify issues, record accrued expenses, and adjust financial balances.

Furthermore, adjusting entries are required to reconcile bank/credit card accounts. These differences are visible in the discrepancy report.

The Reconciliation Discrepancy report highlights a valid accounting difference. It detects adjustments to completed reconciliations and displays the transaction variations.

Prior to making an adjustment entry, check the discrepancy report. Review the opening balance, repeated transactions, unavailable entries, and amounts. Rectify the original entry and integrate the correct amount, date, and account to adjust.

This guide outlines how to detect, rectify, and avoid QuickBooks Online reconciliation discrepancies. The following section highlights the significance of a QuickBooks Online adjusting journal entry and how it supports better business decisions.

Key Reasons for Reconciliation Discrepancies in QuickBooks Online

QuickBooks Online reconciliation adjustment entry is needed during a discrepancy. When the account fails to align with the bank/credit card statements, a reconciliation discrepancy arises.

Here is the list of the common reasons for such discrepancies:

• Opening balance difference- The opening balance fails to align with the last statement’s closing balance.
• Wrong Closing Balance- The ending balance entered does not align with the statement.
• Repeated Transactions- Repeated payments, deposits, or other entries are entered.
• Unavailable Entries- Statement entries are not available in QuickBooks Online.
• Wrong Classification- Entries are aligned to different accounts.
• Adjusted or Erased Entries- Reconciled entries were erased or adjusted.
• Pending Transactions- Statement entries are pending in QuickBooks Online.
• New Transaction Date- Transactions have new dates on the statement and QuickBooks Online. This puts them in separate reconciliation periods.

Steps to Adjust a QuickBooks Online Reconciliation

QuickBooks Online allows users to rectify issues that impact the reconciliation. Follow these steps to perform a QuickBooks Online reconciliation adjustment and rectify the error successfully:

Check the Reconciliation Report

Check the reconciliation report to locate the transaction that triggered the discrepancy. Follow these steps to review the report:

1. Navigate to the “Reports” option.
2. Look for the “Reconciliation Reports” option.
3. Choose the appropriate reconciliation period and account.
4. Check the transactions for wrong amounts, dates, repeated entries, or inaccurate reconciliation status.

Use Reconciled Entries

Access the account register to locate the entries that require rectification. Follow the steps to access reconciled entries:

1. Navigate to the “Accounting” option.
2. Choose the “Chart of Accounts” option.
3. Locate the reconciled account.
4. Choose the “View Register” option.
5. Locate the impacted transaction.
6. Review the “Reconcile” column to check the reconciliation status.

Modify Transaction Information

Adjust the transaction in case of a wrong amount, inaccurate date, or payee. Follow these steps to edit the transaction information:

1. Choose the transaction.
2. Choose the “Edit” button.
3. Update the needed information.
4. Choose the “Save” button.
5. Check the account balance and reconciliation position.

Modify the Reconciliation Status

Modify the reconciliation status when the transaction has the wrong status. Follow these steps to change the reconciliation status:

1. Access the transaction available in the account register.
2. Choose the “R” status available in the “Reconcile” column.
3. Modify the status to blank.
4. Go back to the “Reconcile” page.
5. Choose the transaction while reconciling.
6. Finish the reconciliation.

Repeat Account Reconciliation

Repeat account reconciliation if the rectification modifies the reconciliation balance. Follow these steps to reconcile the account again:

1. Navigate to the “Bookkeeping” option.
2. Click the “Transaction” option.
3. Click the “Reconcile” button.
4. Choose the account.
5. Add the ending balance and ending date for the statement.
6. Check the transactions.
7. Finish the reconciliation when the balance reaches USD 0.00.

When to Adjust or Undo a Reconciliation?

QuickBooks Online offers two methods for rectifying reconciliation irregularities. Select the methods depending on the impacted period, number of issues, and existing supporting records.

Undo a Reconciliation

Undo a reconciliation when the current reconciliation includes multiple issues or needs transaction rectification. Follow these steps to undo a reconciliation:

1. Navigate to the “Settings” option.
2. Click the “Reconcile” option.
3. Choose the “History by account.”
4. Locate the reconciliation and choose the “undo” option.
5. Rectify the impacted entry.
6. Reconcile the account once more.

Adjusting Entry for a Reconciliation

Access a QuickBooks Online adjusting journal entry when the discrepancy is in different records. Record the discrepancy, available records, and the adjustment reason before proceeding.

1. Record the adjusting journal entry.
2. Choose the relevant offset account.
3. Choose the relevant offset account.
4. Include an informative memo.
5. Check the adjustment with the accountant and client.
6. Reconcile the account.

Top ways to make QuickBooks Online Reconciliation Easier

The reason for a QuickBooks Online reconciliation discrepancy is the unavailability of precise and on-time records. Here are the practices to make the process simple and identify issues promptly.

• Monthly Account Reconciliation

Reconcile every account monthly. Daily reconciliation helps you detect discrepancies quickly and prevents error accumulation.

• Prompt recording of Transactions

Record business entries in QuickBooks Online as they arise. On-time entries minimize unavailable entries and reconciliation backlogs.

• Check Accounts during the month.

Check account activity mid-month. Initial reviews can help you locate transaction issues prior to the reconciliation date.

• Access QuickBooks Training and Support

Access QuickBooks training resources and support materials to understand the reconciliation process. Correct training can help you prevent regular issues.

Key Tips to Prevent Future Reconciliation Irregularities

Use the following measures to minimize future QuickBooks Online reconciliation discrepancy issues:

• Assign a closing date– Fix a closing date once the reconciliation is complete. Choose the proper warning and password option.
• Update the closing date– Shift the closing date ahead for every reconciliation that is complete.
• Handle user permissions– Check user access for all. Provide every user only the authorization they require.
• Inform clients– Notify clients to refer to the accountant before the transaction is modified from finalized reconciliation periods.
• Check the Audit log– Check the QuickBooks Online Audit Log frequently. Look for modifications to reconcile entries.

Final Words

In this guide, the significance of QuickBooks Online reconciliation adjustment and the steps are shared. Implement the steps in the given order to adjust a reconciliation for precise records.

Still, if there is any query or doubt, feel free to talk to our team of QuickBooks experts. Call our QuickBooks support staff at call +1-800-974-3985 and resolve your query.

Frequently Asked Questions