RECONCILE NLBAL AND NLTXDH

[Southerndiva]

Can anyone advise how you nreconcile the nlbal file - period balances - with the nltxdh file - transactions detail history.
my year end edit list is out of balance.
thanks.

 

[ceej]

This is always a fun problem to track down.

It's possible that one of your profit/loss accounts have been setup with an incorrect account type. Or maybe the system got screwed up in posting.

The fast way is to have an Trial Balance FRx report which has the detail included. At the bottom of the report there will be a message stating the detail & the balances don't equal. How to create this report is out of scope of an email.

The slow way is to:

Print a general ledger report to the queue manager which only includes the profit and loss accounts. Print one for each month. Compare the report total to the income summary/current earnings account. Once you find the month which is throwing it off, I've had to compare the g/l detail with an FRx summary trial balance. Next you have to edit the NLBAL account.

Hope this helps,

C.J. Kaufman

http://www.dayspringenterprises.com

 

[Southerndiva]

Thanks, I'll try this and advise you of the result. Seems like a lot of work. But I knew there must be a method to the madness. Thanks again.