User Tools

Site Tools


Sidebar

Table of Contents

finance:reports:financereports:summarymiscellaneousreports:workingtrialbalanceusingtransactions

FIN3220 - Working Trial Balance Using Transactions

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

This report is used to print a trial balance and the schedules using transactions. For the Schedule and Exhibit reports to display, option 2 must be selected for the Main report (1) or the rest of reports (2) parameter.

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

Parameter Parameter Description
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

As of Date (MMDDYYYY) for the reportType the as-of date in the MMDDYYYY format. This is a required field.
From Accounting Period 1 (MM)Type the two-digit from accounting period. This is a required field.
To Accounting Period 1 (MM)Type the two-digit to accounting period. This is a required field.
Fiscal Year 1Type the last digit of the fiscal year. This is a required field.
From Accounting Period 2 (MM)Type the two-digit from accounting period.
To Accounting Period 2 (MM)Type the two-digit to accounting period.
Fiscal Year 2Type the last digit of the fiscal year.
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/workingtrialbalanceusingtransactions.txt · Last modified: 2020/08/19 20:53 by emoreno