190 likes | 281 Views
Banner2000 Finance. Chart of Accounts. Objectives. Performance objective: Create, modify, and query Chart of Accounts Produce reports for Chart of Accounts Query financial data Produce financial reports. Objectives. Task objectives:
E N D
Banner2000 Finance Chart of Accounts
Objectives Performance objective: • Create, modify, and query Chart of Accounts • Produce reports for Chart of Accounts • Query financial data • Produce financial reports
Objectives Task objectives: • Explain the features, concepts and functional requirements of the Banner2000 Chart of Accounts module • Discuss the data requirements for the Chart of Account module’s forms • Perform Chart of Accounts validation activities • Review the results of the Chart of Accounts validation activities
Overview FOAPAL information • Account index • Chart code • Fund • Organization • Account • Program • Activity • Location Financial Management Information
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Account Index Code • Entered on Account Index Code Maintenance Form (FTMACCI) • Shortcut or alias • Can “pop in” all or part of FOAPAL string • Increases data entry accuracy
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Chart Code • Entered on Chart of Accounts Code Maintenance Form (FTMCOAS) • One character (alphanumeric) • Used for separate financial entities • Transactions between Charts allowed • Chart code can be automatically populated
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Fund Code • Entered on Fund Maintenance Form (FTMFUND) • Up to six characters allowed • Self-balancing set of accounts • Shows ownership of cash or fund balance • Can automatically populate other elements of Chart
Sample Fund Hierarchy 2000 - Restricted Funds Fund Group 2100 - Fed Restricted Non-Fed Restricted Sub-Fund Group 2105 - NIH 2110 - Nat Sci Found 2201- A Found 2212 - Kodak Sub-Fund Group 211421 211422 22143 - Kodak G 2212 - Kodak A Sub-Fund Group 211421 211422 211423 Individual Funds
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Organization Code • Entered on Organization Maintenance Form (FTMORGN) • Allows up to 8 levels of hierarchy • Can automatically populate other elements of the Chart
Sample Org Hierarchy 1 - President Presidential Level 10 - VP HR 20 - VP Finance VP Level 100 Bus School 110 Arts 200 - Personnel 210 - Acctng Dean Level 11001 - Econ 11002 - History 11003 - Soc Dept Level
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Account Code • Object code or sub-account • Identifies type of account (asset, expenditure, etc.) • Allows up to four levels of hierarchy • Can use hierarchies for pooling budgets
Sample Account Hierarchy 600 - Supplies/Svcs Account Level 1 6001- Supplies 6002- Services Account Level 2 6100 - Office Supplies 6200 -Computer Supplies 6300 - Computer Repair 6400 - Installation Account Level 3 Account Level 4 61010 - Envelopes 61020 - Pens 61030 - Staplers
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Program Code • Functional classification of revenues/expenditures • Defines NACUBO functions (Instruction, Research, etc.) • Can cut across organization boundaries
Sample Program Hierarchy 1 - Instruction Program Level 1 10 - Undergraduate 20 - Graduate Program Level 2 100 - Biology 110 - Business 200 - Law 210 - Accounting Program Level 3 Program Level 4 2002 - Env Law 2001 - Crim Justice
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Activity Code • Typically used to account for special projects or events • Can cut across organization boundaries • May be de-centrally maintained.
FOAPAL Information Required Optional Account Index Chart Fund Org Account Program Activity Location • Location Code • Identifies physical locations • Used in the Fixed Assets, Stores Inventory, and Research Accounting Modules
Sample Location Hierarchy 002 - East Campus Location Level 1 100 - Research Dept 200 - Computer Lab Location Level 2 1001 Lab1 1002 Lab2 2001- Station A 2002 - Station B Location Level 3 10021 TS 1 10022 TS 2 20021 PC1 20022 PC2 Location Level 4 100221 SFA 100222 SFB Location Level 5
Financial Management Information Financial management of the Chart of Accounts • Specify a financial manager • Verify currency and installation control forms are designed for your Chart of Accounts
Summary • Create, modify and query the Chart of Accounts • Produce reports for the Chart of Accounts • Query financial data • Produce financial reports