✦Template Printable Ideas Insights

How to Correct Bank Balances in QuickBooks Desktop

By

Have you recently discovered discrepancies in your bank balance within QuickBooks Desktop? Don't let these errors cause sleepless nights - we understand how crucial it is for your financial records to be accurate. We'll guide you through a step-by-step process to help you correct your bank balance, ensuring your books reflect a true and fair view of your business' finances.

But before we delve into troubleshooting, bear in mind that incorrect bank balances typically result from reconciliation issues, unrecorded transactions, or manual data entry errors. The process to rectify this often involves reconciling your accounts, delving into both bank and credit card transactions, and potentially adjusting entries. Let's address these issues one by one.

Understanding Bank Reconciliation in QuickBooks

Reconciliation is an essential bookkeeping process that ensures your records match your bank statement. It's the first port of call when dealing with bank balance discrepancies. Let's understand the QuickBooks reconciliation process.

How to Fix the Opening Balance in your Bank Reconciliation
How to Fix the Opening Balance in your Bank Reconciliation
How to Reconcile Bank Statement in QuickBooks Desktop
How to Reconcile Bank Statement in QuickBooks Desktop
Uncleared Bank Transactions Report in QuickBooks Online
Uncleared Bank Transactions Report in QuickBooks Online

To reconcile your bank account in QuickBooks Desktop, follow these steps:

  • Access the reconcile screen: Assume the cursor is in the transaction you are reconciling, and go to Accounting, Make Deposits or Pay Bills, choose Reconcile Now.
  • Verify and adjust your reconciliation: Ensure the beginning balance, ending balance, and statement date are correct. Make any necessary adjustments. Also, review and match your transactions.
  • Review and create a reconciliation report: Once done, review the report and at your satisfaction, accept the reconciliation and print the report for your records.

Common Reconciliation Issues and Solutions

Some common issues during bank reconciliation include transactions listed on your bank statement that are not present in QuickBooks, and vice versa. The following steps can help resolve such issues:

QuickBooks Training - Reconcile Bank Account to Bank Statement
QuickBooks Training - Reconcile Bank Account to Bank Statement
How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
Paying & Reimbursing Yourself in QuickBooks
Paying & Reimbursing Yourself in QuickBooks

To find transactions in QuickBooks not on your bank statement, review your register for any transactions listed as "Cleared" or "Deposited" or use the Transaction List Report. Conversely, unrecorded transactions on your bank statement can be entered manually using the Make Deposits or Pay Bills features.

Reviewing Your Bank and Credit Card Transactions

It's worth reviewing both your bank and credit card transactions thoroughly. For any discrepancies, you might need to manually record them using the appropriate commands. Ensure you enter the correct date, amount, and narration to prevent any further issues.

Additionally, double-check your transactions for any duplicate entries or slight differences that might cause your balance to be off. Remove any duplicates, and adjust if necessary.

Fixing Bank Reconciliation Discrepancies in QuickBooks - Candus Kampfer
Fixing Bank Reconciliation Discrepancies in QuickBooks - Candus Kampfer
How to Apply Finance Charges in QuickBooks
How to Apply Finance Charges in QuickBooks
QuickBooks Desktop Finding Vendors PrePayments Balance
QuickBooks Desktop Finding Vendors PrePayments Balance
How To Manually Enter Banking Transactions In QuickBooks Online 2016
How To Manually Enter Banking Transactions In QuickBooks Online 2016
Bank Reconciliation Template Excel & Google Sheets | Monthly Reconciliation Spreadsheet | Bookkeeping Dashboard
Bank Reconciliation Template Excel & Google Sheets | Monthly Reconciliation Spreadsheet | Bookkeeping Dashboard
Small business bookkeeping using QuickBooks online
Small business bookkeeping using QuickBooks online

Making Adjusting Entries to Correct Your Bank Balance

Often, the best way to correct your bank balance in QuickBooks is to make an "adjusting" entry. This entry will balance to the correct amount without changing the overall financial condition of your business. Here's how to do it:

Go to Accounting, Make General Journal Entries. Enter the date, and then in the Account column, enter the bank account. In the Debit column, enter the difference between your bank statement balance and your QuickBooks balance. In the Detail column, write "Adjusted bank balance". Click on Save …

Journal Review, How to Fix Bank Reconciliation Discrepancies, Beginning Balance Is Off in QuickBo...
Journal Review, How to Fix Bank Reconciliation Discrepancies, Beginning Balance Is Off in QuickBo...
bank balance enquiry chart
bank balance enquiry chart
How to Record a Bill in QuickBooks Online
How to Record a Bill in QuickBooks Online