Health and family

How to see who changed an expense entry when you work without a team

Gig workers sharing records with a partner or a CA need a change trail; this explains how to build one with a sheet, version history and a simple log.

Editorial illustration for How to see who changed an expense entry when you work without a team

An audit trail answers three questions: what changed, who changed it, and when. If you share your expense records with a partner, a helper or a CA, you can build a usable trail with three habits: never overwrite, write a one-line change note, and keep dated copies. A tool with a built-in log is a bonus, not a precondition.

Why a gig worker would need one at all

Say you and a cousin both ride for delivery platforms and keep a shared sheet of fuel and repair costs. One day a ₹4,200 repair shows as ₹420. Nobody remembers editing it, and your CA wants to know which figure is right.

Without a trail, you settle it by trust and memory. With a trail, you settle it by reading.

What a basic change log records

ColumnExample
Date and time of the change12 Nov, 9:40 pm
Who changed itCousin
Row or transactionRepair, 3 Nov
Old value₹420
New value₹4,200
Reason and proofGarage bill photo attached

Keep it on a second sheet inside the same file, or in a notes app that records dates. The rule is that every edit to an amount, category or date gets a line.

Can a spreadsheet show who changed what?

Google Sheets keeps a version history that shows which signed-in person edited a file and when, and lets you restore an earlier version. Check that you are viewing the history of the right file and that collaborators are signed in, since edits through an anonymous link may not show a name. In Excel, features differ by version and by where the file is stored, so check what yours offers before relying on it.

A worked check: one disputed repair

  1. Open the version history and find the first version where the amount shows ₹420.
  2. Note the person and time on that version.
  3. Compare it with the next version and see when it was changed to ₹4,200.
  4. Match the final amount with the garage bill photo.
  5. Add a line in the change log so the explanation lives with the row.

A quick count helps too: if fuel is ₹6,000 and repair ₹4,200, the sheet total should be 6,000 + 4,200 = ₹10,200. If the total reads ₹6,420, you have found the effect of the mistake.

What about a tracker app?

Check what the app records before you rely on it. SpendixAI lists import history with status, flags possible duplicate imports, keeps receipts attached to their transactions, and holds deleted transactions in a recycle bin for 30 days. This is not the same as a full change history of every edit, so keep your own note for amount changes if your partner or CA needs one.

Who should get edit rights?

Fewer people than you think. A partner who helps record cash may need edit rights, but a CA usually needs only view or comment access, since they review the record rather than write to it. If a tool lets you assign roles, give the lowest level that gets the job done, and review the list every few months. Most accidental edits come from people who never needed to edit at all.

Finally, make a habit of reading the log at the end of each month with whoever shares the records. It takes five minutes, and it changes behaviour: people edit more carefully when they know the changes are visible. If you find an edit with no reason, ask about it kindly, as a question about the record rather than about the person. Most surprises turn out to be honest corrections made in a hurry.

A habit list

  • One person edits, others comment.
  • Log every change to an amount.
  • Download a dated copy at each month-end.
  • Attach proof to any row you change.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports