Business form
Business Income & Expense Log
Free business income and expense log in CSV for Excel or Google Sheets. Record each transaction's date, item, income, expense and running balance to keep an eye on daily revenue and cash flow.
File format：CSV · Excel／Google 試算表9,400 downloadsFree
Template preview
| Date | Item | Category | Income | Expense | Balance | Note |
|---|---|---|---|---|---|---|
| 06/01 | Cash sales | Revenue | 820 | 820 | ||
| 06/01 | Inventory | Cost | 350 | 470 | supplies | |
| 06/02 | Platform payout | Revenue | 540 | 1010 | ||
| 06/02 | Utilities | Expense | 120 | 890 | ||
| 06/03 | (fill in) |
Ad slot (enabled after AdSense approval)
How to use
- 1Download the CSV and open it in Excel or Google Sheets.
- 2Enter the date, item and category for each transaction.
- 3Put amounts in the income or expense column.
- 4Compute balance with a formula (previous balance + income − expense).
FAQ
Do I calculate the balance myself?
The sample shows example numbers; in a spreadsheet use 'previous balance + income − expense' and drag it down to auto-fill.
Is it suitable for tax filing?
It works as an internal record of revenue and cash flow; for official tax and accounting, follow your accountant or local rules.
Can I summarize by category?
Yes — use a pivot table or SUMIF on the Category column to total each type of income and expense.