Sample workpaper

Sample workpaper

Prepaid expenses: September close

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.

1. The schedule

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.

PrepaidStartMonths Total costPer monthMonths usedAmortized to dateRemaining
Business insurance
Hartwell Insurance
Jul 1, 2026127,200.00600.0031,800.005,400.00
Design software licence
Cloudlane Software
Jan 1, 2026124,800.00400.0093,600.001,200.00
Website hosting (2 years)
Northfield Hosting
Apr 1, 2026242,400.00100.006600.001,800.00
Total14,400.00 1,100.006,000.00 8,400.00

2. Tie-out to QuickBooks

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 balance8,400.00
Prepaid Expenses per QuickBooks, Sep 30, 20268,400.00
Difference0.00

3. The journal entry CloseClerk proposes

AccountDescriptionDebit Credit
Insurance ExpenseSeptember prepaid amortization600.00
Software & SubscriptionsSeptember prepaid amortization500.00
Prepaid ExpensesSeptember prepaid amortization1,100.00
Total1,100.00 1,100.00
Nothing is posted yet. You read the schedule and this entry, ask for changes if something looks off, or approve it. Only then does CloseClerk post it to QuickBooks, with this workpaper attached so the support is right there for your audit trail.

All names and numbers on this page are fictional.

← Back to CloseClerk

Terms · Privacy · Security · FAQ · Support