Identify uncaptured duplicate invoices and prevent duplicate payments

Publisher:	mightymacros
Downloads:	1
Software Type:	Freeware, 0.00
File Size:	4.32M
OS:	Windows All
Update Date:	30 September, 2020

mightymacros Dat add-in helps accounts payable staff to identify uncaptured duplicate invoices before they become duplicate payments. The tool is installed within MS Excel and offers a non-intrusive means for scanning invoice information for duplicate transactions. The tool relies on a standard set of invoice information that you upload into an Excel spreadsheet from an ERP or accounting system. The information is then uploaded into a SQL database, where it is analysed by the program and returns a report back into an Excel workbook. The SQL database that Dat add-in uses is a localDB version of SQL Server Express having around 5 times the capacity of an MS Access database. Among other advantages the localDB version does not require any configuration or administration by the user. mightymacros Dat add-in is designed for regular use, ideally to be used for validation prior to a weekly payment run.