Simple Bookkeeping Excel Spreadsheet

Description
This simple bookkeeping spreadsheet can be used to record receipts and payments for up to 100 transactions and produces a summary of receipts and payments at the end of the accounting period.

Keeping bookkeeping records is a requirement for any small business. It is crucial that records are kept in good order and that financial information is prepared on time and easily understood.

Start your bookkeeping today by downloading our FREE simple bookkeeping spreadsheet in Excel format

The Excel simple bookkeeping spreadsheet keeps a record of receipts and payments transactions for an accounting period, and automatically produces a summary receipts and payments statement based on these transactions. The simple bookkeeping spreadsheet is used as follows:

Using the simple bookkeeping spreadsheet.

1. Delete the example name, period, and transactions. Switch to the bookkeeping spreadsheet tab, and highlight the completed example cells (Row 7 onwards) and delete the contents. Do not include any cells in column N when trying to delete as this column contains protected cells.

2. Enter the business name and accounting period. The accounting period would normally be one month, but can be any period appropriate to the business.

3. Enter the expense payments categories. There are nine expense payments categories, phone, mobile etc. These can be renamed by highlighting the cell and entering the new name.

4. Enter transactions. For each transaction enter the date, reference, description, and amount under the appropriate column heading. The simple bookkeeping spreadsheet will automatically total the expense payments for a particular transaction and also provide totals for each category for the accounting period.

Switch to the accounts summary tab. The accounts summary tab will show a summary of the receipts and payments for the period together with a net receipts total.