Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets

Accounting software is used by accountants to enterdiscretion of the small business owner additional
many complex financial transactions into the financialinformation was required from the bookkeeping
books of account and is almost invariably based uponrecords to indicate the totals of the different types of
double entry bookkeeping principles. A majorproducts and services then additional columns could be
advantage to those companies and the finance staffincorporated to enter the net sales figures in these
is the extent to which financial information contained incolumns.
the database can be queried for financial controlThere it is then, a simple list of sales invoices to satisfy
purposes.the sales accounting requirements for a small business
An accountant needs to not only ensure the financialwhere a balance sheet is not required.
records are accurate but also retrieve any part of theOn the expenditure side of the business the
accounting records to answer accounting questions onbookkeeping can also be a simple list of the purchase
the accounts, provide a legal basis for the transactionsinvoices and receipts showing the amount spent. The
and report the financial statements at regular periodiclist should also produce an audit trail by showing the
intervals.date of the purchase invoice, name of the supplier,
The small business has different accounting needspurchase invoice for identification purposes and the
which are better described as bookkeeping thantotal amount spent.
accounting. For non limited companies that do not needUsually tax returns are the main purpose of producing
to produce a balance sheet then a simple income andsmall business accounts and invariably some analysis
expenditure account can be produced much simpleris required to show what the expenses have been
using single entry bookkeeping principles.spent on. That is not difficult to achieve and as with
Less financial control is often required from smallthe sales accounting the owner manager can add
business accounting software as the bookkeeper isadditional standard columns to the bookkeeping
often the owner manager who already has an intimatespreadsheet.
knowledge of each transaction. Books are still requiredThe expenditure analysis columns do not need to be a
for tax purposes and a solid requirement of preparingdifferent column for each type of expenditure. It is
a set of financial books for tax purposes is that eachbetter to set up and group the analysis columns in
entry is supported by third party evidence.general headings which can accommodate all the
Examples of third party evidence would be salesexpenses.
invoices, purchases invoices and bank statements.Such columns may include stock, other direct costs,
Financial transactions where no receipt exists can stillpremises costs, general administrative costs, transport
be entered in the business books although alland delivery costs, repairs and maintenance, travelling
transactions not carrying third party evidence couldand hotel costs, motor costs, bank and legal costs and
subsequently be disallowed for tax purposes andother expenses. It is better not to enter too many
certainly would be if the amounts entered indicateditems under a general heading of other expenses as
unusual income or expenditure.this is more likely to be investigated as the type of
Producing an income and expenditure statement usingexpense has not been precisely identified.
single entry bookkeeping is little more than making twoOne important column to also include is for asset
lists of financial transactions. Those lists being one ofpurchases as fixed assets usually have different tax
sales income received from sales invoices or receiptsrules applying to the claim of the expense against tax
issued to customers and the other of purchaseand should be separated from other expenditure.
expenditure being from purchase invoices receivedHaving set up two bookkeeping spreadsheets the task
from suppliers.is then to produce the income and expenditure
To record sales income it would not normally beaccount by collecting the totals of each of the analysis
sufficient to simply add up the total of the invoices ascolumns. The sales total is the sales turnover from
such a summation does not leave an audit trail of thewhich is deducted the totals of each of the
items which have been included. A written list of salesexpenditure classification totals with the result being the
invoices does provide an audit trail.net profit and loss of the business.
Sales accounting for a small business accountingWhere stock is bought and sold a further adjustment
purposes can be either a manual list of the salesmay be required to account for the difference
invoices or by using a spreadsheet package a list canbetween opening and closing stock. This is done by
be made on a bookkeeping spreadsheet. Using ataking a physical stock check and valuing the stock at
spreadsheet for the bookkeeping has advantages asthe start and end of the financial period.
simple formula can be used to add up the columnOn the income and expenditure account adjust the
totals.stock purchases figure by adding the value of the
The essential information to enter for a sales invoiceopening stock and deducting the value of the closing
would be the date of the sale, name of the customer,stock. The result is not the stock purchases total as
sales invoice number if applicable and optional a briefshown in the bookkeeping spreadsheets but the cost
description of the item sold. In the next column wouldof the goods which have been sold to produce the
be the total sales invoice amount. If items like valuesales turnover being reported.
added tax are required to be accounted for then anSimple bookkeeping for a small business accounting
additional column would be required to accommodatepurposes can be two lists of sales and purchases
the vat or sales tax accounting.supported with sales invoices and purchases invoices.
A further small complication might be if at the