The Account Activity Report in the Customer Portal allows you to view a snapshot of your primary account activity within a specified date range including
- Invoices
- Credits
- Payments
You can view these events by selecting a date range on the Account Activity page and clicking 'Generate Report'. The report can be downloaded as an Excel file by clicking the ‘Download Report’ button.
Generate an Account Activity Report
To generate an Account Activity Report an Account Admin or Payer can:
- Navigate to the Account Activity page (under the ‘Activity’ menu):
- Specify a date range:
- Click ‘Generate Report’:
Reading the Report
This report is easy to read and includes several columns of data associated with each activity. There are three types of account activities returned when generating this report:
- Invoices
- Credits
- Payments
Transactional vs. Consolidated Invoicing
If you are on transactional invoicing, you will see each and every transactional invoice created during the date range given in the generation of the report.
If you are on on consolidated invoicing, you will only see the consolidated invoices generated during the given date range in the generation of the report. To see individual transactions during a given range of time, please utilize the date range filters on the ‘Transactions’ tab of the ‘Account Overview’ page.
Each individual activity row will include it’s associated ID. The ‘Activity ID’ for:
- an invoice is the ‘invoice ID’
- a credit is the ‘credit ID’
- a payment is the ‘payment ID’
Each individual activity has an associated status. The common statuses include:
- Open: invoices with outstanding balances, payments with unapplied amounts, credits with unused amounts
- Closed: invoices that have been paid in full, payments that have been fully applied, and credits that have been fully used
- Past Due: invoices with open balances that are past their due date
- Failed: payments that have failed (insufficient funds, incorrect banking details, etc.) and which are no longer valid or able to be applied to open invoices
Finally, the remaining columns show the original amount of the activity and its current open amount.
Adjustment Column
There is also an 'Adjusted Amount' column that is hidden by default but which can be toggled on if needed. This adjusted amount provides the amount of any activity item that has been adjusted (such as invoice that has been partially or fully written off, or a payment that has failed).
The adjusted amount can be used to get the accurate net total of open activity in the event there have been adjustments on activity items included in the current report range. Using the sum of invoices in the 'Adjusted Amount' column and subtracting the sum of credits and payments in the 'Adjusted Amount' column, will return the current net open activity. Keep in mind that payments must be applied to open invoices in order to close them.
The 'Adjusted Amount' column is also included in the downloaded excel version of the report.
Downloading a Copy of the Report
You can also download a copy of the report data as an excel file. To do this:
- After generating an Account Activity Report [LINK to section above], click the ‘Download Report’ button:
