A sales invoice is a prime document. In more advanced accounting systems technical terms such as sales day books, sales ledgers, debtors and credit control are important but at the basic level bookkeeping of sales is the act of recording those sales in the business books.
A sales day book is basically a log of sales invoices issued by the business and this level of recording financial transactions is all that may be required for a small business. A simple list of the sales invoices which would be described as part of a single entry bookkeeping system.
A basic bookkeeping system for sales invoices would be a single entry bookkeeping system with minimal analysis of the total sales value. An accountant or bookkeeper may make these entries although in smaller organisations the records are often kept by the business owner.
Larger organisations may well maintain sales day books but would certainly also enter the sales invoices into an accounting system and would usually use accounting software to do so. Within the financial accounting package the sales would not only appear as a list making up the total sales turnover but would also be entered in a sales ledger.
Each sales invoice being allocated to the various clients to whom the sales had been made. The sales ledger at this stage of the bookkeeping represents the value of goods or services sold to each customer.
Purchase Invoices
A purchase invoice is a prime document and a purchase day book is a list of purchase invoices received from suppliers. The purchase invoice day book would not normally require further financial analysis of the type of expenditure. To that extent a simple purchase day book would be a good starting point for a simple set of accounts but require a little more sophistication requiring analysis by expense type for both financial control and taxation purposes.
A basic bookkeeping system for purchase invoices would be a single entry bookkeeping system that also had columns to analyse the expenditure into the expense categories required by the particular tax rules under which the accounts were being prepared.
Medium and larger organisations require to track and control purchase invoices to control costs and payments. In a mirror of the sales ledger system purchase invoices would also be entered by supplier into a purchase ledger. The easy way is to allocate each supplier a code number so that the accounting software can collect the amounts owed to each supplier the individual supplier accounts being the purchase ledger.
Cash and Bank Transactions
Quite apart from the single entry of sales and purchases is the recording by a business in its books of cash and bank receipts and payments. The third area of prime documents is the cash receipt or bank slip, given or received. Such documents may take many forms from the till roll of a retail business to the deposit slip at a bank but all are evidence of money changing hands.
In a small business cash and bank records may be maintained separately to the records of other prime accounting records. In a simple format the cash or bank records would be similar to the bank statement but showing the names of customers and suppliers or if multiple customers for example then the source of the money being received or paid.
Larger organisations and particularly using accounting software also code each receipt and payment to the same customer and supplier codes used to produce the sales ledger and the purchase ledger. In addition to recording the cash and bank transactions in the cash and bank accounts the amounts received and paid are also recorded in the sales ledger and purchase ledger.
By recording the cash and bank transactions in the ledgers the customer and supplier records making up the accounting ledgers then show the balances on each account and the recording of the financial transactions in this way is effectively the other side of the double entry bookkeeping system.
A small business not requiring sophisticated accounting records for financial control purposes and using a single entry as opposed to a double entry bookkeeping system could simply record receipts against the list of sales invoices and the payments against the list of purchase invoices.
Basic bookkeeping using single entry of prime accounting documents would be suitable for small business, requires very little accounting knowledge and when carried out by the business owner rather than a bookkeeper or accountant can save money,
Businesses generally make extensive use of spreadsheets both in accounting and all other business fields. Being a numerically based system of analysing information spreadsheets are used throughout every accounting function as the technique presents an ideal basis to maintain accuracy and automate the collection of financial information.
Every small business needs to keep records of sales invoices and income received and purchase invoices in respect of expenses. It is not sufficient for accounting and taxation purposes for these receipts and payments to be left in the office or the back of a van in a carrier bag. At some stage these prime bookkeeping documents need to be processed.
Processing the financial documents related to a business enterprise basically means they need to be listed. For taxation and financial control purposes the invoices also need to be added up and analysed. The most basic method would be to simply make a list of the sales income and a second list of the purchase expenses.
Using a manual method of listing the information falls short of the analysis required and is more time consuming that using a little technology to both ensure the summation is accurate and the analysis simplified. Listing the sales and expenses of a small business on spreadsheets is no more difficult then a manual paper system and has tremendous advantages in automating and ensuring accuracy.
Hence the use of bookkeeping spreadsheets to prepare the accounting information required. Instead of listing the items on a paper list the items can be just as easily listed on a spreadsheet which will add up the items as required without the requirement to double check the adding up is accurate. Such a list has a history in accounting term as a sales daybook and a purchase daybook
To achieve the required analysis of sales and purchases all that is required is to write into the top of each of the spreadsheet columns the titles of the analysis headings required. Then repeat the value of each transaction in the total column into the analysis columns. Use the spreadsheet technology to add up each column and you have an effective bookkeeping spreadsheet.
Preparing such a bookkeeping spreadsheet might and often does suffice the needs of the smallest business enterprise and is a close step towards achieving a valuable tool for this purpose, bookkeeping software. Bookkeeping software can be as simple as a home produced spreadsheet but with additional facets that can have significant financial benefits to the business.
Bookkeeping software produced on spreadsheets would normally be a series of spreadsheets with the columns preset and titled and formulae written into the sheet to automatically add up each column. In addition the columns used would normally be restricted to general headings to include a full analysis of all items.
Small businesses that might produce their own spreadsheet would often do this on an annual basis. Bookkeeping software is much more likely to provide these bookkeeping spreadsheet templates on a monthly basis to enable a degree of financial control to be exercised by the small business.
That is the second real value of bookkeeping spreadsheets, the ability to provide the business with financial information and through that data financial control over the business activities. The first value is of course the simplicity of listing with automated summation of the figures.
Small businesses can also benefit from professionally produced bookkeeping spreadsheets that have been specifically arranged not just to produce a list of income and expenses but also in a way that analyses that information in the way the small business requires it. There are two main requirements of the way the financial records are analysed being to produce a financial profit and loss account for the business on a periodic basis but also to provide the totals of the categories required for taxation purposes.
Buying a piece of bookkeeping software written on spreadsheets can thus become an essential tool for the business. The essential element being to both make the accounting simple and easy as listing items, automated analysis and summation assisting the financial control and improved financial performance while also producing the benefits of being analysed to make the completion of annual tax return forms easier.
Everyone in business wants to make a profit making financial control important. Everyone in business has to fill in tax forms and submit accounts in the tax authority format. Bookkeeping spreadsheets provide an essential accounting tool for every business to achieve these objectives.