Jaros

A large manufacturing company explained to us that they knew which of their customers had past due receivables and by how much with respect to any point in time. However, their real desire was to determine who their worst paying customer was over time. By taking period end snapshots of their aging, they were able to determine their worst paying customers over time, those which consistently paid late. To get this level of visibility, they needed to integrate two AR systems into a single Jaros Analytics system.

The following is just a sample of questions that Jaros Analytics answers. There are many more.

1. Who is my worst paying customer over time?
2. Who are my past due customers and how much do they owe?
3. What does my AR invoice transaction register look like?
4. What is my current revenue for a particular period? By organization, by customer, by sales rep, by time, by product?
5. I have invoice revenue, but how do I tie this back to COGS and margins?
6. How much did I make on this invoice?
7. How much cash has been applied to a particular invoice?
8. How can I get VAT tax reporting?
9. How do I get financial information on a particular customer or product?
10. What is my revenue by account / sub-account?

Another large manufacturer in Europe wanted Cost of Goods Sold information associated with each invoice line (associated with each sales order line) along with revenue, receivables and cost of goods sold chart of accounts information. This gave the manufacturer gross margin information at the invoice lines/sales order line level and gave them margins by customer hierarchy, sales geography hierarchy, product hierarchy, fiscal period hierarchies and organizational hierarchies. Jaros Analytics automatically provides this reporting area. Many of our customers use the AR sub-ledger and transactional information as an aid in the closing of their books for each period as well as year-end closing. The AR module also includes AR invoice, AR invoice distributions, cash receipts and payment schedule information.