|
Welcome to Accounting Books - your
comprehensive accounting decision financial information resource.
Below, you'll find extensive
information on leading accounting decision financial information articles and products to help you on
your way to success. Dont forget to bookmark us and save by
visiting our Store
Catalog of quality used accounting textbooks at
rock-bottom prices.
For Small Business Accounts Read Bookkeeping Spreadsheets
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 records to answer 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 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. While financial expenditure not supported by a third party receipt could be disallowed as a claim against profits for tax purposes it is likley that if the expenditure appeared reasoinable the expense would be accepted.
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 for a small business 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 bookkeeping entry for as sales invoice is basic. Enter the date of the invoice, name of client, sales invoice number if applicable and optionally a very brief description of the product 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 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. Much better to use a small number of general expense headings than dozens of detailed items as being on a spreadsheet all the data entered is visible anyway.
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 purposes can be two lists of sales and purchases supported with sales invoices and purchases invoices. Article Source: Article Beam - a service of A1 Web Server Web Hosting Terry Cartwright a qualified accountant at DIY designs UK Accounting Software on excel spreadsheets providing complete Small Business Software solutions with single and double entry Bookkeeping Software for both limited companies and self employed business
|
