Excel is perfectly designed to organize financial data into traditional accountancy tables. Excel also provides several functions that are designed to perform common accountancy calculations. Therefore, if you have a small business, Excel may be all you need to maintain full records of your accounts.
The following pages show how to use Excel functions to perform common accounting calculations.
|Compound Interest Formula|
|Depreciation & Amortization in Excel|
The following pages provide templates of common accountancy documents, including a typical balance sheet, a profit and loss account and a cash flow statement.
|Balance Sheet Template|
|Profit and Loss Template|
|Cash Flow Statement Template|