Pocket Ledger
Get Pocket Ledger
← All guide topics

Android handbook · 1.0.0

Connect Google Sheets.

Optional setup, readable reports and sync troubleshooting.

Settings → Sync & Sheets

Connect your own Sheet.

Optional: the phone remains your primary ledger. Use the Android template and Android script together.

  1. Copy the Android template

    Open the Android Sheet template from Download. In the copy, use Extensions → Apps Script. Replace the code with the current Android script and save.

  2. Prepare its reports

    Run setupPocketLedger once and authorize. Run setupCleanTransactions for the readable Transactions report and hidden Sync Support storage.

  3. Deploy a Web app

    Deploy → New deployment → Web app. Execute as Me; choose Anyone for app access. Keep the resulting /exec URL private. For an existing deployment, edit it to a New version and keep its URL.

  4. Connect from the app

    Set Web App URL. Use Test Connection, then Sync Now. Refresh Sheet dashboard rebuilds the report from synced data; it does not upload the phone’s ledger.

Connected saves can attempt sync automatically; there is no scheduled background sync. Sync Now merges the full financial ledger by stable IDs. Split bills stay on the phone.

1Your Android app

Primary financial ledger

2Your private Web app URL

The connection you deploy

3Your own Google Sheet

Transactions + Dashboard + hidden Sync Support

Optional sync. Split bills stay on the phone.
Copy Android Sheet ↗Open Android script ↗Separate iOS Sheet ↗Google’s Web app deployment reference ↗

Questions you might have.

Why did cleared report rows come back?

Transactions is rebuilt from stored sync data. Clearing report cells does not clear the financial ledger. Use the app’s deliberate history action for a fresh start; keep hidden Sync Support intact.

My new entries are not in the Sheet. What next?

Check the Web App URL ends in /exec and the current script is deployed as a new version. Test Connection, then Sync Now. A dashboard refresh alone does not send local entries.

Should iOS use this Android script?

No. The iOS Shortcut is a separate expense-to-Sheet workflow with its own template and script. Android accounts, the financial ledger and standalone splitter are not features of that Shortcut.