I have an issue with a cheque batch that did not post the correct balance to the bank account. The total of the cheque register is correct, but the AP-CK entry in the G/L is incorrect.

It is out by the amount of one particular cheque. That cheque has been cleared through the bank so my bank balance is out by this amount. I can do a manual entry to fix this, but as I am very new to using this system, I'm not sure what the repercussions would be to doing this. I would think that something in the back end might be out of balance.

I have not had any response to this post. I'm assuming this is a system issue and not a user issue.

Hi CDCPG,

Since you indicated that the Check Register was correct, I presume you were using the Print/Post Checks and Advices (or "Check Run") function to print checks, as opposed to a Manual Check batch. Completing a Check Run will write entries for the GL for each check, and the portion going to the Bank GL Account has an option to Consolidate all details to a single entry. Do you use this option?

If you do an inquiry on the vendor to which this check belongs to, and look at the Transactions tab, do you see the check number in question? This is to confirm that doing the Check Run properly updated the vendor transactions file.

It is also possible to print the GL Transactions Report in Payables or any other Adagio program prior to retrieving into Ledger, and optionally Consolidate the details by account. Do you print and/or consolidate this report? If you have the report, you could determine if the amounts were correct up to this point.

After retrieving into Ledger, do you immediately post retrieved batches? Is it at all possible that an entry in the retrieved GL batch may have been deleted accidentally? Within Ledger, you can use the Batch Status Inquiry to see entries of batches in a grid, even for those that have been posted, so you could see if the details were correct or not in the GL batch prior to posting.

This is the kind of issue that is easier to determine when being able to see it. It may be good to be in contact with your Adagio Consultant, who would be well versed in tracking down where transactions may have gone, or the best way to fix it. I suspect that a journal entry in the GL to correct the balance is suitable, as long as the Payables balances are what you expect them to be, but your consultant may be able to give a better answer if they see your entire situation.

Hello,

Sorry for the lack of response - probably because the post was late on Friday and it's a difficult question to answer on the Forum.

If cheque batches were not being correctly passed to the GL, I'm sure that there would be a lot of complaints here - so likely something else happened.

Here are some questions to answer:

• What version of Adagio Payables are you running (see Help | About).
• Was this a System Check Run or a Manual Check Batch posted?
• Was the GL Batch printed and consolidated in Payables before being retrieved to Ledger?
• In the company profile, do you include the Bank with the Control Account Set?
• Are you using Adagio BankRec?
• If you print the Check Audit List, does the cheque you are looking for appear?

Issues of this type can be difficult to track down. You may need some sleuthing on the part of your Adagio Consultant to help you figure out what happened here.

Thanks for your response. I will look into all the documents that you suggested and then go from there.

I am new to using Adagio, and am in the process of learning the system while performing all of the accounting functions for a significant time period. Unfortunately, I don't know how the person previous to me performed the various tasks on the system - so it will take some analysis. I'm not sure if we have a "Adagio Consultant" . I will need to find out if our contract involves system support. I may need to call to get the details.

thanks
Pamela Klowak

Hi Pamela,

You might want to check our the 25 or so Adagio Payables "Show me how..." videos on the Technical Tips page of our website. They are easy to find if you sort the list by module and are only 8-10 minutes long each.

I have let your Adagio Consultant know that you have posted on the Forum.

Adagio will make more sense after you've gone through an entire month cycle. It's always unfortunate when you get dropped into a new environment without any training.