AR Automation offers all the reports listed below. Click on the links to read a summary of each report.

Payment Plans

Recurring Revenue

Accounts Receivable

Sales

User Activity

Consolidated Report

AR Automation has a Consolidated Report functionality which allows you to combine Account Receivable reports if you have multiple company entities. You can select the Consolidated checkbox on the Report page and select entities that you want to have consolidated into the report.

Data objects in the report can be distinguished by the company to which the object is related. You can add a company column by navigating to the report settings.

The Consolidated Reports functionality can be used with the following reports:

• Customer Aging Report
• Detailed Customer Aging Report
• Applied Payments Report
• Payment Plan Statement
• Payment Projections
• Active Payment Plans
• Delivered Communications

📘

Note

The Consolidated Report setting can only be applied from the top-level account.

Multi-Currency Reporting

A/R Dashboards

Reports and Dashboards

Multi-Currency impacts the following A/R Dashboards:

• Total Current Amount
• Total Past Due Amount
• Revenue vs Outstanding
• Projected Cashflow
• Past Due

If you use multi-currency billing, our enhanced reporting provides improved accuracy of the data displayed in the Dashboards on your AR account.

As the exchange rate changes, your accounting system calculates the amount the invoice is valued at that specific time (when the invoice is created). Along with exchange rates, the accounting system calculates the Invoice Total Balance in the base currency, taking into consideration the actual currency rates.

We are pulling invoice balances in base currency from your accounting system for AR accounts connected to any of the following Accounting Systems: QuickBooks Online, QuickBooks Desktop, Intacct, and NetSuite.

If your AR account is connected to the Xero accounting system, we calculate the invoice total balance in base currency based on the exchange rate we receive for invoices from Xero.

The dashboard’s data is calculated based on Invoices’ Total in base currency, either retrieved from your accounting system or calculated in the AR system. This means the data is displayed in your default currency while taking into account the invoices created in additional currencies.

Total in Base Currency column

There is an optional column added to the invoice list page called Total in Base Currency that displays the total in the base currency of an invoice that we imported from your accounting system or calculated in the AR system. You can add/remove this column in Settings by clicking on the gear icon.

📘

Notes

• Multi-Currency reporting is available for AR accounts that are connected to an accounting system. Standalone accounts do not support Multi-Currency Dashboards.
• Multi-Currency Dashboards data may not be 100% accurate if your account has invoices in an additional currency that are not synchronized with the accounting system. If an invoice (in additional currency) is created in AR and is not synchronized with the accounting system, we cannot pull the Invoice Total Balance in Base currency or the exchange rate.