Fund Balance Report

Contents

1 Overview

2 Detail Report

3 Summary Report

4 How-to

5 Detail Report Fields

6 Summary Report Fields

Field Name

Path to data field

Table/ Field ID

Dimension Code

N/A

SYS-FFASAD-ACCT-DTL. FFAACT-HEADING

Dimension Value

Financial Mngmnt / Account Mngmt / Codes / Account Desc

FFAMAD-ACCT-DESCS. FFAMAD-CODE

Account Description

Financial Mngmnt / Account Mngmt / Codes / Account Desc

FFAMAD-ACCT-DESCS. FFAMAD-SDESC

Beg Balance

Financial Mngmnt / Chart of Accounts

FFAMFA-FIS-YTD. FFAMFA-BEG-BALANCE

Revenue

Financial Mngmnt / Chart of Accounts

Calculated field:

Total Revenue activities posted to the current summary account for the specified period

Transfers

Financial Mngmnt / Chart of Accounts

FFAMFA-FIS-YTD. FFAMFA-TRANSFERS

Expenditures

Financial Mngmnt / Chart of Accounts

Calculated field:

Total Expenditure activities posted to the current summary account for the specified period

End Balance

Financial Mngmnt / Chart of Accounts

Calculated field:

Beg Balance – Revenue + Transfers + Expenditures

Detail Balance

Financial Mngmnt / Chart of Accounts

Calculated field:

FFAMFA-FIS-YTD.BEG-BALANCE +

FFAMFA-FIS-YTD.

WA-DEBITS -

FFAMFA-FIS-YTD.WA-CREDITS