Hi,
I'd like to change the width of some of the columns.
Is there anyway I can do this?
TIA x
Printable View
Hi,
I'd like to change the width of some of the columns.
Is there anyway I can do this?
TIA x
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.
Attachment 8132
Hope this helps
Martin
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
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
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! :(
Even if you haven't earned anything in your first year you still need to do a tax return. Glad to be of help :-)
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!
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 :clapping:
Fad spread sheet just a pointer you can claim 45p per mile for petrol :-)
Thanks so much :clapping:
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!
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!
In the attendance log it must be the actual hours logged not the contracted ones.
Thank you so much, this is fantastic again. I've used yours this year and it's so simple and easy. Xx
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.
Thank you so much, you are an absolute star :thank you:
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
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!