Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there,
Potentially a silly question, apologies I'm pretty new to QuickBooks...I have reconciled my Q/B bank to statement however Trial Balance & Balance shows a totally difference balance?
Also, my other bank is out by 20k from prior year. Can I rectify this in current year. If so - how?
Many thanks
Thanks for sharing your concern on the QuickBooks Community page, @Godie.
I'd be glad to provide info on how to correct your account balance in QuickBooks Online.
The data shown in the Trial Balance report summarizes each account's debit and credit balances on your chart of accounts during a period of time. The balances reflected in this report depend on the data you've entered in QuickBooks.
To ensure it matches your actual bank, see to it that the beginning balance of your accounts and their transactions are matched with your bank statements.
To correct your accounts' balance for the current year, I'd suggest reviewing each reconciled period from your previous year. Use your last year's bank statement and compare it with the data you entered in QuickBooks.
Once you find the discrepancy, I'd suggest undoing your reconciled transactions from that period. Then, make any necessary corrections and reconcile them again in QuickBooks until you correct your current year. If you need to undo multiple transactions, look for an accountant with a QuickBooks Online Accountant account. They have tools that could streamline the process of correcting your reconciled accounts. They can also review your accounts to ensure they match your real-life bank and credit card statements.
For additional reference about correcting past reconciliations, use this resource as your guide: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Moreover, you can check our Reconciliation guide anytime you need help doing or fixing a reconciliation.
Please let me know if you have further questions about bank reconciliations. I'll be here to help you out. Have a good one.
Thanks so much Raymond
A quick one ...QuickBooks seem not to permit me to reverse a bank transfer...I need to realloce a bank transfer to a creditor payment. Any clue on how to resolve this?
I appreciate your follow-up, @Godie. Let me help you reverse a bank transfer and allocate it to a creditor payment in QuickBooks Online (QBO).
If you manually record a bank transfer, you can easily edit and reallocate it to the appropriate creditor. Here's how:
Nevertheless, if you record a bank transfer directly from the banking menu, you can easily click the Undo button to reverse the transfer. To do so, go to the Transactions menu, then click the Categorized section. Refer to the sample screenshot below for the process.
Moreover, it's important to categorize transactions downloaded from your bank or manually entered so they go into the right accounts. To speed up this review process, you may want to utilize the bank rules feature.
I'll be around if you have further questions about reversing a bank transfer or managing transactions in QuickBooks.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here