Plan car expenses in one worksheet that separates payments already made, recurring bills and money reserved for future work. Use a consistent monthly or annual period for fuel, insurance, servicing and repairs. Recorded spending does not capture every ownership cost: depreciation and other missing costs need their own explicit inputs.
Start with your own records
Start with one car and clear start and end dates. Gather dated receipts and payment records for fuel, insurance, servicing, repairs, inspection and tyres. Check the payment schedule on your insurance policy and any quotes for work you expect. Enter your own amounts in the worksheet. Where you do not know an amount yet, leave it blank or mark it clearly as your personal estimate. A missing amount is unknown, not zero.
Assign each payment to one category according to what it covered. Split a mixed receipt using its actual item amounts. Decide whether this copy of the worksheet covers a calendar month or a full year. Count a bill when its payment date falls within the chosen boundaries; the dates of insurance cover or service use do not move the payment into another period. Keep a note of the dated source so you can check the entry later.
Monthly and yearly expense worksheet
Copy this blank template into your own notes or spreadsheet; it is not an app form. Choose one period. For each category, enter one planned total and one actual paid total for that period, with a source note identifying the receipts or bills behind it. Use another copy for the year if you also review months. The monthly and yearly views summarise the same records at different intervals, so never add their totals together.
- Start
- End
- Month or year
- Currency
- EUR
| Category | Planned payments (€) | Actual payments (€) | Payment date(s) | Source and note |
|---|---|---|---|---|
| Fuel | ||||
| Insurance | ||||
| Servicing | ||||
| Repairs | ||||
| Inspection | ||||
| Tyres | ||||
| Other personal costs | ||||
| Total |
Include parking or financing payments under “other” only if they apply to you and you have the payment details. A loan balance is not a payment made. Take planned amounts from your own schedule, payment history or a labelled estimate. Take actual amounts from evidence of payment. Keep these columns separate and total each on its own. An unusual month does not provide a reliable forecast for every remaining month.
How to set money aside for a larger bill
A reserve is the money you have earmarked for a future bill. A contribution is what you still intend to add to it. Neither the reserve balance nor a transfer into it is a paid car bill. Use the separate worksheet below for goals you want to fund. Beside each purpose, write the expected payment date and the date and source of the amount, such as your own insurance notice or quote.
| Purpose | Target (€) | Already set aside (€) | Remaining (€) | Contributions remaining | Per contribution (€) |
|---|---|---|---|---|---|
| Insurance Expected payment date: ______ Dated source: ______ | |||||
| Another purpose Expected payment date: ______ Dated source: ______ |
For the insurance row, copy target amount A from your own bill or quote, money B already earmarked for that bill, and the number N of contributions you can make before payment. Remaining amount = the greater of A − B and zero. Amount per contribution = remaining amount ÷ N, when N is positive. Round contributions to cents and adjust the final one so their total equals the remaining amount. If the bill is due now, show the shortfall instead of dividing by zero. Treat an unknown future premium as a labelled personal estimate. Blank inputs produce no result.
Once you pay the bill, enter it once in the actual payments column of the first worksheet using the payment date, then reduce its earmarked reserve. Do not add reserve contributions or the reserve balance to spending. For a full-year plan, divide annual planned payments by twelve to find a monthly equivalent. That average does not say when each bill is due or how much you still need to set aside.
How to compare your plan with payments
At the end of the period, check each category against receipts and bank entries. Subtract the planned amount from the actual paid amount in each row: a positive difference means the plan was exceeded; a negative one means you paid less. Look for a changed price, a delayed bill, a missing record or unplanned work. Do not treat an absent receipt as a saving.
Update the plan for the remaining months when you receive better information. Keep bills already paid in the actual record. Compare months using the same categories, and note any annual insurance bill or repair. Review the reserve separately against the next known payment date.
What this worksheet does not show
This worksheet shows your planned and recorded cash payments. It does not automatically allocate the purchase price across the car’s useful life or account for depreciation, a financing balance, or receipts you do not have. Assess those items separately using your own information and purpose. Moving money into a reserve is also not an ownership cost; it is an allocation of your money before the bill is paid.
MyFuel can help record fuel and other car expenses, but this editorial worksheet is not a planning feature in the app. It does not send reminders, save the worksheet or calculate the result for you. If you have little history, begin with known payments and mark gaps. Add actual documents as they become available, keeping estimates visibly separate from confirmed amounts.
Detailed calculations and records
Use your fuel purchase records to plan that category. For a separate distance-based fuel estimate, see the fuel cost per 100 km guide; it covers fuel only. Use your own policy and payment schedule for insurance, dated receipts or quotes for servicing and repairs, and purchase documents for tyres. These sources let you explain each planned row without relying on a supposed average driver or an unsourced market price.
Track work and invoices with the car maintenance expense log.