By Summer Salinas on October 01 2018 01:14:21
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.
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. Using a spreadsheet for the bookkeeping has advantages as simple formula can be used to add up the column totals. 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. 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.
The budget planners vary according to the particular budgets. These templates are designed such that it fits the particular budget whether it is a wedding budget or the annual get together budget. Spreadsheet templates can also be used for instant budgets such as an instant party budget and etc. The spreadsheets are designed to suit the time limits and they vary according to the time duration no matter whether it is an annual budget, monthly or weekly budget.
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.