This couples budget template works whether you use joint accounts, separate accounts, or a mix. It keeps four questions apart:
- What is the household planning to spend or save?
- Where will the money come from?
- Who will make sure the task happens?
- If the usual owner cannot do it, who takes over?
A single spreadsheet column cannot answer all four. A joint account might pay the electricity bill even when the partners fund it 70/30. Either partner might make the payment, and the backup needs the provider's name and due date.
Open the spreadsheet version in Excel, Google Sheets, Numbers, or your preferred spreadsheet app. The copy, download, and isolated-print controls provide the ready-made CSV, formula fixture, and worksheet without an email address or account.
Copy the monthly budget spreadsheet
Copy everything inside this block and paste it into cell A1. If your spreadsheet does not split the columns automatically, choose comma as the separator.
Section,Line,Shared or personal,Planned amount,Actual amount,Frequency,Due or income date,Paid from,Task owner,Task backup,Notes
Income,Partner A take-home income,Personal,,,,,,,,
Income,Partner B take-home income,Personal,,,,,,,,
Income,Other dependable income,Shared,,,,,,,,
Home,Rent or mortgage,Shared,,,,,,,,
Home,Electricity gas and water,Shared,,,,,,,,
Home,Internet and phones,Discuss,,,,,,,,
Food,Groceries and household supplies,Shared,,,,,,,,
Food,Meals out and takeaway,Discuss,,,,,,,,
Transport,Public transport fuel and parking,Discuss,,,,,,,,
Transport,Vehicle payments insurance and upkeep,Discuss,,,,,,,,
Care,Childcare elder care or other support,Discuss,,,,,,,,
Health,Insurance treatment medicine and accessibility,Discuss,,,,,,,,
Debt,Required debt payments,Discuss,,,,,,,,
Irregular,Annual quarterly and seasonal costs,Discuss,,,,,,,,
Goals,Emergency savings,Shared,,,,,,,,
Goals,Other shared goal,Shared,,,,,,,,
Personal,Partner A personal money,Personal,,,,,,,,
Personal,Partner B personal money,Personal,,,,,,,,
Personal,Partner A personal obligation or goal,Personal,,,,,,,,
Personal,Partner B personal obligation or goal,Personal,,,,,,,,
Fun,Dates entertainment and shared fun,Shared,,,,,,,,
Other,Household-specific line,Discuss,,,,,,,,
TOTAL,Total household income,,"=SUMIF(A:A,""Income"",D:D)","=SUMIF(A:A,""Income"",E:E)",,,,,,
TOTAL,Total planned spending and saving,,"=SUMIFS(D:D,A:A,""<>Income"",A:A,""<>TOTAL"")","=SUMIFS(E:E,A:A,""<>Income"",A:A,""<>TOTAL"")",,,,,,
TOTAL,Planned remainder,,"=SUMIF(A:A,""Income"",D:D)-SUMIFS(D:D,A:A,""<>Income"",A:A,""<>TOTAL"")","=SUMIF(A:A,""Income"",E:E)-SUMIFS(E:E,A:A,""<>Income"",A:A,""<>TOTAL"")",,,,,,Add rows freely. Delete examples that do not belong in your life. A blank row is better than a fake zero when you still need to find the amount.
If a blank template makes it easy to miss irregular or household-specific costs, the couples monthly expenses checklist gives you a fuller category sweep.
The Consumer Financial Protection Bureau separates income tracking, bill timing, spending, and cash-flow planning. This template follows the same useful distinction. An amount tells you how much; a due date tells you when; an owner tells you whether anyone is actually handling it.
Add the spreadsheet formulas
The pasted template puts planned amounts in column D and actual amounts in column E. Its TOTAL rows already contain formulas. They use the labels in column A rather than fixed row numbers, so inserting a new cost row does not silently leave it out:
Planned income: =SUMIF(A:A,"Income",D:D)
Planned outflow: =SUMIFS(D:D,A:A,"<>Income",A:A,"<>TOTAL")
Planned remainder: =SUMIF(A:A,"Income",D:D)-SUMIFS(D:D,A:A,"<>Income",A:A,"<>TOTAL")Use the same formulas with column E for actual amounts. Keep the section label Income on income rows and TOTAL on the three calculation rows. New spending or saving rows can go anywhere else in the sheet.
Here is the paste-ready test fixture. In a blank sheet, paste it into A1 and check that the last three cells read 5,600, 5,600, and zero.
Section,Line,Shared or personal,Planned amount
Income,Partner A income,Personal,3600
Income,Partner B income,Personal,2000
Home food transport health and care,Core household costs,Shared,3350
Debt,Required payments,Discuss,450
Irregular,Annual-cost funds,Shared,300
Goals,Shared goals,Shared,500
Personal,Partner A personal money,Personal,300
Personal,Partner B personal money,Personal,300
Fun,Dates and shared fun,Shared,250
Other,Other household costs,Discuss,150
TOTAL,Total household income,,"=SUMIF(A:A,""Income"",D:D)"
TOTAL,Total planned outflow,,"=SUMIFS(D:D,A:A,""<>Income"",A:A,""<>TOTAL"")"
TOTAL,Planned remainder,,"=SUMIF(A:A,""Income"",D:D)-SUMIFS(D:D,A:A,""<>Income"",A:A,""<>TOTAL"")"Zero does not mean you spent all the income. Transfers to emergency savings, annual-bill funds, and other goals are part of planned outflow.
Printable couples budget worksheet
This version fits the decisions onto paper. Select and copy the block below, or use the isolated-print control to print it without the article.
COUPLES MONTHLY BUDGET MONTH: ______________
INCOME
Partner A usable income: ________ Arrives: ________
Partner B usable income: ________ Arrives: ________
Other dependable income: ________ Arrives: ________
TOTAL INCOME: ________
PLANNED SPENDING AND SAVING
Line Shared/personal Planned Due Paid from Owner Backup
Housing _____________ _______ _____ __________ ______ ______
Utilities _____________ _______ _____ __________ ______ ______
Food and household _____________ _______ _____ __________ ______ ______
Transport _____________ _______ _____ __________ ______ ______
Health and care _____________ _______ _____ __________ ______ ______
Required payments _____________ _______ _____ __________ ______ ______
Irregular-cost funds _____________ _______ _____ __________ ______ ______
Shared goals _____________ _______ _____ __________ ______ ______
Partner A personal money PERSONAL _______ _____ __________ ______ ______
Partner B personal money PERSONAL _______ _____ __________ ______ ______
Dates and shared fun SHARED _______ _____ __________ ______ ______
Other: __________________ _____________ _______ _____ __________ ______ ______
Other: __________________ _____________ _______ _____ __________ ______ ______
TOTAL PLANNED OUTFLOW: ________
PLANNED REMAINDER (income - outflow): ________
TIMING CHECK
Lowest expected balance before next income: ________ on __________
Transfer or action needed before then: ______________________________
Owner: __________________________ Backup: __________________________
NEXT REVIEW
Date: __________ One number to verify: _____________________________
One change to test: __________________________________________________Fill it in without turning it into an audit of each other
Start with a recent ordinary month. Each partner can gather their own figures before you sit down. Bring totals for personal categories when line-by-line detail would add heat but no useful decision.
For each cost, choose shared, personal, or discuss. Discuss is a holding place, not a verdict. It is useful for expenses such as a car used for both paid work and family care, support sent to relatives, or a phone that is partly a work cost.
Then complete these columns:
- Planned amount. What you expect this month, not the amount you wish were normal.
- Frequency and date. Keep the real due date even when you convert an annual cost into a monthly amount.
- Paid from. Joint current account, Partner A account, Partner B account, cash, card, or another source you both recognize.
- Task owner. The person who checks or completes the payment. This is not a label for who "owns" the expense.
- Task backup. The person who knows the due date, payment route, and where to check completion if the owner is unavailable.
If one partner earns more, the template does not force equal contributions. The budgeting for couples guide helps you make the agreement underneath the sheet; this template records the result. Equal amounts, income-proportional amounts, a fixed shared-account contribution, and full pooling can all use the same sheet. Compare those choices in how couples split finances.
Convert annual and irregular costs
Use a monthly planning amount for costs that do not arrive monthly. The weekly and every-two-weeks calculations are estimated average months:
Annual amount / 12
Quarterly amount / 3
Estimated average month for a weekly cost = weekly amount x 52 / 12
Estimated average month for an every-two-weeks cost = amount x 26 / 12An annual insurance bill of 720 becomes a monthly planning line of 60. The 52/12 and 26/12 conversions are planning estimates, not a calendar of actual charges; a particular month may contain four or five weekly payments, or two or three every-two-weeks payments. Keep the real dates beside the average. Put the monthly amount aside rather than mistaking it for a bill paid in installments.
For irregular income, enter a conservative amount you can sensibly plan from. Add a second line called income above base only after it arrives. Decide its order in advance, perhaps overdue essentials first, then the timing buffer, then active goals. That keeps a strong month from silently raising next month's fixed plan.
Add a four-week timing check
A monthly surplus can still leave an account short before payday. Use this small ledger for large or tightly timed items:
Date,Income or bill,Amount in,Amount out,Account,Running balance,Owner,Backup
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,Begin with the balance available for this plan, then enter income and bills in date order. The lowest running balance is the number to watch. The couples budget calculator can normalize the monthly totals, but a calendar or ledger is still needed for timing.
Worked example
Nia brings in 3,600 and Sol brings in 2,000, for household income of 5,600. They keep separate current accounts and use one shared bills account.
Their planned lines are:
| Group | Planned amount |
|---|---|
| Home, food, transport, health, and care | 3,350 |
| Required payments | 450 |
| Irregular-cost funds | 300 |
| Shared goals | 500 |
| Personal money, 300 each | 600 |
| Dates and shared fun | 250 |
| Other household costs | 150 |
| Total outflow | 5,600 |
They fund shared costs in proportion to usable income, but keep personal money equal this month because both want the same amount of unsupervised spending room. Nia handles the rent transfer; Sol handles the energy bill and the annual-cost fund. Income share, personal choice, and admin workload are three separate decisions.
Their first draft balances to zero and still fails the timing check: two large bills leave before Sol's income arrives. They carry 400 forward in the shared bills account. The next month's sheet lists that money as an opening timing buffer, not new income.
Once the monthly sheet works, use the couples financial plan template to connect it to assets, debts, protection, longer-term goals, and account changes.
When the template stops helping
Shrink it if you spend more time maintaining categories than making decisions. Combine rows that always move together. Split a row only when the parts have different due dates, owners, or choices.
If one person's private purchase becomes the subject of every review, replace transaction detail with an agreed personal total. If the planned remainder is repeatedly negative, the useful question is not who entered the wrong number. It is which costs can change, which cannot change soon, and what outside options are available.
Copy, download, or print
The controls below copy or download the complete spreadsheet and test fixture, or print only the worksheet without the article around it.