Payments before due date (accounts payable analysis)

olala

Forums

Hi!I am looking to perform an analysis of an accounts payables where I can see any payments of supplier invoices going out before due date. I would like to generate a list showing total amount per credit being paid before due date, preferrably in a month by month format.This analysis would be useful for fraud investigations on for example bankruptcies. Does anyone have this script available or could help me out in any way?Many thanks!

Brian Element Mon, 10/08/2012 - 07:44

Hi olala

Welcome to IDEAScripting.com.  I don't know of any scripts that currently do this but I am willing to try and help develop a script that does this.

So from my understanding the file would need at minimum the following fields:

  • Payment date
  • Due date
  • Amount

For your monthly summary do you prefer using the payment or the due date to generate the monthly report?  Or would you prefer to have both as an option?

For the transaciton database that would have all the fields contained in the original file in which the payment was paid before the due date?

Thanks

Brian