Self-guided onboarding

User guide

FI Investment Tracker is built so bank and credit union teams can onboard themselves: the installed app includes a re-openable Onboarding Center, role-based tutorial tracks, assistant playbooks, local restore points, and workflow-specific guidance.

Data custody reminder

Customer portfolio data stays on the institution-controlled workstation or deployment environment. Do not send portfolio files, source imports, CUSIPs, GL balances, report packages, or backup archives to support unless a separate support agreement explicitly permits it.

1. First run

Installing for the first time? Newly released versions may show a one-time Microsoft Defender SmartScreen caution — see what to expect during install (confirm the verified publisher is GRANITE HALL SOLUTIONS LLC, then choose More info → Run anyway). Once installed, open the app, review the First Run banner, then open the Onboarding Center from the top bar. The center can be reopened anytime from the top bar or the Training workspace.

  • Review workspace orientation.
  • Review the Suite workspace for Ledger, Operations, Governance, and Digital services.
  • Activate the license.
  • Confirm local backups.
  • Preview an import.
  • Build first report support.

2. License activation

Use Subscribe to enter the license key, confirm activation count, and verify paid workflow access. License validation controls access without requiring hosted portfolio data.

  • Confirm active plan and grace status.
  • Confirm activation limit.
  • Keep license evidence for IT review.

3. Time Machine restore points

Use Controls to review automatic local snapshots, create manual checkpoints, verify integrity evidence, and restore to a prior state when authorized by institution policy.

  • Create a checkpoint before imports.
  • Create a checkpoint before month-end close.
  • Run a restore drill during implementation.

4. Suite workspace

Use Suite to understand how the operating model fits together: Ledger Services, Operations Services, Governance Services, Digital Services, universal file intake, evidence binders, payments operations, cyber assessment replacement, 1071 readiness, and call-report workbench status.

  • Review service pillars and current readiness.
  • Review universal file routes before imports or reconciliations.
  • Choose the right evidence binder for the audience.
  • Start operator-style assistant queues for intake, exam binders, payments, cyber/vendor review, or 1071 readiness.

5. Import workflow

Use Interfaces to preview and commit CSV, TSV, XLSX, legacy-product, custodian, provider, and market-value files. The preview step shows committable rows, updates, blocked rows, duplicates, and validation messages.

Migrating from AIR / ACE: export your legacy database (ACE writes invfixvc.csv), choose the Legacy AIR / ACE export profile, and preview. Amortized cost, accrual basis/balance, premium/discount, mortgage factor, original/current face, WAC/WAM, CPR/PSA, call dates, and step schedules carry over; holdings without a CUSIP import on their account number. Reconcile imported totals to your last legacy report, then save the field map for recurring refreshes.

  • Choose source profile and import mode.
  • Upload or paste source rows.
  • Preview before commit.
  • Resolve exceptions and reconcile totals.
  • Rollback a batch when policy requires it.

6. Investment records

Use Investments to review CUSIP, issuer, balances, GL mapping, reporting fields, maturity/call data, fair value, and lifecycle history.

  • Search by CUSIP, issuer, or investment number.
  • Confirm GL and portfolio header mapping.
  • Confirm call-report and ALM mapping.
  • Review MBS/CMO fields (original/current face, factor + date, WAC/WAM, CPR/PSA, CMO type/group/tranche) and the step-coupon schedule where applicable.
  • For a CMO tranche, the detail shows a CMO Group panel (tranches in paydown priority); step bonds show a Step Schedule panel.
  • Export filtered records when supporting review.

7. Daily activity

Use Activity to queue principal and interest payments, premium or discount adjustments, maturities, calls, sales, market value updates, rate resets, and manual adjustments.

  • Select the investment first.
  • Confirm amount, date, type, and GL impact.
  • Use maker/checker review where required.
  • Sales, calls, and maturities are queued then posted by an approver; posting computes realized gain/loss against amortized cost, redeems a call at the call price and a maturity at par, and reduces or closes the position.

8. Month-end close

Use Month End to review basis-aware accrual and amortization trial data, GL support, premium/discount warnings, MBS/CMO/CMBS factor and CPR assumptions, variable-rate reset notes, close controls, and close package evidence.

  • Confirm all activity is posted or deferred.
  • Refresh rates and market values where applicable.
  • Review exceptions before posting support.
  • MBS/CMO holdings post actual principal paydowns — tied to a custodian-reported factor when present, otherwise modeled (CPR/PSA) and flagged; CMO tranches distribute by structure (sequential, PAC + support, VADM/Z).
  • Step bonds accrue at the scheduled coupon in effect on the close date.
  • Export close evidence.

9. Report support

Use Reports to prepare FFIEC RC-B/NCUA support, FedReporter/DataLink extracts, Brick ALM exports, CECL support, custom CSV reports, tie-outs, drillback, validations, approvals, and verification letters.

  • Confirm categories, designations, book values, and fair values.
  • Export portfolio & GL packages from your live book: Summary Recap, GL Balance Sheet, Book-to-Market, and Assumed Calls (yield-to-call vs yield-to-maturity).
  • Save a report as a reusable definition (base report + scope filter) and run, copy, rename, archive, or import/export it.
  • Run package validations and reconcile package totals to ledger and GL.
  • Keep approval evidence with the package.

10. Reconciliation and payments

Use Reconcile to compare ledger, custodian, GL, market value source, report package balances, and payment-rail files. Certify only after critical breaks are resolved.

  • Review all open breaks.
  • Use rail-specific evidence for ACH, ATM/debit card, Zelle/P2P, FedNow/RTP, wire, network, core, and GL files.
  • Resolve critical items before close or filing support.
  • Archive notes and evidence.

11. Assistant and training

Use Assistant for guided playbooks and Training for role-based tutorials. Assistant output is a workflow starter, not final approval or accounting advice.

  • Run universal file intake.
  • Prepare an exam binder.
  • Work payments exceptions.
  • Run cyber and vendor review.
  • Prepare 1071 readiness.
  • Prepare call-report support.
  • Complete month-end close.
  • Investigate stale prices.
  • Correct premium or discount issues.
  • Start restore or recovery workflow.

Need help without sending data?

Start with version, platform, license status, backup status, screenshots, logs, and steps to reproduce. Keep customer portfolio data inside the institution unless a separate support agreement permits sharing.

Open support intake