Excel Accounting

Excel is perfectly designed to organize financial data into traditional accountancy tables. Excel also provides several functions that are designed to perform common accountancy and financial analysis calculations. Therefore, if you have a small business, Excel may be all you need to maintain full records of your accounts.

Common Accountancy Calculations

The following pages show how to use Excel functions to perform common accounting calculations.

Financial Analysis

The following pages show how to use Excel formulas to perform calculations relating to the time value of money.

Excel Accounting Templates

The following pages provide templates of common accountancy documents, including a typical balance sheet, a profit and loss account and a cash flow statement.