Privacy & connections
Data handling
Understand how data reaches your spreadsheet, what Montley keeps, how optional Telegram delivery works, and what happens when you disconnect.
How your data is handled →
Montley Docs
Documentation
Learn how Montley works and find detailed information about its features.
Explore the docs
Google Sheets · Formula reference
Named ranges
Search all 68 supported ranges for Transactions, Accounts, Balance History, Categories, and optional investment tables. Find each field’s meaning, data type, and example value, then copy its name into your formula.
Browse named ranges →
Editing your spreadsheet
You can edit transaction descriptions, categories, and notes, and add your own columns and formulas. Sync preserves these inputs, including blank values. When your bank links a posted transaction to its pending entry, the existing row and your edits stay together. Bank removals mark the row as removed and retain your work.
Keep managed formulas and identity fields intact. Avoid sorting, moving, inserting, or deleting rows and columns while a sync is running. Montley checks row identities before writing, but a structural edit immediately after that check can still interfere with the update. Use a filter view for a different view of your data, and run Sheet Doctor after structural changes. Doctor checks supported workbook rules; it does not certify that every historical transaction is present.
Looking for a walkthrough?
Explore our guides for practical tutorials and workflow advice.