cancel
Showing results for 
Search instead for 
Did you mean: 
userpvsdls
Level 1

I am taking over QB Online for a new client. I want all dates to start from 1/1/2021. The client populated customer deposits he received in Dec 2020

The deposits that he populated are throwing off the QB "bank" balance to the real bank balance. I want my ending/beginning real bank balance to be the amount ended on 12/31/2020 so January reconciles correctly. And off course my QB "bank" balance to match the real Bank balance. How do I eliminate the customers deposit/payments in Dec 2020 without deleting the record of their invoice/payment?
3 Comments 3
MadelynC
Moderator

I am taking over QB Online for a new client. I want all dates to start from 1/1/2021. The client populated customer deposits he received in Dec 2020

Thanks for reaching out in the Community, @userpvsdls.


In QuickBooks Online, you can create a journal entry to settle those entries and balance the amounts. This way, the first month of the year reconciles correctly. Here’s how:

 

  1. Select the + New button.
  2. Click Journal entry.
  3. Select the accounts affected.
  4. Enter information in the memo section so you know why you made the journal entry.
  5. Hit Save and close.

For your future reference, here’s a detailed guide to reconcile accounts in QuickBooks. It includes articles that make sure everything matches and accurate.


Stay in touch if you have other QuickBooks concerns. I’m always here, ready to help. Have a good rest.

userpvsdls
Level 1

I am taking over QB Online for a new client. I want all dates to start from 1/1/2021. The client populated customer deposits he received in Dec 2020

Thank you for the response. I thought about that while I was eating dinner tonight. So I made an adjustment to my checking register. That worked to adjust my QB Bank Balance so I am on the right track there. What I did scew up is my reconciliation. I reconciled January. I was go to go. Then with screwing around with the QB Bank Balance earlier before I even posted my original question. I deleted my Opening Balance Equity, which I previously edited, that was way back in 2019. And now my reconciliation is off by that amount, in this case $1572.20. 

 

My client has had QB Online since 2019 but has dabbled in it here and there, not knowing what they were doing and that is why I didn't start with a clean QB Online account for them. So now I'm doing clean up, but messing myself up in the process. I tried to recreate the Deposit of the Opening Balance Equity, but all that did was increase my checking account balance by the $1572.20, hence making my adjustment greater but still having my reconciliation off by $1572.20. Any thoughts to help me fix that?

Rasa-LilaM
QuickBooks Team

I am taking over QB Online for a new client. I want all dates to start from 1/1/2021. The client populated customer deposits he received in Dec 2020

Thanks for adding details about your concern, userpvsdls.


We’ll have to change the deposit date to 2020 if this is a single transaction. Then, delete it to clear the $1572.20 balance.


Here’s how:

 

  1. Open the invoice you’re working on.
  2. Choose 1 payment made under the Paid status and hit the date link to open the Receive Payment page.
  3. Enter the correct date in the field box.
  4. Uncheck the box next to the invoice.
  5. Hit the Clear Payment button.
  6. Tap Save and close.
  7. Then, Yes to confirm the action.

 

You can bookmark these links for future reference. These resources outline the complete steps on how to resolve reconciliation problems in QBO.

 

 

Keep me posted if you need still need help with QuickBooks. The Community and I are always ready to assists further. Have a good one.

Need to get in touch?

Contact us