Book keeping excel Workbook UPDATED
Thanks Thanks:  0
Likes Likes:  51
Dislikes Dislikes:  0
Page 4 of 11 FirstFirst 12345678 ... LastLast
Results 61 to 80 of 219
  1. #61
    Join Date
    Mar 2013
    Location
    Gledhow, Leeds
    Posts
    167
    Registered Childminder since
    21Dec11
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default 12/13 speadsheet

    Happy toddler i'm sorry to be a pain, i am a total novice with lots yet to learn and am struggling to input reciept price
    in the month on April, please can you tell me what i'm doing wrong?

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

    Default spreadsheet 12/13

    Quote Originally Posted by Emmalou77 View Post
    Happy toddler i'm sorry to be a pain, i am a total novice with lots yet to learn and am struggling to input reciept price
    in the month on April, please can you tell me what i'm doing wrong?
    It's ok happy toddler, the penny has now dropped

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

    Default

    hurray!

  4. Likes Emmalou77 liked this post
  5. #64
    Join Date
    Mar 2013
    Location
    Gledhow, Leeds
    Posts
    167
    Registered Childminder since
    21Dec11
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default spreadsheet dates

    Quote Originally Posted by Rick_Knight View Post
    hurray!
    Hi, it's me again! I'm just filling in the spread sheet for 12/13 and in both May and June
    show Junes dates, can i just manually change this or will i mess up the whole spread sheet?

    Thanks in advance.

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

    Default

    Quote Originally Posted by Emmalou77 View Post
    Hi, it's me again! I'm just filling in the spread sheet for 12/13 and in both May and June
    show Junes dates, can i just manually change this or will i mess up the whole spread sheet?

    Thanks in advance.
    When i input coucil tax, water an so on, do i put in my total monthly bill and then the spreadsheet will work it out?
    or do i have to work out my % then divide by 12 months then in put the figure i come up with?


  7. #66
    Join Date
    Mar 2010
    Posts
    47
    Registered Childminder since
    Jul 84
    Post Thanks / Like

    Default

    Help this wont open up for me

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

    Default

    Quote Originally Posted by Emmalou77 View Post
    When i input coucil tax, water an so on, do i put in my total monthly bill and then the spreadsheet will work it out?
    or do i have to work out my % then divide by 12 months then in put the figure i come up with?

    For council tax and water rates you take the figure for the whole year (but you generally only pay it over 10 months), eg: council tax bill is £1200 for year then divide it by 12 amount each month is £100 and enter that figure on the spreadsheet - when you enter the number of hours each week you work, the spreadsheet will work out the % you are entitled to claim.

    For gas and electricity just enter in the amount you pay each month and again the spreadsheet will work out the % for you.

  9. #68
    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 hectors house View Post
    For council tax and water rates you take the figure for the whole year (but you generally only pay it over 10 months), eg: council tax bill is £1200 for year then divide it by 12 amount each month is £100 and enter that figure on the spreadsheet - when you enter the number of hours each week you work, the spreadsheet will work out the % you are entitled to claim.

    For gas and electricity just enter in the amount you pay each month and again the spreadsheet will work out the % for you.
    Thank you Hector house for your help, i was diddling myself out of some money there!

    Any idea on the spread sheet dates that are incorrect? can i change them?

  10. #69
    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
    Hi all,

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

    Thanks!
    Hi, i have noticed that both may and june have junes dates in so i have changed it, the problem is that when i input my hours of work it isnt adding up right

    The calculator is giving me one figure and the spread sheet a lower figure, i haven't used a spread sheet before and wondered if there is a reason for this that im not aware of? I cant continue until im sure im doing it right
    Last edited by Emmalou77; 28-05-2013 at 08:01 PM.

  11. #70
    Join Date
    May 2013
    Location
    Aberdeen
    Posts
    414
    Registered Childminder since
    Sept 12
    Latest Inspection Grade
    Very good
    Post Thanks / Like

    Default Spread sheet

    Does anyone know if these work in excel on a mac please?

  12. #71
    Join Date
    May 2013
    Posts
    6
    Registered Childminder since
    2012
    Post Thanks / Like

    Default

    This workbook is amazing. Thanks so much.

  13. #72
    Join Date
    May 2013
    Posts
    6
    Registered Childminder since
    2012
    Post Thanks / Like

    Default

    Quote Originally Posted by Emmalou77 View Post
    Hi, i have noticed that both may and june have junes dates in so i have changed it, the problem is that when i input my hours of work it isnt adding up right

    The calculator is giving me one figure and the spread sheet a lower figure, i haven't used a spread sheet before and wondered if there is a reason for this that im not aware of? I cant continue until im sure im doing it right
    What cells arent adding up correctly? Perhaps need to check the formula is correct.

  14. #73
    Join Date
    Aug 2012
    Posts
    239
    Registered Childminder since
    Sept 13
    Latest Inspection Grade
    Outstanding
    Post Thanks / Like

    Default

    I'm not registered yet but want to start recording the expenses I'm already racking up what with courses and resources etc...this spreadsheet is a-bloomin-mazing!

    Happy Toddlers, you are my hero

  15. #74
    Join Date
    Apr 2013
    Posts
    5
    Registered Childminder since
    Oct 13
    Post Thanks / Like

    Default

    This is fabulous, thank you!!

  16. #75
    Join Date
    Oct 2012
    Posts
    1
    Registered Childminder since
    Feb 12
    Post Thanks / Like

    Default

    Thank you sooo much Happy Toddlers, you have saved me from many sleepless nights

  17. Likes Rick liked this post
  18. #76
    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

    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!
    Thank you so much for this spreadsheet, I have recently dropped my weekly hours and this is perfect for the percentages for utility bills, It is a good job I came across this as I probably would have just still gone with the full 10% and 33% .

    Thanks
    Cath

  19. #77
    Join Date
    Jan 2014
    Posts
    1
    Non childminder member
    Nanny
    Post Thanks / Like

    Default

    Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!

  20. #78
    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 big waves View Post
    Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!
    As far as I'm aware you don't need to worry about that. HMRC work that out for you and send you a bill or you can set up a direct debit

  21. #79
    Join Date
    Feb 2008
    Location
    Teetering....
    Posts
    4,079
    Registered Childminder since
    Apr 01
    Post Thanks / Like
    Blog Entries
    1

    Default

    Quote Originally Posted by big waves View Post
    Hi, this spread sheet is great, but where do I put my National Insurance? I was using the book before, but its so time consuming and repetitive!
    You cannot put NI payments through your accounts they are not tax deductible - everyone that earns over a certain amount has to pay NI. So you don't put them in your accounts

  22. #80
    Join Date
    Oct 2008
    Location
    South West
    Posts
    248
    Registered Childminder since
    2004
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Thank you for the 2013/14 spreadsheet, its brill!

 

 
Page 4 of 11 FirstFirst 12345678 ... 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