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

Team talk and a CRM upgrade

19 Jul 2016

A CRM upgrade is not just about tech – you need to consider the effect on people, says Ivan Wainewright....

The ‘fake’ charity app scam could damage trust in charities

21 Jun 2016

Kirsty Weakley argues that if charities don’t understand what their technology partners are doing, they...

Environmentally-friendly printing - is it possible?

25 May 2016

SaxoPrint highlights how environmentally-friendly printing products and affordability for charities need...

Charity highlights from the Labour Party Conference 2016

30 Sep 2016

Alice Sharman and Kirsty Weakley went to Liverpool earlier this week for the Labour Party Conference....

Does anyone in Labour have any policies for the charity sector?

30 Sep 2016

Did we learn much about Labour’s policy on the voluntary sector at its annual conference? Probably not,...

Society Diary: By the end of the party conference, that glass of wine seemed very, very far away

30 Sep 2016

Our weekly round-up of interesting and outlandish information, collected from the corners of the charity...