Skip to content

Prepaid & deferred release

A premium paid on the 17th does not release in twelve equal slices. Day-weighted, or even — your call.

Runs
In this tab
Data sent
None
Rounding
Once, at the end
Also in
The Chrome extension

Prepaid & deferred release, worked

Showing a worked example — type over it

ISO 4217 code — sets the decimals: JPY 0, USD 2, KWD 3.

Result

Released in total12,000.00
#DateReleaseRemaining
12026-10-311,000.0011,000.00
22026-11-301,000.0010,000.00
32026-12-311,000.009,000.00
42027-01-311,000.008,000.00
52027-02-281,000.007,000.00
62027-03-311,000.006,000.00
72027-04-301,000.005,000.00
82027-05-311,000.004,000.00
92027-06-301,000.003,000.00
102027-07-311,000.002,000.00
112027-08-311,000.001,000.00
122027-09-301,000.000.00

How the prepaid & deferred release works.

Prepaid amortisation even, or by days split at calendar month-ends.

Quoted from the toolbelt spec, the document this tool was built against.

Where these numbers come from.

Negatives are parenthesised because that is what a statement does. The rest is four promises.

More in schedules that tie

Read it in context

The same number, elsewhere.

A calculator answers the question once. These carry the answer into a product, name what it computed, and argue the method.

Works in your QuickBooks Online or Xero file

Get your books closed every month

Lopifi is building AI bookkeeping that keeps your books closed on US GAAP as transactions happen, with a CPA review every quarter, for $200 a month. We’re not open yet.

$200/month when we open. No card now.