<-- Table of Contents -->
Glossary


Monitoring Finances: Comparing Results With Budget Projections
Budget Performance Report
How to ...
Create a budget performance report
Develop a flexible chart of accounts




Monitoring Finances: Comparing Results With Budget Projections

When overseeing an organization's finances, a key monitoring task is to compare the actual revenues and expenses with those which were projected in the budget. This information is crucial. Most managers need to take immediate action when revenue is lower or expenses are higher than projected in the budget. Furthermore, you cannot prepare a realistic budget for the next year without comparing this year's budget with the actual results.

Financial monitoring can only be done well by working as a team with your financial manager and by looking at planning and monitoring as unified parts of the same cycle. Both financial and program managers must:

  • Project expenses and revenues during the planning process.
  • Compare actual revenues and expenses with projections while monitoring the project.

The financial planning and monitoring cycle

The financial planning and monitoring cycle usually works as follows:

  • The program and financial managers work together to determine the key planning and monitoring information that is needed from the financial information system.
  • The program and financial managers develop the structure of the chart of accounts, the budget, and the financial reports.
  • During the planning process, the program managers develop a budget that projects the next year's revenues and expenses.
  • The financial managers oversee the accounting system that records the expenses incurred and the revenues generated during the program implementation.
  • The financial managers and /or accounting staff generate the needed reports from the accounting system at regular intervals during the program's implementation.
  • Financial and program managers discuss any shortfalls or excess in revenues or expenses and determine whether any adjustments are needed in program or management activities.
  • Financial and program managers use the financial reports to plan for the next year's budget.

How to ...

Create a budget performance report

A budget performance report allows a manager to monitor actual revenues and expenses against those projected in the budget.

To create a budget performance report, such as the one following, record the information as outlined below.

  • Column A is the description of the category of expense or revenue. It can be as general (using only broad expense or revenue categories) or as specific (such as by line item or operating center) as you need it to be.
  • In Column B, write the budgeted amount for each item.
  • In Column C, write the amount actually spent or earned for this reporting period (usually every three or four months) for this item.
  • In Column D, add the amount in Column C to the total expenditures or receipts for previous periods in this budget. For example, if this is the third quarterly report, you would add the amount in Column C to the Column C amount in the second quarter's report.
  • In Column E, you will estimate, based on the pattern of expenditures and receipts so far, how much you will spend or receive for this item to the end of the budget period. This column may or may not correspond to the amount projected for this period in the budget, depending on whether or not you see any significant differences so far between actual and budgeted figures.
  • In Column F, for each item you will add the amount in Columns D and E, to give you an estimate of the total that you will spend or receive by the end of the budget period.
  • Under expenses in Column G, you will subtract the amount in Column F from that in Column B to give you the difference between the total you had budgeted for the year and the total you estimate you will actually spend. Under revenues in Column G, you will subtract the amount in Column B from that in Column F, which will give you the difference between the total you had budgeted for the year and the total you estimate that you will actually receive.
  • In your original budget, the total revenues will have either equaled or exceeded expenses. That is, in this worksheet, the total for Column B under "revenues" should be equal to or greater than the total for Column B under "expenses". In this worksheet, the totals for Column G are essential for management decisions:
    • If the total for Column G is a negative number (under either Expenses or Revenues), you will have to cut costs or increase revenues somehow for the rest of the budget period so that revenues cover expenses;
    • If the total for Column G is a positive number, you have spent less or received more than projected, so you may have money available for activities that will expand or improve your program.

Budget Performance Report

Name of Program/Operating Center: Project:
Reporting period: Project Number:
Prepared by: Approved by:

Reviewed by:

Accountant
I. Expenses
Category or Line Item Amount Budgeted Spent this Period Spent to Date Projected Spending to Year End Total to End of Year (D+E) Shortfall or Surplus (B-F)
A B C D E F G







TOTALS:





II. Revenues
Type or Source of Income Amount Budgeted Earned this Period Earned to Date Projected Earnings to Year End Total to End of Year (D+E) Shortfall or Surplus (B-F)
A B C D E F G







TOTALS:





End of How to ...



The chart of accounts

The budget, the chart of accounts, and the financial reports are the key elements of a unified financial planning and monitoring information system, and they must all be compatible. The chart of accounts is a numbered list of the categories and line items, which is used to record revenues and expenses; it is the link between the budget developed during the planning process and the financial monitoring system. Financial information and reports will be easy to assemble when you have a chart of accounts that uses the same categories and line items as those in the budget, thus simplifying the preparation of budgets and reports and the comparison of budgets with actual expenses. When an accounting system and its chart of accounts are not well organized, meaningful budgets and reports require extra work.

How to ...

Develop a flexible chart of accounts

A chart of accounts lists every possible type of asset, liability, revenue, and expense, and assigns a number to each "line item" on the list. This is one of the most basic tools of an accounting system. The chart of accounts allows the financial staff and general managers to have accurate information on the sources and uses of financial resources.

Except in very small organizations, managers usually leave the design of the chart of accounts to bookkeepers, but they must be able to judge whether or not the chart of accounts is adequate for the needs of the organization. In order to be useful, a chart of accounts must:

  • Have a separate line item for each type of income or expense that needs to be tracked separately for donors and for management decision making;
  • Use categories and line items that match (in terminology and level of specificity) those in the organizational and project budgets, as well as those in the financial reports required by donors or top management;
  • Provide a breakdown of each expense type according to use. For example, fuel for vehicles should be a separate line from fuel for an operating room generator.

If the chart of accounts has two line items for fuel (one for vehicles in the category of "vehicle operating costs" and the other for warehouse generators in the category "building operating costs"), then the budget should also show line items under these same categories, thus making separate estimates for the fuel needs of vehicles and generators.

Furthermore, although you may purchase the fuel for both these purposes from the same supplier during the same transaction, your accounting system should record this purchase under two separate categories in the financial reports, continuing to make this distinction across the financial management system.

If this rule isn't followed and your financial reporting forms have only one line item for fuel, it will take a lot of extra work to determine how much your program spends to operate its vehicles.

End of How to ...


Example from Liberia - Chart of Accounts


Glossary
<-- Table of Contents -->