ToolPac for Sage 300

Overview

Why SYSTRONICS ToolPac?

SYSTRONICS ToolPac™ for Sage 300 is a reconciliation tool designed to help spotting mismatches between Sage 300 sub-ledgers and corresponding Control and Clearing Accounts in G/L. ToolPac is packaged in 5 different Toolsets, each addressing a specific sub-ledger in Sage 300.

The following Toolsets are available

• O/E Reconciliation
• P/O Reconciliation
• A/R Reconciliation
• A/P Reconciliation
• I/C Reconciliation

• Cuts time and cost spent on finding transactions causing mismatches between G/L and subledger balances significantly
• Flexible packaging, i.e. you can subscribe to each Toolset separately
• Allows saving reconciliation results for later use
• Allows assigning G/L-Subledger reconciliation tasks to virtually anyone in your accounting team, because processing is done inside ToolPac, eliminating the need to employ spreadsheets or run database queries

Qualification Questions

Business Problems Solved

• How often do mismatches between subledgers and the General Ledger occur in your or your customers' Sage 300 setup?
• How much time do you spend on identifying transactions causing such mismatches?
• Do you want to quickly identify Shipments or Receipts that have not been invoiced yet?
• Do you have pending balances on Payables and Shipments Clearing Accounts, which you want to trace back to their corresponding source subledger documents?
• Do you want to incorporate the G/L-Subledger reconciliation process into routine tasks in Sage 300 maintenance?

• Identifies problematic transactions causing mismatches between the G/L and subledger balances for further corrective action
• Filters Shipments and Receipts that have not been invoiced

Customer stories

• Profile: A Sage 300 Business Partner

• Business Problem: One of the most frequent problems reported by the Business Partner's customers was the mismatch between G/L and subledgers. Consultants spent hours and days to identify problematic transactions causing the mismatch.

• Solution: The Business Partner subscribed for ToolPac Toolsets, replacing home-grown reconciliation tools that mainly consisted of spreadsheets and database queries.

• Results: Delegating reconciliation to ToolPac reduced time spent on diagnosis to minutes, resulting in reduced processing costs and increasing customer satisfaction.

• Profile: Wholesale Electronics Trader

• Business Problem: When closing the year, the Accounts Team found out that the total balance in the Accounts Receivable Subledger did not tally with the net balances of the corresponding Control Accounts in G/L. Days were spent on finding the source of mismatch, without any results.

• Solution: The customer's Business Partner advised using the ToolPac A/R Reconciliation Toolset.

• Results: Within minutes, ToolPac identified about 25 G/L transactions, out of 10,000, originating from A/R documents that were manually modified before posting to G/L, thus artificially increasing the balances of corresponding Control Accounts.

  With this information in hand, the Accounts Team quickly entered adjustment entries in G/L and eliminated the discrepancies between A/R and G/L.

Sales Proposition

Spots discrepancies between G/L and subledger balances in minutes.