Office - Interactive Reports - Vendor - Check Register-Outstanding Checks

Table of Contents


Overview

  • In this guide we will cover the Check Register, Item Receipt and Outstanding Checks Reports. You will learn how to run each report and will see an example of the data that each report will produce.

Required Permissions

  • Interactive Reports

  • Accounts Payable

 


Accessing the Tool

Interactive Reports gives you the ability to filter, sort, and group the data using criteria. The available criteria are specific to the information the report contains. The report functions give you the ability to customize date settings, save criteria settings, delete saved reports, and schedule an email delivery. In this section you will learn how to use the criteria and report functionality.

  1. Click on the Interactive Reports Icon from the left menu bar. 

  2. On the Report Overview page, there is a list of reporting categories to choose from, or the User can search for a topic in the top search bar. It is best to keep the topic as broad as possible. If the club wants to see POS sales search for sale.

Check Register

Provides a list of all checks written within a date range. Details Vendor, Batch and Printed Date, and Amount to Pay. Filter by Vendor. Can select a specific G/L Account. Select to Include, exclude or Only Show Voided Checks. Select to Filter by Printed date, or Batch Date. Option to Positive Pay. 

To run Check Register, select the report from the Vendor Dropdown,

  1. Set the Date Range.

  2. Set whether to display Voided Checks or not.

  3. Choose the Vendors.

  4. Set the Filter By.

  5. Choose the Account\s.

  6. Set the Detail Level.

  7. Select View Report.

In this example we ran the report for the month of September. We have chosen to include voided checks and our Filter By is the Printed Date. Set set a detail level of Invoice but could set one for Item to see line items on the invoices if needed. We see the Check Number, Vendor Number, Vendor Name, Batch Date, Printed Date, and Amount to Pay.

Item Receipt

Provides the ability to select and view an Item Receipt. 

To run Item Receipt, select the report from the Vendor Dropdown,

  1. Choose the Item Receipt to view.

  2. Select View Report.

In this example we ran the report for one of our Item Receipts. We see all the information in a printable format.

Outstanding Checks

Provides a list of all checks not deposited based on an "As Of" Date. Select a G/L Asset Account. Option to Include Reconciled checks. 

To run Outstanding Checks, select the report from the Vendor Dropdown,

  1. Set the As Of Date.

  2. Choose the Ledger Accounts.

  3. Select View Report.

In this example we ran the report as of today with our cash operating account. We see the Check Number (EFTs all will have a check number of 0), Printed Date, Vendor, and Amount.


Best Practices

FAQs

 

Â