By Evian Morris on October 08 2018 21:25:20
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.
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.
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.
Less financial control is often required from small business accounting 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. Financial transactions where no receipt exists can still be entered in the business books although all transactions not carrying third party evidence could subsequently be disallowed for tax purposes and certainly would be if the amounts entered indicated unusual income or expenditure.
employee performance tracking spreadsheet
capsim forecasting spreadsheet
how to use spreadsheet software