Simple Bookkeeping Spreadsheet

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.

Simple Bookkeeping Spreadsheet Free Download

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 by subscribing to our email list using the quick form below.

Using the Free Bookkeeping Spreadsheet

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:

simple bookkeeping spreadsheet-v-1.2
Simple Bookkeeping Spreadsheet Preview
  • Delete the example name, period, and transactions. Switch to the bookkeeping spreadsheet tab, and highlight the completed example cells and delete the contents.
  • Enter the business name and accounting period. The accounting period would normally be one month, but can be any period appropriate to the business.
  • 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.
  • 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.

Unlocked Premium Version

The simple bookkeeping spreadsheet premium version is a spreadsheet just like the free version, except that it is unlocked and does not use password protected sheets, so you have access to all Excel features. In addition, it includes a few other features that make it more powerful as shown below.

Other Features of the Premium Version

Premium vs Free version comparison
Feature Premium Free
Transaction rows 3,000 100
Receipt type columns 3 1
Payment type columns 20 9
Protection Unlocked Locked


The premium version of the spreadsheet was designed using Excel 2010. Please check compatibility with your version of Excel before purchasing. If you are in any doubt please test compatibility by downloading and trialing a copy of the free version of the spreadsheet also developed using Excel 2010.

Buy Premium Version Now!

A licence to use the Premium Version costs £5.00, and can be purchased using the Buy Now Paypal link below.

simple bookkeeping spreadsheet premium

All purchases are made subject to our Terms and Conditions.

Please note you will be taken to the PayPal website to complete your purchase. If you do not have a PayPal account you will have an option to pay by debit or credit card. Your purchase will appear on your account under the heading “DP DOWNLOADS”.

What Happens Next?

After you’ve completed your payment, PayPal will automatically return you to our website downloads page, where you can retrieve your file.

What Happens if there are Problems Downloading?

Don’t worry, if you have any problems downloading the file simply contact us with your name and payment reference, and we will email you a link to the file.

Notes and major health warnings
Users use this Excel accounting spreadsheet at their own risk. We make no warranty or representation as to its accuracy and we are covered by our Terms and Conditions, which you are deemed to have read. This is an example of a free bookkeeping spreadsheet template that you might use to record accounting transactions. It is purely illustrative of small business bookkeeping software. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the simple accounting spreadsheet, please let us know and we will try to fix it.
Simple Bookkeeping Spreadsheet June 22nd, 2017Team

You May Also Like

Related pages

perpetual accounting journal entriesbookkeeping rulesprepaid expense entryexample of unearned revenueunderstated accounts payablevariable cost per unit calculatorreturn on retained earnings formulasundry debtors definition accountingannuity timelineyear end adjusting journal entriesis notes receivable a current assetdiscount on notes payable is charged to interest expensecash to accrual conversion examplewhat are examples of intangible assetsaccounts payable examplesaccount receivable normal balanceincome tax provision templatehow to calculate markupspetty cash fund entriesfinding payback periodprepayments and accrued incomeconsignment inventory sheetformula inventory turnovergrowing perpetuitydouble declining balance depreciation method formulathe balance in the prepaid rent accountincome statement periodic inventory systemexamples of double entry bookkeepingreceiving cash from an account receivabledebits and credits chartcost of goods sold journal entry exampleprofit vs markuphow to calculate annuity due on financial calculatorcalculating percentage markupfob destination vs fob origintvm solver online calculatorfederal income tax payable journal entryperpetual inventory system pdfcreditors accounts payablejournal entry for interest accrued on fixed depositdiscounting of debtorsaccounts receivable spreadsheetmeaning of amortization in accountingwip journal entryaccounting quizzesaccrued income entryfixed cost formula accountingperpetual inventory record examplewhat affects retained earningshow to calculate a payback periodcalculate amortization schedulewages debit or creditexcel formula irrcomputation of payback periodtotal debt to equity ratio calculatorexamples of annuity duezero based budgeting definitionnotes receivablesallowances for doubtful accountscheque receipt formatbank overdraft liabilityexpenses template ukfirst step in accounting cycleaccounting adjusting journal entriesnpv formula for excelaccounting conventions and principlesperpetual annuity calculatordeclare cash dividend journal entrywithout recourse factoringjournal entry and adjusting journal entrywhat is ledger in accounting with examplewhat are retained earningaccounting equation calculatorprovision for stock obsolescenceexample of perpetuityexpense accrualscalculating depreciation straight line method