Automate Your Tasks in Excel
mightymacros Excel Add-ins and Utilities, provides free as well as paid MS Excel solutions to individuals and organisations that need to automate and reduce their repetitive tasks. An Excel solution can help turn MS Excel data into real information at the click of a button.
mightymacros is the business-hobby of a retired Industrial Engineer who enjoys making MS Excel programs using VBA and Visual Basic. There is no hidden agenda, and your feedback is most welcome.
So, if you require an MS Excel solution or would like to contribute to expanding the functionality of any of the free tools available on this site then please send your message using the link below:
Identify Duplicate Invoices and Payments with mightymacros Dat Add-in
mightymacros Dat add-in used alongside an ERP or accounting system helps to easily capture and detect duplicate invoices. If you are looking for a cost effective accounts payable tool, to run and check for invoice duplicates prior to making payments, then you have come to the right place.
Easy to use
The program runs validation checks within Excel on the invoice data prior to uploading it to a SQL Server localDB database file.
SQL logic compares invoice history against unpaid bills.
Appends suspected duplicate invoices to an output table.
Extracts the invoice duplicate data, then sorts and splits the report onto separate Excel tabs by duplicate rule.