The freight forwarding management system software we developed has a company audit module. This program runs every night and checks for any possible error in the business. In total it checks around 50 different situations that indicate a problem in the company from loss on a file to a missing number.
This week I added a function that checks if there is any missing invoice number. For example if invoice 2 is followed by 4 this is a problem because you might not ask for payment for this missing invoice 3.
The application checks all companies. Within each companies it checks if any invoice or credit note is missing and reports that in an email. As the invoice formats are very different and a combination of letters and numbers like A1900000171B we have to work with Regular expressions in the online PHP / Mysql application.
The software found a long list of mistakes in 2 seconds by scanning 4 companies over 10 years and right now our financial staff is following up on all the problems the system detected. It finds problems that no human could possibly find because the information is simply too vast and we can never foresee the errors that employees make like naming the PDF file of the invoice Invoice 1000.pdf and inside the PDF the invoice number is 495.
The app also checks that a higher invoice number has the same or a higher issue date compared to the previous invoice number.
Together with the other 50 business auditing modules this software allows you to have total control over your business without spending any time investigating. The application does everything for you and in the morning you just have to read the report it produced during the night.