Book keeping excel Workbook UPDATED
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 :idea: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>
Book keeping excel Workbook
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...
bookkeeping excel work book - invoice template
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.
Amended Book Keeping Spreadsheet....
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!
Version 3 of the Book keeping excel sheet - Averaging hours per week over the year
Hi all,
I like the idea of averaging hours per week over the year so the utility bill portion isn't capped at 40 hours/wk. Here is the spreadsheet with this modification.....:)
<Note from admin - See post 23 in this thread for the latest spreadsheet>