User Tools

Site Tools


Sidebar

Table of Contents

finance:reports:financereports:summarymiscellaneousreports:workingtrialbalance

FIN3200 - Working Trial Balance

Finance > Reports > Finance Reports > Summary/Miscellaneous Reports > Working Trial Balance

The report is used to print a trial balance and the schedules required by the audit section of the Financial Accounting Resource Guide, including the mandated programs schedule.

In order for this report to display properly, there must be a fund type set up in Tables > Account Codes > Fund.

Parameter Parameter Description
Accounting Period Current (C), Next (N)

C - Include the current accounting period on the report.

N - Include the next accounting period on the report.

This is a required field.

As of Date (MMDDYYYY) for the reportType the as-of date in the MMDDYYYY format. This is a required field.
Main report (1) or the rest of reports (2)

1 - Generate the main Working Trial Balance Report.

2 - Generate the other reports to include the following:

Exhibit A-3 (Actual Only)
Exhibit A-3 (Budget Only)
Revenues and Other Resources Schedule
Total Expenditures and Other Uses Schedule
Program Intent Code Schedule
Governmental Funds Exhibit 4-A
Governmental Funds Exhibit 4-B
Proprietary Funds Exhibit 4-C
Proprietary Funds Exhibit 4-D

This is a required field

Exhibit A-3 (Actual only)? (Y/N)

Y - Include the Exhibit A-3 (Actual Only) report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Exhibit A-3 (Actual Only) report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Exhibit A-3 (Budget only)? (Y/N)

Y - Include the Exhibit A-3 (Budget Only) report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Exhibit A-3 (Budget Only) report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Revenues and Other Resources Schedule? (Y/N)

Y - Include the Revenues and Other Resources Schedule report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Revenues and Other Resources Schedule report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Total Expenditures and Other Uses Schedule? (Y/N)

Y - Include the Total Expenditures and Other Uses Schedule report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Total Expenditures and Other Uses Schedule report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Select Fund(s) for Program Intent Code Schedule, blank for ALL Funds, or N for No Report

Type the three-digit fund code separating multiple fund codes with a comma (e.g., 199, 224), or click Ellipsis Icon to search for funds/years. Or, type N to not include the Program Intent Code Schedule report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter. Otherwise, leave blank to use all fund codes for the Program Intent Code Schedule report.

Governmental Funds Exhibit 4-A? (Y/N)

Y - Include the Governmental Funds Exhibit 4-A report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Governmental Funds Exhibit 4-A report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Governmental Funds Exhibit 4-B? (Y/N)

Y - Include the Governmental Funds Exhibit 4-B report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Governmental Funds Exhibit 4-B report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Proprietary Funds Exhibit 4-C? (Y/N)

Y - Include the Proprietary Funds Exhibit 4-C report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Proprietary Funds Exhibit 4-C report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Proprietary Funds Exhibit 4-D? (Y/N)

Y - Include the Proprietary Funds Exhibit 4-D report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

N - Do not include the Proprietary Funds Exhibit 4-D report when the user types 2 in the Main report (1) or the rest of reports (2) report parameter.

Major Funds for Exhibits 4-A and 4-B or Exhibits 4-C and 4-D

Type the three-digit fund code separating multiple fund codes with a comma (e.g., 199, 224). Or, click Ellipsis Icon to search for funds/years. Otherwise, leave blank to use all fund codes for the Governmental Funds Exhibit 4-A, Governmental Funds Exhibit 4-B, Proprietary Funds Exhibit 4-C, and Proprietary Funds Exhibit 4-D reports.

Generate the report.

finance/reports/financereports/summarymiscellaneousreports/workingtrialbalance.txt · Last modified: 2017/08/21 15:31 by emoreno