Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowHello 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! Go to Solution.
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.
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.
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:
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.
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.
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.
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.
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.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here