By Barclay Spears on October 12 2018 17:08:52
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.
Whether you are a starter or an experienced user, you can always use a free version of personal budget spreadsheet template. Although you may prefer some other versions such as quicken at later stage, you will probably love coming back o use the template from time to time. The budgeting spreadsheet would go a long way in ensuring that you manage your finances pretty well and ensure that everything is working as per your requirement.
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.