Book keeping excel Workbook UPDATED
Thanks Thanks:  0
Likes Likes:  51
Dislikes Dislikes:  0
Page 3 of 11 FirstFirst 1234567 ... LastLast
Results 41 to 60 of 219
  1. #41
    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

    Thank you this has been a life saver. The NCMA accounts book is soooo long winded and time consuming. I have just transferred all my accounts over and it took next to no time. Will it be easy to change details for next years' accounts?

    Thanks again x

  2. #42
    Join Date
    Oct 2010
    Location
    Llanelli
    Posts
    112
    Registered Childminder since
    oct 10
    Post Thanks / Like

    Default

    Perfect thanks sooooo much for sharing xxx

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

    Default

    Hi,

    Thanks for your message. I will be updating this spreadsheet with 2013-14 dates and will post it to this thread for people to download. I promise I'll do it before the new tax year!

    Thanks!

    Quote Originally Posted by Cariad View Post
    Thank you this has been a life saver. The NCMA accounts book is soooo long winded and time consuming. I have just transferred all my accounts over and it took next to no time. Will it be easy to change details for next years' accounts?

    Thanks again x

  4. Likes SandCastles, Cariad liked this post
  5. #44
    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

    Wow, thanks again. I wasn't fishing for this, just wondering if there was an easy way to change it all. But if you're happy to do this and share that's amazing.

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

    Default

    Thanks I will look out for it.

  7. #46
    Join Date
    Feb 2013
    Posts
    9
    Registered Childminder since
    pre reg
    Post Thanks / Like

    Default

    Wow that looks fab . thanks.

  8. #47
    Join Date
    May 2012
    Location
    Sheffield
    Posts
    9
    Registered Childminder since
    Jan 13
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Hi there,

    I am starting childminding in April and have been looking for a good way of keeping my accounts, and your spreadsheet is brilliant - thanks so much for sharing!

    I'm a little confused about the amount claimed for heating etc. On your spreadsheet, you have worked out the average weekly hours, which is 14.18.
    The % I have seen on HMRC website say 10 hours a week is 2% council tax and water, 8% heating and lighting; 15 hours a week is 4% council tax and water, 12% heating and lighting. (Are these correct?)
    I'm not sure how you have then used this to calculate your expenses - it's probably very simple but I just can't seem to make sense of it!!

    Laura

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

    Default Accounts Spreadsheet for 2013-14 Tax Year - Download Here

    Here is the spreadsheet for 2013-14 tax year accounts. Hope this is useful!

    www.horrod.com/Accounts201314.xlsx

    Thanks!

    Quote Originally Posted by happytoddlers View Post
    Hi,

    Thanks for your message. I will be updating this spreadsheet with 2013-14 dates and will post it to this thread for people to download. I promise I'll do it before the new tax year!

    Thanks!

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

    Default

    Hi Laura,

    Thanks for the message. I got the figures from the NCMA Accounts book and they seem to agree with HMRC. They only talk about specific hours e.g. average 20hr week and average 40hr week so if you have an average of 34 hours then it needs to be proportioned. The spreadsheet does this for you, basically proportions the HMRC allowance accordingly. I've done this little graph that might help explain.

    www.horrod.com/UtilityBillClaim.pdf

    Thanks,

    Martin

    Quote Originally Posted by laurajane7 View Post
    Hi there,

    I am starting childminding in April and have been looking for a good way of keeping my accounts, and your spreadsheet is brilliant - thanks so much for sharing!

    I'm a little confused about the amount claimed for heating etc. On your spreadsheet, you have worked out the average weekly hours, which is 14.18.
    The % I have seen on HMRC website say 10 hours a week is 2% council tax and water, 8% heating and lighting; 15 hours a week is 4% council tax and water, 12% heating and lighting. (Are these correct?)
    I'm not sure how you have then used this to calculate your expenses - it's probably very simple but I just can't seem to make sense of it!!

    Laura

  11. #50
    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

    Great, I'll take a look at this straight away. Thank you again

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

    Default

    Or for older versions of Excel use:

    www.horrod.com/Accounts201314.xls


    Quote Originally Posted by happytoddlers View Post
    Here is the spreadsheet for 2013-14 tax year accounts. Hope this is useful!

    www.horrod.com/Accounts201314.xlsx

    Thanks!

  13. #52
    Join Date
    Aug 2008
    Location
    Tonbridge,Kent
    Posts
    143
    Registered Childminder since
    Dec 08
    Post Thanks / Like

    Default

    I have brought an excel package, I have been using it for the last three years it is great

    google childs play accounts
    Sarah

  14. #53
    Join Date
    May 2010
    Location
    Cambridge
    Posts
    503
    Registered Childminder since
    Dec 04
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Wow, that looks amazing! It must have taken you hours to set that up! I will attempt to fill it in for the coming Tax year, any problems will definitely be down to me and not your spreadsheet! Don't suppose that you offer tutorials do you?
    Thanks very much for sharing!

  15. #54
    Join Date
    Aug 2008
    Location
    Hull
    Posts
    607
    Registered Childminder since
    FEB09
    Latest Inspection Grade
    Outstanding
    Post Thanks / Like

    Default

    Thank you very much for the updated spread sheet, I am using your 2012/2013 and think it is wonderful, I'm so far behind with my accounts it is taking me forever to catch up but it is so much easier than writing in the NCMA ones that I know it will be done soon. and will try to start the 2013/2014 one today and work two side by side so I don't fall behind again. Its a weight off my mind as I was getting panicked Thanks again for sharing.
    Sandy
    xx

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

    Default

    Hi all,

    If anyone has any problems with the spreadsheet or needs guidance then please feel free to message me.

    Thanks!

  17. Likes Belly2009, tracy33 liked this post
  18. #56
    Join Date
    May 2012
    Location
    Sheffield
    Posts
    9
    Registered Childminder since
    Jan 13
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Thank you happytoddlers, that does make sense now.
    And thanks again for your spreadsheet, it is brilliant!

    Laura

  19. #57
    Join Date
    Feb 2009
    Location
    Somerset
    Posts
    4,247
    Registered Childminder since
    may 05
    Latest Inspection Grade
    Outstanding
    Post Thanks / Like

    Default

    Thank you again for producing such a brilliant spread sheet - I have spent all day doing 2012 - 2013 and have nearly finished, overjoyed to see you have added 2013-2014 now as well - I promise to not get so far behind ever ever again

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

    Default

    Quote Originally Posted by hectors house View Post
    Thank you again for producing such a brilliant spread sheet - I have spent all day doing 2012 - 2013 and have nearly finished, overjoyed to see you have added 2013-2014 now as well - I promise to not get so far behind ever ever again
    .....are you already behind for this year?!

  21. #59
    Join Date
    Mar 2013
    Location
    Gledhow, Leeds
    Posts
    167
    Registered Childminder since
    21Dec11
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default Spread sheet

    Quote Originally Posted by happytoddlers View Post
    Or for older versions of Excel use:

    www.horrod.com/Accounts201314.xls
    Happy toddler i think your shread sheet is fab but i really need one for 2012/13 can you help please?

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

    Default

    Quote Originally Posted by Emmalou77 View Post
    Happy toddler i think your shread sheet is fab but i really need one for 2012/13 can you help please?
    Look at post number 23

 

 
Page 3 of 11 FirstFirst 1234567 ... 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