AR Reports

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

  • 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 the top sale customers






    Limit By Cycle 



    Limit By Customer, Item and/or Service



    Sort By Total Average Cost or Total Cost



    Sort By Total Average Profit or Total Profit 



    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