The close will not tie. At an $80 million church extension fund, investor interest expense sits $14,200 above the note subledger, and loan principal is $6,800 short because a construction draw hit cash and never hit the loan. The board wants a liquidity picture on Friday. The state wants note balances it can read. Each investor still needs a tax form that matches what was credited.
If notes, church loans, cash, and escrow still live in separate files, this month will look like last month. Another reconciliation tab will not fix it. You need general ledger data that stays tieable from the investor note through the church loan, the restricted purpose, and the 1099 box.
Why General Ledger Data Breaks CEF Reporting
Staff can usually explain an interest difference. A redeemed note accrued a few extra days, or a rate change landed in the workbook and not in the note system. The short loan principal is quieter. Cash left the bank, the project file shows a draw, and loans receivable never moved. A balanced checking account hid both errors.
General ledger data is the double-entry system of record. Each economic event is stored as linked debits and credits, so the books can prove total debits equal total credits. From that structure you can reproduce assets, liabilities, income, and expenses for the board. A file that keeps only an ending balance, plus one person's memory of the formula, is a recollection. It is not a ledger.
Two populations must never collapse into one cash story. Cash from note sales is an obligation to investors, not revenue. Cash advanced to a church is a loan asset with its own principal, interest, fees, escrow, and credit risk. Those balances feed state securities filings, GAAP financial statements, board liquidity reports, and IRS information returns. The IRS does not care how the cash was pooled; it cares that interest credited to each investor matches the note record and lands in the right 1099 box. Private hard money lending operates under a different rulebook, as the California hard money lending rules show, but the control principle is the same: note liability stays separate from the loan and collateral file, and both remain traceable to cash. For a ministry note program, examiners expect the note liability and the church loan on separate records.
Do not accept a trial balance that foots but cannot be traced from the investor note to the church loan to the cash account to the 1099 box. That chain is the ledger's real proof.
Three tests for this week
- The batch balances. Debits equal credits before the batch is allowed to post.
- Every balance names its source subledger. Notes, loans, cash, or escrow, never a plug labeled to balance.
- Someone other than the preparer can see who approved the entry. If approval lives only in an inbox, the ledger does not have it.
Fail one test and the statements are not ready, even when the trial balance foots.
What General Ledger Data Must Capture
| Source | Data the ledger must hold | Balance-sheet treatment | Control tie-out |
|---|---|---|---|
| Investor notes | Principal, accrued interest, rate periods, tax class, backup withholding | Liability to noteholders, never revenue | Notes payable and interest payable |
| Church loans | Principal, accrued interest, fees, nonaccrual date, allowance | Loan asset and related allowance | Loans receivable control |
| Cash and ACH | Bank account, receipt or disbursement, ACH or NACHA batch | Cash asset | Bank balance less outstanding items |
| Escrow and construction draws | Restricted cash, draw approval, project or church | Restricted cash or escrow liability | Escrow subledger by project |
| Fees | Origination, late, and servicing amounts, earned or deferred | Fee income or deferred liability | Fee subledger to income |
A federal securities filing describes a church extension fund as a nonprofit organization that sells notes to investors and uses the proceeds to fund loans to affiliated churches and religious organizations. Selling notes and making church loans are linked operations. They are not one balance. Investor funding is a liability or other obligation to noteholders. Advances to churches are loan assets with their own principal, interest, fees, escrow, and credit risk. Proceeds are not revenue merely because cash arrived, and a borrower payment cannot hit a generic cash account until principal, interest, fees, and escrow are split.
Notes and loans
Notes have to carry principal outstanding, accrued interest, each rate period, the tax classification, and backup-withholding status. One interest-expense total cannot support a recipient statement. State securities reporting uses those same note-level records. The note subledger has to hold investor balances in a form you can produce for state filings without rebuilding them from memory or old spreadsheets.
Loans have to carry principal, accrued interest, fee components, nonaccrual status with an effective date, and the allowance for credit losses, with loan-level evidence behind each balance. A sanctuary project and a refinance can share an income account. They cannot share a loan record. If you cannot name the church, the note, and the cash account that connected them, liquidity analysis and the audit both stall.
Cash, draws, and fees
Cash data names the bank account, the receipt or disbursement, and the ACH or NACHA batch. A plug that forces cash to a round number will foot the trial balance and still fail the bank reconciliation. Escrow and construction draws stay restricted and tied to the project. Undrawn construction money is not operating cash you can use for redemptions. Fees show whether they are earned now or deferred. Origination, late charges, and servicing are different events even when they arrive in one payment.
Circle any row your current file cannot produce at investor, loan, or account level. If the row exists only as a year-end total, the population was never captured.
A Chart of Accounts Built for Ministry Lending
Start with a compact operating core of about 30 accounts that answers what the board and the regulator will ask. The eleven accounts below are the control accounts every fund needs. Do not open a separate general-ledger account for each church or each investor. A fund with 400 notes and 150 loans would bury its trial balance. Carry church, loan, investor, project, fund, and restricted purpose as posting dimensions, and only where a named report uses them.
| Account | Type | Dimensions carried | Question it answers |
|---|---|---|---|
| Cash by bank account | Asset | Bank account | Can the fund meet this month's redemptions? |
| Loans receivable | Asset | Loan, church, fund | What principal is outstanding by portfolio? |
| Accrued interest receivable | Asset | Loan, nonaccrual status | How much loan interest is earned but unpaid? |
| Allowance for credit losses | Contra-asset | Loan or pool | What reserve covers expected losses? |
| Notes payable | Liability | Investor, note | What is owed to each noteholder? |
| Accrued interest payable | Liability | Investor, note, rate period | What note interest is owed but unpaid? |
| Escrow or restricted cash | Restricted asset with offsetting liability | Project, church | Which cash is restricted to a purpose? |
| Interest income | Income | Loan, fund | What is portfolio yield? |
| Interest expense | Expense | Investor, note, 1099 box | What did each note cost? |
| Fee income | Income | Loan, fee type | Which fees are earned versus deferred? |
| Credit-loss expense | Expense | Loan or pool | What provision did the period require? |
Practical rule: Add a dimension when it answers a liquidity, portfolio yield, restricted-purpose, or monthly board exception question. Refuse any dimension nobody reconciles.
A 2025 Stanford field study associated AI adoption with a 12% increase in general-ledger granularity and a 7.5-day reduction in monthly close time across 79 small and mid-sized firms. That is a reason to let software suggest a code. It is not a reason to treat the suggestion as authoritative. Inconsistent or excessive codes make the tie-out worse, not faster.
Who owns the map
Name one owner for the mapping. Require a person to review every automated classification before it posts. Keep a short written dictionary so two staff members code a construction draw the same way. The dictionary should define fund, church, loan, investor, project, and restricted purpose in words a new controller can apply on a Monday. Our chart of accounts setup guide walks through that operating core without turning the trial balance into a list of congregations.
A new account needs a report that a dimension cannot produce. If the question is "what is owed to this noteholder," that is a dimension on notes payable, not account number 2,417.
How Loans Notes and Cash Post into One Ledger
Take one economic event. Members buy notes, and the fund advances a $500,000 church construction loan from those proceeds. The subledgers know the story. The general ledger only knows it if each step becomes a balanced, sourced journal.
- Record note sales in the investor subledger as a liability, with the cash account that received the wires. Never record them as contribution revenue. The mission is lending, and the cash is owed back.
- Record the loan advance as principal on the loan record and as loans receivable. Park undrawn construction funds in escrow, not in operating cash. Redemptions and the jobsite do not share a pocket.
- On each borrower payment, split the cash among principal reduction, interest income, fees, and escrow before anything posts. A single "loan payment" entry is how fees disappear into principal.
- Accrue note interest and loan interest on the same calendar, daily or monthly. Post the accrual to accrued interest and to interest expense or interest income. Different calendars are how a month looks profitable on loans and incomplete on notes.
- Stop loan interest accrual when full collection of contractual interest or principal is no longer expected. Store the nonaccrual effective date, the approval, and the reversal or reclassification of amounts already accrued. A live amortization schedule is not evidence that collection is expected.
- Keep credit-loss expense and the allowance in their own accounts. Do not measure the same loan both individually and inside a pool.
- Require every batch to carry a source-system identifier, accounting date, posting status, and debit-credit proof before it can post. No proof, no post.
The OCC Bank Accounting Advisory Series states that interest accrual is not appropriate when full payment of contractual interest or principal is not expected. It also treats lifetime expected credit losses as amounts not expected to be collected over a loan's contractual life, and it warns against recording an allowance twice. Separate accounts for accrued interest, interest income, credit-loss expense, and the allowance, each with loan-level evidence, are how you follow that warning.
A purpose-built platform can generate those journals from the subledgers instead of retyping them. The control you can apply in any system is the same, and it is the point of posting cash with the ledger. No subledger event reaches the financial statements without a balanced, sourced journal.
Reconciliation Before the Books Close
A balanced trial balance proves only that debits equal credits. It does not prove a construction draw landed in restricted escrow, that a redeemed note left the investor roll, or that interest stopped when a church loan went nonaccrual. Reconciliation is the independent check against bank statements, servicing records, and investor tax rows. Staring harder at the same ledger repeats the same mistake.
Financial-institution ledger work treats the general ledger as a controlled data pipeline: validation at ingestion, explicit suspense handling, and daily comparison between source subledgers and ledger control accounts. That discipline catches omitted, duplicated, misclassified, or late items that a balance check cannot see. For a church extension fund, the chain to prove runs from investor note balances and church loan principal through cash and restricted purpose to the 1099 boxes. Set those dimensions once, and the close becomes tieable.
The order that blocks a bad close
- Each day, compare subledger totals for loan principal, note principal, and accrued interest with the general-ledger control accounts. Park breaks in a suspense or exception queue. Do not force an entry just to make the day look clean.
- Reconcile every bank account to the statement. List outstanding ACH batches and deposits in transit. Do not clear an item without the bank reference.
- Tie investor-level interest by Form 1099-INT box to interest expense and interest payable. The IRS instructions for Form 1099-INT set a $10 threshold for specified boxes, including taxable interest in Box 1. Keep backup-withholding status on the investor row, and do not push every noteholder through one universal cutoff.
- Confirm nonaccrual loans are excluded from income and that the allowance is not counted twice, once on the loan and again in a pool.
- At month-end, require debits to equal credits, review every suspense item older than one business day, and lock the period. An open queue is not a closed month.
| Check | Subledger side | General-ledger side | Close is blocked when |
|---|---|---|---|
| Daily interest | Accrued interest by loan and note | Accrued interest receivable and payable | Any unexplained difference remains |
| Loan principal | Servicing principal, excluding paid-off loans | Loans receivable control | A draw or payoff is only in cash |
| Investor principal | Note balances by holder | Notes payable | A redemption is not relieved |
| Cash | Bank balance plus timing items | Cash by account | An ACH batch has no bank reference |
| 1099 interest | Recipient totals by form box, plus withholding | Interest expense and payable | A filing threshold or withholding exception is missing |
| Credit and nonaccrual | Loan-level status and allowance support | Interest income and allowance | Accrual continues or the same loan is reserved twice |
A $120 million fund should explain any control-account difference over $1 before statements go to investors. Daily tie-out should reduce a three-week audit binder to the exceptions. Those are the pairs to prove before anyone signs.
A Month of Entries an Auditor Can Retrace
Picture March for a fund with $40 million of notes and $36 million of church loans. The month is ordinary until one draw is not. What makes it auditable is that every correction is a new entry, linked to the original, with a name on the approval.
On March 12 a $250,000 construction draw posts to operating cash in error. The bank is right, the project is wrong, and operating cash looks richer than the mission allows. On March 18 staff reverse that batch, link the reversal to the original, and post the draw to project escrow with the loan officer's approval attached. They do not edit the March 12 lines.
On March 31 a demand note changes rate mid-month, and $42 of interest is credited to the wrong holder. The correction is a new entry that moves the amount and splits the accrual by rate period. Backup withholding on one recipient goes to a withholding payable. It is not netted inside gross interest.
The IRS Form 1099-INT page requires the form for each person with reportable amounts in Boxes 1, 3, or 8 of at least $10, and it requires filing when federal backup withholding was withheld and not refunded, regardless of the payment amount. A year-end aggregate interest-expense figure cannot carry that filing. You have to trace totals to individual recipients, then to the returns and the related payable.
What the reviewer reproduces alone
An independent reviewer should not have to ask the preparer what happened. The log has to show event type, timestamp, originating system, outcome, the person who posted, the person who approved, and links to the journal, the account, and the source loan or note.
- Separate the log from the operators. People who create or approve postings cannot edit or delete the evidence of those actions.
- Keep ordinary users out of the log. Open access turns an audit trail into another editable workbook.
- Correct with a new entry. Silent overwrites erase the month you are trying to defend.
IT traceability for growing businesses makes the same point outside a church fund. If the log can be renamed or deleted, the month cannot be retraced. Retention should follow the written records policy you already use for tax and investor documents, confirmed with your auditor. The practical standard is spelled out in audit trail requirements. Clean data then produces the board packet you want: cash by account, loans versus notes, restricted escrow, and the exception queue, with no rebuilt spreadsheet.
Tighten the Ledger Before the Next Close
The decision this month is who signs the tie-out, not which software you buy. A 90-day sequence works whether you keep the current tools or replace them.
In the first 30 days, name an owner for the chart and for each control account. Freeze new accounts. Write the dictionary for fund, church, loan, investor, project, and restricted purpose, and make the owner the only person who changes it.
In the next 30 days, run the control pairs on the latest closed month. List every break over $1, including 1099 box totals and backup withholding, with an owner and a date. If a break has no date, it is not a plan.
In the last 30 days, put daily accrual and the suspense queue on a calendar. Separate the person who posts from the person who approves. Confirm in writing that those users cannot edit the audit log.
If loans, notes, cash, escrow, and the ledger still live in separate files, retyping journals will recreate the interest break that opened this close. A platform built for church extension funds can hold double-entry accounting, a real-time trial balance, financial statements, and automated journal entries from subledger activity in one place. We log financial and administrative changes in a tamper-evident audit trail, and we retain financial transaction records, audit trail logs, and 1099 tax documents for 7 years. That structure is described on CEFCore.
While you repair the source, you can explore financial visualization and reporting options for a clearer board packet. Pictures help only after the tie-out has a signer. Name that person before the next close date.
CEFCore keeps loan servicing, investor notes, cash, escrow, and the general ledger in one set of books, with automated journals from subledger activity and a tamper-evident record of who changed what. That is the path from a church construction draw to a noteholder's interest and tax reporting, without retyping the month into a workbook. Visit CEFCore when you are ready to put the chart, the subledgers, and the close in one controlled ledger.
