A/R Control Report

How to print: Complete the A/R Control Report Screen.

For more information: See the sample report in PDF format.

Contents:

• date range included on the report

• A/R starting balance (The total A/R balance at the first date on the report; calculated as:

 

Open balance of A/R Open Item records (prior to the start date) + paid amount of A/R Payment Detail (after the start date)).

 

• A/R ending balance (The total A/R balance at the last date on the report; calculated as:

 

Open balance of A/R Open Item records (prior to the end date) + paid amount of A/R Payment Detail (after the end date)).

 

• A/R Net Change (The total difference between the A/R starting and ending balances; calculated as:

A/R ending balance - A/R stating balance).

 

• A/R Sales (The total of positive Invoice Payment records with a pay category of A/R or COD within the selected date range).

• A/R Credits (The total of negative Invoice Payment records with a pay category of A/R or COD within the selected date range).

• A/R Adjustments (Any adjustments made to update the customer's A/R account; calculated as:

 

The Open Item - Debit total of A/R Cash Receipts).

 

• A/R Refunds (created today/not processed today) (A/R refund credits processed on a different date than the invoice date).

• A/R Refunds (processed today/not created today) (The total of refund records with an original and current category of A/R or COD that were processed on a different date than the created date).

• A/R Refunds (processed today/original category NON A/R) (The total of refund records with a current category of A/R or COD and an original category of Cash, Credit card, or Coupon/credit).

• A/R Refunds (converted A/R credits) (A/R refunds converted to checks in Processing A/R Refunds (MARC)).

• transaction total: (Total dollar value of all A/R transactions; calculated as:

 

(A/R Sales + A/R Credits + A/R Adjustments + A/R Refunds converted A/R credits) - (A/R Cash - A/R Refund created today/not processed today - A/R Refund processed today/not created today - A/R Refund processed today/original category NON A/R)).

 

• out of balance: (Total dollar value out of balance; calculated as:

 

A/R Net Change - the Transaction Total).

 

• See Printing the A/R Aging Summary Reports (MPAR) for more information on and a sample of the Detail Aging report.