Skip to content
Petty Cash Log cover: a sample sheet with cash paid out, payments made and largest payment and a bar chart, beside the Dashboard, Log and Count tabs

Petty Cash Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Petty Cash Log suits an office, shop or club that keeps a small cash float for everyday costs. The Log tab lists each payment with its date, who was paid, its purpose, the amount and the receipt number. The Dashboard gives total payouts, how many payments were made and how large they were and a chart of spending by purpose.

Fill in the Count tab every Friday or whenever the float is topped up. Enter the float you issued and count the notes and coins into the table, and the sheet works out the expected cash and the difference. A small gap is common, so note it and check the receipts before you top up the float. Keep the box locked and the count sheet with the log.

Useful for

  • Keeping a small float for office supplies and postage
  • Counting the cash box each Friday
  • Explaining a short or over count to the owner

What's included

  • 4 tabs: Dashboard, Log, Count, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: a table
  • Count: a ready-to-fill form
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What if the count does not match the expected cash?

Look at the difference first. Check the receipts from the same period, then recount the box with another person present. Write the reason in the Count tab before you put the float back in the box.

How do I record a payment without a receipt?

Enter the payment in the log and write a note in the Receipt column, such as No receipt, and add who signed it off. The Dashboard still counts the payment, so the spending total stays complete.

Can I change the purposes in the list?

Yes. Edit the options in the Purpose column on the Log tab through the data validation menu, and rename the matching rows in the breakdown on the Dashboard. The two lists must use the same names, or the totals will miss those payments.

  • #expense-tracker
  • #petty-cash-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…