ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Cash book
Excel template · Cash

Cash book template

Record cash transactions in date order: the template calculates the balance after each row, shows period totals and highlights a negative balance in red.

Updated:
Valtera_Cash_book_EN.xlsx · 20 KB · Sheets: Guide, Cash book
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Cash_book_EN.xlsx — Cash book · Preview with sample data
PeriodOctober 2026
Opening cash balance1,850
DateDocument typeDocument no.DescriptionCounterpartyReceiptPaymentBalance
01.10.2026Receipt1Cash salesRetail sales1,2403,090
02.10.2026Payment1Cash deposited to bankKapital Bank1,5001,590
03.10.2026Payment2Office suppliesBaku Office Furniture86.401,503.60
06.10.2026Receipt2Cash withdrawn from bankKapital Bank6002,103.60
07.10.2026Payment3Expense report: business tripR. Aliyev1451,958.60
08.10.2026Receipt3Cash salesRetail sales9802,938.60
09.10.2026Payment4Post and courierAzerpost18.502,920.10
10.10.2026Receipt4Customer paymentNargiz Pharmacy4203,340.10
13.10.2026Payment5Cash deposited to bankKapital Bank1,2002,140.10
13.10.2026Receipt5Cash salesRetail sales1,1153,255.10

What the template includes

  • Period and opening balance.
  • Document type is chosen from a list: Receipt (cash receipt voucher) or Payment (cash payment voucher).
  • Date, number, description, counterparty, receipt, payment and running balance. 300 rows.
  • Total receipts, total payments and closing balance.

Useful rules

  • The cash balance can never be negative: a negative balance means an error in the records or an unrecorded receipt.
  • At the end of each day, reconcile the actual cash in the till with the balance in the book.
  • Collect expense reports for cash advances on time.
  • Reconcile cash transactions with cash register data and bank deposits.

For all cash movements: cash flow statement template.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.