Use these simple accounting templates to manage finances, track income and expenses, monitor cash flow, and ensure compliance. These templates are ideal for small businesses, freelancers, and entrepreneurs.
Purpose: Track revenues, costs, and profits over a specific period.
| Section | Details |
|---------------------------|-----------------------------------------------------------------------------|
| Revenue: | | Category | Amount ($) | |
| | | Product Sales | $10,000 | |
| | | Service Revenue | $5,000 | |
| Total Revenue: | $15,000 |
| Expenses: | | Category | Amount ($) | |
| | | Salaries | $4,000 | |
| | | Marketing | $1,000 | |
| | | Utilities | $500 | |
| Total Expenses: | $5,500 |
| Net Profit (Revenue - Expenses): | $9,500 |
Purpose: Display the financial position of your business by summarizing assets, liabilities, and equity.
| Section | Details |
|---------------------------|-----------------------------------------------------------------------------|
| Assets: | | Category | Amount ($) | |
| | | Cash | $8,000 | |
| | | Accounts Receivable| $3,000 | |
| | | Inventory | $5,000 | |
| Total Assets: | $16,000 |
| Liabilities: | | Category | Amount ($) | |
| | | Accounts Payable | $2,000 | |
| | | Loans | $4,000 | |
| Total Liabilities: | $6,000 |
| Equity (Assets - Liabilities): | $10,000 |
Purpose: Monitor inflows and outflows of cash to manage liquidity effectively.
| Section | Details |
|---------------------------|-----------------------------------------------------------------------------|
| Cash Inflows: | | Source | Amount ($) | |
| | | Sales Revenue | $10,000 | |
| | | Loan Proceeds | $2,000 | |
| Total Inflows: | $12,000 |
| Cash Outflows: | | Category | Amount ($) | |
| | | Rent | $2,000 | |
| | | Salaries | $4,000 | |
| | | Supplies | $1,000 | |
| Total Outflows: | $7,000 |
| Net Cash Flow (Inflows - Outflows): | $5,000 |
Purpose: Track amounts owed to suppliers and ensure timely payments.
| Invoice Date | Supplier | Invoice Number | Amount ($) | Due Date | Status |
|---------------------------|----------------------|--------------------------|-------------------------|-----------------------|-----------------------|
| Jan 1, 2025 | Supplier A | INV-1001 | $500 | Jan 15, 2025 | Paid |
| Jan 2, 2025 | Supplier B | INV-1002 | $300 | Jan 20, 2025 | Unpaid |
| Jan 3, 2025 | Supplier C | INV-1003 | $700 | Jan 30, 2025 | Paid |
Purpose: Track payments owed by customers to manage outstanding invoices.
| Invoice Date | Customer | Invoice Number | Amount ($) | Due Date | Status |
|---------------------------|----------------------|--------------------------|-------------------------|-----------------------|-----------------------|
| Jan 1, 2025 | Customer A | INV-2001 | $1,000 | Jan 15, 2025 | Paid |
| Jan 2, 2025 | Customer B | INV-2002 | $800 | Jan 20, 2025 | Pending |
| Jan 3, 2025 | Customer C | INV-2003 | $600 | Jan 25, 2025 | Paid |
Purpose: Record and categorize expenses for tax purposes and budgeting.
| Date | Expense Type | Amount ($) | Payment Method | Notes |
|---------------------------|-----------------------|-------------------------|-------------------------|-----------------------|
| Jan 1, 2025 | Rent | $2,000 | Bank Transfer | Monthly lease payment |
| Jan 3, 2025 | Office Supplies | $150 | Credit Card | Purchase of stationery|
| Jan 5, 2025 | Utilities | $300 | Debit Card | Internet and electricity|
Purpose: Calculate employee wages, deductions, and net pay.
| Employee Name | Gross Pay ($) | Deductions ($) | Net Pay ($) | Payment Date |
|---------------------------|-----------------------|--------------------------|-------------------------|-----------------------|
| John Doe | $3,000 | $300 (Tax, Insurance) | $2,700 | Jan 15, 2025 |
| Sarah Smith | $2,500 | $250 (Tax, Insurance) | $2,250 | Jan 15, 2025 |
| Mike Johnson | $2,800 | $280 (Tax, Insurance) | $2,520 | Jan 15, 2025 |
Purpose: Organize income, expenses, and deductions for tax filing.
| Category | Amount ($) | Notes |
|---------------------------|----------------------|--------------------------|
| Income: | | Product Sales | $50,000 | |
| | | Service Revenue | $20,000 | |
| Total Income: | $70,000 |
| Expenses: | | Rent | $12,000 | |
| | | Marketing | $6,000 | |
| | | Salaries | $24,000 | |
| Total Expenses: | $42,000 |
| Taxable Income (Income - Expenses): | $28,000 |
Purpose: Calculate the point at which your business covers all expenses.
| Category | Amount ($) | Notes |
|---------------------------|----------------------|--------------------------|
| Fixed Costs (FC): | $10,000 | Rent, salaries, etc. |
| Variable Costs (VC/unit): | $20/unit | Production cost per unit|
| Selling Price (SP/unit): | $50/unit | Selling price per unit |
| Break-Even Point (Units): | (\frac{FC}{SP - VC}) = (\frac{10,000}{50 - 20} = 334 { units})| |
Purpose: Plan and monitor monthly income and expenses.
| Category | Budgeted Amount ($) | Actual Amount ($) | Variance ($) |
|---------------------------|-------------------------|--------------------------|-------------------------|
| Revenue | $15,000 | $14,000 | -$1,000 |
| Rent | $2,000 | $2,000 | $0 |
| Marketing | $1,000 | $1,200 | +$200 |
| Profit | $6,000 | $5,800 | -$200 |
Purpose: Calculate the depreciation of assets over time using the straight-line method.
| Asset Name | Purchase Cost ($) | Useful Life (Years) | Annual Depreciation ($) | Accumulated Depreciation ($) |
|---------------------------|-----------------------|--------------------------|-----------------------------|----------------------------------|
| Office Furniture | $5,000 | 5 | $1,000 | $2,000 (after 2 years) |
| Laptop | $1,200 | 3 | $400 | $800 (after 2 years) |
Formula:
[
{Annual Depreciation} = \frac{{Purchase Cost} - {Salvage Value}} / {{Useful Life}}
]
Purpose: Evaluate business performance using key ratios.
| Ratio | Formula | Result |
|---------------------------|-------------------------------------------|---------------------------|
| Gross Profit Margin: | (\frac{{Gross Profit}} / {{Revenue}} * 100) | [Insert %] |
| Net Profit Margin: | (\frac{{Net Profit}} / {{Revenue}} * 100) | [Insert %] |
| Current Ratio: | (\frac{{Current Assets}} / {{Current Liabilities}}) | [Insert ratio] |
| Debt-to-Equity Ratio: | (\frac{{Total Liabilities}} / {{Equity}}) | [Insert ratio] |