Skip to content

Free spreadsheets for your business

The cash register closing sheet and the inventory sheet we use in our videos. In Excel, so you can adapt them to your business.

Download them without creating an account and without leaving your email.

Preview of the cash register closing sheet: $30,000 float, $26,310 in cash sales, a $10,000 withdrawal, $46,310 expected and, with $44,810 counted, $1,500 short.

Swipe the sheet to see all of it.

Cash register closing

To balance the cash at the end of the day: what was there at opening, what came in, what went out and what should be in the register.

What it does

  • Adds the starting float, your cash sales and your withdrawals and deposits, and tells you how much should be in the drawer.
  • Compares it with what you counted and shows whether it balances, is over or is short, and by how much.
  • It comes with the video example: $30,000 float, five sales and one withdrawal. Delete them and enter yours.

What it does not do

  • It does not add cards, bank transfers, online sales or receipts: it balances cash only.
  • It does not record sales by itself: you enter them one by one.
Download spreadsheet

.xlsx file. It opens in Excel and in Google Sheets (File, Import).

Preview of the Stock sheet: Rice 1 kg 12, Oil 1 L 8, Sugar 1 kg 15, Noodles 400 g 20 and Tea 100 bags 6, and a column to enter what you counted.

Swipe the sheet to see all of it.

Inventory

To know how much you have left of each product and whether your sheet is up to date, with the five-product test from the video.

What it does

  • It is the same sheet as in the video: Product and Stock, with the same five products.
  • It has the five-product test: you enter what you counted on the shelf and it shows whether it matches what your sheet says.

What it does not do

  • It does not deduct stock when you sell or warn you when something is running out.
  • It does not connect to anything: it is a manual count.
Download spreadsheet

.xlsx file. It opens in Excel and in Google Sheets (File, Import).

Want us to let you know when there are new spreadsheets?

It is optional: the two spreadsheets above download without leaving anything.

Usamos tus datos sólo para lo que marcaste. Los guardamos 12 meses y puedes pedir que los borremos escribiendo a contacto@webiados.com. Lee la política de privacidad.

How we solve it

If one day the spreadsheet is too small for you, Rofex balances your register cash when you close the day, without you typing anything by hand.

See Rofex plans