We have programmed our systems to export monthly billing and clearance reports to Excel. You can sort the data by client, office, month of service (MOS) or any other parameter, and drill down to any level of detail.

Aging media payables is useful in determining whether a payable is legitimate or needs to be written off. It also provides audit documentation and is useful for balance sheet reconciliation.

For the step-by-step procedure on how to age media payables, see the Media Control Account Aging Toolkit.