Nothing to re-key
The file brings your book in with the accounting it already carries. There are no opening balances to type by hand and no amortization history to rebuild.
Moving to FI Investment Tracker
Moving your investment book in takes the workbook you keep, or your current system's export, and a tie-out to your last month-end report. The app finds your columns from your own headings and shows you what it read, and every row is checked in a preview that you review before anything is saved. When the file carries amortized cost and accrued interest, your book arrives as it stands, with no history to rebuild.
No headings to rename
The app finds your columns from your own headings, even below a title block or across two rows, and shows which column each field is read from. Ready-made import profiles recognize common export layouts. If a column is wrong, pick the right one, and it is used again for the next file with the same headings.
Every row checked first
The preview checks every row and shows which rows are ready to save, which need a look, and why. Blocked and duplicate rows are held back.
Undo before you post
A restore point is taken automatically before each import is saved. Rollback removes that one import and puts back what it changed, and the app shows you the list first. It will not run once later imports, activity, or a posted close depend on those holdings, so check the import before you post anything after it.
The move, in four steps
You can import your first holdings file the same day you install, and each step is checked before the next one.
1. Export
Use the workbook your team keeps, or your current system's export. There is no need to save it as CSV or rename its columns. An older Excel 97-2003 file, an Excel Binary Workbook, or a password-protected workbook needs to be saved as a regular Excel Workbook (.xlsx) with no password first, and the app tells you how. A month-end file gives you a report to tie to.
2. Preview
Open Imports and upload the file. If it came from an investment system, choose the ready-made profile that fits it. Run the preview. Check which column each field is read from. Answer the questions the app asks, such as the date the balances are as of. Read what it says it worked out for anything the file leaves out. Every row is checked, and the preview totals the file's book and fair value.
3. Tie out and save
Match the preview totals to your last month-end report, then save. The columns you pick are used again for the next file with the same headings.
4. Close
Run your first close at your next month-end. The accrual trial and exception review come first, and the close cannot post until its GL entries balance to the cent.
When the file has the columns, your book and amortization state come over as they stand: amortized cost, and with it the remaining premium or discount; accrued interest; accrual basis; mortgage factor, original and current face, and CPR for mortgage-backed holdings; and call dates. WAC/WAM, PSA speeds, and step schedules come over with the import profile that reads those columns. An accrual basis, payment frequency, yield, and next payment date for every holding give the close what it needs to accrue and to relieve coupons correctly, so bring them if your file has them. When the accrual basis, payment frequency, or next payment date is missing, the preview says what the app used. The optional import template has a column for each of them, if you want a starting point.
Holdings without a CUSIP, such as certificates of deposit and other deposits, import on their account or certificate number, read from the column your file keeps it in. Your first posted close sets each holding's effective yield, and every later period amortizes at that same yield, so the accounting carries on from where your book stands. Your prior-period reports stay in your own files; from your first posted close on, every period's close package, GL entries, and audit trail are kept in the app.
There is no need to rename your headings first. In the preview, check which column each field is read from, and pick another if one is wrong. If you want a starting layout, the import template CSV is optional. After you save, check a few holdings' maturity, coupon, and accrued interest against your month-end report. The user guide walks through the import screen step by step.
Onboarding and first-close help are included with every license. From Operations Ledger up, our hands-on conversion and file-mapping help is included too. If you received our November 2026 letter, column-heading help is included on every plan, Core Ledger too: email us your file's column headings, never the data, and we reply with the exact headings to use. None of it is a separate line on your invoice. Questions before you start: support@fiinvestmenttracker.com.
The import runs on your own Windows PC, into an encrypted local database. Your holdings file is never sent to us, and our help works from column headings, screenshots, and logs, never your portfolio files.
Start with your own holdings file
Pricing is published and checkout is self-serve, with no sales call to book. Download the code-signed installer, import your first holdings file the same day, and tie it to your last month-end report before you rely on it. The FAQ answers the data-custody and licensing questions, and the product overview covers what the software does once your book is in.