The Payment Register report provides you with a listing of all payments within a specified time period. You can filter this report in many different ways, including by Bank Account, Payment Method, or if a payment references a specific account. This report can be helpful to provide a detailed record of payments that occurred over a specified period of time.
- To access the Activity - Payment Register report, open the Finance module and then click "Other Reports". Then click on "Activity - Payment Register".
- Select which book you're wanting to review in the "Book" drop list.
- In the "Date range" field, set the date range you want to look at the transactions for.
- In the "Bank accounts" section, select which bank accounts you want to see the payments for by checking or unchecking the accounts you're interested in.
- In the Payment method field, you can select which payment type you want to see on your report, either Check, EFT, Charged or you can select (all) to see each of the payment types.
- In the "Referencing this account" field, you can pick a specific non-asset account that was used in the payments you're looking for.
- The "Sort by" field will let you choose how you want your report sorted. Options include by date, document number, payment method and payee.
- There are a couple options for this report, described below:
- Hide line items - This will provide you with a version of the report that only shows summary information about each payment, line items are hidden.
- Subtotal by month and year - This will also provide you with a report that only shows summary information, but it will provide a subtotal at the end of each month of your report.
- Click "Print" to generate your report. This will bring up the Print Preview, and if you want to export this report to Excel (or the spreadsheet program of your choice), in the bottom right corner of the preview window, you will see a button that looks like the Excel logo, click on that to send this report to Excel.