There is a major difference between sophisticated accounting software used by larger businesses for financial control purposes than is required for small business where a simple bookkeeping spreadsheet is sufficient.
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.
Accounting is a term that embodies a whole raft of financial activities while bookkeeping is specifically literally the keeping of books of account. 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.
The prime accounting documents providing back up are sales and purchase invoices or receipts and bank statments. 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. Basic formulae canh be used to add up totals in a bookkeeping spreadsheet.
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. Additional columns might be required to account for taxes on sales such as vat in the uk or sales taxes.
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. The small business owner can insert 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.
These bookkeeping analysis columns would 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.
Got a Question? Ask.
Ask the community a question about this article:
Frequently Asked Questions
Money Owed To Me
By: lilsub | 20-09-2008
I have an ex-boyfriend who owes me money for cell phone bills and is refusing to pay. The bill is i my name, but the phone is in his possesion in another state. I have asked that he pay the money and he will not answer me at all. How do I go about getting all the money owed to me for his cell phone usage. It is money I am having to take away from my children, and it is a contract that he entered into willingly. So what are my options and what can I do?
Notifiying the irs
By: jonesy | 20-09-2008
How can a person notify the irs if an individual has not filed their personal taxes since the year of 1995 ,without having their social security number?
Doesn't layoff = payoff? Am I still on the payroll until paid?
By: Brownswannabe | 19-09-2008
I recently got laid off at work and the final pay checks issued to me bounced. The company is out of business. What is the best way to pursue the money I am rightfully owed?
Please hel me get articles on compterized ...at least 20 pages
By: feby sam | 18-09-2008
please help me get articles on compterized accounting
Manuel de procedures quelles sont les ...
By: bob thermil | 17-09-2008
manuel de procedures quelles sont les consequences de l'absence de manuel de procedures?
Statement of earning
By: Rich | 15-09-2008
how can i get a earnings statement for 2004
Q&A Powered by:
Latest Finance Articles
Shopping For Auto Insurance
By: Brenda Williams | 07/10/2008
When you get your license for the first time before you begin driving you need to get car insurance as it's mandatory to have car insurance while driving. Car insurance can be rather expensive, especially for new drivers which is why you'll need to ensure that you're getting the best...
Taking 100% Responsibility - the Prerequisite for Creating Money & Marriage Success
By: Leslie Cunningham | 07/10/2008
It's a simple concept, to refrain from blaming and complaining, and yet it's a challenge to change a habit, especially one that everyone else has. Like sticking to your diet, when everyone else around you is enjoying chocolate cake. Keep reading and you'll find out how this relates to your marriage and finances. Then I'll share some action steps to help you become 100% responsible for your life.
Retirement Income Investing and Your Portfolio
By: Steve Selengut | 07/10/2008
Brokerage firm monthly statements are designed to promote either fear or greed, depending on the current market environment. Nowhere on your statement can you find numbers that report your net investment, your total working capital, or your true asset allocation. Current and projected income numbers are given little attention
Buy to Let Investors Get a Boost
By: Parmdeep Vadesha | 06/10/2008
Buy to let UK investors are in a prime position to take advantage of a new government plan to spur property market activity. The scheme aims to permit property buyers to buy properties worth up to
How to Buy a Repossessed Property for Below Market Value
By: Parmdeep Vadesha | 06/10/2008
Buying a repossessed property is what matters for investors who are keen on reaping high profits. But even with the advantages it poses, there are certain aspects you need to be aware of before you start on the task of acquiring your next property cheaply.
Brits Should Ensure They Have the Cheapest Energy Supplier
By: Abbi Rouse | 06/10/2008
With energy prices escalating steadily, consumers could knock considerable amounts off their utility bills by switching from their areas default supplier.
How to Analyze Commercial Properties
By: Lorenzo Hills | 06/10/2008
Financing commercial properties or income-producing real estate is not an exact science. It requires subjective analysis, experience, and an ability to be innovative and creative.
Is There Really Such a Thing as Free Student Credit Cards?
By: Sean Masterson | 06/10/2008
Looking for free student credit cards? Some insist they don't exist. Don't believe them. You can find them, you just need to know how to play the game...
More from Terry Cartwright
A Private Limited Company Advantages
By: Terry Cartwright | 28/09/2008 | Business
When considering the advantages of a private limited company registration against retaining self employed status the decision taken by a sole trader is often entirely focused upon the tax advantages. There are other private limited company advantages and also disadvantages particularly in regard to limited company accounts and administration compared to producing a simple set of sole trader basic accounts.
UK Tax Codes Explained, Br Basic Rate Tax Coding and New Tax Code
By: Terry Cartwright | 25/09/2008 | Finance
UK tax codes are determined by HMRC, notified to employees and used by employers to calculate tax to be deducted from employee income. Inland Revenue tax codes explained as being made up of numbers or letters and usually both. When multiplied by 10 the number indicates the amount of tax free personal allowance the person is entitled to and the letter indicates the conditions which might be applicable to the UK tax code.
Sole Trader Basic Accounts Income and Expenditure Basic Tax Account
By: Terry Cartwright | 22/09/2008 | Finance
A sole trader in the UK can operate a very basic accounting system. Provided supporting evidence is retained to show the basic accounts are realistic and the income and expenditure statement accurate for basic tax purposes sophisticated accountancy, debits and credits are not required. Basic accounts for sole traders do not require the production of a balance sheet.
How Much is Tax on Income, Tax Percentage Rates and Income Returns
By: Terry Cartwright | 21/09/2008 | Finance
The answer to how much is tax on income and the income tax percentage paid is dependent upon the status of the individual being employed, self employed or incorporated as a limited company. Employees pay income tax and national insurance under the paye system while self employed individuals submit self employed income returns and although they receive the same UK allowances they pay different national insurance.
Tax Questions for Inland Revenue P46 Tax Form
By: Terry Cartwright | 08/09/2008 | Finance
A new employee without a P45 should be asked to complete a P46 form which the employer submits to HMRC. Inland Revenue P46 forms can be downloaded from the HMRC website and also submitted online. Completing the P46 solves a number of tax questions a new employer may have regarding the new employee status and is essential to ensure the PAYE records start off on a correct basis
P45 Form Tax Questions and New Employee P45 Forms in UK
By: Terry Cartwright | 07/09/2008 | Finance
Employers in the UK issue an employee that leaves with a P45 tax form stating details of that employment including the cumulative earnings and income tax paid to date. Not everything always go to plan resulting in a number of tax questions regarding the P45 form especially when a new employer may not have received the P45 form.
Vat Registered Companies Can Claim Vat Three Years Before Vat Registration
By: Terry Cartwright | 03/09/2008 | Finance
When a business completes the vat registration there are rules which enable vat registered companies to claim vat paid on goods for up to 3 years and on some services for up to 6 months incurred prior to registration.
Tax Software and Company Corporation Tax Return
By: Terry Cartwright | 31/08/2008 | Finance
Tax accounting software for UK companies involves business accounting software to produce the accounts combined with tax software to produce the CT600 corporation tax return.
Finance 
About the Author:
