This is what CloseClerk hands you at month-end, shown with made-up numbers for a fictional company (Harbor Studio LLC). It’s the same kind of Excel file you’d get for your own books: live formulas, a tie-out to QuickBooks, and the journal entry waiting for your approval.
One row per prepaid. Amortization, accumulated amounts, balances and totals are formulas in the Excel file, not typed numbers.
Swipe sideways to see every column.
| Prepaid | Start | Months | Total cost | Per month | Months used | Amortized to date | Remaining |
|---|---|---|---|---|---|---|---|
| Business insurance Hartwell Insurance | Jul 1, 2026 | 12 | 7,200.00 | 600.00 | 3 | 1,800.00 | 5,400.00 |
| Design software licence Cloudlane Software | Jan 1, 2026 | 12 | 4,800.00 | 400.00 | 9 | 3,600.00 | 1,200.00 |
| Website hosting (2 years) Northfield Hosting | Apr 1, 2026 | 24 | 2,400.00 | 100.00 | 6 | 600.00 | 1,800.00 |
| Total | 14,400.00 | 1,100.00 | 6,000.00 | 8,400.00 |
CloseClerk reads the prepaid account’s balance from QuickBooks and compares it with the schedule. If they don’t agree, it tells you by how much and asks how to handle it. It never forces a match.
| Schedule ending balance | 8,400.00 |
| Prepaid Expenses per QuickBooks, Sep 30, 2026 | 8,400.00 |
| Difference | 0.00 |
| Account | Description | Debit | Credit |
|---|---|---|---|
| Insurance Expense | September prepaid amortization | 600.00 | |
| Software & Subscriptions | September prepaid amortization | 500.00 | |
| Prepaid Expenses | September prepaid amortization | 1,100.00 | |
| Total | 1,100.00 | 1,100.00 | |
All names and numbers on this page are fictional.