Share

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

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

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.

Comments

[Cancel] | Reply to:

Close »

Community Standards

The civilsociety.co.uk 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

Please:

  • 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 Disasters Voluneteers (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

Ian Allsop (57) John Tate (49) David Davison (47) Robert Ashton (40) Tania Mason (23) Gordon Hunter (17) Andrew Hind CB (14) Daniel Phelan (14) Vibeka Mair (12) David Philpott (10)
Gareth Jones (8) Celina Ribeiro (8) Niki May Young (8) Rui Domingues (8) Andrew Chaggar (5) James Brooke Turner (4) Sir Stuart Etherington (4) Kate Sayer (3) Jeremy Swain (3) Garreth Spillane (3) Alistair Gibbons (3) Ian Clark (3) Claris D'cruz (2) Stephen Lloyd (2) Richard Maitland (2) Adrian Beney (2) Iain Pritchard (2) Pauline Broomhead (2) Daniel Fletcher (2) Martin Brookes (2) Tesse Akpeki (2) Nick Brooks (2) Stephen Hammersley (2) June O'Sullivan (2) Peter Holbrook (2) Belinda Pratten (2) Simon Steeden (2) Jonathan Bruck (2) Dan Gregory (2) Mark Astarita (1) Don Bawtree (1) Sir Stephen Bubb (1) Victoria Cook (1) Lindsay Gray (1) Rachel Holmes (1) Nick Ivey (1) Iona Joy (1) John Kelly (1) Michael King (1) Heather Lamont (1) Lucy McLynn (1) Chris Oulton (1) Julian Rathbone (1) Socrates Socratous (1) Richard Weaver (1) Karl Wilding (1) Richard Williams (1) Roger Chester (1) Matthew Bowcock (1) Reuben Turner (1) Martin Farrell (1) Paul Gibson (1) Becky Slack (1) Jonathon Grapsas (1) Andrew Scadding (1) Simon Hebditch (1) Su Sayer (1) Debra Allcock Tyler (1) Martin Birch (1) Mark Hallam (1) Jonathan Lewis (1) Sara Llewellin (1) John Low (1) Dame Mary Marsh (1) Ruth Murphy (1) Colin Nee (1) Julia Unwin (1) Kate Rogers (1) Malcolm Hayday (1) Filippo Addarii (1) Kimberley Scharf (1) Jakes Ferguson (1) Jessica Sklair (1) Joe Turner (1) John May (1) Julian Blake (1) Rosie Chapman (1) Andy Williamson (1) Malcolm Hurlston (1) Andrew Samuel (1) Chester Mojay-Sinclare (1) Paul Amadi (1) Kirsty Weakley (1) Dan Corry (1) Peter Mitchell (1) Billy Dove (1) Andrew Ketteringham (1) Jackie Turpin (1) Lynne Robb (1) Jonathan Crown (1) Paul Emery (1) Ruchir Shah (1) Pesh Framjee (1) Sukhvinder Kaur-Stubbs (1) Moira Protani (1) Vicki Prout (1) Michael O'Toole (1) Dawn Austwick (1) Lisa Clavering (1) Paul Farmer (1) Neelam Makhijani (1) Logan Anderson (1) Andy Rich (1) Sharon Martin (1) Asheem Singh (1)
Less +++ More +++

A charity CEO's top ten social media tips

15 Apr 2014

There are ups and downs to being a charity chief executive on social media, says Simon Blake, but it's...

From social to CRM – What’s on fundraiser’s minds?

14 Mar 2014

Data. It’s on every fundraiser’s radar. But in the face of ever more data being generated, what do...

What charity CRM vendors are really saying

10 Mar 2014

What do CRM vendors really mean when they are selling charities a package? Robin Fisk deciphers the lingo....

Society Diary: Is it a bird? Is it a plane? No it's a charity minister

11 Apr 2014

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

Society Diary: NCVO and Acevo jump on social enterprise bandwagon

4 Apr 2014

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

A strong charity sector needs a strong regulator

3 Apr 2014

Society and government are growing more reliant on charities, so why don't they do more to support its...