Updated April 2026

Mastering Proration Calculations Step by Step for the Indonesia Property Agent Exam

Last updated: April 2026

For aspiring real estate professionals in Indonesia, passing the LSP Broker Properti certification (often facilitated by AREBI) requires more than just a theoretical understanding of property laws. You must also demonstrate practical financial competence. One of the most critical mathematical skills you will be tested on is calculating prorations. If you want to ensure you are fully prepared for all aspects of the test, be sure to review our Complete Indonesia Property Agent Exam Exam Guide.

Proration is the equitable division of property expenses or income between the buyer and the seller, based on the exact date the property legally changes hands—which, in Indonesia, is the date the Akta Jual Beli (AJB) is signed before a Pejabat Pembuat Akta Tanah (PPAT). This article will walk you through proration calculations step by step, focusing on standard Indonesian property expenses like PBB (property tax), IPL (maintenance fees), and prepaid rent.

Understanding Proration in Indonesian Real Estate

When a property transaction closes, there are almost always overlapping financial obligations. A seller may have already paid the annual property tax for the entire year, but they are only living in the home for the first few months. Conversely, a seller might have collected a full year's rent in advance from a tenant, but they are selling the property halfway through the lease.

Proration ensures that the seller pays only for the days they owned the property, and the buyer pays only for the days they own the property.

In the Indonesian property market, the most commonly prorated items include:

  • Pajak Bumi dan Bangunan (PBB): The annual land and building tax.
  • Iuran Pemeliharaan Lingkungan (IPL): The environmental maintenance fee, common in strata title apartments (Rusun) and gated cluster communities.
  • Prepaid Rent: Common when selling a tenanted investment property (Hak Sewa).

Just as you must understand mortgage mechanics and interest rate types (fixed vs adjustable) to advise buyers, you must master proration to ensure a fair and accurate closing statement for both parties.

The Core Proration Formula

Regardless of what you are prorating, the foundational step-by-step formula remains the same. For the Indonesia Property Agent Exam, follow these four steps:

  1. Determine the Total Amount and the Period: Identify the total cost of the bill and the timeframe it covers (e.g., annual, monthly).
  2. Calculate the Daily Rate: Divide the total amount by the number of days in the period. Note: The exam will usually require a standard 365-day calendar year, but occasionally may specify a 360-day "banker's year." Always read the prompt carefully.
  3. Count the Days: Determine exactly how many days belong to the seller and how many belong to the buyer. (Standard practice assumes the buyer owns the property on the day of closing).
  4. Multiply to Find the Prorated Share: Multiply the daily rate by the number of days the responsible party owes.

Step-by-Step Proration Calculations (Exam Scenarios)

Scenario 1: Prorating Pajak Bumi dan Bangunan (PBB)

The Scenario: A seller has paid the annual PBB of Rp 3,650,000 on February 1st for the current calendar year (January 1 – December 31). The AJB signing (closing) takes place on August 15. The buyer owns the day of closing. How much does the buyer owe the seller at closing?

Step 1: Total Amount & Period
Total PBB = Rp 3,650,000. The period is a full 365-day year.

Step 2: Calculate Daily Rate
Rp 3,650,000 ÷ 365 days = Rp 10,000 per day.

Step 3: Count the Days
The seller owned the property from January 1 through August 14. The buyer owns it from August 15 through December 31.
Let's count the buyer's days:
August: 17 days (31 - 15 + 1)
September: 30 days
October: 31 days
November: 30 days
December: 31 days
Total Buyer Days = 139 days

Step 4: Multiply
139 days × Rp 10,000 = Rp 1,390,000.

Conclusion: Because the seller already paid the full year, the buyer must reimburse the seller. The closing statement will show a Debit to the Buyer and a Credit to the Seller for Rp 1,390,000.

Scenario 2: Prorating Iuran Pemeliharaan Lingkungan (IPL)

The Scenario: You are facilitating the sale of a strata title apartment in Jakarta. The monthly IPL is Rp 1,500,000, which the seller pays on the 1st of every month. The transaction closes on September 11. The buyer owns the day of closing. September has 30 days.

Step 1 & 2: Amount & Daily Rate
Total IPL = Rp 1,500,000. Period = 30 days.
Daily Rate = Rp 1,500,000 ÷ 30 = Rp 50,000 per day.

Step 3: Count the Days
The seller owned the unit from Sept 1 to Sept 10 (10 days).
The buyer owns the unit from Sept 11 to Sept 30 (20 days).

Step 4: Multiply
Buyer's share = 20 days × Rp 50,000 = Rp 1,000,000.

Conclusion: The buyer owes the seller Rp 1,000,000 at closing to reimburse them for the remainder of the month's IPL.

Visualizing Proration Allocation

To better understand how financial responsibilities are split during a transaction, review the chart below, which visualizes the PBB tax allocation from our first scenario.

Annual PBB Allocation Split (Total: Rp 3,650,000)

Scenario 3: Prorating Prepaid Rent

The Scenario: A seller is selling a house in Bali that is currently rented out. The tenant paid a 1-year upfront lease of Rp 120,000,000, covering January 1 to December 31. The property sale closes on October 1. The buyer owns the day of closing.

Note: In Indonesia, it is very common for residential leases to be paid 1 to 2 years in advance. When the property is sold, the new owner must honor the existing lease, and the seller must transfer the unused portion of the rent to the buyer.

Step 1 & 2: Amount & Daily Rate
Annual Rent = Rp 120,000,000. Period = 365 days.
Daily Rate = Rp 120,000,000 ÷ 365 = Rp 328,767.12 per day.
Alternatively, since the closing is exactly on the 1st of a month, we can use months instead of days for simpler math: Rp 120,000,000 ÷ 12 months = Rp 10,000,000 per month.

Step 3: Count the Period
The buyer will own the property for exactly 3 full months of the lease: October, November, and December.

Step 4: Multiply
3 months × Rp 10,000,000 = Rp 30,000,000.

Conclusion: The seller has already collected this money but will not own the property for those three months. Therefore, the closing statement will show a Debit to the Seller and a Credit to the Buyer for Rp 30,000,000.

Exam Tips for Proration Questions

Proration questions are easy points on the exam if you read carefully. Here are a few tips to keep in mind:

  • Who owns the day of closing? Unless stated otherwise, standard real estate exams assume the buyer owns the property on the day of closing. This means the buyer pays for that day.
  • 360 vs. 365 Days: The "Banker's Year" uses 12 months of exactly 30 days each (360 total). The standard calendar uses 365. If the exam does not specify, use 365, but look at the multiple-choice answers—if your 365-day math doesn't match, recalculate using 360.
  • Credit vs. Debit: Always ask yourself: "Who already paid?" If the seller prepaid a bill (like PBB), the buyer owes the seller (Credit Seller, Debit Buyer). If the bill is paid in arrears (at the end of the year), the seller owes the buyer for the time they lived there.

Practicing these formulas repeatedly is the best way to prepare. We highly recommend utilizing the best study materials and resources, including mock exams that feature closing statement scenarios.

Furthermore, when calculating prorations for your clients in real life, absolute transparency is required. This is especially true if you are representing both the buyer and the seller. Make sure you are well-versed in the risks and rules of dual agency to ensure you maintain your fiduciary duties to both parties while handling their financial settlements.

Frequently Asked Questions (FAQs)

1. Does the PPAT handle proration calculations in Indonesia?

While the PPAT (Pejabat Pembuat Akta Tanah) handles the legal transfer of the property and the calculation of transfer taxes (BPHTB and PPh Final), they do not typically calculate prorations for IPL, utilities, or rent. This is the responsibility of the professional property agent to ensure a smooth handover between buyer and seller.

2. What happens if the PBB for the current year hasn't been issued yet?

In Indonesia, PBB bills (SPPT PBB) are usually issued in the first quarter of the year. If a transaction closes early in the year before the new bill is issued, agents typically base the proration on the previous year's PBB amount, with an agreement written into the handover document regarding any discrepancies.

3. Are utility bills (PLN and PDAM) usually prorated?

In practice, post-paid electricity (PLN) and water (PDAM) are rarely prorated by the day. Instead, the seller usually pays the final bill up to the date of handover, or the meter is read on the day of closing, and the seller pays the exact usage up to that number.

4. If an exam question doesn't specify leap year, what should I use?

Always assume a standard 365-day year for proration calculations on the LSP/AREBI exam unless the question specifically states that it is a leap year (366 days) or asks you to use a statutory banker's year (360 days).

5. Can a buyer and seller agree to ignore prorations?

Yes. Prorations are a matter of negotiation. A buyer and seller can agree in the Perjanjian Pengikatan Jual Beli (PPJB) that the seller will cover all PBB for the year, or that no IPL will be prorated. However, for the sake of the exam, you must calculate it exactly as the question dictates.

---