# How to move from Excel to a management accounting system: a checklist

> Moving from Excel to a management accounting system means transferring accounts, income and expense categories, counterparties, opening balances and transaction history into one database where reports are built automatically. The best approach is to pick a start date, enter opening balances, import a few months of statements and reconcile against the spreadsheet for one more month.

A step-by-step migration plan from spreadsheets: what to move, in which order, how to verify the result and where people usually go wrong.

## When is it time to switch, and when is a spreadsheet still enough?

A spreadsheet is fine if you have one or two accounts, a few dozen transactions a month and you are the only one looking at the numbers. Consider switching when you see these signs:

- reconciling balances with the bank takes hours and the figures still differ;
- reports (cash flow, profit and loss) are assembled by hand with pivot tables;
- payment plans live in a separate file or in your head;
- an accountant, partner or manager needs access to the numbers, but not to the entire file;
- there are several versions of the file and nobody is sure which is current.

Migration is not “move everything”. It is a chance to simplify a structure that grew by accident.

## Migration checklist

- Choose a start date — the first day of a month or quarter so periods match your reporting.
- List your accounts and cash desks with currencies, and record opening balances at the start date from bank statements.
- Simplify categories: separate trees for income and expenses; a few dozen categories are usually plenty.
- Add key counterparties (customers, suppliers); the rest can be created during import.
- Create projects or business lines if you want to see profitability by them.
- Enter debts at the start date: unpaid customer and supplier invoices as commitments, otherwise the debt report will be incomplete.
- Import 3–12 months of history through Claude MCP or CSV and review duplicates, transfers and suggested categories.
- Reconcile closing account balances with statements and check the import warnings.
- Run one parallel month: keep data in both places and compare totals.
- Assign roles, lock the spreadsheet for editing and name a single source of truth.

## What in the spreadsheet corresponds to what in the system

| In your spreadsheet | In Financist |
| --- | --- |
| The sheet with money movements | Accounts and transactions (income, expenses, transfers) |
| The “Category” or “Item” column | Income and expense categories |
| The “Customer / Supplier” column | Counterparties |
| The “Property”, “Order” or “Line of business” column | Projects |
| A separate “Debts” or “Bills to pay” sheet | Commitment transactions and the debt report |
| The “Payment plan” sheet | Planned transactions and the payment calendar |
| Pivot tables | Cash flow, profit and loss and balance sheet reports |
| A “Stock” or “Equipment” sheet | Warehouse and fixed assets with depreciation |

## How much history should you move, and how do you set opening balances?

Opening balances are the most important part of migration. For each account, enter the balance at the beginning of the history you import, plus all transactions after that date. If you import six months of statements, the opening balance must be the balance at the start of the first statement day, not today’s.

Years of history usually do not need to be moved. Month totals are enough for year-over-year comparisons, and the system accumulates full data for new periods by itself. Stock balances (on the item card) and fixed assets (cost and commissioning date) are also entered at the start date.

During import through [Claude MCP](https://findir.rozum.one/en/features/claude-mcp/), line sums, the balance chain and period boundaries are checked, and mismatches appear as warnings before anything is written. Duplicates are detected by bank ID or a row fingerprint, transfers between your accounts are merged into one, and categories are suggested from automation rules and your history. An import can be undone within seven days.

## Common mistakes during migration

| Mistake | Consequence | How to avoid it |
| --- | --- | --- |
| Categories that are too granular | Unreadable reports that nobody maintains consistently | Start with 20–40 categories and split only where a decision depends on it |
| No opening balances | Account balances differ from the bank | Record balances at the start date from statements |
| Transfers between own accounts booked as income and expense | Inflated turnover and distorted profit | Record them as transfers; import pairs them automatically |
| Mixing plan and actual | The calendar shows invented cash gaps | Mark future items as planned and complete them when paid |
| Importing without a preview | Duplicates and wrong categories | Review the preview and confirm only afterwards |
| Living in two systems with no deadline | Discrepancies and lost trust in both | Limit the parallel period to one or two months |

## How do you check that the migration worked?

Compare three things for the same month. First, closing balances per account, which should match the bank to the cent. Second, income and expense totals in the [cash flow report](https://findir.rozum.one/en/features/cash-flow/) and in your spreadsheet. Third, the amount of debts at that date.

The usual causes of differences are transfers entered twice, payments that landed in different months and duplicates. Capture the patterns you find in automation rules so they do not repeat next month. For a deeper question about the difference in approaches, read the [comparison of management and financial accounting](https://findir.rozum.one/en/guides/management-vs-financial-accounting/).

Financist is management accounting: it does not replace tax reporting. The product is in early access.

## Terms

- **Opening balance** — The amount of money on an account at the date from which tracking in the system begins.
- **Category** — An income or expense item by which transactions are grouped in reports.
- **Commitment** — A debt that has arisen but is not yet paid: an invoice issued to a customer or received from a supplier.
- **Parallel period** — A time when data is kept both in the spreadsheet and in the system to reconcile results.

## Try it before you migrate

**Try it before you migrate** The demo workspace shows what accounts, transactions and reports look like before any of your data is moved. [Try the demo](https://findir.rozum.one/app/)

## Frequently asked questions

### How long does moving from Excel take?

It depends on data volume, but basic setup — accounts, categories, opening balances — usually takes a day, while importing statements and reconciling takes a few more days. Add one parallel month to make sure the figures match.

### Do I need to move the entire history from my spreadsheet?

No. Three to twelve months is enough for comparisons and reports, and opening balances at the start date account for the rest. It is better to keep old files in an archive than to move them row by row.

### How do I import bank statements?

Through Claude MCP: you hand the statement to Claude in a chat, Claude parses the rows, and Financist shows a preview with duplicates, transfers and category suggestions. Data is written only after you confirm. CSV import is available too.

### Will I still need Excel after the move?

Yes, for one-off calculations and unusual summaries. Reports can be exported to CSV, which opens in Excel. But primary data entry and the single source of figures should live in one place.

### When is it better to stay with spreadsheets?

If you have one account, few transactions, only you look at the figures and you need neither payment plans nor debts by counterparty. Then a system’s complexity will not pay off. Switch when reconciliations eat a lot of time.

---
Source: https://findir.rozum.one/en/guides/excel-to-accounting-system/