Payments before due date (accounts payable analysis)

3 posts / 0 new
Last post
olala
Offline
Joined: 10/08/2012 - 04:23
Payments before due date (accounts payable analysis)

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's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

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

 

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

Hi Ola,

I have put together a script that will hopefully help you out.  I have posted it in the ideascripting section of the site.  http://www.ideascripting.com/content/payment-date-vs-due-date

Let me know if it doesn't fit your needs or if you would like any modifications.

Brian