Sub-Ledger Reconciliations
View Fact Sheet (PDF) | Product Demonstration (Powerpoint)
These utilities enable SYSPRO users to readily monitor, maintain and prove the integrity of their sub-ledger control accounts. Transactions posted in the source modules are checked at each step of their paths to the General Ledger control accounts and any differences between them are shown. Users are provided with the information required to take corrective action.
Reconciliations are currently available for:
| Accounts Payable | Goods in Transit |
| Accounts Receivable | GRN Suspense |
| Cash Book | Dispatch Notes |
| Assets Register | Work in Progress |
| Inventory | WIP Inspection |
If you have any questions or would like to see the product running on your own data, please email us at info@datarapt.com
General Product Information
Our products are designed for ease of installation, implementation and ongoing use. We are constantly striving to improve the products and welcome dealer and customer feedback.
The distribution files conform to the requirements of SYSPRO’s Upgrade program, so the products can be installed by simply placing the file in the upgrade folder and then running SYSPRO.
C-ISAM and SQL are supported with separate coding to ensure good performance on both platforms.
What about SYSPRO 6.1 and real-time GL integration?
Is there an evaluation version of the Sub-Ledger Reconciliations?
How do I get the software?
Is there a way to see the product working without requesting an activation key?
How are the Sub-Ledger Reconciliations priced?
What are my licensing options?
I don’t have all of the modules included in the Sub-Ledger Reconciliation bundle; do I have to purchase all of the reconciliations?
Is the cost of a license per SYSPRO company or is it per server?
On which SYSPRO versions do the reconciliations run?
On which platforms does the software run?
How do I get software updates?
Is there documentation to help me install and run the product?
What about SYSPRO 6.1 and real-time GL integration?
DataRapt reconciliations identify the individual variances that make up any difference between a SYSPRO sub-ledger balance and the balances of the GL control accounts for the sub-ledger. These variances can be caused by: entries not yet posted to the GL (such as unprinted journals and distribution reports), user error (like incorrect GL integration entries or selection of control accounts when capturing distribution entries), data corruption due to hardware/network problems, or SYSPRO program errors.
Depending on how you choose to run the real-time GL integration, it could alleviate variances caused by entries not yet posted to the GL but all of the other types of variances will be unaffected by real-time GL integration.
So, the DataRapt reconciliations will continue to provide the most efficient method of validating your control accounts and the peace of mind that your financial reporting is based on accurate figures.
Top of pageIs there an evaluation version of the Sub-Ledger Reconciliations?
Yes, we offer a free 7 day trial license that allows you to see the reconciliations running on your own data.
Top of pageHow do I get the software?
You can either contact your VAR or contact us directly to arrange the installation. Once the software is installed, you can request a 7 day activation key from within the product.
Top of pageIs there a way to see the product working without requesting an activation key?
Yes, you can run the product without an activation key on The OUTDOORS Company if you have the sample demo data as distributed by SYSPRO installed.
Top of pageHow are the Sub-Ledger Reconciliations priced?
The pricing is based on the number of Users licensed to run SYSPRO.
Top of pageWhat are my licensing options?
You can either purchase a license to run the software and then pay an Annual License Fee that covers ongoing development or alternatively, you can choose a six monthly rental license.
Top of pageI don’t have all of the modules included in the Sub-Ledger Reconciliation bundle; do I have to purchase all of the reconciliations?
No, you can purchase reconciliations just for the modules that you run. However, this option is not available if you opt for a rental license.
Top of pageIs the cost of a license per SYSPRO company or is it per server?
The cost of a license is per server and therefore the reconciliations can be run on any SYSPRO company running on that server. If you have SYSPRO companies running on more than one server though you will need to purchase a separate license for each additional server.
Top of pageOn which SYSPRO versions do the reconciliations run?
The Sub-Ledger Reconciliations can be run on SYSPRO Version 6.0 Issue 010 SP1 and later.
Top of pageOn which platforms does the software run?
The software currently runs on Windows platforms only. Please do contact us though if you require the software on Unix.
Top of pageHow do I get software updates?
Once the software is installed, updates can either be obtained from your VAR or you can download updates directly from our web site once you have registered for access to our Support Site.
Top of pageIs there documentation to help me install and run the product?
In addition to the context sensitive help distributed with the product, there is an installation guide and detailed reference guides per reconciliation. The installation and reference guides can be downloaded from our Support Site.
Top of page
Altech UEC is a leading developer of digital technology for the international Pay-TV industry and specializes in the provision of integrated solutions comprising specialized hardware supported by innovative software solutions and global logistical support services.
ALTECH UEC's innovative technologies can be found in homes across the world providing over 20 million people with a reliable and affordable gateway to digital television based entertainment, education and information.
The Challenge
Enjoying an enviable reputation amongst its partners and peers as one of the most technologically competent businesses in the industry, Altech UEC is consistently first to market with innovative products incorporating the very latest technologies. Altech UEC uses SYSPRO enterprise software to affect the stringent financial, inventory and production controls required to maintain this reputation.
Manual reconciliation of sub-ledger control accounts is undertaken by members of the finance team at Head Office on a monthly basis. Once basic differences such as journal entries have been eliminated, any remaining discrepancies are investigated by the IT department. This has proved to be a time consuming and frustrating exercise which involves spreadsheets, queries and manual comparison, and is not always conclusive.
The Solution
After seeing a demonstration of the DataRapt product, the Altech UEC team was convinced that it was the solution they were looking for. They were particularly impressed with the simplicity of operation, and the speed with which all variances were identified.
The Result
Altech UEC were able to identify and action all control account discrepancies in preparation for the year-end audit, and are in the process of incorporating the DataRapt reconciliations into their daily process. The facility to automate the programs to run overnight without the need for a session recorder is an added advantage in this process. This will enable the finance team to monitor the control accounts on a daily basis, eliminating month-end pressures.
In addition, Altech UEC has been able to identify areas where staff training is required.
Chubb, a world leader in security and fire protection services is made up of four divisions in South Africa, namely Chubb Electronic Security, Chubb Integrated Systems and Chubb Fire Services which incorporates Angus Fire. The company has combined 185 years of safety expertise with world class state-of-the-art technology and a highly skilled work force to provide customers with absolute confidence in their security systems and services. Chubb’s national footprint and ability to integrate various security services, combined with ongoing innovation, is clearly a key differentiation from local and international competitors.
The Challenge
Chubb uses a wide area network to deliver SYSPRO to over 300 staff members across the country. All sub-ledger transactions are captured at source into separate SYSPRO companies configured for each region.
Consolidated financial statements for the group are prepared by a centralized finance team. In order to meet stringent reporting deadlines, the team has adopted a "today's work today" philosophy, and all sub-ledger control accounts are required to be reconciled daily. This has proved to be a time consuming and costly exercise given the number of control accounts to be reconciled and the large number of transactions captured daily at Chubb offices throughout South Africa.
The Solution
After seeing a demonstration of the DataRapt product, the Chubb team was convinced that it was the solution they were looking for. They were particularly impressed with the “What Next?” function which gives an indication of the likely cause of each variance and provides guidelines for corrective action together with hyperlinks to access the SYSPRO programs required to deal with the variance. Another strong selling point was the facility to automate the programs to run overnight without the need for a session recorder.
The Result
Chubb have automated the DataRapt reconciliations as part of their day-end process, and are now able to review and maintain their control accounts on a daily basis.
