BALVAULT
Spreadsheet Guide
The whole guide is the part that makes an accounts spreadsheet update: install, connect SimpleFIN, open the template — the accounts sheet fills itself.
Last updated: November 2026 • BalVault v2.1.63 (Windows)
1What you get
BalVault writes your account balances to a local CSV file, by default Documents\BalVault\accounts.csv. Six columns:
Bank, credit card, loan, retirement, utility, insurance, online money services — whatever SimpleFIN can report, BalVault fetches. The template's "accounts" sheet is linked to that file and fills itself: BalVault fetches from SimpleFIN when the app is called from your macro (max once per hour) or manually within the app UI. Free = 2 accounts forever; a licence writes every account SimpleFIN reports. An account that cannot update says so in its row — cannot update, check simplefin — sign in at bridge.simplefin.org to fix it. The CSV's last line is one status row for the fetch that wrote the file.
2Setup (once)
- Download and extract
BalVault.zip(from balvault.com/download) - Run
BalVaultStart.bat— it installs BalVault and opens its setup window - Get your SimpleFIN Bridge setup token from bridge.simplefin.org ($1.50/month, billed by SimpleFIN — required for your SimpleFIN connection)
- Paste the token into BalVault's setup page and click Save
- BalVault validates the token and confirms how many accounts it found — press Enter to write your first accounts.csv
- Optional: press F to change the CSV location (keep it on a local drive)
3Your accounts spreadsheet (the template)
Open Documents\BalVault\BalVault-Template.ots in LibreOffice Calc — the refresh macro, the Open Document binding and the linked "accounts" sheet are already inside it, and a starter "budget" sheet shows where your own budget goes.
- Open the .ots — Calc opens a new unsaved copy ("Untitled 1"), not the template itself
- Copy your budget into this file — the starter "budget" sheet shows where
- File → Save As → your budget file name (e.g.
MyBudget.ods), anywhere you like - Done — opening the file refills the "accounts" sheet from accounts.csv and fetches from SimpleFIN when your macro calls the app, at most once per hour (section 1); if the sheet ever does not fill itself, press the Refresh balances button on the budget sheet
If Calc asks about the link when opening: Tools → Options → LibreOffice Calc → General → "Update links when opening" → Always (from trusted locations). Set once, per user.
If Calc shows the "Macros disabled" bar (it has no run button — that is normal at High security): Tools → Options → LibreOffice → Security → Macro Security → Trusted Sources → Trusted File Locations → Add both the folder holding the template (Documents\BalVault) and the folder you save your budget file into, then close and reopen — the first open never runs the macro, every open after that does, and the Refresh balances button works after trust.
4An existing spreadsheet of your own
Live link, no macro: Sheet → Link to External Data, browse to accounts.csv, check "Link", OK. Refresh by hand after a fetch: Edit → Links to External Files → Update.
Want the auto-refresh macro in your own file? Every import step is in BalVaultRefresh-README.txt, shipped next to accounts.csv.
5Formulas
Lookup by account name (rows may shift):
6Other apps
Excel: Data → Get Data → From Text/CSV → Load; refresh with Data → Refresh All.
Google Sheets: File → Import uploads a copy of your balances to Google — there is no live link to a local file.
Anything else: open accounts.csv directly — it is plain text.
More app support is coming. Sign up for the newsletter at balvault.com/blog, or visit balvault.com for what's current.
7Privacy
Your SimpleFIN token is encrypted on your PC with Windows DPAPI; your balances stay in the local database and the CSV, which is a plain text file that stays on the PC. For maximum privacy, we suggest keeping accounts.csv in a folder that isn't synced to the cloud (Drive, OneDrive, iCloud, Dropbox).
8Support
Need help? balvault.com/support