Shared flats break a ledger in a specific way. One person pays the power bill, another pays wifi, and someone pays the maid. Then UPI transfers chase those bills around the flat. If every payment is labelled utilities, the home looks far more expensive than it is. Each phone can send its own bank SMS into one Google Sheet. Kharch Log does that without a bank login. The bill is the expense. The share that comes back is a transfer. Your cost is what you paid minus what returned.
One method for power, wifi, and the maid
Use one method for electricity, wifi, and the maid. The person who pays the outside party logs the full amount in that category. Roommates who pay you later are not a second bill. Their UPI is a transfer. Your note on the bill lists the shares. If each person pays the provider directly, log only your own SMS. Do not also log a full bill you did not pay. Mixing both methods in one month doubles the cost. Write the method in the header so the flat does not renegotiate it weekly.
Cash for the maid is the row most flats lose, because there is often no SMS. The person who paid types household help the same day, with the month. Incoming UPI shares are transfers, not a second salary for the maid. If everyone pays the maid directly in cash, each person types only their own notes. Do not combine that with a full-bill row. One method is easier to audit than four memories. Type the cash the same day, before the group chat scrolls away.
- Full bill logged by the payer, shares logged as transfers
- Or each person logs only what they paid the provider
- Never both in the same month
- Maid cash is typed the same day by the person who paid
Match a share to the bill it closes
Put the payer's name on the bill and the word share on the settlement. You will not remember the queue a month later. If the share arrives next month, say which bill it closes. A credit in October for a September bill should not loosen October's food cap. Match it in the note. The credit is not new income. The SMS shows the money. The note is what ties it to last month's bill.
Do not chase a perfect split to the rupee. If the shares in the note add to the SMS, the split is good enough. Ignoring a leftover amount makes it the payer's silent cost every month. Write the UPI you actually received, not the ideal share from a chat. The gap can be noted as the payer's extra. If the flat agrees the payer absorbs round-off, say that once in the header. Then stop debating it in the rows. Record the amounts that happened.
Wifi plans and power periods
Home wifi is often one broadband debit, sometimes with rental bundled in. Log the full debit as internet. Shares back to the payer are transfers. If the plan price changes, write new plan and the month in the note. Do not keep collecting the old share after the SMS has changed. Update the header figure the day the bill is higher. A personal mobile recharge is not the flat's wifi. Keep it out of the split. Similar SMS text is why the note has to say flat wifi or personal data.
Put the billing period in the electricity note, not only the word power. A high bill is easier to read when the dates are written. Late fees should be visible in the note, not folded into a vague higher bill. If an employer pays back a work-from-home slice, mark only that slice. Clear it when the credit arrives. Do not clear the entire bill if only a part was claimed. Flat shares apply to what remains. Otherwise the flat subsidises a claim that already came back.
- Note the billing period on electricity
- Update the wifi share when the plan SMS changes
- Personal mobile recharge stays out of the flat split
- A partial reimbursement clears only that slice
Keep the ledger on the Sheet you already use
A shared Sheet with consistent notes can replace a separate split app. Filter utilities, internet, and household help, plus the share transfers. Once a month the payer checks that each bill has its incoming shares. That is about ten minutes. If someone has not paid, keep the full bill. The missing share is a note, not a reason to delete the expense. Deleting the bill because a roommate is late makes the payer look falsely frugal. The original SMS stays.
When someone moves out, note the last month they share. Stop using their name on new bills. Returning their deposit is a transfer if it is their money going back. It is an expense only if the flat is paying for damage. Say which in the note. Remove their name from the header or the next split will still expect them. Keep old months in the Sheet. Do not start a new file just because the flat changed.
Questions people actually ask
Can the payer log only their own share? Logging only your share hides the full bill and a later hike. Logging the full bill plus transfers shows the household cost and your net. Use the full bill when the account is in your name. Use only your share when you never see the total. Write the method down so a new flatmate can follow it.
Nobody wants to type the maid's cash. What then? If nobody types it, household help stays near zero while the cash is gone. One person can type the full amount the same day. A group chat does not add the month up. If others refuse, the payer should still log the full cash in their own Sheet. Their spending is real even if the flat will not look at it.
Is shared wifi a personal subscription? Not if the flat shares it. Personal subscriptions are things only you use. Flat wifi is internet, and the shares are transfers. A streaming plan only you watch can stay personal. Do not hide the broadband inside personal subscriptions. That makes the flat's cost look like your private lifestyle. The label matters when someone compares spending.
Log the full electricity, wifi, or maid payment once, and label roommate UPI as transfers against that bill. Categories for a household are sketched in household expense categories. Capture is listed on the Kharch Log features page. Check shares once a month, and do not delete the bill while you wait.