1. In the Purchasing/Accounts Payable menu, click Check Report.

2. To generate the Check Report, Check Line Report, or the Check Allocations Report, click the corresponding tab.

3. Before generating the report, be sure the correct fiscal year is selected from the pull-down. The fiscal year defaults to the current year.

4. Start by selecting the type of checks to include in the report by selecting the applicable check boxes, such as Reconciled, Not Reconciled, Voided, Not Voided, Standard, Electronic, ACH, Manual, and/or Filler.

5. Select the Internal Accounts check box to include checks that were run from an internal account.

6. Select the Revenue check box to include checks that were run from a revenue account.

7. Select the Include Amount Type check box to display separate ACH Deposit Amount, Printed Check Amount, and Manual Entry Amount columns in the report results. The additional columns include page totals and grand totals and can be filtered, sorted, exported, printed, and shown or hidden using Toggle Columns.

8. To include a specific range of check numbers, enter the beginning Check # (from) in the text box and an ending Check # (to) in the second text box.

9. To include checks created over a specific date range, enter the beginning Check Date (from) in the text box and an ending Check Date (to) in the second text box.

10. To pull checks as they pertain to specific check batches, select the batches from the Check Batch pull-down.

11. To pull checks linked to a specific Vendor, select the vendor from the corresponding pull-down.

12. To pull check linked to a specific Bank, select the bank from the corresponding pull-down.

13. To pull checks posted by a specific user, select the user from the Check Poster pull-down.

14. To pull checks based on a specific Amount, enter the applicable amount in the text box.

15. Select the Graph check box to display interactive charts on the Check Report, providing a visual breakdown of check totals based on the selected filters and report criteria.

16. From the Select Graphs to Display pull-down select the graphs you want to include in the report output. The available graph options may vary depending on the selected report and the districts configuration, such as By Cntr, By Func, etc.

17. To include a specific range of invoice numbers as they pertain to checks, enter the beginning Invoice # (from) in the text box and an ending Invoice # (to) in the second text box.

18. To include checks are they pertain to invoices created over a specific date range, enter the beginning Invoice Date (from) in the text box and an ending Invoice Date (to) in the second text box.

19. To pull checks as they pertain to a specific Invoice Batch posted by a specific user, select the user from the Invoice Batch Poster pull-down.

20. To include checks based on a range of linked purchase order numbers, enter the beginning PO # (from) in the text box and an ending PO # (to) in the second text box.

21. To pull checks as they pertain to specific purchase orders by name, enter the Draft Name of the purchase request/order in the text box.

22. To include checks are they pertain to purchase orders requested over a specific date range, enter the beginning Request Date (from) in the text box and an ending Request Date (to) in the second text box.

23. To pull checks as they pertain to purchase orders requested by a specific user, select the user from the Requester pull-down.

24. To filter the Check Report based on accounting strip elements, such as a specific Fund, Facility, etc., enter the element code in the applicable text box. You can filter by as many elements as needed.

To conduct a search of accounts, click Account Lookup. This opens a pop-up window giving you the ability to search through all available elements and corresponding codes and descriptions.

25. When all of the report criteria has been entered and/or selected, click Run Report.

You have the ability to save your report before or after running the report.

a. Click the floppy disk icon to name and save the report.

b. You can also click the Trash Can icon to delete saved reports.

c. To edit a Report Name after saving, select the report, then click the Blue Arrow next to the Trash Can.

d. In order to generate a saved report, from the Check Report screen, select the saved report from the pull-down; your report will generate automatically.

The Check Report displays the following columns: Internal indication, Fiscal Year, Check Date, Check #, check Batch, Vendor, Vendor #, E-Verify, Bank, PO #(s), Type of check, E-Pay (Manual, ACH, etc.), check Created By, Reconciled/Cleared indicator, Voided date, check Memo, 1099 Eligible, W9 Eligible, check Amount, ACH Deposit Amount, Printed Check Amount, Manual Entry Amount, MJ #, and MJ Source & Amount.

The Check Line Report displays all of the same columns as the Check Report, but also includes an Invoice Date column, and an Invoice # column.

The Check Allocation Report contains all of the same columns as the Check Line Report, but also contains Accounting Strip elements for each check by invoice, such as Fund, Function, Facility, etc., and the Debit Account and Credit Account.

The E-Verify column indicates whether E-Verify authorization has been obtained to accommodate Florida law regarding contractors doing business with the school district. E-verification is documented via Vendors/Customers > Current Contact tab > General section.

Click the Check # to open Purchasing/Accounts Payable > Checks > View Check Run tab.

Click the PO # to open Purchasing/Accounts Payable > Purchase Requests/Orders > Current Request tab.

Click the MJ # to open Budgeting/General Ledger > Manual Journals.

Click the Invoice # to open Purchasing/Accounts Payable > Invoices > Invoice Lookup tab.

The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.

The grand total Amount is listed at the bottom of the report. The first row lists the Page Total, the second row lists the Grand Total.

1. In the Purchasing/Accounts Payable menu, click Check Report.

2. To generate the Check Report, Check Line Report, or the Check Allocations Report, click the corresponding tab.

3. Select the Graph check box to display interactive charts on the Check Report, providing a visual breakdown of check totals based on the selected filters and report criteria.

4. From the Select Graphs to Display pull-down select the graphs you want to include in the report output. The available graph options may vary depending on the selected report and the districts configuration, such as By Cntr, By Func, etc.

5. Click Bar to display the report graphs as bar charts. Bar charts are the default graph view and provide a visual comparison of the report data based on the selected filters.

6. Click Circle to display the report graphs as pie charts instead of bar charts. The charts provide a visual breakdown of the report data based on the selected filters and can be used to quickly analyze totals by vendor, category, or accounting strip elements, depending on the report.

The reports display number of checks and total amount.

The report also displays charts based on the graphs selected in the Select Graphs to Display pull-down. Note: The available graphs depend on the district's account element configuration, such as fund, function, or other budget elements.

By Vendor: Displays check amounts grouped by vendor.

By Bank: Displays check amounts grouped by bank.

Hover over any chart to view additional details, such as the vendor or bank name and the corresponding check amount. Depending on the selected graph, additional information may also be displayed for configured account elements, such as fund, function, project, or center.

The report displays additional account graphs, such as By Type, By Fund, By Func, By Objt, By Revn, etc.

Hover over any of the charts to view additional information, such as function and amount.

The Monthly Trend report displays check amounts by month based on the selected report filters, allowing you to analyze payment activity over time.

Hover over points in the graph to display amount by month.

7. Click the eye icon to hide the report.

a. To display the report again, you must select the report from the Select Graphs to Display pull-down.

The last report displays the standard report view, such as the Check Report or Check Line Report, depending on the selected report type. This view shows the full data table without graph visualization.

8. Click any of the data points or chart elements to filter the report and update all associated summaries, charts, and tables. For example, selecting a vendor such as Allstate Construction Inc. will filter the report to display only transactions and totals associated with that vendor, including check amounts.

a. Select additional filters, such as a specific project, to refine the report and display only checks associated with the selected project. All previously selected filters remain applied, further narrowing the report results within the existing criteria.

BEFORE

AFTER

b. To remove a filter from the report, click the applied filter again, such as Allstate Construction Inc in By Vendor. The selection is cleared and all reports update to display all vendors.

Allstate selected:

Allstate cleared:

c. All active filters applied to the report display at the top of the screen. Click Clear all to  remove all filters at once.

See Additional Features for details on filtering, exporting, printing, page size, etc.