Articles island - a directory of quality articles, free quality articles reprint for your web site and email newsletter.
Free Articles Reprint for Your Web Site, Email Newsletter, Blog, Ezine and RSS Feed.
Submit Your Articles to Our Article Directory for Massive Exposure.
Total Live Articles: 92613  Total Categories: 389



 
  Advanced Search
Articles island Expert Author - David A. Zimmerman
Have you ever dreamed of starting a new business during your retirement years? David Zimmerman is in process of fulfilling that dream. On Wednesday, February 27, 2008, he created World Wide Market, LLC and went on to create the internet domain name Wholesale Are Us. The actual website address is http://www.wholesaleareus.com...
Home » Accounting » Bookkeeping » Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets

Articles island Expert Author - Terry Cartwright
Author Name:
Terry Cartwright

Country:
Great Britain

Member Since:
9 Nov 2007

Total Live Articles:
55



Email to Friends
Rate this Article
Bookmark this Article
Print this Article
Report this Article
Leave a Comment





Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets

By: Terry Cartwright
Total views: 47
Word Count: 1006
Date:Jan 12th 2008
Article Rating: No Ratings Yet

Accounting software is used by accountants to enter many complex financial transactions into the financial books of account and is almost invariably based upon double entry bookkeeping principles. A major advantage to those companies and the finance staff is the extent to which financial information contained in the database can be queried for financial control purposes.

An accountant needs to not only ensure the financial records are accurate but also retrieve any part of the accounting records to answer accounting questions on the accounts, provide a legal basis for the transactions and report the financial statements at regular periodic intervals.

The small business has different accounting needs which are better described as bookkeeping than accounting. For non limited companies that do not need to produce a balance sheet then a simple income and expenditure account can be produced much simpler using single entry bookkeeping principles.

Less financial control is often required from small business accounting software as the bookkeeper is often the owner manager who already has an intimate knowledge of each transaction. Books are still required for tax purposes and a solid requirement of preparing a set of financial books for tax purposes is that each entry is supported by third party evidence.

Examples of third party evidence would be sales invoices, purchases invoices and bank statements. Financial transactions where no receipt exists can still be entered in the business books although all transactions not carrying third party evidence could subsequently be disallowed for tax purposes and certainly would be if the amounts entered indicated unusual income or expenditure.

Producing an income and expenditure statement using single entry bookkeeping is little more than making two lists of financial transactions. Those lists being one of sales income received from sales invoices or receipts issued to customers and the other of purchase expenditure being from purchase invoices received from suppliers.

To record sales income it would not normally be sufficient to simply add up the total of the invoices as such a summation does not leave an audit trail of the items which have been included. A written list of sales invoices does provide an audit trail.

Sales accounting for a small business accounting purposes can be either a manual list of the sales invoices or by using a spreadsheet package a list can be made on a bookkeeping spreadsheet. Using a spreadsheet for the bookkeeping has advantages as simple formula can be used to add up the column totals.

The essential information to enter for a sales invoice would be the date of the sale, name of the customer, sales invoice number if applicable and optional a brief description of the item sold. In the next column would be the total sales invoice amount. If items like value added tax are required to be accounted for then an additional column would be required to accommodate the vat or sales tax accounting.

A further small complication might be if at the discretion of the small business owner additional information was required from the bookkeeping records to indicate the totals of the different types of products and services then additional columns could be incorporated to enter the net sales figures in these columns.

There it is then, a simple list of sales invoices to satisfy the sales accounting requirements for a small business where a balance sheet is not required.

On the expenditure side of the business the bookkeeping can also be a simple list of the purchase invoices and receipts showing the amount spent. The list should also produce an audit trail by showing the date of the purchase invoice, name of the supplier, purchase invoice for identification purposes and the total amount spent.

Usually tax returns are the main purpose of producing small business accounts and invariably some analysis is required to show what the expenses have been spent on. That is not difficult to achieve and as with the sales accounting the owner manager can add additional standard columns to the bookkeeping spreadsheet.

The expenditure analysis columns do not need to be a different column for each type of expenditure. It is better to set up and group the analysis columns in general headings which can accommodate all the expenses.

Such columns may include stock, other direct costs, premises costs, general administrative costs, transport and delivery costs, repairs and maintenance, travelling and hotel costs, motor costs, bank and legal costs and other expenses. It is better not to enter too many items under a general heading of other expenses as this is more likely to be investigated as the type of expense has not been precisely identified.

One important column to also include is for asset purchases as fixed assets usually have different tax rules applying to the claim of the expense against tax and should be separated from other expenditure.

Having set up two bookkeeping spreadsheets the task is then to produce the income and expenditure account by collecting the totals of each of the analysis columns. The sales total is the sales turnover from which is deducted the totals of each of the expenditure classification totals with the result being the net profit and loss of the business.

Where stock is bought and sold a further adjustment may be required to account for the difference between opening and closing stock. This is done by taking a physical stock check and valuing the stock at the start and end of the financial period.

On the income and expenditure account adjust the stock purchases figure by adding the value of the opening stock and deducting the value of the closing stock. The result is not the stock purchases total as shown in the bookkeeping spreadsheets but the cost of the goods which have been sold to produce the sales turnover being reported.

Simple bookkeeping for a small business accounting purposes can be two lists of sales and purchases supported with sales invoices and purchases invoices.

About The Author-- Terry Cartwright a qualified accountant at DIY Accounting in the UK designs Accounting Software on excel spreadsheets providing complete Small Business Accounting Software solutions with single and double entry Bookkeeping Software for both limited companies and self employed business

Article Source: Articles island - Free article submission and free reprint articles


Most Viewed Bookkeeping Articles




Most Viewed Bookkeeping Articles:

Small Business Advice: Improve Your Accounts Receivable Collection Cycle Now
Almost any small business can use advice on how to improve its collection cycle. The first line of defense aga...

Why Bookkeepers And Accountants Use Double Entry Bookkeeping
Double entry bookkeeping is the technique employed by accounting software to accurately record financial trans...

Understanding Bank Reconciliation
Descibes the process of keeping your account records in line with the banks' account records....

What Is Customer Relationship Management?
Customer relationship management (CRM) is an important part of any business in order to keep clients happy....

Advantages Of Using Accounting Software
Whether you are a large business or a small business there are many advantages of using Sage payroll accountin...

Basic Bookkeeping For Small Business Can Save Money
Every business is required to keep a set of financial records to enable those accounts to be submitted and the...

Understanding Account Reconciliation
Describes the process of checking your account records with the banks account records....

How to Eliminate the Frustration from a Small Business Owner
The mostly of small businesses owners have worries and concerns regarding their company finances. The fact is ...

Your Home Business Tax Deductions
Tax keeping records are an important part of your business that should be maintained, very carefully, year rou...

Michael Jackson's Fiscal Disaster
How can music mogul Michael Jackson, a main stay in the music industry for decades and known to be one of the ...


Recent Bookkeeping Articles




Recent Bookkeeping Articles:

Small Business Advice: Improve Your Accounts Receivable Collection Cycle Now
Almost any small business can use advice on how to improve its collection cycle. The first line of defense aga...

Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets
There is a major difference between sophisticated accounting software used by larger businesses for financial ...

Bookkeeping Services: Get the Right Services for your Business Needs
The selection of a bookkeeping service offers many options. The advent of online services can be beneficial fo...

What Is Customer Relationship Management?
Customer relationship management (CRM) is an important part of any business in order to keep clients happy....

The Importance Of Risk Management
Risk management for business is a very important aspect of any company. This is because it identifies and trea...

Basic Bookkeeping For Small Business Can Save Money
Every business is required to keep a set of financial records to enable those accounts to be submitted and the...

Deciding Between Bookkeeping Software And Bookkeeping Services
All small businesses have to choose between keeping manual records of financial transactions and the benefits,...

Bookkeeping Software Spreadsheets Are Essential Small Business Accounting Tools
Accurate financial records must be kept by every business and bookkeeping software spreadsheets can satisfy th...

Financial Control Under A Self Employed Single Entry Bookkeeping System
Single entry bookkeeping is an accounting practise that can be employed by small business and in particular se...

Why Bookkeepers And Accountants Use Double Entry Bookkeeping
Double entry bookkeeping is the technique employed by accounting software to accurately record financial trans...

Most Viewed Articles by Terry Cartwright




Most Viewed Articles by Terry Cartwright:

Why Bookkeepers And Accountants Use Double Entry Bookkeeping
Double entry bookkeeping is the technique employed by accounting software to accurately record financial trans...

Basic Bookkeeping For Small Business Can Save Money
Every business is required to keep a set of financial records to enable those accounts to be submitted and the...

Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets
There is a major difference between sophisticated accounting software used by larger businesses for financial ...

Financial Control Under A Self Employed Single Entry Bookkeeping System
Single entry bookkeeping is an accounting practise that can be employed by small business and in particular se...

Getting Paid On Time And Debt Recovery When The Credit Crunch Bites
Making sure customers pay on time within the terms and conditions of the business is a serious issue and criti...

Accounting Periods And Basis Periods For Self Employed Business
Accounts are required each year for tax and financial control purposes with preset dates by which those accoun...

Managing Stock Levels Can See Off The Credit Crunch By Improving Cash Flow
When times get hard and 2008 has all the hallmarks of being a difficult financial year control over cash flow ...

Deciding Between Bookkeeping Software And Bookkeeping Services
All small businesses have to choose between keeping manual records of financial transactions and the benefits,...

Bookkeeping Software Spreadsheets Are Essential Small Business Accounting Tools
Accurate financial records must be kept by every business and bookkeeping software spreadsheets can satisfy th...

Payroll Software That Does The Administration Work
DIY Accounting Payroll Software is unusually written on a series of excel spreadsheet templates, Three versi...

You have permission to publish or reprint this article in your ezine, website, blog, forum, RSS feed or print publication, free of charge. As long as you keep this article with no changes(included Article Title, Article Body, Author Name, Article Source and keep all links in this article active)and you agree to our publisher terms of service. Below are ready HTML code for this article, you can copy and paste directly into your web page.

Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets -- HTML Version:


Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets -- Summary:

Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets -- Keywords:
1   2   3 Good!   4   5   6 Very Good!!   7   8   9   10 Excellent!!!  
Comments:
No Comment Posted.

Leave Comment: Please Login to leave a comment. Not a member yet? Sign Up now.