Funds Ledger Report
Use the Funds Ledger Report to report the following fund information for a specified year and period:
Beginning balance
Current period receipts and expenditures
Period span receipts and expenditures
Period span transfer in and transfer out totals
Ending balance
Menu path
From the Fund Accounting menu, select State. From the State - IN menu, select Funds Ledger Report.
Submission period
The auditors require the report. Audits are individually scheduled with the school districts. Most audits are scheduled during the third quarter, but may also occur in the fourth quarter. Additionally, the report data is utilized by the districts throughout the year; however, submission is not required.
Selection rule
Funds for a specified year and period are selected and reported.
Prerequisite
Complete the Transfer Setup procedure.
Transfer Setup
Use the IN Funds Ledger Report - Transfer Setup page to define account components that identify expenditures or revenues as transfer-in or transfer-out amounts.
On the IN Funds Ledger Report page, select Transfer Setup.
To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
You cannot edit records. To update a record, delete the old record, then add a new one.
Field descriptions
The following table describes the fields on the Funds Ledger Setup form of the IN Funds Ledger Report - Transfer Setup page.
Field | Description |
|---|---|
Year | The year of the funds ledger data. |
Transfer | Indicates whether this ledger setup is for transfers coming into the fund or going out of the fund. Valid values:
|
Local Organization Level | The district organization chart/accounting level. The Organization/Account Level must be the number representing the level on the organization chart or account as defined on the Fund Accounting Profile page. Organization levels will be one more than the organization number. For example, orgn2 = level 3. The titles of the organization levels are retrieved from the titles set up on the Titles tab of the Fund Accounting Profile page. The values in the drop-down are retrieved from the Titles tab of the Fund Accounting Profile page. The values also include the 1st, 2nd, and 3rd sub-accounts. |
Level Value | The value or code for the Local Organization Level. |
Create file
Use the IN Funds Ledger Report page to specify the report criteria and create the report file.
On the IN Funds Ledger Report page, enter or select the following:
Fund
Start Year
Start Period
End Year
End Period
Account Type
If you select O - Other in the Account Type field, enter a general ledger account number. Use the pipe (|) symbol to separate multiple account numbers.
Select PDF or Excel. If you select Excel, select All Information or No Totals.
Select Create, and then Yes.
Save the file and select OK.
Navigate to the folder containing the report file.
Inspect the file. Refer to Transfer Setup and update it as necessary.
Repeat these steps until all the required data is included.
The default file names are:
Excel: IN Funds Ledger Report_<MMDDYYYY_hhmmss>.csv
PDF: IN Funds Ledger Report_<MMDDYYYY_hhmmss>.pdf
For detailed information about the report’s file layout, refer to Funds Ledger Report - File Layout and Data Mapping.
Calculation of Receipts and Expenditures
Current Period Amounts
Receipts - the sum of expy (ending period) for all revenue transaction records for the fund except those identified as transfer in accounts.
Expenditures - the sum of expx (beginning period) through expy (ending period) for all expenditure ledger records for the fund except those identified as transfer out accounts.
Period Span Amounts
Receipts - the sum of expx (beginning period) through expy (ending period) for all revenue transaction records for the fund except those identified as transfer in accounts.
Expenditures - the sum of expx (beginning period) through expy (ending period) for all expenditure ledger records for the fund except those identified as transfer out accounts.
Period Span Transfers
Transfer In - the sum of expx (beginning period) through expy (ending period) for revenue transaction records for those records that are identified as transfer in accounts.
Transfer Out - the sum of expx (beginning period) through expy (ending period) for expenditure ledger records for those records that are identified as transfer out accounts.