Debt

Money lent to a friend: prepare the next payment estimate

Estimate the next repayment from a friend using the current lending balance and actual discussion, with separate expected and confirmed cash figures.

Editorial illustration for Money lent to a friend: prepare the next payment estimate

The next repayment estimate should answer a modest question: what amount is currently expected next, on what basis, and what would the balance be after it arrives? It should not turn the entire outstanding loan into assumed income. Start with the verified lending balance and the latest shared understanding, then keep the estimate outside the received-money record until a bank entry or cash acknowledgement confirms it.

Rebuild the current balance from evidence

List advances and repayments through a stated cutoff. Check recent bank receipts before using an older balance note. A repayment may have arrived after that note was prepared, so the estimate could otherwise ask the same amount to be returned twice. Match receipts by purpose and reference rather than assuming every transfer from the friend relates to the loan.

Keep gifts, shared-cost payments and agreed offsets separately identified. An offset can reduce the balance without generating a cash receipt. Record the supported loan subtotal and any disputed component independently. If the starting balance is uncertain, that uncertainty should be visible before you calculate what the next payment might leave outstanding.

Identify the source of the estimate

Use the amount and date actually discussed, noting when the discussion occurred. If the friend has not proposed a next amount, label your number a household scenario rather than a repayment commitment. A private forecast can help you understand cash exposure, but it should not be presented as something the other person agreed to do.

If the next amount is a range, preserve the reason for the range. For example, an amount may depend on a separately identified shared-cost calculation that is not yet complete. Do not choose the highest figure simply because it makes the household plan work. Each conditional figure should be tied to an understandable condition.

Calculate an illustrative remaining balance

Suppose verified advances total 420 currency units and completed repayments total 170, leaving 250. The latest discussion expects a payment of 60 next week. The current balance remains 250; the expected balance after receipt would be 190. These illustrative figures distinguish the factual position from the conditional next position.

If a further 20 shared-cost offset is separately agreed before that payment, the balance would become 230 without cash moving. A subsequent receipt of 60 would leave 170. Record the offset and repayment as distinct movements. Do not enter 80 as a bank receipt, because only 60 would actually arrive in cash under this example.

Keep the household cash estimate conservative

Put the expected 60 in a separate scenario in the cash calendar. The confirmed scenario should exclude it until received. If the repayment arrives after a bill rather than before it, the household low point may be unchanged even though the ending balance improves. Test dates against the actual commitment sequence rather than focusing only on the final total.

An expected repayment can be assigned to a future purpose conditionally, but avoid assigning it to several purposes at once. If it is intended to restore a reserve, state that. If it is intended to cover part of a bill, show the allocation. Neither decision changes the lending balance before the receipt or agreed offset occurs.

Replace the estimate with a dated outcome

When money arrives, record the actual amount, receipt date and purpose confirmation. If 50 arrives instead of 60, reduce the balance by 50 and retain a note of the 10 difference from the estimate. Do not count the missing 10 as another advance or mark it received because it was expected.

If the expected date passes without a receipt, update the estimate's status and preserve the previous expectation in the history. Continue the household plan from actual cash. The next estimate should begin from the current verified balance and the latest supported understanding, so a chain of old promises does not become a chain of fictional transactions in the record.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports