Spreadsheets

Before you share your finance sheet: a privacy clean-up checklist

A privacy clean-up checklist for sharing a finance spreadsheet with an adviser, spouse or flatmate: remove identifiers, check hidden data and set link limits.

Editorial illustration for Before you share your finance sheet: a privacy clean-up checklist

Before you share a finance sheet, make a copy, strip account numbers, names and phone numbers, check for hidden sheets, comments and pivot data, and share view-only with specific people instead of an open link. Treat the copy as the thing you share and keep the original private. The checklist below takes about fifteen minutes.

Step one: decide what the other person actually needs

A CA needs amounts and categories. A flatmate splitting rent needs one number. A spouse co-managing the budget may need nearly everything. Start from that, because the less you include, the less can leak. If a summary tab answers the question, share a file containing only the summary as values.

What should you strip out?

  • Bank account numbers, card numbers and customer IDs, including partial numbers that identify an account.
  • Your name, family names and phone numbers, which often sit inside UPI descriptions.
  • UPI IDs, email addresses and home addresses.
  • PAN, Aadhaar and any identity number pasted into a notes column.
  • Any hints about logins or security answers left in a notes column.
  • The file name itself, if it includes your name or bank.

Use Find and Replace to swap a name for the word Person across the whole workbook, and replace each account number with the word Account A, Account B.

Where does hidden data hide?

  1. Hidden sheets. Right-click any tab and choose Unhide to see if one exists. In Google Sheets, check the sheet list at the bottom.
  2. Hidden rows and columns. Select everything and unhide to reveal them.
  3. Comments and notes. Review each one, since they often hold details you wrote casually.
  4. Pivot tables. A pivot can keep its own copy of the source data. Copy the pivot and paste as values into a new sheet, then delete the old pivot.
  5. Formulas pointing to other files. Paste as values so nothing refers back to a private location.
  6. Document properties. In Excel, File, Info, Check for Issues, Inspect Document lists author names and hidden content you can remove.

How do you share it safely?

SettingWhat to choose
Who can openSpecific people by email, not anyone with the link
Their permissionView only, unless they truly need to edit
Download and copyTurn off for viewers if your tool offers it
ExpirySet an end date if your tool offers it, or note a date to remove access yourself
Original fileKeep private and separate from the shared copy

Afterwards, open the shared link in a private or incognito window to see exactly what an outsider would see. If anything surprising shows, fix it before sending.

How do you lock formulas and structure?

If someone will edit, protect the cells they should not touch. In Excel choose Review, Protect Sheet and unlock the input cells first. In Google Sheets, use Data, Protect sheets and ranges. This stops accidental overwriting of formulas, which is a bigger risk than malice. It is not a security barrier, so do not rely on it to hide anything.

When you are the adviser's client

If a CA or planner asks for your sheet, ask them how they prefer to receive it and how they store it. Share amounts and categories, and give identity details only through whatever route they prescribe, not inside the sheet.

The short version to keep

  1. Copy the file.
  2. Remove identifiers and hidden data.
  3. Paste summaries as values.
  4. Share view-only with named people.
  5. Test the link in a private window.
  6. Remove access when the job is done.

Keeping a sheet clean for sharing is easier if the data never carried account numbers in the first place, and SpendixAI offers CSV downloads and an Export centre with templates for accounting tools. Whichever tool made the file, open it and read it through before you send it on.

SPENDIXAI JOURNAL

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

Explore your reports