Balance Sheet and Net Worth Tracking in SavePoint
Net worth is the single number that best captures your financial progress: everything you own minus everything you owe. This guide shows how SavePoint builds your balance sheet from your accounts, tracks your net worth over time, and turns a scattered pile of assets and debts into one clear picture of your wealth. You will learn how to read the balance sheet, watch your trend line climb, and understand exactly what is driving the changes from month to month.
Your Balance Sheet is where you track all your accounts and their current balances to calculate your net worth. Think of it as your financial health report card - it shows what you own (assets) minus what you owe (debts) to give you your total net worth. Most people check this monthly to see if their wealth is growing and to spot any accounts that need attention.
The Balance Sheet page shows all your accounts organized by type (checking, savings, investments, loans, credit cards) with their current balances. SavePoint automatically calculates your net worth using the basic equation: Total Assets - Total Liabilities = Net Worth. The key is keeping your account balances updated so you get an accurate picture of your financial position. If you have a multi-person household configured, a member filter bar appears above the view-mode buttons so you can see one person's portion of net worth at a time; see Where Household Settings Apply for the full behavior.
📊 Balance Sheet View Modes
SavePoint offers different time views to help you track your wealth building progress:
- Current View: Shows today's account balances for your current financial position
- 3-Month View: Displays account balances over the past 3 months to see recent trends
- 6-Month View: Shows 6 months of balance history for mid-term trend analysis
- 12-Month View: Full year view to track long-term wealth building progress
- Current Year View: Shows balances from January to present for annual analysis
🏦 Account Organization
Your accounts are organized by type to match standard financial statements:
- Assets Section: All accounts that add to your wealth (checking, savings, investments, real estate)
- Liabilities Section: All accounts that reduce your wealth (credit cards, loans, mortgages)
- Account Display: Each account shows name and current balance (with currency indicator if different from base currency)
- Color Coding: Green for positive balances, red for negative balances
- Quick Actions: Click the Edit button (pencil icon) to open the Edit Account Balance screen where you can:
- Enter a new balance for any date
- View recent balance history with dates and amounts
- Delete individual balance entries (with permanent deletion warning)
- Delete the account's starting balance
- See currency conversion preview for multi-currency accounts
📈 Net Worth Tracking Charts
Visual charts help you understand your wealth building trends over time:
- Net Worth Trend Chart: Line chart showing your net worth progression over time. Higher values mean you're building wealth (assets growing faster than debts), lower values mean wealth is decreasing (debts growing or assets declining)
- Assets vs Liabilities Charts: Two separate pie charts showing the distribution of different types of assets (Checking, Savings, Investments, etc.) and different types of liabilities (Credit Cards, Loans, Mortgages, etc.). These help you see which account types make up most of your wealth or debt
- Account Category Charts: Pie charts showing your asset and liability distributions
- Interactive Features: Hover for exact amounts, click legend items to show/hide accounts
- Time Period Controls: Zoom in on specific time periods for detailed analysis
Keeping your Balance Sheet accurate requires regular updates and organization. SavePoint provides several tools to help you maintain up-to-date balance information and analyze your financial progress.
📅 Index Day Setting
The Index Day determines which day of the month SavePoint uses for balance snapshots:
- Default Setting: Day 1 (first day of each month) for monthly balance tracking
- Custom Options: Set to any day 1-31 based on your preference
- Common Choices: Day 15 (mid-month), day 1 (month start), or day 31 (month end)
- Usage Impact: This affects historical charts and trend analysis calculations
- Recommendation: Pick a day when you typically review finances and stick with it
💰 Balance Updates
Keep your balances current with multiple update methods:
- Manual Entry: Click "Edit Balance" to enter current account balance
- Bulk Import: Use CSV import to update multiple account balances at once
- Balance Sheet Entry Updates: Enter balances directly on the Balance Sheet page to track account values over time
- Date Stamping: Each balance update includes the date for historical tracking
- Notes on Balance Entries: Every balance entry has an optional Notes field. Use it to record context like "Statement balance" or "Includes pending charge" so you remember why a number looks the way it does. Notes appear as a column in Recent Balance History and the View All Balance History modal, and travel with CSV exports and imports.
- Currency Handling: Multi-currency accounts display in both native and base currencies
📤 Exporting Your Balance Sheet
The Export button opens a dropdown with two formats:
- Export as PDF: Generates a print-ready balance sheet report. Useful for sharing with a financial advisor, archiving a snapshot at month-end, or attaching to records.
- Export as CSV: Spreadsheet-compatible export of every daily balance entry. Includes account name, date, balance, and the Notes column so any annotations you added travel with the data.
Both exports respect the household member filter, so if you filter to a single member before exporting, only that member's accounts are included.
📊 Balance History Analysis
Access detailed balance history for any account from within the Edit Balance modal:
- Historical Table: Complete list of balance changes with dates and amounts
- Time Period Filters: Quick range presets (Current Month, Last 3 Months, Last 6 Months, Year to Date, Last Year, All Time) or custom date range
- Sorting Options: Sort by date (newest/oldest first) or amount (high/low)
- Bulk Operations: Select All to pick all entries, then delete selected or invert their sign
- Delete All Option: Remove all balance history for the account (with confirmation)
-
Access Balance Sheet
Open the Balance Sheet page to see your current account balances and net worth.
-
Set Your View Preferences
Choose your time period view: Current (single month), 3-Month, 6-Month, 12-Month, Current Year, or Last Year. For a wider view, collapse the navigation sidebar using the chevron icon (<) to see all columns for 12-month view.
-
Adjust Index Day (Optional)
Set which day of the month SavePoint uses for balance snapshots (default is Day 1). Choose a day that aligns with when you typically review finances.
-
Review Account Balances
Check each account balance against your actual bank/investment statements to identify any that need updating.
-
Update Outdated Balances
Click the Edit button for any account that needs updating. Enter the current balance from your statement.
-
Check Net Worth Trend
Review your net worth chart to see if you're building wealth. Look for upward trends over time.
-
Analyze Problem Areas
Identify accounts with concerning trends (declining savings, growing debt) and plan corrective actions.
When viewing 12-Month or multi-month views, collapse the navigation sidebar using the chevron icon (<) at the top left. This gives you maximum screen space to minimize horizontal scrolling when viewing all your balance columns.
Scenario: Mike tracks his wealth building progress using the Balance Sheet every month on the 15th.
Mike's Monthly Process:
- Set Index Day to 15: He chose the 15th because that's when he gets paid and reviews finances
- Update All Balances: Checks each account balance against online banking and investment statements
- Review Net Worth Chart: Looks at the 12-month view to see his wealth building progress
- Identify Trends: Notes which accounts are growing fastest and which need attention
Results After 8 Months:
- Net Worth Growth: Increased from $45,000 to $62,000 (38% growth)
- Savings Acceleration: Emergency fund grew from $5,000 to $12,000
- Debt Reduction: Credit card debt decreased from $3,200 to $800
- Investment Growth: 401k balance grew from $25,000 to $31,000
Key Insights Discovered:
- His net worth was growing faster in months when he received bonuses
- Investment growth was accelerating due to market gains and consistent contributions
- The visual charts motivated him to pay down debt faster
Result: Monthly balance sheet tracking helped Mike visualize his financial progress and stay motivated to continue building wealth.
Instead of manually entering each account balance every month, SavePoint can import balance data from CSV or Excel files. You can create your own tracking spreadsheet or download balance snapshots from some banks and investment institutions. The import system uses a 6-step wizard to map your data format to SavePoint fields, handle duplicates, and import balance history. Each import is tracked with a batch ID (date + filename) so you can review or undo specific imports later. This is especially useful for tracking multiple accounts over time or importing historical balance data to see your net worth progression.
📁 The 6-Step Import Process
SavePoint's import wizard guides you through these steps:
Step 1: Select File
Upload your CSV or Excel file (.csv, .xlsx, .xls). SavePoint will analyze the file structure and detect column headers.
- File Formats: Supports CSV, Excel (.xlsx), and older Excel (.xls)
- Required Columns: Account Name, Date, Balance (column names can vary - you'll map them in Step 2)
- Multi-Account Support: One file can contain balances for multiple accounts across multiple dates
- Template Download: Download a sample template from the wizard to see the correct format
- Drag & Drop: Simply drag your file into the import area or click to browse
- Date Formats: Automatically detects YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, and other common formats
The balance import is for account balances (snapshots of account values on specific dates). Do NOT use this for daily transactions - those belong on the Transactions page. Balance sheet tracks "what you have," transactions track "what comes in and out."
Step 2: Column Mapping
Tell SavePoint which columns in your file correspond to which balance fields. The wizard shows your column headers and lets you map them to SavePoint fields. Like the Transaction import, this step includes the Header Row selector for files where the column headers are not on the first row.
- Header Row Selector: If your file has extra rows above the actual column headers (disclaimer text, account information, blank rows, etc.), use the Header Row selector to indicate which row contains your column headers. You can cycle through each row and preview the header names directly within SavePoint, so there is no need to open and manually clean up the file before importing
- Account Name (Required): Map to your account name column (e.g., "Account", "Account Name", "Institution")
- Date (Required): Map to the date column for the balance snapshot
- Balance (Required): Map to the balance/amount column
- Notes (Optional): Map to a free-text column if your file has annotations like "Statement balance" or "Adjusted for pending transfer". SavePoint auto-detects common header names (notes, note, memo, description, comment). Leave unmapped if you do not need notes.
- Preview Table: Shows sample data with your mappings applied so you can verify it looks correct
- Date Validation: If SavePoint detects invalid dates, it will show Step 2.5 to help you fix date format issues
Step 3: Account Mapping
Map account names from your import file to existing SavePoint accounts or create new ones. SavePoint groups all balance entries by account name and shows you how many entries exist for each.
- Automatic Matching: SavePoint tries to match imported account names to existing accounts based on name similarity
- Manual Mapping: Each imported account shows a dropdown to map it to an existing SavePoint account
- Create New Accounts: Select "Create new account" to add accounts that don't exist yet in SavePoint
- Currency Detection: If your balance amounts include currency symbols ($, €, £), SavePoint auto-detects them and shows a currency preview
- Entry Count: Shows how many balance entries will be imported for each account
Step 3.5: Liability Convention (Conditional)
If you're importing liability accounts (credit cards, loans), SavePoint asks how your file represents debt balances. This step only appears if liability accounts are detected.
- Positive for Debt: Choose this if debts show as positive numbers (e.g., 5000 for $5,000 owed)
- Negative for Debt: Choose this if debts show as negative numbers (e.g., -5000 for $5,000 owed)
- Why This Matters: SavePoint needs to know whether +5000 means you owe money or have a credit - this varies by bank/tracking system
Step 4: Handle Duplicates
SavePoint compares your import to existing balance entries and flags potential duplicates. You decide which duplicates to skip or replace.
- Duplicate Detection: Finds balance entries with matching account and date in your existing data
- Side-by-Side Comparison: Shows the new balance next to existing balance so you can compare amounts
- Resolution Options: For each duplicate, choose to Skip (keep existing), Replace (use new value), or Import Both
- No Duplicates Message: If no duplicates are found, you'll see a success message and can continue
- Why This Matters: Prevents importing the same balance twice if you download overlapping date ranges
Step 5: Final Preview
Final review of all balance entries with all mappings and duplicate resolutions applied. This is your last check before importing.
- Summary Count: Shows total number of balance entries that will be imported
- Final Table: Shows all balances with account names, dates, and amounts
- Currency Display: Multi-currency balances show both native currency and base currency conversion
- Account Creation Notice: Lists any new accounts that will be created during import
- Ready to Import: Click "Import Balances" to add all balance data to your balance sheet, or "Previous" to make changes
Step 6: Import Progress
Watch the import progress as SavePoint processes your data. You can pause or cancel at any time.
- Progress Bar: Shows percentage complete and current operation being processed
- Two-Phase Import: First creates any new accounts, then imports all balance data
- Pause/Resume: Click Pause to temporarily stop the import; click Resume to continue
- Cancel Option: Click Cancel to stop the import (data imported so far is kept)
- Completion Summary: Shows how many balance entries were successfully imported and any errors encountered
- Prepare Your Data: Create a CSV with columns for Account Name, Date, and Balance. Include 6 months of history for 5 accounts
- Step 1: Upload file → SavePoint detects headers automatically
- Step 2: Map "Account" to Account Name, "Date" to Date, "Balance" to Balance → Preview looks good
- Step 3: Map imported accounts to existing SavePoint accounts → Create 2 new accounts that don't exist yet
- Step 3.5: Choose "Positive for Debt" (credit card balances show as positive numbers in file)
- Step 4: Skip 8 duplicates from previous manual entries → Replace 2 that have updated values
- Step 5: Review final count: 142 balance entries to import → Click "Import Balances"
- Step 6: Watch progress bar → Import completes successfully
Result: 142 balance entries imported for 5 accounts across 6 months, with 2 new accounts created and ready for net worth tracking.
The Balance Sheet page includes three charts that visualize your net worth trend and show how your assets and liabilities are distributed across different account types.
📈 Net Worth Trend Chart
Line chart showing your net worth over time:
- Timeline View: Shows net worth for each month based on your balance entries
- Time Period Selection: Choose 3 months, 6 months, 1 year, or current year view
- Hover Details: Hover over any point to see the exact net worth amount and date
- Trend Visualization: See if your net worth is increasing (higher values) or decreasing (lower values) over time
🏦 Asset Breakdown Chart
Pie chart showing how your assets are distributed across different account types:
- Account Type Grouping: Groups assets by account type (Checking, Savings, Investment, Retirement, etc.)
- Percentage Display: Shows what percentage of your total assets each account type represents
- Value Display: Displays the dollar amount for each account type
- Color Coding: Different colors for each asset category for easy identification
💳 Liability Breakdown Chart
Pie chart showing how your liabilities are distributed across different account types:
- Account Type Grouping: Groups liabilities by account type (Credit Card, Loan, Mortgage, etc.)
- Percentage Display: Shows what percentage of your total liabilities each account type represents
- Value Display: Displays the dollar amount for each liability type
- Debt Distribution: See which types of liabilities make up most of your total debt
Every time you update an account balance, SavePoint keeps a history of all previous balances. You can view, edit, or delete historical balance entries to maintain accurate records.
📅 Viewing Balance History
- Complete History: See all balance entries for an account with dates and amounts
- Search and Filter: Find specific balance entries by date range using the Start Date and End Date filters
- Import Batch Filter: Filter balance history entries by import batch. Each balance sheet import is tracked with a batch ID (date + filename), just like transaction imports. Use this to review or bulk-delete all balance entries from a specific import
- Import Batch Column: The full-screen Account Balance History view includes an "Import Batch" column showing which import each balance entry came from
- Auto-Apply Filters: The Start Date, End Date, Sort, and Import Batch filters auto-apply on change. There is no need to click an Apply button after making a selection - the results update immediately
- Sort Options: Sort by date, amount, or other criteria
- Export History: Download balance history as CSV for analysis
✏️ Editing Historical Balances
- Date Changes: Update the date of a balance entry
- Amount Corrections: In the Edit Balance screen, select a balance entry from the recent history list and change the amount
- Currency Updates: Change currency for multi-currency accounts
- Bulk Operations: Click "View all" in the Edit Balance screen to access the full history view where you can make changes to multiple entries
- Delete Entries: Remove incorrect or duplicate balance entries (this cannot be undone)
Scenario: Janet wants to track her family's net worth but doesn't want to manually enter balances for 12 accounts every month.
Janet's Solution:
- Created a Tracking Spreadsheet: Made a simple Excel file with columns for Account, Date, and Balance
- Monthly Data Collection: Once a month, she logs into each account and records the balance in her spreadsheet
- Quarterly Import: Every 3 months, she imports the spreadsheet into SavePoint to update her balance sheet
- Account Mapping Setup: First time she mapped "Wells Checking" to "Checking Account" in SavePoint, then it auto-maps each time
Results After 1 Year:
- Complete 12-month net worth history with minimal manual entry
- Discovered her net worth increased $23,000 over the year
- Charts showed their debt-to-asset ratio improved from 45% to 32%
- Import process takes 10 minutes quarterly vs. hours of manual entry
Result: The import system made net worth tracking sustainable and provided valuable insights into their financial progress.
Use the Balance Sheet view modes and charts to analyze your financial position. By comparing time periods and reviewing the composition of your assets and liabilities, you can track changes and identify trends.
📊 Time Period Comparison
Switch between different time period views to compare your balances:
- Current (Single Month): See the most recent balance for each account
- 3-Month View: Compare balances across three consecutive months
- 6-Month View: Track changes over a six-month period
- 12-Month View: See a full year of balance history for each account
- Current Year / Last Year: View all months for a specific year
🎯 Account Balance Tracking
Review your account balances to identify changes:
- Asset Totals: See total assets at the bottom of the Assets section
- Liability Totals: See total liabilities at the bottom of the Liabilities section
- Net Worth Display: Total assets minus total liabilities (shown at the top, and bottom of Net Worth section)
- Account-Level Changes: Compare individual account balances across months to see which accounts are growing or declining
- Category Distribution: Use the Asset and Liability pie charts to see which account types make up most of your totals
📈 Net Worth Trend Review
Use the net worth trend chart to track changes over time:
- Net Worth Progression: See if your net worth is increasing or decreasing month-to-month
- Growth Patterns: Identify periods of growth or decline in your net worth
- Time Period Selection: Choose 3-month, 6-month, 12-month, or current year view for different perspectives
- Specific Values: Hover over chart points to see exact net worth amounts for each month
-
Update All Account Balances
Enter current balances for all accounts by checking your latest account statements.
-
Review Net Worth Change
Compare this month's net worth to previous months using the 3-month or 6-month view.
-
Check the Net Worth Chart
Review the net worth trend chart to see the overall progression over time.
-
Review Account Changes
Switch to 12-month view to see which accounts have changed significantly over the year.
-
Review Distribution Charts
Check the Asset and Liability pie charts to see how your accounts are distributed across different types.
If you have accounts in different currencies (like EUR savings or GBP investment accounts), SavePoint automatically converts all balances to your base currency for consistent tracking and accurate net worth calculations.
💱 How Currency Conversion Works
- Base Currency Display: All account balances are shown in your base currency (set in Settings → Currency)
- Currency Indicator: Accounts in different currencies show their currency code next to the balance (e.g., "EUR", "GBP")
- Date-Aware Conversion: When you enter a balance, SavePoint uses the exchange rate from that specific date for accurate historical tracking
- Conversion Preview: The Edit Balance modal shows you the converted amount in your base currency as you enter the balance
- Fallback Handling: If exchange rates are unavailable for a date, SavePoint uses 1:1 conversion
📊 Multi-Currency Net Worth Calculations
Net worth calculations automatically account for currency differences:
- Historical Accuracy: Each balance entry uses the exchange rate from its date, so your net worth chart reflects true historical values
- Automatic Updates: When you add a balance for a multi-currency account, the conversion happens automatically
- Consistent Comparison: All accounts display in the same currency, making it easy to compare values across accounts
For more details on setting up currencies and exchange rates, see the Multi-Currency Support section in Settings.
Net worth tracking is more than just calculating assets minus liabilities. It's about understanding the story behind your numbers and using that insight to make better financial decisions. Your net worth trend reveals whether your financial strategies are working.
💰 Net Worth Components
Understanding what makes up your net worth helps you optimize it:
- Liquid Assets: Cash, checking, savings - money you can access immediately
- Investment Assets: Stocks, bonds, mutual funds - money that can grow over time
- Retirement Assets: 401k, IRA - money for your future self
- Fixed Assets: House, car - things you own that have value but aren't liquid
- Liabilities: Credit cards, loans, mortgage - money you owe others
📊 Net Worth Milestones
Common net worth milestones help you track your financial progress:
- $0 Net Worth: Breaking even - assets equal liabilities
- $10,000: First significant milestone for many people
- 1x Annual Income: Net worth equals one year of your salary
- $100,000: Six-figure milestone - wealth building accelerates here
- 25x Annual Expenses: Financial independence number (FIRE goal)
- $1,000,000: Millionaire status - traditional wealth benchmark
🎯 Optimizing Net Worth Growth
Strategies to accelerate your net worth building:
- Increase Income: Career advancement, side hustles, or skill development
- Reduce Expenses: Cut unnecessary spending to free up money for assets
- Pay Down Debt: Every dollar of debt eliminated increases net worth by one dollar
- Invest for Growth: Put money in assets that appreciate over time
- Track Regularly: Monthly tracking keeps you motivated and on course
- Automate Savings: Set up automatic transfers to build wealth without thinking about it
Scenario: Alex tracks net worth monthly to reach $100,000 by age 30.
Alex's Starting Point (Age 27):
- Assets: $25,000 (savings + 401k + car)
- Liabilities: $15,000 (student loans + credit card)
- Net Worth: $10,000
Monthly Tracking Strategy:
- Updated all account balances on the 1st of each month
- Analyzed 12-month trend to see if on track for goal
- Focused on debt reduction first (guaranteed return)
- Increased 401k contributions when debt was paid off
Results After 36 Months (Age 30):
- Assets: $125,000 (emergency fund + investments + 401k + car)
- Liabilities: $8,000 (just student loans remaining)
- Net Worth: $117,000 (exceeded goal!)
Key Success Factors:
- Consistent monthly tracking kept goal visible
- Debt reduction provided immediate net worth boost
- 12-month view helped identify when to adjust strategies
- Seeing progress motivated continued good habits
Result: Regular net worth tracking helped Alex exceed their financial goal by staying focused and making data-driven decisions.
Set a consistent monthly date for balance updates and stick to it - this creates reliable trend data. Use the 12-month view to spot seasonal patterns in your finances. Focus on the net worth trend line rather than monthly fluctuations - wealth building is a long-term process. If your net worth isn't growing over 6+ months, review your budget and spending to identify issues. The Balance Sheet import feature is perfect for quarterly reviews when you want to update all balances at once.
Your net worth calculation is only as accurate as your account balances - update them regularly. Include all significant assets and debts, even those you don't actively use. Investment account balances fluctuate daily, but monthly updates are sufficient for tracking long-term wealth building. Don't forget to include valuable assets like vehicles or real estate if they represent significant portions of your wealth.