Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello All,
I am new to QB Online. I am trying to reconcile 3 months of bank statements to QB. I know that when done right, you will get $0.00. I am way way off of this figure and I am pulling my hair out! I have noticed that some, not all, of my deposits show in the credit column and debit column. I have gone through the steps but still must be doing something wrong. Help Please. I need someone to walk me through step by step to get the prize of $0.00
I've got your back, @snellagaviation. I'm here to make sure have your ending balance will have a difference of $0.00.
Here are the possible causes of ending balance issues:
To fix this, let's start by reviewing the opening and beginning balances. When it's already accurate, check the ending balance you entered. Make sure you recorded the correct amount. To verify, here's how:
If there's still a difference in QuickBooks, let's proceed to the next step. If your bank combined several payments as a single record, you should do the same in QuickBooks. If you notice you didn't combine the same payments in QuickBooks, put them into the Undeposited Funds account and then make a bank deposit.
If the issue persists, let's make sure you entered everything into QuickBooks. If your accounts are connected to online banking, review and categorize all of your downloaded transactions.
Once done, remove transactions that aren't on your bank statement. Let me show you how:
If a transaction in QuickBooks closely matches one on your bank statement but the amount is slightly off, reach out to your accountant. You shouldn't edit transactions, like invoices, that customers already paid for. On the other hand, check for added fees to transactions that weren't included when you entered them into QuickBooks.
Once your accounts are balanced, you can finish reconciling.
I've also added this to learn the reconcile workflow in QuickBooks.
Keep us posted if you still need help with your reconciliation. We're always ready to jump in and offer our help again. Have a wonderful day.
Hi, @snellagaviation.
Hope you’re doing great. I wanted to see how everything is going about the reconciliation concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.
Looking forward to your reply. Have a pleasant day ahead!
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.