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:

name
type
institution
balance
available_balance
balance_date

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)

  1. Download and extract BalVault.zip (from balvault.com/download)
  2. Run BalVaultStart.bat — it installs BalVault and opens its setup window
  3. Get your SimpleFIN Bridge setup token from bridge.simplefin.org ($1.50/month, billed by SimpleFIN — required for your SimpleFIN connection)
  4. Paste the token into BalVault's setup page and click Save
  5. BalVault validates the token and confirms how many accounts it found — press Enter to write your first accounts.csv
  6. 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.

  1. Open the .ots — Calc opens a new unsaved copy ("Untitled 1"), not the template itself
  2. Copy your budget into this file — the starter "budget" sheet shows where
  3. File → Save As → your budget file name (e.g. MyBudget.ods), anywhere you like
  4. 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

=accounts.D2 (Chase balance)
=SUM(accounts.D2:D10) (all balances)
=accounts.F3 (balance date)

Lookup by account name (rows may shift):

=VLOOKUP("Chase Checking";accounts.A:D;4;0)
=INDEX(accounts.D:D;MATCH("Chase Checking";accounts.A:A;0))
=SUMIF(accounts.A:A;"*Savings*";accounts.D:D)

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