Skip to content
IGCSE·Tuition
Accounting · Lesson

Calculate a prepaid amount from dates

The question gives a payment date and a cover period, and the number you need is hiding between them.

On this page
  1. How do you turn dates into months?
  2. How do you calculate the prepayment, step by step?
  3. Worked example
  4. The mistake to watch for
  5. Check yourself
  6. Where this leads next

A prepaid amount is the part of a payment that covers a period after the year end. To find it from dates, work out the cost per month, then multiply by the months that fall after the year end. It appears in questions about insurance, rent, rates, subscriptions and licences, where the question gives a payment date and how long the payment lasts.

This lesson follows allocating an expense to the correct period and belongs to the module on accruals and prepayments.

How do you turn dates into months?

Most IGCSE questions use whole months, so a timeline of month names is the safest tool. Write the first and last month of cover, then tick each month and mark the year end.

The three numbers you need are:

  • Months covered in total by the payment.
  • Months used up to the year end, which form the expense.
  • Months remaining after the year end, which form the prepayment.

The monthly cost is the payment divided by the total months covered. Used months plus remaining months must equal total months, so you always have a check.

How do you calculate the prepayment, step by step?

  1. List the months of cover from the payment date.
  2. Divide the payment by the number of months covered to get the monthly cost.
  3. Count the months up to and including the year end. These are used.
  4. Count the months after the year end. These are prepaid.
  5. Multiply the monthly cost by each count, then check that expense plus prepayment equals the payment.

Worked example

Kedai Buku Teratai has a year end of 31 December 2025. On 1 October 2025 it paid an insurance premium of RM 2,400 for 12 months, covering 1 October 2025 to 30 September 2026.

Step 1, monthly cost: 2,400 ÷ 12 = RM 200 per month.

Step 2, months used in 2025: October, November and December, so 3 months. Expense = 200 × 3 = RM 600.

Step 3, months remaining: January to September 2026, so 9 months. Prepayment = 200 × 9 = RM 1,800.

Step 4, check: 3 + 9 = 12 months, and 600 + 1,800 = RM 2,400, the amount paid.

The insurance account then looks like this:

DebitRMCreditRM
1 Oct Bank2,40031 Dec Income statement600
31 Dec Balance c/d (prepayment)1,800
2,4002,400
1 Jan Balance b/d1,800

Both sides total RM 2,400, and the RM 1,800 debit balance brought down is the asset shown in the statement of financial position.

The mistake to watch for

A common slip is to count one month too many by running the timeline past the year end.

Mistaken answer: Used 4 months, so expense RM 800 and prepayment RM 1,600.

The student counted the dates as 1 October to 1 January, which adds a fourth month that belongs to 2026.

The correction is to list the months by name: October, November, December. That is 3 months, so the expense is RM 600 and the prepayment is RM 1,800.

The mistaken answer still passes the quick check that used plus remaining months equal 12, because the error moved a month from one side to the other. So also check the count against the dates: the policy started in October, and January is the first month after the year end.

Check yourself

Try these on paper, then open each answer.

1. Pasar Muda paid RM 9,000 rent on 1 November 2025 for 6 months, covering November 2025 to April 2026. The year end is 31 December 2025. Find the expense and the prepayment.

Show answer

Monthly cost = 9,000 ÷ 6 = 1,500. Used: November and December, 2 months, so expense = RM 3,000. Remaining: January to April, 4 months, so prepayment = 1,500 × 4 = RM 6,000. Check: 3,000 + 6,000 = 9,000.

2. A salon paid RM 1,800 for insurance on 1 April 2025 for 12 months. The year end is 31 December 2025. Find the prepayment.

Show answer

Monthly cost = 1,800 ÷ 12 = 150. Used: April to December, 9 months, so expense = 1,350. Remaining: 3 months, so prepayment = 150 × 3 = RM 450. Check: 1,350 + 450 = 1,800.

3. A tutor paid RM 960 for a software subscription on 1 March 2026 for 12 months. The year end is 30 June 2026. Find the expense for the year.

Show answer

Monthly cost = 960 ÷ 12 = 80. Used: March, April, May and June, 4 months, so expense = 80 × 4 = RM 320. Prepayment = 80 × 8 = RM 640. Check: 320 + 640 = 960.

Where this leads next

The same dates logic works for money coming in, which is the subject of treating income received in advance. Practise the ledger layout in the double-entry and ledger trainer. When you want to check a share of the year, the percentage-base explorer shows how a part relates to its whole.

If month counting still goes wrong under time pressure, that is something our teachers can work on in online one-to-one Accounting tuition.

Questions people ask

How do I find the prepaid amount when a payment covers part of next year?

Work out the monthly cost by dividing the payment by the months covered. Count the months that fall after the year end. Multiply the monthly cost by those months. For RM 2,400 covering 12 months, with 9 months after year end, the prepayment is 200 × 9 = RM 1,800.

How many months is 1 October to 31 December?

Three months: October, November and December. The range starts on the first day of a month and ends on the last day of a month, so it covers whole months. List the month names and count them instead of subtracting numbers.

Where does a prepayment appear in the final accounts?

A prepayment is a current asset in the statement of financial position, because the business has paid for a benefit still to come. It is also deducted from the expense in the income statement, so that only the part used in the year is charged.

Updated:

Your next step

If counting months from a date is where your answers drift, a one-to-one teacher can watch you build the timeline and show you a check that stops the off-by-one slip.

Paid one-hour trial at your assigned teacher’s confirmed rate, starting from RM80.

Tuition is arranged with a parent or guardian. Send them this page on WhatsApp and they can enquire for you.

Parents: enquire here

  • 9,000+ students helped through our service
  • 9+ years helping IGCSE students