I know of no particular tools. For us, it is old fashioned procedures,
procedures, procedures way to hunt for the problem. Run reports, use the
Account Trackers, compare. When discrepancies occurred, I use account
tracker and/or General Ledger reports back to the last reconciled period to
find the problem. Check invoice dates carefully on the tracker compared
to the G/L. Check the G/L detail for dates as well. Check invoice dates
compared to the Group Date. Is a Nov. 30 shipment managing to get invoiced
on Dec. 1 and yet still be in a November, 2000 Group? Calculate the amount
that you are out of balance - does that number jump out at you anywhere when
looking for the discrepancy?
If I am being too obvious, simplistic and redundant, please forgive me.
It's not fun to be out of balance. Feel free to give me a call if you wish.
Deb Wilmoth
Reeder & Kline Machine Company, Inc.
(317) 846-6591
-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Thursday, November 30, 2000 10:00 AM
To: vantage@egroups.com
Subject: [Vantage] reconcile a/r to g/l
Anyone have a tool to reconcile the total of the a/r aged trial balance to
the balance in the g/l accounts receivable account?
TIA
[Non-text portions of this message have been removed]
procedures, procedures way to hunt for the problem. Run reports, use the
Account Trackers, compare. When discrepancies occurred, I use account
tracker and/or General Ledger reports back to the last reconciled period to
find the problem. Check invoice dates carefully on the tracker compared
to the G/L. Check the G/L detail for dates as well. Check invoice dates
compared to the Group Date. Is a Nov. 30 shipment managing to get invoiced
on Dec. 1 and yet still be in a November, 2000 Group? Calculate the amount
that you are out of balance - does that number jump out at you anywhere when
looking for the discrepancy?
If I am being too obvious, simplistic and redundant, please forgive me.
It's not fun to be out of balance. Feel free to give me a call if you wish.
Deb Wilmoth
Reeder & Kline Machine Company, Inc.
(317) 846-6591
-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Thursday, November 30, 2000 10:00 AM
To: vantage@egroups.com
Subject: [Vantage] reconcile a/r to g/l
Anyone have a tool to reconcile the total of the a/r aged trial balance to
the balance in the g/l accounts receivable account?
TIA
[Non-text portions of this message have been removed]