A rehab-cost report and a bank-spending total answer different questions. Before treating a difference as an error, compare the same project, period, accounts, and transaction basis. Then build a short bridge between the two totals.
Define the two views
A bank statement shows cash that moved through one account during a statement period. A project report follows transactions assigned to a particular job or property. Depending on the report settings, it can include recorded bills that have not yet been paid and costs paid through another account.
Write the report filters above the comparison. Include the dates, accounting basis shown, property identifier, and accounts included. Without that header, a later reviewer may be trying to reproduce a different report.
Work through a simple example
For an illustrative rehab, the project report contains $18,000 of recorded supplier costs. The bank account shows $12,000 paid to those suppliers during the month. A supported $6,000 unpaid bill could explain the difference. It does not follow that either total is wrong.
Now suppose the bank also contains a $4,000 transfer to another business account. Including that movement as additional rehab spending would introduce a second problem. Trace the destination account before classifying the movement as a project purchase.
Use a comparison bridge
| Question | Evidence to check |
|---|---|
| Was the cost paid elsewhere? | Other bank or card statement |
| Is a bill still unpaid? | Supplier invoice and payable detail |
| Does the purchase cover two projects? | Invoice lines and allocation support |
| Is a refund in another period? | Supplier credit and related deposit |
| Is the movement a transfer? | Matching activity in the other account |
Record each reconciling item separately. The sum should connect the two defined views; an unexplained plug only hides the original question.
Preserve the purchase trail
If a $1,200 materials purchase serves two rehabs, keep one invoice reference and document the amounts assigned to each property. Do not make two unrelated copies look like two invoices. When the allocation is uncertain, flag it for the person who knows where the materials went.
Once the bridge is complete, save the source reports and the explanation together. Next month’s comparison can start with any remaining timing items instead of reopening every transaction. DaxCents’ project bookkeeping service uses property-level records as the starting point for that conversation.
Sources and further reading
Source links provide background. The workflow and illustrative examples above are original educational material.