Transactions in SavePoint
Transactions are the day to day heartbeat of your finances, and SavePoint makes them fast to enter and easy to keep tidy. This guide covers entering transactions by hand, splitting a single purchase across multiple categories, using the category system, and filtering and managing your history so nothing slips through. You will also see how importing from your bank fits in. Keep this part accurate and every budget, report, and net worth figure downstream will tell the true story.
The Transaction page is where you enter every purchase, payment, and income you receive. Think of it as your financial journal - every time money comes in or goes out of your accounts, you record it here. SavePoint then uses these entries to create your budgets, reports, and track your financial progress. We recommend entering transactions at least once a month, either manually or by importing bank statements.
When you enter a transaction, you're telling SavePoint what happened with your money. Each transaction needs several basic pieces of information: how much money, which account it came from (or went to), what type it was, when it happened, and what category it belongs to. Let's break down each part and what it means.
đ° Understanding Transaction Types
The "type" tells SavePoint whether money came in or went out, and helps it calculate your totals correctly:
- Income: Money that came INTO your account - your salary, freelance payments, gifts, refunds, or investment dividends. These show up as positive (green) numbers and increase your account balance.
- Expense: Money you SPENT - groceries, gas, bills, subscriptions, or any purchase. These show up as negative (red) numbers and decrease your account balance.
- Transfer: Money you moved from one of your accounts to another - like transferring from checking to savings. This doesn't change your total wealth, just moves money around.
- Payment: When you pay your credit card bill - this doesn't change your total wealth because you're paying off debt you already owe. Your checking account goes down, but your credit card debt also goes down by the same amount.
Transactions are used to track net cashflow (money in and out). Your wealth is calculated separately in the Balance Sheet module, which looks at account balances over time. These are separate systems in SavePoint - transactions show movement, balance sheets show total value.
Got money? Choose Income. Your account balance goes up.
Spent money? Choose Expense. Your account balance goes down.
Moved money between your own accounts? Choose Transfer. Total wealth stays the same (and we don't consider this an income or expense; but you may consider adding this in your balance sheet).
Paying your credit card bill? Choose Payment. Your account balance goes down, your credit card debt goes down - net worth stays the same (this is tracked in your balance sheet, not as cashflow).
đ What Information Do I Need to Enter?
When you add a transaction, SavePoint shows you a form with several fields. Here's what each one means and whether you need to fill it out:
- Amount (Required): How much money - just enter the number, SavePoint figures out if it's positive or negative based on the type
- Account (Required): Which bank account, credit card, or cash account this affects - choose from your list
- Date (Required): When this happened - SavePoint fills in today's date, but you can change it
- Description (Required): What this was for - "Grocery store," "Salary deposit," "Coffee," etc.
- Category (Required): What type of expense or income - helps with budgeting and reports
- Currency (Optional): The currency for this transaction - defaults to your account's currency if not specified
- Payee (Optional): Who you paid or who paid you - "SuperMart," "MyCompany Inc," "Mom," etc.
- Check Number (Optional): If you wrote a check, put the check number here
- Notes (Optional): Any extra details you want to remember about this transaction
Minimum needed: Amount, Account, Date, Description, and Category.
For better tracking: Add Payee, Check Number, and Notes for more detailed records.
For business use: Fill out all fields including Notes for tax records and audit trails.
Scenario: Sarah just bought groceries at SuperMart for $127.83 using her checking account. Here's how she enters it in SavePoint:
Step-by-Step Process:
- Click "Add Transaction" - Found on the Transaction page or in the sidebar
- Choose Type - "Expense" since she spent money
- Enter Amount - "127.83" (just the number, SavePoint makes it negative automatically)
- Pick Account - "Checking Account" from the dropdown
- Enter Description - "SuperMart grocery shopping"
- Choose Category - "Groceries" (required field)
- Add Payee - "SuperMart" (optional but helpful for tracking)
- Click Save - SavePoint records the transaction
What Happens Next:
- Her monthly expenses increase by $127.83
- The transaction appears in her transaction list
- Her monthly grocery budget shows she's spent $127.83
- The transaction counts toward her monthly expense totals
Remember: Transactions track cashflow (money in and out), NOT account balances. If Sarah wants this expense reflected in her net worth, she needs to update her checking account balance on the Balance Sheet page. See Balance Sheet & Net Worth section for how to track account balances over time.
Result: Sarah now has an accurate record of her grocery spending that will help her track her budget and see spending patterns over time.
Sometimes a single purchase spans multiple budget categories. A $150 trip to a wholesale store might include $60 in groceries, $50 in household supplies, $25 in food, and $15 in personal care. Previously, you would need to assign the entire transaction to a single category, which means your budget and spending reports would not accurately reflect where the money went. With split transactions, you can break any income or expense transaction across as many categories as you need, and each split amount flows through correctly to your Budget, Dashboard, Cashflow, Reports, Yearly Trends, and FIRE calculations automatically.
âī¸ How to Split a Transaction
There are two ways to split a transaction: from the transaction table using the split button, or inline when adding or editing a transaction.
Method 1: Split Button (Transaction Table)
- Find the transaction you want to split in the transaction table
- Click the split button (branch icon) in the actions column for that transaction
- The Split Transaction modal opens, showing the transaction summary (description, account, date, type, and amount) at the top
Method 2: Inline Split (Add or Edit Transaction Modal)
- Open the Add Transaction or Edit Transaction modal
- Click "Split this transaction" (branch icon button) to activate the inline split editor
- The single category dropdown is replaced with the inline split editor where you can add multiple category rows
- To turn off split mode, click the button again. If you have split data entered, SavePoint will ask you to confirm before discarding the split rows
đ§ Using the Split Editor
Whether you use the split modal or the inline editor, the controls work the same way:
- Split Rows: Each row represents one portion of the split. You need at least two rows. Each row has a category dropdown, an amount field, a percentage field, and optional notes
- Dollar/Percent Mode: Each row can independently be set to dollar mode or percent mode using the per-row toggle button. In dollar mode, you enter a fixed amount. In percent mode, you enter a percentage and SavePoint calculates the dollar amount. You can also use the "Set All $" or "Set All %" buttons at the top to switch all rows at once
- Amount Adjustments: Each amount and percentage field has +/- buttons for fine-tuning values by $1 or 1% increments
- Progress Bar: A visual progress bar shows how much of the transaction total has been allocated. It displays green when you reach exactly 100%, yellow while you are still allocating, and red if you go over 100%
- Remaining Amount: A "Remaining" badge shows how much of the transaction total is still unallocated. The badge turns green when the remaining amount reaches $0.00
- Reorder Rows: Use the up/down arrow buttons on each row to change the order of your splits
- Per-Split Notes: Click the sticky note icon on any row to expand a notes field for that split. The icon changes color when notes are present
- Add Split: Click "Add Split" to add another row. There is no limit on the number of splits
- Delete Row: Click the X button on any row to remove it (minimum of two rows required)
⥠Even Split
The Even Split button distributes the transaction total equally across your split rows:
- With categories already assigned: Click "Even Split" and the total is divided equally among the existing rows. If the amount does not divide evenly, the remainder pennies are assigned to the first row(s). For example, splitting $100 three ways produces $33.34, $33.33, and $33.33
- Without categories: Click "Even Split" and an inline count picker appears, asking "Split into how many?" Enter the number of rows you want (minimum 2, maximum 50) and SavePoint creates that many rows with equal amounts
đž Saving Splits
The "Save Splits" button is only enabled when all of the following conditions are met:
- All rows have a category selected
- All rows have an amount greater than zero
- The total allocation equals 100% (remaining amount is $0.00)
- At least two rows exist
If any of these conditions are not met when saving a transaction with inline splits, SavePoint displays a specific error message explaining what needs to be corrected (for example, "Split amounts must equal the transaction total" or "All split rows must have a category selected").
đī¸ Viewing Split Transactions
Split transactions are easy to identify and explore in the transaction table:
- Split Badge: Split transactions display a blue "Split" badge (with a branch icon) in the category column instead of a single category name
- Expandable Sub-Rows: Click the chevron arrow next to the Split badge to expand the transaction and see each split as an indented sub-row. Each sub-row shows the split's category emoji, category name, and amount
- Collapse: Click the chevron again to collapse the sub-rows
âŠī¸ Removing a Split (Unsplit)
If you want to revert a split transaction back to a single-category transaction:
- Open the split modal for the transaction (click the split button in the actions column)
- Click "Unsplit" to open the Remove Split modal
- Choose which category to keep: A dropdown shows all the categories from your splits, each with its emoji, name, and amount. Select the one you want the transaction to revert to
- Click "Remove Split" to confirm. All split data is removed, and the transaction is assigned to the category you selected
đ How Splits Affect Reports and Other Features
Split amounts flow through to all areas of SavePoint that use category-based calculations:
- Budget: Each split's amount counts toward the budget for that split's category. A $150 transaction split between Groceries ($60) and Household ($50) adds $60 to your Groceries budget actuals and $50 to your Household budget actuals
- Cashflow Center: Split amounts appear under their respective categories in the monthly cashflow tables and drilldowns
- Dashboard: Category distribution charts reflect the split amounts, not the parent transaction's original single category
- Reports: All category-based reports use the split amounts for accurate breakdowns
- Yearly Trends: Split amounts are aggregated per category in the yearly table
- FIRE Calculations: Split amounts are used for expense and savings calculations
- Goals: If you have goal rules that match a split's category, the split amount (not the full parent amount) is used for the goal allocation. If multiple splits match different goal rules, each goal receives only its matching split amount
- Category Filter: Filtering transactions by category will find split transactions where any split matches the selected category, not just the parent transaction's original category
- Excel/CSV Export: Split transactions are exported as multiple rows (one per split) with "Split" (Y/N) and "Split Group" columns for identification
- Per-split Owner (Advanced household mode): When household mode is Advanced, each split row gets its own Owner dropdown so you can record "Sarah paid the $120 personal portion, Tom paid the $80 business portion" inside a single transaction. If the splits have different owners, the parent transaction is automatically marked Shared.
- Per-split Tags: Each split row can carry its own tags independent of the parent transaction. This is what lets you split one $200 charge into "$120 with General tag Discretionary / Wants" and "$80 with Business tag Client Billable" without having the tags conflict at the transaction level. See Tags & Tagging System for the broader tagging concept.
Scenario: Rachel buys $187.42 worth of items at a wholesale store. The receipt includes groceries, household cleaning supplies, personal care items, and a case of water bottles for an upcoming event.
Step-by-Step Process:
- Add the transaction: Rachel enters the $187.42 expense and clicks "Split this transaction" in the Add Transaction modal
- Add split rows: She adds 4 rows and assigns each a category:
- Groceries: $78.50
- Household: $52.30
- Personal Care: $31.62
- Entertainment: $25.00 (water bottles for the event)
- Verify: The progress bar shows 100% and the remaining amount is $0.00
- Save: Rachel saves the transaction
What Happens Next:
- Her Groceries budget shows $78.50 of spending (not the full $187.42)
- Her Household budget shows $52.30
- The transaction table shows a "Split" badge she can click to see all four categories
- Her category distribution chart on the Dashboard accurately reflects where the money actually went
- If she exports to Excel, the transaction appears as four separate rows with a "Split Group" column linking them together
Result: Instead of all $187.42 showing up under a single category, Rachel's budget and reports now accurately reflect her actual spending across four categories, giving her a much more honest picture of where her money goes.
Categories are how you organize your transactions to understand where your money goes. Instead of just seeing "spent $50 at Store," categories let you see "spent $50 on Groceries." This helps you track your spending patterns, create accurate budgets, and spot areas where you might be overspending.
Categories are set up on the Budget page. To add a new one: Budget page â Expense Budget â "Add Expense Category" â "Create new category" (or Income Plan â "Add Income Source" for income). Name it, set its subcategories, and it becomes available to assign to any transaction. For the full walkthrough, including using subcategories to group your spending, see the Budget System section.
đ How Categories Work
Every transaction gets assigned to a category so SavePoint knows what type of spending it represents. SavePoint uses a three-level categorization system: main category, Subcategory 1, and Subcategory 2.
Main Category (Required)
The primary type of transaction - what you actually spent money on or where income came from:
- Income Categories: Types of money coming in like "Salary," "Freelance," "Investment Income," or "Tax Refund"
- Expense Categories: Types of spending like "Groceries," "Rent," "Utilities," "Entertainment," or "Transportation"
- Transfer Categories: Moving money between your own accounts - doesn't affect your budget since it's not real spending
Subcategory 1 (Optional) - Needs vs Discretionary
We recommend using this to categorize your spending as "Discretionary" (wants) or "Needs" (essential expenses). This helps you see if your actual spending aligns with financial guidelines like the 50/30/20 rule (50% needs, 30% discretionary, 20% savings). SavePoint shows you these percentages in budget reports:
- Needs: Essential expenses you must pay - rent, groceries, utilities, insurance, minimum debt payments. These keep your life running
- Discretionary: Non-essential spending you choose to do - dining out, entertainment, hobbies, subscriptions. You could cut these if needed
Subcategory 2 (Optional) - Life Area Analysis
Use this for more granular analysis across different areas of your life:
- Purpose Categories: Group by life area like "Food," "Living," "Medical," "Transportation," "Entertainment," "Personal," or "Financial"
- Cross-Category Analysis: Track total spending on "Food" even when it comes from multiple categories (Groceries + Dining Out + Coffee)
- Why This Helps: You might realize total "Food" spending is 40% of your budget, even though no single category looked too high
Example: "Groceries" might be main category with "Needs" for Subcategory 1 and "Food" for Subcategory 2. "Dining Out" would be main category with "Discretionary" for Subcategory 1 and "Food" for Subcategory 2. This way you can see spending patterns across broader life areas.
Tracking by property, vehicle, or project. Subcategory 2 is just as useful for grouping costs by something you own (a boat, a vacation home, a car) as by life area. Two facts shape how you set this up: each category is its own budget line, and a transaction takes its subcategories from whatever category you assign it - so the category is the smallest thing that shows on its own, and Subcategory 2 groups across categories. To see each cost and a per-property total, give every cost its own category and tag them with the same Subcategory 2. For example, create Rental Utilities, Rental Property Tax, and Rental Insurance as separate categories, each with Subcategory 2 = "Rental Property" (use "Other (specify)" to type it). Each then appears as its own line in your budget, and on the Transactions page you can filter by Subcategory 2 = "Rental Property" to see everything that property costs in one place. If instead you only want a single number per property with no breakdown, just make one category named for the property (for example "Rental Property") and put all of its spending there.
Transaction 1: $45 at SuperMart for groceries
Main Category: "Groceries" | Subcategory 1: "Needs" | Subcategory 2: "Food"
Transaction 2: $60 at restaurant for dinner with friends
Main Category: "Dining Out" | Subcategory 1: "Discretionary" | Subcategory 2: "Food"
Result: You can see you spent $45 on groceries and $60 dining out separately, BUT also see total "Food" spending of $105. You can also see $45 was "Needs" and $60 was "Discretionary."
đ¯ Setting Up Good Categories
The key is creating categories that match how you think about money and that you'll actually use:
- Start Broad: Begin with major categories like "Food," "Housing," "Transportation," "Entertainment"
- Add Detail Later: If "Food" becomes a large expense, break it into "Groceries," "Dining Out," "Coffee"
- Match Your Budget: Categories should align with how you plan to budget - if you budget for "Utilities," use "Utilities" as a category
- Be Consistent: Always categorize similar expenses the same way - all grocery stores go to "Groceries," all restaurants to "Dining Out"
- Avoid Too Many: 15-25 categories is plenty for most people - too many makes it overwhelming to categorize transactions
âī¸ Assigning Categories to Transactions
SavePoint offers several ways to categorize your transactions efficiently:
- During Entry: Choose the category when you first enter each transaction
- Bulk Categorization: Select multiple similar transactions and assign them all the same category at once
- Auto-Categorization Rules: Set up rules in Settings â Merchant Mapping so transactions from specific merchants automatically get categorized
- Import Categorization: Categories can be assigned during the CSV import process
- Auto Categorization (Import Only): During import, SavePoint suggests categories based on merchant mapping patterns or your prior transaction history for similar vendors
- Quick Edit Mode: Rapidly categorize many transactions in sequence
-
Review Your Spending
Look at 2-3 months of bank statements to see what types of expenses you actually have. This helps you create realistic categories.
-
Create Major Categories First
Start with broad categories that represent your biggest spending areas: Housing, Food, Transportation, Entertainment, etc.
-
Test Your Categories
Categorize a few weeks of transactions to see if your categories make sense. Adjust as needed.
-
Add Subcategories for Large Expenses
If any category represents more than 10% of your spending, consider breaking it into subcategories for better tracking.
-
Set Up Auto-Categorization
Once you know how you categorize different merchants, create rules so SavePoint automatically categorizes future transactions from those places.
Scenario: Maria is setting up categories for the first time and wants a system that will help her budget and track spending effectively.
Maria's Category Structure:
- Income Categories: Salary, Freelance Work, Tax Refund
- Fixed Expenses: Rent, Car Payment, Insurance, Phone
- Variable Expenses: Groceries, Dining Out, Gas, Entertainment, Clothing, Personal Care
- Savings & Investments: Emergency Fund Transfer, 401k, IRA
Auto-Categorization Rules She Created (set up in Settings â Merchant Mapping):
- Groceries: Fresh Foods â Groceries, QuickMart â Groceries, MegaStore â Groceries
- Dining Out: Burger Spot â Dining Out, Coffee Corner â Dining Out
- Gas: Gas-N-Go â Gas, Fuel Plus â Gas, Quick Fill â Gas
- Utilities: City Power â Utilities, FastNet â Utilities
Results After 6 Months:
- 90% of transactions automatically categorized correctly
- Discovered she spent $400/month dining out (much more than she realized)
- Used category data to create a realistic budget based on actual spending patterns
- Reduced dining out spending by $150/month by tracking it through categories
Result: A well-designed category system helped Maria understand her spending patterns and make informed decisions about her budget.
Don't create categories for expenses that happen less than once a month - put them in "Miscellaneous" instead. Use descriptive names that you'll remember - "Car Stuff" is better than "Transportation-Vehicle-Related" if that's how you think about it. Set up auto-categorization rules for your 10 most common merchants first - this will handle 80% of your transactions automatically. Review your categories after 3 months and consolidate any that are similar or rarely used.
Once you have transactions in SavePoint, you need ways to find specific ones, see only certain types, or edit multiple ones at once. The Transaction page has several tools to help you organize and work with your financial data efficiently.
Filtering lets you see only the transactions you're interested in. For example, you might want to see only your grocery spending from last month, or just transactions from your checking account. Here are the main ways to filter your transactions:
đ Time Period Filters
Choose what time period you want to see:
- Current Month: Only transactions from this month, great for tracking current spending
- Last Week: The most recent complete calendar week (Monday through Sunday)
- Last Month: Previous calendar month only, helpful for reviewing completed months
- Last 3 Months: Shows recent spending patterns without going too far back
- Last 6 Months: Good for seasonal analysis or quarterly reviews
- Last Year: The previous full calendar year (January 1 to December 31 of last year)
- This Year: The current calendar year, January 1 to December 31 of this year
- Year to Date: The current year so far, January 1 of this year through today. This is the usual choice for "how am I doing this year?"
- Custom Dates: Pick any start and end date you want
- All Time: Every transaction you've ever entered, can be slow if you have lots of data
Current Month: Daily budget tracking and spending awareness
Last Month: Monthly review, comparing to budget, preparing reports
Last 3-6 Months: Identifying spending trends, seasonal patterns
Year to Date vs. This Year: Use Year to Date for a running total of the current year up to today; use This Year when you want the whole year including future-dated entries, and Last Year for the previous year's full total
Custom Dates: Tax season, specific project tracking, vacation expenses
đĻ Account, Category, and Import Batch Filters
Focus on specific accounts, spending categories, or imports:
- Account Filter: See transactions from just one account - helpful for reconciling bank statements
- Category Filter: Show only certain types of spending like "Groceries" or "Entertainment." This filter also finds split transactions where any split matches the selected category
- Transaction Type: Show only Income, only Expenses, only Transfers, or only Payments. There is also an Income & Expense option that shows income and expenses together while hiding Transfers and Payments, which is the usual view for reviewing what you actually earned and spent without internal money movements between your own accounts
- Import Batch Filter: Filter transactions to a specific import batch. Each import is tracked with a batch ID that includes the date and original filename (e.g., "2026-03-17_Chase-Checking.csv"). Use this to review, verify, or bulk-delete all transactions from a particular import. The dropdown auto-refreshes after deleting transactions, so empty batches disappear automatically
Budgeting: Current Month + specific Category (like "Dining Out")
Bank Reconciliation: Specific Account + Current Month
Expense Analysis: Expense Type + Last 3 Months + specific Category
đ Using the Search Box
The quickest way to find specific transactions:
- Type any keyword - like "grocery store," "coffee," or "gas"
- Search happens instantly as you type
- Finds partial matches - typing "groc" will find "grocery store"
- Not case sensitive - "COFFEE" and "coffee" both work
- Searches everywhere - descriptions, payees, notes, even account names
Find gas purchases: Search "gas station" or "fuel" or "gas"
Find coffee spending: Search "coffee shop" or "coffee" or "cafe"
Find a specific amount: Search "127.50" to find that exact transaction
Find transfers: Search "transfer" or the account name you transferred to
Sometimes you need to change, categorize, or delete several transactions at once. SavePoint lets you select multiple transactions and perform actions on all of them together, which saves a lot of time compared to editing each one individually.
â How to Select Multiple Transactions
When you want to change or delete several transactions at once, you first need to enable Edit Mode, then select them:
- Enable Edit Mode: Click the "Edit Mode" button to activate selection checkboxes on all transactions
- Select Individual Transactions: Click the checkbox next to each transaction you want to work with
- Select All Visible: Use the "Select All" checkbox at the top to choose all transactions you can see
- See How Many Selected: SavePoint shows you "X transactions selected" so you know how many you've chosen
- Keep Selections: Your selected transactions stay selected even if you change pages or filters
Want to select similar transactions? Use filters first to narrow down, then "Select All"
Need to see all your selections? Look for the selection counter - it tells you how many you've picked
đī¸ Deleting Multiple Transactions
Once you have transactions selected, you can delete them all at once:
- Select the transactions you want to delete (use the checkboxes)
- Click "Delete Selected" - SavePoint will ask you to confirm
- Confirm the deletion - SavePoint shows you how many will be deleted
- Account balances update automatically to reflect the deleted transactions
Duplicate imports: When you accidentally import the same transactions twice
Test data cleanup: Removing practice transactions when you're learning
Unwanted transactions: Clearing out transactions that don't belong
âī¸ Edit Mode - Change Multiple Transactions Quickly
Edit Mode lets you change multiple transactions directly in the table without opening each one individually:
- Click "Edit Mode" to turn the table into an editing view
- Click in any cell to change things like category, description, or account
- Use dropdowns that appear for categories and accounts
- Press "Save All Changes" when you're done editing
- SavePoint updates everything and recalculates your account balances
Categorizing imports: After importing bank data, quickly assign categories
Fixing mistakes: Correct multiple transactions that have wrong accounts
Bulk updates: Edit individual transactions in table view (changing categories, accounts, etc.) and then save all changes at once
â¨ī¸ Edit Mode Keyboard Shortcuts
Edit Mode supports keyboard shortcuts that work regardless of Caps Lock state or whether Shift is held down. The two main shortcuts:
- Ctrl+S: Save changes. Works with Caps Lock on or off, with or without Shift.
- Ctrl+A: Behaves differently based on context. In an empty field, a single press adds a new row immediately. In a field containing text, the first press triggers the browser's native select-all (so you can replace the cell's value); a second Ctrl+A within about 600 milliseconds adds a new row.
đ§š Reset All Filters
Clicking "Reset All Filters" clears every filter at once, including Owner and Tag filters (which earlier versions left intact after a reset). Use this when you have narrowed the view several times and want a clean slate back to "all transactions, all the time".
đ "Assign them" Banner from Budget
When you click "Assign them" on Budget's unassigned-transactions banner and arrive at Transactions, SavePoint may show a contextual banner at the top: "Showing unassigned transactions, but your saved filters ({{filters}}) are still narrowing the view." with a "Show all unassigned" link. The banner only appears when you have saved filters like Category, Sub Category, or Type that would hide some unassigned transactions from the list. Clicking "Show all unassigned" clears the narrowing filters but keeps Owner set to Unassigned. The banner auto-dismisses when you change the Owner filter away from Unassigned.
đĨ Household-Aware Transactions
When Household Mode is enabled, the Transactions page gains several member-aware controls:
- Owner column on the table: A column showing each transaction's owner (a member name, Shared, or Unassigned). Hidden in Solo mode.
- Owner filter dropdown: Narrows the list to a specific member, Shared, or Unassigned. Combine with other filters (date, category, account, amount) to scope tightly.
- Default Owner on new transactions: If you have set a default household member in Settings > Household, new transactions pre-fill that member as the Owner. You can override on each transaction.
- Owner dropdown in the Add / Edit modal: Pick a member, Shared, or Unassigned when entering a transaction.
- Per-split member assignment in Advanced mode: Each split row gets its own Owner dropdown. If splits have different owners, the parent transaction is automatically marked Shared so the overall ownership stays consistent.
All of these controls are hidden in Solo mode. See Household & Members for the underlying concepts.
Scenario: Mike imported 3 months of bank statements but now needs to categorize 150 transactions and fix some that have the wrong account.
Step-by-Step Process:
- Filter to Uncategorized: Choose "Uncategorized" in the Category filter to see only transactions that need categories
- Turn on Edit Mode: Click "Edit Mode" button to make the table editable
- Categorize Transactions: Click in the Category column for each transaction and assign categories like "Groceries," "Gas," "Utilities" - Edit Mode lets you quickly move through transactions one by one
- Fix Account Errors: Change a few transactions that were imported to the wrong account
- Save All Changes: Click "Save Changes" to update all the transactions at once
What He Accomplished:
- Categorized 150 transactions in about 20 minutes
- Fixed account assignments for 12 transactions
- Can now run accurate budget and spending reports
- All account balances automatically updated
Result: Mike turned messy imported data into clean, categorized transactions ready for budgeting and analysis, saving hours compared to editing each transaction individually.
SavePoint handles transaction currencies automatically. When you enter or import a transaction, the currency defaults to your account's currency or your base currency. If you have transactions in multiple currencies, SavePoint converts everything to your base currency for display while preserving the original transaction currency.
đą How Transaction Currency Works
- Default Currency: New transactions use your account's currency by default (or base currency if account has no currency set)
- Multi-Currency Display: If a transaction is in a different currency than your base currency, it shows both - the original amount (e.g., "âŦ50.00") and the converted amount (e.g., "â $55.00")
- Conversion Rates: Uses exchange rates from your Multi-Currency settings. If no rate exists for the transaction date, uses 1:1 conversion
- Reports and Summaries: All currency amounts are converted to your base currency for accurate totals and charts
For full multi-currency functionality including exchange rate management, automatic conversions, and historical rates, see the Multi-Currency Support section of this help guide.
SavePoint can import transactions from CSV, Excel, QIF, QFX, and OFX files downloaded from your bank, credit card company, or other financial institutions. CSV and Excel imports cover standard spreadsheet exports, while QIF (Quicken Interchange Format) handles exports from Quicken and similar software, and QFX/OFX files are the bank-downloaded statement format used by most financial institutions for direct download. The import system uses a 9-step wizard to map your bank's data format to SavePoint fields, handle currencies, detect duplicates, and categorize transactions. For QIF and QFX/OFX files, some steps are handled automatically (such as amount direction, since these formats include pre-signed amounts). This section explains each step in detail.
đ Getting Transaction Files from Your Bank
Before importing, you need to download transaction data from your bank. SavePoint supports multiple file formats:
- CSV (.csv): The most common export format. Most banks offer this under "Export," "Download," or "Statements" options. Some banks call it "Excel," "Spreadsheet," or "Comma Separated"
- Excel (.xlsx, .xls): Some banks provide Excel files directly. SavePoint handles both modern (.xlsx) and older (.xls) Excel formats
- QIF (.qif): Quicken Interchange Format. Used by Quicken and other financial software for exporting transaction data. Supports transactions, categories, split transactions, transfers, check numbers, cleared status, and memo fields. Multi-account QIF files are detected automatically so all accounts can be imported in a single pass
- QFX (.qfx) / OFX (.ofx): Bank-downloaded statement files used by most financial institutions for direct download. QFX is the Quicken-specific variant of OFX. SavePoint parses both OFX 1.x (SGML) and 2.x (XML) formats. These files include a unique transaction ID (FITID) from your bank, which SavePoint uses for stronger duplicate detection than date-and-amount matching alone
To get started:
- Log into your online banking and find "Export," "Download," or "Statements" options
- Choose your preferred format - CSV is the most universal, but QFX/OFX files provide stronger duplicate detection
- Select your date range - start with one month to test the import process
- Download the file to your computer
- Open SavePoint and go to Transactions â Import to start the wizard
Most Banks: Account Activity â Download/Export â CSV or QFX/OFX format
Credit Cards: Statements or Activity â Download Transactions â CSV or QFX/OFX
Quicken Users: File â Export â QIF format (select the accounts you want to export)
Important: Each bank's interface is different, but most have CSV or QFX/OFX export under Account Activity, Statements, or Download sections. SavePoint auto-detects the format based on file extension
đ The 9-Step Import Process
SavePoint's import wizard guides you through these steps:
Step 1: Select File
Upload your transaction file. SavePoint will analyze the file structure and detect the format automatically based on file extension.
- File Formats: Supports CSV (.csv), Excel (.xlsx, .xls), QIF (.qif), QFX (.qfx), and OFX (.ofx)
- CSV/Excel Required Columns: Date, Description/Payee, Amount, Category (Category required in file or will be mapped later)
- CSV/Excel Optional Columns: Currency, Notes/Memo, Reference Number/Check Number
- QIF Files: All transaction fields (date, amount, payee, category, memo, check number) are parsed automatically from the QIF format. Multi-account QIF files are detected and you will see an account mapping table to assign each QIF account to a SavePoint account. Split transactions within QIF files are also parsed and saved automatically after import
- QFX/OFX Files: Transaction data including date, amount, payee, and the bank's unique transaction ID (FITID) are parsed automatically. FITID is stored in the confirmation number field and used for enhanced duplicate detection. Account type and currency are also extracted from the file
- Date Formats: Automatically detects MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, and other common formats
- Amount Formats: Handles positive/negative numbers with or without currency symbols ($, âŦ, ÂŖ, etc.)
- Important: For CSV/Excel files, your file should have column headers in the first row (or use the Header Row selector in Step 2 to specify a different row). Save with UTF-8 encoding if you have special characters. QIF and QFX/OFX files do not require any preparation
The transaction import is for income and expenses (purchases, deposits, refunds, fees, interest). Do NOT use this for daily account balances or balance snapshots - those belong on the Balance Sheet page. Payments and transfers will be identified during import and excluded from income/expense categories to avoid double counting.
Step 2: Column Mapping
Tell SavePoint which columns in your file correspond to which transaction fields. The wizard shows your column headers and lets you map them to SavePoint fields. This is the first step where you interact with your data, and it 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 tell SavePoint which row contains your column headers. You can cycle through each row and preview the header names directly within SavePoint. This saves you from having to open and manually edit each spreadsheet file before importing. If your headers are on the first row, you don't need to change anything. A "Following row" preview below the selector shows the row right after the one you picked, so you can confirm it looks like real data
- Transaction Date (Required, marked with a red asterisk): Map to your date column
- Description/Payee (Required, marked with a red asterisk): Map to merchant name or transaction description column
- Category (Required, marked with a red asterisk): Map to category column if your file has one, or leave blank to categorize later
- Amount (Required, marked with a red asterisk): Map to the amount/value column
- Currency (Optional): Map if your file has a currency column (like "USD," "EUR," "GBP")
- Notes/Memo (Optional): Map to any notes or memo column
- Reference Number (Optional): Map to check number, confirmation code, or reference column
- Account Selection (Required, marked with a red asterisk): Choose which SavePoint account these transactions belong to - all imported transactions go to this one account
Step 3: Amount Direction
Banks format amounts differently. Tell SavePoint how expenses are represented in your file so it can correctly identify income vs expenses.
- Negative Amounts (-50.00): Choose this if expenses show as negative numbers and returns/refunds show as positive
- Positive Amounts (50.00): Choose this if expenses show as positive numbers and returns/refunds show as negative
- Why This Matters: SavePoint needs to know if -$100 means you spent money or received a refund - this varies by bank
- Example: If you see "Gas Station -45.50" in your file, select "Negative Amounts." If you see "Gas Station 45.50" for expenses, select "Positive Amounts"
- File Preview: A table shows your file's actual column headers and the first few data rows, unmodified, so you can check the sign of your amounts without opening the file yourself. Final signs are still applied later, in Step 9, based on each transaction's category type
- QIF/QFX/OFX Note: This step is automatically skipped when importing QIF, QFX, or OFX files because these formats include pre-signed amounts (expenses are already negative and income is already positive). No action is needed on your part
Step 4: Currency Mapping
Set the currency for your transactions. If you didn't map a currency column in Step 2, or if you need to override currencies for specific vendors, do it here.
- Default Behavior: All transactions start with your base currency unless you mapped a currency column
- Vendor-Level Currency: Transactions are grouped by vendor/description - you can set a different currency for each vendor
- Set All to Base Currency: Click this button to quickly set all transactions to your base currency
- Individual Mapping: Each vendor group shows a dropdown to select its currency (USD, EUR, GBP, etc.)
- Auto-Detection: SavePoint tries to detect currency symbols in amount fields (like $, âŦ, ÂŖ) and pre-selects them
Step 5: Data Preview
Review how your data looks with all mappings applied. This preview shows what will be imported (but final signs for income/expense aren't applied until Step 9).
- Table View: See all transactions in a table with Date, Description, Category, Amount, Currency, Notes, and Reference
- Verify Mappings: Check that dates, amounts, and currencies look correct
- Go Back if Needed: Use the Previous button to fix any mapping errors
- Sign Conversion Note: Income and expense signs are applied in Step 9 based on category types and your expense direction setting from Step 3
Step 6: Category Mapping
Map all categories from your bank file to SavePoint categories. Each unique category in your import file gets mapped to an existing SavePoint category.
- Exact Match: If a category name in your file matches one of your SavePoint categories exactly (including a subcategory), it's pre-selected automatically with a green "Exact match" badge
- Suggestions as Clickable Buttons: For everything else, SavePoint shows up to three suggestions as buttons - click one to apply it directly, or pick manually from the dropdown
- Historical: A suggestion based on how you've categorized similar transactions before. SavePoint matches on wording shared between the imported description and your past transaction descriptions, not an exact vendor match - occasionally this can surface a category from an unrelated transaction that happens to share a common word. If a suggestion looks wrong, just pick a different button or map manually. You can control how far back Historical looks in Settings â Merchant Mapping â Historical Match Window (see the Merchant Mapping System section)
- Merchant Pattern: A suggestion based on your saved patterns in Settings â Merchant Mapping. Because one file category can cover several different vendors (for example, "Restaurant" might include both a pizza place and a convenience store), this only appears when every vendor sharing that file category agrees on the same SavePoint category - otherwise it's left for Step 8 to resolve vendor by vendor
- Smart Match: A suggestion from a small built-in list of common category keywords (for example, "internet" or "cable" suggesting Cable/Internet)
- Pattern Match: A suggestion based on a partial match against your existing category names
- Auto-Map Suggested Matches: Applies the top suggestion to every unmapped row at once
- No Matches Found: Nothing matched, so you'll need to select the category manually
- Transfer & Payment Categories: These are for internal transactions and won't be included in income/expense calculations (prevents double counting)
- Important: Use Transfer for account-to-account moves, Payment for credit card payments - these don't affect your income or expenses
Step 7: Duplicate Check
SavePoint compares your import to existing transactions and flags potential duplicates. You decide which duplicates to skip.
- Duplicate Detection: Finds transactions with matching date, amount, and description in your existing data
- FITID Matching (QFX/OFX): When importing QFX or OFX files, SavePoint also uses the bank's unique transaction ID (FITID) stored in the confirmation number field for exact duplicate detection. This is significantly more reliable than date-and-amount matching alone, since it can distinguish between two legitimate transactions on the same day for the same amount
- Side-by-Side Comparison: Shows the new transaction next to existing matches so you can compare
- Skip Duplicates: Check the box next to any transaction you want to skip (won't be imported)
- Keep Checkbox: Leave unchecked to import even if it looks like a duplicate (useful for recurring transactions)
- Why This Matters: Prevents importing the same transactions twice if you download overlapping date ranges
Step 8: Vendor-Level Mapping (Optional)
Fine-tune category assignments based on specific vendors or transaction descriptions. This is optional but provides more precise categorization.
- Enable Vendor Mapping: Turn on the switch to activate vendor-level overrides
- Override Categories: Map specific vendors to different categories than the general category mapping from Step 6
- Example Use Case: "Skyline Airlines" might map to "Travel - Transportation" instead of just "Travel"
- Auto-Map Similar Vendors: Click this button to automatically group similar vendor names and assign them the same category
- Merchant Mapping Patterns: You can set up permanent patterns in Settings â Merchant Mapping for future imports
- Source Indicators: Shows whether each category came from auto-mapping, patterns, or historical data
Step 9: Final Preview
Final review of all transactions with all mappings, conversions, and duplicate exclusions applied. This is your last check before importing.
- Summary Cards:
- Transactions to Import (green card) - how many will be added
- Duplicates Excluded (yellow card) - how many were skipped
- Vendor Overrides (blue card) - how many have vendor-specific categories
- Final Table: Shows all transactions with final amounts, categories, currencies, and mapping source
- Mapping Source Column: Shows where each category came from (vendor mapping, pattern, category mapping, etc.)
- Unmapped Category Warning: If any transactions still have no category mapping, a confirmation appears before the import starts, listing which file categories are affected and how many transactions each covers. Choose "Continue Anyway" to proceed (those specific transactions are skipped and reported as errors) or go back and fix the mapping first
- Ready to Import: Click "Import" to add all transactions to your account, or "Previous" to make changes
- Download bank CSV with 3 months of transactions
- Step 1: Upload file â SavePoint detects headers automatically
- Step 2: Map Date, Description, Amount columns â Select checking account
- Step 3: Choose "Negative Amounts" (bank shows expenses as negatives)
- Step 4: Keep all as USD (or map foreign vendors to their currencies)
- Step 5: Preview looks good â Continue
- Step 6: Map bank categories to SavePoint categories â Create "Groceries" category
- Step 7: Skip 12 duplicates from overlapping download period
- Step 8: Enable vendor mapping â Set "Coffee Corner" to "Dining Out"
- Step 9: Review final count: 145 transactions to import â Click Import
Result: 145 new transactions added to checking account, all categorized and ready for budgeting.
- Export from Quicken: File â Export â QIF format, select checking and credit card accounts
- Step 1: Upload .qif file â SavePoint detects multiple accounts in the file
- Account Mapping: Map each QIF account (e.g., "Chase Checking", "Visa Card") to existing SavePoint accounts or create new ones
- Step 2: Column mapping is handled automatically for QIF files
- Step 3: Skipped automatically (QIF amounts are already pre-signed)
- Step 4: Keep all as USD â Continue
- Step 5: Preview shows parsed transactions â Continue
- Step 6: Map QIF categories to SavePoint categories. Split transaction categories from the QIF file also appear here for mapping
- Step 7: Review duplicates â Skip any that already exist
- Step 8: Review vendor mapping. Split transactions show as read-only with a "Split (N categories)" badge
- Step 9: Review final count â Click Import. Split transactions from the QIF file are automatically saved with their split categories and amounts after import
Result: All transactions from both accounts imported in a single pass, with QIF split transactions preserved and categories mapped to SavePoint categories.
- Download from your bank: Look for "Download Transactions" or "Export" and choose QFX or OFX format
- Step 1: Upload .qfx or .ofx file â SavePoint parses the bank statement data, including account type, currency, and unique transaction IDs
- Step 2: Column mapping is handled automatically â Select or create the SavePoint account
- Step 3: Skipped automatically (QFX/OFX amounts are already pre-signed)
- Step 4: Currency is auto-detected from the file â Continue
- Step 5: Preview shows parsed transactions â Continue
- Step 6: QFX/OFX files typically don't include categories, so you'll map all transactions to SavePoint categories here
- Step 7: Duplicate check uses FITID matching for exact detection â Skip any duplicates
- Step 8: Enable vendor mapping for precise categorization
- Step 9: Review final count â Click Import
Result: Bank transactions imported with FITID-based duplicate detection. Re-importing the same statement next month will automatically flag exact duplicates using the bank's transaction IDs.
Set aside time at least once a month to review and enter your transactions. You may find it helpful to do this at the beginning of each month for the previous month's activity. Import your bank statements, categorize transactions in Edit Mode, and review your budget performance. This monthly routine keeps your financial data accurate without requiring daily maintenance. Use the "Current Month" filter to focus on what matters most - this month's budget performance.
Every time you import transactions, SavePoint assigns the import a unique batch ID. The batch ID includes the date and original filename (for example, "2026-03-17_Chase-Checking.csv" or "2026-03-19_test-import.qif"). If you import the same file multiple times on the same day, SavePoint appends a counter to the batch ID (e.g., "_2", "_3") so each import is uniquely identifiable. This tracking applies to all import formats: CSV, Excel, QIF, QFX, and OFX.
đĻ Why Import Batch Tracking Matters
Import batch tracking gives you the ability to review, verify, or undo an entire import after the fact. If you accidentally import the wrong file, import to the wrong account, or discover that an import contains incorrect data, you can quickly filter to that specific import and take action without affecting the rest of your transaction history.
- Import Batch Filter: A new "Import Batch" dropdown in the transactions filter bar lets you filter your transaction list to show only transactions from a specific import. Select any batch from the dropdown to see exactly what was imported in that batch
- Auto-Refresh: The Import Batch dropdown automatically refreshes after you delete transactions, so empty batches (where all transactions have been removed) disappear from the list immediately
- Bulk Delete an Import: To remove an entire import, filter to the batch using the Import Batch filter, enter Edit Mode, use Select All to select all visible transactions, and delete them. This effectively undoes the entire import
- Import Source Tracking: SavePoint also records the file type of each import (csv, xlsx, qif, qfx, or ofx) so you can identify how transactions were imported
- Open the Import Batch filter in the transactions filter bar
- Select the batch you want to review (batches are listed by date and filename)
- Review the transactions that were part of that import
- If you need to remove the import: Enter Edit Mode â Select All â Delete Selected â Confirm deletion
Result: All transactions from that import are removed, and the batch disappears from the Import Batch dropdown.
Scenario: Jennifer had been avoiding her finances for months. She had transactions scattered across 3 bank accounts, 2 credit cards, and no idea where her money was going.
Her SavePoint Journey:
- Month 1 - Initial Setup: Downloaded 3 months of bank statements as CSV files and imported them into SavePoint. Spent about 2 hours in Edit Mode categorizing the imported transactions
- Month 2 - First Monthly Update: Downloaded last month's transactions and imported them. Set up merchant mapping rules based on her common vendors. Took about 30 minutes
- Month 3 - Analysis: Used filters to analyze spending patterns and identify problem areas. Updated her budget based on actual spending
- Month 4 - Routine: Monthly import now takes 15 minutes thanks to auto-categorization from merchant mapping
Results After 3 Months:
- Discovered she was spending $400/month on dining out (didn't realize it was that much)
- Found $1,200 in subscription services she'd forgotten about and canceled unused ones
- Started budgeting based on her actual spending patterns
- Reduced financial stress by having complete visibility with just a monthly 15-minute routine
Result: Jennifer went from financial chaos to complete control with a simple monthly routine, saving over $500/month by understanding where her money was actually going.