A holding-cost schedule tracks the recurring costs of carrying an active property, month by month. Keep recorded actuals, known unpaid amounts and future estimates separate. This lets an owner see the effect of a longer holding period without turning a forecast into a bookkeeping entry.
For a flipping team, the useful question is practical: which recurring costs continue while the property remains unsold, and which records are still missing? The schedule supports that review; it is not a tax classification or investment-return recommendation.
Decide what the schedule includes
Start with your approved project-cost policy. List the recurring items the team wants to monitor, such as utilities, insurance, property charges and financing costs. Identify the source for each item and the person responsible for obtaining it. Keep debt principal movements separate from the cost subtotal so paying down a loan does not appear as a new operating cost.
Intuit’s Projects guidance describes assigning income and costs to a project. The worksheet below is an additional management view: it distinguishes posted records from estimates that have not entered the books.
Use one row per property, period and cost category. Record the service period as well as the payment date. A utility bill paid in September may describe August service; your report should not hide that distinction.
Three columns that prevent forecast drift
| Column | What belongs here | Supporting reference |
|---|---|---|
| Recorded actual | Amount already in the ledger | Entry and statement or invoice |
| Known item awaiting posting | Supported amount not yet reflected | Document plus assigned follow-up |
| Planning estimate | Expected future or unbilled amount | Assumption, date and owner |
When a bill arrives, replace the estimate in the planning view with the supported amount. Do not add the bill on top of the estimate. Keep an archive of the earlier forecast if the owner wants to understand forecasting accuracy.
Worked example: explain the monthly difference
Illustrative management worksheet. A property has $2,460 of holding costs recorded for August. An August utility bill for $140 is available but not yet posted. The owner also expects a $90 charge for which no invoice has arrived.
The ledger remains $2,460 until supported entries are made under the accounting policy. The operating review shows $2,600 supported ($2,460 + $140), plus $90 estimated, for a planning view of $2,690. Label those amounts clearly. A report headed simply “actual cost $2,690” would overstate what the records currently support.
Once the $140 bill is posted, the first column becomes $2,600 and the second becomes zero. The combined supported total stays $2,600. This simple bridge catches a common spreadsheet mistake: leaving the same bill in both columns.
Model a delay without rewriting history
Suppose the owner supplies a planning assumption of $2,700 per additional month and wants to see a two-month extension. Show $5,400 of additional estimated holding cost in a separate scenario. State what the assumption includes, its preparation date, and any items excluded.
Do not prorate every line mechanically. Some charges follow daily calculations, some arrive monthly, and others renew in larger installments. Use actual contracts or statements when available and leave unknown items visible. A rounded monthly scenario can support discussion, but it is not a lender payoff quote or a promise about future costs.
Close the schedule when the property sells
Check final service dates, unpaid bills, expected refunds and charges shown on the settlement statement. Link previously recorded items to the closing adjustment so they are not counted again. Keep unresolved items open rather than freezing an apparently final total before supporting documents arrive.
The sold-flip final-bills guide covers the closeout handoff. This monthly schedule supplies the history behind it. For help maintaining that history across several projects, review DaxCents investor services.
Sources and further reading
Source links provide background. The workflow and illustrative examples above are original educational material.