DesktopFinance User Manual

A guide to installing your first accounts, entering transactions, and keeping your finances organized.

1. Overview

DesktopFinance is a standalone desktop application for Windows for managing personal finances. To install the application, download DesktopFinanceSetup.msi from the download location below and run it. The installation will add the application and the required support files in DesktopFinance folder under Program Files, which is the default location.

The required files include the support files for SQlite database and Microsoft .Net 8.0 Runtime library. Uninstalling the application will remove all these files. See readme.md in the installer folder of the source code in case you want to build the installer yourself.

The application stores all of your data in a single SQlite database file on your computer. Because everything lives in one file, backing up your finances is as simple as copying that file (DesktopFinance has a built-in tool for this — see Backup & Maintenance).

Following a few simple rules will help you track your finances accurately in DesktopFinance. The sections below walk through setting up your accounts and categories, importing transactions, and the habits that keep your reports trustworthy month after month.

2. Getting Started

First Launch

The first time you start DesktopFinance, no database exists yet, so you will be asked to choose one of two options:

  • Start New Database — creates a fresh, empty database with no accounts or categories. Choose this if you want to build your chart of accounts and category list manually from scratch.
  • Restore from Backup… — lets you pick a previously saved backup file (.fdb) to restore, useful when moving to a new computer. You can also use this option to start from a template database that already contains a general-purpose list of categories you can customize — this saves you from typing in every category by hand, though you will still need to set up your own accounts. Download Template.fdb from the download location to get started quickly.

After this one-time choice, DesktopFinance opens directly to the main window on every subsequent launch.

The Main Window

The main window is organized into a few key areas:

  • Menu bar — File, Edit, Accounts, Category, Investment, View, Reports, and Help. Nearly everything you can do in the app is reachable from here.
  • Toolbar — quick-access icons for the most common actions (import, new account/category, budget, securities, and reports).
  • Navigation pane (left) — a tree of all your accounts grouped by type (Bank, Credit Card, Investment, Other Asset, Loan, Other Liability) plus a Reports section. Click an account to open its statement. The arrow button on the divider between the navigation pane and the tab area collapses or expands this pane.
  • Tab area (right) — each account statement, report, or tool you open appears as its own tab, so you can work with several at once. The Home tab is always present and shows a dashboard of pending/upcoming transactions.
  • Status bar (bottom) — shows brief status messages.

Setting Up Your Accounts

Before entering everyday transactions, spend a few minutes setting up your accounts and categories — getting this right up front saves rework later.

  • If you started with a new blank database, set up your accounts and categories from scratch using Accounts and Category in the menu.
  • If you started from a template, it already comes with a general-purpose list of categories, but you still need to set up your own accounts. Review the categories that came with the template by choosing View → Accounts and Categories, then use Category → Edit Category to rename, adjust, or delete any categories you don't need. Do all the editing and customization before you start entering data. You cannot delete a category once you assign that category to a transaction.

Creating Your First Account

  1. Open Accounts → New Account (or click the New Account toolbar icon).
  2. Choose the account type: Bank, Credit Card, Investment, Loan, Other Asset, or Other Liability. If the loan is amortized — such as a mortgage or a car loan — use Loan; for a general-purpose, non-amortized loan (such as a personal loan) use Other Liability instead.
  3. Fill in the account details (name, starting balance, and any type-specific fields such as loan terms) and save.
  4. The account now appears in the navigation tree under its type. Click it to open its statement tab and begin entering transactions.
Tip

Use Accounts → Edit Account to rename an account.

For each account you create, you'll need to enter its beginning balance as of a chosen start date. Pick that start date carefully, since it anchors everything that follows:

  • Prefer the beginning of a calendar year; if that isn't practical, use the beginning of a month instead.
  • Use the same start date for every account — this keeps cross-account reports (like Net Worth and Cash Flow) accurate.
  • For bank, credit card, investment, and loan accounts, make sure the beginning balance you enter matches the balance shown by the bank or financial institution on that exact start date. Getting this starting point right is the single most important step for keeping your books accurate going forward.
Tip

To find the correct beginning balance for a start date, look up the balance at the close of the previous day. For example, if you want to track your accounts starting January 1, 2027, use the balance as of the close of business on December 31, 2026, as the beginning balance for all the accounts. Use December 31, 2026, as the 'Account start date' in the dialog for setting up the accounts. When you start entering transactions, start from January 1, 2027, onwards. This is necessary to ensure the beginning bank balance in the cashflow statement for the first reporting period is accurate, as the cashflow report uses previous period's ending bank balance as the beginning balance for the current period. (also see Importing Transactions).

Setting Up Categories

Categories let you tag each transaction with what it was for, which powers budgeting and every report in the app. Go to Category → New Category to add categories such as "Groceries", "Rent", "Salary", or "Entertainment". To edit categories, choose Category → Edit Category. You don't need to set every category up front — you can create new ones as you go while entering transactions.

Importing Transactions (QFX)

Most banks let you download your recent transactions as a .qfx file. To bring them into DesktopFinance:

  1. Download the QFX file from your bank's website, starting from the account's start date — (see Creating Your First Account to learn about the start date).
  2. In DesktopFinance, choose File → Import QFX Data (or the toolbar's import icon).
  3. Select the downloaded file. DesktopFinance reads the institution information in the file and, the first time you import from a given bank, asks you to map it to one of your accounts.
  4. The transactions are added to that account's statement, ready for you to review and categorize. Use the Category column's dropdown to assign the right category to each imported transaction.
Note

Once an institution has been mapped to an account, future imports from that institution are matched automatically.

Choosing a Start Date for Later Imports

Suppose you imported a month of transactions ending on February 1. When you import the next batch, should you start on February 1 again or on February 2?

It's possible your bank posted additional transactions on February 1 after your first import already ran, so starting on February 2 risks missing them. Starting again on February 1 avoids that risk, at the cost of re-importing transactions you already have.

Tip

Always start your next import on the same date your last import ended, rather than the day after. It's much easier to spot and delete a duplicate transaction than to notice a transaction that never got imported. Duplicates usually appear as adjacent entries, with the earlier (already reconciled) copy showing as cleared and the newly imported copy showing as uncleared — right-click the duplicate row and choose Delete… to remove it.

Reconciling After an Import

Once you've assigned categories to all the newly imported transactions, confirm that the ending balance shown on the account's statement matches the balance reported by your bank or financial institution as of that same date.

  • If your starting balance matched the bank's balance and you've imported every transaction for the period, the two ending balances should match automatically.
  • If they don't match, work through both statements side by side, date by date, to find the discrepancy. Use the Clear column to mark each transaction as reconciled by checking it off as you confirm it against the bank statement.
  • To mark several transactions cleared at once, select them together (click the first row, then Shift-click the last, or Ctrl-click individual rows), right-click, and choose Check/Uncheck from the pop-up menu — this toggles the Clear checkbox for every selected row to match the opposite of the first selected row's current state.
Tip

Marking reconciled transactions as cleared pays off on your next import: every newly imported transaction always starts unchecked in the Clear column, so cleared (older) and new (unreviewed) transactions stay easy to tell apart at a glance.

Important

Assign a category to every transaction — skipping this affects the accuracy of every report that groups by category. A good way to check is the Cash Flow Statement: if the beginning bank balance plus the net cash flow shown there doesn't match the ending bank balance, that's a sign one or more transactions are missing a category.

You may notice that the category column for the beginning balance of an account is blank. Leave it blank.

3. Everyday Use

Working with Statements

Click any account in the navigation tree to open its statement — a spreadsheet-style register of every transaction in that account.

  • Add Row — adds a new blank transaction line for you to fill in to manually enter a transaction (date, name/payee, category, amount, memo).
  • Editing a cell — click any cell to edit it directly in the grid. Edited rows are marked as unsaved (dirty) until you save.
  • Save — commits all changed rows in the current statement to the database.
  • Right-click a row for options such as Delete…, Split…, and Check/Uncheck.
  • Show filter — narrow the register to All Transactions, Uncleared, or Cleared using the dropdown in the toolbar of the statement.
  • Clear column — check off transactions as they clear your bank, useful for reconciling against your bank statement.

On Bank and Credit Card statements you can select multiple rows at once (Shift-click for a range, Ctrl-click for individual rows) and then right-click to apply Delete… or Check/Uncheck to the whole selection in one step. Split… is only available when a single row is selected.

Important

If a statement tab has unsaved changes, DesktopFinance will prompt you to save before closing the tab or exiting the application.

Deleting a transaction cannot be undone.

Split Transactions

Use a split when a single transaction covers more than one category — for example, a store receipt that includes both groceries and household supplies. Right-click the transaction row and choose Split…, then enter each category and its portion of the total amount.

Recurring Transactions

For bills and deposits that repeat on a schedule (rent, subscriptions, paychecks), set them up once as recurring transactions instead of re-entering them every time.

  1. Open View → Recurring Transactions.
  2. Use New Payment or New Receipt to create a template: payee/payor, account, category, amount, frequency, and next due date.
  3. When a payment or receipt becomes due, click its Post button to commit it as a real transaction in the account's register. DesktopFinance automatically advances the due date to the next occurrence.
  4. If you want to skip a single occurrence without recording a transaction, open the entry and use its Skip option — this advances the due date without posting anything.
  5. Use each row's Edit button to change amount, category, frequency, or other details of a recurring item.

Budgeting

Choose Category → Enter Budget to set a planned spending or income amount per category, per period. Once budgets are set, use Reports → Budget vs Actual to compare what you planned against what you actually spent or earned.

Investments

DesktopFinance can track stocks, mutual funds, bonds, and other securities alongside your everyday accounts. Every action related to investing — adding securities, recording prices, entering trades, and reviewing performance — is reachable from the Investment menu.

Two Views on an Investment Account

Every investment account gives you two complementary views of the same holdings:

  • Investment Account View — works like a settlement or clearing account register. Every transfer of cash into or out of the account, every purchase or sale of a security, and every dividend or interest payment you receive appears here as a line item, just like transactions in a bank statement. Open it by clicking the account in the navigation tree, or via Investment → Investment Statement and picking the account from the dropdown.
  • Portfolio View — a rolled-up snapshot of an entire portfolio (a group of investment accounts) as of a given date. The first line shown is the cash balance sitting in the portfolio's clearing account, followed by each security you hold and its current value. Open it with the Portfolio button on the Investment Account View, or via Investment → Portfolio Statement.
Note

Securities in the Portfolio View are valued using the quote on file for the date you're viewing. If no quote exists for that exact date, DesktopFinance falls back to the closest available quote prior to it — so keeping quotes reasonably up to date (see Add Quotes below) keeps portfolio valuations accurate.

Recording Transfers and Trades

Enter money movements and trades directly from the Investment Account View:

  • Use the Transaction button to record a transfer of cash into or out of the account (for example, moving money in from your bank before making a purchase).
  • Use the Trade button to record a buy or sell of a security, including the quantity, price, and any fees.
Tip

If the security you want to trade doesn't appear in the Securities dropdown when entering a trade, add it first via Investment → Add Securities, then return to entering the trade.

Investment Menu Reference

  • Investment → Add Securities — register the stocks, funds, or other securities you hold, identified by ticker symbol.
  • Investment → Add Quotes — record prices for your securities, either manually or by importing a price-history CSV, so DesktopFinance can value your holdings on any given date. The price-history CSV file shoud have three columns with the column headings 'Date', 'Price', and 'Symbol'. Columns can be in any order.
  • Investment → Investment Statement — open the Investment Account View for a chosen account: enter transfers and trades, and review buys, sells, dividends, and other activity.
  • Investment → Portfolio Statement — open the Portfolio View for a chosen portfolio: a combined snapshot of cash plus the market value of every security held in it.
  • Investment → Stock Split — adjust share counts and cost basis after a stock split, so quantities and gain/loss figures stay correct going forward.
  • View → Securities — a simple reference list of every security you've added, showing its ticker symbol and description.
  • Reports → Investment Performance — review growth and returns on your investment holdings over a chosen period.

Loans

If you have an amortized loan such as a mortgage or a car loan, select Loan as the account type when you set up the account (see Creating Your First Account). DesktopFinance calculates the interest/principal split of each payment for you. For a general-purpose loan that is not amortized — such as most personal loans — use Other Liability instead and track payments manually.

Reports

The Reports menu (also available from the navigation tree's Reports section) includes:

ReportWhat it shows
Income and ExpensesA summary of money in versus money out over a chosen date range.
Budget vs ActualPlanned budget amounts compared to actual spending/income by category.
Net Worth StatementYour total assets minus liabilities across all accounts.
Cash Flow StatementHow cash moved through your accounts over a period.
Investment PerformanceGrowth and returns on your investment holdings.
Drilldown CategoryEvery transaction that makes up a category's total, for auditing a number you see elsewhere.

4. Backup & Maintenance

Backing Up

Choose File → Backup to open the backup settings dialog, where you can:

  • Click Backup Now at any time to save a snapshot of your database to a file you choose.
  • Check Backup upon closing and choose a Backup Folder to have DesktopFinance automatically save a timestamped backup to that folder every time you close the application.
Tip

Backup files use the .fdb extension and can be copied to external storage, a network drive, or a cloud-synced folder for extra safety.

Restoring

Choose File → Restore Backup, then select a previously saved .fdb file. Restoring replaces your current database entirely and closes any open statement tabs, so make sure any important recent changes are backed up first.

Starting a New Database

Choose File → New Database if you want to wipe the slate clean and start over (for example, to begin a separate set of books). You will be asked to confirm you have a backup of the current data, then given the choice to start blank or restore from a backup file.

Important

Creating a new database permanently replaces the one currently in use. Always back up first.

5. Quick Reference

TaskWhere to find it
Import bank transactionsFile → Import QFX Data
Export transactions (every account, whole database)File → Export…
Back up your dataFile → Backup
Restore from backupFile → Restore Backup
Create a new accountAccounts → New Account
Open an account's registerAccounts → (statement type), or click it in the navigation tree
Manage categoriesCategory → New/Edit Category
Set a budgetCategory → Enter Budget
Track securities & pricesInvestment → Add Securities / Add Quotes
View list of tracked securitiesView → Securities
Manage recurring bills/depositsView → Recurring Transactions
View all reportsReports menu
DocumentationHelp → Help
About / version infoHelp → About