Balance Sheet doesn't balance

Forum|Forum|4 years ago
February 7, 2022
1 reply
1 view

I deleted a duplicate credit memo and now my balance sheet doesn't balance. I called QB Support and the girl told me she wouldn't tell me how to set up a non-posting account in the Chart of Accounts unless I upgrade to QB 2022 and get full support. I have QB Desktop Pro 2021 and we have other software programs tied into our QB - we can't just 'upgrade'. I offered to pay for support for this issue and she said she'd send me an email which told me nothing and then we got disconnected.

QuickBooks Desktop

Rainflurry

Level 11

@Lala57

Deleting a credit memo, by itself, should not cause the balance sheet to not balance as credit memos always have a debit entry (user assigned) and a credit entry (always A/R). I have never seen a balance sheet in QB Desktop not balance. Any chance you can post a screenshot or give more details?

Lala57Author

I know - you think this would be impossible. The CM was a Cr. to AR for $6,088 and an Dr. to sales. There ended up being 2 of these CM's on Nov 2nd 2021. So I deleted one of them. When I pull up a Balance Sheet on the cash basis on Nov 1st, it balances. When I pull it up on Nov 2nd, the total assets are $6,088 less than the total Liab & Equity, I verified that the customer the CM went to is all ok, and I even tried rebuilding the file.

When I pull up a Balance Sheet on the Accrual Basis, it balances.

Lala57Author

I FIXED IT!!! Thankfully the customer this affected didn't have too many transactions. I printed out each transaction this customer had. Then I deleted each and every transaction for this customer, and then deleted the customer. I then added the customer as a new customer and re-input all the transactions (had all the printed copies of each transaction) and now the Balance Sheet balances.

By deleting that credit memo, it must have somehow corrupted that customer!

Sign up

Login with SSO

Let's get you signed in

Login with SSO