What This Report Shows
This report includes all three account types (revenue, expenditure, balance sheet). Amounts reflect posted figures plus beginning balances through the selected fiscal month. Budgetary control codes can be optionally excluded. These are Balance sheet codes with reference type of Appropriation, Estimated Revenue and Fund Balance-Budgetary Control. This report will show the account description, the account code, and the debit or credit balance of each account.
Best Practices
- Monthly Report - Recommend running this report on a monthly basis.
- Matching - Total debits and credits for each fund should agree.
General Ledger Mixed Account Types Report
- Finance → Financial Management → Reports → Summary → Combined Account Type → G/L Mixed Account Types
- From the Select and Range tab, enter the fiscal month and year.
- Click the Run Report (Process wheel).
| FIELDS | Opt. | Rec. | Req. | Description |
|---|---|---|---|---|
| Select Fiscal Year | — | — | ♦ | The fiscal year selected for viewing |
| Selected Fiscal Month | — | — | ♦ | The fiscal month selected for viewing |
| Exclude Budgetary Controls | ♦ | — | — | You may exclude the budgetary control accounts for Appropriations, Estimated Revenue and Fund Balance by flagging this boolean |
| Fund Classification | ♦ | — | — | Governmental, Proprietary, Fiduciary and Account groups may be chosen |
| Fund Type | ♦ | — | — | Various fund types may be selected such as Governmental |
| Fund Group | ♦ | — | — | The group number assigned to each fund |
| Fund | ♦ | — | — | Fund numbers assigned to the accounts you want to report on |
| Account Manager | ♦ | — | — | The account manager assigned to a group of accounts |
| Grant ID | ♦ | — | — | The grant ID assigned to a group of accounts |
| Opt. = Optional Rec. = Recommended Req. = Required | ||||