cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
NW - DS2
Level 1

Writing off AR on Accrual Basis only

The business keeps it books and records on the cash basis.  When downloading banking activity for the prior 2 years, the bookkeeper did not attempt to match deposits against existing AR.  So, at the end of each year, income is reported for cash basis, and income is also recognized on the accrual basis as cash received while also having recognized as income when the original AR was recorded. 

 

So, on the accrual basis, income/retained earnings is overstated, as well as the current AR balance. 

 

The business now wants to clear all of the AR out, and correct the accrual based retained earnings so they can run an accrual based P&L for potential lenders.

 

We have tried issuing credit memo's (bad debt expense) to record payment against the AR, but this results in an adjustment to bad debt and the recognition of income on the cash basis statements - now overstating gross income (although it has a corresponding bad debt expense). 

 

We tried to set up the credit memo noninventory item as a retained earnings adjustment, rather than as bad debt expense,  but then it adjusted our Cash Basis retained earnings as well.

 

We even toggled the company's accounting method to Accrual, and then tried the adjustments above to see if the AR/Retained Earnings offset would only be applied to the Accrual basis books, but it still showed up as a cash basis adjustment to Retained Earnings.

 

How do we clear out AR that has already been closed out into the Accrual-based retained earnings, without affecting Cash-based retained earnings, income or expense?

 

 

3 Comments 3
Rustler
Level 15

Writing off AR on Accrual Basis only

QB is accrual accounting, it only reports on a "modified" cash basis. Everything you do is accrual, and only reported as cash basis if there is no a/r or a/p involved.


... and income is also recognized on the accrual basis as cash received while also having recognized as income when the original AR was recorded.

 

No it is not, income in accrual is recorded when the invoice is saved. In accrual when it is paid does not affect the reporting for the P&L. In cash basis the recording of the invoice is not reported on the P&L and is only reported when paid.

 

There should be a warning in QBO to start the books without adding prior years data.

 

.... but this results in an adjustment to bad debt and the recognition of income on the cash basis statements - now overstating gross income (although it has a corresponding bad debt expense).

This would appear to be the only thing that will work. Income is reduced by expense on the P&L, an increase in income offset by the same amount as an expense makes no change to the net profit, the taxable amount

 

NW - DS2
Level 1

Writing off AR on Accrual Basis only

"and income is also recognized on the accrual basis as cash received while also having recognized as income when the original AR was recorded."

 

Does this mean that if a deposit comes in and gets coded directly to sales, rather than against an existing invoice, it is not included in Sales on accrual based P&L?  That would be great!

 

 

 

 

 

 

NW - DS2
Level 1

Writing off AR on Accrual Basis only

Just to clarify my previous reply:

 

The bookkeeper linked the bank with QBO cash account.  She only applied some of the downloaded deposits against existing outstanding invoices (already included in accrual basis income)

 

The deposits that weren't applied against A/R were instead coded directly to the sales account.  I think that you are saying that these deposits would not have been included in accrual basis P&L, correct?

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us