Book keeping excel Workbook UPDATED

[happytoddlers]

Hi All!

I recently started childminding and found that the book keeping has been a bit of a headache. Although the NCMA forms are a good starting point, I did find that there was a lot of repetition on entries and endless flicking through pages of weekly accounts / totals / this and that...
So last night I decided to create this in excel in a format that is useful and does all the calculations for heating/lighting, Council tax, Water etc... by proportioning your weekly hours with the guidelines stated by the HMRC. It also calculates the end-of-year accounts on the fly and gives a profit/loss graph. I certainly think this will save me a lot of time (of which I just didn't have!) and make the tax return a lot easier.

Feel free to use it although you may want to check my calculations. I've locked the cells that you don't need (shouldn't) change because they're calculated for you. I've coloured the cells in blue which are the ones you can alter.
Hope someone finds this useful!

Thanks,

Hayley

<Note from admin - See post 88 in this thread for the latest spreadsheet 2014/15>

[MrAnchovy]

That spreadsheet looks good happytoddlers, although note that the calculations for part-time hours for heat/light etc. don't have to be that complicated - you can just add up your total hours for the year and divide by 52 to get the average number of hours per week. This usually works out better because weeks you work over 40 hours make up for some time on weeks you are on holiday etc.

[Bridey]

Wow, a lot of work went into that! I already use a commercially produced excel sheet that I purchased some years ago and its not far off what you have produced to be honest. And yours is free! I hope people find it useful.

I noticed you are numbering receipts for items under £10, as childminder's we don't need to keep those ones but there is no harm in doing so if you wish.

[happytoddlers]

Thanks for the comments! Great point regarding the hours worked, using an average would be far easier and a financial benefit especially as I've capped the percentage in the spreadsheet. As I'm new to this I have perhaps gone further than I need to so it's good to hear where the complexity can be cut down.

Thanks all!

Hayley

[Donkey]

That spreadsheet looks good happytoddlers, although note that the calculations for part-time hours for heat/light etc. don't have to be that complicated - you can just add up your total hours for the year and divide by 52 to get the average number of hours per week. This usually works out better because weeks you work over 40 hours make up for some time on weeks you are on holiday etc.

now why didn't I think of that!!!!!!!!

[clairelou]

I might have to have a go with this, mine cause me such a headache!!

[SammyL]

thank you so much for posting this - it's going to be a great help for me

[k1rstie]

you can just add up your total hours for the year and divide by 52 to get the average number of hours per week. This usually works out better because weeks you work over 40 hours make up for some time on weeks you are on holiday etc


Is this really true?

As many childminders often work 50 hours + per week, this idea could add up to a lot of extra expenditure, so a reduction in tax to be paid

[mum24]

WOW this is so good, I keep excel lists for income and another for expenditure then have to total them all together, this is lovely, all in one place.
Thank you so much for sharing...

[samb]

Well done looks fab.

I have done my own too. I have so far changed it each tax year slightly to make it easier to read etc. For example I decided I didn't like having the workings out of things like mileage and food all on the same sheet so created a separate sheet which just takes the total for each month back to the added up expenses bit making it look a bit tidier for me. I used to have everything squashed in the same bit.

Thanks Mr A - I think I will now create another page to do my bills rather than working it out every month as well!

One day I will be happy with what I've got LOL!

[mum24]

I was really impressed with your work book and now having begun to use it, it is just such a time saver. Thank you much for sharing this.

So I wondered if anyone would be interested in this invoice that I used for a client who used different days and times over the week, then none the next week, really erratic hours. You can use it as an attendance record as well, and it calculates to the minute if you want it to, with two different hourly rates if needed.. I hope it is useful to someone.

I hope it has attached, I have been trying to work it out for ages....I am a complete newbie at all this internet stuff, so please bear with me.

[samb]

I was really impressed with your work book and now having begun to use it, it is just such a time saver. Thank you much for sharing this.

So I wondered if anyone would be interested in this invoice that I used for a client who used different days and times over the week, then none the next week, really erratic hours. You can use it as an attendance record as well, and it calculates to the minute if you want it to, with two different hourly rates if needed.. I hope it is useful to someone.

I hope it has attached, I have been trying to work it out for ages....I am a complete newbie at all this internet stuff, so please bear with me.

I would be interested - although, no it hasn't attached - maybe cos you only have new member access?

[hectors house]

Just spend an hour setting up a spread sheet similar to NCMA accounts book as fed up of the repetition of doing everything weekly and adding up manually - then I found your spread sheet - guess I just wasted an hour, thank you so much for making your hard work open to all it looks fantastic.

[Daisy1956]

Thanks for sharing, it looks really good.

[kaztops]

Hi Hayley,

I don't seem to be able to get your link to work for the spreadsheet? Any ideas?

Thanks,

Karen

[happytoddlers]

Link now fixed...

Any comments or addition suggestions then please let me know!

Thanks!

<Note from admin - See post 23 in this thread for the latest spreadsheet>

[happytoddlers]

Can't stand doing accounts??...

Here is an amended Book Keeping spreadsheet for anyone interested. This does all I need for the accounts and has saved me huge amounts of time.
Differences from the previous version are: More space for expenses and now calculates mileage costs from pence/mile.
Comments welcome...

Thanks!

[happytoddlers]

Hi All,

Some people have had trouble downloading the spreadsheet. Please find it here:

www.horrod.com/Accounts.xls

Thanks!

[dette]

DH did me a version of this last year but yours looks great.Doin our books tonight so i think we'll use yours this time x

[LozanneV]

Hi All,

Some people have had trouble downloading the spreadsheet. Please find it here:

www.horrod.com/Accounts.xls

Thanks!

Thank you so much. This is perfect!...Was just moaning on another thread that someone out there surely must have a spreadsheet and then I saw yours!! This is perfect. Thank your husband too!!: