A/R Aging does not reconcile to G/L balances.

SOLVED

I am trying to reconcile the A/R aging to my G/L and I can't get it to match, no matter what report I run.  It matched in November, so it has to be something that happened in December.  I have checked the G/L accounts and all of the transactions were generated by an AR batch.  I have tried running the aging report by year/period.  The A/R is split between two G/L accounts, Accounts Receivable and Customer Deposits.  Any suggestions on where to look for the issue is appreciated.  I am a new Sage user.

Parents
  • 0

    Hi

    Was their any prepayments done - check what the prepayment account is set to.(is this your deposits)

    Could a new account set have been created and attached to a different debtors account and customers attached to it?

    Does it still match in November?

    Look for any deleted AR Batches?

    Make Sure all batches are posted.

    Good luck

    Stacey

  • 0 in reply to S Orrock

    The deposits account is what we use for prepayments.  There aren't any new account sets for the month.  It does match for November and it is out the same amount in January as it is in December.  Is it possible to delete an A/R batch and it only effect the A/R and not the G/L?  All batches are posted.

    Thanks for your help!

Reply
  • 0 in reply to S Orrock

    The deposits account is what we use for prepayments.  There aren't any new account sets for the month.  It does match for November and it is out the same amount in January as it is in December.  Is it possible to delete an A/R batch and it only effect the A/R and not the G/L?  All batches are posted.

    Thanks for your help!

Children
No Data