SIMPLE ACCOUNTING SPREADSHEET

The sheet has the following tabs:

• Transactions:

This is the detail where you enter mainly individual purchases or sales, specifying Date, Description, Amount, Account and Notes.  The Account field is a drop list taken from the Accounts tab. 

• Date Range:

This is where you control the date range for reports on other tabs. For example you might select Jan 1 to Dec 31 for an annual report.

• Accounts:

This tab is a list of accounts (e.g. Sales Revenue, Business Meals, etc.) and computes the total for each account for the specified date range.

• Profit & Loss Statement:

This tab automatically generates a simple profit & loss report based on the specified date range. The detail is shown on the Accounts tab to reduce redundancy and simplify ease of adding or removing accounts. 

• Entities:

This tab automatically generates balances for bank accounts, credit cards, vendors or anything else you want to track.
A sheet you can copy is here and has some sample data. Visitors are welcome to use the sheet at no cost. We would appreciate a link to this page from your website in return. Please contact us if you find any improvements. 

Disclaimer: 

We are not accountants and provide the spreadsheet at no cost and without any warranty or guarantee of accuracy. We do not assume liability for any errors or discrepancies that may be present. The use of this spreadsheet is at your own risk, and it should not be considered a substitute for professional advice. We encourage you to use this tool as a preliminary step and consult with a qualified professional to ensure compliance with all relevant laws and accounting standards.