Financial Accounts NGOs Guide
Financial Accounts NGOs Guide
Financial Accounts NGOs Guide
Building
Dept.
02
Coordination
01
Furniture Vehicles
project project
03-01 03-02
Metalwork
Dept.
03
38 © Mango 2009
Mango FM1 Course Handbook
Some Solutions
A carefully designed and detailed Chart of Accounts
If the Chart of Accounts is detailed enough, it will be able to cope with different donor
budget formats. For example, the category ‘Transportation’ in an NGO’s Chart of Accounts is
extended to:
Fuel & Lubricants
Vehicle Maintenance
Vehicle Insurance
Public transport
Air travel
Distribution costs…etc
Because this approach provides a very detailed budget it is possible to transfer the
information to any other budget formats as required. The level of detail provides maximum
flexibility.
Include some ‘indirect costs’ as direct project costs in project budgets
Include as many project costs as possible in the project budget, including a share of the
indirect project costs, such as office rent or a percentage of the Director’s salary.
Take care: all costs must be justifiable.
Prepare a ‘funding grid’
A funding grid is a special table which provides an overview of which donor fund is paying for
what part of a budget.
© Mango 2009 39
Mango FM1 Course Handbook
However, Milestone must not assume that it can keep the ‘extra’ USD 2,800 on the Training
line and use it elsewhere in the budget: these funds are restricted and – strictly speaking –
this presents a ‘double funding’ situation.
In this case, Milestone must contact the donor(s) and make a request to re-allocate the
surplus funds on the Training line to other budget lines where there are funding gaps. If the
donors refuse, the surplus restricted funds must be given back to the donor.
40 © Mango 2009
Mango FM1 Course Handbook
Chapter
4
4 Understanding Accounts
An Introduction to the Mysteries of Accounting Concepts and Jargon
This chapter:
Discusses why an NGO needs to keep accounts
Describes the different methods used to keep track of financial
transactions
Outlines which accounting records to keep
Defines and explains key financial accounting concepts and
terminology
Describes the financial statements which are prepared from the
accounts
Information
All organisations need to keep records of their financial transactions so that they can access
information about their financial position, including:
A summary of Income and Expenditure and how these are allocated under
various categories.
The outcome of all operations – surplus or deficit, net income or net expenditure.
Assets and Liabilities – or what the organisation owns and owes to others.
Credibility
NGOs especially need to be seen to be scrupulous in their handling of money – keeping
accurate financial records promotes integrity, accountability and transparency and avoids
suspicion of dishonesty.
© Mango 2009 41
Mango FM1 Course Handbook
Legal requirement
There is often a statutory obligation to keep and publish accounts and donor agencies
almost always require audited accounts as a condition of grant aid.
Future planning
Although financial accounting information is historical (ie happened in the past), it will help
managers to plan for the future and understand more about the operations of the NGO.
With information spanning two or three years, it is possible to detect trends.
Accounting Methods
Keeping accounts simply means devising appropriate methods for storing financial
information so that the organisation can show how it has spent its money and where the
funds came from. Accounting records can be kept in a manual format – ie hardback books
of account – or in a computerised format in one of many accounts packages available.
There are two main methods for keeping accounts:
Cash accounting
Accruals accounting
The two methods differ in a number of ways but the crucial difference is in how they deal
with the timing of the two types of financial transaction:
Cash transactions which have no time delay since the trading and exchange of
monies takes place simultaneously.
Credit transactions which involve a time lag between the contract and payment of
money for the goods or services.
Significantly, the method we choose to record transactions will produce different financial
information – so as managers we need to know the basis of accounting to better understand
financial reports.
Cash Accounting
This is the simplest way to keep accounting records and does not require advanced
bookkeeping skills to maintain. The main features are:
Payment transactions are recorded in a Bank (or Cash) Book as and when they are
made and incoming transactions as and when received.
The system takes no account of time lags and any bills which might be outstanding.
The system does not automatically maintain a record of any money owed by
(liabilities) or to (assets) the organisation.
The system cannot record non-cash transactions such as a donation in kind or
depreciation.
42 © Mango 2009
Mango FM1 Course Handbook
When summarised, the records produce a Receipts and Payments Account for a given
period. This simply shows the movement of cash in and out of the organisation and the cash
balances at any given time.
See Appendix 7 for a sample Receipts and Payments Account.
Accruals Accounting
This involves ‘double entry’ bookkeeping which refers to the dual aspects of recording
financial transactions to recognise that there are always two parties involved: the giver and
the receiver. The dual aspects are referred to as debits and credits. This system is more
advanced and requires accountancy skills to maintain.
Expenses are recorded in a General Ledger as they are incurred, rather than when
the bill is actually paid; and when income is truly earned (ie we are 100% certain it
will be paid) rather than when received.
By recognising financial obligations when they occur, not when they are paid or
received, this overcomes the problem of time lags, giving a truer picture of the
financial position.
The system can deal with all types of transactions and adjustments.
The system automatically builds in up-to-date information on assets and liabilities.
These records provide an Income and Expenditure Account summarising all income and
expenditure committed during a given period; and a Balance Sheet which demonstrates,
amongst other things, moneys owed to and by the organisation on the last day of the
period.
CASH ACCRUALS
Main Book of Account Bank (or Cash) Book Nominal (or General) Ledger
Reports produced Receipts & Payments Report Income & Expenditure Report
with Balance Sheet
© Mango 2009 43
Mango FM1 Course Handbook
Hybrid Approach
Many NGOs adopt a ‘half-way house’ approach. They use the cash accounting basis during
the year and then (often with the help of the auditor) convert the summarised figures at the
year-end (or more frequently) to an accruals basis for the final accounts and audit.
This includes keeping separate books to record and identify accruals and prepayments (see
examples below), unspent grants and capital purchases during the accounting period.
See Appendix 10 for a Schedule of Creditors and Debtors, identified for Milestone’s year-end
adjustment process.
Example of an Accrual
An electricity bill covering the last month of the financial year is not received until 4 weeks
after the year-end. Even though the payment will be made during the new financial year,
the expenditure must be recorded in the financial year that the electricity was consumed. It
shows up as a liability on the Balance Sheet
Example of a Prepayment
Office rent is paid six months in advance. Half of the payment covers the first quarter of the
new financial year and is therefore deducted from the office rent account for the current
year at the year-end. It is carried forward to the rent account for the financial year when the
rent falls due and shows up as a prepayment on the assets list in the Balance Sheet.
44 © Mango 2009
Mango FM1 Course Handbook
Bank paying-in vouchers stamped and dated when money is taken to the bank
Bank statements
Journal vouchers – for one-off adjustments and non-cash transactions.
With these documents on file it will always be possible to construct a set of accounts. Other
useful supporting documents include:
Payment Vouchers (PVs)
Local Purchase Orders (LPOs)
Goods Received Notes (GRNs)
Books of account
The minimum requirements for books of account are:
Bank (or Cash) Book for each bank account
Petty Cash Book
For organisations with salaried staff, valuable equipment and significant levels of stock, the
following records, where relevant, may also be kept as part of a full bookkeeping system:
General/Nominal Ledger
Journal or Day Book
Wages book
Assets Register
Stock Control Book
Supporting Documentation
It is very important to maintain supporting documents in the form of receipts and vouchers
for all financial transactions. These should be cross-referenced to the books of account and
filed in date or number order.
Apart from being required by the external auditor to support the audit
RECEIPTS
trail, certified receipts also provide protection to those handling the
EXPLAIN:
money. Mislaid or incomplete records can result in suspicion of
mismanagement of funds.
When?
Keep separate files for receipts for money coming into the organisation
How Much?
and money going out. Mark invoices ‘paid’ with the date and cheque
What? number to prevent their fraudulent re-use by an unscrupulous person.
© Mango 2009 45
Mango FM1 Course Handbook
These are what make the Bank Book such a useful record. These columns (numbered 1 to 9
in Figure 4.1) include the main categories of income and expenditure as identified in your
Chart of Accounts and your budget. They allow you to sort and summarise transactions by
budget category which in turn helps to compile financial reports quickly and easily.
Date/details 1 2 3 4 5 6 7 8 9 Date/details 1 2 3 4 5 6 7 8 9
Bank Reconciliation
The Bank Book should be checked with the bank’s records – the bank statement – at least
once a month. This is called the bank reconciliation. The purpose of this process is to make
sure that the organisation’s own records agree with the bank’s records and to pick up any
errors made by the bank or the organisation.
A bank reconciliation involves taking the closing bank statement balance for a particular date
and comparing it to the closing Bank Book balance for the same date. If there is a difference
between these two closing balance figures, the difference must then be explained.
46 © Mango 2009
Mango FM1 Course Handbook
In practice, there will almost always be a difference because of timing delays, such as:
Money paid into the bank which is not yet showing in the bank’s records
Cheques issued to a supplier but not yet banked by the supplier
Bank charges and bank interest which get added to the bank statement by the bank
periodically
Errors either made by the bank or when recording entries in the Bank Book.
See Appendix 6 for a completed bank reconciliation form and Appendix 19 (p age A23) for a
blank form to help you with this process.
An advantage of this system is that at any time you count the money plus vouchers in the
tin, they should always add up to the fixed float amount. Also, it is much easier to
incorporate petty cash spending into the accounts as the reimbursement cheque is entered
in the analysed Bank Book.
© Mango 2009 47
Mango FM1 Course Handbook
See how the reimbursement cheque for the petty cash book in Appendix 5 has been written
in to the Bank Book in Appendix 4. Look for cheque no. 13583 on 12/01.
Other Ledgers
Other elements in a full-bookkeeping system include:
Sales ledger and sales day book (but only if you have sales)
Purchase ledger and purchase day book
Stock ledger
Journal
These, together with the Bank Book and Petty Cash Book are the day-to-day working
accounts books. It is quite possible to set up a General Ledger without these additional
ledgers; the choice will depend on the activities of your organisation.
The Journal is used to record unusual, one-off transactions which cannot be recorded easily
in other books of accounts. These will include non-cash transactions (such as depreciation
and donations-in-kind), adjustments and corrections.
48 © Mango 2009
Mango FM1 Course Handbook
A journal entry follows the rules of double entry and will always include entries to at least
two accounts. For example, a donation-in-kind in the form of rent-free office space would
be recorded as income under ‘Donations’ and expenditure under ‘Office Rent’.
Wages Records
Employers have a statutory duty to maintain records of all wages paid and deductions made
and failure to do so could result in a heavy fine. Be sure to familiarise yourselves with the
arrangements of your own Department of Taxes and get hold of the latest tax deduction
tables.
Larger organisations should also keep a separate Wages Book, which brings together all
information on staff salaries and deductions. These can be purchased from stationery
suppliers in a pre-printed format and they help to facilitate the year-end reconciliation or
available as add-ons to accounting software packages.
Trial Balance
Figure 4.3 shows how the Trial Balance is the final stage of the accounting process – the
result of recording, classifying and summarising the many different transactions that take
place in an organisation. Figure 4.2 illustrates which figures from the Trial Balance end up
where in the annual financial statements.
© Mango 2009 49
50
Payment
Vouchers
Book
General
TRIAL
BALANCE
Income items usually appear first in a list down the page, followed by the summary of
expenditure items. The difference between total income and total expenditure, often called
the outcome, appears on the bottom line and is expressed either as:
‘excess of income over expenditure’ where there is a surplus; or
‘excess of expenditure over income’ where there is a deficit.
This excess figure is then included on the Balance Sheet under the heading Accumulated
Funds.
Note that there should be an accompanying Balance Sheet for the same date that the
Income and Expenditure Account is prepared at.
© Mango 2009 51
Mango FM1 Course Handbook
The balance sheet is a list of all the assets and liabilities on one particular date and
provides a ‘snapshot’ of the financial position of an organisation.
These are the tangible, long-term, assets such as buildings, equipment and vehicles, having a
value lasting more than one year. Fixed assets are shown on the balance sheet after an
allowance for wear and tear – or depreciation – has been made (see an explanation of what
depreciation is later in this chapter).
Current assets
These are the more ‘liquid’ assets such as cash in the bank, payments made in advance and
stocks. These, in theory at least, can be converted into cash within 12 months.
Liabilities are also divided into current liabilities and long-term liabilities.
Current or short term liabilities – including outstanding payments, and short-term
borrowings – ie those having to be paid within 12 months.
Long-term liabilities such as loans that need to be paid after 12 months. (However,
for NGOs such borrowings are not common.)
Accumulated Funds
Accumulated Funds and Reserves are separated out from other liabilities and act as a
balancing item on the Balance sheet. They represent the true worth of the organisation – in
the form of capital and/or cash reserves which have been built up from surpluses in previous
years. Accumulated Funds are classified as liabilities since, in an NGO, the funds are held in
trust for the organisation in pursuance of its objectives.
52 © Mango 2009
Mango FM1 Course Handbook
Liquidity
The term liquidity is used to describe how easy or otherwise assets can be turned into cash.
So money held in a bank account is deemed to be very liquid, while money tied up in a
building is clearly not liquid at all.
Working capital
This is the same as net current assets, that is, the short-term assets remaining if all
immediate debts were paid off. These are the funds that the organisation has available as a
cushion or safety net for running the organisation’s operations.
The table below summarises the main components and typical layout of a balance sheet,
although note that terminology does vary.
Component: Description:
FIXED ASSETS: The less liquid assets – those having a significant value lasting more
than one year.
CURRENT ASSETS: The more liquid assets – can usually be converted into cash within
one year.
- Cash Funds held in the bank and as cash.
- Debtors Money owed to the organisation such as loans and unpaid sales
invoices.
- Prepayments Value of items paid for in advance such as insurance premiums or
equipment rental.
- Grants Due Grants owed to the organisation for projects already started in the
reporting period.
- Stocks The value of raw materials or supplies such as publications or T-
shirts for sale.
CURRENT LIABILITIES: Those paid within one year of the year-end.
- Creditors & Accruals Money owed by the organisation at the year-end such as bank
overdrafts, unpaid bills.
- Grants in Advance Grants received for a particular purpose but not yet spent in full, so
carried forward to the next financial year.
OTHER LIABILITIES: Longer term commitments and General Funds.
- Reserves Money set aside for specific purposes, eg replacing equipment.
Although designated funds, they form part of the organisation’s
General Funds.
- Accumulated Funds Accumulated surplus of income over expenditure achieved since the
organisation opened.
© Mango 2009 53
Mango FM1 Course Handbook
What is Depreciation?
Capital expenditure, such as that on buildings, computer equipment and vehicles, is
expenditure which covers more than one accounting period and retains some value to the
organisation.
Depreciation is the way that accountants deal with the cost of wear and tear on fixed assets.
It allows the original cost of the item to be spread over its ‘useful life’.
The amount calculated for depreciation is shown as an expense in the accounts and
deducted from the previous value of the asset. As it is a non-cash transaction, depreciation
is entered in the accounts using a journal entry.
There are several methods used to calculate the cost of depreciating assets, but the two
most commonly used are: Straight Line method and Reducing Balance method
In the Straight Line method the amount to be depreciated is spread evenly over a pre-
arranged period. For example, a computer purchased for USD 1,000 expected to last for 4
years will be depreciated at USD 250 per year for 4 years. At the end of 4 years the
computer will have a zero net book value – ie it will have no value as far as the accounts are
concerned. In reality, it may have a second hand market value.
The Reducing Balance method fixes a percentage reduction in value so that the item loses
more value in the earlier years.
Example:
A car is purchased for USD 10,000. It is decided to depreciate it over 4 years – ie by 25% per
year. The table below shows how the equipment is depreciated over its useful life (all
figures are rounded to nearest dollar).
Depreciation schedule
Note that when using this method, the asset is never completely written off. At the end of
the 4th year it will still have a residual value. In this example, the car will be valued in the
accounts at USD 3,164. This recognises that the item may have a resale value when it comes
to replacing it.
54 © Mango 2009
Mango FM1 Course Handbook
There is no hard and fast rule for allocating overheads to projects; rather logic should be
applied and the criteria chosen should be justifiable.
For example, in allocating central support staff salaries to projects, the number of employees
in the project could be used; and for apportioning the cost of office rent, the actual space
occupied by project staff is applicable.
Whatever method is chosen, it must be fair and justified, and once established it should be
applied consistently.
© Mango 2009 55
Mango FM1 Course Handbook
56 © Mango 2009
Mango FM1 Course Handbook
Chapter
5
5 Financial Reports
Making Sense of the Numbers
Introduction
This chapter:
Identifies the who, what, when and why of financial reporting
Explains how to interpret financial statements using trend and
ratio analysis
Explains how to compile and use the information in management
accounts
Outlines the important features of donor reports
Outlines reasons for reporting to our beneficiaries
Financial reports are needed primarily by those responsible for managing the organisation
and by current and potential donor agencies; but those responsible for financial
management of an NGO also need to ‘give an account’ of their stewardship to a wide range
of stakeholders.
© Mango 2009 57
Mango FM1 Course Handbook
Table 5.1 summarises the main users of reports and why they need this information.
Project staff To know how much money and resources are available for their
projects and what has been spent so far.
Managers To keep an eye on how project funds are being used, especially
compared to the original plans. To help plan for the future.
Finance staff To make sure that there is enough money in the bank to buy the
things the NGO needs to run its programmes.
Board of Trustees To keep an eye on how resources are being used to achieve the
NGO’s objectives.
Donors To make sure that their grants are being used as agreed and that
the project’s objectives are being fulfilled. To consider whether
to support an organisation in the future.
Government To make sure that the NGO pays any taxes due and that it does
departments not abuse it status as a ‘not for profit’ organisation.
Project beneficiaries To know what it costs to provide the services they are benefiting
from and to decide if this is good value for their community.
The general public To know what the NGO raises and spends during the year and
what the money is used for.
From this list, we can see that there are many different users of financial reports – both
internal and external stakeholders – using financial information for management and
accountability purposes. It is not surprising, therefore that we need different kinds of
reports for different users, as summarised in Table 5.2 below.
During the financial year accounting information is summarised and turned into
Management Accounts for internal monitoring of progress against the budget.
At the end of the year, the Annual Accounts (ie the Balance Sheet and Income and
Expenditure Account) are produced to report on the outcome to external
stakeholders.
At intervals during the year, an NGO will also be required to complete special
progress reports to donor agencies.
58 © Mango 2009
Mango FM1 Course Handbook
They should be prepared as soon as possible after the end of the financial year – for example
within six weeks – and made ready for the external audit. The organisation’s constitution
will often specify the deadline for presentation of accounts to the members.
The Annual Accounts, accompanied by the Annual Report, form the main publicity and
information package available and will be of interest to many users. For this reason, the
annual accounts should:
present the organisation in the best possible light;
help to promote its work;
meet the needs of those using the accounts; and
meet the requirements of auditors.
If an NGO’s annual accounts show large accumulated funds, it may give the impression that
the organisation is well resourced and donors may be less inclined to give support to new
initiatives.
There are however, good reasons why an organisation will have cash reserves – for example,
funds put aside to replace equipment or a building appeal fund. An explanation must be
provided to reassure potential donors that their support really is needed.
© Mango 2009 59
Mango FM1 Course Handbook
Trend Analysis
Trend analysis takes at least two sets of figures compiled using the same accounting
techniques and showing information for two consecutive periods, usually year on year. By
comparing the figures it may be possible to detect trends and use this information to
forecast future trends or set targets.
Trend analysis is more meaningful if also combined with financial ratio analysis.
60 © Mango 2009
Mango FM1 Course Handbook
You can use ratios on the Income and Expenditure report by converting each line item into a
percentage of total income (that means to divide each item by total income and multiply by
100). This gives a guide as to the relative importance of different areas on the statement.
For example, the relative costs of administration versus direct project costs. This is useful for
drawing attention to the important areas and away from insignificant issues.
This calculation will also give an indication of the level of donor dependency – by dividing the
total of donor grants by total income and multiply by 100. If your financing strategy is
leading you towards less dependence on external aid, the dependency ratio will help to set
and monitor your target level.
A further level of analysis can be obtained by comparing the ratios for the current and
previous years’ figures to detect trends.
Again try dividing everything by the total income figure shown on the accompanying Income
and Expenditure statement to give an indication of the relative importance of items on the
Balance Sheet.
A ‘Survival Ratio’ can be calculated by dividing general reserves , sometimes called ‘free
reserves’ (that’s the part of the Accumulated Funds which are unrestricted, not held as
capital and for general use) by total income (from the accompanying Income and
Expenditure statement).
If you then multiply the resulting figure by 365 this will give an indication, in days, of how
long the organisation could survive in the coming year if income dried up and levels of
activity remain the same. Of course, this is a highly hypothetical scenario as in practice the
organisation would contract operations if its income was drastically reduce.
The Acid Test or Quick Ratio asks the question: Can we pay off our debts now? It divides
Current Assets less the less ‘liquid’ assets such as stocks and prepayments (in other words,
short term debtors and cash balances only) by Current Liabilities (short-term creditors and
overdrafts). The resulting ratio should ideally be in the range of 1:1. A ratio of 1:1 suggests
an organisation has sufficient cash to pay its immediate debts.
The Current Ratio asks the question: Can we pay off our debts within 12 months? It divides
total Current Assets by total Current Liabilities to find a further test of an organisation’s
(longer term) liquidity. A result of 2:1 is considered satisfactory. Again, convert the figures
for both years shown on the Balance Sheet to detect significant trends.
© Mango 2009 61
Mango FM1 Course Handbook
RATIO: FORMULA:
62 © Mango 2009
Mango FM1 Course Handbook
Management Reporting
Managers need financial information throughout the financial year to monitor project
progress and manage budgets effectively. If reports are produced on a timely basis, any
problems can be addressed early on and action taken to put things right.
How often?
Ideally, the management accounts should be produced every month and within a few days
of the end of the accounting period (any later and the information becomes out of date and
less useful). The minimum frequency for management reports is once a quarter.
Since the reports are produced so that managers can take decisions about the future
management of the organisation, the meetings of the governing body should be set to
coincide with the Management Accounts cycle so that the information is still timely.
Cas hflow
M aster Forec ast
Proje ct Budge t M o n h
t s :
1 J a n
C A SH F LO W F O R EC A ST - Tu sai di an
J a n
e
Fe b M a r Ap r M a y
to 3 1 D
J u n
e c 1 9 9 8
Activity
R e c e i ps
t
Budge ts
D F I D 0 0 1 2 0
, 0 0 0 0 1 2 , 0 0 0
S EED 0 1 5 0
, 0 0 0 0 1 0 ,0 0 0 0
D o n a it o n s 1 , 2 5 0 1 2
, 5 0 1 2
, 5 0 1 , 2 5 0 1 ,2 5 0 1 , 2 5 0
F u n d a
r i s in g 0 0 0 5 , 0 0 0 0 0
Pl ans
S u b s c ir p it o n s 1 0 0 1 0 0 5 0 0 1 0 0 1 0 0 1 0 0
C o n s u lt a n c y 0 0 1 1
, 2 5 0 0 1 , 1 2 5
B a n k I n e
t r e s t 8 0 8 0 8 0 8 0 8 5 8 5
A . To a
t l R 1 c
e , e4 p
i3 0 s
t 1 6 4
, 3 0 1 4 9
, 5 5 6 , 4 3 0 1 1 ,4 3 5 1 4 , 5 6 0
P a y m e n s t
P e sr o n n e l e x3 p
, e7 n
2 s5 e s 3 7
, 2 5 3 7
, 2 5 3 , 7 2 5 3 ,7 2 5 3 , 7 2 5
O f ic e c o s st 1 , 8 0 0 1 5
, 0 0 1 5
, 0 0 1 , 5 0 0 1 ,5 0 0 1 , 5 0 0
M a n a g e m e n t c o 7 s5 st 1 6 1 6 7 5 1 6 8 2 0
P o
r j e c t c o s st2 , 6 7 5 2 6
, 7 5 2 6
, 7 5 2 , 6 7 5 2 ,6 7 5 2 , 6 7 5
T a
r v e l c o s st 1 , 4 7 5 1 4
, 7 5 1 4
, 7 5 1 , 4 7 5 1 ,4 7 5 1 , 4 7 5
Mon ths:
Re ceipt s
Budget
Jan Feb M ar A pr M ay Jun
DF ID 0 0 12,00 0 0 0 12 ,000
SE ED
Monitoring
0 15,0 00 0
Do nati ons 1, 250 1,2 50 1,25 0 1,250
0 1 0,000
1,250 1 ,250
0
Cashflow
Fundr aisi ng 0 0 0 5,000 0 0
reports
Subscr ip ti ons100 1 00 50 0 100 100 100
Co nsultancy
Bank Int ere st 80
0 0 1,12 5
80 8 0 80
0 0 1 ,125
85 85 Report
A. Tot al Re1,cei
430
p ts 16,4 30 14,95 5 6,430 1 1,435 14 ,560
C AS H FLO W RE P O RT 1 J a n t o 3 1 De c 1 9 9 8
Pay men ts
Per sonnel expenses
3, 725 3,7 25 3,72 5 3,725 3,725 3 ,725 M o n t h s : J a n Fe b Ma r A p r Ma y J u n
Of fi ce co sts1, 800 1,5 00 1,50 0 1,500 1,500 1 ,500 Re c e i p t s
DF I D
I 0 0 1 2 0
, 0 0 0 0 1 2 ,0 0 0
M anagem ent cost 75s 16 1 6 75 16 820 SEE D 0 1 5 , 0 0 0 0 0 1 0 , 0 0 0 0
Pr oje ctco st2s, 675 2,6 75 2,67 5 2,675 2,675 2 ,675 D o n a t io n s 1 2
, 5 0 1 , 2 5 0 1 2
, 5 0 1 2
, 5 0 1 , 2 5 0 1 ,2 5 0
F u n d r a is i n g 0 0 0 5 0
, 0 0 0 0
Tr avel costs1, 475 1,4 75 1,47 5 1,475 1,475 1 ,475
S u b s c r ip t io n s 1 0 0 1 0 0 5 0 0 1 0 0 1 0 0 1 0 0
Co n s u l at n c y 0 0 1 1
, 2 5 0 0 1 ,1 2 5
Ba n k n
I e
t r e s t 8 0 8 0 8 0 8 0 8 5 8 5
Ac counting A. 1 c e
T o t a l Re 4
, i3 p
0 t s 1 6 , 4 3 0 1 4 9
, 5 5 6 4
, 3 0 1 1 , 4 3 5 1 4 ,5 6 0
Pa y m e nt s
Rec ords Pe r s o n n e l e
3 x p
Ma n a g e me n t c o
7
, e
O f if c e c o s t s1 8
2 n
5 s e s 3 , 7 2 5
, 0 0
7 s5 t s
P r o je c t c o s t2 s 6
, 7 5
1 , 5 0 0
1 6
2 , 6 7 5
3 7
, 2
1 5
, 0
2 6
1
, 7
5
0
6
5
3
2
7
, 2 5
5
, 0 0
6
7 5
, 7 5
3 , 7 2 5
1 , 5 0 0
1 6
2 , 6 7 5
3 ,7 2 5
1 ,5 0 0
8 2 0
2 ,6 7 5
Ta
r ve l c o s t s1 4
, 7 5 1 , 4 7 5 1 4
, 7 5 1 4
, 7 5 1 , 4 7 5 1 ,4 7 5
© Mango 2009 63
Mango FM1 Course Handbook
Which reports?
The main reports that will be useful to managers are the:
Cashflow Report
Budget Monitoring Report
Forecast Report
64 © Mango 2009
Mango FM1 Course Handbook
We can see the Plan-Do-Review process in action in Rudi’s trip to the Cinema. He set out his
plans for the evening and what each activity would cost (PLAN) and then went out with his
friends (DO). But it did not all go as planned and his actual spending varied as a result. If we
look at the variance column in Rudi’s Budget Compared to Actual Report (REVIEW) in Table
5.3 it is possible to see the story behind the figures...
Table 5.3 Rudi’s Budget Compared to Actual Report
A B C D E
Budget Item Budget Actually Variance Budget
Spent Utilisation
$ $ $ %
Travel 1.50 0.75 0.75 50%
For example, we can see the effect of Rudi arriving too late to buy the cheaper cinema
tickets: he spent USD 1.00 (or 33%) more than planned on the entrance fee. And because
he then didn’t have enough money left to buy his bus fare back home (he got a free lift
home instead) he also under-spent on his Travel budget, using up only 50% of that line.
When we review the figures, and in particular the variance column, it helps us to understand
why we did not fulfil the plans and build in that learning to the next cycle.
In Rudi’s case, he learnt that he needs to get to the cinema early to buy a cheap ticket (and
his mother learnt that it might be a good idea to give Rudi a bit extra for emergencies to
make sure he gets home safely!)
© Mango 2009 65
Mango FM1 Course Handbook
Forecast Reports
Forecast reports are especially helpful from the second quarter onwards
for predicting the outcome for the year and helping with the budget
process for the next year.
See Appendix 17 for a sample Forecast Report.
With a fair degree of accuracy you should be able to tell whether the
organisation is going to run a surplus or deficit. This is all-important in
your relationship with donors:
A large deficit can make the organisation appear to be out of
control and poorly managed
A small deficit can demonstrate a great need and even a sense of good
housekeeping
A small surplus can suggest good management
A large surplus can indicate a failure to meet needs or inexperience in budgeting.
There are various ways of reducing a surplus at year-end, including purchasing new or
replacement equipment, ordering stocks of stationery and office supplies. There is very little
that can be done about a large deficit except to provide an early warning and a very good
explanation to stakeholders and hope that there are sufficient reserves to cover it.
66 © Mango 2009
Mango FM1 Course Handbook
Are there any significant variances in the individual line items? Are the reasons for
the differences explained? For example, the Subsistence Expenses budget is
substantially and unexpectedly over-spent. Do not just concentrate on over-
spending – remember that under-spending is just as critical for an NGO.
Do linked budget line items (eg activity-related costs) tell the same story or do they
contradict? For example, the project materials budget is under-spent suggesting
delayed activities but the vehicle running costs are high, which is not logical.
Do the budget report figures tell the same story as the narrative project report?
Sometimes the figures just do not look right: trust your instincts
and follow up your concerns.
A note on Commitments
Commitments refer to (significant) expenses which have been incurred for a project or
organisation in a particular period but haven’t yet been accounted for or belong to a
future reporting period. Commitments usually occur in a cash accounting system or
where there are time delays in reporting all expenditure, eg from field offices.
If significant commitments are not taken into account when compiling budget
monitoring reports, the results may under- or over-count the true level of expenditure
and give a distorted view when compared to the budget.
It is important to be aware of outstanding commitments when monitoring a budget or
grant because decisions are based on the reported variances and balances available. It
could appear that there is more (or less) money available to spend than there really is.
Here are two solutions if figures exclude outstanding commitments:
Include an extra column in the budget monitoring report to record known
commitments
Add a note about known commitments in the comments column or covering note.
© Mango 2009 67
Mango FM1
1 Course Handbook
The next step is to understand what has caused the variance to happen. In all cases, a
variance represents a change from the original plan but what lies behind it? Generally, we
can say that variances will be the result of a change
cha in one or more of:
the timing of the activity
the actual price achieved or
the actual quantity of goods or services taken.
Sometimes a variance on a report will be due to an error in the figures rather than a change
in plan, for instance a mis-codin
coding in the accounting records.
Timing
[Temporary variance]
Price Quantity
[Permanent [Permanent
variance] variance]
68 © Mango 2009
Mango FM1 Course Handbook
Example
The project plans to purchase a vehicle in month 1 but supplies are held up at the port by
Customs. The budget monitoring report will therefore show a big positive variance on the
Vehicles line (because the budget has not been used yet).
By month 2 the vehicle arrives and is purchased – just a bit later than planned.
The budget monitoring report will no longer show a zero spend on vehicles and the
previous large variance will be gone as it was a temporary variance due to a timing issue.
Permanent variances
Variances caused by changes in the price or quantity of particular budgeted items generally
fall into the permanent variances category because once this has happened, there is no
going back. The only way to recover the situation is to make an action plan, eg to reduce
spending on future items.
These variances are therefore generally more serious and management attention and
corrective action is required.
Example
The invoice for the vehicle is paid in month 3. The price of the vehicle has increased by 10%
due to a fluctuation in the exchange rate.
The budget monitoring report for month 3 now shows a negative variance on the vehicles
line equal to the difference between the budgeted price and the actual, higher price paid.
This is a permanent variance caused by a change of price. A decision has to be made on
how to fund the additional 10% on the cost of the vehicle
Figure 5.3 summarises the actions open to managers to take on variances, once analysed
using the classifications systems described above.
© Mango 2009 69
Mango FM1
1 Course Handbook
Action Planning
Having analysed the figures in management reports, it is then important to work out
appropriate corrective action, if needed. Deciding on the action to take, will depend on
many factors including:
knowledge of the project – where it is now and what the activity plans are for the
next period
awareness of external factors – eg inflationary trends, dependence on other
programmes meeting their targets
how serious the variance is
how controllable, or otherwise, the budget items are
what the impact would be to take no action
donor rules and conditions.
conditions
It is useful to use a Budget Management Action Planner table to help you manage and
control your budget. It can be used to discuss action plans with manager and the project
team and to monitor progress of the action plan.
See Table 5.4 for an example format and Table 5.5 for an explanation of how to use it.
70 © Mango 2009
Mango FM1 Course Handbook
© Mango 2009 71
Mango FM1 Course Handbook
Accountability
Financial accountability requires that you demonstrate to the donor that their funds have
been used for the purpose for which they were intended. The reference point is the original
funding application and guidelines are usually provided with the confirmation of grant aid
and the contract or agreement signed by both parties.
It is important to comply with the conditions and meet reporting deadlines to establish
credibility and encourage confidence, and to make sure your grant arrives on time.
Bank Accounts and interest – separate bank accounts are required by some donors
and/or they do not allow you to keep any interest earned on sums invested.
Depreciation policy – how to treat fixed assets purchased with a grant.
72 © Mango 2009
Mango FM1 Course Handbook
Otherwise the organisation will be involved in a tedious information gathering exercise every
time a report is required. The use of Cost Centres is particularly useful here.
When putting together a report to donors do:
meet reporting deadlines (or request an extension)
produce accurate and verifiable figures
not conceal under-spends or over-spends
explain any significant variations
keep the donor informed of any potential problems
Finally, bear in mind that donors have a lot of experience of working with groups like your
own; they will almost always respond positively to requests for advice.
‘Exceptions’ reporting
Managers and Board members are busy people and they rarely have the opportunity to fully
read all reports that get sent to them. With financial reports it is good idea to provide an
exceptions report – a brief cover note that draws attention to key areas or need decisions.
The exceptions report is usually no more than one or two pages long and should avoid using
technical jargon. It should be brief and easy to read. A suggested layout:
Overview of the period being reported – ie dates covered; how figures have been
compiled; what activities are covered by the attached reports; and author of report.
Significant variances - Highlight the most significant variances from the budget and
explain the reasons behind the variances. This should not just concentrate on over-
spending of budgets – under-spending can also be a problem, especially when
related to donor-funded projects.
Recommendations for action – ie corrective action required to deal with the key
issues identified in the previous section. For example, strategies to avoid a cashflow
crisis in future months; revised activity plans to get projects back on target;
restricting use of vehicles where running costs are running too far over budget.
Presentation of figures
Negative figures in project financial management reports can be represented in two
ways: – 1,234 or (1,234)
Figures are usually rounded to the nearest whole number – the cents are not
relevant to the overall review of the results. This sometimes may result in figures
being out by 1.
© Mango 2009 73
Mango FM1 Course Handbook
Alternative formats
35
30
25
20
15
10
5
0
DFID Smile Trust V.Society Training Other
Fees
Income source
Graphical formats – for example using a bar chart for a budget-actual report (as in Figure
5.4) or a pie chart for an income and expenditure report – are a welcome alternative to
tables of figures, especially for people who are less confident around figures.
Similarly, rather than present figures, we might simply present a list of statements such
as in this example of an alternative Balance Sheet format:
74 © Mango 2009
Mango FM1 Course Handbook
See also some very interesting ideas on alternative ways to present financial information
from Little Fish in Australia: http://www.littlefish.com.au
Reporting to Beneficiaries
Most NGOs recognise the need for downward accountability – ie reporting to the
communities they work with.
with. But few have set up systems to deliver it: most NGO systems
focus on upward accountability, such as reporting to donors, Boards and Head Offices.
To participate fully in an NGO’s
NGO s work, beneficiaries need access to information about the
NGO’s plans, resources
ources and activities. Increasing transparency and accountability to
beneficiaries has many benefits including:
Strengthening trust and respect between NGO staff and beneficiaries
Improving the quality of programme decisions, as beneficiaries provide feedback
feed on
how funds are being spent
Empowering beneficiaries to make their own decisions on their own behalf
Reducing the risks of inefficiencies and fraud
Encouraging finance staff to get more involved with NGO field work
Introducing this level of financial transparency may naturally hit some obstacles, such as
adding to the burden of already busy staff. But if sensitively done, the benefits generally far
outweigh the costs.
Some good practice ideas on how to practically report to beneficiaries include:
Making
king information easier to understand by using graphical presentations
Using white-boards
boards outside offices to display budgets, the amounts of funds
available for each area and a monthly update of expenditure.
For more ideas on how to report to beneficiaries
beneficiaries and information about Mango’s “Who
Counts?” campaign, please visit: www.whocounts.org.
© Mango 2009 75
Mango FM1 Course Handbook
3. Does the organisation have enough ready cash (see ‘Cash at Bank’ listed under Current
Assets) to pay off its immediate debts (see Creditors)?
4. How long could the organisation survive if all of its funding dried up? (Calculate the
‘survival ratio’) How does this compare to last year?
Income & Expenditure (or Profit and Loss) Account
17. Is there enough cash in the bank to fulfil the activity plan in the next six months?
18. What grants are due and are they still expected to come through on time?
19. Are spare cash balances invested to produce the best return?
General
20. What non-financial figures are being produced to show how the programme of activities
is progressing?
76 © Mango 2009
Mango FM1 Course Handbook
Chapter
6
6 Safeguarding Your Assets
‘It is more sensible to establish a system to deter fraud rather than one to discover it’.’
This chapter:
Explains the importance of introducing internal controls
Outlines the principles of delegation of authority and separation
of duties
Highlights the importance of cash control and reconciliation
Discusses ways to manage and control fixed assets
Provides some tips on how to detect fraud
Gives advice on how to manage incidences of fraud and other
irregularities
© Mango 2009 77
Mango FM1 Course Handbook
Delegated Authority
The Board of Trustees delegates authority through the Chief Executive for the day-to-day
running of the organisation. In a large and busy organisation it is not practical to expect one
person to make all the decisions and authorise all transactions. The Chief Executive will,
therefore, further delegate authority to members of the staff team to relieve the load and to
ensure smooth operation during absences of key staff.
The Delegated Authority document must be approved by the governing body and should be
reviewed every year to ensure it is still appropriate to current needs. It should also outline
deputising arrangements to cover for absence of key personnel. A breach of delegated
authority is a serious matter and should be dealt with accordingly.
Authorisation rules
When writing a delegated authority document there are some basic rules which should be
observed:
The lowest level of authority is defined – it is taken for granted that those higher up
the management ladder will also have the same authority.
No one should authorise any transaction from which they will personally benefit.
This makes the individual vulnerable to accusations of abuse.
Sub-ordinates must not authorise payments to managers – they must be passed to
someone who is more senior in the management structure.
Any limits or conditions that apply to delegated authority must be clearly defined. For
example, a person may be authorised to commit expenditure up to a specified amount or
within certain categories of expenditure or within budget.
78 © Mango 2009
Mango FM1 Course Handbook
Separation of Duties
In order to protect those operating the procedures and to prevent any temptation to mis-
use funds, there must be a separation of the various duties within the finance procedures.
For example, the duties of ordering goods, receiving goods, authorising the payment,
keeping the accounting records and reconciling the accounts should not fall entirely on the
shoulders of one person. Apart from weakening financial control, this puts too much
responsibility on one person and if they should leave the organisation or are absent for long
periods, then the finances will grind to a halt.
As far as possible then, duties should be shared between the staff team and/or committee if
there are only one or two staff members.
Procurement Procedure
A Procurement Procedure sets out the steps and conditions that have to be followed by staff
to acquire goods and services so that the objectives of the organisation can be fulfilled
efficiently and effectively. See below for the typical stages in a procurement process.
This is a prime example of separation of duties in action. The procedure will:
outline the process and authorities for ordering, receiving and paying for goods and
services (see below);
describe which method of payment or acquisition is to be used for different goods
and services – for example, when it is acceptable to use petty cash (this should be
rare), bank transfers (eg salaries) or suppliers’ accounts (eg stationery, petrol);
clarify when it is necessary to obtain quotations from suppliers – eg 2 quotations for
all expenditure over $100;
include a list of Approved Contractors or Suppliers, if used.
Signing cheques
Each organisation should have a panel of cheque signatories from which to select the
required number of authorising signatures; there should be sufficient people nominated to
ensure efficient administration of payments. Signatories should be regularly reviewed and
the list updated when people leave the organisation.
It is usual to have more than one signature on a cheque to help avoid fraud.
NEVER ask signatories to sign blank cheques for future use as this defeats the
whole purpose of having more than one signatory.
© Mango 2009 79
Mango FM1 Course Handbook
Receive
Issue Select Supplier
goods
Purchase (‘Purchasing Panel’)
Order
The standard, quantity and price of goods or services required, as described in the activity
plans, is clarified so that it is clear what needs to be purchased. The amount currently
available in the budget for the item to be purchased should be checked at the specification
stage in case the price has changed since the budget was prepared.
80 © Mango 2009
Mango FM1 Course Handbook
An internal request is prepared – usually on a standard form for that purpose – to formally
request the purchase of the goods or services specified. The request will include a
description of the purchase and state why it is required.
The purchase requisition will usually be checked and authorised by the budget holder or
other nominated person to verify that there is a genuine reason for the purchase. The
available budget will usually be checked again at this stage.
4. Obtain Quotations
Quotations from reputable independent suppliers are requested (in accordance with
internal procedures and donor rules) to make sure the organisation gets best value for
money and to minimise the risk of collusion.
5. Select Supplier
Quotations are reviewed and a supplier is selected based on price, quality, delivery times
and ‘after sales’ terms to ensure value for money. For larger purchases, it is usual to have a
Purchasing Panel – a small group of managers who take responsibility for selecting the
supplier.
A Purchase Order is sent to the selected supplier with a copy kept on file with the supplier’s
quotation. This is a legally binding contract.
When supplies are delivered and received, a Goods Received Note (GRN) is usually signed to
confirm receipt and a copy filed for later reference.
The invoice should be checked and matched up with the GRN, PO and quotation, usually by
the finance team.
The Payment Authority is attached to the invoice and all the supporting documents. It
includes budget and accounting codes and must be checked and authorised by the budget
holder or other nominated person.
Payment should be made to the supplier within the specified payment terms, usually 30
days.
The final stage is to record the payment in the organisation’s books of account.
© Mango 2009 81
Mango FM1 Course Handbook
Bank Book
The Bank Book should be reconciled to the bank statement at least once a month. The
purpose of this exercise is to make sure that the organisation’s own records agree with the
bank’s records which are rather like a parallel set of records. This is achieved by taking the
closing bank statement balance for a particular date and comparing it to the closing Bank
Book balance for the same date, then explaining the differences.
This is an important check not only for accuracy and completeness of records, but also as an
early indication of fraud.
Stock records
Stock records must be checked against the supplies held in the store and receipts from sales
to ensure that no errors have crept in (and no stock has crept out).
A Sample Stock Control Sheet for some T-shirts is reproduced below in Table 6.1. It shows
the value of the stock the last time it was reconciled. Then it lists new stock purchases and
new sales. This gives us an expected stock value, on paper at least.
Note that the table lists both the cost value (ie what the organisation paid the T-shirts
supplier) and the resale value (ie what the organisation expects to sell the T-shirts for).
82 © Mango 2009
Mango FM1 Course Handbook
However, when the T-shirts in the stock room are physically counted and checked, the
actual value is less than expected. (The brackets around the bottom line figures indicate the
stock value is short.)
What do you think might explain this difference?
Table 6.1 Sample Stock Control Sheet
Whatever the explanation, the difference would have to be investigated and systems
reviewed if necessary. This demonstrates well the importance of regular stock
reconciliation.
Wages Book
The wages records, and particularly deduction records, are notorious for containing
inaccuracies and for abuse in the form of ‘ghost employees’ (ie people on the payroll who do
not exist and where a salary is paid and collected by a fraudster).
Wages records must be reconciled every month to ensure that the correct deductions are
being made and passed on to the relevant authority. Failure to do so could result in severe
penalties and interest being imposed – and cause discontent amongst the staff.
© Mango 2009 83
Mango FM1 Course Handbook
Cash Control
It is important to observe the Seven Golden Rules for Handling Cash as
follows:
This affords protection to the person receiving the money and assures the person handing it
over that it is being properly accounted for. Receipts must be written in ink, not pencil, and
preferably from a numbered receipt book.
Sometimes this may not be possible. For example, when purchasing materials from a
market; in this case the cost of each transaction should be noted down straight away so that
the amounts are not forgotten and these can then be transferred to a petty cash slip and
authorised by a line manager. Remember – no receipt means there is no proof that the
purchase was made.
Having cash lying around in the office is a temptation to a thief and the money would be
better managed if it were earning interest in a bank account. A casual approach to cash on
the premises might also lead to people wanting to ‘borrow’ from it – many a sorry tale of
fraud has started in this way. Every attempt should be made to pay cash into the bank on a
daily basis or, at the very least, within 3 days of receipt.
To protect those handling money, there should always be two people present when opening
cash collection boxes, etc. Both should count the cash and sign the receipt.
84 © Mango 2009
Mango FM1 Course Handbook
Keys to the petty cash box and the safe should be given only to authorised individuals. This
should be recorded in the organisation’s Delegated Authority document.
Petty cash should only be used to make payments when all other methods are
inappropriate. Wherever possible, suppliers’ accounts should be set up and invoices paid by
cheque. The advantage of paying for most transactions by cheque is that this has the effect
of producing a parallel set of accounts in the form of the bank statement. Also, it ensures
that only authorised people make payments and it reduces the likelihood of theft or fraud.
Physical Controls
Physical controls are additional common sense precautions taken to safeguard the assets of
an organisation.
Having a safe
Having a safe – or a safe place – to keep cash, cheques books, legal
documents, etc. is an important consideration. A proper safe is worth
considering especially if your organisation has to keep large sums of
money on the premises overnight. Safes are however, expensive and if
resources are tight then it may be better to improve on banking
procedures.
Insurance cover
It is the responsibility of the Chief Executive to ensure that there is adequate insurance cover
so that if ‘assets’ are lost, damaged or stolen they can be replaced or compensated. There
are many different types of insurance to consider, including
Office contents against fire and theft
Buildings against fire, floor and storm damage
Vehicles against accident and theft.
The decision whether or not to insure property is a good example of managing risk –
weighing up the pros and cons of paying for insurance is a common dilemma for managers.
© Mango 2009 85
Mango FM1 Course Handbook
An Assets Register should be established with an entry or record sheet for each item. Each
asset should be tagged with a unique reference number for identification purposes. The
register will record important information about each asset, such as:
where and when the item was purchased and how much it cost
where it is held or located
how much it is insured for
repair history
serial numbers
details of guarantees or warranties.
depreciation rate and method, where relevant.
The record sheet should also state who is responsible for its maintenance and security. The
Assets Register should be checked by a senior manager or committee member every quarter
and any discrepancies reported and appropriate action taken. See Appendix 19 (page A21)
for a sample Assets Register record sheet.
Building and Equipment Maintenance policy
To preserve the value of buildings and equipment, an organisation must have a pro-active
policy of maintenance. For buildings this may require a professional planned maintenance
contract for which a realistic budget must be provided.
Office equipment such as photocopiers and electrical equipment should also receive regular
services by qualified technicians to ensure they are safe and operating properly.
Vehicle policy
Every organisation that owns vehicles should have a vehicle policy. This will set down the
policy on a range of issues such as:
Depreciation
Insurance
Purchasing, replacement and disposal
Maintenance and repair
Private use of vehicles by staff
What to do when accidents happen
Driver qualifications and training
Carrying of passengers
The costs of repair and replacement must be also adequately reflected in the budget
process.
86 © Mango 2009
Mango FM1 Course Handbook
For each vehicle there should be a log of journeys so that the running costs per KM can be
assessed and private use closely monitored. (See Appendix 19, page A24 for a sample.) Once
you have 12 months information on the costs of running a vehicle, it is possible to calculate
its average running costs per kilometre.
See below for a worked example.
Table 6.2: Calculating Vehicle Running Costs
In conclusion: using the information from our accounts and the vehicle log sheet, we can see
that each kilometre run with the Toyota Hiace Van cost approx. 0.67 cents.
© Mango 2009 87
Mango FM1 Course Handbook
The following ideas may be an early indication of fraud or abuse. Use with care!
From the accounting records:
Lots of corrections to the manual cashbook – this may include extensive use of
white-out or blocked out figures
Pristine records – ie a manual cashbook that look as if they have all been written on
the same day in the same hand. Could be an indication of rewritten/duplicate books
Delayed banking of cash received – shown up by bank reconciliation. Could be
‘teeming and lading’?
Records not being kept up to date – ie deliberately delayed so managers cannot
detect false accounting going on.
Missing supporting documents – eg certain bank statements destroyed to cover
someone’s tracks, or a project officer who regularly claims to have ‘lost’ receipts.
Debtors rising unexpectedly – eg if debtors have paid but the cash is being pocketed.
This may occur if there are poor controls in issuing receipt books as someone could
take an unused book and issue valid receipts without them ever being entered into
the accounting records.
Hand written supporting documents with errors and corrections on them. Indicates
possible changes made after the goods or services were purchased.
Cash counts not reconciling to the accounts but reconciling at the next cash count –
possible borrowing of funds by the safe key holder.
Reports:
Budget monitoring reports showing inconsistent behaviour between line items - eg
project-related expenditure is under-spent due to delays – except for fuel which his
over-spent. This could indicate abuse of the vehicle.
Vehicle log books not maintained in an appropriate level of detail. This could indicate
abuse of the vehicle.
Budget monitoring reports delayed – to cover up something?
Non-financial areas:
Working very long hours – first in last out of the office? Could mean that they are
having to do extra work to cover tracks?
Never taking holidays – can’t afford for someone else to see what they are doing!
88 © Mango 2009
Mango FM1 Course Handbook
Change of lifestyle – spending patterns don’t match their income (eg designer
clothes, social habits, expensive car...)
Creating ‘smoke screens’ – where someone is making a false accusation about
another team member to give them time to cover their tracks or make a getaway!
And some Ideas on fraud prevention:
Make sure you have robust internal control systems in place.
Visit projects, and see if the activities carried out roughly match the expenditure.
Share financial reports with beneficiaries, and ask if they think they have had value
for money (find out how: www.whocounts.org).
Hold regular meetings with other staff at all levels (eg project and administrative
staff, board members, etc) to discuss financial reports, making budgets and reports
openly available.
Help non-finance staff and managers improve their financial skills, for instance by
reading Mango's Guide to Financial Management (available on the CD-Rom in your
training pack.)
Funding
withdrawn
NGO’s credibility
suffers
Beneficiaries lose
out
NGO survival
under threat
© Mango 2009 89
Mango FM1 Course Handbook
‘Irregularities’ include unauthorised activities for private gain: eg ‘borrowing’ from petty
cash; use of vehicles; or abuse of telephones and other equipment.
Inevitably, the impact of fraud has a damaging effect on the organisation. Imagine a stone
falling into a pond: the initial splash is the loss of funds or equipment but it does not stop
there, as Figure 6.1 above illustrates.
Incidents of fraud and irregularities require sensitive handling to minimise the long-term
impact. It is important to be prepared to deal with any occurrences of fraud or financial
irregularity by having a written procedure which covers steps that need to be taken.
Deterrence
The procedure should state clearly that routine controls, checks and balances are in place to
safeguard the assets of the organisation and to protect staff from any suspicion of, or
temptation to, fraud or other impropriety. Paid staff and volunteers are therefore obliged to
co-operate fully with internal control procedures and failure to do so will be dealt with as
appropriate within the organisation’s disciplinary code.
Types of irregularity
The procedure will identify different types of irregularity; how seriously they are viewed; and
how they will be dealt with. For example, all instances of theft and fraud will be viewed as
Gross Misconduct and will result in immediate dismissal and loss of terminal benefits. A clear
statement of the organisation’s policy on the circumstances in which the Police will be
informed must also be made. This must take in account local circumstances.
Detection
A procedure for reporting suspicions of irregularities should be made clear to all. This should
make it easy for people to report concerns in confidence and without fear of retribution.
When an irregularity is reported or detected, record the details in writing; report it
immediately to a superior. Follow up all reports or suspicions immediately; do not allow
rumours to spread or let the ‘trail’ go cold.
90 © Mango 2009
Mango FM1 Course Handbook
Investigation
When an irregularity comes to light, it must be dealt with quickly and sensitively; look for
corroboratory evidence before instigating a formal investigation. If all the evidence points to
an irregularity, the individual(s) involved should be formally interviewed with a third person
present to take notes.
Protect documents and records by either removing access to them by those involved in the
irregularity or by suspending the people involved during the investigation. The policy will
identify who is responsible for conducting a formal investigation. This will depend on the
nature of the irregularity; it could be conducted by the senior manager, the internal auditor,
the external auditor or, in more serious cases, the Police.
The Aftermath
Don’t under-estimate the long-term and less tangible impacts of fraud. It will involve a lot of
a managers’ time during the investigation and afterwards. In particular:
People will be distressed by the experience and need to be supported. Colleagues
will suffer all the mixed emotions of bereavement: anger, guilt, disappointment and
loss. They will be worried that their own jobs are under threat.
New staff may need to be recruited and trained.
Donors will need reassuring that their resources are safe and the project will not
suffer.
Summary
Here are some tips on how to deal with fraud and other irregularities – to keep RISKS LOW:
DO
Report the incident to a superior or Board member
Investigate incidences, gather the facts
Secure the assets and records
Keep calm!
Swiftly act
DON’T
Look the other way
Overlook the ‘fall out’ of a fraud
Withhold information to protect others
© Mango 2009 91
Mango FM1 Course Handbook
92 © Mango 2009
Mango FM1 Course Handbook
Chapter
7
7 Managing Audit
An Independent Check on Accounting Records and Systems
This chapter:
Explains what an audit is
Describes the different types of audit
Provides an overview of the audit report
Gives advice on how to prepare for and manage the external
audit
What is an Audit?
An audit is an independent examination of records, procedures and activities of an
organisation, resulting in a report on the findings.
There are two kinds of audit:
The Internal Audit
The External Audit
As the name implies, an external audit is primarily for the benefit of those outside the
organisation, eg stakeholders and funders. Internal audit is undertaken for the benefit of
those inside the organisation, ie trustees and management.
The audit should be a positive experience and not one to be feared; it is an opportunity to
receive feedback on strengths and weaknesses in systems. Use your auditor to discuss ways
of improving your accounting systems and procedures.
© Mango 2009 93
Mango FM1 Course Handbook
Internal Audit
Internal audit involves a structured review of systems and procedures, as set by the Board
and managers, to ensure efficient and effective practices. It is not an internal ‘policing’
function, rather an opportunity to improve systems and build internal capacity.
The internal auditor’s report will highlight findings and make recommendations for action,
where needed. It may be carried out by someone within the organisation, or an outsider
may be engaged to carry out an 'internal audit'.
An internal audit will include a range of checks as part of the independent review, including:
financial accounting systems and procedures;
management accounting systems and procedures;
internal control mechanisms.
The internal auditor reviews the adequacy of the design of the systems of procedures, and
checks that they are being appropriately implemented. A report is presented to the
governing body and management, who respond by taking corrective action, perhaps
changing a procedure, or training a staff member.
The ‘Three E’s’ influence an internal auditor’s approach:
Economy: paying no more than necessary for the resources needed.
Efficiency: getting the greatest benefit with the fewest resources.
Effectiveness: how successful we are at meeting objectives or ‘doing the right thing’.
External Audit
An external audit is an independent examination of the financial statements prepared by the
organisation. It is usually conducted for statutory purposes (because the law requires it).
External auditors may also be engaged to do other specific assignments, (eg a fraud
investigation).
Purpose
The purpose of external audit is to verify that the annual accounts provide a true and fair
picture of the organisation’s finances; and that the use of funds is in accordance with the
aims and objects as outlined in the constitution.
The purpose of an external audit is NOT:
To act as a fraud investigation
To prepare the accounts
To provide a certificate to say “there are no problems”
Proof that internal control systems are effective
Evidence that accounts are 100% error free
94 © Mango 2009
Mango FM1 Course Handbook
Although it is not the prime role of the audit to detect fraud, this may of course come to light
during the checks that take place. Auditors have thus been described as ‘watchdogs not
bloodhounds’.
Appointment
An external audit can be conducted either as part of the annual review of accounts or as a
special review by a donor agency. It is conducted by a firm of accountants with recognised
professional qualifications.
Auditors are appointed by the Board of Trustees (or Annual General Meeting) or by a donor
for a special audit. They are independent of the organisation employing them. Being
independent means that the auditor must not have been involved in keeping the accounting
records and is not personally connected in any way with the organisation being audited.
What is involved?
Auditors only have a limited time in which to complete their work, so they concentrate on
testing the validity of a sample of transactions and results rather than vigorously checking
everything. Although an auditor’s independence must be respected and observed at all
times, they are nonetheless providing a service for a fee – you have a right to expect value
for money.
Auditor-speak de-mystified:
Test basis: A representative sample, the rest of the transactions are assumed to be
similar to the sample tested
Auditor-speak de-mystified:
‘True’ means that the transaction did take place and that an asset exists.
‘Fair’ means that a transaction is fairly valued and that assets and liabilities are fairly
stated.
© Mango 2009 95
Mango FM1 Course Handbook
If the auditors do not agree with the financial results as presented by the organisation, they
may issue a report saying that, in their opinion, the accounts are not fine. This could be
disastrous for an NGO seeking donor support.
The table below summarises the types of opinion.
Table 7.1: The status of the External Auditor’s Opinion
Unqualified The accounts do give a true and fair view – 'clean' audit report.
Qualified: Subject to The accounts are basically OK, apart from specific identified issues, eg an incorrect accounting
policy, or specific unsupported expenditure.
Qualified: Disagreement There are so many errors that the accounts do not give a true and fair view.
Qualified – disclaimer The auditors are unable to give an opinion, because the records are so poor or incomplete. This
is very bad indeed.
If the auditors propose any adjustments or changes to the draft financial statements, these
must also be approved by the Board. The audit report is addressed to the members and it is
usual to formally accept the report at the Annual General Meeting.
Auditors will also often provide a Management Letter. This is separate to the audit report
and is addressed to management. The report highlights weaknesses identified in the internal
control systems and makes recommendations for improvements. Managers have an
opportunity to respond to the findings outlined in the management letter and explain what
action they will take.
96 © Mango 2009
Mango FM1 Course Handbook
© Mango 2009 97
Mango FM1 Course Handbook
An Auditor’s Checklist
Acknowledgement: Grateful thanks to Samantha Musoke, ACA, of ACLAIM Africa, Uganda, for her input to this
chapter.
98 © Mango 2009
Mango FM1 Course Handbook
Useful References
© Mango 2009 99
Mango FM1 Course Handbook
© Mango 2009
Appendix 1: Chart Of Accounts – Milestone Project
INCOME: GENERAL
- Bank Interest 1110 Interest received on bank accounts
- Donations & fund-raising 1120 Fund-raising activities, miscellaneous donations
- Sales 1130 Sales of trainees’ work
- Training fees 1140 Course participants’ contributions
EXPENDITURE: ADMINISTRATION
- Audit/accountancy 3010 Audit fees, other accountancy expenses
- Bank charges 3020 Service fees, interest charged on OD balances
- Board meetings 3030 Room hire, refreshments, AGM expenses
- Depreciation 3040 Cost of depreciation of fixed assets
- Postage & stationery 3050 Postage, office and photocopier consumables
- Publicity 3060 Posters, leaflets, advertising training courses
- Rent, insurance & utilities 3070 Office rent, insurance and utilities
- Repairs & renewals 3080 Servicing, small items of equipment, office repairs
- Telephones/fax 3090 Telephone accounts, not repairs
EXPENDITURE: PERSONNEL
- In-service training 4010 Course fees, meals & accommodation
- Recruitment 4020 Recruitment advertising costs, interview expenses
- Salaries & benefits 4030 Gross salaries, housing, medical aid and pensions
- Travel & subsistence 4040 Per diem, meal and overnight allowances, bus fares
EXPENDITURE: TRAINING
- Fees & honoraria 6010 Guest speakers’ & external trainers’ fees/expenses
- Food & accommodation 6020 Room hire, food for trainees
- Training materials 6030 Tools, protective clothing, papers, pens, metal, concrete, etc
CURRENT ASSETS:
- Bank Deposit Account 0210 High interest call account
- Bank Current Account 0220 Cheque account
- Petty Cash 0230 For adjustments to the petty cash Imprest float
- Debtors & prepayments 0240 Money owed to us and prepaid amounts
- Advances 0245 Staff loans and working advances
- Grants receivable 0250 Grants due for this year from donors
- Stocks 0260 Stocks of raw materials
LIABILITIES:
- Creditors & accruals 0510 Money owed by us and accrued expenses
- Grants In advance 0520 Designated donor funds received for this year and not yet
spent
- Reserves 0530 Funds designated for use in future years
Bank Account Transfers Up to $25,000 Any two from: Ch, Tr, Se, CE, one other
designated BM
Over $25,000 Any two from: Ch, Tr, Se, one other
designated BM.
Staff advances/loans Max. $2,000 CE (or in case of CE, Ch or Tr)
Staff expenses LM for all staff below CE level
Ch or Tr for CE
Board Member expenses Ch or Tr
Orders for Goods & Services Up to $1,000 SO, providing within budget
Up to $5,000 OM, providing within budget
Up to $25,000 CE, providing within budget
Up to $50,000 Ch or Tr, providing within budget
Over $50,000 Any 2 BM and minuted by full Board
Meeting.
© Mango 2009 A2
Appendix 3: Bank Book – Receipts Page
MILESTONE PROJECT – January 2009
1 2 3 4 5 6 7 8 9 10 11
AN AL YS IS O F RE CEIP TS C ATE GO R Y
Date Details of transaction Recpt. Cost Total Grant Grant Donations Sales Training Other
No. Centre UC DFID SMILE & fundr’g Fees [add code]
1010 1020 1120 1130 1140
03/01 Cash received for sales goods 46m 03 250.00 250.00
10/01 Donation from Mrs Dlamini 21c 01 100.00 100.00
21/01 Course fees 03b 02 2,000.00 2,000.00
23/01 Misc. sales 04b 02 500.00 500.00
28/01 Course fees 47m 03-01 1,500.00 ` 1,500.00
30/01 4th qtr SMILE grant 05b 01 10,000.00 10,000.00
UC = Unit of currency
© Mango 2009 A3
Appendix 4: Bank Book – Payments Page
MILESTONE PROJECT – January 2009
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
AN AL YS IS O F P AYM E NTS C ATE GO R Y
Date Payee/ details of transaction Cheque Cost Amount Postage Rent, Ins Reprs/ Teleph. Salary Travel Fuel Food & Training Other
Or ref. Centre Paid & Stat’y & Utilities Ren Fax & Ben. & Subs 5010 Accom. Materials [add
no. UC * 3050 3070 3080 3090 4030 4040 6020 6030 code]
PAGE TOTAL: 11,692.08 155.19 1564.21 309.26 657.3 3900 222.85 1478.15 948 1457.12 1,000.00
* UC = Unit of currency
© Mango 2009 A4
Appendix 5: Petty Cash Book
MILESTONE PROJECT
Date PCV Details of transaction Cash Cash Cash Postage Repairs & Travel & Fuel Food/ Training Other
No. or cheque reference In Out Balance & stat’y Ren. subs Accom Mats.
UC UC UC 3050 3080 4040 5010 6020 6030
3/1 Cash balance brought forward: 23.46 - 23.46 - - - - - - -
3/1 - Top up cheque no. 013572 176.54 - 200.00
3/1 1 Milk & coffee for office - 10.57 189.43 10.57
3/1 2 Calculator batteries - 9.99 179.44 9.99
5/1 3 Stamps - 7.00 172.44 7.00
6/1 4 Petrol – Jo’s van. Bldg dept - 45.00 127.44 45.00
7/1 5 Fax paper - 13.49 113.95 13.49
10/1 6 OHP materials, pads & pens - 29.45 84.50 9.95 19.50
10/1 7 Petrol for Hari's car - 35.65 48.85 35.65
11/1 8 Oil - 5.50 43.35 5.50
12/1 9 DHL to New York - 35.00 8.35 35.00
12/1 10 Lunch/bus fare, Treasurer - 7.50 0.85 7.50
PAGE TOTAL: 200.00 199.15 0.85 65.44 20.56 7.50 86.15 - 19.50
A B C
UC = Unit of currency
Total A must = B + C
© Mango 2009 A5
Appendix 6: Sample Bank Reconciliation Form
Milestone Project January 2009
None
© Mango 2009 A6
Appendix 7: Sample Receipts & Payments Account
Receipts
Donor grants Received:
− DFID 48,000
− SMILE Trust 43,000
Donations & fundraising 750
Training fees 13,540
Sales 11,406
Bank interest 832
Total receipts 117,528
Payments
Personnel costs 46,580
Training expenses 20,588
Vehicle running expenses 14,886
Audit/accountancy 510
Bank charges 455
Board meetings 2,156
Postage & stationery 4,768
Publicity 396
Rent, insurance & utilities 9,985
Repairs & renewals 689
Telephones & fax 9,450
Office Equipment 1,850
Total payments (112,313)
UC = Unit of Currency
© Mango 2009 A7
Appendix 8: Sample Income & Expenditure Account
MILESTONE PROJECT
Statement of Income & Expenditure for the year ended 31 December 2008
2007
UC UC UC
INCOME:
Donor Income:
− DFID 48,000 45,000
− SMILE Trust 48,000 96,000 45,000
Other Income:
− Donations & Fundraising 6,750 6,600
− Training Fees 14,640 12,250
− Sales 11,765 6,768
− Bank Interest 832 33,987 698
TOTAL INCOME 129,987 116,316
EXPENDITURE:
Personnel Costs 52,580 48,780
Training Expenses 20,588 18,743
Vehicle Running Expenses 15,686 12,670
Depreciation 12,455 13,633
Administration:
− Audit/Accountancy 587 500
− Bank Charges 455 387
− Board Meetings 2,057 1,480
− Postage & Stationery 4,838 6,776
− Publicity 396 325
− Rent, Insurance & Utilities 9,994 6,524
− Repairs & Renewals 539 324
− Telephones & Fax 9,341 28,207 6,803
TOTAL EXPENDITURE 129,516 116,945
UC = Unit of Currency
© Mango 2009 A8
Appendix 9: Sample Balance Sheet
Milestone Project
Balance Sheet as at 31 December 2008
2008 2007
UC UC
FIXED ASSETS
Vehicles & Equipment:
- Value at 1 January 122,696 130,329
- Plus: Additions during the year 1,850 6,000
- Less: Depreciation for wear & tear (12,455) (13,633)
112,091 122,696
CURRENT ASSETS
Cash at bank and in hand 8,095 2,880
Grants Receivable 10,000 5,000
Debtors & Prepayments 2,459 1,000
20,554 8,880
ACCUMULATED FUNDS
Balance at beginning of the year 128,912 129,541
Plus surplus/(less deficit) for period 471 (629)
Represented by:
General Purposes Fund 6,292 5,216
Designated Fund 11,000 1,000
Capital Fund 112,091 122,696
129,383 128,912
UC = Unit of Currency
© Mango 2009 A9
Appendix 10: Schedule of Creditors & Debtors
Ref Budget Item Unit Quantity Unit Cost Total Notes Account
UC UC Code
A Project Staff Costs 30,300
A1 Metalwork trainer salary Month 12 1,775 21,300 4030
A2 Social Security/Employers' Taxes Month 12 213 2,550 12% of salary 4030
A3 Medical Insurance Lumpsum 1 4,300 4,300 20% of annual salary, rounded to nearest 100 4030
A4 In service training Days 10 150 1,500 For team training and technical training in RSA 4010
A5 Per diem Month 12 40 480 4040
A6 Field trip travel Lumpsum 1 170 170 To RSA 4040
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Incoming cash
DFID grant 18,000 0 0 24,000 0 0 24,000 0 0 24,000 0 0
Smile Trust grant 0 0 22,500 0 0 22,500 0 0 22,500 0 0 22,500
Vanguard Society grant 0 0 7,500 0 0 0 7,500 0 0 0 0 0
Bank Interest 40 5 0 0 71 0 0 74 0 26 96 0
Sales income 2,000 2,000 2,000 2,000 2,000 2,000 1,500 1,800 2,000 2,000 2,500 3,000
Donations 0 0 2,000 0 0 2,000 0 0 2,000 0 0 2,000
Training fees 3,500 7,000 0 7,000 3,500 0 0 7,000 3,500 0 7,500 3,500
A TOTAL CASH IN 23,540 9,005 34,000 33,000 5,571 26,500 33,000 8,874 30,000 26,026 10,096 31,000
Outgoing cash
Administration costs 2,000 2,000 5,000 2,000 2,000 7,100 2,000 2,000 2,000 2,000 2,000 2,000
Staff costs 5,600 5,600 5,600 5,600 5,600 5,600 6,200 6,200 6,200 6,200 6,200 6,400
Vehicle Running costs 22,000 2,500 2,500 3,000 2,500 2,500 3,000 2,500 2,500 3,000 2,500 2,500
Training programme 1,000 25,000 2,000 2,000 25,000 1,000 2,000 25,000 2,000 1,000 25,000 200
B TOTAL CASH OUT 30,600 35,100 15,100 12,600 35,100 16,200 13,200 35,700 12,700 12,200 35,700 11,100
C Net cash flow [A - B] (7,060) (26,095) 18,900 20,400 (29,529) 10,300 19,800 (26,826) 17,300 13,826 (25,604) 19,900
D Cash balance at start 8,095 1,035 (25,060) (6,160) 14,240 (15,289) (4,989) 14,811 (12,015) 5,285 19,111 (6,493)
of month
E Cash balance at end 1,035 (25,060) (6,160) 14,240 (15,289) (4,989) 14,811 (12,015) 5,285 19,111 (6,493) 13,407
of month [C + D]
UC = Unit of currency
1 2 3 4 [2 - 3] 5 6 7 8 [7 - 4]
Annual Budget Actual Balance Spent Spent Budget Grant See
Budget items: Budget last Qtr last Qtr remaining to date to date next Qtr claim Report
GBP GBP GBP GBP GBP % GBP GBP note no.
Administration Audit fees 1,200 0 0 0 1,267 106% 0 0
Bank charges 160 40 29 11 91 57% 32 21
Board Meeting 320 27 23 4 303 95% 27 23
Depreciation 1,600 0 0 0 0 0% 1,600 1,600
Post & stationery 2,000 500 426 74 1,814 91% 187 113 1
Publicity 400 100 43 57 189 47% 200 143
Rent, ins. & utilities 2,400 600 586 14 1,745 73% 573 560
Repairs & renewals 400 100 57 43 212 53% 187 143
Telephones/fax 1,680 420 572 (152) 1,548 92% 415 567 2
Staff Salaries & benefits 16,933 4,233 4,280 (47) 12,411 73% 4,280 4,327
In-service training 1,200 300 859 (559) 1,170 98% 30 589 3
Recruitment 0 0 0 0 36 - 0 0
Travel & subs. 800 200 210 (10) 585 73% 195 205
Vehicle Running Fuel 2,400 600 773 (173) 2,622 109% 874 1,047 4
Vehicle Insurance 4,800 0 40 (40) 4,720 98% 0 40
Vehicle maintenance 6,400 1,600 1,297 303 5,087 79% 1,307 1,004
Training Fees & honoraria 800 200 400 (200) 653 82% 147 347
Food & accomm. 4,267 1,067 1,027 40 3,501 82% 1,040 1,000
Training Materials 24,587 6,147 6,157 (11) 18,455 75% 6,133 6,144
TOTAL 72,347 16,133 16,780 (647) 56,409 78% 17,226 17,873
Total apportioned to DFID: 24,000 5,324 5,537 (213) 18,615 78% 5,385 5,599
% apportioned to DFID: 33% 33% 33% 33% 33% 33% 31%
A cash book for every bank account, reconciled To organise and summarise transaction information;
every month. check for errors and omissions.
A budget detailing costs and anticipated income Planning, fundraising, control and reporting.
for all operations.
Clear delegation of authority – from governing To know who is responsible for what and within what
body through the line management structure. limits.
Separation of duties – sharing finance To prevent temptation to steal and reduce opportunity
administration duties between at least two people to commit fraud; to share the load.
B. Good Practice
Standard Why
Additional accounting records when staff To meet statutory and audit requirements; for control
employed (wages book) or assets owned (Assets purposes.
Register).
Budgets based on real activity plans, which Realistic, more likely to meet targets.
include the full cost of running a project.
Budgets with clear calculations and notes. Easy to read and make adjustments. Easy to justify
calculations.
Monthly cash flow forecast. Helps to identify and take action to avoid short-term
cash flow problems.
Use of Cost Centres for multiple donors and/or To separate restricted funds and related transactions;
projects. to facilitate reporting to managers and donors.
Funding grids for multiple donors situations. To avoid double-funding situations and identify areas
of shortfall.
Written policies and procedures To prevent confusion about organisation rules and
expected practice.
Diversified funding base – mix of restricted and Less vulnerable to financial shocks; helps to build up
unrestricted funds. reserves.
NAME: ____________________________
POSITION: ____________________________
TOTAL CLAIMED :
I confirm that the above expenses have been/will be* necessarily incurred by me
during the course of my duties.
* Delete as appropriate
REF:
Name of Asset:
Description:
Location Of Asset:
Depreciation/Repairs/Insurance Schedule:
Date: Amount:
If yes, please attach copies and indicate preferred supplier with reasons.
CHECKED BY:
ENTERED IN DATE:
RECORDS BY:
A. Balance as on statement:
Less payments in cashbook, not on statement
(e.g. un-presented cheques)
B. Total deduction
C. Total addition
D. Total deduction
E. Total addition
Version 3
2009
Sections:
6 Staffing ............................................................................................ 8
Glossary ............................................................................................ 11
About Mango
Mango is a UK based charity which exists to strengthen the financial management of not-for-profit
organisations, including NGOs. Mango publishes freely available tools, like this one, as well as
running training courses and providing finance staff to work with NGOs. See www.mango.org.uk for
more details.
Version 3 2009 1
management. It is not an audit and it does not describe a standard set of procedures which are
relevant in every situation.
It is not appropriate to set a score as a ‘pass rate’ for partner assessment. It is not appropriate to
compare scores of two organisations and make conclusions about differences between them.
Explanation Score
Our practice is totally in accordance in with the statement 5
Close to 5, but not quite there 4
Close to 0, but not that poor 1
This is not in place, or is not true or does not happen 0
Clearly a degree of judgement is required to decide between ‘4’ or ‘1’, and it is not an exact science.
If you cannot give yourselves a clear cut 5 or 0, you need to decide which one you are closer to.
Often the real value in this exercise is not the score itself so much as the
conversations and the details of issues discussed.
Make good notes and keep a list of action points as they come up.
Ring the score for each statement. Add up the total for each section and transfer it to page 9 to get
a total. Then interpret the score using the guidance given.
Comments
Mango welcomes comments on its tools. Please send any comments or suggestions you might have
on the Health Check to Terry Lewis, [email protected]. Thank you!
Version 3 2009 2
Section 1 Planning & budgeting
Budgeting is about working out how much your planned activities are likely to cost. Both
programme and finance staff should be involved in setting budgets, to create a foundation for good
cooperation and coordination during spending and budget monitoring.
Budgets have a crucial role to play in strong financial management. Budgets should be approved by
the Board of Trustees, to check they reflect the planned strategic direction of the organisation.
Project managers can use a budget to guide implementation and check on progress. Overhead costs
that are shared by many projects also need to be carefully controlled by an assigned budget holder.
The codes used for your budget lines need to correspond to the codes used in your accounting
system. Otherwise it will be difficult to track actual spending against expected spending in your
budget monitoring reports.
A cash flow forecast is as important as a budget. It constantly looks 3-6 months into the future,
starting with the actual cash available now. It helps you to prioritise the timing and scale of planned
activities and to spot cash flow problems in good time.
1.2 Both finance and programme staff are involved in setting budgets 5 4 1 0
Version 3 2009 3
Section 2 Basic accounting systems
Every financial transaction should be backed up by a ‘supporting document’, e.g. a receipt, invoice or
sign sheet (eg for many travel reimbursements). This is the evidence that a specific transaction has
taken place.
Every transaction involving paying out or receiving money should be written down in a cashbook. It
can be kept in a physical cashbook or petty cashbook, on an Excel spreadsheet or as part of a
computerised accounting package. Every entry in the cashbooks should be referenced back to the
relevant supporting document.
It is important to check the accuracy of the accounting books at the end of each month by carrying
out two essential ‘reconciliations’. The bank statement balance is compared to the bank cashbook
closing balance. A physical cash count is done to check the closing balance in the petty cash book.
Accounting works by assigning codes to each transaction entered in the cashbooks. The unique list of
accounting codes that an organisation uses is called its “Chart of Accounts”. Another set of codes
can be used to assign transactions to a specific project or donor. These are called ‘cost centre’ codes.
2.4 There is a separate cashbook for each bank and cash account 5 4 1 0
Every entry in the cashbooks is cross referenced to a supporting
2.5 document 5 4 1 0
2.10 A bank reconciliation is done each month, for every bank account 5 4 1 0
Version 3 2009 4
Section 3 Financial reporting
The Board of Trustees need financial reports to oversee the finances of the organisation. Managers
need up-to-date figures to monitor projects and make decisions. Donor agencies need reports to
check the use of their money, and often as a condition for further funding. Increasingly, organisations
are sharing financial information with beneficiaries to increase accountability and build confidence. An
annual external audit verifies the accuracy of the financial statements.
The monthly financial reports should include an Income and Expenditure report showing money
coming into the organisation and how it was spent. If the report compares the amount spent against
budget, it is called a Budget Monitoring Report. The budget is supposed to be a tool not a straight
jacket. Project managers should use financial reports to help make decisions so that the money is used
efficiently and effectively to achieve desired outcomes.
It is also important to report on balances held at the end of each month or quarter. Balances includes
the amount of money held (cash and bank), as well as amounts owed to the organisation (such as
unaccounted working advances) and owed by the organisation (eg to suppliers / tax authorities).
Reports should be produced showing the relevant level of detail according to their use (eg for a single
project or donor) or consolidated. Reports should also have the right format for their use, eg donor
formats as per grant agreements, standard formats for annual audited accounts, accessible formats for
beneficiaries, user friendly formats for managers.
Version 3 2009 5
Section 4 Internal controls
Version 3 2009 6
Section 5 Grant management
Most NGOs get at least some of their funding as grants from donor partners. It is important to have a
grant agreement in place that outlines the amounts and timings of funds to be transferred.
Donors tend to fund specific projects with specific budgets which form part of the agreement.
The grant agreement may also contain a number of grant conditions, including procurement rules and
reporting requirements. Programme and Finance staff need to work together to ensure consistency
between the narrative and financial reports about the same project.
Often NGOs work with several different donors at the same time. It is very important to keep track of
which donor is funding which project (or part of a project). It is very bad practice to ‘borrow’ money
received from a donor for a specific project for another purpose.
5.5 Donors receive financial reports in the right format and on time 5 4 1 0
Donor financial and narrative reports are consistent and clearly
5.6 linked to each other 5 4 1 0
Donor funds are kept for the activities they are meant for and never
5.7 ‘borrowed’ for other activities 5 4 1 0
Version 3 2009 7
Section 6 Staffing
Good financial management is dependent on staff with the right skills, support, and attitude to carry
out their responsibilities. All staff have a role to play in financial management. The accounting staff
are part of a wider team including the Executive Director, Programme Managers and the Board.
Integrating good financial management into programmes involves budget holders and finance staff
working hand in hand through all the stages of the financial cycle (plan-do-review).
It may be difficult to assess the technical competence of accounting staff. Good indicators are the
timeliness of reports, the neatness of files and records in the accounts office, and auditor’s comments
or recommendations.
6.7 Finance staff are recruited freely and fairly on the basis of merit only 5 4 1 0
All staff receive the training and support they need to carry out their
6.8 financial management responsibilities 5 4 1 0
Version 3 2009 8
Interpreting your score
Record your score for each section in this table. Then compare it to the columns on the right and
ring or shade the appropriate risk assessment for each section. Finally add up your total score
and see the advice below.
3. Financial reporting 0 - 20 21 - 35 36 - 40
4. Internal controls 0 - 40 41 - 60 61 - 75
5. Grant management 0 - 15 16 - 25 26 – 35
6. Staffing 0 - 20 21 - 30 31 - 40