What is the best commercial (no freeware) Excel for bookkeeping and financial reports?

Posted on 2012-08-26
Last Modified: 2012-09-09
What is the best commercial (no freeware) Excel for bookkeeping and financial reports?

An accountant made the financial report in Excel for me for the closing of accounts, and said he could customize a "bookkeeping-Excel" for me that would be much easier to use than any accounting software.

However, I wonder if there is any bookkeeping-Excel available to buy online for download?

The layout I am looking for is double-entry system and the bookkeeping and financial reports (bank and cash ledger, expense ledger, income ledger etc.) should be in this same Excel. So that I get a double-entry bookkeeping system and immediate creation of the ledgers/financial reports. And also good overview of cash-flow each month.

I think these tasks are easier to handle in Excel than in any accounting software for a non-accountant.
Question by:hermesalpha
    LVL 38

    Accepted Solution

    Unless your business is very small, I think it would be better if you used a widely used complete accounting package like Quickbooks, which is integrated with Excel to the extent that it enables you to export any QB report in excel format.

    If your business is small and you are determined to use an excel based accounting system, here is one for $20 that appears to be pretty sophisicated.

    Author Comment

    Really a valuable link for me, thanks puppydogbuddy! My business is small so Excel will be so much easier for me to use.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now