Me, doing the accounts, sure, why not?!

Me, doing the accounts, sure, why not?!

Me, doing the accounts, sure, why not?!

Finance | Andrew Chaggar | 30 Mar 2012

Back to the nitty-gritty of running a charity in the UK, Andy Chaggar is finding a steep learning curve arising from a growth in income.

It seems like I’ve done little other in the past month than stare at spreadsheets. Columns and columns of figures have left me feeling somewhat cross-eyed as I’ve worked away on two fairly major financial tasks: our charity’s annual report for last year and the financial sections of the business plan I talked about last month.

These two tasks, while separate, are heavily intertwined as they both demand various forms of financial analysis. Our annual report needs to contain financial statements for the past year and the business plan calls for various forms of historical financial analysis which support the included forecasting. For me, this means a huge amount of number crunching made all the more challenging by our ageing financial systems.

When we first founded EDV in late 2008 I knew that properly documenting our finances was going to be essential to our success. However as a new organisation, founded by people who had just spent the past few years volunteering rather than earning money, resources were scarce. Consequently we didn’t have the luxury of sitting down with a paid accountant and setting up a system that tracked everything and automatically generated all the various reports needed.

Instead the charity got some spreadsheets, me, and my 6 years of experience as a semiconductor engineer. Although I had little, if any, formal accountancy experience I had been trained - by Germans no less - in how to think logically and make millions of transistors not only fit onto a few square millimeters of silicon but also function as a computer. Surely, I thought, it couldn’t be too hard to keep track of money!

So I sat down and started writing down all the likely income and expenditure scenarios I could think of, thinking especially hard about the sometimes chaotic situations I had found myself in while handling money in two previous disaster zones. When I was reasonably happy I wrote a specification and asked people I knew with related experience to review it. Using their feedback I then built the management accounting system that our charity pretty much still uses to this day.

Too big for our (accountancy) boots

The system I built was all fine when our income was only around £16,000, which it was the last time we prepared an annual report. This year, however, we are reporting on a period with income approaching £140,000, and things have been starting to creak. While our independent examiner (Vin) and I recently agreed on draft financial statements for the report, the process of getting there was sometimes painful.

Because I had essentially created the system myself, some major sections needed changes to get them into a format Vin could use without having to spend lots of (billable) hours understanding. I also had to spend a lot of time relabelling incorrectly categorised transactions to be able to generate correct breakdowns.

Worse still, our accounting period covers our work in Haiti - a country that freely uses the American dollar, its own imaginary dollar (read this Wikipedia entry if you don’t believe me) in addition to its actual local currency. Depending on the best deal we made transactions in all of these. This means that exchange rate fluctuations have turned into my arch-nemesis.

Overall then the process of preparing the accounts for independent examination took me far longer than I can afford to spare and the amount of data that will need to be processed will only grow as our charity does.

Furthermore the annual report essentially contains only one-years worth of data and only relative to one fixed point time (our accounting reference date). The financial statements for the business plan need to reflect 3 years of history and up to the same amount of forecasting. They also need to be easy to update, ideally on a quarterly basis, to enable us to monitor and act on results so that our business plan can be a management tool as well as a communications one.

The increasing strains on our now tired accounting system are part of the reason why I’m tackling all my current financial work as a larger whole rather than as isolated tasks. Once our annual accounts are finalised and submitted the plan is to incorporate all the updates needed into a newer, streamlined system that I can then use to more easily generate the business plan numbers as well as further annual statements in future years.

This is the plan, at least as long as I can avoid the evil of exchange rate fluctuations anyway.

In a blog two months ago I stated that local CVS organisations were unlikely to be able to offer much practical support to new groups that operated internationally. This turns out to be wrong and since writing that post I have accessed the Community Accounting Service at York CVS who I wish to thank for an effective and well-priced independent examination.


[Cancel] | Reply to:

Close »

Community Standards

The community and comments board is intended as a platform for informed and civilised debate.

We hope to encourage a broad range of views, however, there are standards that we expect commentators to uphold. We reserve the right to delete or amend any comments that do not adhere to these standards.

We welcome:

  • Robust but respectful debate
  • Strongly held opinions
  • Intelligent relevant discussion
  • The sharing of relevant experiences
  • New participants

We will not publish:

  • Rude, threatening, offensive, obscene or abusive language, or links to such material
  • Links to commercial organisations or spam postings. The comments board is not an advertising platform
  • The posting of contact details for yourself or others
  • Comments intended for malicious purpose or mindless abuse
  • Comments purporting to be from another person or organisation under false pretences
  • Gratuitous criticism, commentary or self-promotion
  • Any material which breaches copyright or privacy laws, or could be considered libellous
  • The use of the comments board for the pursuit or extension of personal disputes

Be aware:

  • Views expressed on the comments board are left at users’ discretion and are in no way views held or supported by Civil Society Media
  • Comments left by others may not be accurate, do not rely on them as fact
  • You may be misunderstood - sarcasm and humour can easily be taken out of context, try to be clear


  • Enjoy the opportunity to express your opinion and respect the right of others to express theirs
  • Confine your remarks to issues rather than personalities

Together we can keep our community a polite, respectful and intelligent platform for discussion.

Andrew Chaggar

Andy Chaggar is executive director of International Disaster Volunteers (IDV) which he co-founded in 2008. In 2004, he was seriously injured and bereaved in the South East Asian tsunami, after which he became a disaster response volunteer, and founded IDV.

Follow Andy on Twitter @IDVExec

Tesse Akpeki (55) Martin Farrell (46) Robert Ashton (41) Tania Mason (23) Andrew Chaggar (23) David Ainsworth (19) David Philpott (14) Making Good: The Future of the Voluntary Sector (13) Ian Allsop (12) Vibeka Mair (11)
Niki May Young (11) Celina Ribeiro (10) Dorothy Dalton (10) Kirsty Weakley (10) Leon Ward (10) Gordon Hunter (9) David Davison (8) John Tate (8) Neal Green (5) Jeremy Swain (5) Rowena Lewis (5) Andrew Hind CB (4) Daniel Phelan (4) Belinda Pratten (4) Suzi Leather (3) Stephen Lloyd (3) Pauline Broomhead (3) Rosie Chapman (3) Ingrid Marson (3) Alexander Swallow (3) Alice Sharman (3) Sir Stuart Etherington (2) Adrian Beney (2) Joe Saxton (2) Jesper Christensen (2) Paul Gibson (2) Andrew Scadding (2) Anne Moynihan (2) Rosamund McCarthy (2) Kevin Carey (2) Garreth Spillane (2) June O'Sullivan (2) Dan Corry (2) Paul Emery (2) Simon Steeden (2) Lesley-Anne Alexander CBE (1) Victoria Cook (1) Claris D'cruz (1) Peter Gotham (1) Sir Thomas Hughes-Hallett (1) Justin Davis Smith (1) Kate Sayer (1) Alison McKenna (1) Paul Palmer (1) Anne-Marie Piper (1) Jo Swinhoe (1) Karl Wilding (1) Richard Williams (1) Mike Hudson (1) Sir Christopher Kelly (1) Martin Brookes (1) Simon Hebditch (1) Lindsay Driscoll (1) Jo Coleman (1) Cedric Frederick (1) Jonathan Lewis (1) Dame Mary Marsh (1) Jill Pitkeathley (1) Nick Brooks (1) Linda Laurance (1) Suzie Who (1) James Thompson (1) Stephen Hammersley (1) John May (1) Julian Blake (1) Malcolm Hurlston (1) Andy Gregg (1) Andrew Purkis (1) Anne Owers (1) Beth Yorath (1) Paul Amadi (1) Caroline Beaumont (1) Judith Davey (1) Diane Lightfoot (1) Douglas Rouse (1) Jackie Turpin (1) Jonathan Last (1) Lynda Thomas (1) Tom Flood (1) Dan Sutch (1) Jenni Cahill (1) Jonathan Crown (1) Ruchir Shah (1) Katy Wing (1) George Ames (1) Jenny North (1) Sir David Varney (1) Liam Barrington-Bush (1) Mairéad O'Reilly (1) Tobin Aldrich (1) Michael O'Toole (1) Lisa Clavering (1) Jamie Ward-Smith (1) Ian Joseph (1) Jonathan Bruck (1) Rachel Short (1) Dr Debra Beck (1) Andy Rich (1) Ian Leggett (1) Leigh Daynes (1) Tim Willis (1) Richard Caulfield (1) Emma Callagher (1) Andrew O'Brien (1)
Less +++ More +++

Going beyond the Sorp

1 May 2015

Andrew Hind has some advice for charities in the process of writing their annual reports.

Star gazing in the charity sector

1 May 2015

Ian Allsop ponders the meaning of rising stars, fading stars and no stars.

Technology lessons from down the ages

1 May 2015

Holiday technology frustrations remind John Tate of some important IT rules.

Free eNews

Join the discussion


Attending our one day courses is a highly effective way of ensuring new and existing trustees fully understand their role, responsibilities and liabilities.

>> Find out more <<