User Tools

Site Tools


Sidebar

Table of Contents

finance:reports:financereports:journalschecksdetailledgers:yeartodatecheckpaymentslist

FIN1750 - Year-to-Date Check Payments List

Finance > Reports > Finance Reports > Journals, Checks, Detail Ledgers > Year to Date Check Payments List

The report prints information useful for year-end audits. Data is selected based on date range. The report displays check transactions processed and unprocessed. Report information is displayed based on the masked account codes set in the User Profiles table for the logged-on user.

Parameter Parameter Description
YTD only (Y), YTD and Current Month (C), YTD, Current and Next Month (A), Acct Per only (01-12)

Y - Include records with a process date on the report.

C - Include reports with a process date and a current accounting period with an open processing date on the report.

A - Include all records on the report.

01-12 - Include a specific accounting month (e.g., 09) on the report.

This is a required field.

Sort by Ck#/Acct (1), Acct/Ck# (2), Vendor#/Ck#/Acct (3), Vendor#/Acct/Ck# (4)

1 - Sort the report by check number, and then by account.

2 - Sort the report by account, and then by check number.

3 - Sort the report by vendor number, check number, and then by account.

4 - Sort the report by vendor number, account, and then by check number.

This is a required field.

Include Reversal Transactions? (Y/N), or Voided Checks only (V)

Y - Include reversal transactions on the report.

N - Do not include reversal transactions on the report.

V - Include only voided checks on the report.

This is a required field.

Select Computer Written Checks (C), District Written Checks (D), Both (B)

C - Include only computer-written checks on the report.

D - Include only district-written checks on the report.

B - Include both computer-written and district-written checks on the report.

This is a required field.

Include Payroll Deduction Checks? (Y/N)

Y - Include payroll deduction checks on the report.

N - Do not include payroll deduction checks on the report.

This is a required field.

Print Publish Report Only? (Y/N)

Y - Print a condensed version of the report with no account information.

• If you type Y and select sort option (1) or (2), the report is sorted by check number.

• If you type Y and select sort option (3) or (4), the report is sorted by vendor number, and then by check number.

Note: When this parameter is set to Y, unpaid checks are not included on the report regardless of the selection in the Select Paid checks (P), Unpaid checks (U), or blank for ALL parameter. This report is designed to be publicly posted on LEA websites; therefore, should not include checks that have not been officially paid.


N - Print a full version of the report.

This is a required parameter.

Include ONLY EFT Payment? (Y/N)

Y - Include only electronic funds transfer payments on the report.

N - Do not include only electronic funds transfer payments on the report.

Include Reason in the Publish Report? (Y/N)

Y - Include the reason on the report.

N - Do not include the reason on the report.

This is a required field when Print Publish Report Only? (Y/N) is set to Y.

Select Paid checks (P), Unpaid checks (U), or blank for ALL

P - Include only paid checks on the report.

U - Include only unpaid checks on the report.

Blank - Include both paid and unpaid checks on the report.


Note: When the Print Publish Report Only? parameter is set to Y, unpaid checks are not included regardless of the selection in this parameter. This report is designed to be publicly posted on LEA websites; therefore, should not include checks that have not been officially paid.

Select Vendor(s), or blank for ALL

Type the five-digit vendor number, including all leading zeros and separating multiple vendor numbers with a comma (00126, 01260). Or, click Ellipsis Icon search for vendor numbers to search for vendor numbers. Otherwise, leave blank to use all vendor numbers.

Select Bank Account Group(s), or blank for ALL
Select Fund(s), or blank for ALL

Type the three-digit fund number separating multiple fund numbers with a comma (e.g., 161 / 8,199 / 8). Or, click Ellipsis Icon to search for funds/years. Otherwise, leave blank to use all fund numbers.

Enter significant digits for fields to select on

Type the account code numbers or account code number mask separating multiple account code numbers with a comma (e.g., 199-XX-XXXX.XX-XXX-XXXXXX, 224-XX-XXXX.XX-XXX-XXXXXX). Or, click Ellipsis Icon to create an account code mask. Otherwise, leave blank to use all account codes.

From Date (MMDDYYYY), or blank for ALLType the from date in the MMDDYYYY format, or leave blank to use all from dates.
To Date (MMDDYYYY), or blank for ALLType the to date in the MMDDYYYY format, or leave blank to use all to dates.
From Check Nbr, or blank for ALLType the from check number, or leave blank to use all from check numbers.
To Check Nbr, or blank for ALLType the to check number, or leave blank to use all to check numbers.

Generate the report.

finance/reports/financereports/journalschecksdetailledgers/yeartodatecheckpaymentslist.txt · Last modified: 2021/07/12 17:02 by emoreno