The board packet is due, and the note payable still lives in a workbook only two people can explain. Statements were rebuilt by hand. The tax file is a separate tab. Cash is whatever the bank confirmed late yesterday. If you run a church extension fund, that close is familiar, and it is not good enough.
Investment management notes are the liability that pays your investors and funds the next church loan. A stated coupon is not a balance. A balance you can sign is one you can rebuild from the note itself.
Why Note Balances Fail at Month-End
Take a March close at a mid-size fund with about $85 million of investor notes. The note spreadsheet shows accrued interest payable of $412,000. The general ledger shows $397,600. The $14,400 gap is not a rounding item. It is three concrete errors.
Certificates renewed on the 15th still carry the prior rate. A redemption reduced principal and left the old accrued interest sitting on the note. One congregation's reinvested interest was keyed twice, so the same dollars sit in principal and in the payable.
A promised rate is not a balance you can defend.
Members and congregations buy notes and certificates. The fund lends those proceeds for church construction, renovation, land, and refinancing. The notes are not FDIC-insured. They are offered under state securities rules. The subledger is both the payable and the file examiners, the board, and investors can ask to see.
The pain is structural, not a failure of the staff who close the books. Disconnected spreadsheets do not share one cash position. Statements and Forms 1099 get rebuilt by hand. Audit prep consumes weeks because every tie-out starts from a fresh export.
The path from here is practical. Each note type has to carry a defined record. Daily accrual and any discount or premium have to stay tied to the investor statement. Filing thresholds change by tax year, so the 1099 population cannot be hard-coded. A figure is usable only when someone other than its author can reproduce it. A single February close shows how cash and expense part company even when the rates look tidy.
Before the next packet, decide whether the current process can reproduce every investor balance without a manual bridge. If it cannot, the coupon schedule is not your system of record.
What Each Investor Note Must Carry
An investment note is debt. The investor supplies principal. The fund promises interest and repayment at maturity or on demand. Classify the book before you argue about yields.
| Note type | Typical term | When cash interest moves | Record that fails first |
|---|---|---|---|
| Demand note | Redeemable on request | Monthly or quarterly on the collected balance | Current principal and written redemption authority |
| Term certificate | Often 6 months to 5 years | Monthly, quarterly, or at maturity as the offering states | Maturity date and the rate after renewal |
| Certificate of participation | Set by that offering | As disclosed, usually periodic | Investor eligibility and the offering version on file |
| Reinvested interest | Follows the host note | Credited to principal instead of paid out | Split between interest credited and principal increased |
Demand notes fail when yesterday's balance is still on the statement after a same-day redemption. Term certificates fail at renewal, when the new rate never replaces the old one. Certificates of participation fail when the investor file does not match the offering that was sold. Reinvested interest fails when compounding mixes the credit and the principal increase into one unexplained number.
From the offering through the closed file
Walk each note once, in order, and do not skip a step because the dollar amount is small.
- Offering and eligibility. Match the investor to that series, including any state or accredited limits the offering document sets.
- Receipt and creation. Post the funds, open the note, and store the signed authorization with a date.
- Rate and day-count. Lock the rate, the convention, and the payment frequency before the first accrual runs.
- Ongoing accrual and the scheduled credit. Accrue on the stored terms, then pay cash or credit principal.
- Partial redemption, rollover, or payoff. Change principal, accrued interest, and the rate as separate fields.
- Closed-file retention. Keep the closed file for the period your state securities rules, tax-record policy, and audit policy already require, whichever is longest. The file holds offering versions, signed authorizations, payment histories, and final statements.
The Financial Industry Regulatory Authority states that promissory notes are usually securities and generally must be registered with the Securities and Exchange Commission or a state regulator unless an exemption applies, and it describes a Massachusetts Securities Division case in which at least 100 investors nationwide contributed more than $4 million to notes promising 13% over nine months before the issuer collapsed and investors lost their principal. A contractual yield does not remove issuer credit risk, liquidity risk, or fraud risk. The file therefore holds eligibility, disclosures, and payment history, not only a payable account. The same discipline belongs in the general ledger data your statements are built from.
Master-file fields
Every open note should show legal name, tax ID and exempt status, ownership type, principal, rate, day-count, payment frequency, maturity or demand terms, series or offering version, and the authorization date. If one of those fields is blank, do not accrue the note until it is filled. A blank maturity date is how a term certificate becomes an accidental demand note.
Keep the closed file for the longest period your state securities, tax, and audit policies name, and do not let a system purge delete offering versions or signed authorizations early.
Accrual Amortization and the Investor Statement
Interest payable follows principal, rate, and days. It does not follow the cash that left the bank.
Take one certificate in public. $100,000 at 4.25%, actual/365, accrues $11.64 a day, because 100,000 times 0.0425 divided by 365 equals 11.6438. A 31-day month accrues $360.96 even when the investor is paid only at quarter-end. The payable rises every day. The bank balance moves only when you pay.
A monthly convention is acceptable only when that same convention is written down and used in both the note subledger and the general ledger. If the subledger uses actual/365 and the ledger uses a 30-day month, you will manufacture a gap every close. The daily interest accrual calculation should be the same routine both books call.
Notes that are not issued at par
Under the effective-interest method in IFRS 9, the rate uses the initial carrying amount, contractual cash flows, maturity value, and premiums, discounts, and yield-adjusting fees, and it excludes expected credit losses when the rate is first calculated. On the fund's books, a $1,000 original-issue discount on a five-year $100,000 note increases periodic interest cost as it accretes. A premium reduces that cost as it amortizes. Do not rebuild the original effective rate later because collection looks weaker. Credit status is a separate workflow.
The subledger stores the original effective rate, keeps principal apart from accrued interest, amortizes the discount or fee on a schedule, and rolls the carrying amount to the liability in the ledger. Fiduciary practice makes the same demand of any pooled cash you hold for someone else. The Law Office of Bryan Fagan trust accounting discussion of fiduciary accounting income is a useful reminder that principal and income have to stay distinguishable when a statement goes to the person who owns the money.
What the investor sees
The statement, in this order, shows opening principal, rate, days in the period, interest accrued, interest paid or reinvested, redemptions, ending principal, and the next maturity or demand term. If reinvestment is a lump with no split, the investor cannot tell income from principal, and neither can you at tax time.
Run this tie-out this month with the tools you already have.
- Sum principal by note type. Demand, term, participation, and reinvested host notes stay in separate totals.
- Recalculate accrual from the stored rate and day-count, not from last month's spreadsheet formula.
- Match cash interest to the bank, payment by payment.
- Roll accrued payable from opening balance, plus accrual, minus cash paid and amounts credited to principal.
- Compare the subledger total to the general-ledger liability and list every difference by note number.
Leave the tax-form dollar tests and the audit architecture for their own work. This tie-out only proves the month.
1099 Thresholds That Change by Tax Year
The investor statement is not Form 1099-INT. Box 1 is taxable interest paid or credited during the calendar year. It is not the accrual still sitting in a payable account on December 31. A clean statement can still produce a wrong form if you export the payable instead of interest paid or credited.
| What is reported | Threshold | Tax-year anchor | What to tie it to |
|---|---|---|---|
| Boxes 1, 3, or 8 interest | At least $10 | Ongoing IRS 1099-INT rule | Investor and account interest paid or credited |
| Certain trade-or-business interest | $600 | 2024 instructions | Payer records for interest paid in a trade or business |
| Certain trade-or-business interest | $2,000 | Tax year 2026, as identified in later guidance | Same population, with the rule effective for that year only |
The IRS instructions for Form 1099-INT state that the form generally must be filed when reportable interest in boxes 1, 3, or 8 reaches at least $10, and that for certain interest paid in the course of a trade or business the applicable threshold was $600 under the 2024 instructions. Those same instructions cover credit unions and similar organizations, nonprofit activity, and nominee or middleman arrangements. Later guidance identifies a $2,000 threshold for tax year 2026 for certain of those trade-or-business payments. Treat $2,000 as a dated item and verify it against the instructions for that year before you file. A hard-coded rule will file the wrong population after the IRS changes the test.
Denominational or nonprofit status does not remove the duty. A congregation holding a note for its members is a classified recipient, not a detail you can skip. Read the filing population against how much 1099 interest to report for the tax year you are closing, not for the year the software was installed.
Six steps before forms go out
- Calculate interest at the investor and account level for amounts paid or credited in the calendar year.
- Map each amount to the correct box. Do not drop everything into Box 1 by habit.
- Flag exempt recipients and keep the reason on the account.
- Freeze a version of the annual file so later accrual posts cannot rewrite it.
- Reconcile total reportable interest to the note subledger and to the general ledger.
- Retain source transactions, corrections, and any reissued forms with the workpapers.
Investor withdrawals and corrections also need settlement dates and authorization evidence. Missing a return window can block recovery of a bad debit. That rail is a control around cash, not a second way to compute interest.
Put January on the controller's calendar. Freeze the annual file in the first week. Tie reportable interest to the subledger and the ledger before forms are furnished. Keep the bridge file with the workpapers, including every reissue.
Controls That Make a Balance Defensible
Stop asking whether the software has a dashboard. Ask whether any balance can be rebuilt from source records during close, board reporting, tax filing, or an exam.
A modernization study cited alongside the 2025 Global InvestOps Report estimates that properly implemented technology can reduce reporting cycles by 60%–75%, cut manual reconciliation work by about 80%, and redirect 40%–50% of finance resources from processing to analysis. Those gains show up only when the inputs are controlled. The operations report itself describes a shift toward automation and standardization, away from processes that do not scale.
Automation copies a wrong rate, a wrong effective date, or a bad payment allocation across the whole book.
The control set
Maker-checker approval belongs on rate changes, redemptions, write-offs, and payment templates. The person who enters the item does not release it.
The audit trail keeps who initiated, who approved, and who released the item, with timestamps and before-and-after values. Cover dollars and access. A changed user role can matter as much as a journal entry, because the next template will pay whoever the role allows.
Exception queues hold unmatched receipts, returned payments, and interest that did not post. An item in the queue is not "handled" because someone emailed about it.
A signed subledger-to-general-ledger reconciliation happens before statements go out. Unsigned, the statement is a draft.
A parallel run is mandatory when you leave spreadsheets or a legacy database. Explain every difference before go-live. A silent plug is how the old gap becomes the new opening balance.
Written treatment of payoff, loan delinquency, escrow, and modification keeps investor cash from being "explained" by a loan event nobody posted. If a church payoff lands in the operating account, the note book should not change unless an investor transaction occurred.
This quarter, sample 25 notes across demand, term, and reinvested interest. Recalculate them from source documents, not from the summary tab. If you cannot get back to the signed authorization, the rate notice, and the bank line, the balance is not defensible yet.
One Month Inside a Mid-Size Note Book
February in a non-leap year is the cleanest month to prove the note book. The fund has $25 million of notes: $15 million of demand notes at 3.10% and $10 million of two-year certificates at 4.50%, both actual/365. Rebuild each note as a lifecycle record at close. A stated yield is not that record.
Daily demand accrual is about $1,274, which is 15,000,000 times 0.031 divided by 365. Certificate accrual is about $1,233 a day. Over 28 days, demand accrual is $35,671 and certificate accrual is $34,521. Interest expense for the month is $70,192.
Cash follows a different calendar. Demand interest of $35,671 is paid on the last business day. Certificates pay quarterly, so February certificate cash is zero and interest payable rises by $34,521. Anyone who reads only the two coupons will miss that split between expense, cash, and payable.
One maturity inside the same close
A $200,000 certificate issued on December 22 rolls on February 20. Accrued interest taken in cash is about $1,479, from 200,000 times 0.045 times 60/365. The investor rolls the $200,000 principal into the next term.
State the entries in words. Debit interest expense $70,192 and credit interest payable. On the demand payment, debit payable and credit cash for $35,671. On the rollover, move only the $1,479 of interest to cash and leave principal in the termed series. That investor's statement line shows opening principal, 60 days of accrual, cash interest, the rollover, ending principal, and the new maturity. If those six fields cannot be rebuilt from the note record, the close is unfinished.
What a stable coupon can hide
A 4.50% certificate can look calm because the church loans behind it are not repriced every day. Australia's securities regulator, in ASIC Report 820, reviewed private-credit funds and found weak disclosure of strategy, exposures, valuations, risks, and fees. Fee and related-party disclosures were also hard to read. Church loans are a different book. The same failure still applies: infrequent marks can make credit risk look smaller than the loans behind a steady rate.
The board packet for this series should answer four questions in plain language. What loan exposure funds the series? How are delinquent or modified loans classified? Which fees are kept before the investor's stated yield? What redemption or liquidity limits apply? Pair the nominal yield with those facts, and track them over time. A tidy February coupon is not a credit report.
Reproduce Five Figures Before the Next Board Packet
Before the next packet, reproduce five figures from source records. They are total principal, the month's accrued interest, interest payable, cash interest paid, and reportable interest year to date. If any figure needs a one-off spreadsheet bridge, fix that bridge before you add features, portals, or new reports. A new screen on a bad tie-out only prints the gap faster.
Work in this order with the tools you already run.
- Inventory note types, rates, and day-count conventions, including every renewed certificate.
- Lock one day-count and apply it to the subledger and the ledger.
- Reconcile one closed month in parallel and list every difference by note number.
- Sample 25 statements against source transactions, not against the summary.
- Dry-run last year's interest against the correct 1099 threshold for that tax year.
A fund that can pass the five-figure test can keep improving its process. A fund that cannot should stop treating the coupon schedule as the system of record. Where the work has outgrown spreadsheets, a purpose-built church extension platform fits this book better than a generic portfolio tool.
CEFCore is built for this book of business. It covers investment note creation and tracking, daily or monthly interest accrual, interest payment processing, maturity notifications, redemption and rollover, automated statements, and 1099 generation, plus an investor portal for self-service access. A 30-minute demo scoped to the fund's size is available at cefcore.com.
Accurate notes let the fund keep paying its people and lending to churches without a surprise at audit. That is the standard the mission deserves.
CEFCore handles investor notes for church extension funds, from creation and daily or monthly accrual through payments, rollovers, statements, and 1099 reporting. If your month-end still depends on a manual bridge, a walkthrough scoped to your fund will show whether those five figures can be reproduced in one system. Visit CEFCore and set a 30-minute demo around your note book.
