Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingPetty Cash Log

SpreadsheetAccounting & BookkeepingFree

Petty Cash Log

An audit-ready petty cash book with running balance, cash count, shortages and the top-up needed.

Shown with sample data

Colour

Petty Cash Log

An audit-ready petty cash book with running balance, cash count, shortages and the top-up needed.

Book balance
$111.90
What should be in the tin
Spent this period
$188.10
Top-up needed
$188.10
To restore the float
Count difference
$0
Counted cash minus book balance; $0 when balanced
Spending by category
  • Repairs$4524%
  • Postage$31.5017%
  • Travel$31.5017%
  • Cleaning$31.4017%
  • Office supplies$24.6013%
  • Refreshments$24.1013%

How to use it

  1. 1Set the float amount on the Check sheet and record the opening float as the first line (type Top-up).
  2. 2Record every payment as an Expense with a receipt number, category and approver.
  3. 3Count the cash in the tin by denomination on the Count sheet; the Check sheet shows any shortage or overage straight away.
  4. 4At month end, top up by the amount shown and post spending by category to your books.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Run petty cash the way auditors expect: a fixed float, every payment with a receipt number and approver, a running balance on every line, and a cash count by note and coin that is compared with the book balance to show any shortage. The top-up needed to restore the float is worked out for you, and spending is summarised by category for posting to the books.

Who it’s for

  • Offices, shops and schools with a cash float
  • Month-end posting of small expenses
  • Passing an audit without missing receipts

What’s included

  • Cash book sheet: Every movement in and out of the float, with the balance after each one.
  • Count sheet: The cash in the tin, counted note by note.
  • Check sheet: Counted cash against the book balance, and the top-up to restore the float.

How to use it

  1. 1Set the float amount on the Check sheet and record the opening float as the first line (type Top-up).
  2. 2Record every payment as an Expense with a receipt number, category and approver.
  3. 3Count the cash in the tin by denomination on the Count sheet; the Check sheet shows any shortage or overage straight away.
  4. 4At month end, top up by the amount shown and post spending by category to your books.

Tips

  • Keep receipts numbered in the same order as the log.
  • Two people should count the cash together.
  • Investigate any difference the same day.

Questions

What is an imprest float?

A fixed amount (for example $300) that is topped back up to the same level, so receipts plus cash always equal the float.

Related searchespetty cash logpetty cash bookcash reconciliationoffice expensesimprest

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounting & BookkeepingFree

Petty Cash Log

An audit-ready petty cash book with running balance, cash count, shortages and the top-up needed.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More accounting & bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Invoice Tracker2 sheets

Outstanding

$9,940

Overdue

$8,690

Average days to pay

15

ABCD
1InvoiceClientSentDue
21001Harbor LogisticsSep 15Sep 29
31002Northwind StudioSep 22Oct 6
41003BluepeakSep 30Oct 14
51004Juniper & CoOct 8Oct 22
Invoices
SpreadsheetBilling & Receivables

Invoice Tracker

Every invoice you have sent with due dates, payments received, days late and who to chase.

10 min setupPreview
Accounts Receivable Aging Report2 sheets

Total outstanding

$47,805

Overdue

$31,455

Over 60 days

$12,680

Balance by age
$17k
$16k
$11k
$2,150
$1,980
1-30Current61-9031-6090+
SpreadsheetAccounting & Bookkeeping

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ