Bank Statement to QuickBooks for Daycare and Childcare Centers: Convert PDF Statements to QBO

Two things break the feed. First, most bank feeds reach back only about 90 days and skip closed accounts, so a prior year you need for taxes or a licensing audit is not there to pull. Converting the PDF statements is the only way to bring that older activity in.

Second, your billing platform does not deposit each family's payment separately. Brightwheel, Procare with Tuition Express, KinderSystems, HiMama (now Lillio), and Kangarootime collect tuition by ACH and card, then deposit a net batch: one bank line covers many families minus the processing fees. Book that net number as your tuition and revenue runs low every single month. Instead, split the batch into gross tuition income and a processing fee expense, so the P&L shows what you actually billed and the deposit still ties to the bank statement. Having the full line detail in front of you is what makes that split possible.

Money collected before a term starts is not income yet. Prepaid tuition, summer camp deposits, and nonrefundable registration or enrollment fees are cash you take before you deliver the care, which makes them unearned revenue, a liability. Book the amount received to a deferred revenue liability account, then recognize it as the weeks pass. A family that pays 1,200 dollars in April for a three week July camp gives you zero July revenue in April; you move 400 dollars into income at the end of each camp week. A nonrefundable annual registration fee is earned across the enrollment year, not all in the month it hits.

Skip this and you overstate income in the collection month and get a P&L too lumpy to plan staffing against. It is the same mechanic gyms use for annual memberships; the gym and fitness studio guide walks through the recognition entries in more detail.

If you accept children on state child care assistance, part of your money comes from the state, not the parent. Those subsidy or voucher payments arrive as separate state ACH deposits, often on a lag and at a rate below your private tuition, and they land with cryptic government descriptors that no rule will categorize on its own. The parent still owes a copay through your normal billing. Put subsidy income in its own account, apart from private-pay tuition, so you can reconcile the state deposits against attendance and catch a slow or short payment. The amount the state authorizes is usually the provider payment plus the parent copay, so tracking the two pieces tells you whether a family is fully paid up.

The Child and Adult Care Food Program (CACFP) is a USDA program that reimburses centers for nutritious meals and snacks served to enrolled children. You claim meals monthly, and your state agency or sponsor sends a reimbursement deposit some weeks later. That deposit is income, and it goes in its own income account. Do not net it against what you spend on food. The IRS Audit Technique Guide for child care providers has centers report the full reimbursement as income and separately deduct the full food cost, so groceries and catering stay their own expense line. Netting the two hides both numbers and can cost you deductions. Rates are set annually by USDA and depend on the meal type and the income tier of the children served, so the monthly deposit varies; keep it apart so you can tie it back to your meal counts.

Centers that run Head Start, Early Head Start, or a state pre-K contract receive grant money that is restricted to approved program activities. Restricted grant income belongs in its own income account, separate from tuition and subsidy, because grantors and auditors expect you to show those funds were tracked and spent on the program. Head Start in particular carries federal fund-accounting rules, a non-federal match requirement, and cost-allocation expectations when the grant shares staff or space with your private classrooms. If your center also files as a nonprofit, the nonprofit guide covers restricted-fund tracking in QuickBooks.

Not every auto-draft clears. ACH returns and NSF fees show up days after the original tuition batch, and each one reverses revenue you already recorded and usually costs you a bank fee. Because it is dated after the deposit, it rarely lands in the same batch, so you need every line in date order in QuickBooks to match it back. Post the returned amount against the tuition income it reverses, send the bank's fee to a bank charges expense, and record any late fee you collect from the family as its own small income line.

Staff wages are the dominant cost at almost every center. Your classroom teachers and aides are W-2 employees: you set their schedule, direct their work, and run them through payroll with withholding and payroll taxes. An occasional enrichment provider, say a music teacher who comes in once a week on their own terms, may be a 1099 contractor whose pay goes to contract labor with no withholding, and who needs a 1099-NEC if you pay them 2,000 dollars or more in a year (the threshold rose from 600 dollars for payments made on or after January 1, 2026). Do not push regular classroom staff onto 1099s to save payroll tax; that misclassification is exactly what a state labor audit looks for, and childcare staff almost always meet the test for employees. Finally, if you take money out as the owner of an S-corp or a sole proprietorship, an owner draw is an equity distribution, not a payroll expense, so it never touches the P&L.

A lot of recurring card charges at a center are ordinary operating expenses: liability and accident insurance, state licensing fees, staff background checks, and CPR or first-aid certification. Give the main ones their own accounts so renewals are easy to find at budget time. Big purchases are different. A new playground structure or a passenger van to transport children is a fixed asset, capitalized on the balance sheet and depreciated over its useful life, not written off in the month you pay for it. Booking a 15,000 dollar playground as one month's expense wrecks that month and misstates the asset base.

1. Upload your PDF bank and credit card statements to the converter at the top of this page, several accounts at once if you like. It accepts PDF and image files as input.
2. The tool parses each statement, reconciles the running balance, and keeps the date, description, and amount for every line, including subsidy deposits, CACFP payments, and returned drafts.
3. Download a .qbo file per statement, plus Excel and CSV copies for your own worksheets.
4. Import into QuickBooks. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 transactions or 350 KB per file, so split a long statement past that limit. For one statement, use the PDF to QBO converter or the QBO converter. To bring older PDFs into Desktop, see convert bank statement to QuickBooks Desktop, and bookkeepers running several centers can use the accountant workflow.

Can QuickBooks be used for a daycare?

Yes. QuickBooks Online and Desktop both work for a daycare once you build a chart of accounts that fits it: separate tuition, subsidy, and CACFP income accounts, a deferred revenue liability for prepaid tuition and camp deposits, a processing fee expense, and payroll for W-2 staff. Then import your bank statements and categorize each line against those accounts.

How do I record daycare tuition in QuickBooks?

Record tuition to a tuition income account at the gross amount families were billed, not the net batch your billing platform deposits, and post the platform's processing fee to a fee expense so the net still matches your bank statement. Prepaid tuition and camp deposits go to a deferred revenue liability first, moving into income as each week of care is delivered.

What chart of accounts should a daycare use?

Use separate income accounts for private tuition, state subsidy, CACFP food reimbursement, registration fees, and late fees, plus a deferred revenue liability for prepaid amounts. On the expense side, keep payroll, food, insurance, licensing, rent, and supplies as their own lines, and record playground equipment or a van as fixed assets. Owner draws sit in equity, not on the P&L.

How do I record CACFP reimbursements in QuickBooks?

Record the CACFP deposit as income in its own food program income account, and keep your food purchases in a separate food expense account. Do not net the reimbursement against the food cost. The IRS Audit Technique Guide for child care providers has you report the full reimbursement as income and deduct the full food expense, which also keeps both numbers visible for your meal-count records.

Does Brightwheel integrate with QuickBooks?

Brightwheel lets you export billing data to bring into QuickBooks Online, but it is not a full automatic sync, so you still review and post the figures yourself. Procare offers a QuickBooks integration as well. Either way, the platform deposits a net ACH batch, so importing the actual bank statement is what lets you split gross tuition from the processing fees and tie the deposit to your books.

How do I import a bank statement into QuickBooks for a daycare?