Sage 100

Cash Account Really Off The bank says the customer has say $35,000 in bank. Sage 100 GL Cash Account shows a -$27,000, that's a negative $27,000. A swing of $61,000. We have gone through all the GL, AR and AP Detail and Posting reports, Trial Balances, General Ledger entries and uncashed checks looking for Out of Balances or anything out of the ordinary. Nothing. Does anyone have any ideas on what I could have missed or have a fresh approach to the problem? Its such a large number you would think it easy to find.

Did you rebuild the BR files and sorts? I always do that first with BR issues.

Yes we rebuilt the sort files for every module.

Rebuild key files for BR and then sorts. This fixed an issue I was having with a customer yesterday.

A few ideas: - When was the last bank reconciliation and is there a copy? - Reconcile this on paper before tackling the BR - the immediate urgency is to know whether you have a ""true"" cash balance problem - Verify that the bank has not made a mistake by looking at their transactions online (if possible).

Were any of the cash accounts merged or renumbered?

Did you recalc account balances - both in BR and GL?

Had no contact with the customer over the weekend. Thanks for all the suggestions. Will try your suggestions from beginning agin today