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

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
RMH2022
Level 1

How can I correct a negative cash balance from a different year?

Hello All, 

 

I need help with correcting a negative cash balance in my QuickBooks from 2023. It occurred from fraudulent activity from a "client". I have been trying to locate information on how to make the proper transactions to remove the negative balance, but have been unsuccessful. I will leave as much detail as I can below that is relevant to making the accounting corrections. 

 

I received pre-payment for services in the amount of $1,650.00 from a "new client". I deposited the check into my business account and withdrew the funds in an owner draw.  Before I spent any of the funds, I detected that the request was part of a scam. I notified the proper entities of the fraud and upon request from my bank, I deposited the funds back into my business account so the bank could execute their protocol for fraud behavior. Part of that is recouping the funds and sending back to the original location. 

 

In doing so, this left a negative cash balance in my QuickBooks of $1,650.00. I have not been able to figure out how to get this to show $0.00. My accountant at the time was not aware of how to make the correction in the system either, so this was locked in for 2023. I appreciate any help in figuring out how to get this zeroed out and hopefully not messing up reports/numbers for this year or last. I attached screenshots from my QuickBooks in hopes that this will help seeing the order of events. 

 

Sincerely, 

Rachel H.,  a.k.a. Up A Stream

Solved
Best answer January 31, 2025

Best Answers
Rainflurry
Level 15

How can I correct a negative cash balance from a different year?

@RMH2022 

 

Got it.  The entry to clear this negative balance is a deposit to your Cash account.  Assign Uncategorized Expense to the deposit because that account was overstated from the previous year too.  Date the deposit in 2024 if you haven't closed the books yet or 2025 if you have.    

 

The reason Uncategorized Expense was overstated is because you assigned that account to both the personal withdrawal and to the transaction when the bank pulled back the funds whereas you only assigned an income account to the original deposit.  So, you recorded $1,650 in income and $3,300 in expenses (for a $1,650 loss) in the previous year for this $0 net transaction.

View solution in original post

DS127
Level 5

How can I correct a negative cash balance from a different year?

I would just add that, as an accountant here, we do NOT want to see "Uncategorized Expenses" used.  Every expense needs a category. Before your books are done each year, look at those "Uncategorized" categories and get everything out of there.

 

Post the amount in the current (unclosed year, 2024 I am assuming) and charge it to something like "misc expense" if you don't have another place to put it.  

View solution in original post

6 Comments 6
EvethC
QuickBooks Team

How can I correct a negative cash balance from a different year?

I appreciate the screenshot you've shared and the complete details about your concern, RMH2022. Dealing with a negative cash balance from a past year due to fraudulent activity can be challenging; Rest assured, I'm here to help you out.

 

To start, I recommend checking the transaction history in QuickBooks to pinpoint the entries that led to the negative balance. This can be accomplished by looking at the account register associated with the transactions of the year 2023.

 

After identifying the incorrect transaction, create a bank deposit entry dated 2024 for the amount of $1,650:

 

  1. Select + New.
  2. Under Other, select Bank Deposit.
  3. Select the payment and the Journal Entry you created.
  4. The total should be zero.
  5. Select Save and Close.

 

Once done, create an adjusting entry in your current accounting period. This entry should include a memo stating that this adjustment is to correct the negative $1,650 balance from 2023.

 

Nevertheless, it might be beneficial to consult with a qualified accounting professional or reach out to a QuickBooks Live Expert Assisted service. They can review your entries to guarantee the accuracy of your financial records.

 

Additionally, you can check out this article to learn how to change your closing date and password: Edit your closed books in QuickBooks Online.

 

If you require further assistance in correcting your negative transactions, please feel free to reach out in the Community space. We are here to support you around the clock.

Rainflurry
Level 15

How can I correct a negative cash balance from a different year?

@RMH2022 

 

Obviously you cannot follow the advice given by @EvethC .  If you do, you will make changes to your closed 2023 books.

 

It's hard to tell based on your screenshot because it doesn't show exactly what accounts are being hit.  You will need to post a screenshots of each of the four transactions shown.  If you can click on the links after 'Added to:' (Deposit 04/27/2023, for example) and post screenshots of all four transactions, we can get this fixed in no time.  Ultimately, you will need to create a deposit dated in 2024 for $1,650.  The screenshots will determine what account to assign to the deposit because that account is also off by $1,650.  Double-entry accounting always affects two accounts.      

DS127
Level 5

How can I correct a negative cash balance from a different year?

Rainflurry is right from an accounting perspective. Once tax returns are complete using the data in QBO, you do NOT want to make any entries to those books, because if you do, the trial balance will no longer match the tax return.  Make any entries using an early January date (of the next year) and be sure to memo.  We always password protect/close the books for our clients to make sure they don't touch those closed books.

RMH2022
Level 1

How can I correct a negative cash balance from a different year?

Rainflurry - 

 

I hope the screenshot is decent. It would only let me upload 1 image. =/ 

Thank you for your reply and willingness to help! 

Rainflurry
Level 15

How can I correct a negative cash balance from a different year?

@RMH2022 

 

Got it.  The entry to clear this negative balance is a deposit to your Cash account.  Assign Uncategorized Expense to the deposit because that account was overstated from the previous year too.  Date the deposit in 2024 if you haven't closed the books yet or 2025 if you have.    

 

The reason Uncategorized Expense was overstated is because you assigned that account to both the personal withdrawal and to the transaction when the bank pulled back the funds whereas you only assigned an income account to the original deposit.  So, you recorded $1,650 in income and $3,300 in expenses (for a $1,650 loss) in the previous year for this $0 net transaction.

DS127
Level 5

How can I correct a negative cash balance from a different year?

I would just add that, as an accountant here, we do NOT want to see "Uncategorized Expenses" used.  Every expense needs a category. Before your books are done each year, look at those "Uncategorized" categories and get everything out of there.

 

Post the amount in the current (unclosed year, 2024 I am assuming) and charge it to something like "misc expense" if you don't have another place to put it.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us