Loan Accounting & Accruals: How Mogul Books Manages Mortgages

If you own multiple rental properties, you likely maintain multiple mortgages with different lenders, interest rates, and escrow requirements.

In standard accounting software, keeping these loans clean is a major challenge. If you post every mortgage payment to a single 2400 - Mortgages Payable account, your balance sheet will quickly become a jumbled mess, making it impossible to reconcile individual loan balances.

Mogul Books solves this by using sub-GL (General Ledger) accounts and structured accrual transactions. In this article, we'll explain how Mogul Books handles property loans, interest accruals, and payment tagging.

Financing fees and discount points have their own loan accounts and schedule. See Mortgage Closing Costs: Tracking Fees, Points & Amortization for how 1700, 5085, and 5090 track these amounts separately from ordinary interest.

Sub-GL Accounts: Isolating Lender Balances

To keep your ledger clean, Mogul Books uses a sub-GL suffix system. When you register a new loan in Mogul Books' Loans Manager, the system prompts you for a short unique suffix code (e.g., CHASE for a Chase mortgage, or WFB for Wells Fargo).

Mogul Books then automatically creates two sub-GL accounts in your Chart of Accounts:

1. 2400.[SUFFIX]: Mortgages Payable - Lender Name (Liability)

2. 2600.[SUFFIX]: Accrued Interest - Lender Name (Liability)

Chart of Accounts Suffix Isolation
├── 2400 Mortgages Payable (Parent)
│   ├── 2400.CHASE (Chase Loan Principal)
│   └── 2400.WFB (Wells Fargo Principal)
└── 2600 Accrued Interest (Parent)
    ├── 2600.CHASE (Chase Accrued Interest)
    └── 2600.WFB (Wells Fargo Accrued Interest)

By tagging every loan transaction to these specific sub-GL codes, Mogul Books can track each loan's principal and interest payable separately, while still rolling them up into standard parent accounts for entity-level reporting.

Step 1: Accruing Loan Interest

Under double-entry accrual accounting, interest expense must be recognized in the month it is incurred, regardless of when the cash actually leaves your bank account.

Every month, before your mortgage payment is made, your lender accrues interest. Mogul Books books this monthly interest accrual automatically (or allows you to trigger it in one click):

Journal Entry (Accruing $1,400.00 interest on WFB loan):

• Dr 5080 - Mortgage Interest (P&L Expense) — $1,400.00
• Cr 2600.WFB - Accrued Interest - Wells Fargo (Balance Sheet Liability) — $1,400.00

Effect: You record the interest expense on your P&L today, and increase your accrued interest liability on the Balance Sheet. The entry balances perfectly.

Step 2: Booking the Monthly Mortgage Payment

When your monthly mortgage payment is paid from your checking account, the transaction is structured to:

1. Clear the accrued interest liability (2600.WFB).

2. Pay down the principal loan balance (2400.WFB).

3. Deposit money into your lender-held escrow reserve (1310).

Let's look at a payment of $2,500.00 ($1,400 interest, $600 principal, $500 escrow):

Journal Entry (Wells Fargo Payment):

• Dr 2600.WFB - Accrued Interest - Wells Fargo — $1,400.00 (Clears liability)
• Dr 2400.WFB - Mortgages Payable - Wells Fargo — $600.00 (Reduces loan)
• Dr 1310 - Escrow Reserves — $500.00 (Increases prepaid asset)
• Cr 1110 - Operating Cash — $2,500.00 (Cash outflow)

                      +-------------------+
                      |   Wells Fargo     |
                      | Mortgage Payment  |
                      |    $2,500.00      |
                      +---------+---------+
                                |
             +------------------+------------------+
             |                  |                  |
    +--------v--------+ +-------v-------+ +--------v--------+
    |  Accrued Int.   | |   Principal   | | Escrow Reserves |
    |   2600.WFB      | |   2400.WFB    | |     1310        |
    |   $1,400.00     | |    $600.00    | |    $500.00      |
    +-----------------+ +---------------+ +-----------------+

Auto-Splits and Rules

You don't need to post these multi-legged entries manually. When you register a loan, Mogul Books builds the full amortization schedule.

When your bank feed imports the mortgage payment:

1. Lender Detection: Mogul Books matches the transaction to the registered loan (e.g. via bank description matching Wells Fargo).

2. Suffix Tagging: Mogul Books looks up the current month's split, identifies the WFB suffix, and generates the balanced journal entries targeting 2400.WFB and 2600.WFB instantly.

This automated sub-GL tagging guarantees that your loan ledger matches your bank balances and tax obligations with zero manual calculations.

Bidirectional Loan Linking

To ensure complete auditability, Mogul Books links all transaction lines related to a loan directly to the loan record using a nullable loan_id field on the journal line level:

1. Auto-Resolution: Any journal line posted to an account with a loan suffix (such as 2400.L1 or 2600.L1 or 1310.L1) is automatically resolved and tagged with the corresponding loan_id by the system.

2. Transaction Alignment: When a loan payment or manual interest accrual is posted, the system links every participating line (including checking offsets and escrow reserves) to the associated loan.

3. Audit Trail: This bidirectional link allows you to click on any loan in your directory and view its entire transaction register (origination, monthly payments, accrued interest, and escrow deposits/outlays) instantly.