Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 11, 2020
Question

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

  • September 11, 2020
  • 8 replies
  • 35 views

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 replies

K_Siman
Level 1
September 11, 2020

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 ! 

September 11, 2020

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! :)