Mortgage Schedule & Payment with Narrative Journal

studio

See exactly where every mortgage dollar goes.

An Excel workbook that combines your amortization schedule with a journal of every real transaction: payments, escrow, taxes, insurance, PMI, fees and extra principal, with your own notes on each line.

Mortgage statements spread this information across pages and months. This journal puts it in one place, in date order, with a dashboard on top that shows where you stand today and over the life of the loan.

What it shows you

Current balance and escrow balance, matched to your statement
Every payment split into interest, principal, escrow and fees
Escrow activity: property tax, homeowner’s insurance, PMI and escrow interest
The share of your money going to interest
Payoff date, interest still to pay and lifetime interest
How much an extra monthly payment saves, and how much sooner you finish
A memo column for your notes: confirmation numbers, calls, questions, changes

Built to stay correct

Insert a row anywhere. Totals and balances reconnect automatically, so a late entry never throws off the numbers.
Interest rounds to the penny, the way lenders calculate it, so your balance matches your statement.
Prints cleanly on letter paper: landscape, one page wide, headings and dashboard on every page.

How it works

Enter your loan amount, rate, monthly payment and first payment date.
Add each statement line in date order. Type the date and the row calculates itself.
Read the dashboard: balance, escrow, interest share and payoff, always on top.

See what you get

Here is how some of the tabs look with the example numbers that come in the file. In your copy the totals fill in on their own as you add entries.

Dashboard

CURRENT BALANCE$297,842

ESCROW BALANCE$954

PAYMENTS MADE6

Share of money going to interest63.7%

Interest saved by extra payments$98,148

See where you stand today, always on top.

Journal

Jan 1Monthly paymentInterest $1,625.00 · Principal $271.20 · Escrow $550.00$2,446.20

Mar 20Extra principal paymentTax refund put toward principal$500.00

Apr 18Escrow disbursementHomeowner’s insurance, annual policy($1,450.00)

Apr 20Late chargeExample of a fee$75.00

Every payment, escrow charge and fee in date order, with your own note on each line.

What if you pay extra?

Extra principal each month$200

Payoff date as paying nowNov 2054

Payoff date with extraFeb 2048

Interest saved by extra$98,148

Change one number and see the payoff date move.

Details

Format: Microsoft Excel (.xlsx), Excel 2010 or newer, Windows and Mac
Instant download after purchase
Sample data included; type over it with your own
For personal record-keeping. Not financial, tax or legal advice.

Price: $19.99

BUY NOW — $19.99

Secure checkout by Digistore24. Instant download. 60-day money-back guarantee.

Need help getting set up, or want your own statements entered for you? Email info@illisopes.com.

Refund Policy · Terms of Sale · Privacy Policy · Shipping & Delivery

‹ Back to the Studio

Search site