There could be various reasons

1/ GL Batches not posted

2/ GL Batches deleted from AP or AR

3/ GL Journals entered directly to the payables or receivables accounts

4/ Timing as you indicated if document dates and posting dates altered

5/ opening balances never balancing

You should reconcile these monthly then you will immediately know the cause.

The best way to resolve unfortunately is after checking the above you may need to go back to the period that last reconciled and work forward ticking and flicking the gl to the AP/AR as you go to identify the issue.

Good Luck

Stacey

Thank you Stacey,

1. All the batches are posted and non of the batches are deleted

2. No journal was passed directly in the GL to any of the control accounts

3. Posting date and document date is the same all through and nobody altered it

4. Opening balance are correct

1/  So if you go back and reconcile period by period, is there only one period that is out?

2/  Could someone have changed the control accounts part way through?

3/ Use the Periodic Processing function to see if any batches not pushed through?

4/ is one of the account sets incorrectly?

If all that you say above is correct then you should be able to track your variance

1. All the period - There are lot of transactions in each period that runs to hundred of pages per period.

2. Control Account did not change

3. The system is set to create and post a new batch in the setup

4. The account sets are correctly configured

1. All the period - There are lot of transactions in each period that runs to hundred of pages per period.

2. Control Account did not change

3. The system is set to create and post a new batch in the setup

4. The account sets are correctly configured

1. Are you using multicurrency??

2. Does the variance amount change or is it consistent??

3. Have you tried checking variance after current day processing is complete??  Won't help with previous errors but it may help highlight where there is a current problem.

1. Using multicurrency

2. The variance is not consistent

We have different control account accounts for different currency

Check for mispostings - the most common cause. I have seen horrible setups where IC posts to AP control instead of an IC receipt clearing account, the same on the OE side.

Analyze the AP control account entries, you should only be seeing transactions from AP source codes in there.

I know what you are talking about.

No other transactions have gone in there apart from batches from AP only because i define the account as control account in the chart of accounts which is only AP that can go in there.

OK... so all is good then :)

All is not good

Well your job is figure out where it went wrong, no one here can help you with that. The most likely cause is something posting to the AP control account when it should not be. Check your setup, somewhere something is not setup correctly.

When you run the Aged Payables and Receivables reports try using the Cutoff By = Year/Period to reconcile to the G\L Trial Balance Report for the same Year/Period