Buyer's guide

The eight jobs of an investment subledger, and how FI Investment Tracker does each one

An investment subledger has eight jobs at a credit union or community bank. The first three decide your close, the next two decide your exam, the sixth decides how quickly you are up and running, and the last two decide your vendor review, your budget and your exit. For each one, this guide says plainly what FI Investment Tracker does in the version you can download today, and where it stops, so you can check every line on your own holdings.

Our published pricing Our vendor-review packet

The eight jobs

In the order they matter at month-end, with what FI Investment Tracker does for each today.

1. Calculate the accounting, holding by holding

Everything else depends on this.

Premium and discount amortize on the effective-interest method, per holding, at a constant effective yield, so there are no formulas to maintain.
A callable bought at a premium amortizes to its earliest call date at the call price. Discounts accrete to maturity.
Each holding accrues on its own day-count basis, read from the import file's Basis column. Include it for every holding: a file that leaves it out gets a default by security type.
Realized gain or loss on sales, calls, and maturities is measured against amortized cost.
Each posted close keeps the per-holding accrual and amortization detail behind its GL summary, so a reported number can be traced back to the holdings that produced it.

2. Cover the instruments you own

Bullets to structured paper.

Bullets, callables, and step-ups and step-downs. Step bonds accrue at the scheduled coupon in effect on the close date.
Variable-rate notes, with a review note in the accrual trial when a next reset date is missing or the index rate needs confirming before the close.
Certificates and other holdings without a CUSIP, which import on their account number.
Mortgage-backed holdings post actual principal paydowns at month-end, using the custodian-reported factor when present, otherwise a modeled CPR/PSA estimate that is clearly flagged.
CMO tranches pay down by structure: sequential, PAC and support, VADM and Z.

3. Close the period and tie it to the GL

The close is checked before it posts.

The close runs in order: set prior market value, import market prices, run the accrual trial, review exceptions, check GL entries, post month end.
A close cannot post while a blocking check fails, including GL entries that do not balance to the cent or holdings missing GL accounts.
Each posted close package is hash-sealed. Corrections post as new, approved entries through a guided flow: a current-period adjusting entry, or a flagged prior-period adjustment with a required justification note.
Each posted close gives you a balanced GL summary and a journal file: the close's GL rows as journal lines (effective date, account, debit, credit, description, reference) laid out for your core's GL import. Confirm the layout with your core administrator before the first import. A date-range journal export covers posted activity.

4. Produce the support you file from

Output from the closed period.

The NCUA 5300 support package and the FFIEC RC-B support report, built from the positions recorded at the quarter-end close, with holding-level detail.
A CSV extract with WAL and call-report lines for your call-report filing software.
Summary Recap, GL Balance Sheet, Book-to-Market, and Assumed Calls reports, ALM and CECL exports, and saved report definitions.
The 5300 package carries its validation checks, book-to-market, accrued-interest detail, amortization rollforward, and ledger tie-outs in one download.
It prepares support; your institution files and approves the report.

5. Keep the evidence

Numbers you can show an examiner.

A tamper-evident, hash-chained audit log of key actions.
A record of every posted close: when it posted, who posted it, its transaction count, and its hash.
On-device restore points with integrity hashes, a safety snapshot before a restore point is rolled back, and restore drill evidence.
The app has one operator sign-in per computer, a read-only view lets a second person review without changing anything, and the review-before-post queue records the queue and the approval under that operator. The app does not enforce two-person (maker-checker) separation or separate named roles today.

6. Bring your holdings in

Moving in is easy, and every row is checked first.

Import an Excel workbook (.xlsx or .xlsm), a CSV file, or a TSV file as it is. The app finds your headings and shows which column each field is read from. It asks for what it needs from you, such as the date the balances are as of. It holds back a row that is missing a required value. The preview says what it worked out for anything else the file leaves out. Ready-made import profiles recognize common export layouts.
Amortized cost (and with it the remaining premium or discount), accrual basis and balance, factor, original and current face, CPR, and call dates come in when the file has those columns. WAC/WAM come in with the import profile that reads them. Holdings without a CUSIP import on their account number.
Every row is checked in a preview before anything is saved. The preview marks each row ready, warning, update, blocked, or duplicate, counts each status, and lists the first rows with the reason. Blocked and duplicate rows are held back, a restore point is taken before each import, one import can be rolled back on its own unless later imports, activity, or a posted close depend on it, and the column map can be saved so the next file from the same source loads the same way.
Onboarding and first-close help come with every license, and hands-on help with importing your holdings and file mapping is included from Operations Ledger up. If you received our November 2026 letter, column-heading help is included on every plan: email us your file's column headings, never the data.
The migration page walks through the move in four steps: export, preview, tie out and save, close.

7. Keep your data in your building

Custody you can verify.

A 64-bit desktop app for Windows 10 or 11, with your ledger in an encrypted local database on a PC your institution already owns. There is no server to run.
Your portfolio data is never sent to us. Only license and billing details and security logs reach our servers. Activation and a license check about once a day need outbound HTTPS to fi-investment-tracker-api.fly.dev.
Support works from logs, screenshots, and your version number, never your portfolio files.
The installer is code-signed by GRANITE HALL SOLUTIONS LLC, and a SHA-256 checksum is published for each release.

8. Keep the cost predictable and the exit clean

Priced as software you run yourself.

One flat, published price per plan, billed annually or monthly, from $799 a year for Core Ledger to $4,999 a year for the Full FI Operations Suite. Every plan has the full investment ledger.
No server to buy or host, and support, onboarding, and first-close help are included with every license.
Cancel anytime from the billing portal on your download and license page. The refund policy covers a genuine, verified defect that stops you from using what you paid for, not a change of mind, and it is published in full.
If the subscription ends, the app becomes read-only, not locked: you can still open your records, export an encrypted backup, export the audit log, and download stored documents.

What it does not do today

Plainly, so you can decide quickly.

No hosted copy of your book

Your portfolio stays on your own machine in an encrypted local database and is never sent to us, so your backups are yours to run and keep, and nothing is deleted if you stop.

Windows only

FI Investment Tracker is Windows desktop software for Windows 10 or 11, 64-bit. There is no Mac or browser version.

Files, not a live core interface

It works from files you import and produces entries and a journal file your team posts. It is not a live connection to a core system.

No price feed included

Fair values come from the custodian, provider, or market-value files you import, so your pricing source stays yours.

A book of record, not a risk model

It produces exports for ALM and credit loss work and includes rate-shock support, but it is not an interest rate risk model, a credit loss model, or a trading system.

One operator sign-in per computer

The app has one operator sign-in per computer, a read-only view lets a second person review without changing anything, and the review-before-post queue records the queue and the approval under that operator. The app does not enforce two-person (maker-checker) separation or separate named roles today.

Who it is built for

A credit union or community bank with real accounting in its investment book, including mortgage-backed and structured positions, that wants the portfolio data to stay inside the institution, wants the month-end math and the close checks done for it, and wants to start on its own data through self-serve checkout, with no sales call to book.

Prove it on your own holdings

Your first working session is the evaluation. Checkout is self-serve and the signed installer is ready right after payment, so in a day you can load your holdings, tie them to your last month-end report, and run the current month's close up to the post. Post your first close at month-end, once the period is complete, and produce your support from it.

Step 1

Load a real holdings file, including your three most awkward securities, and reconcile the loaded totals to your last closed report before anything else.

Step 2

Run the current month's close up to the post: the accrual trial, amortization, accretion, accrual, and paydowns, with the entries visible at holding level. Post it at month-end, once the period is complete.

Step 3

Tie the subledger to the general ledger, and confirm the differences are explainable rather than plugged.

Step 4

Produce the investment support you would actually file from, then reproduce it a second time and confirm the numbers are identical.

Step 5

Run a backup and a restore, and keep the evidence. Then write down what you could not do, because that list is the real output of the proof.

What should a first session on our own data test?

One real period on your own holdings. Load your portfolio, tie it to your last month-end report, and run the current month's close up to the post. At month-end, post the close, tie the subledger to the general ledger, and produce the investment support you would file from. Your own securities show how the software handles your instruments, your conventions, and your reconciling items.

How much does FI Investment Tracker cost?

Prices are published on the pricing page: from $799 a year for Core Ledger up to $4,999 a year for the Full FI Operations Suite, or billed monthly. Every plan includes the full investment ledger, support, and onboarding and first-close help, and there is no server to buy or host.

Do you have a SOC 2 report?

Not yet, and we will not imply otherwise. Your portfolio data is never sent to us: it stays on your own machine, encrypted, under your IT controls, and only license and billing details and security logs reach our servers. Whether that meets your vendor management policy is your institution's call.

What does FI Investment Tracker not do today?

It keeps no hosted copy of your book, it runs on Windows only, it works from imported files, not a live connection to your core, it does not include a price feed, it is a book of record rather than a risk model, and it has one operator sign-in per computer without separate named roles. The full list is on this page.

Where our job ends and yours begins

Your institution files its own reports and remains responsible for its filings. Nothing on this page is regulatory, accounting, tax, or legal advice, and the accounting references here should be confirmed against the guidance currently in effect with your own auditors. Classification elections, day-count conventions, fair-value sources, materiality judgments, and vendor management policy belong to your institution. This guide describes the software; it is not a substitute for your own due diligence.

Start on your own holdings

Pricing is published, checkout is self-serve with no sales call, and the installer is code-signed and checksummed so your IT team can verify it before it is deployed. Your first working session on your own portfolio is the evaluation, and your data never leaves your machine while you run it.

See pricing Vendor-review packet

Keep reading

Product detail: the investment accounting software overview, NCUA 5300 and FFIEC RC-B support, the time and cost savings calculator, the migration guide, the security model, and the FAQ. Guides: effective-interest amortization, NCUA 5300 Schedule B, and subledger to GL reconciliation. Questions: support@fiinvestmenttracker.com.