Balance Shared Expenses by 55% and 45% in WPS Spreadsheets
Question details
Create an expense workbook that calculates what two people owe when shared costs are split at 55% and 45%, including repayments in either direction.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- Two people pay shared expenses from different accounts and need to reconcile their required contributions against the amounts they actually paid.
- Observed behavior
- The workbook needs to show a positive or negative net balance after applying each person’s percentage share, direct payments, and repayments.
List every shared expense with its total amount and record who paid it. Decide which sign convention the worksheet will use, such as a positive balance meaning Person B owes Person A.
Calculate each person’s share and net balance with signed repayments
Use this method when expenses are paid individually and you need an ongoing balance that can switch direction as repayments are recorded.
Calculate each person’s required contribution from the total shared expenses, then compare it with what each person paid. Record repayments as signed amounts so the same formula handles money moving in either direction.
In WPS Spreadsheets, create columns for Date, Description, Total Expense, Paid by Person A, Paid by Person B, and Repayment from B to A. Enter each shared purchase on a separate row.
In a summary area, calculate Person A’s required share with =SUM(C2:C100)*55% and Person B’s required share with =SUM(C2:C100)*45%, adjusting the Total Expense range as needed.
Use =SUM(D2:D100) for Person A’s direct payments and =SUM(E2:E100) for Person B’s direct payments. If one person pays the full bill, enter the full amount only in that person’s payment column.
In the Repayment from B to A column, enter a positive number when Person B repays Person A and a negative number when Person A repays Person B. Use =SUM(F2:F100) to total repayments.
Calculate Person A’s net position with =SUM(D2:D100)-SUM(C2:C100)*55%+SUM(F2:F100). A positive result means Person A has paid more than their required share and should receive that amount; a negative result means Person A owes the absolute value.
Fund a dedicated shared account at the agreed percentages
Use this approach when you want to reduce reconciliation work for recurring household or joint expenses.
Create a 55% and 45% shared-expense settlement tracker in WPS Spreadsheets
WPS Spreadsheets lets you build a clear shared-expense tracker with percentage formulas, payment totals, signed repayments, and a live settlement balance. Use simple formulas to identify who owes money after every new expense or repayment.
- 1. Open a blank spreadsheet: Launch WPS Office and select Spreadsheets > New Blank Workbook.
- 2. Add the expense-tracking headers: In row 1, enter Date, Description, Total Expense, Paid by Person A, Paid by Person B, and Repayment from B to A.
- 3. Build the summary formulas: In a summary section, use SUM formulas to total expenses and payments, then multiply the expense total by 55% and 45%.
- 4. Calculate the current settlement: Enter a net-balance formula that subtracts Person A’s 55% share from their payments and adds signed repayments.
- 5. Save or share the workbook: Select Menu > Save As to store the tracker, or use Share to send the updated workbook to the other contributor.
Frequently Asked Questions
How do I calculate what each person should pay for a shared expense?
Multiply the total shared expense by each agreed percentage. For a $100 expense, the 55% contributor owes $55 and the 45% contributor owes $45.
What does a negative settlement balance mean?
It depends on the sign convention in your formula. If your formula measures Person A’s payments minus Person A’s required share, a negative result means Person A has paid too little and owes the absolute value.
How should I enter a repayment when the money goes in the opposite direction?
Use one repayment column with a defined direction. If positive values mean Person B pays Person A, enter a negative value when Person A pays Person B.
Can I track expenses when one person pays the full bill?
Yes. Enter the full bill amount in the payment column for the person who paid it, then let the summary formula compare that payment with each person’s percentage share.
Should repayments be included in total expenses?
No. Keep repayments separate from purchases. Expenses determine each person’s required share, while repayments only reduce or reverse the amount one person owes the other.
