Cash Focus

1. FOR WINDOWS For budgets and cash flow forecasts, and rolling revised forecasts. Cash Focus INTRODUCING CASH FOCUS Budgeting and Cash Flow Forecasting Software Cash Focus utilises traditional debit and credit accounting methodologies to produce fully integrated budgeted profit and loss statements, balance sheets and forecast cash flows that mirror your financial reports. Performs consolidations, ‘What if?’ scenarios, graphs and ratios for any retail, service, manufacturing, or agricultural businesses.

2. Cash Focus Cash Focus provides a standard platform for reporting by client, division, business unit and product. Cash Focus for Windows is designed to guide you through the budget building process. It is comprehensive, flexible and sophisticated, yet easy to use. With an auto set-up feature to take you through the steps of setting up a new forecast. Click on the Revenue button and add “Account Groups” and “Sub- Headings” to replicate your financial statements. Link any number of detail account lines to the Groups and Headings. See here the revenue group “Export Sales” and sub headings “Chemicals and Herbicides”. Each detailed account line has its own budget and cash flow timing assumption window. Click on the New icon to add an Account line or Heading. Use your systems chart of accounts for the short code and your codes. Choose to budget an “amount” or “price and quantity”, simple Cost of Sales %, the GST rate and currency. Cash Focus uses the short code for sorting items into alpha and numeric order and for consolidations. Your codes are used for importing budget, actual and forecast data, and exporting budget data.

3. Cash Focus Edit the cash flow timing assumptions to reflect how you intend to collect revenues and pay expenses in percentage terms. When required add special timings for each forecast period per line. See previous page for the special “PROMO” timing assumption under CI column in the budget window. Add or delete the timing “Marks” to turn the cash flow timing assumption on or off to accrue revenues and expenses. See here the FBT expense accrued to the June, Sept and Dec calendar quarters and paid one month following the timing mark. Add as many Inventory, Work In Progress and Finished Goods accounts as required. Choose from the default “purchases calculated”, “Inventory level specified” or “Purchases specified” methods to control inventory. See here the Purchases specified method where budgeted purchases are specified for each month independent of Cost of Goods sold.

4. Cash Focus Add as many Inventory related Cost of Sales lines and specify the COS percentage for each month. Click new and add as many direct production expenses as required. When adding a new account choose to enter the budget as an Amount, a Percentage to Sales, Variable on another expense, Cost price and quantity, (independent of sales) or, Cost price linked to a revenue line quantity. Link the COS account to a revenue and inventory line. Create direct non inventory Cost of Sales Expense lines. Capitalise production expenditure to WIP or Raw materials inventory accounts. See here Wages-Direct variable on sales with 79% paid in Cash and 21% paid the following month. Note the timing assumption. Wages are accrued to the balance sheet accounts A/E and PAYE then reversed according to the cash flow timing assumption.

5. Cash Focus Add as many Fixed Assets lines as required. Choose from Straight Line or Diminishing Value depreciation Add any P&I, interest only, simple interest, lease or HP loan. Add to the loan or payback as cash flow permits. See here a R1.5m P&I loan for 10 months with R50k added and R90k paid back. Click on proceed and load the budget. When finished click “Activate” and Cash Focus will create a full P&L statement balance sheet and cash flow statement. Click “View” and see a full Debit and Credit drill down of the detail behind any number. See here a print out of the bank statement for April with the details of all transactions.

6. Cash Focus The unique debit/credit accounting methodology guarantees balance sheets balance to at least two decimal places. Consolidate any number of divisional/company Budget or Rolling Forecast models with the model selector. Click “Reports” and preview one of a number of preformatted P&L accounts, balance sheets and cash flow statements before printing. See here a preview of a Profit and loss statement. Or use the Report Wizard to customize your own reports

7. Cash Focus Save the Budget model again as a Forecast model and roll it over a month. Substitute the first months forecast with “actual results” and re Activate to calculate a revised balance sheet and cash flows. Compare actual results to the budget and forecast. See here a forecast report with actual results and forecast to the end of the year. Delegate budgeting tasks with confidence. Challenge the balance sheet and cash flow timings by printing and reviewing a timing “Assumptions” report. See here the detailed cash flow timings for every account line. See what bank account, debtor and creditor account is used. See how opening debtors (A/R) are collected. 60% I month following the opening balance sheet, 20% 2 months following and 20% 3 months following. Select any P&L, balance sheet, cash flow or ratio, and Cash Focus will automatically create a a 2 or 3D graph. Cut and paste to a document as shown or print direct. Cash Focus is sold and supported by for ATS Database Services (Pty) Ltd 437 Jan Smuts Ave, Blairgowrie, Randburg South Africa 2194 Tel: +27 11 886 1740 Fax: +27 11 886 1786 Email: info@ats.co.za Web|: www.ats.co.za or Web www.cashfocus.com