Vencru Logo

Free template to track your business transactions (income and expenses)

Track your transactions by entering your sales and expenses numbers in the Excel template

excel cash book template by Vencru

Get the Template

Enter your information below to instantly get access to your free copy

What’s a cash book template?

The cash book template is used to track cash transactions (income and expenses) to control your profits or loss. Cash Book is just like a ledger account because it includes your cash and bank transactions.

Overall, there are three kinds of cash book: Single Column, Double Column, and Triple Column cash book. For Single column cash book, there is only one amount column (Cash). For double or two column cash book, there are two amount columns – Cash and Bank Column. For three column cash book, there are three amount columns: cash, bank, and discount.

Why do I need a cash book template?

Profit and loss statements are useful for understanding the financial performance of your business. When you know that your brand is raking in more profits, you’re confident to approach the next business year with even bigger goals.

Also, profit and loss statements help you compare your business profits over time, by showing your changes in revenue and spending. The profit and loss statement can tell you if your expenses are growing faster than your income, causing you to make less profits than you made in the past year. With this insight, you can make moves to cut down your spending while keeping your revenue high.

How to fill an excel cash book template?

Creating a profit and loss statement is much easier with Vencru’s free profit and loss statement template, available for download. Here’s a simple set of steps to fill out your template:

  • Download and open your free template.
  • Fill in your company name, address, and other details as applicable.
  • Include the period being covered in the profit and loss statement.
  • Collect all records necessary to obtain information about your revenue and expenses.
  • Add all revenue by filling in the revenue details and amounts.
  • If applicable, add the ‘cost of goods sold’–that is, the cost of manufacturing or delivering products sold during the period.
  • Calculate and fill in the ‘Gross Profit’ by subtracting the cost of goods sold from the total revenue.
  • Next, add all expenses by filling in the expense details and amounts.
  • Calculate and fill in the total expense amount.
  • Calculate and fill in the ‘Net Profit’ by subtracting the total expense amount from the gross profit.
  • Check to see if all details and amounts are correct.

Get more bookkeeping templates?

Need more resources for your accounting? Vencru has all the templates you need to keep your records in check, and they’re free to use.

Even better, Vencru’s reliable accounting platform helps you save time by generating these reports automatically for you. Vencru keeps all records up to date and gives you more insight into the numbers, so you never have to worry about time-wasting calculations and you’re equipped to make the best decisions for your clients and for your business.

Tired of spreadsheets? Get the free bookkeeping app

Your free bookkeeping app will allow you automatically generate your cash flow report. It is available across all your devices (Web, Android, and iPhone)

income statement generator by Vencru