What is an Accounts Receivable Aging Report?

The only way to be able to manage and see exactly who owes you money and when in the collections department is by using an accounts receivable aging report. It is one way to keep everything organized and keep your team on track. Those that are latest in your aging report, get the first call. Many collections departments use the accounts receivable aging report as their go to reference for all their customers and open invoices.
Continue reading

How To Create an Aging Report in Excel Continued

Since we all are in agreement that Excel can get pretty confusing when we start throwing out “IF, THEN” statements, “AND” statements and every other formula that exists, we’ve put together step-by-step instructions for you to make an aging report. For the first six steps and how to set up the Excel sheet, look back at our first post in the series.
Continue reading