Agree on the parking rule before anyone sends money. An equal split usually fits a fixed permit when access is similar; a usage-based split fits a space used on different schedules. Put the decision in writing, then use a shared sheet that separates charges from repayments.
Parking may mean a permit, a reserved driveway space, metered visits, guest access, or several of these at once. Give each type a clear rule before the first charge arrives.
Choose the rule before you split the bill
Start with what the charge buys: access, priority, or actual use. A spreadsheet can apply a rule consistently, but it can't decide whether that rule feels fair.
| Method | Good fit | Tradeoff |
|---|---|---|
| Equal split | A shared permit or driveway with similar access for everyone | Easy to maintain, but it can feel unfair when use differs sharply |
| Usage-based split | Metered parking, guest parking, or a space used on different schedules | More precise, but someone must keep a usage log |
| Room-size split | Parking is part of a broader housing arrangement with materially different rooms | Simple once agreed, but bedroom size doesn't measure car use |
| Priority-adjusted split | One person gets a reserved, covered, or especially convenient space | Can reflect different value, but requires a specific dollar adjustment |
| Mixed split | A fixed permit is shared equally while variable charges follow usage | Matches different cost types, but needs two rules in the sheet |
For usage-based parking, use this calculation:
person's share = total parking cost x (person's agreed units / total units)
Choose the unit first. It could be a parked night, calendar day, entry, or reserved block. Don't switch units halfway through the month.
For example, an $80 charge split across 20, 10, and 10 agreed units would be $40, $20, and $20. Turns out, a fixed permit often needs no usage log when access is genuinely equal. If one housemate gets the only convenient spot, equal cost may still feel wrong even if everyone has a key.
Round shares to cents. If rounding leaves a penny, assign it to one person's share and write that convention in the Rules tab.
Write down access and exceptions
Many disputes come from exceptions, not arithmetic. Before collecting the first dollar, record the decisions that could change someone's access or balance.
| Decision | What to record |
|---|---|
| Who can park | The people allowed to use the driveway, permit, or reserved space |
| Cost included | Permit, rent add-on, meter fees, guest charges, tickets, or other items |
| Usage unit | Night, day, entry, reserved block, or another agreed measure |
| Guest use | Whether guests can use the space and who pays for that use |
| Absences | Whether someone still pays for reserved access while away |
| Price changes | How a new permit price or extra fee will be divided |
| Move-out timing | The date a departing housemate stops owing future charges |
| Review point | A monthly check or a review after a major access change |
Check the lease, building or HOA rules, and local parking requirements first. A roommate spreadsheet can't override a reserved-space restriction or permit condition.
Put the final rule in the sheet, not only in a group chat. A sentence such as "The monthly permit is equal; metered visits are paid by the person who uses them" is much easier to revisit than a scattered conversation.
Build a Google Sheets tracker that stays readable
Use four tabs: Rules, Expenses, Payments, and Summary. One row should represent one parking charge, not one row per housemate.
- Rules: Write the split method, access limits, guest policy, usage unit, and review date.
- Expenses: Enter every permit, meter charge, or other agreed parking cost.
- Payments: Record repayments separately from the original expense.
- Summary: Show what each person owes or should receive after repayments.
Use actual housemate names in place of Alex, Blair, and Casey. This expense layout works well for three people:
| Column | What to enter |
|---|---|
| A Date | Date the charge occurred |
| B Description | Monthly permit, meter session, guest parking, or another clear label |
| C Amount | Full charge paid |
| D Split method | Equal, usage, room-size, priority, or mixed |
| E Paid by | Person who paid upfront |
| F to H | Alex, Blair, and Casey percentage shares |
| I to K | Alex, Blair, and Casey amounts owed |
| L to N | Each person's net before repayments |
| O Status | Unreviewed, reviewed, or disputed |
| P Note or receipt | Usage count, exception, or receipt location |
Format the amount and balance columns as currency. Format the percentage columns as percentages, then enter values such as 33.33%. Don't mix percentage-formatted cells with plain numbers such as 33.33 unless the formulas are written for that convention.
Assume C is Amount, E is Paid by, F:H are percentage shares, I:K are amounts owed, and L:N are net amounts. Put these formulas in row 2:
| Cell | Formula |
|---|---|
I2 |
=ROUND($C2*$F2,2) |
J2 |
=ROUND($C2*$G2,2) |
K2 |
=ROUND($C2-I2-J2,2) |
L2 |
=I2-IF($E2="Alex",$C2,0) |
M2 |
=J2-IF($E2="Blair",$C2,0) |
N2 |
=K2-IF($E2="Casey",$C2,0) |
Copy the formulas down the sheet. The K2 formula uses the remainder, so the three rounded shares still add up to the full charge. With four housemates, add more share and net columns, then make the last person's share the amount minus the earlier rounded shares.
Check each row with =SUM(F2:H2). It should show 100%. A positive net means that person owes money; a negative net means that person should receive money.
Add a usage log only when it changes the split
Usage logs help when people genuinely use parking differently. They create extra work, though, so don't track every entry just because the spreadsheet allows it.
To be honest, a usage log is a poor fit when everyone pays for the option to park, whether or not they use it every night. In that case, split the access fee by the agreed access rule and track only variable charges.
| Usage field | Record |
|---|---|
| Period | Month, billing cycle, or date range |
| Person | Housemate connected to the usage |
| Agreed unit | Night, day, entry, or reserved block |
| Count | Number of units used or reserved |
| Note | Guest use, absence, exception, or adjustment |
One line per person for each billing period is usually easier to review than one line for every parking event. If the group pays for reserved access, count reserved units rather than actual nights unless everyone agrees otherwise.
Record repayments as transfers
A repayment isn't another parking expense. Keep it on the Payments tab so the original permit or meter charge remains visible.
| Column | What to enter |
|---|---|
| A Date | Date the repayment was sent |
| B From | Person who sent money |
| C To | Person who received money |
| D Amount | Amount transferred |
| E Note | Related month, expense, or confirmation note |
For the Summary tab, put Alex, Blair, and Casey in A2:A4. The expense net formulas for column B would be:
| Cell | Formula |
|---|---|
B2 |
=SUM(Expenses!L2:L1000) |
B3 |
=SUM(Expenses!M2:M1000) |
B4 |
=SUM(Expenses!N2:N1000) |
C2 |
=SUMIF(Payments!$B$2:$B$1000,$A2,Payments!$D$2:$D$1000) |
D2 |
=SUMIF(Payments!$C$2:$C$1000,$A2,Payments!$D$2:$D$1000) |
E2 |
=B2-C2+D2 |
Use columns C, D, and E for Sent, Received, and Adjusted balance. Copy the last three formulas down. A positive adjusted balance means the person still owes money. A negative balance means that person should receive money. Zero means the recorded charges and repayments balance.
Don't rewrite an expense row to hide a repayment. Record the transfer, then let the Summary tab show its effect. A simple reminder works well: "I added the parking charge. Please check the Summary tab and record your payment after sending it."
Share the sheet without losing control
Thing is, real-time editing only helps when the right people can edit the right cells. Use the sharing controls deliberately.
| Setting | Practical choice |
|---|---|
| People with access | Add housemates individually when possible |
| Permission level | Give Editor access to people entering charges; use Viewer access for someone who only needs to review |
| Link sharing | Avoid an open link for private household records unless everyone accepts the wider access |
| Formula columns | Protect formula cells if your group can work with protected ranges |
| Input fields | Use dropdowns for Split method, Paid by, and Status |
| Visibility | Freeze the first row and keep receipts or notes free of passwords and account details |
If a link is used, check who can open it and whether editors can invite others. The permission labels can vary by account or device, so review the sharing panel before sending the link.
Google Sheets records the agreement; it doesn't confirm that a transfer happened. Mark a payment only after the sender has reported it, and keep any confirmation note the group needs.
Reconcile before anyone settles up
Check the sheet after each new charge, then do a monthly close if parking is recurring.
| Check | Question |
|---|---|
| Missing charges | Is every permit, meter, guest, or agreed fee entered? |
| Split percentages | Does each expense row total 100%? |
| Payer | Does the Paid by name match the person who covered the charge? |
| Usage | Do the logged units match the written rule? |
| Repayments | Is each transfer on the Payments tab rather than the Expenses tab? |
| Rule changes | Did access, price, roommates, or guest use change? |
If someone forgets an expense, add it with the date and a note instead of silently changing an old row. Thing is, the sheet will still be wrong if one person changes a percentage halfway through a month, forgets a guest charge, and tries to fix everything from memory later. Close the period, document the correction, and start the next one with the new rule.
Create the Rules tab first. Write one sentence for the fixed charge, one for variable use, and one for guest parking, then enter the next real expense as your first row.