AR Reports

Overview

  • AR Reports
    All AR sales and transaction reporting can be found under the reports menu.  

    Reports:
    - AR Report: Provides a high-level summary of all outstanding receivables, including total balances, customer aging brackets, and open credit amounts.
     
    - AR Aging: Breaks down overdue balances by age buckets (e.g., 30/60/90+ days), allowing for effective collection prioritization and financial risk tracking.

    Sales:
    - Daily Sales Report: Offers a snapshot of all invoiced sales within a single business day — ideal for daily performance tracking.
     
    - Weekly Sales Report: Aggregates sales data over a 7-day span to highlight mid-range trends and sales velocity.
     
    - Monthly Sales Report: Presents high-level sales activity across a full calendar month, including totals by customer, product, or sales rep.
     
    - Sales Detail Report: Delivers line-item level reporting on all invoiced sales transactions, allowing for granular review and product-level performance.

    Registers:
    - Invoice: Lists all invoices generated within a selected date range, including invoice numbers, amounts, and customer info.

    - Credit: Tracks credit memos issued to customers, including the original invoice reference, reason codes, and amounts.

    - Overpayment: Identifies instances where payments exceed invoiced totals, helping manage credit balances and potential refunds.

    Transactions:
    - AR Cash Receipts: Logs all incoming customer payments, whether via check, ACH, or credit card, including applied and unapplied balances.
     
    - AR Credits: Lists customer credits issued, with associated reasons and links to original transactions.
     
    - AR Adjustments: Displays manual AR adjustments such as write-offs, account corrections, and payment reapplications.
     
    - AR Misc. Cash: Captures non-invoice-related cash entries, such as deposits or one-off customer payments, for complete AR visibility.

    How to Use These AR Reports for Smarter Financial Management
    Each report listed above is designed to serve a specific purpose in the Accounts Receivable lifecycle, enabling teams to track revenue, monitor customer payment activity, and maintain financial control. Understanding how to use these tools effectively is key to maximizing the value of your ERP system.

    • Improve Cash Flow & Collections
    Use the AR Report and AR Aging to identify overdue accounts and prioritize follow-up. These reports help finance teams take proactive steps to reduce outstanding balances and improve liquidity.
     
    • Drive Sales Visibility & Performance
    Daily, Weekly, and Monthly Sales Reports allow sales and finance managers to monitor invoicing trends, track rep performance, and spot revenue fluctuations. This insight supports both short-term adjustments and long-term sales strategy.
     
    • Audit-Ready Documentation
    The Invoice, Credit, and Overpayment Registers ensure your records are always audit-ready. Having clear, well-organized documentation streamlines both internal reviews and external audits.
     
    • Enhance Customer Account Management
    Reports like AR Cash Receipts, AR Credits, and AR Adjustments provide a comprehensive view of each customer’s financial activity. These are essential tools for resolving disputes, issuing refunds, or reviewing payment history before future transactions.
     
    • Track Non-Standard Cash Entries
    The AR Misc. Cash report helps account for cash transactions not tied to invoices, ensuring that no customer payment goes untracked.

    Together, these AR reports offer real-time insights, actionable data, and full visibility into customer financial activity—all critical for managing receivables efficiently and making confident business decisions. We are continually developing new reports and enhancing existing ones to ensure users have access to the most relevant and powerful financial tools within the Inspired Technology Systems ERP.

AR

  • AR
    1. Go to the Reports Menu and click on the AR Sub-Menu



    2. You are now viewing the Accounts Receivables for all customers

  • AR Aging
    1. Go to the Reports Menu and click on the AR Aging Sub-Menu 



    2. You are now viewing the open accounts receivables for all customers



    Note: Only customers with an open AR Balance will appear on this report

Sales

  • Sales Details

    To View the Sales Details Report: 

    1. Go to the Reports Menu and click on the Sales Details Sub-Menu



    2. You are now viewing all of the sales details (one record per order detail line) across all customers.  




    To Limit by Cycle:

    1. Enter a cycle in YYMM format and click the Search Button 

    Example: Cycle 4 of 2021 -> YYMM = 2104 




    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 




    To Generate Subtotals:


    Example 1: Subtotal by Service

    1. Select the appropriate option from the Subtotal By Drop Down 



    2. Enter either a Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note:     For the service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table 




    Example 2: Subtotal by Address ID

    1. Enter a Customer name (Required) 



    2. Select the appropriate option from the Subtotal By Drop Down 



    3. Enter either a Cycle or a From/To Date (Required)



    4. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note:     For the address id subtotal selection, entries will be shown by address id in descending date order with a subtotal at the end of each address id's transactions



    5. Click on Download Table to download an Excel Spreadsheet of the current table 

  • Sales Daily

    To View the Sales Daily Report: 

    1. Go to the Reports Menu and click on the Sales Daily Sub-Menu

     
    2. You are now viewing all of the sales daily details (one record per date, per service) across all customers. 




    To Limit by Cycle:

    1. Enter both a From and To Cycle in YYMM format and click the Search Button 
     
    Example: Cycle 1 of 2021 -> YYMM = 2101 
     




    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 




    To Generate Subtotals:     

    Example 1: Subtotal by Customer

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter either a From/To Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note: For the customer subtotal selection, entries will be shown by customer # (not name), in descending date order with a subtotal at the end of each customer's transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table




    Example 2: Subtotal by Customer Class

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter either a From/To Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the customer class subtotal selection, entries will be shown by customer class name in descending date order with a subtotal at the end of each customer class' transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Sales Weekly

    To View the Sales Weekly Report: 

    1. Go to the Reports Menu and click on the Sales Weekly Sub-Menu
     


    2. You are now viewing all of the sales weekly details (one record per week, per service, per item) across all customers. 



    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 

    Note:     From Date must be a Saturday
    To Date must be a Friday
     



    To Subtotal by Item: 

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the item subtotal selection, entries will be shown by item number in descending date order with a subtotal at the end of each item's transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table  



    To Subtotal by Item Class: 

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the item class subtotal selection, entries will be shown by item class in descending date order with a subtotal at the end of each item class' transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Sales Monthly

    To View the Sales Monthly Report: 

    1. Go to the Reports Menu and click on the Sales Monthly Sub-Menu
     


    2. You are now viewing all of the sales monthly details (one record per month, per service, per item) across all customers. 



    To Limit By Cycle: 

    1. Enter either a From Cycle, To Cycle or both a From and To Cycle and click the Search Button 
     
    Note: Cycle 1 of 2021 -> YYMM = 2101
     
     



    To Subotal by Salesman:     

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Cycle (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the salesman subtotal selection, entries will be shown by salesman in descending date order with a subtotal at the end of each salesman's transactions 




    4. Click on Download Table to download an Excel Spreadsheet of the current table   



    To Subtotal by Service:

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Cycle (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Top Sales

    Use our Cloud ERP WMS software's Top Sales Report to easily view the customers bringing in the most sales.   


    1. Go to the Reports Menu and click on the Top Sales Sub-Menu



    2. You are now viewing the sales made for the current month, ordered by customer, starting with those top sale customers






    Limit By Cycle 



    Limit By Customer, Item and/or Service



    Sort By Total Price, Total Quantity or Total Weight



    Download Excel Sheets 



    Compare Sales With The Previous Year



    Subtotal By Customer, Customer Class, Item Class, Item, Salesman and Service  




Registers

  • AR Invoice Register

    To View the Invoice Register:


    1. Go to the Reports Menu and click on the AR Invoice Register Sub-Menu 



    2. You are now viewing all invoices across all customers



    To View Just Open or Closed/Paid Invoices:


    1. Select the Open or Closed/Paid Option from the Show Dropdown 



    To View Totals: 


    1. Select either a Customer, or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • AR Credit Register

    To View the Credit Register:

     
    1. Go to the Reports Menu and click on the AR Credit Register Sub-Menu 



    2. You are now viewing all posted credit invoices (both on account and against invoice credits) across all customers


    To View Just Open or Closed/Paid Credits:

     
    1. Select the Open or Closed/Paid Option from the Show Dropdown 



    To View Only On Account or Against Invoice Credits: 


    1. Select either Against Invoice or On Account from the Credit Type Dropdown 


    To View Totals: 

     
    1. Select either a Customer, and/or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • AR Overpayment Register

    To View the Overpayment Register:

    1. Go to the Reports Menu and click on the AR Overpayment Register Sub-Menu 
     
     
    2. You are now viewing all posted overpayment invoices across all customers
     
     

    To View Just Open or Closed/Paid Overpayments:

    1. Select the Open or Closed/Paid Option from the Show Dropdown 
     


    To View Totals:

    1. Select either a Customer, and/or enter a Date or Cycle (Required) 
     
     
    2. Click on the Show All Button  

     
    3. Click on Download Table to download an excel file

  • AR Invoices/Credits/Over-payments Register

    To View the AR Invoices/Credits/Over-payments Register:

     
    1. Go to the Reports Menu and click on the AR Invoices/Credits/Overpayments Register Sub-Menu 



    2. You are now viewing all invoices for all invoice types across all customers



    To View just Open or Closed/Paid Invoices/Credits/Over-payments:

     
    1. Select the Open or Closed/Paid Option from the Show Dropdown 


    To View Totals: 

     
    1. Select either a Customer, or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • Tax Register
    The Tax Register showcases one row per order line, along with its tax rate and tax total.

    Note: Only credits made directly against invoices will be showcased on the Tax Register.  On Account Credits do not apply to the Tax Register. 


    1. Go to the Reports Menu and click on the Accounts Receivable Sub-Menu, then click on the Tax Register 






    Search by Customer



    Search by Period or Date



    View Invoices and/or Credits

     

    View Totals



Transactions

  • AR Invoice Adjustments

    To View AR Invoice Adjustments:

    1. Go to the Reports Menu and click on the AR Invoice Adjustments Sub-Menu



    2. You are now viewing all Posted AR Invoice Adjustments 



    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 

    Accepted Formats: MM/DD/YY or MMDDYY

    Examples:     12/07/20
    120720



    To Search by Cycle:

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 

    Accepted Format: YYMM

    Example:     2101



    To Search by Notes:

    1. Enter the Note and any other relevant inputs 
    Note: Only either  note1, note2 or amount can be searched over at once   



    To Search by Amount: 

    1. Enter the amount of the AR Invoice Adjustment(s) and any other relevant inputs 
    Note: Only either  note1, note2 or amount can be searched over at once 

  • AR Miscellaneous Cash

    To View AR Miscellaneous Cash Entries:

    1. Go to the Reports Menu and click on the AR Miscellaneous Cash Sub-Menu



    2. You are now viewing all Posted AR Miscellaneous Cash Entries  


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720

     

    To Search by Cycle: 

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example:
    2101


    To Search by Notes:

    1. Enter the note in either the Notes 1 or Notes 2 input field 
     
    Note:Only either  note 1, note 2 or amount can be searched over at once
    Notes entered into the Notes 1 field can only be searched within the Notes 1 field, not Notes 2, and vice versa  


    To Search by Amount: 

    1. Enter the amount of the AR Misc. Cash entry and any other relevant inputs 

    Note: 
     Only either  note 1, note 2 or amount can be searched over at once    



     
  • AR Cash Receipts

    To View AR Cash Receipts:

    1. Go to the Reports Menu and click on the AR Cash Receipts Sub-Menu



    2. You are now viewing all Posted AR Cash Receipts 


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720


    To Search by Cycle:

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example: 
    2101


    To Search by Check #:

    1. Enter the check # and any other relevant inputs 
     
    Note:
    Only either check #, amount or reference # can be searched over at once 


    To Search by Amount:     

    1. Enter the amount of the AR Cash Receipt(s) and any other relevant inputs 
     
    Note: 
     Only either check #, amount or reference # can be searched over at once 


    To Search by Reference Number: 

    Reference #: Reference numbers are required for Credit Card and ACH/Transfer/Wire Payments.  Once a Credit Card or ACH/Transfer/Wire Payment has been completed from an outside source, the reference number generated from that transaction must be included as part of the corresponding AR Cash Receipt. 
     
    1. Enter the reference # and any other relevant inputs 
     
    Note: 
     Only either check #, amount or reference # can be searched over at once

  • AR Credits

    To View AR Credits: 

    1. Go to the Reports Menu and click on the AR Credits Sub-Menu



    2. You are now viewing all Posted AR Credits (Against Invoice Credits and On Account Credits)


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720


    To Search by Cycle: 

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example: 
    2101


    To Search for Credits Applied Against an Invoice: 

    1. Enter the invoice number the credit has been applied to and click on the Search Button 
     

AR Reconciliation