Problem with accrual vs. cash basis in an Income by Customer Summary in QB Desktop 2019

tmorse · ‎January 21, 2021

I am keeping the books for a friend's business. She had four customers last year (2020). All of them accrued charges during the year. Their invoices are dated 1/1/2020. All but one paid their charges in full during 2020. When I run an Income by Customer Summary for the business for the last fiscal year (January through December 2020), all the customers appear in the summary on an accrual basis, but the one with the outstanding balance drops out completely (i.e., none of their 2020 payments are included) if I change the summary to a cash basis. It seems to me that the payments this customer made in 2020 excluding the unpaid charge should show up in the 2020 summary on a cash basis, but none are included.

Am I missing something about the difference between cash and accrual basis? If not, can anyone suggest a solution to this conundrum?

Thank you,

Terry

tmorse · ‎January 22, 2021

Thank you for responding.

Verify Data found no errors. When I ran Rebuild Data, it found 19 errors that it couldn't fix. All 19 errors were "RealmInput: TokenHeaders for the user found to be NULL." QuickBooks Desktop File Doctor also couldn't fix the file.

HOWEVER, when I went back and looked at the payments in detail, I discovered that they had not been applied to the relevant invoice. Once I applied them to the invoice, the problem with the Income by Customer Summary was resolved.

If you can shed any light on the RealmInput error, I'd be interested in knowing what it means.

Terry

View solution in original post

JessT · ‎January 21, 2021

Hi Terry,

You'll want to check out the payments and make sure they are dated in 2020. If not, you can correct them. If they are dated correctly, but not showing on the report, you can run the Verify and Rebuild utilities. This checks for data issues and resolves them.

Feel free to share an update after checking or running the tools.

tmorse · ‎January 22, 2021

Thank you for responding.

Verify Data found no errors. When I ran Rebuild Data, it found 19 errors that it couldn't fix. All 19 errors were "RealmInput: TokenHeaders for the user found to be NULL." QuickBooks Desktop File Doctor also couldn't fix the file.

HOWEVER, when I went back and looked at the payments in detail, I discovered that they had not been applied to the relevant invoice. Once I applied them to the invoice, the problem with the Income by Customer Summary was resolved.

If you can shed any light on the RealmInput error, I'd be interested in knowing what it means.

Terry

JessT · ‎January 22, 2021

Thanks for the update, Terry!

If there are no issues detected when running Verify utility, there's no need to run the Rebuild utility. Else, you could get false positives like the RealmInput error. This is harmless and won't impact the use of QuickBooks in any way.

About the unlinked payments, just reselect the invoice to link it back to the invoice.

Please let me know how it goes.

tmorse · ‎January 22, 2021

I did that (relink the payments) right away, and it fixed the problem. I'm 99% certain they were linked when I first recorded them (every other customer's payments were properly linked), so something apparently unlinked that customer's payments. Regardless, the problem was easily fixed. In the meantime, I learned something about QuickBooks's utilities and simple things that can go wrong in the program, so it was time well-spent.

Terry

tmorse · ‎January 22, 2021

I did that (relink the payments) and it fixed the problem. I'm 99% certain they were properly linked when I recorded them (every other customer's payments were linked to the appropriate invoice), so it appears that, at some point, they became unlinked. Easily resolved, once I diagnosed the problem.

Terry

Topics

Training

Community

Resources

Problem with accrual vs. cash basis in an Income by Customer Summary in QB Desktop 2019