Cashflow Forecasting for Sage 300

Overview

Why SYSTRONICS Cashflow Forecasting?

SYSTRONICS Cashflow Forecasting™ for Sage 300 forecasts daily bank balances up to a user specified date, spotting liquidity issues or excess cash. Cash inflows and outflows are projected based on the following Sage 300 documents:

• A/R Invoice
• A/P Invoice
• Purchase Order
• Sales Order
• G/L Budget

The users can enter their own projected transactions to run "what if" scenarios.

• Automatically prepares the forecast based on Sage 300 transactions and data.
• All of processing is run inside Sage 300 without any involvement of spreadsheets or external applications.
• The forecasting process is flexible, so that the users can delete/add new transactions to the forecast or modify the projected ones.
• Projected transactions can be converted to actual Sage 300 transactions upon maturity.
• Bank overdraft limits can be defined to easily spot the transactions that put the account balance below the overdraft limit .

Qualification Questions

Business Problems Solved

• Do you regularly miss payment of invoices or use the overdraft excessively because of poor cash planning?
• Do you spent too much time on exporting the information from Sage 300 to your cash flow forecasting spreadsheet model?

• Cash treasurer has all necessary data to plan the optimal cash balance so that all obligations are timely met and at the same no cash is frozen in the bank account
• Cash treasurer has all necessary data to plan the optimal cash balance so that all obligations are timely met and at the same no cash is frozen in the bank account

Customer stories

• Profile: Large retailer.

• Business Problem: The existing cash flow forecasting spreadsheet model harvested the data only from the Invoices, meanwhile The CFO has asked accounting team to include the Purchase and Sales Orders in the cash forecast as well to make it more precise. This was an impossible task for the accounting team, since none of them was proficient in SQL and knew ins and outs of Sage 300 tables.

• Solution: SYSTRONICS Cashflow Forecasting for Sage 300 took care of all complexities related to retrieving the data from database.

• Results: The accounting team obtained a detailed daily cash flow forecast based on both invoices and orders, without executing a single query or opening a spreadsheet file.

• Profile: Manufacturer of Furniture

• Business Problem: The Company’s supply chain policy was to its supplies frequently in small quantities, rather than to buy large lots. This strategy resulted in a large number of Invoices, that ly complicated the cash flow forecasting and management.

• Solution: SYSTRONICS Cashflow Forecasting with its functionality to convert the projected payments into actual Sage 300 payments was an ideal solution.

• Results: Not only the cash flow forecasting has been streamlined, but the accounting team did not have to re-enter the Invoice payments when the documents were due. Instead, they simply converted the projected payments auto-generated by Cashflow Forecasting into real ones.

Sales Proposition

Upset your Bank! Push your cash management efficiency to the limit.