Funds Ledger Report - File Layout and Data Mapping

A

START PERIOD

The beginning accounting period for the report date range. Represents the fiscal period number (1-13) from which the report calculations begin.

Retrieved from the Start Period field on the IN Funds Ledger Report page.

B

START YEAR

The beginning fiscal year for the report date range. The year when the reporting period starts (e.g., 2024).

Retrieved from the Start Year field on the IN Funds Ledger Report page.

C

END PERIOD

The ending accounting period for the report date range. Represents the fiscal period number (1-13) through which the report calculations run.

Retrieved from the End Period field on the IN Funds Ledger Report page.

D

END YEAR

The ending fiscal year for the report date range. The year when the reporting period ends. Can be the same as or different from the start year for multi-year reports.

Retrieved from the End Year field on the IN Funds Ledger Report page.

E

FUND

The fund code from your general ledger system. Identifies the specific fund for which financial activity is being reported.

Retrieved from the Fund field on the IN Funds Ledger Report page.

F

FUND TITLE

The descriptive name or title associated with the fund code. Provides a clear and concise description of the fund's purpose.

Retrieved from the Title field on the Organization Chart page.

G

BEGINNING BALANCE

The cash balance at the start of the reporting period (i.e., before the beginning of the period).

The valid value is calculated from transaction records before the report start date.

H

CURRENT PERIOD RECEIPTS

Revenue received during only the current/ending period of the report. Shows receipts for the final period only within the specified date range.

The valid value is the sum of expy (ending period) for all revenue transaction records for the fund except those identified as transfer in accounts.

I

CURRENT PERIOD EXPENDITURES

Expenses incurred during only the current/ending period of the report. Shows expenditures for just the final period in the date range.

The valid value is the sum of expx (beginning period) through expy (ending period) for all expenditure ledger records for the fund, excluding those identified as transfer out accounts.

J

PERIOD SPAN RECEIPTS

Total revenue received across the entire date range, from the start period/year through the end period/year - cumulative receipts for all periods in the report span.

The valid value is 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.

K

PERIOD SPAN EXPENDITURES

Total expenses incurred across the entire date range, from the start period/year through the end period/year - cumulative expenditures for all periods in the report span.

The valid value is the sum of expx (beginning period) through expy (ending period) for all expenditure ledger records for the fund, excluding those identified as transfer out accounts.

L

PERIOD SPAN TRANSFER IN

Total transfers into the fund from other funds during the entire report period span. Based on the transfer accounts defined on the IN Funds Ledger Report - Transfer Setup page.

The valid value is the sum of expx (beginning period) through expy (ending period) for revenue transaction records for those records that are identified as transfer in accounts.

M

PERIOD SPAN TRANSFER OUT

Total transfers out of the fund to other funds during the entire reporting period. Based on the transfer accounts defined in the Transfer Setup page.

The valid value is the sum of expx (beginning period) through expy (ending period) for expenditure ledger records for those records that are identified as transfer out accounts.

N

ENDING BALANCE

The final cash balance at the end of the reporting period.

Calculated as:

Beginning Balance + Period Span Receipts - Period Span Expenditures + Period Span Transfer In - Period Span Transfer Out