This guide explains each piece of the Accounts Receivable report in the Accounting Module.
Brand Filter: Use this filter to limit the report to specific brands.
Agent Filter: Use this filter to limit the report to specific sales agents.
Payment Setting: Use this filter to limit the report to specific payment types (Autopay, POS, and Statement)
Returned Not Paid: Selecting this checkbox will limit the report to only customers that have an outstanding balance and have at least one order returned to them. Turning this on in addition to filtering by POS and Autopay customers will give you a report of all "walk out" customers or customers that an employee forgot to charge.
Declines Only: Selecting this checkbox will show only customers who have a Declined or Expired credit card.
A/R Only: Selecting this checkbox will show only customers who have account receivables.
Run Autopay: This button charges all Autopay customers with a card on file and a balance. The same function occurs automatically, but you can manually execute it with this button.
Generate: This button allows you to generate Open Invoices / Invoices / Statements. It also gives you the choice to email the customers along with printing them out
Print: This button allows you to print statements and mark them as sent.
Current Total: This section displays the Current unbilled receivables and the number of customers that make up the current total. An unbilled order is a ready order that is not on a statement or invoice.
1-30 Total: This section displays the total billed receivables up to 30 days old and the number of customers that make up that total. 30 also includes any credits, prepayments, rewards, and overpayments, as a negative amount. If your 30 total is a negative value then you have more unused credits than billed sales.
31-60 Total: This section displays the total billed receivables that are 30 to 60 days old and the number of customers that make up that total.
61-90 Total: This section displays the total billed receivables that are over 90 days old and the number of customers that make up that total.
90+ Total: This section displays the total billed receivables that are over 90 days old and the number of customers that make up that total.
Total A/R: This section displays the total billed receivables that are unpaid
Column Headers: You can click each column header to sort the report by that column's values. Sorting the report by the Payment column with Declines, Expirations, and missing cards at the top with the report filtered by your routes is an easy way to see which route customers you need to get credit cards from.
Customer Details: This arrow opens a drop down with details for the customer, see descriptions below.
A. Customer Name, click this to open the customer's account.
B. The order number, piece count, price, created date, ready date, and returned date for each order the customer's total A/R is comprised of is shown here. Click a row to open that order.
C. Customer Contact Info, click this to send an email or text to the customer.
D. Pay button, click this to make a payment on the customer's account.