I posted an adjustment batch in A/R but for some reason the adjustment is not being calculated on the A/R Aged Trial Balance (Calculated as of Sept 30/14). Our year end is Sept 30th so now my subledger report doesn't equal my control account - it's out by the amount of the adjustment. Is there a reason for this? And is there a fix for it?

Thanks,
Jean

What was the date of the adjustment transaction?

The date of the adjustment transaction was September 30/14.

Jean:

Which report are you running? Use Aged Trial Balance with Calculate as of.

I'm using the Aged Trial Balance, Calculated as of September 30/14.

...it doesn't make sense to me why it is not being included.

Do you allow the accounting date to be different from the document date? If so, are you doing the ATB by Accounting date or Document date?

If you look up the Customer's transactions, what is the date on the Adjustment you posted? In the general ledger, what period was that adjustment posted to?

It occurred to me that we never asked where the adjustment was posted.

We assumed that it was posted in Receivables. Is this correct?

Also, what was the offsetting account for the adjustment? A common mistake is to use the AR Control account as the offsetting side of the entry. This results in the Debit and Credit both going to the Receivables Control account and netting to $0.00.

I don't think we allow the accounting date to differ from the document date...not sure where to verify this but when I run the ATB I don't have the option to choose Calculate as of Accounting Date vs Document Date, so the date I'm running it is for September 30, 2014 which is the same date used for the adjustment. And looking in the AR control account I can see that it was posted to the correct period for September 2014. It just is not calculating into the ATB

Looking at the Adjustment transaction in Receivables I can confirm that I did not use the AR control account as the offsetting side to the transaction (I have done that before though, learned from my mistake).

Have you shown the data to your Adagio Consultant?

No...I was hoping you'd have come come across this issue before, that it was just a rogue tick-box somewhere that was affecting the report. It's not something that has ever caused a problem before and I use adjustment batches pretty rarely, so it probably won't ever cause an issue for us again.

The ATB just doesn't seem to include Adjustment batches...just Invoice & Cash batches.