cancel
Showing results for 
Search instead for 
Did you mean: 
blueberry123
Level 2

How can I reconcile different amounts from the bank statement and from quickbooks online?

I really need someone who can help me with my dilemma because I've been stuck with this for how many weeks now. So here it goes..

 

I'm almost done reconciling this particular month. However, there's only one transaction left that I'm confused about. It's a deposit transaction with 'split' on the account column amounting to 5,100.00. But it appears in the bank statement as 2,550.00. When I click 'edit', it directs me to the bank deposit window and it showed me the 2.550.00 transaction which is the same with the bank statement. 

 

How can I reconcile them? This is the only transaction left for this certain month and I cannot move on to the next. I've been reading articles and tutorials but I'm still confused. Please help. :(

 

Thank you so much for your kind assistance. 

8 Comments
Kiala_S
QuickBooks Team

How can I reconcile different amounts from the bank statement and from quickbooks online?

Hello @blueberry123! Thank you for reaching out to the Community for help on this issue. We are always more than happy to help:)

We always say that the bank statement is the source of truth, so if the amount is recorded incorrectly or showing the wrong amount within Quickbooks, we can definitely make it right again. I do wonder, because it is split, if the same bank account was used on the other split amount? Using two asset accounts on a transaction such as this can sometimes cause things to look unusual. Feel free to provide a screenshot of that transaction and I am more than happy to take a look.

Another option would be to simply delete that split transaction and then re-enter that Bank Deposit fresh and with the right amount recorded. I will happily walk you through how to accomplish this.
 

  • Within the Reconciliation screen, click on the transaction and choose Edit
  • Once opened, click More along the bottom of the screen
  • Then select Delete

After that has been deleted we will want to re-enter that bank deposit.

 

  • Click on +New in the upper left hand corner in your account
  • Underneath Other choose Bank Deposit
  • Enter in the correct amount, choose the Account, and the date
  • Next to the Save and New button along the bottom is a dropdown arrow
  • Choose Save and Close

Please feel free to reach back out with any updates on this fix. Would love to hear you are now officially reconciled and can move on to another month. Have a great rest of your day ! 

blueberry123
Level 2

How can I reconcile different amounts from the bank statement and from quickbooks online?

Hi! Thank you for you response. :)

 

Attaching herewith the screenshot for your reference.

 

What would be the best way to solve my dilemma? 

 

Thank you for your usual kind assistance! :)

 

blueberry123
Level 2

How can I reconcile different amounts from the bank statement and from quickbooks online?

Hi, @Kiala_S , sent the screenshot. Have you seen it? Thanks! :)

Nick_M
QuickBooks Team

How can I reconcile different amounts from the bank statement and from quickbooks online?

Hi there, blueberry123. 

 

Thanks for dropping by the Community this evening, based off of your screenshot provided (which was very helpful) I believe you may have included an additional transaction or transactions that made that deposit $5100. I suggest checking the Chart of Accounts to see if you may have accidentally added the deposit. To do so, follow these steps:

 

1.    Go to Accounting and select Chart of Accounts.
2.    Choose the bank name where the deposit is located and click View register.
3.    Select the deposit and click Edit.
4.    On the Bank Deposit screen, scroll down to Add funds to this deposit.
5.    Change the Account to Accounts Receivable (A/R).
6.    Click Save and close.

If you have any other questions, feel free to reply again down below, We'll respond as soon as possible. Thank you for your time and have a nice evening. 

blueberry123
Level 2

How can I reconcile different amounts from the bank statement and from quickbooks online?

I can't edit it though. I don't think I can also delete it and make a new one. Please see screenshot I attached.

Please help me with this. I really need to reconcile this asap. :(

 

Thank you so much.

Joesem M
QuickBooks Team

How can I reconcile different amounts from the bank statement and from quickbooks online?

Hello there, @blueberry123.

 

I understand the importance to get your account reconciled in QuickBooks and appreciate you for following the steps shared by my colleagues to get this sorted out.

 

Let's do some browser troubleshooting steps to get rid of any cache-related issues. Piled-up cache files can sometimes cause display issues in QuickBooks Online.

 

To start, let's log in to your account via a private browser and perform the steps shared by my colleague Nick_M to edit the deposit. 

 

To open a private or incognito window, you can follow these keyboard shortcuts:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P 

If you're able to edit the deposit, then you'll need to clear your browser cache. You can also use another browser as an alternative.

 

 Also, if you can void the payments, I'd suggest voiding it to. This way, you can recreate the transaction properly in QuickBooks.

 

Upon sharing this suggestion, I still recommend consulting with an accountant first before making any changes to your account. They might have specific instructions on how to handle these transactions to ensure your book is accurate.

 

Let me share these articles for more details about reconciliation:

 

 

Please don't hesitate to reach back out to me if there's anything else you need. I want to ensure that everything has been taking care of. I'm always here to help. Have a good one! 

blueberry123
Level 2

How can I reconcile different amounts from the bank statement and from quickbooks online?

Thank you so much for your help y'all. :) I reconciled it. Finally. :)

Kiala_S
QuickBooks Team

How can I reconcile different amounts from the bank statement and from quickbooks online?

Good morning, @blueberry123 ! A big thank you to @Nick_M and @Joesem M for jumping in to help. So glad we were able to come together and get to a solution for you. If one of the answers above helped, feel free to mark it as the solution so others can get the help if they are experiencing a similar issue. Have a wonderful week everyone:)

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us