Sage 300 Payroll Data Input Automation

AutoSoft Systems

2 Round Hill Court

East Greenwich, RI 02818

401.885.3631

401.884.5653 Fax

401.996.3631 Cell

AMDG

Decision Ready Information!

autosoft@aol.com

Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems. Founded in 1982.

We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.

Pharmaceutical & Biotech

Construction Management

AMDG

Sage 300 Payroll Data Input Automation

Sage 300 is the leading Construction and Real Estate property management software. Construction companies typically use a payroll service. Sage's accounting module needs accurate and complete payroll information. Sage has never developed a tool to automatically import payroll data from a payroll service. AutoSoft Systems has developed this tool.

This approach solves the age-old problem of data double entry into different corporate computer software packages. This same approach can be used to solve any double-entry issue.

This tool is a semi-automatic tool. It simulates the process of a Sage user sitting down in front of the keyboard and manually entering data into the Sage interface. This assures that all of the data goes in correctly and that all Sage business rules are applied properly. Each individual payroll entry takes seconds as the computer types by itself at lightning speed. After each entry the program pauses and asks the user if the entry was successful. Each entry takes seconds increases data entry accuracy and reduces the data entry time by 90%

The main screen of the program allows the user to harvest payroll information from Sage and translate the payroll service's report into a format that can be imported.

This is an example of a typical payroll report from the payroll service. This is the starting point.

The tool translates the payroll file into a file for automated data entry through the Sage user interface, entering up to 10 entries a minute. If the data goes in without issue, the "Process Notes" column turns green. If an issue arises, the "Comments" column provides the user with a number of messages to describe the issue so that it can be quickly fixed.

AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631

This web page was last updated at 04/30/2015 03:36 PM and is written in EXCEL!

Sage 300 is a Trademark of Sage Software - AutoSoft Systems is not affiliated with Sage Software