A $35,000 earner and a $90,000 earner park the same car in the same garage. So why should their parking fees match? Splitting parking by budget share ties each person's cost to what they actually earn. If one roommate brings in 60% of total household income, that person covers 60% of the monthly garage spots, trip meters, or visitor passes. The other covers 40%.
Thing is, proportional splitting only works when everyone agrees on the math before the first receipt shows up. A basic sheet keeps the numbers honest. You enter the parking cost, the formulas do the dividing, and there's nothing left to argue about.
Equal Splits Versus Income Ratios
Equal splits look painless on paper. Take a $100 parking bill, divide by two, everybody sends $50. When incomes sit close together, that holds up fine, and the Waleeto expense guide points out the same thing: nearly identical paychecks justify an even split with almost zero math.
Unequal pay changes the picture fast. Say you take home $3,000 a month and your roommate clears $6,000. That $50 takes twice as big a bite out of your cash. A budget-share method balances the financial weight instead of the raw dollars.
How you calculate it stays flexible. A 60/40 split, worked out the way the Jake Lee income ratio spreadsheet does it, means each partner sacrifices an equal portion of their income for shared necessities.
Other households land somewhere else. The SameNest guide to shared household expenses features higher earners covering 65% of common living costs. Neither number is a law. Pick the ratio that fits your place.
How to Build the Parking Tracker
Two tabs. Name the first "Setup" and the second "Parking Log".
In Setup, list each roommate's monthly net earnings in cells B2 and B3. Cell B4 holds the household total, calculated with =SUM(B2:B3). Your income split formula goes in C2: =B2/$B$4. Copy it down to C3 for the second person.
Then set up the log with these columns:
| Column | Header | Row 2 Contents | Formula or Entry |
|---|---|---|---|
| A | Date | Date parking was paid | Enter manually |
| B | Description | Location or lot ticket | Enter manually |
| C | Total Cost | Total dollar amount | Enter receipt total |
| D | Person 1 Share | First person's cost | =ROUND(C2 * Setup!$C$2, 2) |
| E | Person 2 Share | Second person's cost | =C2 - D2 |
| F | Paid By | Who paid at the gate | Name dropdown |
| G | Settled? | Payment status | Checkbox or TRUE/FALSE |
Column E is where the rounding trap hides. Person 2's share comes from =C2 - D2 rather than its own multiplication, because if you multiply and round both percentages separately you'll eventually end up with grand totals off by a cent or two, which drives everyone a little crazy when balances are supposed to come out clean. The subtraction absorbs whatever's left over. To be honest, catching this early saves pointless arguments later on.
For Person 1's running balance across all unpaid rows, use =SUMIF(G2:G, FALSE, D2:D).
Step-by-Step Logging Workflow
Keep the routine boring and it will hold.
- Agree on income figures before anyone signs a lease or rents a car. Pull net monthly earnings from recent pay stubs and enter them in the setup tab.
- Photograph the ticket on the spot. Receipts go straight into a shared folder, before the paper copy gets crumpled or lost in the car door pocket.
- Enter the expense within 48 hours. Put the total in column C, pick the payer in column F, and the sheet handles the split on its own.
- Settle balances on a fixed schedule. First of the month works, or every other Friday. Review the open checkboxes together so nothing drifts.
- Keep payment reminders neutral and short: "Hey, I logged the $40 airport parking ticket. Your 40% share is $16 whenever you get a chance."
When Proportional Splits Fall Short
Turns out, income-based splitting doesn't fit every parking bill. Picture one roommate parking in the building garage every single day while the other only rents vehicles for weekend road trips. Charging both of them by income ratio for that one spot is unreasonable.
Friction shows up in a few predictable places:
- Dedicated spaces: a personal parking stall belongs 100% to the driver who parks there.
- Income privacy: some roommates would rather not share their salaries or tax returns.
- Variable earnings: freelancers and seasonal workers need frequent recalculations.
- Casual road trips: travel groups usually prefer an even split over salary discussions.
Frequently Asked Questions
Should we use gross income or take-home pay?
Use net take-home pay. Taxes, health insurance premiums, and retirement contributions vary heavily from one employer to the next, and take-home pay reflects the real cash you have available to spend.
What if one person does not use the parking spot?
Skip the income split entirely. Mark the non-user at 0% and assign the entire cost to whoever uses the space. Proportional splits apply only to genuinely shared costs.
How often should split ratios be updated?
Revisit the ratios twice a year. Someone who switches jobs, takes a pay cut, or lands a significant promotion should trigger an update sooner than that.
Open a fresh sheet today. Enter your baseline earnings, copy in the columns above, and run your latest parking bill through it.