Here is a brief list of the major stages that needs to be completed in order to implement a new accounting software system:
· Implementation planning
· Software installation
· Accounting system configuration
· System training
Implementation planning
· This is the vital first step that can make or break your project. The expertise of knowing how all the pieces need to flow, the order of the steps, what needs to be addressed and when will impact how successful your new system is for your business.
· Implementation planning is where decisions on the Chart of Accounts, customer numbers, vendors numbers, inventory items, integration, who gets trained, how to go live in a timely and safe manner all occur.
· Discussion and determination of what information from your old system is needed in the new system. There can be an broad difference in the cost based on what they want. Be careful not to try to do more than you actually need or more than you find cost effective.
Software installation
· Make sure your hardware and network system is adequately configured to support the new accounting software. Since several of today’s programs also offer CRM additional hardware needs may be required.
· Load the software from a CD or a download onto the proper computer either a stand alone or server
· Install or adjust the operating system and ancillary software such as Microsoft Windows Server, SQL Server, Small Business Server, IIS, etc.
· Establish a backup of the system data to protect against hardware failure. This needs to be followed up by testing and checking to confirm that the right files are being backed and the process is correct. Note that backing up SQL products are handled differently.
· Setup of Terminal Services, Citrix or web services is required in many of today’s environments, especially where companies have remote employees or multiple locations.
· If loaded onto a server and accessed from PC’s then establish proper access rights to the server to allow your employees to use the system. Network security must be incorporated into the accounting software installation.
· If multiple users:
· Establish passwords for each user
· Establish proper access for each user to their specific areas such as limiting Payroll access to specific employees
· Sarbanes – Oxley type security options (role based security) is available for many systems. The setup needs to be specific and carefully setup.
· Configure system documents to suit your needs such as:
· Customer invoices
· Customer statements
· Payroll checks
· Vendor checks
· Purchase Orders
· Sales Quotes, etc.
· Create custom reports to provide information in a format you need. These reports incorporate both operational areas as well as financial areas.
· Establish any needed “tie in” with other software such as importing data from an E-commerce application or from a time clock. Integration with other systems will vary based on your individual system. All require attention for security, backup and the ability to recover from a failed import.
Accounting system configuration
· Establish your company chart of accounts for assets, liabilities, equity, sales and expenses
· Establish company divisions, departments and cost centers as needed
· Load the following actual data:
· All customer information into Accounts Receivable and establish new customer default AR information
· All vendor information into Accounts Payable and establish new vendor default AP information
· All Inventory items into Inventory Control and establish new part default IC information
· All employees information into Payroll and establish new employee information – payroll must be handled very carefully as the data in the system must feed to quarterly payroll reports correctly and year to date numbers are vital to a clean cut over.
· Load specific figures so as to support the Trial Balance amounts for these accounts:
· Some people need history transactions– see the implementation plan
· The integrity of the old data must be determined.
· Before and after reports must be run to confirm that the data imported flowed through correctly. We recommending bringing in non master record information through data entry screens to have it post through where possible. This checks the data integrity and lets you keep drill downs inherent in most of today’s systems.
· Accounts Receivable all open unpaid invoices
· Accounts Payable all open unpaid invoices
· Inventory Control all current inventory stats including: quantity on hand, quantity on order by customers, quantity on order from vendors, current cost per item in stock, etc
· Payroll all individual payroll amounts per employee for current and former employees for the current year and quarter including pay, individual Federal, state, local and unemployment taxes paid and withheld
· Load other specific information to support the actual business condition at the time of conversion
· Purchase Order all open purchase order detail
· Sales Orders all open sales orders detail
· Job Cost all open jobs detail information and costs
· Bill of Materials all BOM “recipes”
System training
· Software providers include training on the software use tailored to specific individuals based on their area of responsibilities for example train payroll department employees are trained on employee adds, changes and terminations; recording employee payroll data, preparing various tax reports, procedures to close a month and year and processing various year end tax reports.
· Training needs to be timed correctly so it is long enough ahead of go live to learn, but so far ahead where employees forget what they learned.
· Although most companies employ smart people, they are not experts on the systems they are implementing.
· Training of new employees that did not sit in on the initial training is vital to avoid “attrition of knowledge”.
· Update training when new versions come out. It is a waste to install a new version and not know the new features.
· Implementation planning
· Software installation
· Accounting system configuration
· System training
Implementation planning
· This is the vital first step that can make or break your project. The expertise of knowing how all the pieces need to flow, the order of the steps, what needs to be addressed and when will impact how successful your new system is for your business.
· Implementation planning is where decisions on the Chart of Accounts, customer numbers, vendors numbers, inventory items, integration, who gets trained, how to go live in a timely and safe manner all occur.
· Discussion and determination of what information from your old system is needed in the new system. There can be an broad difference in the cost based on what they want. Be careful not to try to do more than you actually need or more than you find cost effective.
Software installation
· Make sure your hardware and network system is adequately configured to support the new accounting software. Since several of today’s programs also offer CRM additional hardware needs may be required.
· Load the software from a CD or a download onto the proper computer either a stand alone or server
· Install or adjust the operating system and ancillary software such as Microsoft Windows Server, SQL Server, Small Business Server, IIS, etc.
· Establish a backup of the system data to protect against hardware failure. This needs to be followed up by testing and checking to confirm that the right files are being backed and the process is correct. Note that backing up SQL products are handled differently.
· Setup of Terminal Services, Citrix or web services is required in many of today’s environments, especially where companies have remote employees or multiple locations.
· If loaded onto a server and accessed from PC’s then establish proper access rights to the server to allow your employees to use the system. Network security must be incorporated into the accounting software installation.
· If multiple users:
· Establish passwords for each user
· Establish proper access for each user to their specific areas such as limiting Payroll access to specific employees
· Sarbanes – Oxley type security options (role based security) is available for many systems. The setup needs to be specific and carefully setup.
· Configure system documents to suit your needs such as:
· Customer invoices
· Customer statements
· Payroll checks
· Vendor checks
· Purchase Orders
· Sales Quotes, etc.
· Create custom reports to provide information in a format you need. These reports incorporate both operational areas as well as financial areas.
· Establish any needed “tie in” with other software such as importing data from an E-commerce application or from a time clock. Integration with other systems will vary based on your individual system. All require attention for security, backup and the ability to recover from a failed import.
Accounting system configuration
· Establish your company chart of accounts for assets, liabilities, equity, sales and expenses
· Establish company divisions, departments and cost centers as needed
· Load the following actual data:
· All customer information into Accounts Receivable and establish new customer default AR information
· All vendor information into Accounts Payable and establish new vendor default AP information
· All Inventory items into Inventory Control and establish new part default IC information
· All employees information into Payroll and establish new employee information – payroll must be handled very carefully as the data in the system must feed to quarterly payroll reports correctly and year to date numbers are vital to a clean cut over.
· Load specific figures so as to support the Trial Balance amounts for these accounts:
· Some people need history transactions– see the implementation plan
· The integrity of the old data must be determined.
· Before and after reports must be run to confirm that the data imported flowed through correctly. We recommending bringing in non master record information through data entry screens to have it post through where possible. This checks the data integrity and lets you keep drill downs inherent in most of today’s systems.
· Accounts Receivable all open unpaid invoices
· Accounts Payable all open unpaid invoices
· Inventory Control all current inventory stats including: quantity on hand, quantity on order by customers, quantity on order from vendors, current cost per item in stock, etc
· Payroll all individual payroll amounts per employee for current and former employees for the current year and quarter including pay, individual Federal, state, local and unemployment taxes paid and withheld
· Load other specific information to support the actual business condition at the time of conversion
· Purchase Order all open purchase order detail
· Sales Orders all open sales orders detail
· Job Cost all open jobs detail information and costs
· Bill of Materials all BOM “recipes”
System training
· Software providers include training on the software use tailored to specific individuals based on their area of responsibilities for example train payroll department employees are trained on employee adds, changes and terminations; recording employee payroll data, preparing various tax reports, procedures to close a month and year and processing various year end tax reports.
· Training needs to be timed correctly so it is long enough ahead of go live to learn, but so far ahead where employees forget what they learned.
· Although most companies employ smart people, they are not experts on the systems they are implementing.
· Training of new employees that did not sit in on the initial training is vital to avoid “attrition of knowledge”.
· Update training when new versions come out. It is a waste to install a new version and not know the new features.