Skip to main content
AR / AP Report Settings

Quick reference for settings specific to the Accounts Receivable and Accounts Payable Reports and Charts

Sandra McCarthy avatar
Written by Sandra McCarthy
Updated over 2 months ago

For full details see AR / AP Reports & Charts

Ageing periods

The aging periods configuration allows you to customise how the aged values are grouped. 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 date of invoice

  • Due Date: shows outstanding transactions based on the due date of invoice

Show Receivables & Show Payables

The AR / AP reports and charts include sections for both Aged Receivables and Aged Payables. Toggle on/off to run separate reports.

Calculate unrealised gain/loss

Toggle to reconcile to your accounting system please note the following

  • MYOB: toggle off to reconcile to MYOB reports on to calculate any potential profits or losses on outstanding invoices or bills.

  • 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.
    ​

Report Criteria for Detail AR/AP Reports

AR / AP Detail reports contain the following additional criteria options.

Detail reports show each transaction as a separate line, these 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
    ​

Did this answer your question?