
Annual Report
Docs + Word6 pages
FeaturedFree
This income statement suits a small business owner or bookkeeper who wants a clear picture of one month's trading. The Lines tab takes each line item with its section (revenue, cost of sales, operating expense or other expense), its amount and a note. The Effect on profit column adds revenue and subtracts costs, so the net result is one total.
The Dashboard shows total revenue, gross profit, gross margin, operating expenses and net income, plus a bar chart of where the money went by section. The sample month is a shop with product and service sales. Overwrite those lines with real numbers, but leave the sections alone so the totals stay right.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Lines tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Gross profit is revenue minus cost of sales, the direct cost of what you sold. Net income goes further and takes off operating expenses, such as rent and wages, and other costs like loan interest. Tax is also a deduction, but this sheet leaves it out, so add it separately.
Put a cost in cost of sales when it rises and falls with what you sell, such as stock and packaging. Anything else, such as rent and software, goes under operating expense. Apply that rule consistently, and margins from different months stay comparable.
Yes. Copy the sheet when a new month begins and clear the Amount column. Keep each month in its own file, or add a month column to compare results over the year.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free