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.
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.
$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.
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.
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.
| Item | Vendor and what | Paid | Amount $ | Cover, from the owner | A month $ | What the skill sees |
|---|---|---|---|---|---|---|
| P0 | Ridgeway Mutual, liability insurance 2025-26 | Mon 1 Sep 2025 | 6,600 | 1 Sep 2025 to 31 Aug 2026 | 550 | The cover ended on 31 August. 550 of it stays in the account |
| P1 | Ridgeway Mutual, liability insurance 2026-27 | Tue 1 Sep 2026 | 7,200 | 1 Sep 2026 to 31 Aug 2027 | 600 | This year's policy. September's cost is 600 |
| P2 | Cobalt Analytics, reporting software for a year | Mon 15 Jun 2026 | 4,800 | 1 Jul 2026 to 30 Jun 2027 | 400 | Paid in June, and the cover starts in July. So the cost starts in July |
| P3 | Delta Packaging Machines, two-year maintenance contract | Mon 15 Dec 2025 | 3,600 | 1 Jan 2026 to 31 Dec 2027 | 150 | 24 months. Part of it is for more than 12 months ahead |
| P5 | Midwest Trade Expo, booth, memo "spring expo" | Thu 20 Aug 2026 | 2,400 | Unknown | — | No dates. It stays on the schedule with blank dates and the flag "unknown" |
| P6 | Pixelform Studio, design software for a year | Wed 1 Apr 2026 | 3,000 | 1 Apr 2026 to 31 Mar 2027 | 250 | All 3,000 went to expense in April. Nobody recorded it as a prepaid |
| D1 | Riverside Properties, a round sum to the landlord | Fri 1 May 2026 | 5,000 | — | — | A refundable deposit. The lease says that the landlord returns the money, so it is not a prepaid |
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 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 datesThe common shortcut
Compare the account with its own roll-forwardThe 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:
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 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.
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.
Three draft entries, and one deposit to move
| Draft | What it does | Amount $ | Effect on Prepaid Expenses |
|---|---|---|---|
| E1 | September's cost: insurance 600, software 400, machine maintenance 150 | 1,150 | Down 1,150 |
| E2 | The missed August month: insurance 550, software 400, machine maintenance 150. The 550 also clears the cover of P0 that ended | 1,100 | Down 1,100 |
| E3 | Pixelform: moves the unused months, October 2026 to March 2027, from expense to the asset. 6 × 250 | 1,500 | Up 1,500 |
| Action | Move the Riverside deposit to Deposits, after you read the lease. A recommendation, and not a draft entry | 5,000 | Down 5,000, when you post it |
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.
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.
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.
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.
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.
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.
Eight questions, in one message
The skill asks these first, in one short batch. It asks only for what it cannot already see.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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?"
Connect once, or upload the prepaid account
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
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
Seven sheets, from the schedule to the coverage
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.
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.
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.
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.
- 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.
- 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.
- 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.
- 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.
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 →