Accountable Plan Expense Tracker
If you made the leap to an S Corp and are working out of your home office or have shared business / personal expenses, this tracker is for you.
An accountable plan is how your S Corp legally reimburses you for the business portion of those shared expenses, tax-free. But to keep the IRS happy, you need a paper trail. This spreadsheet is that paper trail.
What's included:
A pre-built spreadsheet with three tabs:
Start Here — a plain-English overview of how accountable plans work, a reminder of the three IRS rules you need to follow, and step-by-step instructions for using the tracker
Expense Tracker — your main working tab, organized by month (January through December), with a running Annual Total column. Gray cells are yours to fill in. No math required.
Annual Summary — a clean year-at-a-glance view that pulls directly from your tracker, organized by category. Handy for splitting transactions in QBO.
What it tracks:
Home office (auto-prorates your expenses based on square footage)
Cell phone & internet (with business use % built in)
Mileage for up to two vehicles (IRS standard rate + prorated loan interest and property tax)
Out-of-pocket expenses: travel, meals, health insurance premiums, HSA contributions, and more
How it works:
Each month, enter your expenses in the gray cells. When you’re done, transfer the "Total Monthly Reimbursement" amount from your business bank account to your personal account. Then record the transfer in QBO, split it across the right expense categories, and save this spreadsheet. That's it!
At the end of the year, your completed tracker is your documentation if you're ever audited.
This is for you if:
You're an S-Corp owner-employee reimbursing yourself for home office, phone, mileage, or other business expenses
You want a simple, organized way to track everything in one place, month by month
You're tired of scrambling at year-end to remember what you spent
This is not for you if:
You're a sole proprietor (you don't need an accountable plan — Schedule C handles this differently)
You're looking for legal or tax advice (this is a tracking tool, not a substitute for your CPA)
File format: Excel (.xlsx) — compatible with Microsoft Excel and Google Sheets
After purchase: You'll receive an instant digital download. No refunds on digital products, but reach out at jessica@openbookservices.com if you have any trouble.
If you made the leap to an S Corp and are working out of your home office or have shared business / personal expenses, this tracker is for you.
An accountable plan is how your S Corp legally reimburses you for the business portion of those shared expenses, tax-free. But to keep the IRS happy, you need a paper trail. This spreadsheet is that paper trail.
What's included:
A pre-built spreadsheet with three tabs:
Start Here — a plain-English overview of how accountable plans work, a reminder of the three IRS rules you need to follow, and step-by-step instructions for using the tracker
Expense Tracker — your main working tab, organized by month (January through December), with a running Annual Total column. Gray cells are yours to fill in. No math required.
Annual Summary — a clean year-at-a-glance view that pulls directly from your tracker, organized by category. Handy for splitting transactions in QBO.
What it tracks:
Home office (auto-prorates your expenses based on square footage)
Cell phone & internet (with business use % built in)
Mileage for up to two vehicles (IRS standard rate + prorated loan interest and property tax)
Out-of-pocket expenses: travel, meals, health insurance premiums, HSA contributions, and more
How it works:
Each month, enter your expenses in the gray cells. When you’re done, transfer the "Total Monthly Reimbursement" amount from your business bank account to your personal account. Then record the transfer in QBO, split it across the right expense categories, and save this spreadsheet. That's it!
At the end of the year, your completed tracker is your documentation if you're ever audited.
This is for you if:
You're an S-Corp owner-employee reimbursing yourself for home office, phone, mileage, or other business expenses
You want a simple, organized way to track everything in one place, month by month
You're tired of scrambling at year-end to remember what you spent
This is not for you if:
You're a sole proprietor (you don't need an accountable plan — Schedule C handles this differently)
You're looking for legal or tax advice (this is a tracking tool, not a substitute for your CPA)
File format: Excel (.xlsx) — compatible with Microsoft Excel and Google Sheets
After purchase: You'll receive an instant digital download. No refunds on digital products, but reach out at jessica@openbookservices.com if you have any trouble.