Parking shows up as a $200 monthly permit, a street fee, or a string of event charges, and each one splits differently. For an unmarried couple, a fair split comes from two things: the benefit each person actually gets, and the rule you both pick before the next bill arrives.
Go 50/50 when access and use are about the same. If one of you occupies the space far more often, usage percentages fit better. And when the goal is for the cost to take the same bite out of each paycheck, that's an income split.
So what's fair when one car sits in the garage and the other doesn't? That's what the spreadsheet settles. Log the full charge, who paid, each person's share, and any payback. The sheet records the agreement; a payment app or bank transfer only moves the money.
Being in a relationship doesn't hand you a default split. Keep rules narrow, too. A monthly garage permit might be shared, but a personal parking ticket or work-only parking belongs to whoever incurred it.
Choose the split before you track anything
Start by naming what you're actually splitting. A reserved space has a fixed price even when one car sits elsewhere, so usage math changes how you allocate the cost. It doesn't change the garage's invoice.
| Method | Fits when | Parking example | Tradeoff |
|---|---|---|---|
| Equal, 50/50 | Both people get similar access or want the simplest rule | A $200 permit becomes $100 each | Easy to maintain, but it ignores uneven use or income |
| Usage-based | One person occupies the space more often | One person parks 18 of 30 nights and pays 60% | More tailored, but you need an agreed counting method |
| Income-based | You want each person to contribute a share based on take-home income | A $4,000 and $6,000 take-home split becomes 40/60, or $80 and $120 on a $200 permit | Requires agreement about income and review dates |
| Per-use or per-person | The charge comes from an event, visitor, meter, or valet use | The person who parks pays, or attendees split the fee | Clean for one-off costs, less useful for shared monthly access |
Turns out a hybrid can be cleaner for mixed costs. Split the monthly access fee 50/50, then assign valet, meter, or event charges to whoever used them. Write the hybrid down somewhere. Trying to infer it later is where couples get stuck.
If you pick income-based sharing, agree on the income measure first. Using take-home amounts, someone bringing home $4,000 of a combined $10,000 would cover 40% of a $200 permit, or $80. Store the 40% in a Settings tab and salary figures never have to sit on every expense row.
Put the exceptions in writing
Small parking rules prevent large arguments. Decide who owns each kind of charge, when reimbursement happens, and what would change the percentage.
- Monthly permit or reserved spot: Write down the method, the percentages, the billing date, and when you'll review it.
- Visitor or event parking: Settle on per-person, per-car, or user-pays treatment in advance.
- Tickets, towing, and work-only parking: These stay with the responsible person unless you both expressly treat them as shared.
- Deposits, access cards, and refunds: Say whether they're shared, and return any refund using the same split.
Try a plain rule, something like:
"For the building permit, we'll use 60/40 based on nights parked. I paid the $200 charge, so your share is $80. We'll check the ratio at month-end."
Save that sentence in the sheet's Notes area. Keep the note. Keep the receipt too. It sounds like overkill for a small event fee, but missing details are what make later balances feel personal, and personal is where the arguing starts.
Then review the rule after a car change, a move, a schedule change, or an income change. A stable permit usually needs only a monthly reconciliation. A changed routine deserves a fresh percentage before the next billing cycle, not after.
Build a two-tab parking tracker
Each expense row should answer four questions: what was charged, who paid, how it was split, and whether the difference got settled. Two tabs keep the math visible. They also stop a small bill from becoming a project.
| Tab and field | What to enter | Example or formula |
|---|---|---|
Expenses - Date |
Date of the charge or parking use | May 1 |
Expenses - Description |
Permit, garage, event, meter, or other detail | Building garage permit |
Expenses - Total cost |
The full amount charged | $200 |
Expenses - Paid by |
The person who paid the provider | Partner A |
Expenses - Split method |
Equal, Usage, Income, or Custom |
Usage |
Expenses - Partner A % |
A's agreed share of the cost | 60% |
Expenses - Partner A share |
A's calculated share | =C2*F2 |
Expenses - Partner B share |
B's calculated share | =C2-G2 |
Expenses - A position |
A's payment minus A's share | =IF(D2="Partner A",C2,0)-G2 |
Expenses - Running A balance |
Running total before settlements | =SUM($I$2:I2) |
Expenses - Receipt link |
Invoice, photo, email, or file link | Permit invoice |
Expenses - Notes |
Usage count or special rule | 18 of 30 nights |
Settlements - Date |
Date of reimbursement | May 5 |
Settlements - From |
Person who sent the reimbursement | Partner B |
Settlements - To |
Person who received it | Partner A |
Settlements - Amount |
Amount transferred | $80 |
Settlements - Note |
What the reimbursement covered | May permit |
Enter the full charge once. Don't enter $80 as the total just because that's what one person owes.
Here's how A position reads: a positive number is money Partner A has advanced beyond their share. A negative number means A hasn't covered enough yet. Partner B is the mirror image.
Reimbursements live on the separate Settlements tab, which keeps a payment from being mistaken for a new parking expense. If you later add utilities or groceries, the same record structure can expand into a shared expense tracker with a reimbursement column.
On a Summary tab, calculate the amount still owed with this formula:
=SUM(Expenses!I2:I)-SUMIF(Settlements!C2:C,"Partner A",Settlements!D2:D)+SUMIF(Settlements!B2:B,"Partner A",Settlements!D2:D)
A positive result means Partner B still owes Partner A. Negative, and Partner A owes Partner B.
Make each row show the agreed percentage
The Settings tab exists so repeated math stays out of the expense log. Use it for current assumptions, but preserve the percentage that applied to each settled charge.
Suppose Settings!B2 holds Partner A's take-home income and Settings!B3 holds Partner B's. In Settings!B4, use =B2/(B2+B3). That cell is Partner A's income percentage.
Usage works the same way. Partner A's count goes in Settings!B5, Partner B's in Settings!B6, and =B5/(B5+B6) in Settings!B7 returns A's usage percentage. The counts might be occupied nights, but agree on the unit first.
For rows using the standard methods, the Partner A percentage cell can use:
=IF(E2="Equal",0.5,IF(E2="Income",Settings!$B$4,IF(E2="Usage",Settings!$B$7,"")))
Custom rows get a typed-in percentage. Format the cell as a percentage, then check that the two shares add back up to the full cost.
Thing is, a live Settings cell can rewrite last month's split the moment this month's income or usage changes. Before changing a percentage, copy the final value into old rows or record it in Notes. Historical rows should show what you agreed then, not what the settings happen to be today.
Make reimbursement routine, not awkward
Money conversations get easier when the process is boring and out in the open. The sheet shows the amount and the reason. Neither of you should have to reconstruct the past from memory.
- Before the first charge, record the method, percentage, exceptions, and review point in Notes.
- When a charge occurs, enter the full amount, actual payer, split method, and receipt link.
- When someone reimburses the payer, log the transfer on the Settlements tab with sender, recipient, amount, and date.
- At the review point, check the final balance and agree on the next payment. Positive means Partner B owes Partner A; negative means the reverse.
- If the car, permit, schedule, or income changes, discuss the new rule before changing future rows.
Share the file with the people who need to enter rows, check the sharing setting before sending it, and use version history if a formula gets overwritten. No app required.
Run the example: Partner A pays $200 with a 60% share. A's share is $120, B's is $80, and A's position sits at positive $80. B sends the $80, you log it, and the final A balance lands at $0.
Separate fixed access from one-off parking
A monthly permit and a Saturday meter fee don't need the same formula. For a visitor or event, per-person or per-user splitting is often easier. Work-only parking stays with the person who benefits unless you both agree to share it.
Tickets and towing need a named rule. A practical default: a charge caused by one person's action goes to that person, while a refundable access-card deposit follows the agreed shared split. Check the lease, garage agreement, or permit terms before changing the named user or treating a space as transferable.
To be honest, the silent switch is the trap. If one partner is away for two weeks, don't quietly change methods. Keep the fixed ratio if that's what you agreed, and move to actual nights only after both people accept the change.
FAQ
Is 50/50 fair for a shared parking spot?
Sometimes. It fits when both people have comparable access or just want the simplest rule available. It isn't automatically fair when one person gets most of the use, or when the income burden matters to one of you.
How do we split a $200 permit by usage?
Count the unit you agreed on, like occupied nights, then divide each person's count by the total. At 18 nights and 12 nights, the shares come to 60% and 40%, or $120 and $80. On a fixed permit, this reallocates the cost. The permit price itself doesn't move.
Should an income-based split use gross or take-home pay?
Either works if both people agree. Take-home may track available cash better, though. Record whichever measure you chose and update it only at an agreed review point.
What if one partner paid the whole bill?
Record the full total with that person in Paid by. The share formulas will show what the other person owes, and the payback goes on the Settlements tab. Don't enter just the owed amount as the parking cost.
Does the spreadsheet replace lease or permit rules?
No. The sheet records your cost-sharing arrangement. Lease, garage, employer, or local parking rules can still control who gets to use the space, so check those terms on their own.
Open a blank sheet, set up the Expenses, Settlements, and Settings tabs, and enter your last parking charge. Agree on the next split while you're in there. Then add the first receipt link before the next bill shows up.