Dependent Care FSA Log Excel - Free Template

1. Open the Expense Log tab and replace the sample employee name, annual election amount, and plan year with your own information. The template is labeled for Plan Year 2026.
2. Enter one expense per row. Add the payment date, provider name, provider EIN, dependent name, service start and end dates, description, and amount.
3. Choose or enter the payment method and claim status, then add the claim submitted date when you send documentation to the plan administrator.
4. Record the reimbursed amount after the claim is paid. Review the reimbursed percentage and use Notes for invoice numbers, receipt locations, or questions from the administrator.
5. Review the Provider Summary tab to compare activity by care provider and check the Dashboard for the plan-year picture. Images 2 and 3 show these review areas.
6. Read the Instructions tab before submitting a claim and retain invoices, receipts, and provider statements with the workbook. Image 4 identifies the guidance included with the file.

Working Parents And Payroll Teams

You usually need this spreadsheet when daycare invoices arrive, not when tax season begins. A household with two working parents might pay a daycare center $850 each month and an after-school provider $240 each month; entering both payments as separate rows gives you a running $1,090 monthly record instead of a stack of receipts.

The employee enters the provider's legal name, EIN, dependent, service dates, and amount in the Expense Log. A payroll or benefits coordinator can then compare the employee's claim paperwork with the same fields before approving reimbursement. Image 1 shows the 14-column log, including the claim and reimbursement fields that are often missing from a simple household ledger.

When The Log Matters Most

Use it after every payment or at a fixed weekly time. Monthly daycare tuition, summer day camp, preschool charges, and before- or after-school care can otherwise be mixed together, especially when two providers serve one child. A $1,090 monthly pattern becomes $13,080 over 12 months, so a few missed entries can make the account look materially underused.

At the end of each month, review the Provider Summary tab shown in image 2. That view is useful when one provider sends a monthly invoice and another bills by attendance. The Dashboard in image 3 gives you a faster plan-year review, while the Instructions tab in image 4 helps a new employee understand the workbook before entering records.

Households With Changing Care Arrangements

This log also fits a family that changes providers during the year, adds a summer program, or has more than one qualifying dependent. Keep one row for each invoice or payment period rather than combining six months into one total; the service start and end dates make the record much easier to match to a claim.

2026 Contribution And Reimbursement Limits

For 2026, the federal dependent care assistance exclusion is up to $7,500 for most taxpayers and $3,750 for a married person filing separately, subject to the employer plan and the employee's earned-income limits. A plan can impose a lower election, so the Annual Election Amount field must reflect the amount your employer actually permits. The workbook's $5,000 sample is an example, not a universal 2026 limit.

Eligible care generally must enable you and your spouse to work or look for work. Qualifying expenses commonly include daycare, preschool, before- or after-school care, and day camp for a qualifying person. Overnight camp, school tuition for kindergarten or higher, and ordinary medical care do not become eligible merely because you paid them through a provider.

Information Required For Form 2441

Use your records when completing Form 2441, Child and Dependent Care Expenses, with Form 1040. You generally need the provider's name, address, and EIN or Social Security number, the dependent's information, the amount paid, and the period of care. The Provider EIN column and service-date fields in image 1 are practical prompts for those details.

Your employer reports dependent care benefits on Form W-2, box 10. You cannot use the same $850 daycare payment for both tax-free FSA reimbursement and a separate child and dependent care credit calculation. The expense also cannot exceed the applicable earned income, and married couples generally apply the lower-earning spouse's income limit unless a special student or incapacity rule applies.

Keep The Records Together

Save invoices, receipts, payment confirmations, and provider statements with the workbook. The IRS generally expects tax records to be retained for 3 years, with records kept up to 7 years in situations involving substantial underreported income; your employer's plan may require documents sooner for claims or forfeiture deadlines.

Payments Without Complete Provider Data

The most expensive problem is often not the amount—it is an incomplete claim. An employee enters $850 for January daycare but leaves the provider EIN and service dates blank. The administrator sends the claim back, and the employee spends 20 minutes searching email for a corrected invoice while reimbursement remains pending.

Another failure occurs when a parent records the payment date as 01/31/2026 but describes the service as February care. The Date, Service Start, and Service End columns serve different purposes. If you collapse them into one note, you make it harder to prove which care period the payment covered.

Reimbursement Totals That Do Not Match

Suppose six rows total $5,400, but only $4,950 has been reimbursed. Treating the entire $5,400 as paid creates a false impression that the claim balance is zero. Enter the actual reimbursement in the Reimbursed Amount column and use Claim Status and Claim Submitted Date to identify the $450 still awaiting payment.

Partial payments create a second trap. A $1,000 invoice reimbursed at $750 should show the $750 actually received, not a manually edited expense amount of $750. Otherwise your expense total understates care costs and your reimbursement percentage becomes meaningless.

Tax Problems From Double Counting

Some households export a daycare total to a tax worksheet and also include the same amount in a dependent care credit calculation. For example, using $3,600 of tax-free FSA benefits and then claiming that same $3,600 as an eligible credit expense can overstate the tax benefit. Reconcile the Expense Log to Form W-2, box 10, and Form 2441 before filing.

Do not assume every child-related charge qualifies. A $600 private-school tuition bill for a first-grade student is not the same type of expense as $600 paid to a qualifying after-school care provider. Keep the description specific enough to show the nature and period of care; vague entries such as “child costs” are poor evidence.

Attach Entry To A Payment Habit

Choose one repeatable trigger: update the log immediately after paying the provider, or enter every Friday after reviewing your bank transactions. Five weekly entries take less time than reconstructing 20 payments before a claim deadline. For a family making four $850 daycare payments and four $240 after-school payments in a month, the routine captures $4,360 without relying on memory.

Use The Workbook Consistently

Keep provider names and dependent names consistent from row to row. “Sunshine Daycare Center” and “Sunshine Day Care” may look like the same provider to you but can fragment a summary. Use a stable naming convention, enter dates as MM/DD/YYYY, and record the exact reimbursed amount when the administrator pays a claim.

• Save invoices with filenames such as 2026-01 Sunshine Daycare $850 and put that reference in Notes.
• Review the Expense Log and Dashboard once each month after the final care payment posts.
• Check pending claims before your plan's submission cutoff instead of waiting for year-end.
• Keep a backup copy in a restricted folder because provider and dependent data is sensitive.

Know When Excel Is No Longer Enough

This workbook is a good fit for one household with a manageable number of monthly invoices. If you are an HR team processing 75 employees, or a benefits administrator reconciling hundreds of claims, move to a benefits platform with employee access, document storage, audit trails, and deadline controls.

For personal use, do not replace the spreadsheet merely because the year contains 100 rows. Replace it when you need automated payroll feeds, multiple plan years, shared access, or approval controls. Until then, a monthly review of the Provider Summary and Dashboard is more reliable than opening the file only during tax preparation.