Daily Cash Book
Keeps a day-by-day record of cash going into and out of the cash box; automatically finds the difference between the end-of-day count and the book.
Income and Expense Statement Excel Template
The income and expense statement Excel template gathers all of your business's money in and out in a single table and automatically calculates the VAT amount, the grand total and net profit/loss. All you need to do is mark each entry as Income or Expense; the summary sheet shows the VAT you collected and the VAT you paid separately, and the month column is generated automatically from the date.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 26 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Date / Month | The transaction date. The month column is generated automatically from the date (in the format 2026-08) and is used for monthly filtering. |
| Type | Income or Expense — chosen from a drop-down list, and it determines the row color. |
| Category | Groups such as rent, payroll, purchases, sales, tax. Extend the list to suit yourself. |
| Description | What the transaction was; at month end this column answers the question "where did this money go?". |
| Amount (excl. VAT) | The taxable amount. |
| VAT % / VAT Amount | Enter the rate and the amount is calculated automatically. |
| Grand Total | Automatic: Amount + VAT. |
| Payment Method | Cash, credit card, bank transfer, check or promissory note. |
How to use it
- Download the file and delete the sample rows.
- Enter each money in and money out as a single row; select Income/Expense in the Type column.
- Enter the VAT rate — the VAT amount and grand total are calculated automatically.
- Edit the category list to match your own expense items.
- At month end, read your net profit/loss and your VAT difference from the "Summary" sheet.
Who is it for?
- Sole proprietors and small business owners
- Freelancers and consultants
- Businesses with heavy cash flow, such as cafes, restaurants and shops
- Entrepreneurs who keep their own basic bookkeeping
Frequently asked questions
Does this template replace official accounting?
No. This is a basic bookkeeping/cash tracking tool. For official books and tax returns you need to work with your accountant; the template makes it easier to prepare the breakdown you give them.
How should I determine the VAT rate?
Enter the rate that applies to your product or service (common rates in Turkey are 1%, 10% and 20%). If you are not sure, consult your accountant.
Can I get a monthly report?
Select the relevant month in the filter on the Month column; the summary figures work on all data, not on the month you select, and for a monthly total you can add a SUBTOTAL formula after filtering.
Can I track more than one business in the same file?
Just add a separate "Business" column instead of a category and filter by it; however, a separate file is recommended to avoid confusion.
Can I import bank transactions?
You can open your bank's Excel/CSV statement and copy the date, description and amount columns into this template.
Related templates
Invoice Tracking Excel
Brings issued and received invoices, VAT, collections and overdue receivables together in a single table.
Customer Account Tracking Excel
A statement table that tracks the debit–credit balance per customer or supplier account across all transactions and gives due-date warnings.
Store Credit Ledger Excel
A digital ledger that automatically calculates, per customer, the credit extended, the amount paid, the remaining balance and the number of days overdue.
Last updated: September 21, 2026
Searched terms: income expense excelprofit and loss statement templatebasic bookkeeping excelcash flow tracking