Google Answers Logo
View Question
Q: Accounting with Excel (looking for good templates). ( Answered 5 out of 5 stars,   1 Comment )
Subject: Accounting with Excel (looking for good templates).
Category: Business and Money > Accounting
Asked by: centure7-ga
List Price: $35.00
Posted: 01 Jul 2005 22:40 PDT
Expires: 31 Jul 2005 22:40 PDT
Question ID: 539305
I am starting a business and am looking for a very generic set of
templates I can use for: creating accounts, journal entries, and
generating the big four statements (income, balance, R.E., cash flow).
Also, I'm hoping to do keep sets of books: one for reality and the
other for tax purposes. Perhaps there is a template out there that can
make that a bit easier?

I have been running websites for years and will start accounting for
that, but there are invention investments I will be making now, so the
range of use for the templates will be large.

If for some reason you think accounting should not be done in Excel,
feel free to comment below.

Request for Question Clarification by sublime1-ga on 02 Jul 2005 00:24 PDT

See if the offerings on this page suit your interests:

Subject: Re: Accounting with Excel (looking for good templates).
Answered By: hummer-ga on 02 Jul 2005 07:52 PDT
Rated:5 out of 5 stars
Hi centure7,

Well, you might have to experiment a bit before settling on a set of
business templates or programs which suit you, it all depends on your
level of expertise and personal preferences.  My guess is you've
already decided not to use feature-rich programs such as QuickBooks
but if not, you should consider them because they are designed to help
prevent making mistakes, something spreadsheets can't do.

What You Want vs. What You Need
"If you know bookkeeping, you can get along with the very simple
spreadsheet package such as Microsoft?s Excel or Lotus 1-2-3. These
programs replicate the paper ledger sheets while still offering
sophisticated capabilities for manipulating figures and values to get
a picture of what the company is experiencing.
When it comes to basic accounting software, two names are probably
familiar to everyone, Intuit?s QuickBooks and Microsoft?s Great Plains
Accounting. While offering all the basic modules and facilities, these
are not really the entry level; they are much more complex than that
and are the best starting point for nonaccountants."

>>> Microsoft Templates

That said, Microsoft offers free templates for Excel -

MICROSOFT BUSINESS TEMPLATE (free): Accounting and Reporting

Tax-related templates

> For your specific requests:

Accounts receivable aging workbook

General Ledger

Income Statement

Expense Report [see main list for more themes]

Waterfall forecasting model	
Financial professionals can use the Waterfall Forecasting Model
template to analyze key line items from the profit and loss statement
and balance sheet on a monthly basis. The user can enter forecast and
actual data in this template and determine monthly progress toward an
organization's financial goals.

Year End Tax Plan

>>> Other Solutions

As I already mentioned, although Microsoft's templates may be adequate
for getting the job done, it would be wise to consider choosing an
accounting program.

Bean Counter: We Count While You Manage:
"Believe it or not, there is some good free business software
available - it's just hard to find ! These sites provide you with
mostly free business software to aid you in the day to day operation
of your business."

Quoted from Bean Counter's list:

"This is one of my favorites. Simple to use. Only drawback is it
doesn't have a payroll module, but it's still a nice alternative to
some of the commercial programs with too many bells and whistles.
OneStep Accounting Standard Edition 4.0 is an integrated accounting
system. Modules include general ledger, sales processing (sales
invoice, credit memo, and cash sales), purchase processing (purchase
invoice, debit memo, and cash purchase), cash management, inventory
management, and report designer. It features customizable document
formats. Excellent OneStep User Guide (PDF) included to aid you in
making your bookkeeping hassle free."
One Step Accounting 4.0
Standard: free
Professional: $90 + $45 for additional user

"Free, open-source accounting system for Java. Runs on any computer
(Windows, Linux, MAC, etc.) which has Java installed. Accounting
program designed for people who have experience in bookkeeping. In
other words, this program is for those who can do their accounting by
hand but would rather have a program that will automate the process
and even perform some of the more complex calculations that would
normally be reserved for the accountant to do."

"For those wanting to update from their manual bookkeeping system.
here's a slick little program that tracks the ins and outs of your
money without all the bells and whistles. Big E-Z has lots of cool
programming that makes good use of your Excel program. It doesn't
matter what your skill level is -- anyone can use it. And it's so
affordable -- it's almost free!"
Big E-Z Bookkeeping
$29.95 / Free to Try

"Provides all kinds of financial templates and even provides some
excellent tutorials on Excel. A site well worth your time to visit."

"An excellent Excel site with free and pay for services is Ozgrid.
OzGrid's main business focus is Microsoft Excel  and all aspects of
it. Their site has over 4000 pages (and growing) of information on
Excel Templates - Excel Add-ins - Excel Training - Software

Additional Links of Interest

Find Accounting Software Free Buyer's Guide
"Choosing accounting software can be confusing. Eliminate the
confusion with your own customized Buyers Guide! It includes
information on everything from Accounts Receivable to Work Orders. The
Buyers Guide saves you time and helps you make a better software
decision. Read it online or print it out. To get your Free, customized
Buyers Guide, simply complete the Software Search form. It only takes
a few minutes."


SCORE Templates for Your Business

Excel Business Tools

Excel Spreadsheet Templates

Microsoft Money features

Excel-Related Product Links

I hope this helps to get you off to a good start. If you have any
questions, please post a clarification request *before* closing/rating
my answer and I'll be happy to reply.

Thank you,

Google Search Terms Used:

business templates excel tax
business accounting templates
business excel templates
financial reports excel
centure7-ga rated this answer:5 out of 5 stars and gave an additional tip of: $3.00

Subject: Re: Accounting with Excel (looking for good templates).
From: hummer-ga on 04 Jul 2005 10:54 PDT
Thank you for the tip, centure7!  Sincerely, hummer

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy