NCUA 5300 investment reporting and FFIEC RC-B call report support, straight from your subledger
FI Investment Tracker produces the call-report support and investment evidence organized for examiner review directly from a local-first securities subledger your institution controls. Amortized cost, accrued interest, and MBS factors are calculated in the same system that posts them, the close ties to the general ledger first, and the quarter's support package is built from the positions recorded when the quarter-end close posted.
1
Hold every security in one subledger, with amortized cost, accrual, factors, and call/step schedules calculated for every holding.
2
Close each month with a GL tie-out, so your team can check the investment numbers against the GL. The quarter-end close records the positions it closed, and the support for that quarter is built from them, so it does not move afterward.
3
Export the quarter’s support package and examiner evidence while your portfolio data never leaves your machine. Your institution completes and files the call report.
The quarterly work this takes off your desk
Amortized cost, accrued interest, premium and discount, and paydown factors live in one subledger with a documented month-end close. By quarter-end the numbers behind the 5300 investment lines and the RC-B schedule have been calculated and closed, with the tie-out to the general ledger you import checked at each close, so the support package is a report you run, with nothing to re-key and no spreadsheet formulas to maintain. Your team still reviews it before filing.
NCUA 5300
Support for the 5300 investment accounts and Schedule B
The page 1 cash on deposit, time deposit, and investment accounts and Schedule B Sections 1 to 3, with each holding on its line and the maturity distribution placed by the Weighted Average Life Table, plus brokered certificates (788) and realized gains and losses for the year to date (NV0159 to NV0161) from Section 4. Staged as an XML file for CUOnline import, with account support, holding-level detail, and tie-outs behind every figure. The Schedule B guide covers what each section asks for.
FFIEC RC-B
Schedule RC-B support
Every subitem of items 1 through 8 in the four columns (held-to-maturity amortized cost and fair value, available-for-sale amortized cost and fair value) and Memoranda 1 to 4, with Memorandum 7 on the FFIEC 051, in thousands as reported, plus where each holding is reported and why. The CSV carries the RC-B item numbers for your Call Report software. Memoranda 5 and 6, for banks with $10 billion or more in total assets, are not produced.
GL tie-out
A GL tie-out at each close
The schedule is produced from the same subledger, and the close checks the tie-out to the GL you import.
Exam evidence
Investment evidence organized for examiner review
Amortization methodology, premium/discount accretion, MBS/CMO paydown, realized gain/loss, and a record of every posted close: the workpapers and audit trail, organized for exam and audit questions.
Call-report support packages
For the team that owns the investment lines on the 5300 and RC-B.
- For the NCUA 5300: the page 1 investment accounts and Schedule B Sections 1 to 3, plus 788 and NV0159 to NV0161 from Section 4, for any of the last eight quarter-ends. For the FFIEC RC-B: items 1 through 8 and Memoranda 1 to 4 (Memorandum 7 on the FFIEC 051). Holding-level backup behind every total.
- Amortized cost, accrued interest, premium/discount, and MBS/CMO factor-based paydown calculated by an effective-interest engine for every holding. Holdings come in from your Excel workbook or your current system's export through a previewed import; the user guide shows each step.
- ASC 320 / SFAS 115 classification support, call and step schedules, and the rate shock reports your packet usually needs attached.
- Repeatable each quarter: choose the quarter-end and the package is built from the positions recorded when that quarter's close posted, so a trade, sale, or price entered after the quarter-end does not move it. A quarter whose close has not posted is a Blocker, not a guess.
- What stays with your team: on the 5300, line 784A (state-chartered credit unions), the impairment lines 420A to 420C, the employee benefit and charitable donation lines 789C to 789H, and IS0047 on the income statement (the package states the IS0047 figure that NV0162 must equal); on RC-B, Memoranda 5 and 6.
Examiner and audit evidence
- A documented month-end close with a GL tie-out, so your team can see whether the investment subledger reconciles to the ledger before the call report is filed.
- A record of every posted close and on-device restore points, so you can show what the numbers were, who posted them, and recover a prior state if asked.
- Methodology you can defend: effective-interest amortization, premium/discount accretion, factor-based paydown, and realized gain/loss on calls and maturities.
- Bring in the Excel workbook you keep, or the file your current system exports, without re-keying. The import finds your columns from your own headings and shows you what it read, and ready-made import profiles recognize common export layouts. Holdings without a CUSIP import on their account or certificate number, and amortized cost, accrual, and factor come in when the file has them.
Where our job ends and yours begins, honestly
Your institution files its own call report and is responsible for its filings. FI Investment Tracker produces the investment support and the evidence, organized for examiner review, behind your numbers. It does not transmit the 5300 or RC-B, and it is not regulatory, accounting, or legal advice. You and your auditors remain responsible for classification decisions, fair-value sources, and the accuracy of what you file. What the product gives you is a documented starting point for your own review: the same subledger that posts your investment accounting also produces the support package, so the schedule and the evidence trace back to one system of record.
Post the period
Amortization, accrual, and paydowns run in the subledger and post at month-end close.
Tie to the GL
The close reconciles the investment subledger to your general ledger and records the positions it closed.
Export support
Choose the quarter-end and export the support package and examiner evidence, built from the positions recorded at that close.
You file
Your team reviews the support, completes the 5300 in CUOnline or RC-B in your Call Report software, and files it.
Your portfolio stays on your own machine
The subledger that produces your call-report support runs on a machine your institution controls, in an encrypted local database. There is no copy of your portfolio sitting on our servers. The installer is code-signed by GRANITE HALL SOLUTIONS LLC, so your IT team can verify the publisher before anything is installed. Every release ships with a published SHA-256 checksum, and nothing is deleted if you ever stop. The architecture keeps your sensitive data in your building. See Security and Vendor Readiness for the detail your reviewers will ask for, and Company for who builds it.
Prove it on one quarter before you commit
We recommend starting narrow: import one real source file, close one quarter-end month with a GL tie-out, and generate that quarter's support package on your own numbers. You see the schedule support and examiner evidence come out of your real data before you roll it out across the rest of the close.
Step 1
Choose a plan and complete checkout.
Step 2
Download the signed installer and activate your license.
Step 3
Import holdings, close a quarter-end month, and export that quarter's support package.
Step 4
Get help using screenshots and exported evidence only, never confidential portfolio files.
Run your next call-report support from a posted quarter-end close
Pick a plan, download the signed installer, and produce your next NCUA 5300 / FFIEC RC-B investment support from one subledger you control.