Saturday, May 10, 2008

The Real Concepts Of Acounting Software

A necessary part of any business is knowing where all your money is being spent. Accounting principles are designed to accommodate this need in an organized fashion. To the untrained eye, it may look like pandemonium, but it really is simple.

The principles of accounting are as follows:
Accounts are divided into three types, namely assets, liabilities and equity. Each account type has it’s own properties. The accounts can be represented as simple “T” accounts with a left and right side separated by a vertical centerline. All you need to do is make a large T. Each side of the “T” will record increases or decreases in that account balance in the form of debits or credits. Debits are always on the left side while credits are on the right.

TIP: Since the words “right” and “credit” have R’s in them, that’s how you can remember this.


Asset accounts use debits as increases and credits as decreases. Liability and equity accounts are the exact opposite. For every debit, there must be a corresponding credit. This is so that there is a balance that can be tracked.

All of your important information is at your fingertips, you always know exactly where you stand and you will be able to report pertinent information should Uncle Sam come around asking for records. Complex software is available that allows you to make your entries and track your accounts in minutes. Accounting software is simple to use and while no previous experience is necessary, it does help to have some background knowledge in accounting. These pieces of software will allow you to print documents detailing specific transactions, financial reports, print checks and some even feature the ability to send payments to creditors via E-check online. The real advantage of using this software is the minimum amount of paper files you need to have. Everything is located on storage devices like CDs, floppy discs (old) or a separate hard drive designed to hold this information.

All this sounds a bit confusing, but it really is simple and it is an absolute necessity for any person doing business anywhere. Take the following example:

Suppose you get a loan of $5000 to open your business. That cash is an asset of your company. So you would enter a $5000 debit to the asset account and a corresponding credit to an equity account. If you apply the accounting equation (assets=liability+equity), you will see how that works. Namely, your assets (now $5000) equal your liabilities ($0) plus your equity ($5000). See how the two sides balance out? This is the basis of accounting.

As you can probably see, the use of accounting will tell you exactly how much money you have, how much you owe and how much your business is worth at any given time. It is important to know these things for many reasons. Primarily for tax purposes and taking care of monetary responsibilities in a timely fashion.

Accounting used to be done by hand using “T” accounts, debits and credits or ledger books. While these methods worked and were functional, the advances of the Internet and computers have greatly streamlined the accounting process.

Dont Wait to Construct Your Accounting.

Most of this accounting software covers four major areas of construction industries. Accounting module covers, A/P, A/R, check writing, financial reports, inventory, job costs, payroll, project billing, cost estimating module covers assemblies, as well as unit costs, project management module includes change orders, contract writing, material takeoffs, punch lists, schedules. Business management module deals with appointments, customer relations, leads, property management, sales, etc.

The construction industry has some specific accounting requirements. Apart from routine receivable and payable accounts, they need systems for project estimating, job costing, overhead expenses, project schedules and contracts, project billing, vendor tracking and invoicing, customer management, etc. A typical construction accounting system includes accounts payable, job cost management, accounts receivable, payroll, detailed job budgets, time and material billing, general ledger, AIA billing, subcontract status, custom job reports, certified payroll, over and under billings, purchase orders, union reports, inventory, equipment tracking, work in progress, etc.

Accounting systems form an integral part of any successful business. Proper accounting not only helps the organization know its monitory worth, but also works as leverage to climb the ladders of growth. A construction company is like any other company and has many responsibilities towards their employees, customers, vendors, investors and government. They are bound to answer questions or queries that are raised time to time. Unless, they maintain a sound accounting procedure and proper reporting systems they can not fulfill these requirements.

In this computer age, there are many software packages available. Software specifically developed for the construction industry incorporates their specific requirements and are user-friendly and can be operated by the personnel with little computer knowledge. Apart from fulfilling statutory requirements such as balance sheets, profit and loss accounts for company and outside agencies like sales tax and customs departments, these packages generate innumerable reports which would be very helpful in company's decision making process.

Tips For Accounting Development

There was a tremendous increase in the nature and scope of manufacturing enterprises, trading activities had become far more complicated and extensive and therefore effective methods of planning and control were essential. These needs led to the emergence, out of cost accounting, of management accounting, the specific function of which is to provide whatever financial information may be required by the management of the enterprise for the purpose of planning and control.

The influence of electronic data processing (EDP) on accounting has been of paramount importance in the second half of the 20th century. It should be borne in mind, however, that EDP is purely a technology that has produced a dramatic increase in the speed at which large volumes of data can be processed. Although it has influenced the utilisation of accounting information, it nevertheless has had no effect upon the theory. The computer has made accounting information more effective chiefly in that it is now more complete, easier to understand and more readily available.

The particulars of transaction and financial relationships between different parties have been written up in the form of financial records since the dawn of civilisation, examples being Babylonian clay tablets and records from the Roman and Greek civilisations.

During the renaissance, this system of accounting became known throughout Europe; by the 16th century it was standard practise in England, Germany and Holland. The first published description of the double-entry system appeared in Venice in 1494. Written by Luca Paciolo, it was entitled Summa de Arithmetica Geometria et Proportionalita.

Our present system of accounting has its origins in Renaissance Italy. By the 12th century the bustle and extent of the wide-ranging trading activities engaged in by the Italian city-states had created the need for an effective system of financial recording which could accurately determine the results of large volumes of transactions involving several parties. Consequently, the double-entry system of bookkeeping, the basis of our modern accounting system, was developed.
The 18th century saw the emergence of another factor that exerted considerable influence on the development of accounting, namely the Industrial Revolution.

These days there are a large number of accounting software packages that are available to individuals, small and medium size enterprises and large corporations. The type of enterprise and internal operating systems will determine the type and size of accounting package that is used. In order for the enterprise to make investment decisions, a proper accounting structure must be in place. Accounting packages are just a tool to interpret the 'language' of the financial world - an instrument for transmitting information. Users of financial information expect accurate and comprehensive information that cannot be provided by general spoken or written language, so accounting was developed to satisfy this specialised need. By virtue of its nature, accounting information is historical. Historical trends do, however, serve as valuable guidelines for future projections.

Sunday, May 4, 2008

Finding Reliable Accounting Software For You

Those of us who own and operate a business know that far more goes into it than just marketing and selling products. There is an entire behind-the-scenes operation that enables the business to run smoothly, including the payment of vendors and employees, and other bookkeeping requirements. To this end, quality accounting software can be enormously helpful in maintaining organized books.

Depending on your needs - largely the size and type of business that you run - the accounting software will differ. There is accounting software designed exclusively for smaller businesses, as well as software that lends itself to larger corporations. Additionally, accounting software is often specific to the exact industry in which you run your business. This can be incredibly helpful, as it will offer features that speak directly to your particular situation. But, ultimately, no matter what you choose, the accounting software that you work with should be compatible with your computer network and comfortable for you to operate.

You can find accounting software in a variety of locations including large retail stores and computer supply stores. The Internet is also a comprehensive resource for finding the accounting software best suited to your needs. You will find a large fluctuation in price depending upon the different features the accounting software offers.

The most important thing to remember when selecting your accounting software is that reputation counts. Software of this kind is an investment in your business, and you should expect to see a return in that investment in the form of more convenient and organized bookkeeping. Speak with other entrepreneurs in your industry to determine if they've had success with any one particular accounting software. You'll find that the more popular accounting software often provides more bang for its buck.

Regardless of what accounting software you choose, the result should be the same; it should offer you a level of professionalism and convenience that you have been looking to achieve. Further, it should help you gain a better understanding of your financial situation.

The Right Benefits For Accounting Software

Historically the software has been an invaluable tool for corporations that required control over telephone usage costs. Call accounting systems generally capture and report on call type, origin, date, time, duration and dialed digits. The system stores the data and utilizes the information to
calculate cost and generate desired reports.

Call accounting is software or hardware that provides metrics for telephony functions such as traffic analysis, toll fraud alerts, network management, E911 notification and cost allocation to various corporate levels.

Call accounting can generally reduce telecom expenses from 10% to 40% by highlighting misuse and abuse, discovering supplier billing errors and increasing productivity through greater network and workforce efficiency.

Environments that are not monitored tend to have excessive charges for directory services, specialty numbers, personal and overseas calls. The implementation of a call accounting system can pinpoint calls to individual extensions for greater accountability. In fact, simple awareness of the impending installation of a new call accounting package circulated among staff curbs misuse immediately by approximately 10%.

Supplier billing errors can be a costly revelation. A Gartner Group study found 12 to 20 percent of corporate telecom invoices contain billing errors and 85 percent of such errors are in favor of the carrier. A good call accounting system can provide accounting assurance through bill reconciliation.

In this era of heightened security, it is imperative that a call accounting software package monitor suspicious, fraudulent and malicious behavior. Calls to E911, emergency services or to specific calling patterns can be tracked and notified to authorized personnel. In 2002, the United States Congress passed the Sarbanes-Oxley Act following fraudulent operations by companies, such as Enron and WorldCom. Call detail reports can be used to provide documented proof of fraudulent behavior.

Over the years call accounting has evolved from a single processor MS DOS system to elaborate SQL databases with globally accessible browser-based solutions. Web browsers are either pre-installed with the operating system or freely available downloads from the internet. Browsers are popular because they can access information remotely from a public IP address or via a virtual private network (VPN). Therefore an individual can access his stock quotes, read the latest headlines and review call accounting reports through various tabs on the browser. Web browser based systems allow enterprise users to easily manage many sites from a centralized location.

Many corporations are developing total communication management solution (TCMS) strategies to manage their growing communication spend. Call accounting is the core of any powerful communication management portfolio.

RSI (www.telecost.com) is recognized as an industry leader in the field of communication management. The communication management product portfolio includes tailored integration to the most popular switching and network manufactures. RSI has been granted Nortel Developer Partner status with recognition for its core portfolio as Compatible Products. RSI is a Cisco Technology Partner, Siemens HiPath Ready Standard certified, Avaya DeveloperConnect Member, Mitel MiSN Member, Adtran Complementary Solutions Provider, ShoreTel Technology Partner, NEC Univerge Partner and Alcatel Applications Partner.

Thing About The Right Accounting System For Your Martial Arts Business

As a school owner it is essential that you know exactly how your business is performing on a month by month business. Rather than ignoring this valuable information the successful school owner would know exactly how much income had been generated last month, how this income had been generated, how much expenses were paid and exactly how much should be provided for certain events.

Without recording your transactions on a regular basis it is impossible to know the above details with any certainty, and even harder to identify whether you are meeting or exceeding budgets.

Reports can be easily generated from accounting systems, providing you with information such as profit and loss accounts, various breakdowns of expenses, budget reports, and graphs detailing year to date performance.

In this article I am going to look at several different methods of keeping your bookkeeping records and provide honest feedback from an accountants point of view so that you can make an informed choice for your business.

To grade the different packages I am going to use the following criteria:

Cost there is no point purchasing enterprise-level software with a correspondingly high price tag for a small school! Ease of use again, there is no reason for purchasing software that is so complicated that it doesnt get used!

Reporting the standard of reporting provided from the system is vital for allowing you to monitor the progress of your business.

Manual Cashbook

Ratings: Cost: 4/5 (Approximately 10 20) Ease of use: 4/5

Reporting: 0/5

The manual cashbook has probably been used by all of you at some point the big red (or green) book provided by an accountant so that you can handwrite all of your payments and receipts at the end of the year.

Advantages: Low cost, relatively easy to use

Disadvantages: No reporting,each column has to be totaled manually

Excel Spreadsheets

Ratings: Cost: 5/5 (Free of charge)

Ease of use: 3/5

Reporting: 1/5

Excel spreadsheets are essentially a computerized version of the manual cashbook, available free of charge (provided that you have spreadsheet software).

Advantages: Excel analysis and summary tools, free of charge

Disadvantages: Reporting in Excel is complex, potential formula issues

Online Accounting

Ratings: Cost 5/5 (Free of charge)

Ease of use 4/5

Reporting 3/5

A secure online accounting tool provided by your accountant will provide you with the ease of use of a manual bookkeeping (with no manual totaling!) and basic reports found in comprehensive packages such as Profit and Loss, category breakdowns, graphs etc.

Advantages: Reporting, ease of use, free of charge, no software installation

Disadvantages: Ideally requires broadband connection

Quickbooks

Ratings: Cost 2/5 (Approximately 100 upwards)

Ease of use 3/5

Reporting 4/5

Quickbooks is a comprehensive package targeted at small business owners to assist them with the management of their financial affairs, offering various reports and functions.

Advantages: Detailed reporting, ease of use compared to Sage

Disadvantages:Cost, training requirements, ongoing updates

Sage Accounting

Ratings: Cost 2/5 (Approximately 129 upwards)

Ease of use 2/5

Reporting 5/5

Sage is an established accounting software providing comprehensive reporting and more functions than you will ever need, albeit with a steep learning curve.

Advantages:Detailed reporting, potential departmental / budget analysis

Disadvantages:Cost, learning curve, ongoing updates

If you feel that your system is not currently providing you with the reports that you feel would assist you in your business it would be worthwhile discussing this with your accountant to decide whether a change would be beneficial. For example, our firm provide online accountancy packages and tailor made Excel spreadsheets. We are also Sage Accountants Club members, and as such can advise all of our clients how to select and implement a package to suit their needs.

Tips For Choose Great Canadian Income Tax Software Programs For You

Canada has a wealth of income tax preparation software that can do more than just let you calculate your income tax and file in your return. Most tax software programs available in Canada also include a number of useful tax planning features that allow you to analyze a wide range of income tax scenarios. There are income tax software programs that cater to an individual as well as in business.

Businesses are required to fill out a highly accurate income tax return. Such businesses might be able to benefit a lot from using income tax software to help them in their tax preparation. Here is a short list of several income tax software programs available that Canadian citizens as well as any sole proprietorship or partnership business may be able to make good use of during the tax season.

QuickTax
This user-friendly and popular Canadian income tax software program helps you prepare your income taxes quickly and with ease. This software program has useful features such as The EasyStep Interview that guides you through the tax preparation process by asking significant questions needed to fill out your income tax forms. This software also makes tax planning a snap because of its ability to cover multiple tax scenarios that also offer automatic tax calculations. Other useful features that come with this popular income tax software program include tools such as the capital gains analyzer and incorporation analyzer.

TAXWIZ
This Canadian tax software program is useful in the preparation of personal income tax Many interesting features of this income tax program include providing multiple "what if" scenarios. This software also offers a convenient popup help when being used top prepare taxes and also provides multiple filing options that allows you to prepare up to six income tax returns at any one time.

GenuTax Canadian Tax Software
The good thing about this typical income tax software is that it offers future annual software updates for free online. You never have to purchase updated versions unlike those being offered by other income tax software companies. Another interesting feature that this particular program has is that you may be able to prepare and file a limitless number of tax returns which most tax preparation software programs fail to provide.

TaxTron
This wonderful software program is known to be the only fully functional user-friendly Canadian tax preparation software that is available in both individual (T1) and corporate (T2) versions for Macintosh OS users. A version of this tax software for Windows OS is also available that can be used to prepare individual as well as business income tax. Different software versions available for both operating systems are all quick, simple to understand and easy to use.

Preparing Tax Software In Canada.

Fancy, Brand-Name and #1 Best-Selling Tax Software Programs Have Fancy Price Tags

If you have always wanted to file your own tax returns but are not sure which tax software programs to use, this article is for you. To file your own income tax returns, you need to use income tax software programs. I will review a few Canadian tax software programs and let you decide the best one for you. I will only discuss value tax software programs and will not discuss any fancy, brand name and #1 best-selling programs. Fancy, brand-name and #1 best-selling programs have fancy price tags, and I do not use or recommend them.

Types of Tax Software Programs

Tax Preparation Software comes in two different versions. One version is Windows version and the other version is Web application or online version. An Online version means you don't have to download and install any applications on your computer, and you do everything online. Your tax information is saved on the web site's server. Windows version means you download and install tax preparation software on your computer and all your information is kept on your computer. I do not use or recommend online version tax software, and I will discuss only Windows version tax preparation software here.

How Canada Revenue Agency Receives Your Return

Two ways. One is the traditional way. You print off a copy of your return and mail it to CRA. The other is via online. You transmit your tax return to CRA via online. This online filing process is called NETFILE. NETFILE allows you to file only your own tax return. You cannot transmit tax returns on behalf of others. Also, you need an access code to use NETFILE. To learn more about NETFILE and access code, click here. http://www.netfile.gc.ca/about-e.html Both Windows version and online version tax preparation software offer options to print off your tax return (and mail to CRA) or to transmit online using NETFILE. In order to be NETFILE eligible, a tax software program has to be NETFILE certified by CRA. To learn more about NETFILE-certified tax preparation software, follow this link - http://www.netfile.gc.ca/software-e.html. The tax preparation software programs I am discussing here (and most of the tax preparation software programs) are NETFILE certified by CRA.

New Limit of 20 Returns

CRA has announced that starting 2007, there will be a limit of 20 returns (paper or electronic) with each copy of NETFILE-certified software. Before 2007, you were able to produce unlimited numbers of returns with some of these value tax preparation software programs (such as GenuTax). To know more about this newly imposed limit, follow this link - http://www.netfile.gc.ca/software-e.html.

Canada Tax Software - A Dawn Journal's Top Picks

After researching dozens of tax software programs, I have picked these tax software programs for this year. I am keeping it to a minimum so you don't get inundated with too much information. Let's begin.

TaxFreeway

* TaxFreeway is the only software allows user to use Interview and Form mode ssimultaneously. This gives user the maximum flexibility and helps user utilize the full power of software.

* Tax forms and slips are identical to actual CRA slips and forms.

* Both Windows version and MacVersions are available.

* It's got RRSP planner, carry forward feature, spousal return integration and tax tips on demand.

* Price: $9.95

* Website: taxfreeway.ca

MyTaxexpress

* MyTaxexpress allows to share tax forms/slips in coupled return. Spouse can prepare their returns together as a coupled return to share tax data in the beginning or in the middle of preparation.

* It prints on CRA official forms for mail filing.

* View tax return summary page.

* Price: $6.99 (1 return) and $13.99 ( 1o returns)

* Website: mytaxexpress.com

GenuTax

* Multiyear tax software program. Buy only once and future annual updates are free.

* Price: $34.99

* Website: genutax.ca

Studiotax

* The only free tax software. yes, you heard it right. It is free. However, if you would like to make a contribution, Feel free to do so and Studiotax appreciates it.

* Price: Free

* Website: studiotax.com

Quick Fact

* Deadline for 2006 tax returns: Midnight, April 30, 2008

* Penalty for late filing: 5% of your 2007 balance owing, plus 1% of your balance owing for each full month that your return is late, to a maximum of 12 months.

* EFILE : Don't mix up EFILE with NETFILE. EFILE is a service that lets authorized and professional service providers send individual income tax return information to CRA by Internet. Tax professional cannot use NETFILE. They must use EFILE. Therefore, when you submit your own tax return = you use NETFILE and when tax professionals submits your tax return = they use EFILE.

Made Accounting More Simple Now!

Proper accounting is a must for any emerging business. Following a good accounting practice make the overall management of the business very easy. Accounting is based on certain principles. These rigid rules make accounts consistent for all transactions involved. There are five major books of accounts. They are :

  1. Cash Book - Records all cash related transactions for a specified period.
  2. Bank Book - Records all bank related transactions for a specified period.
  3. Journal Book - Records all transactions, which are not cash or bank related.
  4. Purchase Book - All purchase related transactions are recorded here.
  5. Sales Book - All sales related transactions are recorded here.

Based on these books, a Trial Balance is prepared which shows the accuracy of accounting transactions involved. A Trial Balance has got two sides, Debit and Credit side. If sum total of Debit is tallied with the sum total of Credit side, then it shows that all transactions are recorded properly. These two sides are tallied only when the double entry concept is followed. Double entry concept stipulates that for every Debit amount, there must be a Credit amount.

In modern day business, Accounting software is used to record these transactions. These are commonly known as Accounting Packages. These Accounting Packages are built on the Accounting principles. These accounting packages make the whole accounting process very simple and integrated. One or more persons can work at a time. A data entry operator may be entering the data and a higher authority can approve it. Thus, the management can analyze the whole accounting process with ease.

Use of software in Accounting Will Save Much on Everything

Complete financial accounting course or tutorial covers a range of following topics. It is being evaluated that how computers have affected traditional accounting methods and practices.

  • Financial Accounting with Double Entry Bookkeeping
  • Principles of Accounting
  • Basic Book of Accounting - Journal
  • Accounting Ledger
  • Accounting Sub Journals - Cash Cook
  • Subsidiary Accounting Books
  • Accounting Verification by Trial Balance
  • Banking Transactions Bank Reconciliation Statement
  • Depreciation
  • Rectification Of Accounting Errors
  • Balance Sheet and Profit and Loss Account
  • Single Entry Bookkeeping Accounting System
  • Non Profit Organization Accounting
  • Capital and Revenue
  • Reserves and Provisions

In a very short span of time, computer has grown from a scientific curiosity to an indispensable tool of modem society. There is hardly any scientific/technical or business activity which is not in one way or the other, affected by modern data processing techniques.

The human mind can handle only a limited number of things at a time. The digital computer, on the other hand, can be programmed to compare, measure, calculate and evaluate thousands of readings in an extremely short period of time.

The computer industry has become the fastest growing industry these days. The sale of mainframe computers is increasing day by day. The computer industry has been further pushed up by the introduction of mini computer and micro computers which are small, cheap, reliable and very light. These are being routinely used for process control, production testing, scientific instrument recording, in store check out systems, in automobile test and evaluating systems, and medical monitoring etc.

Computers are now being used extensively in office administration to perform the routine clerical work. Today, most large and medium sized organizations are almost totally dependent on their computers. Routine uses of computers are given below:

(i) Accounting, Billing, Inventory Control Software with MIS, CRM

Computers are extensively used in accounting and there are multitude of computer software for Accounting, MIS, CRM. HiTech Financial Accounting is one such software which has been customized for users in many segments in business and services.

(ii) Payroll and personnel records.

Payroll accounting was the first commercial area to become widely computerized. The calculation of wages or salaries involves a number of variables which relate to the personal details of each employee, such as gross pay or rate for the job, individual deductions, tax liabilities of the employees and so on. These facts can be retained in the computers and processed every month of produce pay slips for the employees.

(iii) Stock control

The computer helps to exercise the type of stock control needed by the organization. It upto dates the sales and purchases records, determines optimum re-order levels for different items and prints out the stock lists when desired. The system can be so designed that it triggers orders when stock level reaches order point for various material items; tests those item which are slow moving or gives list for over stock items.

(iv) Sale accounts records

Programming can be done for any sales accounting system. The computer will pin point defaulting debtors, determine the right limit for credit for each debtor and maintain stores ledger.

(v) Costing and budgetary control

Costing and budgetary control can be affected through the computer, the computer will point out the variations from the planned performance.

(v) Production control

The computer also helps greatly in production planning and control. It is possible that scheduling of the work may become necessary due to break downs etc. A new critical path may have to be worked out. A critical path is the shortest path to be followed in production to achieve production objectives. The computer helps the management lay down this new critical path. Advantages and disadvantages of a computer

A computer is surely advantageous because of the high speed of operation and greater accuracy it provides, savings effected by better managerial control, savings in labor because it is fully automatic and finally because of its flexibility in use. However, there is a considerable capital outlay with difficulty of obtaining experienced analysts and programmers, break down and maintenance troubles and finally fear of obsolescence due to rapid development of computers.

Type of other applications in relation to accounting system

WORD PROCESSOR

It is a software package to help in text processing. Words are processed. Processing includes insertion, deletion changing, moving words, paragraphs etc. Word processing is the preparation of type scripts, using computing facilities for the storage and manipulation of text. For example, word processor has ability to merge name and addresses with standard text so as to give impression that the latter is personalized even in case of circular letter.

HiTech Financial Accounting has got features so that you can export its reports to Microsoft Word, a word processing and Mail Merge Program. You can also write letters to various parties and store the details in the program database.

DATA BASE

It is simple collections of information (data) on a particular subject. Data base file allows you to manipulate the data in desired form. So, data base allows us to work on facts and figures to store and manipulate that data in any desired way. For example, from the same basic information trial balance is prepared; trading and profit and loss account may be prepared; list of debtors and creditors may be prepared; purchases and sales forecast may be made and so on. So, an efficient data-base management is needed to provide flexibility in uses of information. HiTech Financial Accounting uses MS Access and MS SQL server databases for robust database connectivity.

SPREAD SHEET

It is one of the software programs which have increased the utility of computer for accounting purposes. Spread sheet programs help you to draw vertical as well as horizontal columns on a large sized paper. Each .column's length and breadth can be adjusted according to suitability. Even when columns are once drawn subsequently these can be altered, increased or decreased additional columns can be inserted, existing columns can be deleted. It is very useful for businessmen and professionals. It enables us to study multidimensional data at one sheet and helps in arriving at logical decisions. For example, if profit and loss account has been prepared for the year 1989 and you want a comparison with 1987 figures and 1990 forecast then spread sheet shall enable you to provide two additional columns on each side for inserting 1987 actual figures and 1990 forecast estimates.