Profit & Loss and Balance Sheet Maker for Small Business (Excel)

Banks, landlords, investors and your own decisions all need a profit and loss account and a balance sheet. If your accounts sit in registers or a simple cash book, this workbook turns the year's balances into proper statements.

What it does

• Trial Balance: each account, its group and debit or credit; totals and difference shown
• Trading and P&L: sales, opening and closing stock, purchases, direct expenses, gross profit, other income, indirect expenses, net profit and net margin
• Indirect expenses list with a chart
• Balance Sheet: capital plus profit less drawings, loans and current liabilities against fixed assets, stock, current assets and cash
• Checks: trial balance difference and balance sheet difference with a clear Balanced or Check entries

Note

This is a management format for proprietors and small firms. Companies must follow Schedule III; your CA prepares statutory accounts.