Quick, cheap, and easy bookkeeping

This simple spreadsheet in Google Docs allows you to easily and quickly keep the books for a simple business.

Simple Instructions
1. In the Simple Accounts page, enter your beginning bank balance in the “Cash” column under “Opening Balance.”

For each transaction:
2. Enter the date under the “Date” column.

3. Enter a description in the “Description” column.  If the transaction is a check written, include the check number.

4. Enter the amount of the transaction under “Cash.”  Receipts are positive and payments will be negative.

5. Classify the transaction by entering the amount in the appropriate column (“Sales,” “Advertising expense,” etc.)

Go to the following IRS instructions for more information about classifying expenses.
http://www.irs.gov/pub/irs-pdf/i1040sc.pdf

6. If the first column says “OK,” then you’re in balance.  If it says “Oops,” double-check your numbers.

Simple Information
To check out your cash balance and profitability, click on the “Simple Report” tab below.

Warning!
Take proper precautions to keep your account information private.




Here is a video to demonstrate how to use the spreadsheet (added November 13, 2011)


About Mark P. Holtzman

Chair of Accounting Department at Seton Hall University. PhD from The University of Texas at Austin. Worked at Deloitte's New York Office. BSBA from Hofstra University.

No comments yet... Be the first to leave a reply!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: