AR and Unpaid Customer Invoice amounts don't balance, and I can't start my new year!

I can't start my new year because they don't balance! I don't know where to look, or how to add in a temp fix so I can move forward. I have an accounting firm go through my books at the end of every year, and I generally just make the changes and additions they tell me to... This is the first year I've had issues, but I NEED to get my new year started now...!

  • 0

    SammyCastlebury said:
    I have an accounting firm go through my books at the end of every year, and I generally just make the changes and additions they tell me to...

    Are they in balance when you check under Maintenance | Check Data Integrity?

    Did they give you any adjustments to Accounts Receivable?  

    If you temporarily restore a copy of the books as they were before you sent them to the accounting firm, are they in balance under Maintenance | Check Data Integrity?

  • 0 in reply to RandyW
    No, I found the 'unbalance' under Data Integrity. They don't actually make changes with the system - they go thorugh the data then send me any journals I need to enter in order to make the books correct. The balance was off before I added their journals.
  • 0 in reply to SammyCastlebury
    Did the accountants give you any direction as to where the problem was?

    I believe there is a process documented in a knowledgebase article on how to unlink the A/R temporarily in order to record adjustments into the G/L, or search for 'unlink' to find articles like this one:

    sagecity.na.sage.com/.../176130

    If the sub-ledger to G/L was once in balance and now isn't, possibly due to some data corruption or damage, then you may need to contact Sage software.

    If it's not in balance because setup is not yet finished, and the module is still in 'history' mode, then it's just a matter of correcting any opening balances or from the start of the year.