Aged Payables and Receivables

Aged Payables and Receivables

 

Overview

See a live comparison of your payables (money owed to your suppliers shown as a liability on your company's balance sheet) and receivables (payment held by your business against your customers).

The payables and receivables can be broke down by customers by clicking the "+" button on the left of each element of the list.

By selecting an element on the left panel, the unpaid amounts in history appear on the right.

Calculation 

The column on the left represents the absolute total payable/receivable amounts: it corresponds to the total amount owed to a supplier or waiting for a customer's payment.

Credit notes are taken into account and deducted from the totals.

The chart is non cumulative: it will display the amount owed for each period interval, and not the total amount owed at each point in time.

Settings 

The time range can be changed in the settings section (top-right cogwheel).

The line chart representation will vary depending on the customers/suppliers that you select on the left-hand panel.


 

See it in Xero 

In Xero menu: Reports > Aged Payables / Aged Receivables

To match Impac!'s default settings, the Date should be the current month, and the "Ageing by" parameters should be set at “Invoice date”.

Noticeable differences with the Impac! widget

The column on the left panel in Impac! should match the column on the right in Xero (column “total”).

Aged payables and Aged receivables are displayed on two separate reports on Xero.

Screenshot.png


 

See it in QuickBooks

QBO proposes 2 different reports: “A/R Aging Summary” and “A/P Aging Summary”.

 Include “All dates” in the reports parameters.



 

See it in MYOB AccountRight

Aged Receivables can be found in MYOB under Reports > Index to Reports > Sales > Aged Receivables (Summary).

 Aged Payable can be found in MYOB under Reports > Index to Reports > Purchases > Aged Payables (Summary).

 The default configuration will return all the customers and base the invoices history on today.

  • As of: Today date
  • Customer: All

 

Noticeable differences with the Impac! widget

In Impac! the Aged Receivables and Aged Payables are combined into the same widget. It has to be used to compare both MYOB reports.

Any question? Contact us on support@maestrano.com