Use the Aged Receivables and Aged Payables reports to complete your reporting within Calxa. Clearly identify overdue receipts and payments to assist with managing cashflow effectively.
Report Templates
This help article relates to the following Calxa report and chart templates.
Aged Receivables/Payables Summary
Aged Payables/Receivables Detail
Aged Receivables/Payables Summary Bar Chart
Aged Receivables/Payables Stacked Bar Chart
Aged Receivables/Payables Summary Pie Chart
See the following additional help articles for generic help with the Calxa Report Builder.
Current Support for AR / AP Reporting
The following integrations support Aged Receivable and Aged Payable reporting:
Xero: fully supported
MYOB Business: Invoices and Credits from FY 2019
Other integrations:
QuickBooks Online: coming soon
Manual Organisations: transactions cannot be imported for manual organisations and therefore the AR / AP reports are not supported for manual organisation
Enterprise Integrations: enterprise integrations such as MYOB Acumatica, NetSuite and Business Central do not import transactions and therefore the AR / AP reports are not supported
Report Criteria for Summary AR/AP Reports
The following criteria options are unique to AR / AP reports and charts.
See the Set Report Criteria help article where you can learn more about using the report criteria generally.
Ageing periods
The aging periods configuration allows you to customise how the aged values are grouped. You can customise these intervals based on your specific business needs. You can group a number of Months or Days. For example, 3 Months or 90 Days.
Ageing by
View the aged values based on their: Invoice Date or Due Date.
Invoice Date: shows outstanding transactions based on the period they were raised
Due Date: shows outstanding transactions based on the period they were due
Show Receivables & Show Payables
The Calxa AR / AP reports include sections for both Aged Receivables and Aged Payables. If you would like to just run one at a time you can easily toggle each section on or off.
Calculate unrealised gain/loss
Toggle on to calculate any potential profits or losses on outstanding invoices or bills.
When enabled the invoice value will be calculated using the closing exchange rate for the reporting period rather than the original transaction exchange rate
When disabled the original transaction value will be used
Tip:💡to reconcile to your accounting system please note the following
Xero: toggle on to reconcile to Xero reports, however, please be aware Calxa is unable to detect the exchange rates used in Xero and thus there may be small discrepancies for foreign currency transactions
MYOB: toggle off to reconcile to MYOB reports
Report Criteria for Detail AR/AP Reports
AR / AP Detail reports contain the same criteria as the summary reports with the following additional criteria options.
Group by
Detail reports show each transaction as a separate line. The transaction detail can be grouped by:
Contact: Invoices and Bills are grouped by contact (customer/supplier) with a corresponding total value for each contact
Invoice Date: Invoices and Bills are grouped by the date they were raised with a corresponding total value for each date
Due Date: Invoices and Bills are grouped by the date they are due with a corresponding total value for each date
