Printable View
I have all my info from my families on paper and I'm ready to put it on my computer for security reasons and to keep track of expenses, income, child info, etc..
I'm not sure where to start! What do you do to keep organized? Did you create your own bookkeeping forms or download them? Do you keep the info on paper? I still might go with daycare software but would like to do it myself if I can come up with a set plan. I'm a little particular. ;)
I'd appreciate any advice. :)
A
I have an excel spreadsheet that I use for my bookkeeping. I also keep a papertrail of printed forms and whatnot in my filing cabinet. If you'd like I can send you my spreadsheet...pm me your email.
I use Microsoft office for everything! This allows me to sync my documents to my cell phone if I happen to need the document when I am not at home. On my cell I keep the basics so I don't have to carry a physical copy of my handbook, my interview questions, all the children's emergency information (in the contact area under the parent that I am to call first), pictures of the child if there was ever an emergency and I have started to keep pictures of my daycare too just in case I ever have an inquiry while we are out and about, our field trip budget, etc.
So to break it down, I have my attendance forms and documents in word, my income and expense statements in excel, my interview notes in one note, and my emergency and contract information and calendar in outlook. I think I should get royalties or shares to promote Microsoft Office, lol. I love the ability to sync my phone with office. I am just starting to use one note, but the amazing thing is how it can keep several different types of documents organized in one location like a filing cabinet.
Hi Emily can you please send me a sample of your spreadsheet to friendlyexplorers@gm ail.com. thanks
Hi Emily. I would also appreciate it if you would please send me a copy of your spreadsheet to samsdaycare@hotmail. com - Thank you.Quote:
Originally Posted by Emilys4Guppies
I was wondering if you all would mind sharing this spreadsheet? I have spend hours and hours trying to come up with something to track attendance and income and I just can't come up with anything usable!
Thanks
Hi Emilys4Guppies
I've just recently started my own home daycare and as many other providers on here.. I'm struggling with how to bookkeep! Would you be so kind to share your document with me?
My email address is jenniferbergsma@hotm ail.ca
Thanks in advance,
Jennifer
Hi Tot-Time!
I've just recently started my own home daycare and as many other providers on here.. I'm struggling with how to bookkeep! Would you be so kind to share your document with me?
My email address is jenniferbergsma@hotm ail.ca
Thanks in advance,
Jennifer
I am soooo old school LOL. I have all my policies and contract online and send those to the parents to read before we meet but than I have all my forms printed out and they sign them and I put those into folders. When they leave, I give them all their info back except for my copy of the contract.
I keep all my receipts in envelopes and 3-4x a year I add them all up and at the end of the year I add up those 3-4 totals to get my grand total for each area. Then I give all that to my tax preparer and she does my taxes for me.
I have a payment sheet for each family and every payday, I mark down how much they paid, how they paid (cash or cheque) and we both initial it. Then at year end I add that up and give them a receipt.
I am technology stupid (and I'm only 27 LOL) and prefer to do things on paper.
Not sure if this is what you are looking for but try www.thedaycarelady.com. It was lots of document examples including expense and income ones and more. And it's all free.
I do the same and so far has worked fine. The only differences is I that file my own income taxes and that I give receipts to parents for every payment and I keep a carbon copy of all payments and at year end I add all the income. I am currently using excel only for tracking attendance and for my assistant's payroll, but next year I am planning on stop using the carbon copies and add parents payments to my excel program (to be more efficient). I will still keep children information/forms in paper. My policies and related info are in my webpage and accessible to clients only.Quote:
Originally Posted by 5 Little Monkeys
Hi there. I was just wondering as well about the book keeping aspect of my home daycare. I have excel as well but cant seem to figure out how to set it up. If you have any advice or could passably send me an example spreadsheet i wohld appreciate it. Thank you.
Like others I am an old school pen, paper and envelope kinda gal. I have a diary which I record attendance in, and the rest is shoved in a zippy and organised quarterly.
I hope this helps, if you go online go to www.ccprn.com I have taken worshops with them about taxes etc. And they generously provided us with a excel program designed for homedaycares. (Send an email, I'm sure they will be able to help you out by facilitating the Excell program)
It has different pages ins and outs of a homedaycare. I'm not a computer wizard but what I do is, at the beginning of the year I print the forms. Keep it in my daycare daily journal and fill them up with pencil at any convenient time. Payments basically then I just place this inf. In the computer any given month and by the end of the year I'm able to print the accounting pages attached with my monthly bills. My accountant really appreciates all this done. My receipts are also easy to print. The program keeps track of the totals so, when I have children leaving it is easy to print a receipt.
I was also able to customize the pages as i needed.
You can go with MS Excel and Visual Basic if you know Excel formulas properly. I am not that much expert. For our daycare agency we are using online bookkeeping services from ZipBooks. This one is free. Some other pricey solutions are Quickbooks, Sage etc.