The safest way to share an expense spreadsheet read-only is to send a copy that contains only what the other person needs, as a PDF or a view-only link. Mark as Final and "cannot edit" settings help prevent accidents, but they are not a lock. So decide first what you are showing, trim the file, then choose the format.
Which read-only method should I use?
| Method | Good for | Limit to know |
|---|---|---|
| View-only link in Google Sheets or OneDrive | Family who check the sheet now and then | Anyone you forward the link to may open it unless you restrict it to named people |
| Excel Mark as Final | Telling a reader that this version is finished | A flag only; the reader can click Edit Anyway |
| PDF copy | A CA or a bank who just needs to read figures | Static: the reader cannot filter or check formulas |
| Copy of the file with values only | A CA who wants to work with the numbers | Formulas are gone, so you cannot trace the logic |
A rough rule: a PDF when the reader needs to look, a values-only file when the reader needs to work, and a view link when the reader needs to look again next month.
How do I make a view-only link?
In Google Sheets, press Share, then under General access choose Restricted and add the email addresses, or choose Anyone with the link and set the role to Viewer. Prefer named people when the sheet shows spending. In Excel stored on OneDrive, press Share, open the link settings, and set the permission to Can view; there is a separate tick box for allowing editing, which should be off. Menu names change between updates, so read what your own screen says.
Remember that a viewer can often still download or make their own copy unless you switch that off in the sharing settings. Look for a setting about letting viewers download, print or copy.
What should I remove before sharing?
Do this before choosing any method. Work on a copy, never on your working file.
- Save a copy and add "share" to its name.
- Delete the columns the reader does not need: narrations with names or UPI IDs, account numbers, phone numbers, and any notes column with remarks about people.
- Check hidden sheets, hidden rows and hidden columns. Right-click a sheet tab and look at Unhide.
- Convert formulas to values if you do not want to expose the working: select the range, copy, then Paste Special, Values.
- Look at File, Info and Inspect Workbook for comments, author names and personal information stored inside the file.
- Open the copy as if you were the recipient and read every tab once.
What does a CA usually want to see?
Ask your CA before sending anything. Many prefer date, description, amount and category in a flat table, with one tab per financial year from April to March, rather than a dashboard. Ask whether they want the totals or the raw rows, and whether supporting receipts should come as separate scans. Sending exactly what was asked saves a round of back-and-forth, and it keeps the rest of your finances out of the email.
A quick sharing checklist
- Is this a copy, not my working file?
- Are sensitive columns deleted, not hidden?
- Is the link restricted to named people, or a PDF used instead?
- Do I know who else the recipient might forward it to?
- Will I need to turn off access once the purpose is done, such as after the ITR is filed?
If you find yourself preparing a trimmed copy every month, a tracker that keeps your statements and categories in one place and lets you download a CSV of exactly the filtered rows may save the effort. SpendixAI has a report builder and CSV download for that purpose.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


