Prepayment & Deposit Listing — Excel Template
Track prepayment amortisation and deposits as at any date — built for accountants and small businesses
S$20.00
Who is this for?
Accountants, bookkeepers and small business owners who need a clean, professional way to track prepayments and deposits — without building formulas from scratch.
What makes this different?
Just like our Fixed Assets Register, this template uses a Schedule As At Date — key in any date and the entire listing recalculates instantly. Perfect for month-end reporting, audit purposes and year-end closing.
What's inside:
📋 Prepayment tab — Track unlimited prepayments. Monthly amortisation, balance remaining and status all calculate automatically based on your Schedule As At Date.
💰 Deposit tab — Track all deposits paid. Outstanding amount auto-zeros when deposit is settled. Invoice amount always stays visible for reference.
🔄 Settlement tab — Log deposit returns and forfeitures. Description, vendor and original amount auto-fill from Deposit tab.
📊 Dashboard — Total prepayment balance, monthly charge, expiring within 3 months alert ⚠️, total deposits outstanding, returned and forfeited amounts.
⚙️ Setup — Company name and financial year end. One setup, everything flows.
Key features:
— Schedule As At Date — see exactly what your listing looked like on any date
— Forfeited amount auto-calculates — paid $24k, got back $20k, forfeited = $4k automatically
— Prepayments not yet started show full balance — no premature amortisation
— Fully amortised prepayments flagged red automatically
— Active deposits flagged green, returned orange, forfeited red
— Yellow cells = your input. Green cells = auto-calculated.
Instant download. One-time payment. No subscription.
Questions? templates@getbookjobs.com
