My open payables report of 8/31/14 doesn't match my Payables on the Trial Balance for 8/31/14. What caused this...how can I find the difference?? Thank you in advance.Helen

Helen

There are many reasons why this may have happen. Did this occur recently or did you just notice that the balance is different

The most common reasons are a manual journal entry in Ledger or an uncoordinated restore of either Ledger or Payable.

Beyond that you should get your Adagio dealer to help you.

This just happened. I am a new user and I have not been trained on Adagio. When I call my dealer she comes and does what I need but it seems I don't get the actual explanation.
I just find out that I had access to this website. So I will look at the videos and other information on this site.I missed the last training because the email went to an old email. Your company did not have the current email. Thank you so much for your help.

Helen:

It can be difficult to take over a position without adequate training. When working with your dealer, you are entitled to insist on getting full answers to your questions. After all, you're the one signing the cheques! One technique is to build a list of questions and send them to your dealer. Maybe some can be answered by email and maybe some require a site visit.

The 1-hours webinars are a good way to get an introduction to Adagio.

Another way that the subledger could be out of synch with the control account is when Retrieving subledger batches to the GL. This could happen if you choose to "Assign entries to" a "Specific period" rather than "Period based on date",

Hi Helen

Before panicking, do the following -

Make sure everything is retrieved into the Ledger and posted.
Run an Open Payables report as of fiscal year-end and see if it ties to the Payables balance as of period 12.

If it does, then you have a timing difference which will wash out over time. If it doesn't, then something went wrong, and as Doug says, it can be any number of things.

Here's an example - if you scan through the Payables account activity and see transactions that have a source code other than AP (such as GL), then that is going to be your problem. Nobody should be making GL journal entries to that account, without knowing exactly what they are doing.

Steve

Hi Helen,

To add to Steve's point, there is a feature in Adagio Ledger to restrict posting to the subledger. So if you discover manual journal entries are being made to the A/P control account in error you can prevent that with this feature.
Once you've got your account in balance with A/P, go to Edit>Accounts and select the control account in question. Check the "Restrict to subledgers" box and a new tab will appear. You can then select only the A/P sub-ledger as being able to post to this account. This will at least prevent the manual entries from G/L.

Another possibility not yet mentioned, is that someone deleted a batch in GL that came from A/P. You can see that by going to Inquiries>View Batch Status and looking for batches marked "deleted" with the source code AP.

If that is the case, you can recover the batch from this screen and it will be available to post.