Accounts Receivable Movement

The Accounts Receivable Movement report is an Advanced Report that shows the overall accounts receivable movement for the past twelve months broken down by month. This report also contains a graph that shows each month's Charges, Payments, Adjustments and Balances.

Description

The Accounts Receivable Movement report tracks the following pieces of data:

  • Charges — The total amount of charges entered for a given month. This will match the Charges total from the Activity report set for the same month.
  • Payments — The total amount of payments entered for a given month. This will match the Payments total from the Activity report set for the same month and filtered by DateCreated.
  • Adjustments — The total amount of adjustments entered for a given month. This will match the Adjustments total from the Activity report set for the same month and filtered by DateCreated.
  • Balance — Charges - Payments - Adjustments = Balance.

The graphical representation at the top of the report displays the above information as a bar graph, with green representing charges, orange representing payments, yellow representing adjustments, and red representing balance.

Views

This report has two views:

  • Graph — The top of the report is a bar graph that will show the Charges, Balances, Adjustments and Payments for each month over the last 12 months from the date the report was run. The Y axis is dollar amount. The X axis is month. The center of the graph is at 0, with negative amounts falling below 0 and positive amounts rising above.
  • Data — The bottom of the report will display the numbers for the report listed out in a table. The information shown is: Month, Charges, Payments, Adjustments and Balance Due for the entire month listed.

Filters

  • Run Date — The date the report is generated. This will default to today's date, but setting another date will cause the report to generate results 12 months back from the date selected.

Sample Report

armovement.PNG
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-NoDerivs 3.0 License