Thanks Pete and Pauline, I am fairly new to excel but it looks fairly straight forward. I am about to do my December invoices so it will save me time and look more professional.
Thanks Pete and Pauline, I am fairly new to excel but it looks fairly straight forward. I am about to do my December invoices so it will save me time and look more professional.
I've just updated the original version as Pete made some additions after a problem was noticed on the calculations
Pauline x
Hi I have only just found this as I have run out of record sheets and was looking to do my own . I cant get it to work cos when I try to alter anything on the attendance sheets its says review and change but then it asks for a password ? any advice on this please how as any else got this to work as I see a few of you are using it xx thank you x
you have to change everything form the attendance sheet first ie delete entries and input from there as all the other sheets are filled in automatically from the original entry on the attendance sheet . ..............it will then work fine.
I have been using this and giving Peter feedback and think all the problems have been tweaked now
Just had a quick play, not minding at the moment but think this would be a great tool if I went back to it well done
I have just changed the format for my invoicing and then saw this so thought I would have a play. Potentially I like the idea of having a system like this that would generate an invoice for me but as someone previously mentioned I cannot use it as I charge in advance. I suppose if I was purely using as an invoice tool it would work. I can't imagine there are many people who literally charge for the time the children are in and in arrears for this to work? If they do then I imagine it would be fantastic and it looks as though some are already using it. For those that do - if the child comes say 5 mins early at drop off and then gets collected say 20 mins early are you charging them for 15 mins less than contracted times?
It is very nice of you Pete to do this for everyone. Especially to sort out individual needs. Can I ask, do you do this for a living or putting together a package for childminders that you are running passed us first etc? (Just me being nosey!)
does anybody know why i cant open this file.
thanks
tracy
To answer your question No I don't do this for a living, I am a rank amateur compared to the real experts with excel.
It all started with a friend who is a child minder that was fed up with filling out the forms and writing receipts for customers. I said I would like to have a go at creating something that she could enter the arr times and dep times on a screen that looks like the form she was filling out and an invoice would be produced.
she loved it, that was a couple of years ago, last year my pc died so i bought a new one, whilst I was transferring all the files over to the new one I came across the sheet and wondered if anyone else could benefit from it. that's when I contacted Pauline.
thanks to all the forums feedback it's far better than it was, but there is always room for improvement lol.
some people do sudoku or crosswords I love the challenge of excel.
believe it or not I drive trains for a living.
sorry to be long winded.
pete
I am using it and yes I do charge in arrears.
In 16yrs I have never had a problem
It is not intended as an accurate attendance register for Ofsted who want exact times a child enters and leaves your care but as an invoice tool for creating your monthly bills.
I enter contracted times of arrival and departure, if a child arrives earlier/leaves later I enter the appropriate times so that extra payment will be calculated.
Obviously this system will not cater for everyone's individual needs but as a basic invoice system it is excellent.
If you charge in advance it will work as you just enter the booked times and days for the month in question, any extra payments can then be added to the next months invoice as additional payments as I presume you would do normally.
I keep a totally separate record of actual times of arrival and departure in a separate place for Ofsted purposes.
thanks to Pete it has made my life a lot easier
Ah thanks Pete - I love long winded answers! What a nice train driver you are
Sonia Ann, yes I can see what you mean re using it purely for the invoicing side of things. Might have another play myself. I am all up for ease!
Thanks Pete this is really brilliant!
I wonder if you could help me though...
I only give my parents monthly invoices - is there any way I could put down additional costs on the monthly sheet, instead of asking them to refer to the weekly ones?
Sorry to be a pain!
Help x I have deleted everything from the spread sheets and then tried to put the figures in again and when I try to put the hours in it still stops me putting the hours in it says cells are protected and needs a password. I cant get past it. x
i have just found this and it will work great for me but when i try to enter and change times it says no as its only a read doc. please help i am being thick!
tax
Love it!
Not started minding yet but will be def using this. Will be invoicing in advance so I will just calculate their contracted hours and add any extra hours they have onto next invoice, perfect!
Thank you
Emma x
does any one know how we go about Retainers?
my mindee has been off for three weeks and I would charge fee
also I cant open the updated document
ziller
Hiya. This spreadsheet sounds perfect but it won't let me open it. I have just joined the site yesterday. How long before I have privileges? Thank you x
|
Bookmarks