Track Account Balances Over Time in Google Sheets
Every fetch records a snapshot of each account's balance by date. Build running totals, net worth trends, and cross-account dashboards in a spreadsheet you control.
BudgetSheet writes a new row to BSA_Balances for each linked account every time transactions are fetched, whether manually, via Sync, or through Autofetch. Each row includes the account name, balance, and fetch date. Credit and loan accounts also get available balance, credit limit, and utilization percentage. Sum across accounts by date to see your total net worth, or chart individual account trends over weeks and months.
Running totals across all accounts by date
Because every account gets a dated balance row on each import, you can pivot or formula your way to a consolidated view: total cash, total debt, net worth, or any grouping you define.
- New balance row per account on every fetch, giving you a historical record over time
- Checking, savings, credit cards, loans, and investment accounts supported
- Credit accounts include available balance, limit, and utilization %
- Combine with BSA_Transactions for a complete financial picture in one workbook
- Use pivot tables, charts, or the free BSAT_Dashboard template for visual summaries
Balances update automatically with Autofetch
Enable Autofetch and BSA_Balances grows every night without manual work. Pair balance history with transaction imports to answer questions like “what was my net worth on the first of each month?” or “how fast is my credit utilization changing?”
How It Works
- Step 1: Run Setup to create the BSA_Balances sheet (or it is created automatically on first fetch).
- Step 2: Link accounts and fetch transactions. Balances are recorded alongside each import.
- Step 3: Each run adds dated rows: Account, Balance, FetchDate, and credit-specific fields where applicable.
- Step 4: Build formulas, pivot tables, or charts, or install the BSAT_Dashboard template for a head start.
Frequently Asked Questions
- How do I get running totals across all accounts by date?
- BSA_Balances stores one row per account per fetch date. Use a pivot table grouped by FetchDate with Balance summed across accounts, or write a SUMIFS formula to total balances for a given date. Because each fetch adds rows, you build a time series automatically.
- When are balances updated?
- Balances are written every time you fetch or sync transactions, including Autofetch runs overnight. You can also trigger a balance-only update from the Accounts page in the BudgetSheet sidebar.
- Does balance tracking work for credit cards?
- Yes. Credit and loan accounts include Balance, BalanceAvailable, BalanceLimit, and utilization percentage so you can track debt and available credit over time.
- Can I chart net worth over time?
- Absolutely. BSA_Balances is a plain Google Sheet tab, so you can create a line chart of summed balances by FetchDate, or use the free BSAT_Dashboard template which includes a recent-balances summary.
Related Resources
Ready to import live banking data into Google Sheets? Install BudgetSheet and start your free 15-day trial. No credit card required.
Install BudgetSheet Addon
