Bank reconciliation in QuickBooks is a crucial process that helps you ensure the accuracy of your financial records by comparing your company’s records with those of your bank. Reconciliation is typically done on a monthly basis and helps identify any discrepancies or errors in your financial transactions. Here’s how to perform bank reconciliation in both QuickBooks Online and QuickBooks Desktop:
Bank Reconciliation in QuickBooks Online:
- Log In to QuickBooks Online:
- Open your web browser and log in to your QuickBooks Online account.
- Access Bank Reconciliation:
- In QuickBooks Online, go to the “Accounting” or “Banking” menu and select “Reconcile.”
- Select the Bank Account:
- Choose the bank account that you want to reconcile from the dropdown menu.
- Enter the Statement Information:
- Enter the statement date and ending balance from your bank statement.
- Compare Transactions:
- QuickBooks Online will display a list of transactions that have cleared your bank. Compare these transactions with the ones on your bank statement.
- Check off each transaction in QuickBooks Online that matches your bank statement. The goal is to reconcile all transactions.
- Review Unreconciled Transactions:
- If there are unreconciled transactions, investigate them to identify discrepancies. You may need to adjust transactions or add missing ones.
- Make Adjustments:
- If necessary, make adjustments for interest, bank fees, or other items not included on your bank statement.
- Finish Reconciliation:
- Once you’ve reconciled all transactions, QuickBooks Online will display a reconciliation summary. Review it to ensure everything matches your bank statement.
- Click “Finish Now” to complete the reconciliation.
Bank Reconciliation in QuickBooks Desktop:
- Launch QuickBooks Desktop:
- Open QuickBooks Desktop on your computer.
- Access Bank Reconciliation:
- Go to the “Banking” menu and select “Reconcile.”
- Select the Bank Account:
- Choose the bank account you want to reconcile from the dropdown menu.
- Enter the Statement Information:
- Enter the statement date and ending balance from your bank statement.
- Compare Transactions:
- QuickBooks Desktop will display a list of transactions that have cleared your bank. Compare these transactions with the ones on your bank statement.
- Check off each transaction in QuickBooks Desktop that matches your bank statement. The goal is to reconcile all transactions.
- Review Unreconciled Transactions:
- If there are unreconciled transactions, investigate them to identify discrepancies. You may need to adjust transactions or add missing ones.
- Make Adjustments:
- If necessary, make adjustments for interest, bank fees, or other items not included on your bank statement.
- Finish Reconciliation:
- Once you’ve reconciled all transactions, QuickBooks Desktop will display a reconciliation summary. Review it to ensure everything matches your bank statement.
- Click “Reconcile Now” to complete the reconciliation.
Simplify your financial management by outsourcing your accounts payable and accounts receivable tasks to our capable bookkeeper for small business.
Bank reconciliation is a critical step in maintaining accurate financial records and ensuring that your QuickBooks records align with your bank statements. It helps identify any errors, missing transactions, or fraudulent activities. Performing bank reconciliation regularly is essential for the financial health and integrity of your business.
