Wedding Journal Examples (And Why Most Real Estate Investors Skip Them Entirely)
Most people hear "wedding journal" and picture a scrapbook with guest signatures and dried flowers. In real estate investing circles, the term means something completely different. A wedding journal is a single-spreadsheet model that tracks the purchase, financing, operations, and eventual sale of one rental property. It is not fancy. It works. The structure is usually a sheet named Wedding Journal with columns for date, category, description, amount, running balance, and notes. Income goes one color, expenses another. You feed it a monthly CSV from your bank and let formulas do the rest. That is it. That is the whole system.
What Actually Goes Into Wedding Journal Examples
Standard fields include purchase date, purchase price, loan amount, interest rate, loan term, closing costs, rehab costs, rent amount, vacancy rate, insurance, property tax, HOA, maintenance, CapEx reserves, management fees, and disposition costs. The sheet calculates cash flow, cap rate, cash-on-cash return, and IRR at sale automatically. I built my first version in 2011 using columns A through N in Google Sheets. I have rebuilt it six times since. The sixth version still uses the same core columns. The only thing that changes is where I put the CapEx schedule.
How to Build One in About 40 Minutes
Open a blank spreadsheet. Create these sheets: Summary, Income, Expenses, Debt, CapEx, Sale. That is five sheets total. Do not add more until you actually need them. In the Summary sheet, enter the purchase price, down payment, loan amount, interest rate, and loan term. Link the mortgage payment using the PMT function. Put total monthly income and total monthly expenses below that. Subtract expenses from income. Subtract debt service. You now have monthly cash flow. This usually takes about twelve minutes if you already know the basic formulas. In the Income sheet, list every revenue line: rent, laundry, parking, pet fees, late fees. Enter each month for a twelve-month period across the top. Enter amounts below. Sum at the bottom. Same structure for the Expenses sheet. Use separate rows for property tax, insurance, maintenance, CapEx reserve, vacancy, management, utilities, and repairs.
Get the Full Details
The Debt sheet tracks remaining principal and interest month by month. The CapEx sheet is where most people stop early and regret it later. List every major component with its expected replacement year: roof, HVAC, water heater, appliances, flooring. Assign a dollar amount to each replacement. Spread that cost across the months leading up to the swap. This prevents surprises when the water heater blows in year three and you have nothing set aside. The Sale sheet ties everything together at exit. Enter expected sale price, closing costs, outstanding loan balance, and gain calculation. The sheet computes your total return and annualized IRR. A complete setup like this takes roughly forty minutes on the first pass. After that, monthly updates take about eight minutes if you have your bank statement open and copy-paste directly.
Realistic Example Walkthrough
Purchase price: $220,000. Down payment: $44,000. Loan: $176,000 at 6.75% for 30 years. Monthly P&I payment: approximately $1,142. Rent: $1,650/month. Property tax: $2,200/year. Insurance: $1,200/year. Management: 10%. Maintenance reserve: 5% of rent. CapEx reserve: 3% of rent. Vacancy assumption: 5% of rent. Monthly income: $1,650. Monthly expenses total roughly $1,248 when you include debt service. Cash flow comes out to about $402 per month. That is a rough but usable starting point. The actual number shifts every time a real expense hits or a tenant turns over. I once ran a property where the journal showed strong cash flow on paper but the actual bank account told a different story. The missing piece was a $3,400 sewer line repair that happened in month fourteen. I had no CapEx line for it because I did not know the pipe was cast iron until the inspection came back. I started adding a miscellaneous line item with a quarterly $500 buffer after that. It is not perfect but it stopped catching me off guard.
Where People Mess This Up
The most common mistake is building a spreadsheet that looks good but nobody actually uses. I have seen journals with seventeen color-coded tabs, conditional formatting, and dropdown menus. They get abandoned within six weeks because updating them feels like work instead of like logging a receipt. The second mistake is ignoring short-term rentals versus long-term rentals. A wedding journal built for a 12-month lease does not handle monthly turnover, cleaning fees, or seasonal occupancy the way an Airbnb model does. If you plan to convert the property to short-term later, build that capability into the income section from the start. Changing it after the fact means backdating six months of entries and hoping you remember everything. The third mistake is setting the CapEx reserve too low. Twenty percent of monthly rent sounds generous until the roof fails. The actual number depends on the property age and condition. A 1970s build with original components needs a higher reserve than a 2019 build with a builder warranty. I use a tiered approach now. Newer properties get 2% to 4% of rent. Older properties get 6% to 10%. The difference shows up clearly in year two.
When Wedding Journal Examples Actually Fail
These spreadsheets do not scale well past about ten properties. At eleven and above, you start spending more time maintaining models than analyzing deals. Portfolio-level dashboards exist for a reason. They aggregate the same data faster and reduce copy-paste errors across multiple sheets. They also fail when you have complicated financing structures. A BRRRR deal with a refinance, a HELOC draw, and a split between rental and owner-occupied units requires custom handling. The standard template assumes one loan, one tenant, one property. Add complexity and you will spend an hour rebuilding formulas that should have been straightforward. If you are running single-family long-term rentals and want a clear picture of one deal at a time, this method works fine. If you are flipping houses or managing a mixed-use commercial building, look at property management software instead. AppFolio, Buildium, and DoorLoop handle data entry and reporting without manual spreadsheet maintenance.
Download and Template Notes
You can find free Wedding Journal Examples templates on GitHub, Reddit threads in r/realestateinvesting, and several real estate education sites. Most are Google Sheets or Excel files. Pick one, open it, and change the loan terms to match your actual numbers. Do not import it blindly and assume the formulas are correct. I spent an afternoon debugging someone else's CapEx tab because the author used a sumif formula that referenced the wrong column range. It returned zero for every entry and made the property look cash-flow positive when it was actually breaking even after a $2,100 water heater replacement. If you want a direct starting point, search for "real estate investment wedding journal template google sheets" and sort by date. The newest results tend to have fewer broken formulas than the ones posted in 2018. File format matters less than the structure. Make sure the sale section actually calculates IRR and not just total profit, because total profit without time weighting is useless for comparing deals.
A Quick Checklist Before You Start Tracking
Confirm your purchase price and closing costs are correct. Enter the exact loan terms from your note, not the ones from the pre-approval letter. Lock in your expected rent using recent comps in the neighborhood, not the asking price of a similar unit three streets over. Set your vacancy rate based on local market data, not a guess. Track CapEx for every component that has an age or expected life. Include a maintenance contingency line even if you think you will not use it. Review the sheet quarterly and adjust assumptions if actual numbers drift more than 10% from projected. That last point is important. Projections drift. Tenants move out. Roofs leak. Interest rates change. The journal is a living document, not a one-time calculator. The value is in tracking the variance between what you expected and what actually happened. That variance becomes your real edge on the next deal. I track about eight properties now. Each has its own journal. I open them once a month, update the actuals, and let the summary sheet refresh. It takes about fifteen minutes total across all eight. The alternative is trying to remember everything from memory, which has never worked out well for me.
