-
07-04-2014, 04:39 PM
#101
Hi,
I have tried to put the hours in the columns but it throws up a different time to what I put in very odd, any ideas please x
Cath
-
07-04-2014, 07:10 PM
#102
Thank you so much. I hate working out the hours I need to invoice.
-
12-04-2014, 02:04 PM
#103
Originally Posted by
cathtee
Hi,
I have tried to put the hours in the columns but it throws up a different time to what I put in very odd, any ideas please x
Same thing happens for me too :/ x
-
12-04-2014, 09:42 PM
#104
Originally Posted by
Shamcc
Same thing happens for me too :/ x
Hi,
Please make sure you use a colon and not a decimal point (or full stop) between the hours and minutes.
So write the times 16:30 for example and not 16.30
Hope this helps!
Thanks
-
12-04-2014, 11:48 PM
#105
Hi All,
After this FY I've realised that I should be claiming more proportioned costs such as 33% of the TV Licence, 50% of mobile phone, 50% of ink cartridges etc.. All helps So the spreadsheet now has an extra few columns allowing you to enter these easily. If it's easier then I guess we're more likely to put them down and save more.
Downloads below..
Under 'Shared Family/Business Costs' put the full amount such as £12.12 for a TV Licence. Then under '% Proportion Childminding' put say 33. The spreadsheet will then calculate this proportion and add it to your expenses. I've put a few examples in for you to see which you can replace with your own entries.
Download is here..
www.horrod.com/Accounts201415V3.xlsx
or for older versions of excel..
www.horrod.com/Accounts201415V3.xls
Thanks
-
13-04-2014, 06:45 AM
#106
Originally Posted by
happytoddlers
Hi All,
After this FY I've realised that I should be claiming more proportioned costs such as 33% of the TV Licence, 50% of mobile phone, 50% of ink cartridges etc.. All helps
So the spreadsheet now has an extra few columns allowing you to enter these easily. If it's easier then I guess we're more likely to put them down and save more.
Downloads below..
Under 'Shared Family/Business Costs' put the full amount such as £12.12 for a TV Licence. Then under '% Proportion Childminding' put say 33. The spreadsheet will then calculate this proportion and add it to your expenses. I've put a few examples in for you to see which you can replace with your own entries.
Download is here..
www.horrod.com/Accounts201415V3.xlsx
or for older versions of excel..
www.horrod.com/Accounts201415V3.xls
Thanks
Query the tv license is that allowable?
When someone tells you nothing is impossible, tell them to go slam a revolving door
-
13-04-2014, 07:09 PM
#107
Originally Posted by
FussyElmo
Query the tv license is that allowable?
I read somewhere on this forum that you can claim up to 1/3 of your tv license....apparently. :-)
-
13-04-2014, 07:49 PM
#108
See page 10. TV licence isn't an allowable expense unfortunately
http://www.childmindinghelp.co.uk/fr...nformation.pdf
-
13-04-2014, 09:59 PM
#109
Last edited by happytoddlers; 13-04-2014 at 10:10 PM.
-
Post Thanks / Like - 0 Thanks, 1 Likes, 0 Dislikes
Rick liked this post
-
14-04-2014, 08:44 PM
#110
Fantastic resource, many thanks once again
-
20-05-2014, 12:53 PM
#111
Hi Hayley,
would you be able to private message me the password to unlock?
only i only started my business in March, and its calculating my average hours over the 12 months, making it 0.90 hours
thanks
Originally Posted by
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>
-
20-05-2014, 12:56 PM
#112
Originally Posted by
lindsay.butler
Hi Hayley,
would you be able to private message me the password to unlock?
only i only started my business in March, and its calculating my average hours over the 12 months, making it 0.90 hours
thanks
sorry don't worry, realised its not password protected, thanks
-
20-05-2014, 09:21 PM
#113
hello
hello may someone send me the link for the spread sheet please x
-
26-05-2014, 07:16 PM
#114
Originally Posted by
samijored
hello may someone send me the link for the spread sheet please x
www.horrod.com/Accounts201415.xls
or for newer versions of excel (2003 on) use..
www.horrod.com/Accounts201415.xlsx
Thanks for using..
-
19-06-2014, 08:20 PM
#115
Thank you happytoddlers for sharing This is fantastic and very useful!
-
12-07-2014, 10:01 PM
#116
spreadsheet and tax return
Hi
I use that spreadsheet and it's fab!!!
Can someone advise me? Hope this question makes sense?!
In the tax year 2013-2014 I used NCMA book accounts. In my tax return I put 31.03.2014 as end of accounts.
For 2014-2015 I'm using this great spreadsheet. Accounts period on it starts on 7th of April so on tax return it looks like I have a gap (01/04-06/04).
What shall I do with it so my books are correct?
thanks in advance for any help
-
25-07-2014, 06:17 PM
#117
Book keeping excel Workbook UPDATED
Hello,
Thank you so much for the fantastic spreadsheet.
I am a new Childminder and I'm thinking to start each month from the 1st, not sure if it is the correct way. I'm using the 2013/14 at the moment.
Would it be possible to send me by private message the password to unlock it.
Thanks again.
Originally Posted by
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>
-
20-09-2014, 12:11 PM
#118
Originally Posted by
olicja
Hi
I use that spreadsheet and it's fab!!!
Can someone advise me? Hope this question makes sense?!
In the tax year 2013-2014 I used NCMA book accounts. In my tax return I put 31.03.2014 as end of accounts.
For 2014-2015 I'm using this great spreadsheet. Accounts period on it starts on 7th of April so on tax return it looks like I have a gap (01/04-06/04).
What shall I do with it so my books are correct?
thanks in advance for any help
I was wondering the same thing & I can't seem to insert the missing 6 days into the hours worked section.
-
04-11-2014, 03:57 PM
#119
working tax credits
Do you declare all your expenses if you are receiving working tax credit rather than paying tax ie you are working less hours? Also if you are doing other work, in my case tutoring can I use the same process-are allowances specific to childminding or do they generally apply to self employed people?
-
05-11-2014, 05:01 PM
#120
self employment
I'm thinking I should put the tutoring on the same spreadsheet but perhaps unlock and edit the wording-and use the same percentage principle as for childminding. The only thing is I don't know if my expenses will actually make any difference to my final TC award. I think you get the full wack until you earn over £5,000-ish
Thanks for the fantastic spreadsheet of course btw!
Bookmarks