Book keeping excel Workbook UPDATED
Thanks Thanks:  0
Likes Likes:  51
Dislikes Dislikes:  0
Page 5 of 11 FirstFirst ... 23456789 ... LastLast
Results 81 to 100 of 219
  1. #81
    Join Date
    Apr 2012
    Location
    Eccles, Salford
    Posts
    157
    Registered Childminder since
    Aug 12
    Post Thanks / Like

    Default

    Hi,

    I'd like to change the width of some of the columns.
    Is there anyway I can do this?

    TIA x

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

    Default

    Hi, to change the width of, for example, column D, then click and hold the mouse button down on the line between column D and E (shown in the attachment). Drag either left or right to change the width. You'll know when the mouse is in the right position to click because the cursor arrow will change to two arrows pointing left and right.

    Column width.jpg

    Hope this helps

    Martin


    Quote Originally Posted by SammyL View Post
    Hi,

    I'd like to change the width of some of the columns.
    Is there anyway I can do this?

    TIA x

  3. #83
    Join Date
    Apr 2012
    Location
    Eccles, Salford
    Posts
    157
    Registered Childminder since
    Aug 12
    Post Thanks / Like

    Default

    Hi,

    Thanks Martin. It doesnt work f8r some strange reason.
    It's ok though, I need to add more rows & columns so will have a go at doing my own.

    Thanks for all your help in sharing this though x

  4. #84
    Join Date
    Nov 2013
    Posts
    31
    Post Thanks / Like

    Default any other forms

    hi,

    sorry,newly registered as a childminder and not sure if to get a bookkeeper or do it myself?

    would it only be this spreadsheet i would need to complete, is this all the bookkeeper would do?

    thanks

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

    Default

    Hi, yes that's all you need to do. No need to pay anyone else to do it x

  6. #86
    Join Date
    Nov 2013
    Posts
    31
    Post Thanks / Like

    Default

    Quote Originally Posted by Emmalou77 View Post
    Hi, yes that's all you need to do. No need to pay anyone else to do it x
    thanks Emmalou, I'm finding it quite a daunting task

    I haven't started earning yet, so will i have to do a tax return for 2013/14 if i start to earn between now and march? when do i need to do tax return etc??
    i have no idea where to start with the finance side of things, help!

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

    Default

    Even if you haven't earned anything in your first year you still need to do a tax return. Glad to be of help :-)

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

    Default Excel Book Keeping Files for 2014-2015

    Hi all,

    Last year I posted a spreadsheet for accounting that seemed to prove useful to many. Here are the links to the next financial years..

    www.horrod.com/Accounts201415.xls for excel 97-03
    www.horrod.com/Accounts201415.xlsx for later versions

    I've made a few changes, mostly with the layout so it's more printer friendly and easier to navigate. The most useful change is the ability to enter your start time and finish time for each day and 'it' works out the hours worked for that day. I found this got tedious on the last version! Make sure you enter the time in with a : between the hours and the minutes.

    Thanks all!

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

    Default

    happytoddlers, you are quite frankly amazing! I cannot tell you how much easier your spreadsheet has made my life...thank you SO much for sharing this

  10. #90
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    55
    Registered Childminder since
    June 11
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Fad spread sheet just a pointer you can claim 45p per mile for petrol :-)

  11. Likes Chatterbox Childcare liked this post
  12. #91
    Join Date
    Sep 2012
    Posts
    3,037
    Registered Childminder since
    Oct 12
    Latest Inspection Grade
    GOOD! Hurrah
    Post Thanks / Like
    Blog Entries
    1

    Default

    Thanks so much

  13. #92
    Join Date
    Jan 2012
    Posts
    196
    Registered Childminder since
    Nov 11
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Thank you!

    When entering our hours worked do we enter the actual time the first child arrived & the exact the last child left or the hours they were booked in for? So if a child was booked in 7:30 until 5:30 but arrived at 7:40 & left at 5:20 which figures do we enter?

    Thank you!

    Kirsty x

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

    Default

    Quote Originally Posted by Kirsty90 View Post
    Thank you!

    When entering our hours worked do we enter the actual time the first child arrived & the exact the last child left or the hours they were booked in for? So if a child was booked in 7:30 until 5:30 but arrived at 7:40 & left at 5:20 which figures do we enter?

    Thank you!

    Kirsty x
    Hi Kirsty,

    Oooh that's a grey area that! TBH I'm not sure. In the past I've been entering the figures for the time I'm getting paid. With what I've noticed this past year, even if you put down the exact times I would reckon that after averaging it would only effect your final calculations by a few pounds. It's a good point Kirsty.

    Thanks!

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

    Default

    I'm gonna record the contracted times on the spreadsheet because that's what I get paid for and what is important in terms of my accounts. I have a separate attendance register to record exact times.

    Don't know if that's right but it makes sense to me so I'm going with it!

  16. #95
    Join Date
    Mar 2012
    Posts
    537
    Registered Childminder since
    Mar 90
    Latest Inspection Grade
    Outstanding
    Post Thanks / Like

    Default

    In the attendance log it must be the actual hours logged not the contracted ones.

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

    Default

    Thank you so much, this is fantastic again. I've used yours this year and it's so simple and easy. Xx

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

    Default

    Thank you so much for sharing this, I have been using it for this year and love how it takes one of the most stressful tasks that I always find so difficult and makes it really simple.
    Sandy
    xx

  19. #98
    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

    Thank you so much, you are an absolute star
    Cath

  20. #99
    Join Date
    Nov 2013
    Posts
    31
    Post Thanks / Like

    Default

    hi

    this is great thank you!

    If I charge a daily fee for meals, I assume I would then not put through food I purchase as an expense?

    Thanks

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

    Default

    Hi,

    Personally I don't. I charge £1.50 for a lunch so I don't declare this as income and I don't put the food down as an expense either. The same with outing costs, I invoice for the cost of entry to places etc.. but I put down purely the labour element of the invoice for the accounting.

    Thanks!

    Quote Originally Posted by lindsay.butler View Post
    hi

    this is great thank you!

    If I charge a daily fee for meals, I assume I would then not put through food I purchase as an expense?

    Thanks

 

 
Page 5 of 11 FirstFirst ... 23456789 ... 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