← All prebuilt solutions
Bookkeeping & Compliance

Petty Cash Book

An imprest petty cash book – analysed, reconciled and VAT-ready

£20

Secure checkout. Your download link is sent as soon as payment clears.

Petty Cash Book

Overview

Most businesses keep a little cash for stamps, milk, parking and the odd emergency repair – and most lose track of it. This workbook runs your petty cash on the 'imprest' system used by accountants: you start with a fixed float, record every payment out and every top-up in, and top the tin back up to the float by exactly what's been spent. The cash book keeps a running balance and tells you the top-up needed at any moment. It produces the traditional analysed petty cash book for any month, a full-year analysis, a VAT summary by month and VAT quarter, a cash count that reconciles the notes and coins in the tin to the book, and a printable petty cash voucher.

Price
£20
Who it’s for
Bookkeeping & Compliance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Cash Book

Every payment and top-up with the running balance and checks. What you do: enter the yellow columns.

Cash Book
Monthly Analysis

Step 2

Monthly Analysis

The traditional analysed petty cash book for one month. What you do: type any date in the month.

Step 3

Year Analysis

Every month of the year by category, with month-end balances and a sorted category table. What you do: nothing to enter.

Year Analysis
VAT Summary

Step 4

VAT Summary

VAT on receipts, reclaimable and not reclaimable – by month and by VAT quarter. What you do: nothing to enter.

Who it is for

Made for people like you

  • Example – text
  • Offices, practices and shops with a cash tin – A clear record of every penny, with the balance and the top-up needed always on screen.
  • Practice managers and administrators – Automatic checks for missing receipts, missing categories, duplicate vouchers, date order and a negative balance.
  • Bookkeepers – Monthly totals by category (net of VAT) ready to post, plus a cross-check that the analysis agrees to the cash paid out.
  • VAT-registered businesses – VAT reclaimable by month and by VAT quarter – only where there's a VAT receipt and the category allows it.
  • Owners and directors – A dashboard, regular cash counts with a record of each one, and signed vouchers for every payment.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter the business name, petty cash holder, float, the date the year starts, the opening cash balance, whether you're VAT registered, the low-cash warning level, the count tolerance and your VAT quarters.
  2. Authorisers and categories – List the people who can authorise payments, and check the categories – rename, add or remove them to suit your business.
  3. Record each payment – On the Cash Book, enter the date, voucher number, description, who was paid, the category, the net amount and VAT from the receipt, whether there's a receipt and VAT receipt, and who authorised it.
  4. Top up – When cash runs low, withdraw the amount shown in 'Top-up needed to restore the float' and enter it on a new line in 'Cash in / top-up £'.
  5. Count the tin – On Cash Count, enter the count date and the number of each note and coin. The result shows whether the tin agrees with the book.
  6. Month end – Pick the month on Monthly Analysis, check the cross-check is ✓, print it with the vouchers and post the totals to your accounts.
  7. VAT quarter end – Use the VAT Summary to check the petty cash VAT included in your VAT return.

Key features

  • Cash book for up to 500 entries with a running balance, automatic checks and the exact top-up needed to restore your float.
  • Traditional analysed petty cash book for any month – receipts, payments, VAT and up to 12 analysis columns – plus a full year analysis.
  • VAT summary by month and by VAT quarter, showing what you can reclaim and what you can't.
  • Cash count with notes and coins, reconciliation to the book balance, count history, and a printable petty cash voucher.

What’s included

  • Dashboard – Balance, top-ups, spend and reconciliation
  • Settings – Float, VAT, categories, authorisers
  • Cash Book – Every payment and top-up
  • Monthly Analysis – Analysed petty cash book for a month
  • Year Analysis – Month by month for the year
  • VAT Summary – VAT by month and quarter
  • Cash Count – Count the tin and reconcile
  • Voucher – Print a petty cash voucher
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions