PDA

View Full Version : Anyone use Excel or Access for bookkeeping?



agesandstagesdaycare
02-17-2011, 09:16 AM
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

Emilys4Guppies
02-17-2011, 05:54 PM
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.

Tot-Time
02-17-2011, 06:07 PM
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.

karen
07-11-2011, 12:14 AM
Hi Emily can you please send me a sample of your spreadsheet to friendlyexplorers@gm ail.com. thanks

momx3
07-12-2011, 10:15 AM
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.

Hi Emily. I would also appreciate it if you would please send me a copy of your spreadsheet to samsdaycare@hotmail. com - Thank you.

lunademiel
03-12-2012, 08:22 PM
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

JenniferBergsma
11-26-2013, 06:45 PM
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

JenniferBergsma
11-26-2013, 06:46 PM
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

5 Little Monkeys
11-26-2013, 07:01 PM
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.

momof2_boys
11-26-2013, 08:43 PM
Not sure if this is what you are looking for but try www.thedaycarelady.c om. It was lots of document examples including expense and income ones and more. And it's all free.

Artsand crafts
11-26-2013, 08:56 PM
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 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.

Jackie pichette
11-27-2016, 07:56 PM
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.

bright sparks
11-28-2016, 09:31 AM
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.

Peacefulbird
11-29-2016, 12:41 PM
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.

Paulo Gomes
03-12-2017, 09:39 AM
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 (https://zipbooks.com/bookkeeping-services/) services from ZipBooks. This one is free. Some other pricey solutions are Quickbooks, Sage etc.