Accounts Receivable Reports

 

Report

Purpose

Adjustment

Displays a single account or interest adjustment for a customer.

Adjustment Receipts Batch

Displays all account and interest adjustments for specified customers.

Aged Receivables

Displays a detailed list of customer account balances, outstanding payments, and payment amounts. Shows the amount of days payments are overdue. Select the number and days of aging buckets.

Applied Credits

Shows the transactions that credits were applied to for a specific customer during a specified date range.

AR Invoice Activity

Displays what has been invoiced for particular dates, locations, customers, and products.

AR Release Numbers

Lists the AR release numbers for selected date ranges and products. Often used to provide a snapshot of what is happening per scheduled day (to allow for planning).

Tip Ordered From is the work order line location; Shipped From is the LOT or INV line location.

AR Taxes

Shows all the applicable AR sales taxes, including tax exceptions and override rates.

Bill & Hold

Shows bill and hold information grouped by customer or by product.

Cash Out

Displays the AR Activity of Payments and Invoices by location. Includes optional Cash Worksheet to assist with bank deposits.

Comparative Customer Sales

Displays a comparison of sales between sales per product and per customer.

Credit Info

Displays customer current balances, prepayments, warning limits, interest rates, current credit limits, and optionally bank information.

CRS Transfer

AR Invoice created when transferring items to another association.

Customer Account Activity

Displays a selected customer’s current balances and all of the account activities that affect the current balances.

Customer Balances

Displays a selected customer’s charge, credit, prepayment, and net balances.

Customer List

Displays all selected customers and their contact information.

(defaults to Active - Yes
click More Options to change)

Customer Position

Displays the position of prepaid committed products to be shipped to customers.

Customer Prepayment

Displays a selected customer’s prepayment deposits, plans, and activities.

Paid - refers to status of Work Order Paid In Full checkbox

Customer Prepayment Position

Shows customers’ total prepayment amounts remaining and compares them to their prepayment plans.

CRM Activity Summary

Lists CRM activities by Customer.

Customer Sales

Tips
Use the Product List data export to identify products flagged as Omit from Sales Reports.

To display Permit information, Group Sales By: Customer and Product and check the Show Permits box.

Lists all the invoices and invoice details for selected customers.

Sales Rep - Sales Rep under Select Customers is sales rep on customer account; Sales Rep next to Location of Sale is sales rep on Invoice (which may have been changed from default sales rep on customer account).

Manufacturer - Manufacturer under Select Products is manufacturer on product now; Manufacturer of Sale is manufacturer on product at time of sale.

Group by Supplier - from Supplier Product Code Mappings (if multiple, looks at top row only). 

Customer Sales - Single Customer

Tip
Use the Product List data export to identify products flagged as Omit from Sales Reports.

Run from the Customer Account, lists all the invoices and invoice details for that customer.

Note View Margins permission is inherited from Customer Sales.

Customer Statement

Displays a selected customer’s account activity, debits, credits, and balances during a specified date range. Used to send to customers for billing.

Can include a dynamic "special comment" text line that will display on each statement in this run only, or a more permanent comment for each location that will appear on every statement run until it is changed or removed.

Customer Summary Statement

Displays a summary of Purchases, Returns, Adjustments, Interest, Payments, Prepay Deposits, Prepay Purchases, Prepay Transfers, and details of purchases and Taxes.

Discount Groups

Displays all discount groups and their details.

Interest Charges Applied

Displays a selected customer’s interest charges and interest adjustments.

Invoice

Displays purchase date and due date, purchased products,  and prices.

Invoice Activity

Provides an overview of invoices in the system. Shows what has been invoiced: for particular invoice dates, entry dates, locations, customers, and/or products.

Invoice Batch

Displays all invoices for specified customers to be printed and sent to customers for billing.

Payment Type refers to Immediate Payments only.

Note: When backdating, the batch report may display permit details differently than the non-menu version if the customer has multiple permits (with different expiry dates) for the same product.

Loadout Ticket

Displays products/services on Loadout Ticket; provided to customer on receipt of goods (customers may refer to it as a bill of lading or delivery slip).

Loadout Ticket Activity

Displays all loadout tickets and their details, including products, dates, and locations.

Loadout Ticket Batch

Displays all loadout tickets for specified customers to be printed and sent to customers.

Payment Activity

Displays payments received from customers of various payment types. Used for reconciliation and to assist with bank deposits.

Show Undeposited Funds Only - transactions that will not display:
- funds that have been deposited 
- funds received/paid out when payment type is flagged to not show on Bank Deposits

Payment Receipt

Displays receipt for payments and prepayments received to be printed.

Payment Receipts Batch

Displays all payment receipts for payments and prepayments received.

Suggested Interest Charges

Displays the suggested interest charges on or before a certain date.

Note  Calculation Method defaults to Balance Forward; remember to change to Daily if that is the method your company is using, then save as a Report Favourite.

Suggested Receipts

Shows the outstanding receivables as of a given date. Useful for predicting the dollar value of expected payments (based on invoice due dates).

Tip  Sort by Date, then when viewing the results think of the Due Date column (on the far left) as the "future date". If you want to know how much you can expect in customer payments by August 31, scan down the Due Date column until you get to August 31. If you want to know how much to expect by the end of the year, scan a few more pages until you get to December 31.

Transport of Dangerous Goods

Displays a list of dangerous goods and all information required by Transport Canada. Applicable to LOTs, Invoices.

There are layouts that can display all products, not just the dangerous ones

Work Order

Displays products and pricing details of a given work order/quote; intended for the customer.

Work Order Activity

Displays all work orders and their details, including dates, prices, and any committed, ordered, prepaid, and/or taken products.

Sort By: Sales Rep is sales rep on work order.

If Show Totals is checked, average unit price (per product, weighted by Quantity Ordered) is displayed in totals section.

Work Order Batch

Displays all work orders for specified customers.

WO and PO Activity Combined

displays Purchase Orders and the Work Orders that created them (PO quantities converted to work order units; PO prices converted to home currency)