Does anyone who uses Telpay have a suggestion on the best methodology to reconcile Telpay payments with AP control account in Adagio?

Prior to Telpay, a bank rec would be the usual g/l match to bank statement for each individual invoice - pretty obvious if there was a posting error.

Now with Telpay, the only thing that goes through the bank is the lump sum payment which matches the session total provided by Telpay after processing, however we are lacking a way to match the invoices paid to the invoices processed in Adagio.

There have been many posting issues and it has been a long time since the Telpay session numbers shown as the 'cheque number' in Adagio have any relation to the true session. The G/L detailed report for the Telpay bank is just a mess of invoices and payments with no rhyme or reason.

Any advice at all would be greatly appreciated!

Thanks!

Tam:

Not sure if I really understand what you are looking for. Even without TelPay there wasn't an easy way to match invoices to payments in GL, unless you issued individual cheques for each invoice. Also "The G/L detailed report for the Telpay bank is just a mess of invoices and payments with no rhyme or reason." doesn't make sense as the invoices would not be in the TelPay Bank GL Detail report.

With TelPay there is a way to set up TelPay to post to GL the same way that a regular cheque is posted, however this cannot be done retroactively.

I would recommend that you consider contacting your Adagio dealer for assistance.

Thank you.

Indeed, before Telpay, each invoice in the G/L matched each individual chq that went through the bank. Easy when doing the monthly bank reconciliation to know which invoice payments had been cashed and which were outstanding.

Moreover, the invoices are very much showing, as a credit to the bank, in the Telpay G/L Detail Report, just as the posted and paid invoices would should as a credit to the bank in our regular bank acct G/L. The problem lies in the fact that the Telpay number (or chq number rather) does not correlate with the actual Telpay session so when the data and dollars don't match, it is a painful process to figure out why.

Thanks.

Tam:

I know there is a better way for Adagio and Telpay to work together that would not result in the problems you describe but it's hard to tell what needs to be done without actually reviewing your existing database setup.

Hi Doug

I have spoken with Tam and she has a plan of action for rectifying her issue.

Thanks for the help.

Profuse thanks to you both. Your time is greatly appreciated!

Tam