MosoFin · Prepaid amortization, in plain words

We paid a year of insurance up front. How much of it is this month's cost?

When you pay for months of cover or service in advance, the cost belongs to those months. This skill spreads each advance payment across the months that it pays for. It tests your books against that schedule, and it writes draft entries for a person to post.

The 20-second version

You give it a company and a month. It reads your prepaid account, from your books or from your files. It asks you for the start and end date of each item, because your books do not hold them. It calculates this month's cost for each item and builds the schedule. It compares the schedule with your books and names each difference. It never changes your books.

The idea

$7,200 of insurance, and $600 of it is September's cost

A prepaid expense is a cost that you pay before you use it. It stays an asset on the balance sheet until you use it. Then it moves to the income statement as an expense. An accounting textbook uses insurance as its example. It spreads a $4,500 six-month policy at $4,500 ÷ 6 = $750 a month1.

Paid $7,200 on Tue 1 Sep 2026 for 12 months of cover, 1 Sep 2026 to 31 Aug 2027 SEPOCTNOVDEC JANFEBMARAPR MAYJUNJULAUG $600 $600$600$600$600 $600$600$600$600 $600$600$600 Expense $600 Still an asset at 30 September: 11 months × $600 $6,600 prepaid The dates come from the policy schedule that the owner gives the skill. The payment date does not set them.
Example figures for a made-up company, Northbrook Trading. 7,200 ÷ 12 = 600 a month, and 7,200 − 600 = 6,600 at 30 September. Accountants call this spread amortization, and the table of months a prepaid schedule.

Why are the 11 unused months an asset? Northbrook has a right to cover that it paid for and did not use yet. The international framework for financial reports defines an asset as a present economic resource that the business controls because of past events2. Northbrook reports under US rules, so this is the IFRS wording of the same idea.

The skill uses one of two ways to divide the cost, and you choose the way. Whole-month gives each month an equal share: $600. Daily gives each day an equal share: 7,200 ÷ 365 days × 30 days = $591.78 for September, and $6,608.22 stays. Both ways are correct. The skill uses one way for each item and records which. Northbrook uses whole-month.

The ledger holds the prepaid balance. It does not hold the schedule.
SKILL.md

Your books show the total in the prepaid account. They do not show what each part of it pays for, or when that cover ends. Those dates are on the policy and the contracts. So the skill always asks you for them.

What a run finds

Seven payments at Northbrook Trading for September 2026

Northbrook Trading keeps its books in US dollars, with a calendar year. The month is Tuesday 1 September to Wednesday 30 September 2026. The skill reads the account "Prepaid Expenses" through MosoFin, back to its oldest open item. It also reads the expense accounts, where it finds one more prepaid. The owner gives the cover dates from the policy schedule and the contracts.

ItemVendor and whatPaidAmount $Cover, from the ownerA month $What the skill sees
P0Ridgeway Mutual, liability insurance 2025-26Mon 1 Sep 20256,6001 Sep 2025 to 31 Aug 2026550The cover ended on 31 August. 550 of it stays in the account
P1Ridgeway Mutual, liability insurance 2026-27Tue 1 Sep 20267,2001 Sep 2026 to 31 Aug 2027600This year's policy. September's cost is 600
P2Cobalt Analytics, reporting software for a yearMon 15 Jun 20264,8001 Jul 2026 to 30 Jun 2027400Paid in June, and the cover starts in July. So the cost starts in July
P3Delta Packaging Machines, two-year maintenance contractMon 15 Dec 20253,6001 Jan 2026 to 31 Dec 202715024 months. Part of it is for more than 12 months ahead
P5Midwest Trade Expo, booth, memo "spring expo"Thu 20 Aug 20262,400Unknown—No dates. It stays on the schedule with blank dates and the flag "unknown"
P6Pixelform Studio, design software for a yearWed 1 Apr 20263,0001 Apr 2026 to 31 Mar 2027250All 3,000 went to expense in April. Nobody recorded it as a prepaid
D1Riverside Properties, a round sum to the landlordFri 1 May 20265,000——A refundable deposit. The lease says that the landlord returns the money, so it is not a prepaid
Example figures for a made-up company, in dollars. 7,200 ÷ 12 = 600, 6,600 ÷ 12 = 550, 4,800 ÷ 12 = 400, 3,600 ÷ 24 = 150 and 3,000 ÷ 12 = 250. P1's cover starts on its payment date, but the skill takes the date from the owner, and not from the payment.
September's insurance cost$6007,200 ÷ 12 months, for the 2026-27 policy
Policy left at 30 Sep$6,60011 months × 600, still an asset
Account as booked$22,100Against a schedule of $14,850, at 30 September
Dates unknown$2,400The expo booth. It stays with blank dates

Cobalt shows why the dates matter. Northbrook paid on 15 June, and the cover started on 1 July. If the cost started in the payment month, June would get 400. By 30 September the expense would be 1,600 instead of 1,200, which is 400 too much. The skill's rule:

Never derives coverage dates from the payment date or the invoice memo.
SKILL.md, Rules that never bend
The mistake it catches

The account agrees with itself, and it is still $7,250 too high

A quick test compares the account balance with a roll-forward. A roll-forward is the opening balance, plus new payments, minus the monthly cost. At Northbrook both give 22,100. That agreement proves only that the books add up. Both numbers come from the same books.

What the skill does

It compares the account with the schedule that it built from your dates
Prepaid Expenses, as booked$22,100
The schedule: 6,600 + 3,600 + 2,250 + 2,400$14,850
Difference$7,250
It names each part by its shape. 1,150 is September's cost, not yet booked. 1,100 is one whole month, August, that nobody booked. 5,000 is the deposit that the ledger tests flag. 1,150 + 1,100 + 5,000 = 7,250, with 0 unexplained.

The common shortcut

Compare the account with its own roll-forward
Prepaid Expenses, as booked$22,100
Roll-forward: 14,900 + 7,200 − 0$22,100
Difference$0, and it proves nothing
The result looks like a clean reconciliation. It shows nothing about the expired cover, the missed month or the deposit.

The skill uses the schedule that it built from your dates as the third test. Only the schedule knows what each part of the balance pays for. The skill's rule:

Never reports a roll-forward as a reconciliation.
SKILL.md, Rules that never bend

The books also show three problems before the skill sees any contract:

A missed month

No monthly entry in August

The monthly entry came every month from January to July, and then it stopped. The recurring entry in QuickBooks probably stopped without a warning. August's cost is 550 + 400 + 150 = 1,100.

A cost in one month

A year of software in April

Software subscriptions show one charge of 3,000 against a monthly average of 6,400 ÷ 12 = 533.33. That is 5.6 times the average. Pixelform's order form shows 12 months of cover.

Not a prepaid

A round sum to the landlord

A payment of 5,000 to a landlord looks like a refundable deposit. The lease says that the landlord returns the money. It belongs in a Deposits account.

The skill also tests if the balance is more than 12 months of new payments. Here it is not: 22,100 against 23,000. But P0's cover ended on 31 August, and 550 of it stays in the account. The schedule finds that amount.

What it proposes

Three draft entries, and one deposit to move

DraftWhat it doesAmount $Effect on Prepaid Expenses
E1September's cost: insurance 600, software 400, machine maintenance 1501,150Down 1,150
E2The missed August month: insurance 550, software 400, machine maintenance 150. The 550 also clears the cover of P0 that ended1,100Down 1,100
E3Pixelform: moves the unused months, October 2026 to March 2027, from expense to the asset. 6 × 2501,500Up 1,500
ActionMove the Riverside deposit to Deposits, after you read the lease. A recommendation, and not a draft entry5,000Down 5,000, when you post it
Example figures for a made-up company. After E1 to E3: 22,100 − 1,150 − 1,100 + 1,500 = 21,350. The schedule with Pixelform is 14,850 + 1,500 = 16,350. The 5,000 difference is the deposit. After you move it, 16,350 = 16,350.

Pixelform covers April 2026 to March 2027. Northbrook used six months, April to September. So the correction returns only the six unused months to the asset: 1,500, and not 3,000. The year 2026 is still open, so the correction goes through this year's expense.

Every draft carries this mark:

PROPOSED — NOT POSTED

The owner's answer: the 2026-27 policy costs 600 in September, and 600 in each month to August 2027. At 30 September, 6,600 stays. If you post E2 in September, September's report also shows August's 550 from last year's policy. That 550 belongs to August, and you decide the posting date. You also create the recurring entry again in QuickBooks. Next month, the skill tests that it ran.

Small items, and items for other skills

Two small payments go straight to expense, and their total stays in view

Northbrook's limit is $1,000. Accountants call this a materiality threshold. A trade association membership of 600 and domain and hosting of 480 are each below 1,000. Each covers 12 months, and each goes to expense when Northbrook pays it. The skill lists them, with a count of 2 and a total of 1,080.

It also shows what the limit does. Spread over 12 months, the two items cost 50 + 40 = 90 a month. As expense on payment, September carries 1,080, which is 990 more. The next 11 months carry none of them. The owner keeps $1,000. The skill applies your limit and never sets one. The accruals page for Northbrook uses a $500 limit for accruals. That is a different policy, and both limits are the owner's.

Outside this skill

Pinnacle Clinics paid Northbrook $36,000 for a year

That is money that a customer paid in advance. Accountants call it deferred revenue. This skill does nothing with it. The skill's files do not name a skill for it. On this site, the accruals-and-deferrals page covers it.

Not a prepaid

Huddle Notes, billed every month

Huddle Notes sends an invoice for 250 every month. That is an ordinary monthly cost. The skill's rule: a vendor with twelve invoices a year is not a prepaid.

Then the owner says: "Just post these in QuickBooks." The skill declines once, in plain words, and gives the owner the three drafts. It cannot change data in a connected system. Nothing in the books changes.

The balance sheet

What stays, and when you use it

After the drafts and the deposit move, Northbrook's prepaid total is $16,350. The skill splits it by time. The part for the next 12 months is current. The part for later is non-current.

Current, Oct 2026 to Sep 2027$13,5006,600 + 3,600 + 1,800 + 1,500
Non-current$450Delta, October to December 2027: 3 × 150
Not split$2,400The expo booth, until you give its dates. Total 13,500 + 450 + 2,400 = 16,350

Northbrook's chart of accounts has no account for non-current prepaids. The skill says so, because the $450 then shows as current on the balance sheet. The $16,350 is not money in the bank. Prepaid expenses never become cash, so they cannot pay a bill. Accountants still report them as current assets3.

Tax is a separate question

The skill calculates the cost for your books only. It says nothing about your income tax deduction. US federal tax has a 12-month rule. Under that rule, a business can sometimes deduct a payment in the year that it pays, if the benefit ends within the rule's limits. A business that starts to use the rule may need IRS approval first4. Your books still show 600 a month for the policy. Whether Northbrook can deduct the full premium in 2026 is a question for its accountant. The skill does not apply the rule and gives no tax amount.

How a run starts

Eight questions, in one message

The skill asks these first, in one short batch. It asks only for what it cannot already see.

  1. Use MosoFin for this run, or upload the data yourself?
    MosoFin is the connection to your books and the other platforms that you link. With it, the skill reads from there. Without it, you upload the files, and the tests are the same. The skill asks this only if your account has the MosoFin tools. If not, it says once that the run is manual.
  2. Which company, or which companies in a group?
    Each company gets its own schedule, with its name on it. The skill never puts two companies into one schedule. On the MosoFin path it asks you by name and never chooses for you.
  3. Which account or accounts hold your prepaids?
    Many books have more than one. Sometimes an "Other Current Assets" account holds many different items. On the MosoFin path the skill reads your chart of accounts first, then asks you to confirm.
  4. The start and end date of the cover for each open item, and your current prepaid schedule if you have one.
    Required. Your books cannot supply these dates. The skill asks item by item. If you do not know a date, the item goes on the schedule with blank dates and the flag "unknown". The skill never guesses a date.
  5. Your materiality threshold: the amount below which a payment goes straight to expense.
    This decides what goes on the schedule. You set it, and the skill never sets it. The skill can show what a proposed limit does in total. If you set none, the coverage sheet says so.
  6. Whole-month or daily?
    Both ways are correct, but one schedule must not mix them. The skill looks at how your past entries divide the cost, then asks you to confirm.
  7. Do you recover sales tax such as VAT or GST when you pay, and in which country?
    Where you can recover the tax, it comes out at payment, and the skill does not spread it. You state the policy. The skill still tests the books for recoverable tax inside the asset.
  8. Your main currency, and your policy for prepaids in a foreign currency.
    A prepaid is not a right to an amount of money, so it usually keeps its first exchange rate. You must give the currency. On the MosoFin path the skill reads it from your company record. It asks you to confirm the policy.

Then it reads the plan back and waits for your yes. The skill's own example also uses Northbrook. This page adapts it to the example above: no recoverable tax, because Northbrook is a US company, and dates for 5 of 6 items.

"Building the September prepaid schedule for Northbrook Trading, account Prepaid Expenses, from your Mosofin connection. Materiality $1,000, whole-month amortization, no recoverable tax (US). You gave coverage dates for 5 of 6 items; the other one goes on the schedule blank and flagged. Shall I go ahead?"
What you need

Connect once, or upload the prepaid account

Connected with MosoFin

Say yes, then give it what no ledger holds

  • It reads back the workspace and the company file by name, and waits for your yes
  • It reads a saved profile first, if you have one, and tells you that it uses it
  • It reads every entry in the prepaid account, the expense accounts, the bills and payments behind each item, and the chart of accounts
  • You still give it the cover dates. Your books do not hold them, and a memo such as "annual renewal" is not a date
  • You also give it your threshold, and your decision on deposits and on advances to related companies
Uploading instead

Bring the account, the dates and the chart

  • Prepaid account detail, back to the oldest open item and for at least 24 months, with vendor, description, reference, amount and payment date. CSV or XLSX, required
  • Cover start and end dates for each item, from the contracts, policy schedules or invoices. PDF, CSV, XLSX or typed in the chat, required. Unknown dates stay blank and flagged
  • Chart of accounts, with the prepaid and expense accounts. CSV or XLSX, required
  • Main currency, and the currency of each item if there is more than one. Typed in the chat, required
  • Your current prepaid schedule, if you have one. XLSX or PDF. Without it, the upload list calls the tie-out a roll-forward only
  • Expense ledger detail for the last 12 to 24 months. CSV or XLSX, recommended. Without it, the skill cannot find a prepaid that went to expense in one month
  • Bills behind each prepaid, with tax lines, and credits and receipts from prepaid vendors. CSV, XLSX or PDF, recommended. The coverage sheet names each test that the skill could not do
  • Threshold, tax country and how often you book the cost. Typed in the chat, recommended
What you get back

Seven sheets, from the schedule to the coverage

Prepaid scheduleOne row for each item, with its dates, amount, monthly cost, current and non-current parts, and a Source column: ledger, user or unknown.
Period detailEach item's cost, month by month, across its cover.
Tie-outThe account against the roll-forward and against the schedule. Only the schedule column comes from you.
Draft entriesThe month's entry, the catch-up entries and any correction, each with its months. All are proposals.
Cancellations and changesA log of each cancelled or changed item, with its effect.
Ledger findingsWhat the books showed without a contract: missed months, prepaids that nobody recorded, items that are not prepaids.
CoverageWhat the skill read, what it could not do and why, the unknowns for next month, and the threshold and method that it used.

It asks whether you want the sheets as an Excel file before it makes one. If you say no, you get the same sheets as tables in the chat. After you see the results, it offers to save your prepaid accounts, method, threshold, renewal months, cover dates and the errors that it found. It saves them only if you say yes.

What it never does

Six rules that never bend

  • Never reads MosoFin without asking. A connected account is not permission to read it.
  • Never reads anything before you answer the intake questions and say yes to the read-back.
  • Never writes, updates or deletes anything, in any system. Every entry that it makes is a proposal for a person to post.
  • Never takes cover dates from the payment date or the invoice memo. An unknown date stays blank, with the flag "unknown".
  • Never calls a roll-forward a reconciliation. The account balance and the roll-forward come from the same books. Only the schedule tests the balance. No schedule means no reconciliation.
  • Never sets the materiality threshold. It applies yours. It never shows a tie-out on test data as a clean result.
Words you'll hear

Seven terms, in plain English

Prepaid expense
A cost that you pay before you use it. It stays an asset until you use it1.
Amortization
Moving a prepaid into expense, a share at a time, over the months that it pays for.
Coverage period
The dates that a payment pays for. They come from the policy or the contract, and not from your books.
Prepaid schedule
A table of each prepaid item, its dates, its monthly cost and the amount that stays.
Roll-forward
The opening balance, plus new payments, minus the monthly cost. It shows how the account moved.
Materiality threshold
Your limit. Below it, a payment goes straight to expense and stays off the schedule.
Current and non-current
The part that you use in the next 12 months, and the part for later. Accountants report prepaids as current assets3.
Sources

Where the facts on this page come from

The sources are two sections of open accounting and finance textbooks, the IFRS conceptual framework and an IRS publication. We found each one on 28 October 2026 in search results. We did not open the pages, so follow each link for today's wording. What the skill does comes from the skill's own files.

  1. OpenStax: Principles of Accounting, Volume 1, 4.2 Discuss the Adjustment Process and Illustrate Common Types of Adjusting EntriesA prepaid expense is a cost that a business pays before it uses it. It stays an asset until the business uses it, and then it moves to expense. The example spreads a $4,500 six-month policy at $750 a month.
  2. IFRS Foundation: Conceptual Framework for Financial ReportingAn asset is a present economic resource that the entity controls because of past events. An economic resource is a right that can produce economic benefits. This is the international framework. Northbrook reports under US rules.
  3. OpenStax: Principles of Finance 2e, 19.1 What Is Working Capital?Supplies and prepaid expenses never become cash, so they cannot pay bills. Businesses still report them as current assets.
  4. IRS: Publication 538 (01/2022), Accounting Periods and MethodsFor US federal tax only. A prepaid expense is usually deductible only in the year that it applies, unless it qualifies for the 12-month rule. A business that starts to use these rules needs IRS approval first.

No outside authority backs the four ledger tests, the 5.6 ratio, the three-way tie-out and its variance shapes, the seven sheets or the draft mark. They are the skill's own rules. We made up Northbrook Trading, its vendors and every figure in the example for this page. Source 2 is international. Sources 1, 3 and 4 are US sources.

About this skill

This page explains prepaid-amortization-schedule, from the MosoFin finance skills library, MosoFin/mosofin-finance-skills on GitHub. Read the skill on GitHub → The skill is in the card format on the main branch. It merged in PR #1 on 26 October 2026, and a change from a bookkeeping audit followed on 27 October 2026. This page describes that version. Want the worked examples? Learn it step by step →