General Ledger (GL) Integration

The general ledger (GL) is an organization's main set of accounting books. General ledger integration means loan activity flows into those books automatically. Each event in the loan system becomes an accounting entry: money sent to a borrower, a payment received, interest earned, a fee charged, a loan written off as a charge-off.

The loan system acts as a detailed sub-ledger, with one record per loan. The general ledger holds the summary, such as one "loans receivable" account. Integration keeps the two in step.

Here is a simple example. A borrower pays $1,000, of which $700 is principal and $300 is interest. The integration records $1,000 more cash, $700 less in loans receivable and $300 of interest income. Without integration, someone adds up the day's payments, splits them by hand and types the totals into the accounting system.

Why it matters for lenders

The loan book and the general ledger must agree. Bank and credit union examiners check this directly. The examiner's guide used by the National Credit Union Administration (NCUA), for example, expects the total of loan records to balance with the matching general ledger account, and treats material differences as a problem to fix.

When the two don't tie, finance staff spend days at month-end tracing the gap. Common causes are a payment reversed in one system but not the other, a fee posted twice, or a loan boarded with the wrong balance. Each one also weakens the numbers that go into board reports, audits and the loan loss reserve.

Mission lenders face an extra layer. A CDFI that borrows from several funders may need to track loans and income by capital source, and tie each source to its own ledger accounts.

How it works in practice

A CDFI loan fund closes its books on the fifth business day of each month. Its servicing system sends a daily summary of entries to the accounting system, split by capital source. Each entry carries a reference back to the loans behind it.

At month-end, the controller runs a tie-out report. The loan book shows the same principal balance as the GL, except for one difference of $250. The report links it to a single returned payment that was reversed in servicing after the daily file had already been sent. She posts the correction, documents it and locks the period.

Before integration, the same close took two weeks. Staff copied totals from servicing reports into spreadsheets, and differences were sometimes carried forward for months because nobody could find them.