Our client produces over 800 invoices each month. Each week they generated an Aged A/R report and manually transferred all hand written notes from the previously generated Aged A/R report to the new one.

• Eliminate manual transfer of handwritten notes by exporting Aged A/R report to an Excel file.
• Use Vlookup to connect old notes to invoices that are still open.
• Allow multiple users to update the Excel file in real-time.

Our client approved the design of a simple and intuitive WEB based application that facilitates tracking of comments and notes for each individual invoice. The application helps organize information more efficiently and allows Credit & Collections Department to be proactive in their collection effort. DSO has been reduced and collaboration within the department has improved. Common problems associated with shared Excel files, such as; file corruptions, unauthorized copy distribution, formula overrides, etc., have been eliminated.

Additional features allow for generation of Unconditional Progress & Final Lien Releases, graphical analysis of customer payment habits, and improved record retention.

• Reduced DSO by over 25 Days.
• Annual interest Savings of $417,000.
• Increased Working Capital.
• Auto-generation of progress & final Unconditional Lien Releases.
• Executive Dashboard provides a quick view into Aged A/R.
• Aged A/R by Project Manager.
• Improved credit rating by reducing credit risk.
• Simplified customer dispute resolution.
• Oversight into cost of relationship with customers.