In the Google Sheets app, open the file, tap the three-dot menu and switch on Available offline. While you have no connection you can still open the sheet and edit cells, and the changes sync when your phone is back online. Do this before the journey, not on the platform, because the file has to be saved to the phone while you still have signal.
How do I make a sheet available offline?
- Open the Google Sheets app while you are still online.
- Open your expense log, tap the three-dot menu and turn on Available offline.
- Wait for the confirmation or the small offline tick next to the file name.
- Test it: switch on flight mode, then open the file. If it opens and you can type, you are set.
Do it once for each file you need, including a separate summary file if the log is split. On a computer, offline editing in Chrome needs the Google Docs Offline extension and the offline option switched on in Drive settings; the phone app does not need an extension.
What can I do without a connection?
You can add and edit rows, tick checkboxes, pick dropdown values and read formulas that depend only on cells inside the same file. That covers most of an expense log: Date, Amount, Category, Paid by.
| Feature | Offline behaviour |
|---|---|
| Typing new rows, editing cells | Works and is saved on the phone |
| Formulas on data inside the file | Recalculate normally |
| IMPORTRANGE from another file | Cannot fetch new data until you are online |
| GOOGLEFINANCE and web imports | Show the last value or an error until you reconnect |
| Sharing, comments, version history | Need a connection |
If your summary tab pulls the log from a second file with IMPORTRANGE, the numbers can look stale on the train. Keep log and summary in one file so everything keeps calculating.
How does the sync work when I get a signal?
When the phone reconnects, the app uploads the changes you made and pulls anything others changed. You do not press a button. Open the app once on Wi-Fi after the trip and look for the sync indicator to finish before you close it, because a phone that is locked straight away may not finish uploading.
What if two people edit the same shared sheet?
Say you and a family member both log expenses in one file, and one of you was offline. Changes to different cells merge without trouble. If both of you changed the same cell, one edit ends up on top, and you may not notice. The simplest defences:
- Give each person their own tab, or their own rows in a Paid by column.
- Do not edit an existing cell offline if someone else might also change it; add a new row instead.
- After syncing, open File, Version history, See version history to see who changed what and restore an older version if a cell was overwritten.
Where does offline logging fit with your bank statement?
Offline entries are mostly cash and small purchases made where the network is weak, such as a hill road tea stall or a village market. Card and UPI payments will turn up later on the bank statement anyway. When you are ready to see everything together, SpendixAI can take the statement upload, and cash spends can be added there by hand, one or several at a time.
Offline checklist
- Available offline switched on for every file you will use.
- Log and summary kept in the same file.
- One tab or one set of rows per person on shared sheets.
- Sync finished on Wi-Fi when you are back, before you close the app.
- Version history checked if a number looks wrong.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
