Free template

Business partner
expense tracker
spreadsheet

Log every business expense, record whether the business or an owner paid it, and see who has funded what.

A free Excel workbook for small businesses with two or more owners — partners, LLC members or co-founders. It totals expenses by owner, category and month, and keeps business-paid and personally paid costs apart, so nobody has to rebuild who paid for what at the end of the year.

Download the free spreadsheet Start free with RecordSplit

Excel workbook (.xlsx), 46 KB · No signup or email · No macros · Tested in Excel and Apple Numbers

Version 1.0 · Published October 11, 2026 · By RecordSplit

Preview

What the workbook
looks like.

Rendered from the downloadable file itself, with its example rows. The Summary is calculated by formulas from the Expenses and Setup sheets.

The Expenses sheet with three example rows: Maya's $1,200 advertising and Daniel's $400 software paid personally, and $800 rent paid from business funds. — Expenses sheet — one row per expense, with dropdowns for category, paid from, paid by and settlement status. Example data, not customer data.

The Summary sheet for the example rows: total expenses 2,400, business funds 800, paid personally 1,600; Maya paid 1,200 and Daniel 400 personally. — Summary sheet — totals by funding source and by owner, for the same three example rows.

What's included

Four sheets,
nothing hidden.

Plain ranges and standard formulas, so you can see how every number is calculated and change anything.

Read me: How to use the workbook in five steps, what it does and doesn't calculate, and compatibility notes.
Setup: Your business name, the year the Summary covers, up to ten owners, an optional share of owner-paid expenses for each owner, and up to 30 expense categories (nine starters you can rename or replace).
Expenses: One row per expense, with dropdowns for category, paid from, paid by and settlement status. Room for 1,000 expenses. Starts with three example rows to delete.
Summary: Calculated totals: all expenses, business-paid and personally paid, personally paid but not yet settled, and breakdowns by owner, by category and by month. Nothing on it needs editing.

What it tracks

Nine columns
for every expense.

Who paid is recorded on the expense itself, so the business-paid and personally paid totals always add up to total expenses.

Columns on the Expenses sheet
Column	What goes in it
Date	When the expense was paid.
Expense	A short description — the supplier or what was bought.
Category	Chosen from the list on Setup: Advertising, Equipment, Internet, Rent, Salary, Software, Travel, Utilities, Miscellaneous, or your own.
Amount	The full amount of the expense.
Paid from	Business funds, or Owner personally.
Paid by (owner)	Which owner paid, when Paid from is Owner personally. Highlighted if it's missing.
Funding	Filled in automatically: Business-paid or Personally paid.
Notes	Anything else — an invoice number or where the receipt is saved.
Settlement status	Not applicable for business-paid costs; Not settled or Settled for personally paid ones.

How to use it

Five steps,
the same as the Read me.

Add your owners
On Setup, replace the example names with each owner's name. Add your own expense categories if the starters don't fit.
Add your expenses
Delete the three example rows on Expenses, then add one row per business expense with its date, description, category and amount.
Choose who paid
Set Paid from to Business funds when the business paid. If an owner paid with personal money, choose Owner personally and pick that owner.
Review the summaries
Summary shows total expenses, how much the business and each owner funded, and totals by category and month for the year on Setup.
Mark settlements separately
When owners even out a personally paid cost, change its status to Settled. Keep a record of the settlement payment itself outside the sheet.

Worked example

Maya and Daniel's
March expenses.

Two owners, three expenses — the example rows in the workbook. Maya pays a $1,200 advertising bill personally, Daniel pays $400 for software personally, and the business pays $800 rent from its own funds. Assume they agreed to share owner-paid costs 50/50 and nothing has been settled yet.

Every expense counts in full in total expenses, whoever paid. With the optional 50/50 shares entered, the Summary also shows each owner's $800 share of the $1,600 paid personally: Maya paid $400 beyond her share and Daniel $400 below his.

Total expenses: $2,400
Paid from business funds: $800
Paid personally by owners: $1,600
Maya — paid personally: $1,200
Daniel — paid personally: $400
Personally paid, not yet settled: $1,600

Example figures, not customer data. The sheet does not calculate a full partner balance: it leaves out revenue an owner received personally, profit sharing, capital, owner withdrawals and settlements already paid, so it doesn't say who should pay whom.

Limitations

What a spreadsheet
can't do.

A spreadsheet is a good way to start tracking who paid for what. These are the gaps to know about.

It isn't a partner balance: It shows what each owner paid personally and, if you enter shares, how that compares with each owner's share of owner-paid expenses. A full position between owners also depends on revenue an owner received personally, profit sharing, capital, owner withdrawals and settlements already paid — none of which are in this sheet.
No revenue or profit: It tracks expenses only, so it can't show profit or how profit is shared.
One set of shares: The shares on Setup apply to every row. If owners change how they share costs partway through the year, earlier expenses don't keep the old shares.
Settlements are a status, not a record: Marking a row Settled doesn't record who paid whom, how much or when.
Copies drift apart: When several owners keep their own copy, or a formula is typed over, totals stop agreeing. Someone has to check.
Receipts live elsewhere: You can note where a receipt is saved, but the file isn't attached to the row.

Spreadsheet or RecordSplit

When the spreadsheet
isn't enough.

Plenty of businesses run on this spreadsheet for years. RecordSplit is for when you also need revenue, profit sharing and a partner balance kept with the expenses — see expense tracking and partner finance.

This spreadsheet compared with RecordSplit
Compared on	This spreadsheet	RecordSplit
Price	Free, no signup	Free for your first organization; paid plans raise limits (pricing)
Who paid each expense	Paid from and Paid by columns	Business funds, or the owner who paid personally
Sharing owner-paid expenses	Optional shares, one set for the whole sheet	Partnership rules with effective dates; earlier expenses keep the shares that applied when they were paid
Revenue and profit	Not tracked	Revenue, profit and each owner's profit share
Partner balance	Not calculated	Partner Balance from owner-paid expenses and revenue received personally, with suggested settlements
Settlements	A status on each row	Settlements recorded between owners
Capital and withdrawals	Not tracked	Capital contributions; owner withdrawals on business accounts
Receipts	Note where you saved them	Attach a receipt to the expense
Access	Whoever has the file	Each owner signs in to the same organization; staff see only what their role allows
Reports	One Summary sheet	Dashboard and reports, exported to Excel or PDF
Bank connections	None	None — you record transactions yourself

Questions about the template

Is the spreadsheet really free?

Yes. The download link gives you the file directly — no signup, email address or account. Use it and change it however suits your business.

Which spreadsheet apps does it work in?

It's an Excel workbook (.xlsx), tested in desktop Excel and Apple Numbers. It uses only standard functions — SUM, SUMIFS, COUNTIFS, IF and DATE — and dropdown lists, with no macros, scripts or external links.

How many owners can it handle?

Up to ten. Add each owner's name on the Setup sheet and they appear in the Paid by dropdown and in the Summary's by-owner table. Nothing in the workbook assumes two owners.

Can I use my own expense categories?

Yes. Setup starts with nine common categories; rename them, delete them or add your own, up to 30. The Category dropdown and the by-category summary follow your list. They are record-keeping categories, not tax categories.

Does it calculate how much one owner should pay another?

No. It shows what each owner paid personally and, if you enter shares, how far each owner is above or below their share of owner-paid expenses. Whether anyone should pay anyone also depends on revenue received personally, profit sharing, capital, withdrawals and settlements already made — which is what Partner Balance in RecordSplit brings together.

Is the share of owner-paid expenses the same as ownership or the profit split?

Not necessarily. Owners can own the business 60/40, split profit 50/50 and share owner-paid costs another way. The share on Setup is only for owner-paid expenses, it's optional, and the Summary uses it only when the shares total 100%.

Is a cost an owner paid personally still a business expense?

Yes — the full amount is a business expense whoever paid it, which is why the Summary counts it in total expenses. What changes is who funded it. The guide business expenses paid personally explains it with figures. Tax treatment depends on your structure and jurisdiction.

Is my data sent anywhere?

No. The workbook has no macros, connections or external links; your figures stay in the file, wherever you keep it.

Download the
free spreadsheet.

Four sheets, standard formulas and example rows to delete. No signup or email.

Download the free spreadsheet Or start free with RecordSplit

Excel workbook (.xlsx), 46 KB · No signup or email · No macros

Business partner expense tracker spreadsheet

What the workbook looks like.

Four sheets, nothing hidden.

Nine columns for every expense.

Five steps, the same as the Read me.

Maya and Daniel's March expenses.

What a spreadsheet can't do.

When the spreadsheet isn't enough.