A/R Customer Balances As Of

The A/R Customer Balances As Of report shows what every customer's account balance was at the end of a chosen date — not what it is today. Its main job is month-end reconciliation: proving that the A/R total in VMX matches the accounts receivable balance in your accounting system as of a closing date.

Opening the A/R Customer Balances As Of report

1. Go to Reports and open the Accounting report under the Accounts heading (see Accounting Report).
2. Set the Accounting report's date to the day you're reconciling to — typically the last day of the month.
3. In the A/R section, click the A/R Ending Balance amount. It links to the A/R Customer Balances As Of report for that same date, and the report's total will match the figure you clicked.

How the as-of balance is calculated

The report starts from each customer's balance today and works backward: it removes all account activity dated after your chosen date — sales charged to the account, payments, refunds, voids, manual credits, returned/bad payments, bank fees, finance charges, and early-pay discounts. What's left is the balance the account carried at the end of that date.

Because it works from today's records, the report reflects any corrections made since — if a transaction from that period was later fixed, the as-of balance shows the corrected figure.

A/R Customer Balances As Of columns

• Number — the customer's account number.
• First, Last, Company — who the account belongs to. The list is sorted by company name (or by first and last name for accounts without a company).
• Balance — the account balance at the end of the as-of date. A negative balance means the customer had a credit — they had paid more than they owed.

Customers whose as-of balance is zero are left off the report. The grand total of the Balance column is printed below the table — that's the number to compare against your accounting system's A/R account.