REPORTING @ ANU - PowerPoint PPT Presentation

Reporting @ anu l.jpg
Download
1 / 33

REPORTING @ ANU June 2008 Reporting @ ANU – this course covers: Brief introduction to Accounting The General Ledger Structure at ANU Allocation of the Operating Grant in the ANU Ledger University-wide Reporting and Local Area Reporting The nVision Financial Management Reporting Statement

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

REPORTING @ ANU

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Reporting @ anu l.jpg

REPORTING @ ANU

June 2008


Reporting @ anu this course covers l.jpg

Reporting @ ANU – this course covers:

  • Brief introduction to Accounting

  • The General Ledger Structure at ANU

  • Allocation of the Operating Grant in the ANU Ledger

  • University-wide Reporting and Local Area Reporting

  • The nVision Financial Management Reporting Statement

  • SPF Unspent Funds Report


Brief introduction to accounting l.jpg

Brief Introduction to Accounting

  • This will cover ..

    - The Accounting Cycle

    - Types of Financial Statements

    - Accrual Accounting

    - Reporting – Financial & Management Accounting


Brief introduction to accounting4 l.jpg

Brief Introduction to Accounting

The Accounting Cycle

The Accounting cycle that applies to all businesses and organisations who use accounting information to aid decision making includes the following steps:

  • recognise and record transactions

  • Journalise transactions

  • Post to accounts which are contained in ledgers

  • Prepare trial balance of general ledger

  • Prepare financial statements


Brief introduction to accounting contd l.jpg

Brief Introduction to Accounting contd.

The Accounting Cycle contd.

In the University context, our accounting cycle is example the same:

  • transactions are recognised and recorded by accounts processing staff;

  • Transactions are journalised and posted to accounts in the ledger through the use of ESP Financials; and

  • Staff at F&BS as well as College Finance Staff and local departmental administrators prepare financial statements.

    The information generated during this process is presented in different ways to enable users in decision-making.


Brief introduction to accounting contd6 l.jpg

Brief Introduction to Accounting contd.

Types of Financial Statements

The generic Financial Statements produced by most accounting systems are:

  • Balance Sheet

  • Income Statement

  • Cash Flow Statement

    The Balance Sheet and Income Statement are usually prepared on an Accrual basis.

    The Cash Flow Statement is prepared on a Cash basis – cash received and cash spent.


Brief introduction to accounting contd7 l.jpg

Brief Introduction to Accounting contd.

Accrual Accounting

What is accrual accounting?

Revenue and expenses reported for an accounting period are the revenue earned and expenses matched to or incurred in generating that income – regardless of whether the income has actually been received or cash paid for the expenditure.

For Example

Where we have performed some work for a client and invoiced this client, we would include this revenue in our reporting for the period, regardless of whether we have actually received payment or not. On the expense side, we would include expenses such as electricity and gas consumed during the period even if the bill is not due for payment until the following period.


Brief introduction to accounting contd8 l.jpg

Brief Introduction to Accounting contd.

So why are some reports cash and some accrual?

It really depends on the needs of the users.

Reporting Types

There are two types of accounting or reporting:

  • Financial Accounting

  • Management Accounting


Brief introduction to accounting contd9 l.jpg

Brief Introduction to Accounting contd.

Financial Accounting

- usually deals with accounting/reporting for external users and is compliant with relevant accounting standards and legislation. An example would be the ANU Annual Financial Statements that are tabled in Parliament.

Management Accounting

- usually deals with accounting/reporting for internal users such as management, executive etc. There is a lot more flexibility and it can be accrual or cash-based depending on the needs of the users of the reports. Examples in the ANU context would be our SPF reports and our recurrent reports.


The general ledger structure at the anu l.jpg

The General Ledger Structure at the ANU

University Budget Units

The University has implemented a College-based Structure to better align the interests and collaborations across academic units.

The seven University Colleges are:

ANU College of Arts and Social Sciences

ANU College of Law

ANU College of Medicine and Health Sciences

ANU College of Asia and the Pacific

ANU College of Science

ANU College of Engineering and Computer Science

ANU College of Business and Economics

The University General Ledger operates on the Peoplesoft ESP Financials system.


The general ledger structure at the anu11 l.jpg

The General Ledger Structure at the ANU

For budgeting and planning purposes, the University is organised into budget units representing all sectors of the University structure including:

  • Institute of Advanced Studies

  • The Faculties

  • University Centres

  • Division of Information

  • Administrative Divisions

  • Academic Support

  • Property Costs

  • Other Central Activities

    Budget Unit delegates (Directors, Deans, Administrative Heads) are responsible to the Vice-Chancellor for setting the budget and subsequently accounting for performance against the budget.

    University Business Units and Full Fee paying programs are subject to their own budgeting process based on the nature of their trading activities.


The general ledger structure at anu l.jpg

The General Ledger Structure at ANU

General Ledger Structure

Within ESP Financials the General Ledger structure has three streams. The ledger structure for each stream is identical, however each has a distinct purpose.

  • Actuals Ledger

    The ledger through which cash transactions for the current reporting period are processed (where current refers to the current financial year). This ledger includes encumbrances, commitments for the current and future reporting periods, pending the actual transacting of this commitment.

  • Financials Ledger

    The ledger through which non-cash (or accrual) transactions for the current reporting period are processed (e.g.. Depreciation).

  • Std_Budget Ledger

    Establishes and maintains the budget for the university for each reporting period.


The general ledger structure at anu13 l.jpg

The General Ledger Structure at ANU

Ledger Location Structure

AccountFundDepartmentProject/Grant

NNNNANNNNNXXXX

The account structure comprises four main components:

  • Account

  • Fund

  • Department

  • Project


The general ledger structure at anu14 l.jpg

The General Ledger Structure at ANU

Account

This is the ‘natural account code’ and is a four-digit numeric field (it may have a fifth digit alpha for classification).

There is a Chart of Accounts available on the Finance and Business Services web site. This can be found at:

http://info.anu.edu.au/fbs/Publications/Chart_of_Accounts/index.asp

There is also a download of Natural Account Codes in ESP, which provides information such as Account, Account Description, Budget Code etc. These downloads can be found by using the following navigation:

Go, Define Business Rules, Design Chartfields, Report, Account Download

More information is available at:

http://info.anu.edu.au/fbs/Training_and_Support/__News_and_Tips/_2005/Acct_DL.pdf


The general ledger structure at anu15 l.jpg

The General Ledger Structure at ANU

Fund

This is the alpha ledger segment code, denoting fund source:

R – Recurrent

F – Fees

S – Special Purpose Funds where funds are held contractually by the University for external parties

Q – Special Purpose Funds where funds owned by the University

E – Endowment

T – University Business Units

C – Capital

# - Superannuation Reserve


The general ledger structure at anu16 l.jpg

The General Ledger Structure at ANU

Department

This is a five digit alpha-numeric field.

College identifiers are:

CA - College of Arts and Social Sciences

CC - College of Business and Economics

CE- College of Engineering and Computer Science

CH- College of Medicine and Health

CL- College of Law

CP- College of Asia and the Pacific

CS- College of Science

Project

This is a compulsory field for S, Q and E funds. The accepted norm is a two to four digit character and it can be alpha, numeric or a combination. The field is optional for other ledger segments.


The general ledger structure at anu17 l.jpg

The General Ledger Structure at ANU

Relationships of the Account & Code Components

Natural accounts and summary codes

Natural accounts are rolled up to various summary codes that are used in the preparation of the University’s annual financial statements. These summary codes then roll up to the various budget class categories.

Illustration:

BC01 Salaries and Related Costs

S3100 Academic Staff Salaries

5001 Salary Academic Continuing

5001V Salary Academic – Visiting Fellows

5003 Salary – Casual Sessional Academic

5003A Sal P/T Teach Savings

Actual transactions cannot be processed against budget class accounts (with the exception of BC15 – Operating Grant – and BC20 – Prior Year Result).

It is possible to drill down in the recurrent budget reports from budget class to summary code and then down to natural account code detail.


The general ledger structure at anu18 l.jpg

The General Ledger Structure at ANU

Departments and Project Grants

Project codes are related to a particular department. A department can have a number of different project codes sitting underneath it. Reports can be run at the Project level, at the Department level incorporating all Project under the department or with only departmental information.

Illustration:

Department

F&BS

R24100 – Admin Department

R24103 – Printery

R24600 – Chancelry Services

Department (incorporating Project)

F&BS

R24100 – Admin Department

R24100 01 – Ledgers

R24100 02 - SPF


The general ledger structure at anu19 l.jpg

The General Ledger Structure at ANU

Departments and Budget Units

Department ranges within a Budget Unit are rolled up to the Budget Unit level. Budget Units are rolled up to Sectors.

Reports can be obtained at the Budget Unit level, for every active department within that Budget Unit, and for every active project within each department.

Illustration:

ADMIN -Administrative Divisions(SECTOR)

HR – Human Resources(Budget Unit)

22000-22ZZZ(Departments)

F&S – Facilities & Services

23000-24ZZZ

F&BS – Finance & Business Services

24000 – 24ZZZ


The general ledger structure at anu contd l.jpg

The General Ledger Structure at ANU Contd.

  • nVIsion reports can be run for an entire Budget Unit using the tree node with the budget unit description. E.g. – F&BS will provide a consolidated financial report for all valid departments and project within the recorded department range (e.g. 24000 – 24ZZZ)

  • The organisation tree structure was established to mirror the actual operational structure of the University as opposed to the formal academic structure of the University that is represented by Academic Organisational Unit (AOU) codes.


The general ledger structure at anu contd21 l.jpg

The General Ledger Structure at ANU Contd.

Use of ‘Budget Class’ (BC) Accounts

Account codes roll up into various Income and Expenditure Budget Classes. For example, all the salary and oncost account codes, such as 5001 through to 5097, roll up into BC01.

Budget Class Codes

Expenditure

BC01Salaries and Related Costs

BC02Equipment

BC03Scholars Expenses

BC04Other Expenses

BC05Travel, Field and Survey

BC06Equipment – Non-Capital

BC07Expendable Research Materials

BC08Transfers to Other

BC09Contingency


The general ledger structure at anu contd22 l.jpg

The General Ledger Structure at ANU Contd.

Budget Class Codes contd.

Income

BC10Student Fees

BC11Other Income

BC12Internal Sales

BC13Transfers from Other

BC14Internal Allocations

BC15Operating Grant (RTB)

BC16Investment Income

Current Year Operating Result

BC19Operating Result

Prior Year Result

BC20Prior Year Result


University wide and local area reporting l.jpg

University Wide and Local Area Reporting

Recurrent budget reporting is performed on a cash basis in the ACTUALS ledger, while the University’s annual financial statements are prepared on an accrual basis. The main difference between the two types of reporting at the University is that transactions in the FINANCIALS ledger appear in the annual financial statements and do not appear in recurrent budget reporting. Financial transactions include, but are not limited to, depreciation, provisions (doubtful debts, long service leave, recreation leave etc) and other ‘year end’ entries such as prepaid and accrued expenditure and accrued revenue.

The financial transactions are recorded at the local Budget Unit level (in the financials ledger), however, areas are not required to manage these costs as part of their budget responsibilities. The transactions will not show on any recurrent nVision financial reports and as such do not affect the cash position. Some reports allow for the optional inclusion of these transactions.


University wide and local area reporting24 l.jpg

University Wide and Local Area Reporting

Financial activity of all budget units impacts on the University’s annual financial statements (Income Statement, Balance Sheet and Statement of Cash Flows), but reports on recurrent budget expenditure are not presented in these formats.

The Financial Management Report (FMR) is a ‘hybrid’ report, taking on some concepts from the Income Statement (cash income and expenditure), Balance Sheet (cash carry forward – almost like accumulated results + capital expenditure) and encumbrances (cash accruals).

Recent University Recurrent Budget reports can be found at:

http://info.anu.edu.au/fbs/Finance_Functions/__Financial_Reporting/__Recurrent_Budget_Reports/Index.asp


University wide and local area reporting25 l.jpg

University Wide and Local Area Reporting

Usefulness of reports

All reports produced from the ESP Financials system contain information that is in the system at the time the reports are run. The usefulness of reports containing budget information depends on how budgets are entered and updated.

It is therefore important to enter accurate and meaningful information into the budget ledger. If inaccurate or unachievable figures are entered then the reports produced will be ineffective in highlighting variances or identifying budget trends as well as supplying a misleading picture of the budget unit.

Often individual budget units have different levels of reporting requirements. Some budget units need to report down to a project level whereas other areas need only report down to the department level. The budgets entered into the system need to reflect these differences. If the project level of reporting is required then budgets (both income and expenditure) must be allocated down to the project level.


University wide and local area reporting26 l.jpg

University Wide and Local Area Reporting

Encumbrances/Commitments and the effect on reports and budgets

Encumbrances are a useful way of formally recording, in the ledger, commitments an area has against a budget for future expenditure.

Encumbrances in the financial system show what future expenditure is expected to be made against a particular expense line, and reduces available funds accordingly.

The most significant encumbrance for many budget units is that generated by the ESP Human Resources (ESP HR) payroll system. ESP HR will automatically generate salary encumbrances for full-time staff and permanent part-time staff. The salary encumbrance will calculate the remaining salary cost until the end of a year. As actual expenditure is incurred, the ESP HR system automatically recalculates the encumbrance each pay period so as not to duplicate expenditure. In respect of casual staff, budget units need to discuss their options with the ESP HR team for encumbrance creation.

Encumbrances created through purchase orders are automatically reversed by linking the payment voucher to the purchase order (i.e. using PO Vouchers).

Manual encumbrance journals must either have the auto reverse option selected or be reversed manually, once the costs have been incurred. It is important to ensure that once costs have been incurred, they are not also reflected in the encumbrances.


University wide and local area reporting contd l.jpg

University Wide and Local Area Reporting contd.

Encumbrances should be entered into the ESP Financial system. They should NOT be added to reports manually ‘off-line’.

Ifencumbrances are not formally recorded in the ESP Financials system, users who are examining information directly from the system will come to a different conclusion about the financial performance of an area compared to those users who have a report that has had encumbrances added off-line (i.e. after the report was run from the system).


The nvision financial management reporting statement or recurrent budgetary report l.jpg

The nVision Financial Management Reporting Statement or Recurrent Budgetary Report

For a Budget Unit, nVision Financial Management Reporting Statements provide a standard Income and Expenditure Statement (for Budget, Actual and Encumbrance classifications)

This report can be produced at varying levels

·        - For the Budget Unit as a total;

·        - For each Department within a budget unit; and

·        - For each Project within each Department.

Recurrent Budgetary Reports can be found at:

http://info.anu.edu.au/fbs/Finance_Functions/__Financial_Reporting/__Recurrent_Budget_Reports/Index.asp


The nvision financial management reporting statement or recurrent budgetary report29 l.jpg

The nVision Financial Management Reporting Statement or Recurrent Budgetary Report

Contents of the nVision Financial Management Reporting Statement or Recurrent Budgetary Report

The statement contains income and expenditure information for the following

categories, displayed in rows:

IncomeFor the Current Year

ExpenditureFor the Current Year

Current Year Operating ResultIncome less Expenditure

Prior Year Cash ResultActual Result from Prior Year

Net Operating PositionCurrent Year Operating Result +/-

Prior Year Result


The nvision financial management reporting statement or recurrent budgetary report contd l.jpg

The nVision Financial Management Reporting Statement or Recurrent Budgetary Report contd.

For each category, there are seven columns, which display numerical information:

Column

Details

1Movement for PeriodActual Transactions for most recent period only

2BudgetThe budget information that has been loaded into the system(Final Scenario)

3YTD MovementThe total of actual transactions recorded so far in this accounting year

4Outstanding Encumbrances/commitments that have either been system generated

Encumbrances(e.g. from HR system) or input manually

5Total – YTD MovementActual transactions + encumbrances

+ Encumbrance

6VarianceThe difference between Budget and YTD Movement and encumbrances

This is the amount of available funds

7% total to Budget – 5/2Percentage received/expended compared to budget for full year


The nvision financial management reporting statement or recurrent budgetary report contd31 l.jpg

The nVision Financial Management Reporting Statement or Recurrent Budgetary Report contd.

Inclusion of Salary Information

The report can be produced with or without a payroll analysis. The payroll analysis comprises a payroll summary which identifies all the salary transactions for the period that make up the balance of ‘Salaries and Related Costs’ and ‘Scholars Expenses’ on the nVision report.


Special purpose discretionary fund net and overspent balances report l.jpg

Special Purpose & Discretionary Fund Net and Overspent Balances Report

Financial Management reports can also be run for Special Purpose Funds, although these are reported on a whole of life or life to date basis and not periodically.

The Special Purpose & Discretionary Fund Net and Overspent Balances report can be found in Section P of the periodic Recurrent Budgetary Report. This report shows the overspent balances for Q and S funds by college.

A more detailed report is also run by the Special Purpose Funds (SPF) Section of Finance & Business Services, which lists overspends for all projects. This report is distributed by SPF on a regular basis.


Further training l.jpg

Further Training

Finance & Business Services also run the following courses:

  • Budgeting @ ANU

  • Expenditure & Contracts @ ANU

    These are run for specific groups of staff in colleges or schools – please contact Mardi Savill (mardi.savill@anu.edu.au or 55587) for more information and to make a booking.

    Finance & Business Services Business Solutions Office can also provide training on ESP Financials.

    Further information can be found at:

    http://info.anu.edu.au/fbs/Training_and_Support/__Courses_and_Seminars/index.asp


  • Login