Some Book-Keeping Functions That Can Be Done Using Microsoft Excel

Some Book-Keeping Functions That Can Be Done Using Microsoft Excel

Here are some of the book-keeping functions that can be performed using Microsoft Excel, and that will be shown in this book:

To record data.
To automate updating of the Trial Balance statement.
To automate updating of the Balance Sheet statement.
To automate updating of the Profit & Loss statement.
To generate and update Debtors Ageing report.
To generate and update Creditors Ageing report.
To generate and update monthly Sales summary report.
To generate and update monthly Purchases summary report.
To generate and update monthly Items purchased summary report.
To generate and update monthly Items sold summary report.
To generate data for preparing Statement of account.
To help in preparation of bank reconciliation.
5 To help in cash flow monitoring.
Filtering data to see only list of data that we want to see.

Are these functions sufficient for your needs?

Many other reports, detailed or summary, can be produced as long as we know how to use Excel's Filtering function, PivotTable function, and formulas.