The Payment Register report, found at Accounting / Accounting Reports / Accounts Receivable / A/R Status, can be used to assist with daily cash drawer reconciliation or provide Customer Payment history for a given timeframe.
Customer and Payment data will display including: Payment #, Control #, Date, ID, Name, Payment Type, Payment Method, Reference Number, Payment Amount, Amount Received, Discount, and Total Credit. Also included is a Location Recap, displaying the Location of Payments, Method of Payment Totals, and G/L Account to which payments were posted.
Note: The Location Recap is for the entire Location totals regardless of filter.
Using the Show Detail option will include the Invoices paid by the payment.
- Select Customers – The Payment Register report defaults to All Customers. To choose specific Customers, choose Select.
- Classifications – Customers can be selected by Classifications. Information regarding Classifications can be found here.
- Print Notes – Select to include the information added in the Description section of the Payment on the report.
- Show Detail – Select to include the detail of the Invoices paid by the Payment.
- Include Payments – Select which Payments to include in the report - Regular, Prepay, or Budget Billing.
Note: Any combination of Payments can be chosen, including selecting all three options. - Payment Method – The default is All. Optionally, select a specific Payment Method from the list.
- Location – The default is the Location selected upon logging into Agvance. Optionally, select a different Location from the list.
- Source – The default is All. Optionally select a specific Source from the list.
- Select Range – The Payment Register report can be run based on Payment #, Date, or Fiscal Month. Select the desired range and set the Start and End parameter.
- Sort by – Choose to sort the report by Payment # / Date, Control # / Date, Customer / Payment # / Date, or Customer / Control # / Date. If the Customer / Payment # / Date or Customer / Control # / Date option is selected, the choice to sort by ID or Name becomes available.
- User – The default is All. Optionally select a specific User to filter results to Payments entered by that User.