How to Reconcile an Account in QuickBooks Online: A Step-by-Step Guide
Reconciling accounts in QuickBooks Online is an essential process that ensures your financial records are accurate by comparing them with bank and credit card statements. Regular reconciliation helps you catch discrepancies, locate missing transactions, and identify errors like duplicate entries. This guide will walk you through the steps to reconcile your accounts and provide answers to frequently asked questions (FAQs) to address common concerns.
We have a team of QuickBooks experts who are available 24/7 to assist you. Just call our support line at +1–888–858–6199.
What Does It Mean to Reconcile an Account in QuickBooks Online?
Reconciling an account means matching the transactions in QuickBooks Online with those on your bank or credit card statement. During reconciliation, you confirm that all transactions (deposits, withdrawals, checks, payments, etc.) recorded in QuickBooks align with the bank’s records. This process helps ensure the accuracy of your financial data.
Why Is Reconciliation Important?
- Accuracy: Reconciliation ensures that your financial records are correct and up to date.
- Fraud Detection: By regularly comparing your records with bank statements, you can detect any unauthorized transactions or discrepancies early.
- Tax Compliance: Accurate financial data is essential for preparing and filing taxes.
- Cash Flow Management: Knowing your exact balance helps you manage your cash flow effectively.
How to Reconcile an Account in QuickBooks Online
Follow these steps to reconcile your accounts in QuickBooks Online:
Step 1: Prepare for Reconciliation
Before you start reconciling, make sure you have everything in place:
Gather Your Bank or Credit Card Statement:
- You’ll need your latest bank or credit card statement. This includes details like the opening balance, ending balance, and the transactions during the statement period.
Ensure All Transactions Are Entered in QuickBooks:
- Make sure that all transactions (checks, deposits, payments, etc.) have been recorded in QuickBooks for the period you’re reconciling.
Review Opening Balance:
- Check that the opening balance in QuickBooks matches the opening balance on your bank statement. If they don’t match, you’ll need to investigate why, often due to previously unreconciled transactions.
Step 2: Start the Reconciliation Process
-
Go to the Reconcile Page:
- In QuickBooks Online, click the Settings gear icon in the top right corner.
- Under Tools, select Reconcile.
-
Select the Account to Reconcile:
- From the drop-down menu, choose the bank or credit card account you want to reconcile.
-
Enter the Statement Information:
- Enter the Ending Balance from your bank or credit card statement.
- Enter the Statement Ending Date as shown on the statement.
- If your bank statement shows any service charges or interest earned, enter them as well.
-
Click Start Reconciling:
- Once you’ve entered the required information, click Start reconciling to move to the next screen.
Step 3: Match Transactions
Compare Transactions:
- In the reconciliation window, you’ll see a list of transactions from QuickBooks that match the transactions on your bank or credit card statement.
- Compare the transactions listed in QuickBooks to those on your statement.
Mark Cleared Transactions:
- As you compare transactions, mark the ones that have cleared the bank by checking the box next to each transaction. A cleared transaction means it appears on your bank statement.
Unmark Incorrect or Missing Transactions:
- If you find a transaction in QuickBooks that doesn’t match your statement, leave it unchecked.
- If a transaction appears on your bank statement but not in QuickBooks, you may need to enter it manually. Double-check for duplicate entries, and delete any duplicates.
Check the Difference:
- At the bottom of the reconciliation screen, QuickBooks will show the Difference between the cleared transactions in QuickBooks and your statement.
- The goal is to have a $0.00 difference, meaning the transactions in QuickBooks match your statement perfectly.
Step 4: Fix Discrepancies (If Necessary)
Identify Missing or Extra Transactions:
- If the difference isn’t zero, look for any missing or extra transactions that could cause the discrepancy.
Enter Missing Transactions:
- If there are missing transactions on QuickBooks, enter them by going to the + New button and recording the transaction.
Review Previously Reconciled Transactions:
- Sometimes discrepancies arise from changes made to previously reconciled transactions. If necessary, review and correct any past reconciliations.
Revisit the Opening Balance:
- If your opening balance is incorrect, it could be due to a missing or deleted transaction from a previous reconciliation. You can adjust this by investigating and fixing the opening balance.
Step 5: Finish the Reconciliation
Review the Reconciliation Summary:
- Once the difference is zero, review your reconciliation summary to ensure everything matches correctly.
Click Finish Now:
- After confirming everything is accurate, click Finish now to complete the reconciliation process.
Save a Copy of Your Reconciliation Report:
- After reconciling, you can view and save a copy of the reconciliation report for your records. This is especially useful for auditing and tax purposes
Common Issues When Reconciling in QuickBooks Online
Transactions Don’t Match:
- Double-check the dates of transactions and ensure that all transactions from your statement period have been entered in QuickBooks.
Bank Statement and QuickBooks Balances Don’t Match:
- This issue often occurs due to missing or duplicate transactions, or because a previously reconciled transaction was modified.
Incorrect Opening Balance:
- This may occur if a transaction from a previous period was deleted or altered. Correct the opening balance to resolve the discrepancy.
Frequently Asked Questions (FAQs)
It’s a good practice to reconcile your accounts every month, as soon as you receive your bank or credit card statement. Monthly reconciliation helps you stay on top of your financial transactions and identify any discrepancies or fraudulent activity early.
If your balances don’t match, follow these steps:
- Ensure all transactions for the period are entered in QuickBooks.
- Look for duplicate or missing transactions.
- Review past reconciliations to check if any reconciled transactions were altered or deleted.
- Check the opening balance to ensure it matches your previous statement.
Yes, you can undo a reconciliation, but only accountants or users with special permissions can do so directly. If you’re not an accountant, you’ll need to manually unreconcile each transaction by editing it individually and unchecking the reconciled status.
Skipping reconciliations can lead to inaccurate financial records and missed transactions. If you fall behind, it’s essential to go back and reconcile each month individually to ensure all transactions are accurate.
If you find an error after reconciliation, you can go back and edit the transaction. However, this may affect the reconciliation, and you might need to reconcile again or adjust the opening balance. It’s recommended to make any corrections as soon as you spot the error.
In QuickBooks Online, reconciled transactions will have an “R” (reconciled) status in the Reconcile column of the account register. You can also view reconciliation reports to see a summary of reconciled transactions.
A cleared transaction is one that has been processed by the bank but may not yet be reconciled. A reconciled transaction is one that has been reviewed, matched with the bank statement, and confirmed during the reconciliation process.
QuickBooks Online is designed for business accounting, but you can reconcile personal accounts if you track personal finances in the software. The reconciliation process is the same for personal accounts.
To ensure accurate reconciliation:
- Regularly update your QuickBooks transactions.
- Review and compare bank statements and QuickBooks data carefully.
- Fix any discrepancies immediately after identifying them.
- Back up your QuickBooks data before starting a reconciliation.
After completing the reconciliation, go to the Reports menu, search for Reconciliation Reports, and select the account and reconciliation period. From there, you can view, print, or save the report for your records.
Conclusion
Reconciling accounts in QuickBooks Online is crucial for maintaining accurate financial records. By regularly matching your QuickBooks transactions with your bank or credit card statements, you can prevent errors, detect fraud, and ensure your business’s financial health. Follow the step-by-step instructions provided in this guide to reconcile your accounts easily and accurately.
