Book keeping excel Workbook UPDATED
Thanks Thanks:  0
Likes Likes:  53
Dislikes Dislikes:  0
Page 6 of 11 FirstFirst ... 2345678910 ... LastLast
Results 101 to 120 of 219
  1. #101
    Join Date
    Feb 2010
    Location
    at the mad hatters' tea party
    Posts
    1,620
    Registered Childminder since
    Sept 90
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    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

  2. #102
    Join Date
    May 2009
    Location
    Bolton
    Posts
    802
    Registered Childminder since
    June86
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Thank you so much. I hate working out the hours I need to invoice.

  3. #103
    Join Date
    Jul 2013
    Posts
    1
    Registered Childminder since
    May 03
    Post Thanks / Like

    Default

    Quote Originally Posted by cathtee View Post
    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

  4. #104
    Join Date
    Jul 2012
    Posts
    56
    Registered Childminder since
    June 12
    Post Thanks / Like

    Default

    Quote Originally Posted by Shamcc View Post
    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

  5. #105
    Join Date
    Jul 2012
    Posts
    56
    Registered Childminder since
    June 12
    Post Thanks / Like

    Default

    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

  6. #106
    Join Date
    Jan 2009
    Location
    in the never never land fighting off fae
    Posts
    6,880
    Registered Childminder since
    july05
    Post Thanks / Like
    Blog Entries
    9

    Default

    Quote Originally Posted by happytoddlers View Post
    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

  7. #107
    Join Date
    Jul 2012
    Posts
    56
    Registered Childminder since
    June 12
    Post Thanks / Like

    Default

    Quote Originally Posted by FussyElmo View Post

    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. :-)

  8. #108
    Join Date
    Sep 2012
    Posts
    3,040
    Registered Childminder since
    Oct 12
    Latest Inspection Grade
    GOOD! Hurrah
    Post Thanks / Like
    Blog Entries
    1

    Default

    See page 10. TV licence isn't an allowable expense unfortunately

    http://www.childmindinghelp.co.uk/fr...nformation.pdf

  9. #109
    Join Date
    Jul 2012
    Posts
    56
    Registered Childminder since
    June 12
    Post Thanks / Like

    Default

    Quote Originally Posted by Rick View Post
    See page 10. TV licence isn't an allowable expense unfortunately

    http://www.childmindinghelp.co.uk/fr...nformation.pdf
    Thanks for the great link there. Further searching....NCMA claim that you can only claim the TV License if it is solely used for childminding..which I should think in most cases is not the case. See downloadable document below:

    http://www.horrod.com/NCMAv5.pdf
    Last edited by happytoddlers; 13-04-2014 at 10:10 PM.

  10. Likes Rick liked this post
  11. #110
    Join Date
    Aug 2011
    Location
    North Wales
    Posts
    115
    Registered Childminder since
    June 12
    Non childminder member
    I AM a childminder
    Post Thanks / Like

    Default

    Fantastic resource, many thanks once again

  12. #111
    Join Date
    Nov 2013
    Posts
    31
    Post Thanks / Like

    Default

    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


    Quote Originally Posted by happytoddlers View Post
    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>

  13. #112
    Join Date
    Nov 2013
    Posts
    31
    Post Thanks / Like

    Default

    Quote Originally Posted by lindsay.butler View Post
    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

  14. #113
    Join Date
    May 2012
    Location
    swansea
    Posts
    20
    Registered Childminder since
    JUNE 13
    Post Thanks / Like

    Default hello

    hello may someone send me the link for the spread sheet please x

  15. #114
    Join Date
    Jul 2012
    Posts
    56
    Registered Childminder since
    June 12
    Post Thanks / Like

    Default

    Quote Originally Posted by samijored View Post
    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..

  16. #115
    Join Date
    Apr 2014
    Posts
    1
    Post Thanks / Like

    Default

    Thank you happytoddlers for sharing This is fantastic and very useful!

  17. #116
    Join Date
    Jan 2013
    Posts
    3
    Registered Childminder since
    Dec 12
    Post Thanks / Like

    Post 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

  18. #117
    Join Date
    Oct 2012
    Posts
    1
    Registered Childminder since
    Sept 12
    Non childminder member
    N/a
    Post Thanks / Like

    Default 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.

    Quote Originally Posted by happytoddlers View Post
    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>

  19. #118
    Join Date
    May 2012
    Location
    Kent
    Posts
    403
    Registered Childminder since
    Sept 12
    Post Thanks / Like

    Default

    Quote Originally Posted by olicja View Post
    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.

  20. #119
    Join Date
    Nov 2014
    Posts
    8
    Post Thanks / Like

    Default 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?

  21. #120
    Join Date
    Nov 2014
    Posts
    8
    Post Thanks / Like

    Default 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!

 

 
Page 6 of 11 FirstFirst ... 2345678910 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Quick Links and Advertisements

Important Information Links
Some Useful Quick Links
Advertisements

 

You can also find us on:
Book keeping excel Workbook UPDATED Book keeping excel Workbook UPDATED Book keeping excel Workbook UPDATED

We use cookies to make this site as useful as possible. They are small text files placed in your browser to track usage of our site but they don’t tell us who you are.
By continuing to use this site you are consenting to cookies being placed on your computer. Find out more here: Cookies in Use

Childminding Help and the Childminding Forum are part of Childcare.co.uk