Home

foreCASH User Guide

1. Barclays current Unused overdraft 61 275 10 127 10 127 10 127 25 000 25 000 25 000 Petty Cash Unused overdraft 0 0 0 0 0 0 0 Euro account Unused overdraft 0 0 0 0 0 0 Unused overdraft 0 0 61 275 10 127 10 127 10 127 25 000 25 000 25 000 Barclays current Cash Available 25 000 25 000 86 275 35 127 35 127 35 127 236 303 236 303 236 303 Petty Cash Cash Available 127 127 127 127 127 127 127 127 127 Euro account Cash Available 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000 Cash Available 14 873 14 873 76 148 25 000 25 000 25 000 246 430 246 430 246 430 Barclays current ABL Borrowed 0 0 0 1 319 1 319 1 319 0 51 57 ABL Borrowed 0 0 0 1 319 1 319 1 319 0 51 57 Barclays current Cash less ABL borrowed 25 000 25 000 86 275 36 446 36 446 36 446 211 303 211 252 211 246 Petty Cash Cash 127 127 127 127 127 127 127 127 127 Euro account Cash 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000 Cash less ABL borrowed 14 873 14 873 76 148 26 319 26 319 26 319 221 430 221 379 221 373 Page 130 of 182 E support foreCASH co uk fo re C A S H j Headroom Shortfall OYAN IOUNUG ewuuu ewuuu ew uuu ewuvu ewuvu ew uuu ew uvvu ew uvu ev Undrawn ABL capped 41 997 41 997 41 997 134 713 113 157 110 647 Headroom Shott fall ABL borrowed 1 319 57
2. Sales can also be re allocated by using the reconcile option Once sales on a date have been reconciled the amount cannot be altered further Page 163 of 182 E support foreCASH co uk fo re C A S H 10 4 1 Proof of deliveries and their impact on approved ABL sales Your ABL lender may on either a random basis or for large invoices require proof of delivery POD of goods relating to your sales foreCASH allows you to enter POD requests together with the anticipated date of release of the invoice The release date is the date on which your lender acknowledges the POD and allows an invoice to resume its part in qualifying sales submissions If the actual release date varies from that originally anticipated you may go back and amend the POD information Sales total Proof of delivery time delays Adjusted sales net Gross sales inc VAT 6 i Advance against sales 85 105 364 DESS taney FOD detai P FOD ataie ABL processed amp available 219 72 Customer ref name POD cumulative balance Ref inv 28970 Comment DHL chased 5 10 Amount 6 000 Origin date 05 Oct 07 Release date 10 Oct 07 i r Save Close Save Close The POD data entry screens are accessed by right clicking on a white cell in the Proof of delivery time delay row visible on the lower grid during the selection of sales Page 164 of 182 E support foreCASH co uk fore
3. 1 319 51 1 319 Barclays current Barclays current Net cash 25 000 25 000 86 275 35 127 35 127 35 127 211 303 211 303 211 303 Barclays current Overdraft facilities 25 000 25 000 25 000 25 000 25 000 25 000 25 000 25 000 25 000 Barclays current Undrawn ABL 0 0 0 41 997 41 997 41 997 134 713 113 157 110 647 Barclays current ABL Borrowed 0 0 0 1 319 1 319 1 319 0 51 57 Barclays current Cash less ABL borrowed 25 000 86 275 36 446 36 446 36 446 211 303 211 252 211 246 Petty Cash Petty Cash Net cash 127 127 127 127 127 127 127 127 Petty Cash Overdraft facilities 0 0 0 0 0 0 0 oa Euro account Euro account Net cash 15 000 15 000 15 000 15 000 15 000 15 000 15 000 15 000 Euro account Overdraft facilities 0 0 0 0 0 0 it 0 i ABL Borrowed Overview of ABL Invoice discounting accounts Clicking on the Sales Impact or Collections Impact lines opens up the more detailed ABL section where ABL sales collections and draw down can be adjusted See section 10 Headioom Short fall 10 127 61 148 41 997 41 997 41 997 111 717 133 273 198 783 ABL borrowed 1 319 1 319 Invoice Asset BL Daily Draw GBP ABL 1 207 246 430 0 0 Borrowed ABL GBP ABL 0 1 319 0 51 57 C F in available uncapped GBP ABL 41 997 134 713 113 157 110 647 41 997 41 997 GBP ABL b f avail uncapped 0 134 713 1
4. Minimum Rounded Exact Min Facility details p O1Jan 12 85 875 000 Click hee O O1Jun 13 85 925 000 Click here The advance rate and cap can be varied with the facility in place from a given date onwards until superseded If you operate more than one ABL facility a borrowing cap for each facility and an overall cap can be specified The total borrowing cap will be spread across the facilities in the order they appear in the banking set up tabs Page 28 of 182 E support foreCASH co uk fo re C A S H 3 2 4 1 Limits on the size of individual customers balance If your lender specifies an allowable percentage limit on how large a part of your ledger any one customer can be foreCASH can model this Any excess will be removed from the forecast level of borrowing available from the lender Bank facility details Account Description bank_description Asset based lending cleared draw down account Upon flex drag drop re display No one account to 100 of total allowable ledger for this ABL account 100 of total allowable of ALL ledgers on ALL ABL accounts Recalc excess excel 3 after date of newest manuallitem 7 Change amount gt 1 000 7 OR after Month end z Set accounts to which percentage limits apply cren when Customer account Select All Percantage limitations may only need to be applied to high risk accounts Grouped accounts
5. Down Top and Bottom buttons Drivers Ledgers Supe Te i Adin de Suppliers Pool Default or COS category Key Suppliers COS 9 Ref Amount JVC002 PANA007 12 349 SONYOO1 15 000 R Top RADIO009 50 500 2 U PIONEEROO2 10 000 Poe TELACCOO2 5 000 Down Bottom ROYALIOO7 To add to key accounts either highlight selection above and press the Add gt button or double click your selection Suppliers in other categories unavailable for COS ranking Ref Amount ABCWHAOO1 500 BARCOO4 10 BGASOO1 761 BT_001 970 250 Key Account Total 142 849 90 6 o 3 256 Grand Total 157 712 p To remove item from key accounts either highlight selection above and press the lt 752 Rem button or double click your selection Press lt lt All to clear all of key accounts View ledger The process for customers mirrors that for suppliers In addition to individual key accounts you could also allocate a place in the ranked items for a particular group of customers with a common payment pattern such as web sales made on credit cards Use the Add new delete tab to create a new customer group Page 52 of 182 E support foreCASH co uk fo re C A S H j 3 5 4 Non standard terms All customers and suppliers when imported for the first time will be assigned the default rules prevailing at that time most importantly the settlement terms Use the
6. 3 2 3 stock based lendingi import lOAMS 2i s csctasteseeladeaseuceveezcanescevsteds ecesa secant aeiaai aaa adinira derici eviceeapannened saneeua asus 3 2 3 1 Stock based facility month end stock level 3 2 3 2 Import loan facility eee eeeeeeeeeeeeeeeeeeeeees 3 2 4 Asset Based Lending Invoice Discounting 3 2 4 1 Limits on the size of individual customers balance cccecceceseceneeeeeceeeaeeceaeeeeceeeseeeeaeeeeeeeseaeeeeaeeseaeesseeseaeeseaeessaeeseaeessaes 3 2 4 2 Lender advances against Un cleared receipts cee eeceeeeeeeeeeceeeeeeceaeeeeecaeeeaeceaeeaeeeaeeseeeaeeeaeseesaeeeaeseeeeaeseeeeaeesaeseeseaeeeneees 3 2 4 3 Multiple invoice discounting accounts 3 2 5 Loan faciliti Sionissa 3 2 5 1 Autocalc loans 3 2 5 2 Manual loans 3 3 Set General Drivers Rules 3 3 1 VAT pisticsaataanans 3 3 2 Import VAT 3 3 3 Import Duty aseen 3 3 3 1 Import duty COS and stock 05 3 3 4 Supplier and Customer ledger defaults 3 3 5 Working trading days of the week 3 4 Importing customer and supplier ledgers 3 4 1 Choose customers or suppliers and locate the import file 3 4 2 Ledger import settings Mapping sssr 3 4 2 1 Fields included in your file for import eeeeeeeeeeeeeees 3 4 2 2 Mapping Setting the order of Fields included in your file eeeeceeceeseeeeeeeeeeeeeeeeeaeeeeeeaeeeaeseeeaeeeeeseesaeeneeeaee
7. Excess share 201398 Argos Ltd predicted to exceed limit Excess share 201398 Argos Ltd predicted to exceed limit 01 Aug 13 02 Aug 13 05 Aug 13 Excess share 201398 Argos Ltd H predicted to exceed limit 06 Aug 13 Excess share 201398 Argos Ltd predicted to exceed limit 07 Aug 13 Excess share 201398 Argos Ltd F predicted to exceed limit 08 Aug 13 Excess share 201398 Argos Ltd predicted to exceed limit 51 990 09 Aug 13 Furrss X share 2M1398 Arans td fh nredicted ta exceed limit f 19 Auin 13 V Hide reconciled 6 009 20 384 833 6 009 31 616 80 919 6 009 zx ngee 2 75 75 75 5 263 60 689 4 507 0 0 0 6 91 gt gt gt Cumulative disallowed POD aaed SA gt 0 79 0861 73 0771 93 4611 93 4611 93 4611 93 4611 84 169 fi Viewing disallowed invoices due to excess limit after cash flow calculation run Page 29 of 182 E support foreCASH co uk fore CAS H a 3 2 4 2 Lender advances against un cleared receipts Some Asset Based Lenders collect money into one bank account and only when the collections have cleared are they swept into the draw down account This is the default option in foreCASH If your lender operates with a single account and calculates amounts available for draw down based on all receipts even when un cleared you need to specify this under the ABL Collections account using the lender will Advance Against Un cleared Items check
8. Consolidator version of foreCASH allows forecasts for a number of companies to be aggregated into a consolidated group forecasts These features must be activated with a specific licence code Please contact support or refer to the full user guide for more information See section 12 Page 9 of 182 E support foreCASH co uk fo re CA S H 2 3 Network shared drive foreCASH allows you to store your forecasts on Your local PC hard drive A shared drive such as your company network 2 3 1 Setting the shared drive location first user If you wish navigate to a folder which a colleague has previously specified as their shared To change the shared drive location From the Company Selection screen presented after login or via Change Version Company options First Click on the Shared Data button foreCASH Select Company Version company Shared Company Select Delete I acd company Import comp Import comp Delete now Delete now Copy shared gt lt Copy local fd 1 Demo_standard l Standard 19701 2011 2 Demo_manufacturing Manuf 1970172011 Import version 3 Project Comp l Standard 19 01 2011 4 Electrical Wholesale 2 l Standard 19201 2011 Delete now l Standard 19 01 2011 Edit descrip Local gt shared Selected database ref local wkforecash111_5 mdb Companies licenced E Refresh Exit Page 10 of 182 E support foreCASH co uk fore CAS H Navig
9. E support foreCASH co uk fo re C A S H 7 check the Make accrual for previous invoice as not in ledger box For the example above this would force foreCASH to schedule a specific payment in January 08 The periodic payment should be entered excluding net of any VAT If your ledger includes an invoice for an annual charge that is paid off in monthly instalments you may wish to exclude the ledger item from scheduled payments use term Never__ Annual invoice model with recurring and then use a monthly recurring payment This approach is best used with items that do not attract VAT such as annual insurance invoices 3 10 3 Irregular overheads Irregular overheads can be modelled using either a simple or complex model 3 10 3 1 Simple irregular overheads Simple Irregular overheads payments can be scheduled using a Calendar View By setting the Invoice date VAT offset point foreCASH will determine which month the invoice was raised by the supplier and will charge the expense to the profit and loss in that month Irregular expenditure item Description or reference Southern Exhibtion 0 invoiced in same month Invoice date VAT point offset relative to payment date in months ja 7 aby A Se eel month before payment Overheads VAT reclaim applies IV Total amount l 9599 Expense will be charged to the P and L based on the Invoice x point Type Please add amounts for irregular costs
10. The split of sales by supplier in later steps is based on the Recognised Revenue NB If WIP Revenue Recognition is being used Sales Flexing is disabled in the current version Page 103 of 182 E support foreCASH co uk fo re C A S H j 3 7 2 4 Margin by supplier In order to calculate the level of goods being purchased to fulfil your sales the rate of gross margin by supplier is required The margin rate can be set at a fixed level or the rate may be varied across each month of the forecast as required Sales and stock forecast Step 1 Order preference Il Step 2 Sales by Customer j upp Step 4 Sales by Supplier I Variable by month Margin Margin Margin Margin Margin Margin Margin Margin Margin Jan 08 Feb 08 Mar 08 Apr 08 May 08 Jun 08 Jul 08 Aug 08 Sep 08 10 0 10 0 10 0 10 0 10 0 10 0 10 0 10 0 10 0 1 10 0 10 0 Please note that this screen collects gross margin as opposed to mark up percentages Page 104 of 182 E support foreCASH co uk fo re CA S H 3 7 2 5 Sales by supplier In order to forecast the expected stock and purchasing levels it is necessary to know the split of the sales by the underlying suppliers of the items sold This is the gross sales value including any margin Sales and stock forecast Step 1 Order preference Step 2 Sales by Customer Step 3 Margin by Supplier Step 4 Sales by Supplier Step 5 Stock by Supplier Jan 08 Mar 08 Apr 08 May 08 Jun 08
11. a Merge amp Ce T Erea aae Erg z SEAN ENE Clipboard g Font i Alignment Sipboand E Alig numer Al ba f ResellerPack fcv 76 las 7 fail ResellerPack fov 76 5 a o ReselerPacktevi766 S ResellerPack fcv 76 6 ResellerPack fcv 76 6 2 2 Opening Jan 08 Feb 08 N 3 Barclays current Currency Sterling 3 4 Interest rate not set 4 Current Accounts 5 Interest accumulation default 5 Barclays current 25 000 403 462 226 895 2T 6 Interest freq not set 6 Petty Cash 127 127 127 7 Autosweep options off 7 Euro account 10 000 10 000 92 674 14 8 Details 8 14 873 413 589 134 348 73 3 From 01 01 2008 to 02 04 2009 facility of 25 000 9 11 Petty Cash _Currency Sterling l 13 12 Interest rate not set 14 Asset Based Invoice Finance Lending Accounts 13 Interest accumulation default 15 bank description 14 Interest freq not set 16 Borrowed BF 219 540 21 Ee Autosweep options off 17 Drawn 378 500 136 100 15 16 Details 18 Receipts 158 960 143 518 171 17 From start to end facility of 0 19 Fees Int 19 Euro account _Currency Euro 20 Borrowed CF 219 540 212 122 19 20 Interest rate not set 21 Interest accumulation default 22 Ledger CF i 302 478 258 388 250 404 22 22 Interest freq not set 23 Perc Borrowed inc month end fees 84 97 84 71 8 23 Autosweep options off 24 Adv Perc 85 00 85 00 85 00 8 24 Details 25 Cap 1 000 000 1 000 000 1 001 25 From start to end facility of
12. bank statement view via Reports gt Export Main forecast gt Bank statement Oa ed 9 io amp C Ga foreCASH_Detailvixl Compatib 1 Showing All Current Standard Bank Accounts 2 Date Description 3 Bf Opening Balance 02 Jan 2008 JVCOO2 JVC 3 SHOP2 Out of town nes Pool non ABL ED act 8 SHOP1 60 High Street 5 EURO CUsT euro cust 10 03 Jan 2008 Bank transfer ar JVCO02 JVC 12 PIONEEROO2 Pioneer 13 Pool COS 14 Pool Gen OH 15 os AGG test 16 Pool Capex 17 Dividends paid 18 Bank transfer 19 SHOP1 60 High Street 20 SHOP2 Out of town 21 WEBSITE Web sales paid by credit cards 22 EURO CUsT euro cust 23 Pool non ABL 24 EURO CUsT euro cust 25 04 Jan 2008 Bank transfer 26 JVC002 JVC 27 PIONEEROO2 Pioneer 28 Pool Gen OH 29 Bank transfer 30 SHOP1 60 Hish Street The report will show either all accounts or a single account based on the Now Showing option in the daily cash forecast Receipt 14 063 4 854 350 10 000 376 399 10 500 50 000 193 000 7 313 800 1 200 191 651 Page 146 of 182 1 700 144 000 191 651 260 5 127 168 814 238 328 Home Insert Page Layout Formulas Data Review View Developer Sage a Act Calibri 2n EN RA gt p Wrap Text Custom 7 E 2a Copy a ee E ME rom rona EEE tee coe B EE eng Clipboard Sa Font FI
13. ob ebb bob a bad hi ai E a f RFR RR ROR RE Sd oe a 2 Rog R fe sacked n top ofthe green surplus defers management this If before management actions there surplus pene the a surp s is shown in gre cranes improvements in the ta cast position is point and reduce the deficit Any unresolved deficit is shown isa cash su action there is a deficit the exte n ofthe defer is the bw st poi e graph Inprowmments to management actions are stacked bow ined NB any adverse fexing collection deferals or payment ot advances wil be inouded i the bas e position p base suplus P sates texing p Detemed payments Unresolved deficit Stock flexing D Arance cotlections Page 1of4 Zero on the x axis represents the available facilities on any given day The lowest point on the graph in any given day is the bank position under the base forecast plus any re scheduling or flexing that have an adverse impact on the cash position Rescheduling and flexing actions that have a beneficial impact on cash flow are layered above this point Page 156 of 182 E support foreCASH co uk fore CAS H 7 12 Supplier strain report An overview of the number and cumulative value of any deferrals applied to supplier payments can be viewed Suppier strain sd a hox x foreC ASH for XaYbZc Limited Dataload date 34 08 2007 Supplier DEF 321 wary January February March April Number of payments deferred Gross payments deferred 1200000 650
14. will vary the stock level for all suppliers in order to hit the target number of stock days subject to not generating negative purchases Stock days are based on the following months COS cost of sales Editing the target stock days for any one supplier will apply this new target days to all months for the supplier If there are COS cost of sales in the following month the target stock days for a given supplier in a given month may be set Quick fill options Apply gt gt will vary the stock level for all suppliers in order to hit the target number of stock days subject to not generating negative purchases Stock days are based on the following months COS cost of sales Editing the target stock days for any one supplier will apply this new target days to all months for the supplier If there are COS cost of sales in the following month the target stock days for a given supplier in a given month may be set Page 107 of 182 E support foreCASH co uk fo re C A S H 3 7 2 7 Importing Purchase Order Commitments POC In Supp lt gt Cust mode there are three options for the order and method of setting up the sales and stock forecast see 3 7 2 Under options A and B you can import a fixed schedule of purchase order commitments Once imported these commitments unless cleared will limit the lower level of overall purchases that can be forecast Stock levels can be increased to
15. 3 7 1 5 1 Stock levels Raw material Purchase Order Commitments POC If your business has placed purchase orders for COS items or services which have not been supplied on the forecast start date you may wish to specifically account for these items and schedule the payments and stock they will trigger A schedule of Purchase Order commitments can be imported from an Excel or CSV format file The import option can be accessed from either the opening stock form or from the third tab of the Sales and Stock forecast entry screen i You can import POCs for all or specific COS supplier accounts f foreCASH gt gt gt Company 161 DemoCompany v 3 Wholesaler Item Mode POC local data St01 01 2008 Lgth 12 Mode Prd Item fCv 2 7301 File Edit Banksetup Drivers key accounts Openingdats Forecastdata Calculate cashflow View Forecast Reports Flex Help e S 2 Select file 3 Preview 4 Validate PANA007 Panasonic HDTY002 High Definition TV SONYO01 5 PIONEEROO2 Pioneer TELACCOO2 Tele Accessories Ltd RADIO003 Digital Radio UK Pool Notes on columns 1 NB Al existing entries for accounts included in the import will be overwritten ii Browse to file containing list of POCs Purchase Order Committments import 1 Choose accounts 2 Select file 4 Validate C Users dger D ocuments4201 O foreC4SH sub_task_specification A039 testing impo
16. C Cheque 0 4 Card type 1 90 7 Card type 2 0 28 3 5 7 3 Adding New Customers by importing a list of customers paying by cash or credit card When a list of customers is imported foreCASH searches for new account codes and automatically adds the new customer Customer group name Customer Total Month 1 M2 and gt Account outstanding 670o 6 053 6 053 BranchB TB 1275 12 Web WEB _ 4063 4 063 Once the customer list ledger has been imported you can go to the Drivers gt Ledgers section from the top menu and add these customers to your key accounts ranked items list and set up the relevant business terms For more details on building a file of customers for import see 3 4 4 2 Page 61 of 182 E support foreCASH co uk foreCASH 3 5 7 4 Adding New Customers using the ledger housekeeping method Go to the Drivers gt Ledgers section from the top menu and select the Add new delete tab You can create the new customer groupings Then add them to the ranked items list and set the terms and method Drivers Ledgers Supplier Terms Suppliers Top 9 COS Customer Terms New suppliers or customers appearing in an aged ledger file that you import will automatically be added to the valid list of customers suppliers Alternatively you can use this screen to manually add a customer or supplier You can remove a customer or suppler using this screen
17. Cash transactions are split into two halves which in general reflect first receipts and then payments It is typical in many businesses for there to be a small number of key accounts or groupings To reflect this cash transactions with both suppliers and customers are assigned in each case across a Key ranked accounts with a pool for any remaining accounts in the category The emphasis on key accounts is taken a step further by splitting customers and Cost Of Sales Suppliers into two sets giving higher emphasis on the top five key accounts There are two key reasons for doing this Firstly many businesses will try and ensure that there is no unnecessary disturbance to key accounts and secondly and somewhat contradictorily should significant cash strain occur it may be necessary to address these key accounts to find transactions of a significant size to reschedule In many cases the key ranked accounts will relate to an individual customer or supplier but there is no reason why some of the ranked lines should not be assigned to a new account called m0045d Mid sized accounts on 45 days credit in order that your sales forecast reflects a certain group of customers with similar characteristics who while not significant individually together represent a significant segment that cannot be satisfactorily modelled within the general pool 14 2 Weekends bank holidays and Shut down days Payments and receipts are no
18. Copy shared gt and lt Copy local buttons in the upper section will copy a Company and all its versions from the local to shared drive and vice versa foreCASH Select Company Version Import comp Delete now 6 Z2v18testD 7 ZZ_ 18testMan 8 zDemoCompany 9 TEST4_Disti 13 1 0 22 from blank Oo000000000 Oo0000000 r Existing versions for selected company Version Descriptio 1 Blue Retail 5 Standard 19 01 2011 2 General Features Standard 19 01 2011 3 Electrical wholesaler 5 Standard 19 01 2011 4 Project Company Oct Standard 19 01 2011 5 Manu Mode Manuf 19 01 2011 6 Invoice discounting l Standard 1970172011 7 Fin and capex Mar Manuf 19 01 2011 POP Standard 19 01 2011 To copy a single selected version use the Shared gt Local Local gt Shared button in the lower section Page 13 of 182 E support foreCASH co uk fo re CA S H 7 foreCASH Select Company Version Existing companies 75 from blank 2 JH Live 76 ResellerPack JH Live 77 FROM BLANK ResellerPack 78 from Blank new template Z_Demodata 79 from blank Copy shared 7 y Copy 1 Demo_standard copy From Local Company 111 Version 5 2 Demo_manufacturing 3 Project Comp Company Name Z_Demodata 4 Electrical Wholesale 2 Vetsion Description Blue Rea 77 O Copy Cancel Selected database ref local wkforecash111_5 mdb Companies licenced ss Refresh
19. Page 64 of 182 E support foreCASH co uk fore CAS H a 3 6 2 1 Stock feed In item product mode you have the option for raw materials suppliers to feed into another supplier stock category There are two reasons for using this feature i To note opening stock by supplier but for ongoing activity treat several supplier stock groupings as one because stock is interchangeable or to simplify the stock usage COS forecasting within the forecast ii To allow Purchase Order Commitments see sections 3 7 1 5 1 item product mode and 3 7 2 7 supp cust sales split mode to drive cash payments against a specific supplier but to simplify stock usage COS forecasting within the forecast Stock l Stock details e postdate GRNI Stock feeds POE Canpeaed a commitments __ _not yet invoiced _ invoice days into 0 Self a ae ZMerged incl Stock 7 ZMerged 2 Merge Stock H 0 0 0 Pan 0 OTVOR High Beton TYC 0 0 0 Suppier ID ZMerged ZMerged incl Stock Feed JVCOO2SVC PANAO07 Panasonic HDTV002 High Definition TY Corp SONYO01 Sony Corp SONY001 Sony Cor Sarena Pi iireai TELACCO02 Tele Accessories Ltd RADIOO0S Digital Radio UK Pool Total materials TELACCOO02 T ele Accessories RADIODOS Digital Radio UK O Pool 0 0 0 0 0 PIONEER002 Pioneer 5 0 0 0 0 0 A supplier which has others suppliers feeding into it cannot itself feed into another supplier gro
20. amount approved b f proposal actual a pending COLLINGO2 05 Dec 07 meed 60 003 60 003 60 003 O3Jan 08 Cheque 47 500 i 47 500 O i 47 500 04 Feb 08 Cheque 14 100 0 14100 O a 14 1 a0 0 a FILOFAQO1 05 Dec 07 Cheque 1 033 103 0 1 033103 O O 0 0 1 033 103 O3Jan 08 Cheque 175 000 Q 175 000 O ix 165 000 10 000 0 PENCILOOI 05 Dec 07 Cheque 111 003 0 111 003 O oO 0 0 111 003 O3Jan 08 Cheque 650 000 0 650 000 O O 0 0 650 000 LEADLIOOS 05 Dec 07 Cheque 250 003 0 250 003 0 0 250 003 O3Jan 08 Cheque 225 000 0 225 000 CO O 0 0 225 000 PARKEROO1 05 Dec 07 Cheque 406 103 0 406 103 O Oo 0 0 406 103 O3Jan 08 Cheque 438 000 i 438 000 O oO 0 0 438 000 Pool COS 05 Dec 07 gt 189 556 0 183556 O O 0 0 189 556 O3Jan 08 gt 320 487 o 320 497 0 0 320 487 Salary 31 Dec 07 gt 7 700 0 7 700 O o 0 0 7 700 31 Jan 08 gt 7 700 0 7 700 0 0 7 700 29 Feb 08 gt 7 700 0 7 700 O oO 0 0 7 700 31 Mar 08 gt 7 700 0 7 700 O O 0 0 7 700 PAYE NI 21 Jan 08 gt 3 400 o 3 400 O oO 0 0 3 400 19 Feb 08 gt 3 400 0 3 400 O oO 0 0 3 400 19 Mar 08 gt 3 400 0 3 400 O O 0 0 3 400 31 Mar 08 gt 3 400 0 3 400 oO 0 0 3 400 Pool Direct C 03 Jan 08 gt 23 487 0 23 487 O g 0 0 23 487 Total 5 699 381 0 5 699 381 179 100 10 000 Save Close Page 139 of 182 E support foreCASH co uk fore CAS H 5 3 Reconciliation The reco
21. 24 25 40 41 42 Vat schedule 43 Quarterly returns payment method 3 day trda credt from HMRC for electronic payment If VAT reclaim cash received 2 days after period close 44 Period end January submission in Februa 45 Period end April submission in May paid i 46 Period end July submission in August pai 47 Period end October submission in Novem 48 inb the first month s activity may include VAd not invoice GRNI and goods in transit GIT 49 an Page 150 of 182 E support foreCASH co uk fore CAS H j 7 6 4 Monthly reports Bank Summary and details When you export to excel the monthly reports Bank summary and details reports are included which between them give Breakdown of current accounts by bank Summary movement on asset based invoice finance accounts Interest rate and charges on accounts Movement in facility levels Advance rate and lending caps on asset based invoice finance accounts Basis of stock based lending accounts and the forecast facility level during the forecast ERE fe m C3 a9 e 2 fot a Home Insert Page Layout Formulas Data Review View Developer Home Insert Page Layout Formulas Data Review View Developer B Asi sis du Aw SSD Ewet B Sss Arial Ju as E Wrap Text General 4a Copy es Past ae a z Paste A Format Painter PIAU Ea Orme 2E
22. 30 12 2013 12 000 12 000 eked Coo TELACCOO2 Tele Accessories InvABH128 15 12 2013 14 01 2014 7 812 7 812 Month 3 Zand older EULEROO2 Euler TI Inv2p3129 30 12 2013 29 01 2014 100 100 Month 4 and older BARCOO4 Barclays Bank In Inv21251 508 13389203 30H00 a egy ge BP Month 5 and older SECUR009 Securicor Group Inv2123131 15 10 2013 14 11 2013 1 000 0 1 000 Month 6 and older Month 7 and older D gt gt gt gt gt gt gt sey si pe en ne a ave Month 8 and older PIONEEROO2 Pioneer Inv2123146 28 05 2014 27706 2014 57 400 57 400 Month 9 and older JVC Inv2123147 12 06 2014 12 07 2014 127 892 127 892 Month 10 and older Panasonic Inv2123148 27 06 2014 27 07 2014 125 777 125 777 ve T cod High Definition T Inv2123149 12 07 2014 11708 2014 100 000 100 000 Bank a caiie Digital Radio UK Inv2123150 2707 2014 26 08 2014 30 000 30 000 Amounts payable are shown as Positive Negative On opening the settings screen you see a preview display showing the first and last rows of your data file to help you to set the parameters for your import mapping Page 43 of 182 E support foreCASH co uk fore CAS H 3 4 2 1 Fields included in your file for import First adjust the parameters see box 1 above to set the key parameters on e the number of fields in the file you will be importing e Company ID field o most accounting packages have a Company
23. I amp J for suppliers K amp L for customers Days 61 89 NME M amp N for suppliers O amp P for customers User Defined Q R User defined split net month end payment terms whereby invoices are settled a in a 50 50 split on two precise number of days following the month in which the invoice was raised Retail A C Define the proportion of retail sales settled by cash credit or cheque together with the days delay between sale and cleared funds being received Payment Plan A E define weekly payment plans using a start point number of weeks and payment day of week Stage Payments A C Define the settlement split across up to four stages Define the settlement point 99 days relative to the invoice for each stage User defined new terms Retail collection mix Payment plan settings Strict UDT Stage payments m Supplier net month end UDT 1 28 days E Invoices payable on Net Month end 7 F Invoices payable on Net Month end 21 rm Customer net month end UDT 1 28 days G Invoices receivable on Net Month end 7 H Invoices receivable on Net Month end 21 m Supplier net month end UDT 31 59 days Invoices payable on Net Month end ar J Invoices payable on Net Month end 37 m Customer net month end UDT 31 59 days K Invoices receivable on Net Month end 37 L Invoices receivable on Net Month end 31 m Supplier net month end UDT 61 89 days
24. In the example below the selection below would be represented by gt Reports gt Surplus strain report gt Surplus strain relative 4 3 P L Balance sheet Funds flow O1Dec07 O2Dec07 03Dec07 04 Dec 07 05DecO _06 Dec 07 Payment release control _11Dec07 12 Dec 07 13Dec 07 1 Saturday Sunday Monday Tuesday Wednesday Thursday I Threedan Wadnasdau Thursday Receipts Surplus strain report Surplus strain absolute Receipt from ABL i i 0 Q 200 0 All accounts graph Surplus strain relative 0 Customers top 5 2 650 025 k J Customers other 35 007 Supplier Deferrals graphs d Other receipts Supplier Deferrals status table gt Receipts Total 0 0 0 0 200 2 735 032 Amended transactions t0 0 0 0 Payments COS top 5 1 204 109 Export main forecast a COS others 845 662 Direct Costs 6 000 Print Screen Salaries Property 9 200 Other Overheads 12 000 Other Taxes Interest Capex Payments Total 0 0 0 0 2 075 971 0 0 0 0 0 0 0 0 Exchange gain loss 1 4 Cleared Bank Position Please note that at all times foreCASH gives the position forecast to be seen by your banks and as such represents the cleared bank position 1 5 Consolidated Bank Account View The main cash forecast view within foreCASH shows the net shortfall or surplus of all your banking f
25. Item can also be set up as a Project It is important to choose the right mode For more information on modes please see the 2nd tab refer to the handbook your sign up email or contact support foreCASH co uk m Financial Year Company Financial year runs Apr Mar v You have the option to enter actual monthly results for the current financial year so far These actual results will be combined with the forecast data for the current and future months to produce a profit and loss forecast for the whole of your company s financial year Page 19 of 182 E support foreCASH co uk fo re C A S H 3 1 1 foreCASH modes foreCASH can operate in two sales modes Selecting the right mode is important if unsure please contact support Activity Sales defined by Sales defined Notes Item by supplier and Service Product customer split or Project plus customer mix options ltem Pro gt Cust Supp lt gt Cust Use item product project mode Use item product project mode v Generally item mode should be used with items set to have no stock vv y Item Pro Mode generally suitable Includes option to import purchase order commitments Supp lt gt Cust Mode includes option to import forecast sales and purchases and the import of Manufacturer Project focussed Service Wholesaler distributor existing purchase order commitments Supp lt gt Cust Mode allows
26. M Invoices payable on Net Month end 67 N Invoices payable on Net Month end E m Customer net month end UDT 61 89 days 0 Invoices receivable on Net Month end 61 P Invoices receivable on Net Month end 67 Page 59 of 182 E support foreCASH co uk fore CAS H 3 5 7 Terms for customers that pay by cash with order or by credit card While some businesses offer credit to their customers and maintain a list or ledger of the amounts due others such as retailers ask their customers to pay at the time of sale with cash cheques or credit cards 3 5 7 1 Past sales and existing balances If all of your customers pay by cash there will be no balances due from customers at the start of your forecast However if your customers pay by credit card or debit card there will typically still be money due to you with this money being held by the Merchant Services Provider MSP that administers your credit card operations The MSP will retain money from credit card payments for a set period of time You will need to build the money outstanding from your MSP into your forecast In order to do this you will need a summary of the money outstanding which you can then import into foreCASH For more information on incorporating existing customer balances into your forecast refer to section 3 4 4 2 3 5 7 2 New sales and balances Rather than modelling a few large customers a cash credit card based busines
27. O Pa 50 ue on amount 286 250 3lJan11 286 250 Clickhere ee orowed g BG 25N Click here g 31 Mar 11 286 250 Click here O All COS suppliers C By ranked suppliers Tap ajaa Rhee g 31 May 11 286 250 Click here O ANstun 11 2A PAN Click here M4 eee ne SCA 60 non vat R acilities calculated by foreCASH based on stock SCA reduced terms O purchases SCA PACKAGING MUNKSUND o NORAMPAC AVOT VALLEE 5 4 5 O Page 26 of 182 E support foreCASH co uk foreCASH 3 2 3 2 Import loan facility Some lenders will advance funds against stock that is in transit or is still being manufactured by an overseas supplier When building your forecast you define information on the purchases you are making from suppliers you may enter the level of purchases directly or it may be calculated by foreCASH based on your forecast level of stock and the amount of stock you plan to sell Stock Based Lending Closing stock at m e C Import Loan G Percentage 100 mi on eee 1 000 000 e advance Oro All COS suppliers e By ranked suppliers Panasonic High Definition TY Corp Sony Corp Pioneer Tele Accessories Ltd Digital Radio UK Pool Select All Clear All From 60 0 days prior to o to 0 120 days 10 purchase after purchase Opening facility 4100 Allocate manually Edit Using the purchases made from all selected suppliers foreCASH will calculate the import loan facility available to run from 0 to 60 days bef
28. OptiOns eienen erreira esnaera i iaae aada eins anaes sles seetiatiiehivemtaaienineah te 152 7 7 Actual Profit and Loss report Financial Year Profit and LOSS repOFt c eeceeceeeeeeseeeeeeeeceeeeeeeeaeeeeesaeeeaeeeeseseaeseeeaeeneeeatee 153 7 8 Balance sheet Actual figures Financial Year Balance Sheet report 7 9 Funds flow Actual figures ce ce eeeseesseceeeteeeeseeeeeeeeeeaeeeeesaeeeaeteeeas ad 7 10 Strain surplus Overview ADSOIULC cceceeeeceeeeeeeeeeeeseeaeeeseeseeeaeeeaesaeeeaeeseessaeeaeeeesaeesaeseesaeeeaeesaesaeesaeseeesaeseaeseeeeeeeaeeaee 7 11 Sirain Surplus relati Orne pties iin cinta nines Anite SE aS eiaa EEE ERE OF aE etd iata 7 12 Supplier strain report s s s 7 13 Supplier deferral status report 0 0 0 Changing the start date or length of your forecast 8 1 Changing the start date of your forecast 8 2 Changing the length of your forecast Foreign currencies Asset Based Lending ABL esneeeee 10 1 ABL Factoring and Invoice Discounting 10 2 ABL in the main daily cash flow summary screen 10 3 ABL detail screen eseseeeeeeneeeirerrrirnererrernens 10 4 Adjusting daily ABL sales data cceeceeseeeeseeeeteeeeeeeeeeeeee 10 4 1 Proof of deliveries and their impact on approved ABL sales 10 4 2 Disallowed ABL inVOiCeS ee eceeeeeeeeeeeeeeeeeeneeeeeeeeeeeeeeeeeae 10 5 Varying the amount drawn down into the master account 10
29. Page 69 of 182 E support foreCASH co uk fo re CA S H 3 6 6 Opening credit note accrual If credit notes are due from suppliers to customers at the forecast start date but do not appear in the imported customer supplier ledger balances they may be accrued manually Three categories of credit notes are offered for each category the amount of accruals and the expected timing delay before receipt of the credit notes can be entered Credit notes will then be net off the next available payment Opening credit note accruals Supplier RADIOO0S Opening Data Manual ent r Aetens Suppliers Man CN Manually entered payment 4 credit note accruals are alsq Credit date Evenly over a period of days In a single release after a period of days Allocate manually F r Seva prize Amount Credit date Evenly over a period of days Allocate manually Amount J 850 Credit date Evenly over a period of days In a single release after a period of days Allocate manually Click here to edit amount Save Close Page 70 of 182 E support foreCASH co uk fore CAS H a 3 6 7 Other debtors If at the start of your forecast you have debtors which are not included within your main customer ledger they can be entered via Opening data gt Other debtors Where you expect to receive cash for the debtor during the forecast period you may enter a schedule of receipts using a Calendar View These amounts can
30. Therefore 30d 2 15 30 45 30 days 30 days net fortnightly represents a minimum of 30 days credit on an invoice with 2 payments per month on the 15 and 30 or the last day of each month The range in credit is from 45days to 30 days depending when in a two week cycle an invoice is raised Please refer to the full table of terms below Page 54 of 182 E support foreCASH co uk Terms reference code past Cash with order no credit 0d 30 no credit_cash foreCASH Description Notes 0 days credit typically cash purchase or presentation of cheque at time of sale Net month end fortnightly terms 30d 1 last 60 30 30 days net month end 30d 2 15 30 45 30days 30days net fortnightly 45d 2 30 15 60 45days 45days net fortnightly 60d 1 last 90 60 60 days net month end 60d 2 15 30 75 60days 60days net fortnightly 90d 1 last 120 90 90 days net month end Od 2 15 30 15 Odays Odays net fortnightly User defined E F I J and M N UDTe x days Net month end User defined G H K L and O P UDTg x days Net month end User defined Q UDTq x y Split days Net month end 30 days net month end A single payment at the end of each month for the previous months transactions Payment occurs 60 30 days after the sale purchase 30 days net fortnightly Two payments per month one at mid month and one at the month end Payment occurs between 45 and 30 days after the sa
31. Web sales paid by credit c Pool Supplier code Pool TNTOVNO01 TNT Ovemight Add Supplier Suppiername JT vengy SCS SS Basis Percentage of sales C All Selected customers Percentage of purchases C Se Serr Enter amount s C Selected Items Payment frequency Monthly Payment day within month fast Day 7 Weekly gt Months credit to settle invoices invoiced gt months before payment 0 Invoiced gt months in advance atrears of start of expense period 1 v Balance in imported ledger I 0 Accrual 0 Terms applied to ledger ETS last 60 30 30 days net month end Select All Clear All Any opening balance in the purchase creditors ledger for the supplier will be scheduled in accordance with the past terms chosen for that supplier New costs will be scheduled for payment on a monthly basis You can select the payment date and the number of month s credit you receive If invoices are received in arrears or an invoice for a prior period had not been posted when the purchase creditors ledger was imported you can enter an accrual figure Suppliers that have been set to another cost category such as cost of sales materials property overheads or general overheads will not be available in the list of suppliers available If a supplier genuinely supplies more than one cost type a new supplier could be
32. excluding VAT on the expected PAYMENT DATES Irregular expe i E 01 Feb 2008 02 Feb 2008 03 Feb 2008 04 Feb 2008 05 Feb 2008 06 Feb 2008 07 Feb 2008 Saturday Tuesday Wednesday Thursday 29 Feb 2008 0 lt Epee gt of 13 Page 115 of 182 foreCASH E support foreCASH co uk 3 10 3 2 Complex irregular overheads If the cost of an Irregular overhead needs to be spread over a number of months or you wish to model complex opening accruals for the overhead use the complex method This method involves three steps First enter the overhead description amount net of VAT and the period to which it applies Irregular complex expense Step 1 expense description Description or reference Autumn Season Marketing Total Expense net 100000 00 VAT applies Iv Expense over period from q t 2008 To Dec 2008 Charge spread over Charge per month to P and L Page 116 of 182 Esuppon torecasheouk SS foreCASH In step two the phasing of invoices from the supplier are noted This allows any prepayments accruals during the forecast period to be calculated Irregular complex expense Step 2 invoice schedule Expensed Net prepay 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 000 00 0 0 30 000 00 0 0 33 333 33 0 33 333 33 40 000 00 33 333 33 ooooooooo0oo0oo0oo0oo0oo0oo0oo0o00O0 In ledger paid Accrue for invoice Opening posi
33. gt gt Company 63 ResellerPack v 1 Disti Flex Test St 01 01 2008 Lgth 15 Std Reports Flex Help File Edit Banksetup Drivers key accounts Opening data Forecastdata Calculate cash flow COLOCAR ALAE P amp L Balance Sheet Funds Flow and Cash Flow Profit and Loss Balance Sheet Funds flow if Cash flow FRS it 1 2008 405 000 373 090 31 310 7 88 405 14678 46 183 11 40 19 800 6 767 42 000 0 22 384 1597 EBIT Operating Profit 23 981 Interest 0 4 2008 395 000 363 590 31 410 7 95 395 14 782 45 797 11 59 19 800 6 767 41 143 0 21 913 2 153 24 066 0 5 2008 395 000 363 590 31 410 7 95 395 14 782 45 797 11 59 19 800 6 767 141143 0 21 913 2 153 24 066 0 6 2008 395 000 363 590 31 410 7 95 395 14 782 45797 11 59 19 800 6 767 61 143 o 1 913 18 819 50 732 0 0 21 913 18 819 40 732 0 8 2008 395 000 363 590 31 410 7 95 335 14 782 45 797 11 59 19 800 6 767 41 143 0 21 913 19 653 41 566 1 866 0 9 2008 395 000 363 590 31 410 7 95 395 14 782 45 797 11 59 19 800 6 767 51 143 0 31 913 19 653 51 566 0 0 0 23 981 7194 16 787 0 11 358 26 502 0 0 24 066 7 220 16 846 a 0 24 066 7 220 16 846 0 50 732 15 220 35 513 0 o 40 7
34. may need to be excluded from limit as they represent a number of smaller accounts which are unlikely to breach any percenatge limit m Treatment of customer cash discounts Lender provides for cash discounts on sales side each month end for new invoices raised rather than wait until discount taken IV Bl Saye Close The excess is initially determined when the forecast cash flow forecast calculation is first run If you want to re calculate the excess when receipts and sales are changed you can set the Recalc excess option from within the bank settings or while viewing the excess post calculation You may wish to manually adjust the excess figures once you are notified of them In this case you can also select the after date of newest manual item setting This means any excess amounts occurring before the date of any manual adjustment on excess unchanged should receipts or sales be changed further f foreCASH gt gt gt Company 137 Scott Bros Demo v 61 DG test pool PO comms local data St 01 07 2013 Lgth 5 Std File Edt Banksetup Drivers key accounts Openingdata Forecast data Calculate cash flow View Forecast Reports Flex Help BO 08 t 42 8 8 8 736 gt All Disallowed details Re cale for max single account excess J7 only after date of last manual item I 2 Type Origin date Excess share 201398 Argos Ltd predicted to exceed limit J O1Jul 13 i O2Jul 13
35. terms 56 updates 176 VAT 35 View forecast 141 post calculation of cash flow 141 pre calculation of cash flow 141 Warning error messages 177 Weekly cash forecast 143 144 WIP 103 Working days of the week 41 working trading days 41 Page 182 of 182
36. three months old and older column Once your ledger files are ready they can be imported into foreCASH To begin the import process select Opening Data gt Ledgers import from the top menu bar within foreCASH Page 49 of 182 E support foreCASH co uk fore CAS H 3 5 Key customer and supplier accounts groups Key customer and supplier for costs of sales accounts or groups of accounts can be ranked and given prominence in your forecast Up to 125 ranked accounts groups can be added with remaining accounts treated as a pool 3 5 1 Pre existing supplier and customer accounts dummy ledger accounts When you create a new forecast from scratch rather than one based on an existing forecast you will find foreCASH already contains a number of ledger accounts As you build a forecast you are likely to want to model some costs and sales down to an individual supplier or customer level an example may be a supplier for a large rent bill or a key customer For other less material areas you may not want to associate a cost with a specific account in this case you could use a general dummy ledger account against which to record the cost You could create your own dummy account see 3 5 7 4 on adding new accounts use a general aggregated account see 3 5 2 or use one of the pre populated aggregated accounts zAgg GenCOS General COS zAgg GenOH General OH zAgg GenProp General Property zAgg_GenDC General Direct Cost
37. 0 27 Peak Borrowed 279 100 271 540 24 27 bank description Currency Sterling 28 28 Fixed interest at 0 29 29 Interest accumulation default 30 30 Interest charge applied Monthly 31 31 Autosweep options off 32 Monthly charges 0 Charge per draw 0 Commision charge 0 Commissions applied at month end 33 Default draw down method All Rounded Drawdown into acount Barclays current 34 Invoice processing delay of 2 35 Rates and caps 36 From 01 01 2008 to 02 04 2009 advance rate 85 00 cap 1 000 000 group cap 1 000 000 38 Page 151 of 182 E support foreCASH co uk fore CAS H 7 6 5 Monthly reports Options You can specify certain aspects of report layouts and the detail shown when exporting to excel via Reports gt Report Options gt Report options Page 152 of 182 E support foreCASH co uk fore CAS H 7 7 Actual Profit and Loss report Financial Year Profit and Loss report In addition to the rolling profit and loss forecast that starts at the start point of your cash forecast you can review P amp L reports that synchronise with your company s financial year This report blends Actual P amp L data which you can enter in any cell with a white background with the sales and expense forecast data that are driving your cash flow The report can be viewed by month or quarter Use the Set Fin Yr button to change the starting month of your forecast gt gt Company 28 Revenue recognitio
38. 04 Sep 07 05 Sep 07 06 Sep 07 07 Sep 07 08 Saturday Sunday Monday Tuesday Wednesday Thursday Friday Sat Payments Suppliers top 5 Suppliers other 2 370 012 85 003 Overheads and taxes 100 000 Payments Total 0 0 0 3 371 190 0 0 1 185 006 Receipts E aS eae a ee ae ee Receipt from factor 0 0 0 0 0 0 0 Customers top 5 3 300 009 Customers other 2 370 012 Other receipts E Receipts Total 0 0 0 0 5 670 021 0 0 Exchange gain loss a Daily move on cash 0 0 0 3 371 190 5 670 021 0 1 185 006 Net position 100 000 100 000 100 000 3 271 190 2 398 831 2 398 831 1 213 825 1 Net bank facilities 71 000 000 71 000 000 1 000 000 71 000 000 7 000 000 71 000 000 1 000 000 1 Undrawn ABL 0 0 D 0 0 0 Headroom Shortt fall 1 100 000 1 100 000 1 100 000 2 271 190 3 398 831 3 398 831 2 213 825 2 2 AAPAPEOO2 f FILOFA001 1 100 003 HUMFLMOO1 Not specified 4 Not specified 5 Sub Total 0 1 100 003 A4PAPEDOZ past activity AAPAPEOO2 new activity A4PAPE 002 management AAPAPEDO2 A4PAPE O02 reconciliation Sub Total Selecting a cell with a value in the second of the three grids shown above and holding down the mouse allows it to be dragged onto a different date for the same account Ensure that the dragged box is well placed over the destination cell and then release mouse Page 132 of 182 E support foreCASH co uk fo re C A S H 4 1 2 Defer advance foreCASH File D Overheads Bank
39. 10 000 7 500 Sales flex 0 0 0 0 0 20 000 40 000 20 000 5 000 5 000 15 000 30 000 5 000 10 000 7 500 Flex now 1 270 2 540 1 270 317 317 952 1 905 317 All sales in forecast 21 270 42 540 21 270 5 317 5 317 15 952 31 905 5 317 10 635 7 976 Sales can be flexed by individual customer or across all customers on a pro rata basis Customers that are covered by an asset based lending agreement invoice discounting or factoring are flexed as a group and cannot be flexed individually Similarly the supplier or product can be flexed on an individual or group basis In the Supp lt gt Cust mode foreCASH offers the user the option to always flex purchases in line with the sales change or to express a preference to adjust stock levels in preference to changing purchases If the user has expresses a preference to adjust stock they can further choose to allow the stock changes to cascade through any following months or to limit the stock impact in which case the stock in the following months will not be impacted Integrity checks are applied to ensure the stock movements are compatible and this may limit the extent of flexing that is available By default payments and receipts arising from flexing are applied on standard business terms Steps 2 and 3 of the sales flex process gives the option to allow the user to schedule payment and receipt adjustments manually using a calendar view Page 136 of 182 foreCASH E support foreCASH c
40. 2013 10 000 8 500 1 500 8 Sinv INDEPoo Independents 2 11 750 1 763 9 988 9 Sinv SAINSO02 Sainsburys 11 750 1 763 9 988 10 Sinv WAITROO1 Waitrose s 11 750 1 763 9 988 344 963 25 000 435 250 11 14 Jan 2013 Cash WAITROO1 Waitrose 11 Jan 2013 10 000 8 500 1 500 12 Sinv INDEPoo Independents e 5 875 881 4 994 13 Sinv SAINSO02 Sainsburys 11 750 1 763 9 988 14 Sinv WAITR001 Waitrose Ea 11 750 1 763 9 988 371 431 15 000 454 625 15 16 Jan 2013 Cash WAITROO1 Waitrose 15 Jan 2013 11 750 9 988 1 763 373 194 3 250 442 875 16 21 Jan 2013 Cash WAITROO1 Waitrose 18 Jan 2013 10 000 8 500 1 500 17 Sinv INDEPox Independents lt 11 750 1 763 9 988 18 Sinv SAINS002 Sainsburys SH 11 750 1 763 9 988 19 Sinv WAITROO1 Waitrose oa 11 750 1 763 9 988 20 Draw down 21 Jan 2013 6 750 397 906 468 125 21 23 Jan 2013 Cash WAITROO1 Waitrose 22 Jan 2013 11 750 9 988 1 763 22 Draw down 23 Jan 2013 11 750 387 919 456 375 23 28 Jan 2013 Cash WAITROO1 Waitrose 25 Jan 2013 65 000 55 250 9 750 24 Sinv INDEPwo Independents I 11 750 1 763 9 988 25 Sinv SAINS002 Sainsburys 11 750 1 763 9 988 26 Sinv WAITR001 Waitrose 29 375 4 406 24 969 27 Draw down 28 Jan 2013 65 000 377 613 444 250 28 30 Jan 2013 Cash WAITROO1 Waitrose 28 Jan 2013 11 750 9 988 1 763 M 4b h BankStatement Sheet2 Sheet3 Changes in the available ABL balance due to sales can be set to show as being due to genera
41. 798 6 798 6 798 6 798 6 798 6 798 6 798 6 798 6 798 6 465 6 465 3 96 finc dec stock 18 950 15 750 15 750 8 250 0 0 0 0 0 0 0 0 inc dec Debtors 11 900 9 439 291 38 414 1 643 31 500 31 500 10 897 7 325 7 288 13 590 5910 6 90 finc dec ABL debtors 0 0 0 0 0 0 0 0 0 0 0 inc dec Other debtors 1 200 0 1 200 1 200 0 1 200 1 200 0 1 200 1 200 1 200 0 1 20 inc dec COS creditors 10 545 14 070 375 1 860 0 510 0 0 0 35 799 35 700 39 7 inc dec Op costs creditors 41 640 27 322 37 738 17 683 27 500 37 683 7 700 27 500 37 700 7 342 10 057 499 7 69 inc dec Capex creditors 0 0 0 it 0 0 0 0 0 0 0 0 inc dec Salary Creditors 0 0 0 0 0 0 1 000 0 0 1 000 0 0 inc dec VAT Creditor 3 563 7 715 5 090 30 156 6 325 4 005 49 044 6 125 4 005 11 129 5 134 3 014 9 13 Net flow from op activities 10 680 61 401 23 341 75 599 103 492 72 556 72 180 127 546 48 204 59 459 50 559 105 276 130 72 Interest Paid 687 912 0 4 388 4 101 0 12 215 8 262 0 19 887 166 11 408 26 52 Foreign exchange 0 0 0 0 0 0 0 0 0 0 0 0 Servicing of finance 9 993 62 313 23 341 79 986 107 593 72 556 84 395 135 807 48 204 79 346 50 724 116 684 157 24 Tax Paid 0 0 0 0 0 0 0 0 0 0 0 0 Fixed Asset additions 0 0 0 0 0 0 0 0 0 i 0 0 New Lease Advance 0 0 0 0 0 0 0 0 0 0 0 0 Lease Payments ex VAT int 862 1 602 0 0 752 0 0 773 0 0 795 0 Loan funds 0 0 0 0 0 0 0 0 0 0 0 0 Loan repa
42. Aged Format Debtor a company to which you have extended credit a company that owes you money Debtors Ledger see Customer Ledger Drawdown the amount of money you draw against an Asset Based Lending facility such as an invoice discounting scheme on any given day DBL Dealt With by Ledger This notation is used to show where the cash impact of a recurring cost such as rent is dealt with through the settlement of an invoice on your imported suppliers ledger rather than by scheduling a new invoice and cash payment Excess Percentage ABL disallowed if an Asset Based Lender who gives a loan based on a percentage of the value of customer invoices outstanding specifies that any one customer must not exceed a given percentage of your total ledger any invoices raised against a single customer which the lender then disallows for lending purposes make up the excess amount Factoring a form of Asset Based Lending whereby a bank or lender buys a debt owed to you by a customer The lender charges a fee pays a discounted price for the debt it acquires Finished goods stock items that are not processed altered or manipulated any further by your business before sale As opposed to raw materials or Work In Progress GIT Goods In Transit stock you have ordered and which your supplier has shipped at a given month end but which have not yet been received at your warehouse Such items will typic
43. Cash overdrafts Overdraft facilities Undrawn ABL capped Headroom Shott fall ABL borrowed ASDA002 Asda fact B amp Q001 B amp O fact HALFORDSO03 Halfords GRATTANOO8 Grattan Pool non ABL Sub Total Poal non past activity Pool non 4 new activity Poal non management Pool non Pool non A reconciliation Pool non A cn accrual 14 873 25 000 weekly and monthly cash flow views In daily view on this second grid you can drag drop or defer advance amounts see section 4 1 Page 128 of 182 O3Jan 2008 04 Jan 2008 05Jan 2 Thursday Friday Saturd 0 1 207 0 0 51148 O 61 275 0 0 61 275 51148 14 873 76 148 25 000 5 25 000 25000 50ND 0 0 aig S 10127 61148 4997 41 0 0 aag ff 23 247 a y O 0 0 49 941 26 694 0 0 26634 foreCASH foreCASH In addition when you click on a standard item on the second grid a third grid appears showing whether the amounts in question relate to a past item from imported ledgers new item e g from sales stock forecast or recurring overhead are a management item result of drag drop rescheduling flex item from sales or stock flex or are a reconciliation item after adjustment to match bank statement actual figure Lastly if the amount is impacted by credit notes say related to customer rebates this is also shown E support foreCASH co uk Page 129 of 182 E support foreCASH co uk fo re C A S
44. Crystal Reports and html formats Page 142 of 182 E support foreCASH co uk fore CAS H 7 1 By bank account Daily cash forecast report The main daily cash forecast can be filtered to show a single bank account using the Now showing drop down list at the bottom left of the daily forecast screen A foreCASH gt gt gt Company 128 Z_Demodata v 6 Blue retail by bank tests localdata St0 File Edit Banksetup Drivers key accounts Opening data Forecast data Galculate cashflow wiew Fore BOO 8 4 Lie Sis 7 316 Tuesday Wednesday Thursday Friday Se Receipts Customers top 5 90 000 144 793 192 622 Customers other 750 1 700 2 270 Other receipts Loan advance 100 000 Share Issue 10 000 Receipts Total 0 190 750 146 493 204 892 Payments COS top 5 14 063 5 204 8 186 COS others 10 000 Direct Costs Salaries Property Other Overheads 1 275 1 200 Other Taxes Interest Lease principal Loan repayment Capex 10 500 Dividends 50 000 Payments Total 0 14 063 76 979 9 386 Transfer Exchange g l 0 0 o Daily move on cash 0 176 688 69 514 195 507 Net Cash overdrafts KIA 181 814 251 328 446 835 Overdraft facilities 5 000 5 000 5 000 5 000 Headroom Shott fall 10 127 186 814 256 328 451 835 i All accounts Barclays current Da Now Showing All accounts z Page 143 of 182 E support foreCASH co uk fore CAS H i 7 2 Weekly cash forecast report The main cash
45. Data Calculate Reports 01 Sep 07 02 Sep 07 03 Sep 07 04 Sep 07 05 Sep 07 06 Sep 07 07 Sep 07 08 Sep 07 Of Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Payments Suppliers top 5 Suppliers other 2 370 012 85 003 Overheads and taxes 100 000 N Payments Total 0 0 0 3 371 190 0 0 1 185 006 0 Receipts Receipt from factor 0 0 0 0 0 0 0 0 Customers top 5 3 300 009 Customers other 2 370 012 Other receipts Ea Receipts Total 0 0 0 0 5 670 021 0 0 0 Exchange gain loss ae bS Daily move on cash 0 0 0 3 371 190 5 670 021 0 1 185 006 0 Net position 100 000 100 000 100 000 3 271 190 2 398 831 2 398 831 1 213 825 1 213 825 Net bank facilities 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 Undrawn ABL 0 0 0 0 0 0 a 0 Headroom Short fall 1 100 000 1 100 000 1 100 000 2 271 190 3 398 831 3 398 831 2 213 825 2 213 825 2 A4PAPEOO2 i FILOFA001 11 100 0031 HUMFLMO01 r by 1 Day Not specified 4 Not specified 5 by 2 Days Sub Total o aio Realocate by 3 Days AAPAPE002 past activity RA by 1 Week AAPAPED02 new activity g 4PAPE00Z management Edit AAPAPEON2 flex T a A4PAPEO02 reconciliation Sub Total Reconcile Show Detail Calender View Deferring or advancing a transaction is very like the drag and drop operation except that it is menu driven by right clicking on a cell A pre set list of common deferment l
46. Funds flow Actual figures 154 General Drivers Rules 35 goods in transit 64 group forecasts 170 Housekeeping tab 52 Import company or forecast version 170 ledgers 42 sales or purchases schedules and totals 109 schedule of payments or receipts 67 Import Duty 38 Import loan 27 Import VAT 36 installation 142 Invoice Discounting See Asset Based Lending Item Product Mode 79 Key customers 50 Key suppliers 50 Late changes 125 ledger dummy general use accounts 50 manually add new accounts 62 Ledger credit notes unallocated cash 62 defaults supplier and customer 40 import mapping 43 report export 62 length of forecast 19 licence expiry date 8 Loans 32 autocalc 32 manual 25 34 Management Actions 126 155 156 advance 133 Auto spread 134 Defer 133 Drag and drop 132 Re allocation calendar 134 Manual allocation 67 margin 104 Master Currency 9 160 Menu protocol 6 modes 20 monthly P amp L Balance sheet and funds flow 148 Monthly reports bank summary and detail 151 Monthly reports cash flow 150 Monthly reports VAT 150 Multiple companies 169 multiple versions 169 Network 10 Non banking days Bank holidays 175 Shut down 175 Opening Balances 63 Other creditors 72 Page 181 of 182 Index Other debtors 71 other income 121 overheads irregular 115 recurring 114 Own Carriage 121 password foreCASH access password 16 Payment release control
47. ID and Company Name fields for each customer supplier o If your accounts package such as Xero has a single identifier for and account then uncheck the Company ID box e The Company Name field o This is mandatory and cannot be unchecked o Rows without data in this field will not be imported e The number of aged columns o If your ledger has current 30days 60 days and 90 days columns you would enter 4 as the aged columns figure o If your file has a single column for amounts then check the No ageing box e Whether due dates included You can also set whether the following fields are in the file e Invoice dates where the past terms for a customer supplier are set to a strict number of days the invoice date is used to schedule the imported invoices e Credit limits e An un aged credit note column e A payments on account marker type o For supplier ledger imports if your list includes Payments On Account POA you can flag these in a specific column in the import file o Flagging items as payments on account mean that they will be set against the next available new activity invoice in the forecast and will not be net off any invoices in the imported ledger o If applicable you can specify what text denotes a payment on account in order to match that provided by your accounts system e Bank account reference o This can be used to automatically map which bank acco
48. No flexes Page 124 of 182 E support foreCASH co uk fore CAS H a 3 15 3 Late Changes without Clearing the Forecast If you clear the calculation to amend base data you will lose any flexing reconciliation and rescheduling amendments you have made The following methods of making late changes to the forecast can be made while retaining flex reconciliation and re scheduling items Sales flexes Stock flexes Additional overheads recurring general property or irregular overheads Additional other income recurring or irregular Additional capital expenditure sale Ltd local data St 01 01 2008 Lgoth 10 Mode Def lata Calculate cash flow View Forecast Reports Flex Help Calculate and display Che Re display Clear calculation and amend base data Add capital expenditure Page 125 of 182 E support foreCASH co uk fo re C A S H i 3 15 4 What is a Base Forecast A Base Forecast can be thought of as an underlying starting case should you choose to defer payments or flex the sales or stock forecasts collectively known as Management Actions this Base Forecast is always retained within the system By retaining the Base Forecast i a record of any underlying strain is noted and ii Management Actions can be separately identified and controlled a foreCASH File ES w A 7 3 68 06 Dec 07 01 Dec 07 02 Dec 07 03 Dec 07 04 Dec 07 05 Dec 07 Saturday
49. Sales Sales Sales Sales Sales 3 E Ing oe gt 2 gt Total sales 20 000 20 000 20 000 20 000 20 000 20 000 v M ne v M De Reference 10 000 gt 0 gt 0 gt 0 gt 0 gt 0 gt 10 000 gt 10 000 gt SR 0 gt 0 gt 0 gt 0 gt 0 gt 10 000 10 000 gt a gt 0 gt a gt a gt 0 gt 10 000 3 2AA 10 000 gt 0 gt 0 gt 0 gt 0 gt 0 gt 10 000 3 10 000 gt 0 gt 0 gt 0 gt 0 gt 0 gt 10 000 vvvvyvyv iv vivviveviviv Shar srarsas vvvvyvviv vivviveviviv Shrtriadssas vvvvwv wv iv X 5 a 1 000 10 0 1 000 10 0 10 0 10 0 10 2 l 10 2 1 50 gt Copy for one month gt gt Copy total but keep mix gt gt Copy for all later months gt gt Copy each amount and mix Page 105 of 182 E support foreCASH co uk fo re C A S H i 3 7 2 6 Forecast stock levels by supplier There are a number of ways of setting the stock levels e Enter each value manually subject to maintaining zero or positive purchases e Copy the stock values to the following click Copy gt or all later months click Copy All gt gt in the upper grid e Stock days general target for all months clicking Apply gt gt in the second column of the lower grid will vary the stock level for all suppliers in order to hit the target number of stock days subject to not generating negative purchases Stock days are based on the following months COS
50. Sales and stock forecast Step 1 Order preference Step 2 Sales by Customer Step 3 Margin by Supplier Customer outlet Apr 08 35 000 gt 7A 0 gt 0 gt vv vv ais a gt BRABdAD a a a a a FORE gt Copy for one month gt gt Copy total but keep mix gt gt Copy for all later months gt gt Copy each amount and mix 000 click here Enter daily manual schedule 2 Import lt Back Next gt Page 101 of 182 E support foreCASH co uk fo re C A S H 3 7 2 2 Daily schedule of Sales by customer If you have selected Manual Import as the sales schedule pattern for any of you key accounts these accounts will have their sales quantities highlighted orange Sales and stock forecast Step 1 Order preference Sales by Customer Step 3 Margin by Supplier Sales by Supplier Customer outlet Total sales Ja gt 21 000 gt J amp F gt 215 gt 28 000 gt 2 gt E gt 71 000 gt E gt a a gt gt Copy for one month gt gt Copy total but keep mix gt gt Copy for all later months gt gt Copy each amount and mix 000 click here Enter daily manual schedule Clicking on the relevant cell will bring up a calendar view from which you can manually enter the sales schedule NB When manual scheduling is in use some of the auto fill quick copy gt gt gt features are disabled on the screen Page 102 of 182 E support foreCASH co uk
51. Suppliers Supplier ref I Supplier name AAPAPEOO2 A4 Paper Supplies Co ABCWHAON1 ABC Warehouse Automation CANON_O01 Canon Consumables CHANGMOO1 Chang Mai Carbon Co COLLINOO2 Collins Diaries Ltd CWRAPOO1 Colour Wrap ple EUROPA003 Europa Inc FILOFA001 Filofax Design Incorp HPCONSOO1 HP Consumables HUMFLMOO01 Humflmans HGB LEADLIOO8 Leadiine Co MITSUBOO2 Mitsubishi Pencil Corp OUPRESO02 OU Press manvenans SoS Customers Customer ref Customer name CRISSCO02 Crisscross Ltd DAWwSONOO3 Dawsons Newsprint EUROFFOO2 Euroffice Suppliers Ltd GRAPHGO01 Graphic Limited INDNEWO01 Independent News Corp JLEWISO02 John Lewis Partnership KENTCCOO1 Kent County Council PAPERCOO2 Paperchase PCASEOO Pencilcase PENINKOO2 Pen and inkcase Ltd RYMANSOO1 Rymans SUPERDOO1 Superdrug Stores Limited WHSMITOO1 WHSmiths Only Suppliers and Customers in the Pool can be deleted to delete a top 9 item it must first be moved to the Pool using the top 9 tab ooo000 Oooo 3 5 7 5 Ledger report export You can export a copy of the supplier or customer ledgers As well as ageing this report highlights e any aggregation of accounts that has been applied e terms applied to ledgers e terms applied to new activity e whether an account attracts Vat This report can be run from the Drivers gt Ledgers sectio
52. V shape Tick Back tick Ramp up Ramp down Flat n shape Week3 push Page 173 of 182 E support foreCASH co uk fo re C A S H j If you are making a single net month end payment to a supplier these rules are unlikely to have a significant impact on the cash flow If you are making multiple payments or are not paying to net month end a large impact versus a flat position may be seen If a customer is part of an ABL lending scheme correctly choosing the sales pattern will be important in trying to model accurately the daily invoicing and subsequent impact on available facilities The pattern for customer sales can be set to a variable pattern whereby different patterns apply in different months of the year See gt Drivers Key Accounts gt Sales Phasing By Month Sales Phasing Phase patterns Gen Default Fixed pattern co Variable 2 Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default Gen customer Default If the monthly pattern is applied you cannot then vary the sales pattern by customer as well All customers will follow the monthly patterns prescribed Page 174 of 182 E support foreCASH co uk fo re C AS H a 14 Notes on the Structure of foreCASH 14 1 Ranked items and grouping of accounts
53. VAT applicable 9 VAT applicable 9 vat Yes C No VAT Yes C No Past business terms 30d 1 Jast____ 60 30 30 days ne Past business terms 30d 1 Jast____ 60 30 30 days ne 7 New business terms 3pq 1 last___60 30 30 days net New business terms spqJast___60 30 30 days net 7 Pool profile details Conform with standard terms l 85 Remainder collection pattern 0 30 30 60 60 90 90 120 gt 120 days J o f o f wtf 3 f 2 Pattern across months U shape X Payment method Cheque X Collection method Cheque Allow repayments C Yes No Allow repayments C Yes No Purchasing pattern fu shape z Def Sales pattem U shape x Asset based lending applicable ABL factored invoice discounting C Yes No Bank Account Barclays current v BankAccount Barclays current ne Currency Stering Currency terina A full description of the business terms can be found in section 3 5 5 Sales purchasing and collections activity patterns are discussed in section 13 By default if an account goes into a net credit position a refund is not raised instead the credit will be retained pending further business If you wish net credits to be reimbursed as soon as they arise check the Allow repayments radio button Page 40 of 182 E support foreCASH co uk fore CAS H 3 3 5 Working trading days of the week If you used Asset Base
54. Whether item has finished goods stock or WIP Set to No for services foreCASH gt gt gt Company 161 DemoCompany v 2 FF Actual local data St 01 03 2009 Lgth 10 Mode Prd Item File Edit Banksetup Drivers key accounts Openingdate Forecastdate Calculate cashflow Yiew Forecast Reports Flex Help Big om taille A ti3 16 Sales and stock forecast Step 1 Products services Step 2 Sales and COS Dept centre Input Method Currenc Has own stock Has WIP Cash Collection Brakes gt Hydraulic gt L3 Ge Amount Sterling N N Has own collection setting Brakes gt L2 Genera L Unii erlina N N Mulitole ome Sales and stock forecast Praducte carvirac Ctan 1 PESENE Sales Item Settings Hydraulic brakes Product service name Hydraulic brakes ss ss s S S Dept centre Brakes m Hydraulic L3 General Method of entering sales Jamunt o A Enter figures in Currency Steins o oo0000 Collections customer Has own collection setting 7 Invoiced Month dispatched work done Month dispatched work done Terms 1 month in arrears VAT months in arrears Bank Barclays current Collect method Cheque 7 AL iat Monthly sales pattern fu shape Trading days Defaut Has Stock M HaswIP Page 80 of 182 E support foreCASH co uk foreCASH 3 7 1 2 Sales and COS product group or items non Project items Enter a sales forecast for each product group t
55. added for example Smith001 DC against which the direct cost can be attributed Page 110 of 182 E support foreCASH co uk fo re CA S H 3 9 Cost centres and departments To increase the detail in your Profit and Loss reports you may wish to group costs by cost centres or departments 3 9 1 Adding a cost centre department To add a cost centre go to Forecast data gt Cost centres and departments type the name of the new cost centre in the box as the bottom of the screen and press Add Cost centres and departments r Cost centres Order Description Edit Delete OHs Oth Inc Sales COS Relevant to 1 General click here Default 4 6 ALL fixed Cost centres and departments Order Description Edit Delete OHs Oth Inc Sales COS Relevant to 1 General click here Default 4 Sf ALL fixed 2 clickhere O All All Sales COS DC Overheads Other Income Delete Now Add new cost centre New cost centre descr Sales teard Enter description and then pi Once you have added the cost centre you can choose whether the cost centre will be available to Sales Cost of Sales Direct Costs Overheads Other Income or all entries in your forecast To do this use the Relevant to drop down list You can use the Up Down buttons to change the order of the departments in the list which in turn will be followed in your P amp L reports Page 111 of 182 E support foreCASH co uk fo re C A S H 3 9 1 1 Sec
56. and raw materials Step 3 is the entry stock for each product group and supplier WIP for projects is calculated automatically and cannot be edited directly Sales and stock forecast Step 1 Products services All Stock Finished Goods Raw Materials Finished Goods Sheds super Sheds general Wheelbarrows Benches Group5 D efault Group6 D efault Group Default Group8 D efault WIP Sheds super Sheds general Wheelbarrows Benches Group5 D efault Group6 D efault Group Default Group8 D efault Supplier materials TIMBEROO PLASTICOO2 TUBULARO01 WHEELIOO7 FABRIOO3 FELTROOO2 Opening Mar 10 Apr 10 May 10 Jun 1 2 245 000 0 0 245 000 o 41 000 41 000 41 000 O 10 000 10000 10 000 0 10 000 10000 10 000 O 15 000 15000 15 000 O 5000 5000 5 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 11 000 11 000 11 000 0O 5000 5000 5 000 O 5000 5000 5 000 o 1000 1 000 1 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 245 000 245 000 245 000 245 000 2 100 000 100 000 100 000 100000 1 10 000 10000 10 000 10 000 20 000 20000 20000 20 000 5 000 5000 5000 5 000 20 000 20000 20000 20 000 30 000 30000 30000 30 000 297 000 297 000 297 000 41 000 41 000 41 000 11 000 11 000 11 000 245 000 245 000 245 000 Clicking on the row for the Product or supplier brings up screen where the amounts or drivers for the stock can be set Page 90 of 182 E supp
57. balance sheet foreCASH will calculate a base opening balance sheet using the imported ledgers opening bank reconciliation data fixed asset list stock figures and tax balances foreCASH will also use the pattern of recurring overheads income to calculate accruals and prepayments If you prepare a forecast using foreCASH in the first few days of a month you may not have a final closing balance sheet and so the estimate generated by foreCASH is sufficient If you do have a precise starting point you can apply adjustments in foreCASH to reconcile the starting position You will also need to reconcile the foreCASH base position if you have opted to include Actual Balance Sheet Data as you go through the year While you may not have a final balance sheet to reconcile to you will have entered an estimated P amp L for the prior month and you will need to ensure that overall reserves movements reconcile Page 76 of 182 E support foreCASH co uk fore CAS H To apply adjustments go via menu Opening Data gt Opening Balance sheet Summary screen or via the Monthly Reports view after calculation is run At the bottom right of the Balance Sheet Tab and if selected to enter Actual Balance Sheet Data the bottom right of the BSH Financial Year Tab there is a button Adjust Opening Company 53 OrignWine v2 June 2010 trom vist StOT OG 2010 Ugh I0 Sia CE HUM NS SCP om TO s ale e mja aap roan tam Page 77 of 182
58. cost of sales e Editing the target stock days for any one supplier will apply this new target days to all months for the supplier e Edit the stock days for a single month for a given supplier only available if the COS for that supplier are gt 0 in the following month e The stock days calculation can be moderated by further applying a minimum and a maximum stock holding for a given supplier e Minimum stock levels may also be affected by any Purchase Order Commitments that have been imported see 3 7 2 7 Sales and stock forecast Step 1 Order preference Step 2 Sales by Customer group Step 3 Margin by Supplier Step 4 Sales by Supplier Opening Jan 08 Feb 08 Mar 08 _ Stock GIT cos Purchase Stock cos Purchase Stock cos Purchase Stock 100 000 90 000 190 000 200 000 90 000 90 000 200 000 90 000 90 000 200 000 PANA00 Panasonic 40 000 47 000 54 000 47 000 47 000 47 000 47 000 47 000 47 000 47 000 HDTV002 High Definitio 20 000 23 250 26 500 23 250 23 250 23 250 23 250 23 250 23 250 23 250 SONY001 Sony Corp 5 000 9 100 22 300 18 200 9 100 0 9 100 0 9 100 18 200 PIONEEROO2 Pioneer 10 000 9 500 9 000 9 500 9 500 9 500 9 500 9 500 0 0 70 000 77 840 56 490 48 650 48 650 77 840 77 840 77 840 77 840 77 840 20 000 26 400 15 200 8 800 8 800 26 400 26 400 26 400 26 400 26 400 DUTY_OTHER Smaller 0 0 0 0 0 0 0 0 0 0 125 000 90 000 100 000 135 000 4 500 0 130 500 90 000 59 500 100 000 390 00
59. daily sales schedule to be imported If this form of import is not required the Item Pro Mode can be used Retailer 3 1 1 1 Item Service or Product project sales mode ttem ro gt cust e Sales forecasts based on items products o enter sales amounts in Sterling or foreign currency or o number of units and sales price per unit or o set up a project with one or more stages e Can specify customer mix Service items can be set to have no stock Manufactured items can have the component elements specified and have finished goods stock and if applicable work in progress e Items can be set up as Projects with stage payments WIP and accrued income Page 20 of 182 E support foreCASH co uk fore CAS H 3 1 1 2 Sales by supplier and customer split mode Supp lt gt Cust e Includes specialist features for wholesalers distributers who buy goods for resale without modification e A single stock level finished goods is modelled e Sales forecasts must define level of goods sourced from each supplier by percentage of total or specific amount e Can specify customer mix e Sales by customer can be imported from excel if required e Purchase order commitments can be imported from excel if required 3 1 2 Revenue Recognition phasing invoices in the P amp L In Item Pro Mode for items set up as projects WIP and accrued income is automatically calculated Items entered with sales amounts or un
60. monthly to weekly view by clicking on a column of data in the weekly or monthly cash flow reports Page 144 of 182 E support foreCASH co uk fo re C A S H 7 3 Cash forecast report The main cash forecast can be printed directly from foreCASH either partially that element visible on screen or in its entirety These print outs can be run in summary view or with one element expanded The main forecast can also be exported to a CSV or Excel file When exporting to an Excel file a template file is provided containing some pre formatting of cells You may find exporting to Excel particularly useful for issuing reports to both internal and external contacts that do not have a foreCASH subscription E Microsoft Excel 070419exportformatXLT 1 xls DER m Fle Edt View Insert Format Tools Data Window Help Type a question for help _ iis Be Oe Aen gt fi Sanh o P Q N K L M N 01 Nov 06 02 Mov 06 03 Nov 06 O4Hov 06 05 Nov 06 06 Nov 06 07 Nov 06 08 Nov 06 09 Hov 06 10 Mov 06 11 Mov 06 12 Nov 06 13 Nov 06 14Nov 06 15 Nov 06 16 Nov 06 Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Payments Top 5 stock suppliers 2 550 009 1 999 000 100 003 500 000 il 2 3 4 zn SupA 1 100 003 1 13 4 15 1 100 003 a a o 0 o a o 0 o o a o o SupB 350 003 SupB past acti
61. no value Sales out basis o r Qtly basis m Own Carriage if customer provides own transport and deducts from invoices Fregene ro Dapat BEE m Net carriage off each specific invoice Percentage rate l 250 Sales out basis E Annual basis m General monthly credit note Percentage rate 0 Days delay 30 Percentage rate l p Days delay 0 Ye December x Sales out basis r d hoc basis None Add ppa Save Close Page 120 of 182 E support foreCASH co uk fore CAS H 3 12 2 Own Carriage Some wholesalers sell goods to customers who arrange their own transport and deduct the cost from their sales invoices foreCASH allows you to set a percentage rate for own carriage deductions You set a rate to be deducted from the payment of each specific invoice or set a rate that will be rolled into a single credit at the end of each month which will be used against the next available invoices outstanding 3 12 3 Cash discounts Terms of business may also include an early settlement or cash discount for paying quickly foreCASH allows you to mark key customers as suppliers as attracting an early settlement discount To use early settlement discounts mark the account with the payment terms that the customer supplier will be paying under to attract the discount then set up the percentage discount to be received Early settlement cash discount scheme settings are entered via Forecast data gt Rebate schemes and cash discounts The
62. normal day Page 41 of 182 E support foreCASH co uk fore CAS H 3 4 Importing customer and supplier ledgers The easiest way to set up key customer and supplier data is to start by importing a list of both current customers and current suppliers Please ensure you have checked the customer and supplier defaults before importing your ledgers see section 3 3 4 If you do not maintain formal supplier and customer ledgers you may create a file for import or add accounts manually please see sections 3 4 4 2 and 3 5 7 4 The Ledger Import screen can accessed from two places in the menu via the gt Opening Data gt Ledgers import and gt Drivers key accounts gt Import Ledgers gt Four steps are involved i choose whether you will import the customer or supplier ledger and then locate the file the file you wish to import ii set the mappings of the fields to tell foreCASH which columns of your file contain the needed information iii review the pre import validation of the import data and if you are happy import the data iv check the imported total agrees back to the value you were expecting to import 3 4 1 Choose customers or suppliers and locate the import file Locate the file you wish to import using the Browse button The file can be in CSV or Excel format The ledger data must be in your base currency usually Sterling before being imported Import Settings 4 Importer 1 Select File 2 Set ma
63. of project a From stock Delete Amount 0 01 50 Pre forecast start date Proj end gt NME 30 Delete Labour Enter as Perc Amount Delete 1 COS labour W Amount 0 30 3 000 Delete 2 COS labour M Percentage 2 00 200 Delete Add stage Costs Specify by stage z Add cost element i Add labour i Reset project basis When reviewing the details of a project you also have the option to Reset project basis to copy an existing project using the button at the bottom of the screen Page 84 of 182 E support foreCASH co uk fo re C A S H 4 You can add one or more stages to a project using the Add stage button The start date of the first stage must be explicitly entered as a date Subsequent stages can have a start date which is driven by the start or end of an earlier stage H foreCASH gt gt gt Company 147 PROJECT TEST v 1 pROJECT TEST WAS 76 11 local data St 01 03 2010 Lgth 24 Mode P File Edit Banksetup Drivers key accounts Opening data Forecastdata Galculate cashflow View Forecast Reports Flex Help D M OR t 4 L ES w a Sales and stock forecast Step 1 Products services Step 2 Sales and COS Project Proj 09a O a Stages and costs Margin Start type Duration Dw M O A Total 22 000 11 350 10 650 1 Stage1 10 000 9 250 750 Date 01 Jun 10 1 Week s 2 Stage2 5 000 2 000 3 000 End of stage Stage plus 0 days 4 Week s 3 Stage3 250 0 25
64. or zAgg GenCapex General Capex Page 50 of 182 E support foreCASH co uk fo re C A S H a 3 5 2 Aggregating accounts There are a number of possible reasons for aggregating a number of accounts into a group e You wish to summarise certain accounts in a single line in order to make it easier to navigate and review the forecast e You have a customer operating a number of branches which you sell to under different ledger codes but which you wish to consider as a single entity e You have a number of customers that represent a sales segment that you would like to consider as a group such as overseas customers customers on special terms or customers managed by a certain department branch e To group accounts which are bad debts All the accounts in an aggregated group will have the same terms of business applied to them Customers or suppliers that have previously been given a rank cannot be added to an aggregated group You may create up to 1 000 aggregated groups gt Drivers Key Accounts gt Aggregate Accounts gt Aggregate customers gt Aggregate accounts i Add Customer Ledge detai Customer id JzAga_MidSized Customer name Mid sized customer accounts Add group Delete Now INDNEWO00 Independent News Corp JDWILLOO1 JD Williams JLEWISOO1 John Lewis JLEWISOO02 John Lewis Partnership KENTCCOO Kent County Council LWOODSOC Littlewoods MAKROOO1 Makro MAPLINOO2 Maplin NEXTOO8 Next Direc
65. settlement discount will be applied to the net invoice amount Settlement discounts are classified by HMRC as a financing activity and as such do not attract VAT Where a customer supplier attracts a settlement discount foreCASH will calculate VAT based on the invoice value less the expected settlement discount A separate percentage settlement discount can be applied to i existing invoices in the debtors creditors ledger ii new invoices expected based on the sales purchasing plan 3 13 Other income If you receive other income on a regular or irregular basis this can be modelled via a specific section tab within the Forecast Data gt Other Income gt section The forms for modelling other income mirror those of regular overheads and irregular complex overheads Opening levels of accrued deferred income are calculated automatically based on the invoice date VAT point relative to cash dates regular income or the invoice phasing relative to revenue recognition Irregular income Page 121 of 182 E support foreCASH co uk fore CAS H 3 14 Dividends and New Share Capital Dividend payments and receipts from new share capital can be schedule using a calendar view If dividends are paid on a regular monthly basis a recurring amount and the day of the month when payments made can be specified Dividend rec Reg div rec 6 500 58 500 Click here Dividend irr One off div 10 000 Click here Recurring Descinion fRegdv SSS M
66. such instance Some additional technical information regarding the fault will also be stored in an error log file named wkerror log and it would also assist us if you forwarded this file to Well Keen T 01582 766 066 E support wellkeen co uk 18 Trade marks foreCASH is a registered trade mark of Well Keen Limited in the United Kingdom Excel Word Adobe Crystal Reports and all other trademarks referenced are the property of their respective owners Page 177 of 182 E support foreCASH co uk fo re CAS H 19 Glossary and abbreviations ABL Asset Based Lending a form of lending whereby a bank or other lender uses an asset typically an invoice to your customer as the security to lend you money Typical forms as Invoice Discounting and Factoring Accrual a liability recognised in a balance sheet to reflect that a cost has been incurred but an invoice for this cost has not yet been recorded in a company s account Accruals are driven by the timing of invoices and do not reflect whether an invoice has been settled Advance rate percentage the percentage of an invoice value that a lender will advance under an Invoice Discounting facility Aged Format ledger a list of outstanding balances split by the age of origin for example invoices raised 0 30 days ago 31 60 days ago 61 90 days ago BACS Bank Automated Clearance Service a form of electronic settlement that normally takes 3 wo
67. system records The bank figure is the balance reported on your bank statement for each account The difference if any relates to payments or receipts recorded in your accounting system which have not yet been recognised by the bank because a cheque has not been presented or has not yet been cleared by your bank Opening Data Manual entries Opening Bank Balances r inini Book balance 125 130 00 LININ ET PRINS Supplier 30 Nov 07 05 Dec 07 PENCILOO1 5 000 00 Click here Uncleared payment 5 0000 s Add Bank Transaction Uncleared receipts 7 Ref optional Unreconciled D Foren E Date banked 30 Nov 07 as Add Details Bank balance 130 130 00 Date clear 03 Dec 07 Customer KENTCCOO1 Amount Unreconciled field must be set to zero a 5 before a forecast can be run Add individual receipt details Total i Add Details Save Close Please note that foreCASH presents the cleared bank view of balances The un cleared payments and receipts noted in the bank reconciliations will appear in the first few days of the cash forecast Page 63 of 182 E support foreCASH co uk fore CAS H i 3 6 2 Stock and goods in transit There are four elements to the opening stock screen e Opening stock reflects the physical value of goods in your warehouse e Items marked as goods in transit will be added to any ledger balance you import for this supplier This assists t
68. timing setting In the example shown the VAT cycle includes a VAT quarter ending in February Q E Quarter End with the return needing to be filed in March Drivers and rules Al Corporation tax H inp VAT VAT parameters r Standard VAT rate Share of pool sales that are zero rated excludes key accounts Fixed gt 0 lt Fixed Mar 11 Apr May 11 Jun11 Variable gt Variable gt m Pool COS purchases VAT VAT C Import VAT C Nil Share of pool COS purchases that are zero rated excludes key accounts 0 lt Fixed Mar 11 Apr 11 May 11 Jun 11 C Variable gt MYAT return frequency and timing Monthly Quarterly Filings include Jove February return March x Annual Filing 7 Payment method Cheque hed Reclaim delay in case of net refund 29 days after VAT return date cut off Page 35 of 182 E support foreCASH co uk fo re C A S H i 3 3 2 Import VAT Once you have imported a supplier ledger see section 3 4 ranked suppliers can be marked as attracting standard VAT import VAT or no nil rate VAT via menu option Drivers key accounts gt Ledgers drivers and key accounts Drivers Ledgers Supplier Terms Suppliers Key COS Key ranked Suppliers COS Supplier Supplier name Past bus terms J C002 J C Wat 30d 1 last___ 6 PANAOO Panasonic 30d 1
69. v 5 Actuals data File Edit Bank setup Drivers key accounts Opening data Forecast data Calculate cash flow Reports Flex Help AMOR 4 L S in 7 316 P amp L Balance Sheet Funds Flow and Cash Flow Balance Sheet Funds flow 11 2008 4 _12 2008 4 Soleloleloalelo Slo 2o o o2 oflo o o ojo ofo o e ols ls clelo slo o 2 5 5 2 2 5 ola clog Set Fin Yr 7 8 Balance sheet Actual figures Financial Year Balance Sheet report If you opted to enter actual balance sheet data see 3 6 11 1 then you can view a balance sheet report for the whole of your financial year Page 153 of 182 E support foreCASH co uk fore CAS H 7 9 Funds flow Actual figures If you opted to enter actual balance sheet data see 3 6 11 1 then you can view a funds flow report for the whole of your financial year including actual data f foreCASH gt gt gt Company 161 DemoCompany v 2 FF Actual local data St 01 03 2009 Lgth 10 Mode Prd Item File Edt Banksetup Drivers key accounts Openingdata Forecastdata Calculate cash fow view Forecast Reports Flex He 180 072 540 216 540 216 540 216 1 667 5 000 5 000 5 000 257 500 0 0 0 454 841 304 565 15 177 4 305 13 333 0 0 392 744 392 744 26 395 0 8 100 0 36 669 129 085 712 952 529 943 549 520 Opening net cash debt 0 165 084 878 036 1 407 978 Cash inflow outflow 129 085 529 943 Closing net cash debt 165 084 87
70. want to restrict access to foreCASH for example in a terminal server installation where a number of users run programs on a single server or where several staff may log onto the same PC you can switch on Users and Security settings via menu option File gt Properties and Keys Once the Require user and password to run foreCASH on this PC Server setting is activated users will be prompted for a valid username and password on all subsequent openings of foreCASH A foreCASH gt gt gt Company 118 Electrical wholesaler v 1 Was 76 3 localdata St01 03 2011 Lgth 15 Std File Edt Banksetup Drivers key accounts Opening data Forecastdata Calculate cashflow View Forecast Reports Flex Help AN AE Ai IESE SEEE Ma 2 316 O oneee Y e Current user not logged in Login User Secuirty Require user name and password to run foreCASH on this PC Server E User List Administrator click here Standard click here Standard click here Delete now Add user The first user created will always be given Administrator rights for foreCASH which allowed then to add further users or to reset other users passwords Page 16 of 182 E support foreCASH co uk foreCASH 3 Creating your first forecast quick start In order to create your first forecast you will need to follow the steps below Additional information for each step can be found on the following pages Step 1 Set start date length and s
71. 0 Cap on amount borrowed 250 000 All COS suppliers 2 By ranked suppliers Timber box Plastic Supplies Co Tubular Metal Supplier Wheels and pins Ltd Cardboard and bubble Itd Fabric houses and tents inc Felt and roofing South West Select All Clear All r Stock Provisions applied by lender m Advance on WIP and finished goods 4 1 000 Initial stock adjustment Percentage advance on WIP B Other adjustments Percentage advance on Finished Goods Provision of 20 0 on first 5 000 of stock Provision of 10 0 on remaining stock Plus 0 amount J7 Cale after advance rate applied Cc 2 000 other reserves Lenders often apply provisions or reserves within the calculation of available facility and foreCASH also models this In Supp lt gt Cust mode you can opt for stock based facilities to be re calculated on a weekly basis Page 25 of 182 E support foreCASH co uk fo re C A S H When you run the forecast calculation foreCASH will convert this information into the overall facility level that will run from the end of each month You have the option to manually edit or add to the facility if required Bank facility details Account Description STock based Stock based lending EEA Stock Based Lending el Closing stock atm e Import Loan 2 31 Oct 10 286 250 Click here O 30 Nov 10 286 040 Clickhere O 31 Dec 10 286 250 Clickhere
72. 0 End of stage pa Stage2 plus 12 days 20 Days 4 Stage4 6 000 0 6 000 fp te Stage3 plus 0 days 1 Quarter s 100 650 Stage4 plus 0 days 0 Quarter s End of stage r Project costs click on stage costs to see detail You have the option whether to specify the project costs by individual stages or for the project as a whole If you wish to specify costs for the project as a whole these can be phased evenly over the life of the project or pro rata to individual stages 2 COS labour M Percentage 2 00 200 Delete Costs Specity by stage Add cost element Add labour Reset project basis er Pro rata to stage values Specify by stage Add stage Cost elements either materials or labour can be added using the buttons below the project grids Cost elements can be defined as a percentage of the stage project total or as a specific amount Page 85 of 182 E support foreCASH co uk fore CAS H For materials used on a project you can specify when they are booked out of stock By default items are assumed to come from general stock The timing of payments will be driven by the level of stock you specify and the rate of usage If items are bought for a specific project select the Job Spec Job Specific check box With this option you can then specify the precise payment terms that apply including the option to time payments in relation to the stage or project completion Stages and costs Invoici
73. 0 373 090 473 490 490 400 240 800 273 990 523 590 363 990 333 090 492 690 Copy gt Minimise Copy gt Minimise Copy gt Minimise Copy gt Copy all gt gt Copy all gt gt Copy all gt gt Copy all gt gt Maximum and minimum stock levels Max Min PO Mar 08 Supplier J CO02J C Days Towage Maximum stock 1 000 000 T No Maximum a7 30 a 30 30 a Minimum stock 200 000 7 30 60 60 30 f Save Cancel z 0 30 f 30 30 7 The maximum stock level may be exceeded if the opening stock balance is A 30 30 above the target maximum stock and there has been an insufficient sell z 0 through of goods in the following months to reduce the stack holding to 30 within the target level 2 33 Page 106 of 182 E support foreCASH co uk fo re C A S H j In order to maintain the integrity of stock movements foreCASH may prompt you to Auto fix stock levels when a change you have proposed will lead to a negative purchase level highlighted in red Sales and stock forecast Fe i no Purchase 11 000 000 3 000 9 000 11 1 500 0 0 1 500 0 0 0 0 0 0 1 796 1 796 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 038 500 8 500 18 500 1 048 500 6 800 700 1c Total stock 2 540 000 17 500 9 527 500 12 050 000 17 596 3 096 12 0 Copy gt Copy all gt gt Cor b Autofix lt Back C Close Quick fill options Apply gt gt
74. 0 80 000 15 000 D 205 000 120 000 240 000 Mar 08 Apr 08 May 08 40 000 40 000 40 000 4 000 4 000 D 36 000 40 000 44 000 40 000 44 000 44 000 40 000 40 000 40 000 E support foreCASH co uk fore CAS H After importing POCs they are displayed on the opening data stock form If the option to include POCs in GIT when shipped was chosen any POCs shipped but not delivered at the forecast start date will be shown under GIT 2 POC imported Opening Data 100 000 40 000 20 000 5 000 10 000 70 000 20 000 125 000 390 000 To edit details click on white cells in the grid Enter opening stock balances and GIT Goods In Transit The GIT figure is for items already shipped by suppliers but not yet recorded in stock foreCASH will include in stock and accrue for invoice Import POC PO commitments can be imported via the sales and stock forecast screen In item mode PO commitments can be included within GIT GANI Goods Received but Not Invoiced by your suppliers an accrual will be recorded and a payment scheduled for GRANI Clear PU Al Saye Page 96 of 182 E support foreCASH co uk fore CAS H 3 7 1 5 2 Stock feeds stock transfer lf a supplier has been set up to feed into another supplier see section 3 6 2 1 then a stock transfer will be applied at the end of each month to zero the balance carried forward Sales and stock forecast Marualenty l ee Page 97 of 18
75. 000 16 Jan 07 10 000 47 Jan 07 10 000 18 Jan 07 10 000 19 Jan 07 10 000 03 Jan 07 Total 03 Jan 07 04 Jan 07 1 000 05 Jan 07 1 000 06 Jan 07 1 000 07 Jan 07 1 000 08 Jan 07 1 000 09 Jan 07 1 000 10 Jan 07 1 000 11 Jan 07 1 000 12 Jan 07 1 000 13 Jan 07 1 000 14 Jan 07 1 000 Page 158 of 182 E support foreCASH co uk fore CAS H 8 Changing the start date or length of your forecast 8 1 Changing the start date of your forecast At the end of each month you will probably want to refresh your forecast by e Bringing in the latest month end actual figures for cash debtors and creditors as a new starting point e Reviewing the sales and stock forecasts in light of recent trading You may also want to e Push out the end date of the forecast by an additional month e Review cost levels Before changing the start date consider whether you wish to retain the current version of the forecast for reference if so you will need to create a new version of the current company forecast see 11 2 To change the start date of the current version as you did for your first forecast see 3 1 e Select gt File gt Change start date from the menu bar e Next enter the starting month for your forecast e Set the length of your forecast in months Provided the new forecast date is later than the current forecast date you will be given the option to roll forward your forecast This will al
76. 000 350000 150 000 Maximum number of parallel deferrals Deferred at month end 100 000 o o Deferred at month end Maximum parallel deferrals 800 000 540000 230000 120 000 Longest deferral days Day pounds deferred 7 200000 1950000 700000 300000 Average deferral days 3 Agreed 100 100 o Deferral Summary z 3 5 3 3s o s 2 3 a Page 1 of4 Page 157 of 182 E support foreCASH co uk fore CAS H 7 13 Supplier deferral status report The supplier status report can be run by supplier then by status or by status and then by supplier The report shows deferrals of amounts in your base forecast It does not show the deferral of any payments resulting from the flexing of your forecast foreC ASH for XaYbZc Limited Dataload date 31 08 2007 Supplier Payment Deferrals Page 1 of 2 Status Supplier Original Date Revised Date Total 02 Jan 07 05 Jan 07 25 000 02 Jan 07 Total 25 000 03 Jan 07 15 Jan 07 7 000 16 Jan 07 6 500 17 Jan 07 2 121 18 Jan 07 2 131 03 Jan 07 Total 03 Jan 07 15 Jan 07 10 000 16 Jan 07 10 000 17 Jan 07 10 000 03 Jan 07 Total E 03 Jan 07 15 Jan 07 30 000 16 Jan 07 18 762 03 Jan 07 Total 48 762 4 gt 02 Jan 07 05 Jan 07 10 000 02 Jan 07 Total 10 000 03 Jan 07 18 Jan 07 10 000 03 Jan 07 Total 10 000 4 01 Jan 07 02 Jan 07 24 000 03 Jan 07 23 000 04 Jan 07 23 000 01 Jan 07 Total 70 000 03 Jan 07 15 Jan 07 10
77. 01 Sony Corp 75 870 0 75 870 24 PIONEEROC Pioneer 57 400 0 57 400 25 J CO02 JVC 127 892 0 127 892 26 PANA00O7 Panasonic 125 777 O 125 777 27 HDTYO02 High Definition TY Corp 100 000 O 100 000 28 RADIOONS Digital Radio UK 30 000 0 30 000 Edit Extra To do this click the edit extra mapping button This brings up tabs on which to set Bank account terms and VAT codes Any newly found references from the accounting software ledger import are initially set to use the default settings in foreCASH Click on a line to choose an option from the relevant list in foreCASH 1 Pert ie IWI ZAI IES FT LLLI m i fields mapping VAT code Default VAT Nil VAT applies Accounts Software Ref foreCASH Ref D NIL VAT 1 VAT 1 Import VAT where ranked only Exempt lt as default gt Nil lt as default gt 001 lt as default gt 002 lt as default gt 003 lt as default gt 004 AEE 005 006 VAT i TI PNICVAT T10 lt as default gt T11 lt as default gt T12 lt as default gt T13 lt as default gt T14 lt as default gt T15 lt as default gt Only apply to newly found accounts Close Lastly at the bottom left you can opt whether this auto mapping only applies for new items If manually override say the terms for an account from that shown in your accounts system checking the only apply to newly found accounts box avoids terms reverting to those in the accou
78. 03 Jan 2008 04 Jan 2008 OF Tuesday Wednesday Thursday Friday q Receipts 0 ome 0 p FAL A10 PUL Customers other 101 827 Other receipts o Receipts Total 0 1 270 802 29 467 123 793 Payments BI COS top 5 143 073 COS others 899 Direct Costs Salaries Propert Other Overheads 376 Other Taxes Interest Capex 50 000 I Payments Total 0 O 194 348 0 Exchange gain loss vy Daily move on cash O0 1 270 802 164 881 123 793 Net Cash overdrafts 14 873 1 255 929 1 091 048 1 214 840 Overdraft facilities 25 000 25 000 25 000 25 000 Undrawn ABL capped 1 000 000 0 0 0 Headroom Short fall 1 010 127 1 280 929 1 116 048 1 239 840 4 ABL b f uncapped 1107106 1107106 10 486 25 424 19 151 150 000 1 634 1 215 1 107 106 i a a o O 267 592 283 759 296 024 1 000 000 1 000 000 1 000 000 1 000 000 0 35 00 85 00 35 00 i In the receipts total section and ii if the total line is selected in the lower grid with a more detailed breakdown in the movement on the ABL account By clicking on the Drawn down from ABL line in the daily cash flow forecast a summary of the ABL account Page 161 of 182 E support foreCASH co uk fore CAS H a movements will be called up in the second grid below the main forecast summary In turn clicking on a white row in the ABL summary will open a new screen which allows the full drill down m
79. 03Jan 2008 04Jan 2008 Of Tuesday Wednesday Thursday Friday ABL b f uncapped 1 107 106 1 107106 0 0 Sales impact 25 424 19451 Collections impact 150 000 1 634 1 215 Rate change impact Available today uncapped 1 107 106 1 267 592 27 057 20 366 Drawn down 0 1 267 592 27 057 20 366 Draw rule All All All C F in available uncapped 1 107 106 0 0 0o Interest and charges 0 0 0 0 Amount borrowed ABL 0 267 592 283 759 296 024 Cap 1 000 000 1 000 000 1 000 000 1 000 000 Ledger balance Bank 1 302 478 314 814 333 834 348 264 Borrowed 0 85 00 85 00 85 00 Sales Impact Base sales net VAT 1 day delay 0 26 796 20 187 13 351 Sales phasing Sales flexing Reconciled sales CN General Sales total net 26 796 20 187 13 351 Gross sales inc VAT 29 910 22 530 14 900 Proof of delivery time delays 10 000 CN cash Disc Adjusted sales 29 910 22 530 4 900 gt gt gt Processed 0 29 910 22530 O gt gt gt Advance rate 85 85 85 gt gt gt Sales Impact 10 486 25 424 19 151 POD cumulative balance 0 0 0 Page 162 of 182 E support foreCASH co uk foreCASH 10 4 Adjusting daily ABL sales data If the spread of sales predicted by foreCASH is not exactly as you expect or indeed as has occurred you can adjust the sales on a given date by either Pushing some or all of the sales to a different date or by using a calendar view to Reallocate that day s sales To
80. 08 4 000 24 05 2008 12 03 2008 29 04 2008 4 000 13 06 2008 01 04 2008 19 05 2008 4 000 03 07 2008 21 04 2008 03 06 2008 4 000 23 07 2008 11 05 2008 Bj lt Back Validate gt Close You have the option to include POCs within Goods In Transit GIT by selecting the relevant check box Items will be added into GIT based on the shipping date if imported or else the specific number of days in advance of the land date chosen from the drop down list Page 93 of 182 E support foreCASH co uk fore CAS H iv Validation checks and confirmation The validation checks data in each column is consistent with the expected information type i e dates or amounts Purchase Order Committments import 1 Choose accounts 2 Select file Pre Import Report All rows valid Page 94 of 182 E support foreCASH co uk foreCASH After importing POCs for a supplier they are separately reported in the schedule of additions and stock usage H foreCASH gt gt gt Company 161 DemoCompany v 3 Wholesaler Item Mode POC local dat File Edit Banksetup Drivers key accounts Openingdate Forecastdata Galculate cashflow View F RM OP 4 EB vB t 230 Sales and stock forecast Step 1 Products services Single supplier stock JYC002 JYC Stock B F Stock C F PO commitments Other Additions to Items or COS Page 95 of 182 RAM calculation method Manual entry Jan 08 Feb 08 100 000 60 00
81. 1 162 163 164 165 166 174 175 Adavance against un cleared receipts 30 Collections impact 168 Disallowed invoices 165 draw down 166 Limit to single customer balance 29 Multiple accounts 31 PODs 164 Reconciling 168 Sales impact 167 Auto sweep 24 25 Backing up 7 Bad debt 51 71 Balance sheet Actuals Financial Year Balance Sheet report 153 report 148 reviewing your forecast 127 Bank accounts 22 53 175 reconciliations opening 63 Bank accounts 22 Calculate forecast 123 Capital Expenditure 119 cash discounts 120 Cash discounts 121 cash strain 132 cash with order 60 CIS See Construction Industry Scheme Clear the calculation 123 125 Company and version 9 Consolidated forecasts 170 Construction Industry Scheme 89 Corporation tax 66 Cost centre 111 credit card 56 60 credit note accrual 70 Currency Master currency 9 Daily schedule of Sales by customer 103 deferred income 121 Department 111 Second and third levels department categories 112 Direct costs 110 Dividends 122 Driver Ledgers 53 early settlement 121 error 177 Exchange rates 35 export a forecast version 170 daily cash flow 145 ledger 62 monthly reports 148 weekly report 144 Factoring See Asset Based Lending Finance leases existing 74 foreCASH new 120 Fixed assets 73 Flexing 136 sales 136 stock 138 Forecast Base 123 126 Forecast status 124 Foreign currencies 160 Funds Flow 127 148
82. 1 2 New finance leases 0 eeeee 120 3 12 Rebate schemes and cash discounts 120 3 12 1 Rebate Schemes ccececeeeeeeees 120 EA Own GaraQe ss 22 E cass ste r T A EEE cy ocans AE E T 121 ea ee GashiGiSCOuntS ivisise cacsts A E Geesduisausacvasstosiesuiaeadenivedvaisadsas 121 3 13 Other NCOME 121 3 14 Dividends and New Share Capital 122 3 15 Calculate a Base FOreCas tics ticcctesceccsdsiscesesiveansavvecsasscesstavgecsans Ea Eia EEE aa OE EE aa A EA E Eaa AEOS EEE Eia 123 3 15 1 e ene thie ORC CASE eerie etc ate E A A E 123 3 15 2 Forecast Status cash flow status 124 3 15 3 Late Changes without Clearing the Forecast 125 3 15 4 What is a Base Forecast cceceeeeeees 126 3 15 5 Reviewing your Base Forecast 127 3 15 5 1 Daily cash flow report review 128 3 15 5 2 Bank summary breakdowns 130 4 Planning a solution to a period of cash strain 4 1 Revising cash transaction dates 4 1 1 Drag and drop sses 4 1 2 Defer advance 4 1 3 Auto spread eeeeee 4 1 4 Re allocation calendar 4 1 5 Status of transactions 4 2 Flexing sales and stock levels 4 2 1 Flexing Sale a 4 2 2 Flexing StOCKv 2 i 220 sie avi ieee dence adit aE AATA OAA aa a ATAOE D ena dl pale vdivan dl apenas iio 5 Delivering a solution 2 0 ee eee eeececeeeeeeeeeeeeaeeeeeaeeeaeceeeeaeeaesaeeeaeeaeesaeesaesaeeaessaesaeeeaeesaesaeseaesaeesaeeea
83. 100 less the percentage previously advanced at the time of invoicing 10 6 Reconciling all ABL elements for a given date As well as reconciling sales and collections individually you can choose to reconcile all three elements sales collections and draw down of a given date at the same time This option is selected by right clicking on the drawn down amount for a given date ABL Reconcile r Summary 07Jan 2008 Monday 5 100 01 52 017 00 Draw Down 12 887 00 Comments Actions 4 899 99 10 000 00 0 10 000 00 Increase next sales day 5 100 01 Var receipt Action receipts 5 400 00 24 345 00 17 536 00 4 500 00 next collections z 0 gt 4 736 00 nezl ions last coll s in month no cascade As there can be a time delay for new invoices and cash collections to be applied to the available amount to draw down when reconciling the draw down amount the sales and collections figures being reconciled will look back to the relevant earlier date Page 168 of 182 E support foreCASH co uk fore CASH 11 Multiple companies and multiple versions 11 1 Multiple companies foreCASH allows you to make forecasts for a number of companies Up to 99 different companies can be modelled Subject to appropriate licence agreement foreCASH Consolidator allows you to consolidate a number of companies See section 12 a oe foreCASH Select Company V
84. 13 157 43 316 32 632 21 607 2516 37 175 0 43 316 41 997 41 997 111 804 113 106 110 641 0 112 0 0 87 51 6 1 207 0 O 246 430 0 0 Ex min Ex min Ex min Ex min 0 0 0 41 997 41 997 41 997 134 713 113 157 110 647 0 0 a 1 319 1 319 1 319 0 51 57 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 0 0 0 2 59 0 0 0 Page 131 of 182 E support foreCASH co uk fore CAS H 4 Planning a solution to a period of cash strain There are two main aspects to remedying a period of cash strain i To revise cash transaction dates by modifying the timing of payments and receipts for the business activity assumed in the Base Forecast typically deferring payments to suppliers or accelerating receipts from customers for example by offering early settlement discounts ii To change flex the business activity for example reducing the forecast levels of stock holding and raising the level of sales 4 1 Revising cash transaction dates There are a number of built in methods for revising cash transaction dates When such changes are made they are recorded separately from the Base Forecast A status will be created for the change for example whether it has been agreed with the customer supplier and an audit trail is instigated For more information see section 5 1 4 1 1 Drag and drop File Reports 01 Sep 07 02 Sep 07 03 Sep 07
85. 139 Payments On Account in supplier creditors ledger 44 Payroll 113 Petty Cash 23 Profit and Loss 148 Actual P amp L report 153 P amp L detail 149 review your base forecast 127 Project Items 84 Protocol menu routes 6 provision bad debt 71 Purchase Order Commitments 92 Purchase Order Commitments POC 108 quick start flow chart 17 Ranked items 52 175 Rebate schemes 120 Rebate Schemes 120 Reconciliation 140 Reconciling opening reserves to actual balance sheet 76 Reports 142 Main excel 143 144 145 146 147 strain surplus absolute 148 155 Strain surplus relative 156 Supplier deferral status 158 Supplier strain 157 retailer 60 retail mixes 61 Revenue Recognition 103 phasing invoices in the P amp L 21 Revising cash transaction dates See Management Actions Salary foreCASH opening accrual 66 Sales customer mix 98 101 Daily schedule of Sales by customer 102 forecast 79 Security keys 8 settlement discount 121 Share Capital new 122 share capital and reserves 76 shared drive 9 10 11 12 13 15 Access restrictions to shared data 15 copying from local data 13 start date 19 Start date Changing the start date or length of your forecast 159 Status reports 139 transactions 135 Stock feed 65 97 forecast 79 opening 64 Stock based loans 25 Taxes opening accrual 66 Terminal Server 176 Terms of business 54 non standard 53 user defined terms 59 user defined
86. 2 E support foreCASH co uk fo re C A S H a 3 7 1 6 Sales mix by customer Step 4 is the mix of sales across customers In the product settings it is possible to assign sales of products items to specific customers If sales of a product have a specific cash collection profile you can set it to have its own specific debtor Where sales of a product are set to Multiple customers they are split out across ranked customer groups using step 4 The mix can be set by month You can copy the sales mix for a given month to all following months by using the gt gt text at the top of each month s percentage mix figures fa foreCASH gt gt gt Company 128 Z_Demodata v 2 Demo_manufacturing lo File Edit Banksetup Drivers j key accounts Openingdate Forecastdate Galculat RM OP 4 LES vP 2 316 Sales and stock forecast Step 1 Products 7 services ames Grand Total Customer specific 75 000 Sales items with own 50000 000 Perc based mix BODIYO03 WEBSITE TREETOPOO 3 220 7 0 WEBSHEOO 2 760 6 0 WESTLAOO 2 300 5 0 JLEWIS002 2 300 5 0 JONJONOO2 1 840 4 0 INDGAROO1 1 840 40 KENTCCOO1 1 840 4 0 ltem Sheds 0 0 Key customers Pool Page 98 of 182 E support foreCASH co uk fo re C A S H 7 To see how the percentage split on sales to multiple customers combines with any product sales with specific customer or own debtor settings click the View Total butt
87. 21 23 742 23 964 22 735 22 950 23 164 21 928 22 134 22 341 21 097 If you enter a finance lease with a lease start date that falls after your forecast start date foreCASH will assumed the lease is to finance a new addition and will add the item into your fixed asset forecast at the appropriate time See also section 3 11 2 Page 75 of 182 E support foreCASH co uk fore CAS H 3 6 11 Share Capital and reserves If you wish to enter Actual Balance sheet Data Data for the start of the financial year then ensure the check box on the right hand side is ticked Opening Share Capital and Reserves r Forecast new estimates gt opening data r Start of Financial Year gt opening data Enter the share capital and other reserves as at the start date of your forecast The Profit and Loss want to include Actuals Balance Sheet Vv Reserve will be calculated based on the other Data for the current Financial Year opening balance sheet data or the cumulative actual profits Share Capital 10 000 Share Capital 10 000 Other Reserves 100 000 Other reserves 110000 PandLteserves Calculated field P and L reserves 3 136 976 Total Save Close The left hand box is data as at the new estimates start date ie the date of the ledger imports starting cash etc The right hand box is for data at the start of your financial year 3 6 11 1 Reconciling opening reserves to actual
88. 32 12 220 28 513 i 43 432 13 030 30 402 a 51 566 15 470 36 096 0 16 78 6 502 16 846 16 846 5 51 8 51 30 402 You may use the print screen feature to print the report or Export all sections of the report to Excel You can change the which tabs are exported via Reports gt Report Options Page 148 of 182 E support foreCASH co uk fore CAS H 7 6 1 Monthly reports P amp L detail To view a detailed breakdown of the costs making up your profit and loss forecast use the View Detail button on the monthly P amp L report This will export all the detail into an Excel file Use the buttons to drill down into the detail Gn ied e A E 1 FE Cw a Home Insert Page Layout Formulas Data Review View Magdi Calibri Je a y E wrap Tet Custom GA Copy a e e 3 iai J Format Painter Barrie E zA S S E H Merge a Center Eh Clipboard Fy Font T Alignment Tj Num E4 2120 1l2 l P A B 1 ResellerPack v 1 2 14 Sales by Cust 15 395 00 26 Sales bySupp gt gt 405 000 260 000 395 00C l 37 COS by Supp gt gt 373 090 240 800 363 99 38 Margin amount 31 910 19 200 31 010 39 Margin rate 8 00 7 00 8 00 40 43 Direct Costs gt 405 260 395 l 51 Rebates gt gt 14 678 9 460 14 387 52 Net Margin amount 46 183 28 400 45 002 53 N
89. 5 1 Calculating how much is available for draw down ss 10 5 1 1 MGISS aan or RAET T E E E E A A T T 10 5 1 2 Collections MpaCi reinsa ann raaire aAa AA SSA E REAA AAE SEA E a 10 6 Reconciling all ABL elements for a given date Multiple companies and multiple versions 0 se 11 1 Multiple companie Sasnnn a a a aa a aa iara thane i aie did i sedan 11 2 Multiple Versions ec ceeessesseceeecseeeseeeseeseeeaecseecseeaecsaesaeeaecsaeeseeeaesseesaesaesseeeaessaesaeesaessaesseesaessaeeaeeeaeeaeesaeseaeseeeeaeeeaeeaee 11 3 Exporting a forecast version 11 4 Importing companies or versions Multi company aggregated consolidated forecasts 12 1 Enabling Multi company consolidations 12 2 Setting up Multi company consolidations 12 3 Multi company consolidation reports Activity patterns seenen Notes on the Structure of foreCASH 14 1 Ranked items and grouping of accounts 14 2 Weekends bank holidays and Shut down days 14 3 Past new and flex lines ce ceeeeceeeseeeeeeseeeeees iti Terminal Server Installations cceseeceeseeeeeseeeeceeseeseeeaececeeseeeaesseeeaeseaeeaceeaeesaesaeeeaesaeeseseaessaeeaesaecseeeaeesaesaeeeaessaeeaeeeateaeeeaeeegs Updates and maintemance releases is ai 3 sscdscsscg Senge satesseacesdecass dase ystsan saad aded caaduvedsdeeada sbeausphaceale ssvageavseshassadesnsnasndi eahdneteeeseress Warning mess
90. 50 21 250 21 250 21 250 21 250 21 250 edit 10 000 10 000 10 000 10 000 10 000 10 000 edit 10 000 10 000 10 000 10 000 10 000 10 000 15 000 15 000 15 000 15 000 15 000 15 000 gt Cost per Unit Eu 150 150 150 150 150 1 250 Page 83 of 182 E support foreCASH co uk fore CAS H 3 7 1 3 Project Items Sales and COS When you first create an item based on the Project entry method you have the option to base it on a blank project or a pre existing project if any Using a pre existing project as a template can save time when your projects have a similar composition foreCASH gt gt gt Company 147 PROJECT TEST v 1 pROJECT TEST WAS 76 11 local data St01 03 2010 Lgth 24 Mode Prd Item File Edit Banksetup Driyers key accounts Openingdata Forecastdata Calculate cashflow View Forecast Reports Flex Help Big om ti 4h li isivin t 3 6 Sales and stock forecast Step 1 Products services Step 2 Sales and COS Project Proj 09a Projectname Pioa sss Peto Stages and costs Invoicing 11 350 10 000 9 250 750 Date O1Jun 10 1 Week s 5 000 2 000 3 000 End of stage Stage plus 0 days 4 Week s 250 0 250 End of stage Stage2 plus 0 days 20 Day s 6 000 0 6 000 End of stage Stage3 plus 0 days 1 Quarters 750 100 650 Start of stage Stage4 plus 0 days 0 Quarter s Enter as Amount t Materials booked out Job aN T erms Amount Bui 4 000 Start of project From stack Delete Percentage 20 00 2 000 Start
91. 8 036 1 407 978 1 957 498 0 0 va 1 2009 12 2009 x By Month By Gtr Rolling Yrd 14 To select a funds flow including actual data use the drop down box at the bottom left of the funds flow report to switch from a rolling future report into the Yr1 annual report view This view can be presented by month or by quarter It is important that your balance sheet actual figures reconcile before running this report foreCASH will warn you if this is not the case Page 154 of 182 E support foreCASH co uk fore CA S H 7 10 Strain surplus overview absolute This report shows the level of any strain surplus both before and after any cash management actions that have been applied as part of the forecasting process Surplus strain absolute Gd a fox foreC ASH for XaYbZe Limited Dataload date 3408 2007 Peak values by month Day wel ghted values by month January February April January February Maroh April O 800000 250000 140 000 ai 2 500 000 300000 250 000 140 000 o o o 2 000 000 o o o 175 000 o o o o greed O 300000 150 000 ral 2 500 000 o 2 000 000 o o 100 000 o o o Used Bank support 180 000 o o o o o 300000 150 000 oO 100000 175 000 o o o a 100 000 176 000 Suppl other 0 o o 10 000 300000 200000 175 000 Used support 2 700 000 300 000 175 000 o o o o Unresolved 700 000 o o Base and adjusted position relative to facility coo
92. ALAE Step 2 Sales and COS Mar 10 Apr 10 ra oe Jul 10 Aug 10 Ser 171100 171 000 171 000 171 000 127 010 127 000 i P i F 127 000 127 000 44 090 44 000 44 000 44 000 44 000 44 000 25 77 25 73 25 73 25 73 25 73 25 73 Single item Sheds general Add edt cost element 3288 _ ____ Supplier TUBULAROOT 7 ELR COS total Method Percentage of Sales Price 7 60 750 ee curency a a amount 0 go PLASTICOO2 Baia Delete Cancel oK 14 250 14 250 14 250 14 250 14 250 14 250 19 00 19 00 19 00 19 00 19 00 19 00 Add cost element se ct cell and use F2 for copy to all months options If a product s sales entry method is based on units then the costs by supplier can also be based on a price per unit Alternatively all products can have costs entered as a specific amount or as a percentage of the sales total for that product in a given month Sales and stock forecast Step 1 Products services Step 2 Sales and COS Mar 10 Apr 0 May 10 Jun 10 Jul 0 Aug 10 171100 171 000 171 000 171 000 171 000 171 000 127 010 127 000 127 000 127 000 127 000 127 000 44 090 44 000 44 000 44 000 44 000 44 000 25 77 25 73 25 73 25 73 25 73 25 73 Single item Wheelbarrows ce m ET acre mE ts mr L ail Aug 10 edit 25 000 aa a ir ei a 100 Cost per Unit 250 250 250 250 250 250 COS total PLASTICOO2Z TUBULARO01 add ele 21 2
93. Alignment FI Number Ca a B D E support foreCASH co uk fo re C A S H 7 5 ABL Invoice discounting bank statement view ABL account balances and movement can be shown in a bank statement view via Reports gt Export Main forecast gt Bank statement ABL when viewing the daily cash flow screen or via the Export List button when viewing the detail of an ABL account G EAr E g si foreCASH_Detailvix2 Compatibility Mode Microsoft Excel Home Insert Pagelayout Formulas Data Review View Developer Sage B ae Calibri v En E wrap tot Custom Eel 7 Bad Good TK ii Zeer ay za gt u P Grominne BE UEO A E E ME Beea BY o 8 contona format Neutral Gaevtion E E N e e l Clipboard a Font 5 Alignment a Number a Styles Cells Editing E4 fe A A B c D p a F G H 1 J L M N o 1 Showing Account GBP_ABL showing in Master currency Processed Date Description Initial Date Collection 100 Sales inc VAT Retention Sales coll impact Drawn down Charges and Available un Borrowed Ledger per bank interest capped 3 Bt Opening Balance 280 250 200 000 565 000 01 Jan 2013 Cash B f unprocessed 31 Dec 2012 100 000 l 85 000 15 000 5 Sales invoicing B F unprocessed 30 Dec 2012 10 000 1 500 8 500 303 750 100 000 475 000 6 02 Jan 2013 Cash WAITROO1 Waitrose 01 Jan 2013 65 000 55 250 9 750 313 500 35 000 410 000 ai 07 Jan 2013 Cash WAITROO1 Waitrose 04 Jan
94. CAS H i 10 4 2 Disallowed ABL invoices There are two ways that invoices can be disallowed in order that they cannot be borrowed against e Your ABL lender may disallow certain invoices such as old unpaid items The POD feature can be used to remove an appropriate level of invoices from the ABL availability level e f you offer customers cash discounts early settlement discounts your lender may disallow a proportion of invoices An opening figure for disallowed items due to cash discounts on the ABL bank opening data screen foreCASH will adjust the amount disallowed due to cash discounts at the end of each month based on o the opening figure o cash discounts taken in the forecast and o expected new invoicing where cash discounts apply Opening Data Manual entries E Bank accounts Bank ABL m Ledger total recorded by Lender m Reconciliation of ABL account ledgers Ledger total recorded by lender a 1 302 478 00 Ledger total recorded by lender I a 1 302 478 00 Disallowed cash discounts b i Disallowed proof of delivery and aged items 0 Edbak eal il aca ior cleared o 1 000 000 00 b i Allowable ledger c a bi bii 1 292 478 00 Invoices not submitted to processed by lender n 12336 00 Advance rate on forecast start date d 85 00 31 Dec 07 7 336 00 Potential full advance e c x d 098 606 30 30 Dec 07 5 000 00 Cap at forecast start date
95. Clear calculation rescheduled items flexes reconciled items and amend the base data Post calculation Page 123 of 182 E support foreCASH co uk fo re C A S H i 3 15 2 Forecast Status cash flow status From versions 2 74 of forecast a forecast status is highlighted when no other screen is being specifically viewed to highlight whether a cash forecast calculation has already been run A foreCASH gt gt gt Company 161 DemoCompany v 5 Wholesale Item Mode Stock feed local data St 01 File Edit Banksetup Drivers key accounts Openingdata Forecast data Calculate cash flow View Forecast Reports eM IE Ai IE SE SIE AEO Forecast status Cash flow calculation pending Re display cash flow Clear cash flow calc and amend base data Cash flow calculation run Management actions exist lf a cash forecast has been it will be highlighted if manual changes such as drag drops or flexes have been applied to the forecast i foreCASH gt gt gt Company 161 DemoCompany v 5 Wholesale Item Mode Stock feed local data St 01 File Edit Banksetup Drivers key accounts Opening data Forecast data Calculate cash flow View Forecast Reports MM Om eA Forecast status Cash flow calculation pending Cash flow calculation run No management actions Cash flow calculation run Management actions exist Cear mgt actions ard amendbase data TE m Management actions
96. E support foreCASH co uk fo re C A S H foreCASH Learn about foreCASH gt Last updated Sept 2015 Page 1 of 182 E support foreCASH co uk foreCAS H Table of Contents Ai Mioto eaaa EAS E E AT 5 1 1 Before you Start eee eseeseeeeeeeees 5 1 2 Screen messages raised by foreCASH 6 1 3 Menu protocol 0 0 0 eee eeeeeeeseeeneeeeeeeees 16 iA Cleaned Bank POSION e t caves a eaa vecaedsteseestsss tvs feeb ves sna A TESNE ETEN ASL le Seas E ea aa van EEE te eee eae 6 125 Consolidated Bank Account ViOW issicsscesciscdscciausccsecsevedccveacs cisaduxedsueadovbsdscnaiueaaith Gosadaadsauadeacdacdsleacassstdsisaanpevovesvistuaiasteeiastbaneenscce 6 1 6 Backing up your data ee 7 First time use and security keys 8 Zed E E EE AAE A E T T A T T E T EA TTT 9 2 2 Company and version Select oriire a eiea ATi a dAran ASAR i GEENE Eara iada NFEE EKE a NEIEN E NEF 9 2 3 Network shared drive c cecceeseeeeeeeeeeeeees 10 2 3 1 Setting the shared drive location first USC cecceceeseeeeeseeeseeeeecaeeeeeeaeeeaeeseeeaeeeaecaeesaeseaesaeeeaeseaesaeseaeseesaeseaeeneseaeeneeeae 10 2 3 2 Setting the shared drive to correspond with your Colleagues settings cecceeeeseeeeeeeeeeeeeeeeeeeeeeeaeeeeeseneraeseneteeeeaeeeaeeaee 12 2 3 3 Copying forecast companies and versions from local to Shared data cccccccccceeeeceseeeeeeeeseeeeee
97. E support foreCASH co uk fore CAS H The Adjust Opening option allows you to make manual adjustments to the base foreCASH opening position A foreCASH gt gt gt Company 53 Origin Wine v 2 June 2010 from visit St 01 06 2010 Lgth 10 9 Fie Edit Banksetup Drivers key accounts Openingdete Forecastdata Calculate cash How Reports F O80 t 4218 8 m2 310 10 Trade debtors std 1 491 926 Provisions 0 Trade debtors ABL 0 Accrued def income 0 Other income debtors def 0 Cash 0 Current Assets 1 491 916 Overdraft Asset Based Lending Finance Leases Creditors COS 3 101 192 Creditors prepayments Op cos 1 699 Creditors Capex 0 Salary creditors inc taxes 11 664 157 768 127 437 Current Liabilities Net Current Assets Total assets less CL LT creditors Loans Net Assets Share capital Other Reserves PL Reserves Total Cap Reserves Check sum Use the Save button on the bottom right of the screen to keep the changes Page 78 of 182 E support foreCASH co uk fore CAS H 3 7 Entering sales and stock forecasts If you are operating foreCASH in item product Mode please see section 3 7 1 non project items see 3 7 1 2 for project items 3 7 1 3 if you are operating in Supplier lt gt Customer split sales mode Supp lt gt Cust please refer to section 3 7 2 3 7 1 Item Product mode including projects If the Item Product mode was selec
98. E typical rate 25 NI EmployEEs typical rate 10 NI EmployERs typical rate 10 m Pension Pension employEEs deductions 0 of gross base amount Pension employERs cost 0 of gross base amount r Commission hie ot Gross commission 0 Sales C Margin Paid in arrears One month after quarter end 7 E lt Back Cancel Save As well as entering the gross payroll costs the approximate percentage rates of National Insurance NI both employers ER and employees EE are needed If pension payments are made the percentage rate should also be noted on this screen Page 113 of 182 E support foreCASH co uk fo re C A S H a 3 10 2 Other regular recurring overheads Other recurring overheads such as rent rates and car leases can be set up These expenses should be attributed to a specific supplier If you want to summarise a number of smaller expenses you could create a new supplier such as Sundry IT to which the relevant cost amounts can be attached In order to synchronise invoices already in your supplier ledger with recurring costs it is important to note i how many month s credit your supplier gives you ii whether invoices are received in advance or arrears of the period they relate to In the example below Forecast start date of Jan 08 Hertz provide one month of credit Hertz invoice neither in advance or arrears but in t
99. H 3 15 5 2 Bank summary breakdowns Other key lines on the daily cash flow report also offer more information when click on Daily move on cash splits daily movement by current bank account Right click on a day for further detail foreCASH gt gt gt Company 76 ResellerPack v 3 Electrical wholesaler local data St01 01 2008 Lgth 15 Std File Edit Banksetup Drivers key accounts Opening data Forecastdata Calculate cashflow View Forecast Reports Flex Help UEA wl Je 09 Jan 200 Wednesda 0 61 275 Bank Details r faks 14 873 14 873 76 148 Account Barclays curent _ Date 03 Jan 2008 7 Amount 61 275 25 000 25 000 Barclays current Petty Cash Net cash break down or balances and facility including the balance of any invoice discounting ABL accounts that are drawn down into a particular current account Net Cash overdrafts 5 25 000 25 000 Overdraft facilities l 25 000 25 000 25 000 25 000 25 000 25 000 25 000 Undrawn ABL capped 0 41 997 41 997 41 997 134 713 113 157 110 647 _ Headroom Short fall 41 997 41 997 41 997 111 717 133 273 135 783 ABL borrowed 1 319 1 319 1 319 0 51 57 Barclays current 25 000 25 000 86 275 35 127 35 127 35 127 211 303 211 303 211 303 Petty Cash 127 127 127 127 127 127 127 127 127 Euro account 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000 10 000
100. Product Project Mode Project Mode see Item Product Project Mode Purchase ledger see Supplier ledger Q E Quarter end the end of a specific calendar quarter e g March Q E being the 31 March Raw Materials items held in stock that will be processed and converted into Finished Goods Retail Collection Mix a pattern defined by the user which sets out the proportion of sales from an outlet that are paid for by cash credit card or cheque The time for each form of payment is also set by the user Stage Payments a user defined business term setting out he split of a payment across up to four stages Strict terms a form of business terms whereby invoices must be settled a precise number of days after the invoice date This typically results in numerous payments being made across a month rather than settling all invoices at the end of a month Supp lt gt Cust mode A mode of operation in foreCASH which models a single level of stock Sales are forecast by customer split and the supplier they are sourced from Supplier ledger a list of balances showing the amounts you owe to your suppliers Page 179 of 182 E support foreCASH co uk foreCAS H Terminal Server a computer system set up where users run programs on a shared central server If accessed via a PC the PC is merely acting as a screen and keyboard without doing any actual processing Terms of business the terms governing when i
101. Recent management accounts or profit and loss report to help you pick up the current level of costs e Recent P32 payroll return or your most recent payroll journal in order to check the salary levels and the average rate of PAYE and NI e lf you are not making the sales and stock estimates your self some notes from your sales or purchasing managers on likely sales and stock product levels and mix e Recent balance sheet to pick up the level of fixed assets and reserves It is also worth spending time to consider which accounts make up your key customers customer groups that you will wish to focus upon before you start building the forecast Page 5 of 182 E support foreCASH co uk fore CAS H a 1 2 Screen messages raised by foreCASH At various times you may see messages appear on the screen There are three types of messages indicated by the symbol in a speech bubble 2 Question foreCASH wishes you to confirm an action or take a choice i Information foreCASH is flagging a point to confirm an action has taken place or wishes to flag that you may need to perform further work before the forecast is complete _ Waring unexpected processing please contact support 1 3 Menu protocol Throughout this guide the following protocol is used to represent menu routes from the main menu bar There will be up to three elements in the route gt Main menu option gt Sub menu option gt Sub sub menu option
102. Sunday Monday Tuesday Wednesday Thursday Receipts Receipt from ABL 0 0 0 0 200 0 Customers top 5 2 650 025 Customers other 85 007 Other receipts Receipts Total 200 2 735 032 Payments COS top 5 1 204 109 COS others 845 662 Direct Costs 5 000 Salaries Property 9 200 Other Overheads 12 000 Other Taxes Interest Capex Payments Total 0 0 0 2 075 971 0 Exchange gain loss ied Daily move on cash 0 0 0 0 2 075 771 2 735 032 Net position 130 130 130 130 130 130 130 130 1 945 641 789 391 Net bank facilities D 0 0 0 0 a Undrawn ABL 0 D D 1 161 Headroom Shott fall 130 130 130 130 130 130 130 130 1 945 640 789 552 If your forecast includes a lot of category lines you can condense the receipts and or payments sections by clicking on the heading or total in the first column click again on the condensed total prefixed lt gt to expand Monday Tuesday Receipts Drawn down from ABL 0 0 Customers top 5 Customers other 23 Other receipts ICO or Directors Loan 23 0 92 879 11 684 Receipts Total lt gt Payments Total Transfer Exchange g l Daily move on cash Net Cash overdrafts 92 856 11 684 428 171 439 855 Overdraft facilities 350 000 350 000 Undrawn ABL capped 43 196 14 386 Headroom Short fall ABL borrowed 501 899 383 888 Page 126 of 182 E support foreCASH co uk fore CAS H 3 15 5 Reviewing your B
103. T EE unresolved defot M Raro managed deficit Page 1of4 The bank facilities available on any given day are the point where the forecast moves from red into green If the daily position remains in deficit after any management actions the facility is marked by the top of the striped red lines If the daily position is in surplus before any management actions the facility is marked by the lowest green stripe Page 155 of 182 E support foreCASH co uk fore CA S H 7 11 Strain surplus relative This report shows the level of any strain surplus both before and after any cash management actions that have been applied as part of the forecasting process Cash surplus strain relative to facilities EERE Eo foreC ASH for XaYbZc Limited Dataload date 3408 2007 Peak values by month Day weighted values by month MAX ru March April january February March April Maximum base strain 300 000 250 000 140 000 2 500 000 300 000 250 000 140 000 in month o o o jes flex 000 o o o 175 000 o o o 175 000 o o o greed o 300000 150 000 o ul agree o 300000 150000 2 500 000 o 100000 175 000 ul other o o 100000 175 000 2 000 000 o o o o o o o 100 000 o o o n 160 000 o o o 10 000 300000 200000 175 000 Used support 2 700 000 300 000 200000 175 000 o o o o Unresolved 700 000 o o o Net strain surplus pre post beneficial cash management actions yl af gb bb a a
104. Te Exit When copying a single selected version you are given the option for this to become the first version of a new forecast or to add the forecast as a version in an existing company Page 14 of 182 E support foreCASH co uk fo re CA S H 2 3 4 Access restrictions to shared data A single user may use a forecast version at one time Users book out and work on a forecast Until a user closes the forecast version it will not be available to other users foreCASH Select Company Version Add company Import comp i ResellerPack Delete now Z Demodata 88 ReselePack2 COO Co 37 JH Live py shared gt 111 Z_Demodata lt Copy local Dti 1 Demo_standard l Standard 19701 2011 2 Demo_manufacturing Manuf 19 01 2011 3 Project Comp l Standard 19 01 2011 4 Electrical Wholesale 2 l Standard 1920172011 Blue Retail Jan Standard 19 01 2011 Selected database ref shared wkforecash5_5 mdb Companies licenced 99 Refresh Booked out versions are copied to a users local hard drive and changes made At the end of their session the amended file is copied back to the shared drive If the connection to the shared drive is lost during a session the logged out file is returned the next time the connection is restored and the foreCASH Select Company screen is visited Page 15 of 182 E support foreCASH co uk fore CAS H 2 3 5 Access password Terminal server installations If you
105. Terms tab of the Drivers Ledgers screen to vary terms both historic and for ranked items ongoing default bank accounts currency settlement method and activity pattern see section 13 Ranked items can be classed as attributing VAT on an individual basis There is also the option to mark ranked suppliers are subject to Import Duty see section Error Reference ource not found Drivers Ledgers Supplier Terms Suppliers Key COS Customer Terms Customers Key Add new delete Top 9 Suppliers COS JVC 30d 3 5 15 25___ StagePayB 4 Cash Barclays curren No Panasonic Manual entry 30d 1 last 6C Cash 0 U shape Euro Euro account No Sony Corp 60d 2 15 30 2 days 30days net fomightly shape Sterling Barclays curren No Digital Radio UK 30d 3 5 15 25_ ays shape Sterling Barclays curren No Pioneer 30d 3 5 15 25_ 1 net month end Sterling Barclays curren No Tele Accessories Ltd 30d 1 last 2 1 days 60days net fornightly Sterling Barclays curren No 90d 1 last 120 90 90 days net month end Manual entry 30d 30 30 days strict 45d 30 45 days strict 60d 30 60 days strict 3 A4 Paper Supplies Co ABC Warehouse Automatic Barclays Bank Intl British Gas BT ple BUSPOSO01 Business Post CHANGMOO1 Chang Mai Carbon Co COLLINOO2 Collins Diaries Ltd CWRAPOO1 Colour Wrap ple DEFDEFOO1 DEF Ltd EULEROO2 Euler TI FILOFAOO1 Filofax Design Incorp GBCOUNCILOO G Borough Council HDTV002 High Definition TY Corp HFRTZNM1 Hert Gr
106. acilities combined Details on individual accounts are obtained by drilling down into the forecast Page 6 of 182 E support foreCASH co uk fore CAS H 1 6 Backing up your data To avoid the loss of data should your computer be lost or damaged we recommend that you make a copies of your user data at regular intervals and store it in a safe location The foreCASH settings you choose and other information unique to a company forecast is stored in a database file One database file exists for each version of a company that you create To back up all the companies and versions on your system you should make a copy of the all the files in location Windows 2000 or Windows XP C Documents and Settings All Users Application Data Wellkeen foreC ASH Database Vista or Windows 7 C ProgramData WellKeen foreCASH Database We recommend you use Windows Explorer to find these files These files are classed as system files and depending upon your PC set up may not be visible if you navigate directly to the folders noted above Alternatively you can back up a single forecast using the in built feature from the File gt Backup data for this forecast version menu option foreCASH gt gt gt Company 2 zDemoCompany v 6 Blue Retail Ltd A1 Edit Bank setup Drivers key accounts Opening data Forecast dat eM Change start date Change length of forecast Change add company Change add version Check for updates Properties and key
107. acility details i Account Description GBP Invoice Discount HSBC Asset based lending cleared draw down account m ABL details Fi At rate of oo Draw down rule fExactMin xl Variable rate Points above Percentage of Pool sales that are factored oo a Default advance percentage 85 000 Allow negative borrowing bank owes you E Didi as Processing delay days Invoices 2 Monthly C Quarterly o Default borrowing cap limit j 1 000 000 C Annual oo Draw into account GBP Current HSBC Facility details amp r Charges paid from ABL account 01 Oct 09 85 1 000 000 Clickhere J Monthly charges Per draw 800 000 Click here se alse as J cece 15 Feb 10 90 1 250 000 Click here O Commission charges on invoices O Commission charges applied Daily i x When exporting statment show sales by cust J Add the period and extent of borrowing facilities for this account using the Add s Details button Add Details 2 Save Close Page 167 of 182 E support foreCASH co uk fo re C A S H 10 5 1 2 Collections impact foreCASH assumes e That all collections for invoices submitted to your ABL finance company are received into a specific ABL collection account e That amounts received into the ABL collection account have to clear overnight before they affect your balance available for draw down e The impact on the amount available is
108. age 7 8 07 Nov 10 D 14 Dec10f gt By Month Period B F _ Mar 2010 Apr 2010 May 2010 Jun 2010 Jul 2010 Aug 2010 Sep 2010 Oct 2010 Nov 2010 Dec 2010 Jan 2011 _ Fet work done 0 0 0 0 13 966 1 201 2 446 1 935 2 000 452 0 0 Invoiced 0 0 0 0 2 000 0 0 0 0 12 925 0 0 Accr def inc 0 0 0 0 11 966 13 167 15 613 17 548 19 548 7 075 7 075 7 075 Materials B F Mar 2010 _ Apr 2010 May 2010 Jun 2010 Jul 2010 Aug 2010 Sep 2010 Oct 2010 Nov 2010 Dec 2010 Jan 2011 Fet Booked out 50 0 0 0 8 100 0 0 0 0 0 0 0 cos 0 0 0 0 7 636 414 100 0 0 0 0 0 WIP materials amp sub 50 50 50 50 514 100 0 0 0 0 0 0 Labour B F Mar 2010 _Apr 2010 __May 2010 _Jun 2010 Jul 2010 Aug 2010 Sep 2010 Oct 2010 Nov 2010 Dec 2010 _Jan 2011 Fet Utilised 0 0 0 0 3 200 0 0 0 0 0 0 0 cos 0 0 0 0 3 200 0 0 0 0 0 0 0 WIP labour 0 0 a 0 a 0 0 0 0 0 0 0 Export Proj This screen shows a monthly summary of when work is preformed and invoiced to give the resulting accrued or deferred income The booking out of materials and labour their utilisation and any resulting WIP is also shown The project invoicing or complete project details can be exported to Excel from this screen Use the return to item list to go back to the full summary of items project revenue and costs Page 88 of 182 E support foreCASH co uk fore CAS H 3 7 1 4 Construction Industry Scheme CIS and PAYE If your suppliers are covered by the Construction Industry Sc
109. ages Trade Marks ceeeeeeeeeeeeee a Glossary and abbreviations repornirea eaa edanen Nea VEEE ECE Ede Aeka Eaa TAEAE ANEA meanenecstctcedaitd Page 4 of 182 E support foreCASH co uk fo re C AS H a foreCASH User Guide 1 Introduction foreCASH is a cash forecasting planning and delivery tool developed by Well Keen Limited We would recommend that you take the time to review the whole user guide before starting to use foreCASH but as we recognise this may not always be possible we have provided a quick start guide in section 3 The foreCASH program itself contains context sensitive help which will provide guidance about the particular form that is currently on view If you need additional support please contact your foreCASH reseller or the developer of foreCASH Well Keen Limited on T 01582 766 066 E support foreCASH co uk 1 1 Before you start Before you start working with foreCASH it is worth gathering information you may need to help you build your forecast You will typically need e Sales debtors ledger as at the planned start date of your forecast Showing the amount you are owed by your customers split by the age of the invoice Not required if all customers pay by cash e Purchases creditors ledger detailing the amounts you owe your suppliers split by the age of the invoice e Bank reconciliations or statements for each of your bank accounts so that the opening bank position can be set e
110. ales mode of forecast Step 2 Set up bank accounts and bank loans Step 3 Set up default ledger rules and other main drivers rules Step 4 Import customer and supplier ledgers Step 5 Key accounts Aggregate accounts Set ranked items Non standard terms Step 6 Opening balances Bank stock payroll accruals other debtors creditors fixed assets and fin leases Share capital Step 7 Sales and stock forecast Step 8 Direct costs Enter the start date in the format mm yy e g 03 07 for March 2007 foreCASH can be run in Item Product Project mode or sales can be entered based on Supplier amp Customer split The minimum forecast length is 4 months into the future the maximum forecast length is 5 financial years including current year Enter your bank accounts together with the extent of any overdraft facilities the account currency etc Enter details of loan schedules Drivers or rules determine what calculations to apply in your forecast They cover standard terms of business for customers suppliers VAT periods and other aspect of the factors impacting your cash flow Import a full list of your customers and suppliers from an Excel or CSV format file Aggregate accounts optional Select the most important key accounts groups for extra prominence and versatility of options These are known as ranked items If your ranked customers and suppliers have non standard terms of t
111. ally have Invoice dates before the start date of your forecast GIT is added to you opening stock and an accrual for the pending invoice is made Gross Margin the amount by which the sales price of an item exceeds the purchase price or manufacturing cost Gross Margin Percentage Rate the Gross Margin as a percentage of the sales price of an item GRNI Goods Received but Not Invoiced items that are in your stock but for which you have not yet received the supplier s invoice An opening accrual is made for the net pre VAT value of the invoice Import Duty a non refundable levy on items imported into the UK from outside the EEC Charge is included by foreCASH in the value of stock and COS Import VAT VAT levied directly by HMRC at the time of import of goods charge not raised by supplier and does not appear on supplier invoice Payable either to shipping agent or monthly to HMRC VAT paid can be deducted from next full VAT return Page 178 of 182 E support foreCASH co uk foreCAS H ltem Product Project Mode A mode of operation in foreCASH which models three levels of stock raw materials Work In Progress and Finished Goods and where sales are forecast principally on items products Mode also includes options for modelling projects Invoice discounting a form of Asset Based Lending whereby a bank or lender advances a specified percentage of the invoice value you raise to your customers in return for an
112. anagement and reconciliation of the ABL account Please note e The amount drawn down from ABL accounts into your master current account is shown within the cash flows e The net borrowings on ABL are not shown in the daily cash flow forecast or the weekly cash flow forecast or format Il monthly cash flow instead only the remaining amount available to be drawn down is shown in order to indicate where additional funds are available to assist in any shortfall on your non ABL accounts The amount shown as available for draw down is the capped amount By contrast in the balance sheet and funds flow monthly reports the full extent of the ABL borrowing level is recorded 10 3 ABL detail screen The ABL detail screen contains two grids The upper grid shows the same summary seen on the main cash screen The lower grid shows a detailed breakdown of either i the sales or ii the collections related to the ABL account Which is shown depends upon which row is highlighted selected in the upper grid ABL collections for individual debtors can be manipulated in the same way as for balances collected into standard bank accounts foreCASH gt gt gt Company 115 ResellerPack Invoice Discount was 76 2 v 2 ABL CN testing recald File Edit Banksetup Drivers key accounts Openingdata Forecastdata Calculate cash How Reports Flex LT OB 2 4 h E Sr EB 320 Asset based lending Bank Holiday 02Jan 2008
113. ase Forecast There are a number of ways to review your Base Forecast i Daily cash flow in the main foreCASH calculation screen ii Weekly cash flow option from the main foreCASH daily cash flow forecast screen iii Monthly overview from the main foreCASH Daily cash flow forecast screen or by using the P amp L Balance Sheet and Funds Flow report iv Daily graphical summary reports see section 7 v In a spreadsheet having used the Export function from the Reports menu While foreCASH will highlight where cash strain is expected it is worth remembering that customers and suppliers are not totally predictable neither are sales or stock levels and so the drivers and budgets you have assumed may not lead to your cash position materialising as expected It is advisable to apply a tolerance level when reviewing your forecast in order that periods of potential risk are not missed It is also important to reconcile your cash forecast to the actual cash position on an ongoing basis see section 5 3 P amp L Balance Sheet and Funds Flow Profit and Loss Balance Sheet Cash flow P and L Financial Year Funds Flow 3 2008 4 2008 5 2008 6 2008 7 2008 8 2008 9 2008 10 2008 11 2008 12 2008 1 2009 2 2003 3 20f Operating Profit 68 390 72 422 77 422 80 561 74 822 79 822 91 822 89 822 94 822 115 332 110 036 115 036 130 50 Dep n 6 798 6
114. ast changes may be made to the sales and stock levels while all rescheduled items flexing and reconciliation will be cleared You can set the length of your forecast into the future Minimum length 4 months into the future maximum length 5 financial years including current financial year with actual data where applicable Forecast date range and mode Mode and Time Span Help on choosing mode Current start month year of forecast estimated data mm yy fi 1 13 New start month year of forecast estimated data mmy fi2 13 Future estimated months in forecast 5 Fin Years This is usually the month which includes today s date m Overall forecast Span based on proposed new start month of forecast estimated data Actual past results in current financial year optional 01 Apr 2013 30 Nov 2013 Forecast into future 01 Dec 2013 31 Mar 2018 5 Fin Years Default mode Item product mode including project based items Sales specified by customer mix and supplier of goods Sales are specified based on product items Customer mix can then also Single level of stock Includes specialist wholesaler be specified Each item may be a service or product made up of distributor options elements from one or more suppliers Sales can be specified as amounts or units x price per unit Items can be set to have no stock erable Revenue recognition phase invoices in PAL 7 finished goods stock and WIP Raw materials also modelled
115. ata gt Fixed Assets Fixed Assets Fixed assets Description Cost Cum Dep n p Desk and furniture 10 000 2 278 click here New IT system Capex 05 11 2007 Add opening fixed asset z click here Description Desk and furniture Original Cost 10 000 Cumulative depreciation 2 278 Net book value NBV 7 722 Depreciation option Straight line over 3 pears Straight line over 20 years Reducing balance 5 per annum Reducing balance 10 per annum Reducing balance 20 per annum Reducing balance 25 per annum Add Details Depreciation charges will be calculated based on the opening fixed assets Asset disposals are not specifically modelled within version 1 0 11 of foreCASH If required cash receipts from disposals pending can be entered into the forecast using Other Debtors Forecast capital expenditure is generally rolled into fixed assets when a new forecast is started Page 73 of 182 E support foreCASH co uk fo re C A S H 3 6 10 Finance leases If you have previously purchased assets using a finance lease you may define the terms of the agreement in order to schedule capital repayments and interest payments Add Edit Lease Step 1 settings Ej Type Car to Description Transit van Total amount excluding VAT 25 000 VAT 3 750 VAT not reclaimable at inception Even spread of YAT iz Deposit in advance 3 000 Amount finan
116. ate to the required drive and folder 75 from blank 2 con WW 78 from Blank new template 5 a Delete now 79 from blank 36 qqaqNew 87 feb09 inetpub E InstallShield 2011 Projects InstallShield Express Projects Intel aisty E PerfLogs Program Files E shated_forecash Local gt shared If you are the first foreCASH user in your operation to specify a shared drive the screen will note that this will be a New shared data location Page 11 of 182 E support foreCASH co uk fore CAS H 2 3 2 Setting the shared drive to correspond with your colleagues settings If you wish navigate to a folder which a colleague has previously specified as their shared drive location it is noted on the screen when you have reached the correct location by marking the Existing foreCASH data detected text ioi xi z MYISTA PC Vist J obs_database v4 Ga v41_v42 E v42 B v43 B v44 E v50_2 Shared data Path Path z 5 data will be placed in a folder fC_sharedData Set C New shared data location f Existing foreCASH data detected Cancel Page 12 of 182 E support foreCASH co uk fo re CA S H 2 3 3 Copying forecast companies and versions from local to shared data When you have selected a local company version they are highlighted in orange A selected shared company version will be highlighted green The
117. be entered under three categories Marketing Royalty or Other If you do not expect to receive the debtor during the forecast period enter the amount under Long term other debtors this will not affect your cash flow but will be reflected in your balance sheet Other debtors Short term other debtors Receipt details Marketing f Edit Details Royalty Edit Details Other Edit Details Opening provision for bad debt Provision 50 000 Long term other debtors Not received during this cash forecast Only impacts Long term 7 500 Balance Sheet Close An opening provision for bad debt can also be noted on this screen This figure will not impact the cash flow forecast but will be reflected in the balance sheet If a figure in your customer sales ledger is not expected to be collected you should mark the account with collection Business Terms of Never___exclude write off Page 71 of 182 E support foreCASH co uk fore CAS H a 3 6 8 Other creditors and accruals Opening creditors and accruals can be created in a number of ways e Accruals for costs of sales items can be added using the GIT Goods in Transit and GRNI Goods Received Not Invoiced elements of the opening stock screen e Taxation and salary accruals have a specific form e Accruals related to overheads are created automatically as part of their setup whether they are regular recurring overheads simple irregular or complex
118. box Banking Facilities ABL collections Lender advances against uncleared items E Page 30 of 182 E support foreCASH co uk fo re C A S H j 3 2 4 3 Multiple invoice discounting accounts foreCASH can model multiple invoice discounting facilities for example some companies have a facility for Sterling invoices and a separate facility for US dollar invoices Additional invoice discounting facilities can be set up via the Other ABL factoring invoice disc Tab of the bank set up menu Bank Details set account name and facility information B 7 Master bank accounts current and ABL Other bank accounts Other ABL factoring invoice disc Sort code Account no Description Type Currency Further details Delete Add Banking Facility r Banking deias Sort code lf Account no a Description fo Type o Save omeri 3 Close Save Close If you operate multiple invoice discounting facilities which share a combined overall borrowing cap preference to draw down amounts is calculated as follows Calculated by day Reconciled draw down amounts applied first Manually specified draw down amounts have priority over general rules such as draw min e Master ABL account has priority over other accounts which the follow in the order listed Page 31 of 182 E support foreCASH co uk fore CAS H 3 2 5 Loan facilities Loan facilities are used where there is a
119. call up these options right click on the sales impact grid Sales cannot be moved outside of the month from which they originate To change sales across months use the Sales Flexing see section 4 2 1 option to increase or reduce ABL sales in a given month Asset based lending Bank Holiday 02Jan 2008 03 Jan 2008 04Jan 2008 _ Tuesday Wednesday Thursday Friday ABL b f uncapped 1 107 106 1 107 106 0 0 Sales impact 10486 25 424 19151 Collections impact 150 000 1 634 1 215 Rate change impact Available today uncapped 1 107 106 1 267 592 27 057 20 366 Drawn down 0 1 267 592 27 057 20 3 Draw tule All All C F in available uncapped 1 107 106 0 0 Interest and charges 0 0 0 Fiatist peach DER Amount borrowed ABL 0 267 592 283 759 296 Cap 1 000 000 1 000 000 1 000 000 1 000 Date 02 Jan 2008 Ledger balance Bank 1 302 478 314 814 333 834 348 Borrowed 0 85 00 85 00 85 1 ABL sales Current 26 795 74 Sales Impact Base sales net VAT 1 day delay a 26 ar _ on 107 13 Revised 25 000 00 Sales phasing Sales flexing Reallocate Change Reconciled sales rr CN General Undo last change m Change Sales total net 0 a Pushback Tomorrow Gross sales inc YAT 0 29 _ Show Detail 14 5 Proof of delivery time delays ENE 10 4 C 2days CN cash Disc oOo 0 O C Last day of month Adjusted sales 0 29 910 22 530 4 gt gt gt Processed 0 0 29 910 22 530 Parasara C 1day 2days
120. ced 25 750 Start month year MMAYYYY 1 2009 Payment frequency Monthly Quarterly Number of further payments 25 Payment day ast Day X Last payment 4 2015 Set up method Recurring payment amount ine VAT C Interest Rate Recurring amount 1 450 Annual Rate per quarter Rate percentage 11 790 2 925 Depreciation option if new lease aight line er ved Page 74 of 182 foreCASH E support foreCASH co uk Finance leases You can check the suitability of the options you have chosen by reviewing the summary schedule of charges and payments Add Edit Lease Step 1 settings Type Bal b f Opening 25 000 Feb 2009 25 750 Mar 2009 25 993 Apr 2009 26 235 May 2009 25 028 Jun 2009 25 263 Jul 2009 25 499 Aug 2009 24 285 Sep 2009 24 513 Oct 2009 24 742 Nov 2009 23 521 Dec 2009 23 742 Jan 2010 23 964 Feb 2010 22 735 Mar 2010 22 950 Apr 2010 23 164 May 2010 21 928 Jun 2010 22 134 Jul 2010 22 341 3 750 0 ooo oo oo So Solo e Solo ool o o VAT Int charge Repayment 0 222 222 214 214 214 207 207 207 3 000 0 0 722 0 0 743 0 0 764 0 0 785 0 0 808 0 0 1830 Int paid 0 0 0 728 0 0 707 0 0 686 0 0 665 0 0 642 0 0 620 Step 2 summary Bal c f 25 750 25 993 26 235 25 028 25 263 25 499 24 285 24 513 24 742 23 5
121. ceeeeeeseeseaeeseaeeseaeesnaeeeaaes 13 2 3 4 ACCESS restrictions to shared Gata erriren daeoni aN E EA de tscdva ven Si au EAE LEE NEE Anian 15 2 3 5 Access password Terminal server installations cccccccccceseeeeeeeeeeeeeseeceaeeceaeeseeeseaceseaeeseaeeseaeeseaeesaeeenaeeseaeeseaeeeneeeeaees 16 Creating your first forecast QUICK Start ee ceceeeeeeeeceeeeeeeeeeeeeseeseeeseeeaeeaeesaeeaesaeesaeeeaeeseeeaeeaeesaeesaeseeeaeseaesaeeeaeeneesaeeeaeseeseeeseaeees 17 3 1 Setting the start date length and mode of your fOreCast ee eeceeeeecceeeeeeeeeeeeeeeeeeeeeeaetaeesaeeeaeseesaeseaeseesaeeneesaeeeaeeeeeeeneeatees 19 3 1 1 POE GAS eTo l A ses ca cence vacates scsnssaccecAhctevhcatannesnussivecuestedtucsagsessavesdaas Vosscaseanaceesacebuashsatisadensisndeyensdugatsanesseesaatensuase eeee 20 3 1 1 1 Item Service or Product project sales mode Item Pro gt Cust cccceeccescceseeeeeeeeeeeeeeeeceaeecaeeeeaeesseeeeaeeseeeeesaeeseaeeneaes 20 3 1 1 2 Sales by supplier and customer split mode SUPP lt gt Cust ecceececeseeeeeeeeeeeceeeeeeeeeeaeeeeeeeeaeeseaesceaeesaeeseaeeseaeeseaeeseaeessaes 21 3 1 2 Revenue Recognition phasing invoices in the P amp L oo eee eeeeseeeeeeeeeeeeeeeeeeeeeeeaeeeeeseeeeesaeesaeeeeeseeeaeeeeeseeeeseaeseseaeeneeeaees 3 2 Set up bank accounts and loan facilities 0 3 2 1 Current accounts and overdrafts 3 2 2 Current accounts overdrafts Auto sweep
122. d Lending ABL or you operate on strict rather than net month end payment terms then it is worth considering the working trading days for your business Drivers and rules Non Working Days Working trading days of the week Purchases Sales Bespoke weightings by day Monday Friday e Monday Saturday Monday Monday Sunday Tuesday Tuesday Sunday Wednesday Monday Friday half day Wed Thursday Monday Friday half day Fri Friday Bespoke weightings Saturday Bespoke weightings2 Sunday You can set the working trading days to weight sales and purchasing activity across the days of the week This is most relevant to your cash flow if you operate significant levels of business on cash or strict terms as opposed to offering receiving net month end settlement terms You can opt to apply bespoke weightings set the relative activity levels by day if Friday is an average day give it a score of 1 00 if Saturday is very busy say three times busier than Friday give it a score of 3 00 As well as offering some common patterns you have the option to set up some bespoke weightings For bespoke weightings it is the relative size of figures that are used to apportion sales or purchases You could enter the typical percentage spread across a week Alternatively a retailer might use a score of 1 0 for a normal day O for a day when the business is closed and say 3 0 for a Saturday if it is three times as busy as a
123. down amount will also lock in and reconcile sales and collections 10 5 1 Calculating how much is available for draw down The amount available for draw down from your ABL account is calculated in two parts the sales impact and the collections impact Page 166 of 182 E support foreCASH co uk fo re C A S H 10 5 1 1 Sales impact Amounts available for draw down driven by sales will be based on e Daily sales activity is determined by o the total sales to ABL customers whether ranked or the share of pool sales that are factored in the month o the monthly sales phasing pattern o the specific day of the week and the working trading days setting o any bank holidays or shut down days in a given month Sales occurring on Saturdays or Sundays are deemed to be submitted to the ABL finance company on the next banking day usually the following Monday e The advance percentage the proportion of the gross sale your finance company will advance to you o A default advance percentage can be set up and apply to all dates o In addition you can opt to specify variable facility settings for the advance percentage and cap These variable settings will be applied to all dates following the facility start date up until the next specified date if any e The invoice availability delay how long it will take after the day of invoicing submission before your finance company makes the funds available Bank f
124. duct focus Customer analysis m Data entry preference You have a number of options when entering your sales stock and purchasing forecast information The option you choose will depend on whether your sales plan is more customer or product centric You may when estimating sales start from a position of which customers you will sell to Choose A Alternatively you may think primarily about which products you will be selling and the suppliers you source these products from Choose B If you need to be able to schedule purchases from suppliers on a daily basis or to import a schedule of purchases then choose C A by customer first then by supplier margin sales stock B by supplier first then by customer C by customer first then by supplier purchases stack and sales Summary Schedule Import a list of Schedule Import alist of Enter WIP to customer sales customer sales purchases on purchases schedule sales on daily basis option see daily basis option see recognition option note 1 option note 1 option ie note want to set my sales total by customer in detail first I ll then y y split the total across my suppliers want to set my sales based on the suppliers who provide the goods sell I ll then split the total across my customers want to have the option to schedule my purchases on a daily basis or to import a list of purchases I ll set my sales total based by customer and then split this
125. eCASH will calculate the daily spread based on the Co LOrE MONN monthly pattern chosen for this account gt gt Copy for all later mont The file for import requires a format Column 1 Customer Supplier reference 2 Date 3 Amount You have the option of also importing the due date in a manually specified column 4 20 Page 109 of 182 E support foreCASH co uk fo re C A S H 3 8 Direct costs The level of some costs is directly related to the level of activity in a business By setting up a Direct Cost foreCASH will automatically vary the forecast costs and payments in relation to either sales or purchases of stock Costs linked to sales can relate to sales of selected customers or in item mode selected categories or items Costs related to stock purchases can be linked to activity on selected suppliers If you wish a cost to appear in the direct costs section but the cost level is not closely tied to activity levels there is the option to Enter Amounts which allows you to set the expense amount for each month Direct Costs are attributed to an individual supplier If you wished to group several smaller direct costs together you could add a new supplier called for example Misc Packaging Edit Direct Cost M Direct cost Notes Type and dept Cariage In 7 General hd Description carnage costs Flat C Variable gt Trade Accounts Cash accounts STORE2 NEW STORE
126. each invoice Fixed order simple Invoice listing with Account invoice date and amount only m Number of fields and special fields to be included in import m Header footer and sheet z m New accounts found _ 5 25 Number of fields columns to be mapped in the file for import ming max30 Sheet rea o M ei coal A A eel m UI Key fields IV Invoice date JV Bank account ref IV Company ID code Credit limits IV Terms reference First li Set ledger terms to import due tl tain headers 5 LCL A sep Paley e JZ CompanyName JV Unaged credits or debits JV VAT code Vv piret Ineta PEAR Wes A 2 7 date I no spefic terms imported V Total balance J Payments on account flag of gt Po A excluded from import 1 3 5 V Due date Last line s contain footers totals 16 Remaining fields available H faa i Fas Number of footer total lines to be over here for i 10 Number of ageing categories 1 12 No ageing B excluded from import 1 Company ID 4 5 Bal S l 2b Supplier refere supplier name Invoice refere Invoice Date Due Date L Company ID Company Name PARENTOO B Parent Inv2ps123 01710 2013 31710 2013 Sains a SUBSIDOOT _ B_FellowSubsid Inv21g3124 1610 2013 15 11 2013 Due Date xyvzxvz001__ XvZ ple Inv0083125 31 10 2013 30 11 2013 28 779 26 779 Total DEFDEFOO1 DEF Ltd Inv2193126 15 11 2013 15 12 2013 12 000 12 000 Unaged Balances DEFDEFOO DEF Ltd Inv243127 30 11 2013
127. econciling opening reserves to actual balance sheet 3 7 Entering sales and stock forecasts c ccsceeseeeeeeeeeeeeees 3 7 1 Iterm Product mode including projects oo eeeeeeeeeseceeeeeeeeseeeseceeeeeesaeeaeeeeecaeesaeeseesaeeeaesaeesaeseaeeaeseaeeeesaeseestaeeeseaeeeeeeaees S7AG Product group Or item definito M wcissx ase ececasiesterveetercsses anadiriki arre PaE FE OEE aces nel 3 7 1 2 Sales and COS product group or items non Project items 22 2 0 ee cece ceeeeceee cence eeeeeeeeeeceaeeeeaeceaeeeeeeeeaeeeeeeeseaeeseaeensaes 81 37 11 39 Project items Sales and COS iis ei ssesiisis sent cieei dinner ie a a EES Las Ada E ER aN E Ea ii 84 3 7 1 4 Construction Industry Scheme CIS and PAYE eeceesceeceeseeeeeeeceeeeeecaeeeaesaeeaeeeaeeaeesaeeeaeseeeaeseaesaeesaesneeseeeaeseeeeeeeatens 89 3 7 1 5 Stock levels Product Finished goods WIP levels and raw materials ccccceceeeeeeeeeeeeeeeeeeeeeeeeseeeeaeeseeeeseaeeenaeessaes 90 3 7 1 5 1 Stock levels Raw material Purchase Order Commitments POC c cescceceseeeeeeeeeeneeeeeseeeeaeeeeetaeeeeeeaeeeaeeeeeeeeeeaeees 92 3 7 1 5 2 Stock feeds stok fans for se asirini dean Jesseeiiga este npoveacsdatiunteslbarntsatin EA N aE aai i eaii 97 STA Sales mix by CUSTOMET ennenen eura a a ee ra EEE Ee E A EE EEES ASE EEIE AAN E E E 98 3 7 2 Supplier lt gt Customer split sales mode Supp lt gt Cust 100 3 7 2 1 Sales by CUStOMED 0 0 eeeeeeeeeee
128. eeceeeeeeeeeeeeeeeeaeeeeeeaeeeaeeeeees 101 3 7 2 2 Daily schedule of Sales by CUStOMET eeeeeeteeereees 102 3 7 2 3 Sales by customer group revenue recognition WIP 103 3 7 2 4 Margin by Supplier sisane 104 3 7 2 5 Sales by supplier ee 105 3 7 2 6 Forecast stock levels by supplier 106 3 7 2 7 Importing Purchase Order Commitments POC 108 3 7 2 8 Importing customer sales or Supplier purchases eeeeceeeeeseeeeeceeeeneeseesaeeeaeeaeeeaecaeesaeseaeeeeesaeesaeseeeaeseeetaeseaeeeeesneeaeeaees 109 3 8 Direct COSIS arora E a a A A aa EEE E EEA ees E Aue 3 9 Cost centres and departments 3 9 1 Adding a cost centre department ar 3 9 1 1 Second and third levels departMent CateQOrieS eeceseeceeseceeeeeeeeseceeeeaeeeeeeaeeeaeceeesaeseaeeeeesaeesaeseesaeseeeseeseaeeeeeseneeaeeaees 112 3 9 2 Assigning a cost tO a COST CONTE eee eeceeeeeeeeeceaeteceeseeeaesaeeeaeeeeeseseaecseeeaeesaecaneeaesaesaeseaeteeesaeesaeseeesaeeeeeseeseaeseeeeaeeeaeeeees 112 3 10 Overheads payroll and taxes 113 3 10 1 Payroll Wages and salaries 113 3 10 2 Other regular recurring overheads 114 3 10 3 Irregular overheads eee 115 3 10 3 1 Simple irregular overheads 115 3 10 3 2 Complex irregular overheads ceeeeee 116 3 11 Capital Expenditure and New Finance Leases 1119 3 11 1 Capital Expenditure eee eeeeeeeeeeeeneeeeeenees 119 3 1
129. eeeeeeeeeeseatees 3 4 2 3 Excluding the header and footer from your import file ee ceeeeceeeeeeeeeeeeeeeeeeeeeeeeeseeeaeeeaeseeeeaeeeaesaeesaeeneesaeeeaeeeeseeeseaeees 3 4 2 4 Check the sense of supplier ledger imports 06 3 4 2 5 Automatic ranking of new accounts 3 4 3 Validate the filer riniacsan ernis 3 4 3 1 Mapping bank accounts terms and VAT codes 3 4 4 Ledger Import file structure format 06 3 4 4 1 Users of formal accounting packages 3 4 4 2 Users without a formal accounting package 3 5 Key customer and supplier accounts QrOUDS c cceeceeeteeeeteeeseeeneeeeaees 3 5 1 Pre existing supplier and customer accounts dummy ledger accounts 3 5 2 Aggregating ACCOUNES eeeeeceeseeereeeeeeeeeeeeaeeeeeeaeeeaeeeeesaeesaeenaeeeeseaeeeeeeaee 3 5 3 Setting Ranked Items 3 5 4 Non standard terms 3 5 5 Table of business terms 3 5 6 User defined business terms ceeeeceeeeeeeeeeeeeeeeeeeeeeeeeneeeaeeeneeaee 3 5 7 Terms for customers that pay by cash with order or by credit card 35 21 Past sales and existing Balances isiin a edie A a a a ea aaa aaa Eaa aE a a aaea aaa Aaa a Tiaare 3 5 7 2 New sales and Dalances ccccccccsecceecceseeeeeeeeeeeceeeeceaeescaeecaeeeaeesseaesaeeseaeeceaeeceaeeeaeessaeeeceeeceaeeseaeesaeesaeeseaeeseaeessaeeseatensaes 3 5 7 3 Adding New Customers by importing a list of cus
130. een foreC ASH It is advisable to activate the program password access when operating on a terminal server see section 2 3 5 16 Updates and maintenance releases foreCASH includes a Software Manager that manages updates and messages related to foreCASH You are prompted to run the Software Manager when you change the start date of your forecasts You may also initiate a manual check via the menu at File gt Check for Updates Page 176 of 182 E support foreCASH co uk fore CAS H 17 Warning messages At various times you may see messages appear on the screen There are three types of messages indicated by the symbol in a speech bubble Question foreCASH wishes you to confirm an action or take a choice i Information foreCASH is flagging a point to confirm an action has taken place or wishes to flag that you may need to perform further work before the forecast is complete Warning unexpected processing foreCASH thinks an error has occurred please contact support While every effort has been made to remove any bugs in the foreCASH software it is possible that faults exist in the code In the unlikely event that a fault occurs a warning message will be displayed on your screen You will be given the opportunity to print the screen at this time Printing and forwarding a copy of the screen at this time may be of assistance to Well Keen in resolving the fault and as such we would urge you to report any
131. end Net month end payment is split 50 50 across x days and y days net month end Page 55 of 182 E support foreCASH co uk fore CAS H j Terms reference code past Description Notes User defined S Net weekly Payment x days net of week S only UDTq x Days Net end of week UDT User defined T Net weekly Payment x days net of week UDTt x Days Net end of week User defined U Net fortnightly Payment x days net of UDTu x Days Net end of fortnight fortnight User defined V Net fortnightly Payment x days net of NC only UDTv x Days Net end of fortnight fortnight UDT 45d 1 last 75 45days 45days net Mid 45 days net Mid month A single payment at month the end of each month for the first fortnight of the previous months transactions and the second fortnight of the month before last Payment occurs 75 45 days after the sale purchase Strict terms 30d 30 30 days strict 30 days strict terms Aged monthly opening P Only balances still in terms will be split evenly over a month 60d 30 60 days strict 60 days strict terms Aged monthly opening P Only balances still in terms will be split evenly over a month 30d 30 30 days strict 30 days strict credit Potentially 30 payments N only one for every day of month 45d 30 45 days strict 45 days strict credit Potentially 30 payments N only one for every day of month 60d 30 60 days strict 60 days strict credit Potentially 30 payment
132. engths is available Page 133 of 182 E support foreCASH co uk fo re C A S H 4 1 3 Auto spread Spreading a transaction will divide it among the chosen number of days 2 5 The transaction will be divided equally over the following banking days 4 1 4 Re allocation calendar S UUI 53 Reallocate Account A4PAPE002 Total amount to be re allocated 1 101 178 Date 04 Sep 07 Outstanding to match base figure 1 101 178 Past 01 Sep 07 02 Sep 07 03 Sep 07 05 Sep 07 06 Sep 07 O7 Sep 07 Saturday Wednesday Thursday 08 Sep 07 13 Sep 07 15 Sep 07 20 Sep 07 22 Sep 07 27 Sep 07 23 Sep 07 30 Sep 07 The re allocation calendar allows you to reallocate an amount up to but not exceeding the base figure chosen for reallocation The remaining balance available for possible reallocation is noted as Outstanding to match base figure The amount to be reallocated can be assigned to any date within the four month forecast period where that customer or supplier has not been reconciled One month of the forecast is shown at a time You can move through the months using the arrow keys at the bottom of the screen Page 134 of 182 E support foreCASH co uk fore CAS H 4 1 5 Status of transactions The Show Detail view accessed by right clicking on an amount in the second level grid displays base forecast amounts and all modifications to the Base Forecast The status of the change will be logged and comment
133. ersion Existing companies Add company Import comp Delete now licenced 5 Existing versions Version Description Created Starts at Select Delete Add version 1 Version 1 0 01 11 2008 O iS 2 WDT 081229 29 12 2008 01 12 2008 gO Import version Delete now Database ref wkforecash1_2 mdb New companies can be opened when foreCASH is opened or by selecting gt File gt Change add company from the menu 11 2 Multiple versions You can make as many versions of a given company as you wish You may wish to create a new version each month before rolling forward the forecast start date Alternatively you may wish to have a number of forecast versions to reflect different high level scenarios When you create a new version it will create a copy of the currently selected version for that company as the starting point Page 169 of 182 E support foreCASH co uk fore CAS H 11 3 Exporting a forecast version You can export a version of a forecast using the back up feature see 1 6 Exported versions can be imported by other licensed foreCASH users 11 4 Importing companies or versions If you or another foreCASH user have previously backed up a forecast date file you can use this file to import a new version of an existing company or as a brand new company 12 Multi company aggregated consolidated forecasts 12 1 Enabling Multi company consolidations The Consolidator version of foreCASH allows forecasts
134. esaeeeaeseesaeeeaeseeesaeseaeseeeeaeeneesaeees 5 1 Status reports 5 2 Payment release control sheets RY 58 REGOMCIALON E seta vind os aeiadacivatecdsacs daveidoecsaccesscusSatdeshessas iustdeasi sSusaivaleadsadsan idiseige Givelieesateadadesuatterisaaazi paaavane dead 6 WiGW IFOFECAS TE T T cease chased E E vane sueatesuneuaiiveaysuvesietaan dade tessasaavaciaeags sited do Veateavtaves E 6 1 View forecast pre calculation of cash flow 141 6 2 View forecast post calculation of cash flow 7 ROPOMS niaren a aii 7 1 By bank account Daily cash forecast report 143 7 2 Weekly cash forecast report 144 7 3 Cash forecast report 145 7 4 Cash bank statement View ivcccssscseecsseveescesecesasics tayeevensauseusecevanceezcnessecuetiweuysuve Aae E Sa EE EDE aa SENEESE AE E iada 146 Page 3 of 182 E support foreCASH co uk foreCAS H 9 10 11 12 13 14 7 5 ABL Invoice discounting bank statement view eceecsecceseceeeeeceeseteceeseeeaecsaeeaecsaecaeesseesaesaeesaessaesaeeeaeeaeesaeeeaesaeseaeseetaeees 147 7 6 Monthly reports Profit and Loss Balance sheet and funds flow report 148 7 6 1 Monthly reports P amp L detail ee eeceeeseeseeeeeeeeaeeeeeeaeeeeeeneeeeeeaees 149 7 6 2 Monthly reports cash flow 150 7 6 3 Monthly reports VAT eseese 150 7 6 4 Monthly reports Bank Summary and details 151 7 6 5 Monthly reports
135. et Margin rate 11 00 11 00 11 00 54 l 59 Wages 60 61 62 63 64 Salary 19 800 19 800 65 Salaries 19 800 19 800 19 80 l 70 Property OH 6 767 6 767 F 71 Be 73 Telecoms gt gt 2 000 1 000 2 00 75 Other gt gt 40 000 40 000 50 00 77 irr Simple gt gt 2 000 2 000 3 00 l 79 Irr Complex gt gt z 14 80 Other Overheads gt gt 42 000 43 000 54 142 81 EBITDA Ss 22 384 41 167 35 708 l 91 Depreciation gt gt 1 597 1 875 2 15 92 EBIT Op profit 23 981 43 041 37 861 93 Interest nA nnr ian nanai tan nasi inaa nra Page 149 of 182 E support foreCASH co uk fore CAS H a 7 6 2 Monthly reports cash flow The monthly cash flow report is available in two formats The first format Cash flow FRS is in a format similar to financial reporting standards If you are using ABL the report shows the net balance with the Asset Based Lender The second format Cash flow Il is a monthly view of foreCASH s daily and weekly cash reports In this format the amounts drawn down from the ABL lender are shown and the net borrowings from the Asset Based Lender are not shown This report shows the net position on current bank accounts overdrafts and deposit accounts It excludes loan balances and only shows loan interest and capital repayments 7 6 3 Monthly reports VAT When you ex
136. ext gt Close Step 1 settings Step 2 summary Bal b f Int charge Repayment 3 333 0 0 3 333 0 0 3 333 Page 33 of 182 E support foreCASH co uk 3 2 5 2 Manual loans foreCASH If your loan schedule does not follow a simple regular pattern use the Manual loan option The manual option allows you to define the level of capital outstanding on a given date The Balance foreCASH will schedule the repayments and interest payments Those payments that fall within your forecast period will be included in the cash flow forecast generated NB Please ensure your schedule a 0 Nil facility on the date of the final capital repayment Loan manual schedule Step 1 settings Step 2 summary Type Manual loan Description Complex loan schedule Annual Rate percentage J 10 00 m Interest calculated Interest paid Monthly Paid as calculated C Quarterly March Paid with next capital repayment C Annual scene Paid with final capital repayment Loan CAPITAL level Advance 15Jun 09 100 000 0 100 000 Click here 30 Sep 09 0 40 000 60 000 Click here 30 Sep 10 0 30 000 30 000 Click here 30 Sep 11 0 30 000 0 Click here i Add details of the initial loan received and associated date Add Details ii Add further balances reflecting the remaining loan available after each repayment is made iii Enter a O facility o
137. f 7 000 000 00 29 Dec 07 Impact of cap g 98 606 30 Unreconciled 0 l m n p Total amount borrowed h Pre cap availabilty Imported ledger total of ABL accounts p 314 914 00 Expected amount available i e g h 1 000 000 00 Pre cap 1 098 606 30 Please enter any receipts recorded in your ledger but not recognised 0 cleared by your lender Enter invoices in your Ideger not submitted or Amount available per the lender k 1 000 000 00 processed a er e will show whether your ledger Unreconciled i i k Please enter the ledger total recorded by your lender a schedule of disallowed amounts proof of deliveries the amount borrowed and the amount available to draw down foreCASH will show whether the available amount is consistent with the recorded advance rate and cap 5 3 ave Page 165 of 182 E support foreCASH co uk fore CAS H j 10 5 Varying the amount drawn down into the master account When setting up the ABL account you had the option to select the default level of draw down all available either full amount available or amount rounded down typically to nearest 1 000 or the minimum amount required to prevent a net shortfall on non ABL accounts either exact minimum or rounded up typically to the nearest 1 000 By right clicking on a Drawn down amount you may change the draw down rule option for a given date In addition to the four default opti
138. fo re C A S H j 3 7 2 3 Sales by customer group revenue recognition WIP Provided you have opted for the revenue recognition option see Error Reference source ot found then under Order Preference options A and C where By Customer sales data is entered first you have the option to schedule the revenue recognition of sales invoicing For example if the work carried out is not matched by the invoicing schedule you may wish to set the level of WIP Work In Progress Work Performed Not Invoiced in order that the Profit and Loss reported each month is a fair reflection of activity levels rather than just invoicing Sales and stock forecast Step 1 Order preference Step 2 Sales by Customer group Step 3 Purchases stock sales by Supplier Customer outlet Feb 09 Apr 09 gt gt copy total gt gt gt gt copytotal gt gt gt gt gt gt copy total 50 000 gt gt copyeach gt 50 000 gt 0 gt Invoiced CustProj1 50 000 50 000 WIP added released 25 000 25 000 Revenue recognised 25 000 25 000 Cumulative WIP renee at Invoiced All WIP added released Revenue recognised Cumulative WIP gt Copy for one month gt gt Copy total but keep mix gt gt Copy for all later months gt gt Copy each amount and mix In the example above a 100k piece of work is invoiced 50k at the start of the project and 50k on completion The work is performed evenly over four months
139. for a number of companies to be aggregated into a consolidated group forecasts These features must be activated with a specific licence code This licence key is typically applied while a single company forecast is open via menu option File gt Properties and Keys after which an additional tab is offered on the select company version screen foreCASH Select Company Version session1 Consolidations r Consolidation r Existing Groups 1 6 Delete now Mega Group Edit version m Elements of selected version of consolidation i Add element 2 Z_Demodata 57 USD Retail 1 2008 10 2008 1 00000 2Z_Demodata Sv2edited 1 2008 3 2009 1 65000 Edit element 2 DemoCompany 21 Wholesaler Item Mode 1 2008 12 2008 1 50000 1 2_Demodata 1 Demo_standard E 122008 10 2008 1 50000 Delete now Page 170 of 182 E support foreCASH co uk fore CAS H 12 2 Setting up Multi company consolidations A number of existing forecast versions can be added to consolidation Each is called an element The display order of the companies within the consolidation can be changed using the A and V buttons alongside the element list r Consolidation Existing Groups rr mS acon 1 mj Edit Group Delete now r Existing consolidation versions for selected group Elements Symbol _ Select Delete Logged out by 1 2 GBP oO Edit version Delete now p Ele
140. forecast additional purchases beyond those in the imported schedule Purchase Order Committments import 1 Choose accounts 2 Select file 4 Validate Sales and stock forecast Step 1 Order preference j Step 2 Sales by Custom OOOOOOOOO wks Notes on columns 1 NB All existing entries for accounts included in the import will be overwritten 2 Account currently set to Man Import monthly pattern Items will be scheduled on a daily basis using the imported data 3 Account will be set to Man Import monthly pattern during the import 4 Daily imported values will be aggregated on a monthly basis foreCASH will calculate the daily spread based on the monthly pattern chosen for this account Nea Copy gt Copy for one month Copy all gt gt Copy for remaining months Apply gt gt Apply target stock days based on COS in following month Minimise Purchases Clear PO comms Autofiy lt Back To start the process of importing a schedule of PO commitments use the Import PO comms button The file for import requires a format Column 1 Supplier reference 2 Date 3 Amount You have the option of also importing the due date in a manually specified column 4 20 To clear any previously imported PO commitments use the Clear PO comms button A useful tool after importing PO comms is to use minimise purchases button This presents the lowest possible stock levels bearin
141. forecast can also be presented on a weekly basis using the button at the bottom of the main daily cash flow screen This report can also be exported to Excel foreCASH gt gt gt Company 2 zDemoCompany v 1 Demo_standard Cash movements weekly to F otto sf Sto 12 to 18 19to 25 to tol 2 to 2008 Janae Jan 2008 Jan 2008 Jan 2008 Feb 2008 Feb 2008 EEE 4 days 7 days 7 days 7 days 6 days 1 days 7 days Receipts 0 0 0 0 0 0 0 0 191 714 10 650 1 030 680 170 211 298 0 106 563 0 0 0 0 206 212 0 0 0 0 0 0 0 0 298 277 10 650 1 030 680 170 417 510 Payments 10 000 0 0 0 0 0 486 939 899 500 0 0 0 Oo 87 301 0 0 0 0 0 ol 18 252 0 0 2 000 0 11 700 0 0 0 0 0 0 20 000 0 8 017 376 0 0 0 0 0 39 222 0 1 000 0 0 0 0 0 Interest ooo i i 0 0 0 0 0 0 0 50 000 0 0 0 0 0 0 61 275 1 500 2 000 0 31 700 0 649 731 0 0 0 0 0 0 0 61 275 296 777 8 650 1 030 31 020 170 232 221 76 148 220 629 229 279 230 309 199 289 199 459 32 762 25 000 25 000 25 000 25 000 25 000 25 000 25 000 0 0 0 0 0 0 0 51 148 245 629 254 279 255 309 224 289 224 459 7 762 51 148 245 629 254 279 425 102 Using the buttons at the bottom right of the daily cash flow report you have the option to move to a weekly or monthly view on cash When in the weekly or monthly cash report you also have the option to move to the other two levels of detail using buttons You can also drill down from weekly to daily or
142. g in mind opening stock PO comms and sell through of goods Having set the minimum level stock days can be applied to refine expected stock levels The value of any PO comms imported by month are shown in lower grid Page 108 of 182 E support foreCASH co uk fore CAS H 3 7 2 8 Importing customer sales or supplier purchases Sales and Stock forecast order entry Options a and c allow some importing of sales and schedules Option c also allows a schedule of purchases to be imported unlike PO commitments see 3 7 2 7 option c allows the manual reduction of these purchases after import If a given customer or supplier has been set with a Manual Import monthly pattern The sales or purchasing data that is imported will be treated on a daily basis Where data is imported for other accounts any daily data will be consolidated as a monthly figure This monthly total will be split across the month using the monthly sales purchasing pattern assigned to that customer Sales and stock forer lt Sales import Step 1 Order prefer 1 Choose accounts 2 Select file 4 Validate 1 NB All existing entries for accounts included in the import will be overwritten 2 Account currently set to Man Import monthly pattern Items will be scheduled on a daily basis using the imported data 3 Account will be set to Man Import monthly pattern during the import 4 Daily imported values will be aggregated on a monthly basis for
143. he month of actual hire 0 The payment made to Hertz in January 08 will be for the December 07 invoice This invoice should be in the imported ledger of supplier balances and so the January 08 payment will be Dealt With by Ledger or DBL e foreCASH will schedule additional payments from Feb 08 onwards Add Overhead Y Overhead Type Car X Description fCar hire 10 cars Supplier code Herz Group z Add Supplier Supplier name Herz Group VAT M Bank account Barclays current z Periodic payment Payment frequency ex VAT 5106 38 Weekly gt z fine VATE J 6 000 00 Monthly Payment method Cheque gt C Quarterly gt a Emmo J C Annual gt J 10 payments over 12 months Payment day within month Last Day pa Months credit to settle invoices invoiced gt months before payment fi x accrual Invoiced gt months in advance arrears of start of expense period fo x Balance in imported ledger J 6 000 Make accrual for previous invoice as not in ledger E Terms applied to ledger 30d 1 last 60 30 30 days net month end foreCASH will assume that the invoice for the first month is already in your supplier ledger and does not need to be added into the schedule as a recurring item If this is not actually the case say the invoice was not received and no invoice was booked to your ledger Page 114 of 182
144. he reconciliation of supplier statements to your payment schedule Goods in transit items will be added to your opening stock balance e f you import a schedule of purchase order commitments see sections 3 7 1 5 1 item product mode and 3 7 2 7 supp cust sales split mode these will be summarised here e Goods received not yet invoiced increase the level of payments due to suppliers to avoid understatement of payments in the forecast This also helps in the reconciliation between supplier statements and your payment schedule Opening Data Manual entries Please enter opening stock balances GIT Goods In Transit and the accrual for GRANI Goods Received but Not Invoiced by your suppliers You may also enter any purchase order backlog commitments optional Stack detak Top 9 Pool Opening stock Goods in Opening Purchase order Goods received Suppier ID actual transit stock commitments not yet invoiced 1 000 000 500 000 1 500 000 J 1 500 0 1 500 0 0 RADIO009 PIONEER002 TELACCO02 Not specitied ooooooooo 0 0 0 0 0 0 0 0 38 500 1 000 000 1 038 501 1 040 000 1 500 000 2 540 000 To edit details click on selected data on grid above When running in Item product mode this form only collects information on opening Raw Materials levels by key supplier WIP and Finished Goods stock levels are collected with the ongoing sales and stock levels forecasts under Forecast Data gt Sales and stock forecast
145. heme CIS whereby you have to deduct PAYE from payments made to suppliers or subcontractors you can specify the relevant rate of deduction in foreCASH One rate can be specified for existing invoiced items in your opening ledger with a second rate used for any new forecast activity If a subcontractor provides both materials and labour you can either use a weighted rate to reflect the expected mix if activity or set up the sub contractor in two parts e g ABC_ materials 0 CIS deduction rate and ABC_Labours 20 CIS deduction rate Cis deduction rates Supplier CIS deduction rates i 2_GenMaterials GenMaterials Click to edit 2_GenConsumables GenConsumables z_GenSubcontractor GenSubcontract 2_GenSiteVehicle GenSiteVehicle z_GenSiteFuel GenSiteFuel z_GenVehicleR epairs Gen ehicleRepair 2_GenHirePlant GenHirePlant CIS_Test ClS_Test CIS_test2 ClS_test2 z4qq_GenCOS General COS Click to edit Edit CIS discount rates Supplier CIS_Test CIS deduction rate percentage of net invoice Percentage rate past ledger b f f1 00 Effective when paid Percentage rate new activity 18 00 Effective when paid Close Amounts deducted from suppliers will be added onto the PAYE NI payment in the following tax month PAYE NI 204 325 150 Pension Sub Total 0 204 475 Page 89 of 182 foreCASH E support foreCASH co uk 3 7 1 5 Stock levels Product Finished goods WIP levels
146. hmonthend C MPa gy 01 Dec 08 50 000 Click here Points above base rate 7 x 31 Jan 09 30 000 Click here Single Target Level Always C Action depends if balance positive negative o Always Set to Zero 9 p ia Aod the period and extent of boroning Uss kul facky s G facilities for this account using the Add Monn Details button Add Details m If positive balance C Quarterly z Clear down to zero 9 C Annual a If balance exceeds 100 000 then lower G to balance of 25 000 m If negative balance Always bring back to zero If exceed facility bring back to zero Bring back into credit balance of If balance exceeds facility then transfer funds to bring E back J 25 000 _ into facility Save Close The Other current accounts overdrafts can have an Auto Sweep option applied in order to keep the Other accounts within a certain boundary range See below Page 23 of 182 E support foreCASH co uk fo re C A S H 3 2 2 Current accounts overdrafts Auto sweep You can Auto sweep to from the Other bank accounts in order to keep them within facility or to draw down excess funds Options include e Keep account at zero e Keep at full facility e Replenish to bring back X into facility if goes overdrawn e Clear down to X if excess funds balance gt X build up Auto Sweep Options Iv G Each monthend Apply utosweep transfer
147. hs invoicing can be split for collection over 1 12 week period The collections can start at the beginning of the following month or after a one month delay The day of the week for the receipts can also be specified Define the settlement split across up to four stages Define the settlement point 99 days relative to the invoice for each stage Initial payment terms on new activity can be SN only set to run until a certain month after which UDT point a new set of terms applies Not all of the other payment terms are currently available in the list of initial and new terms S supplier C customer P past imported ledgers N new based on sales purchase forecast UDT user defined terms allow some local configuration of settings Page 58 of 182 foreCASH E support foreCASH co uk 3 5 6 User defined business terms A number of terms allow some local user configuration to create user defined terms These can be configured via gt Drivers Key Accounts gt User Defined Terms gt User Defined A D User defined strict payment terms whereby invoices are settled a precise number of days following the invoice date A amp B for suppliers C amp D for customers User Defined E P User defined net month end payment terms whereby invoices are settled a precise number of days following the month in which the invoice was raised Days 1 28 NME E amp F for suppliers G amp H for customers Days 31 59 NME
148. ing invoice disc Pi The master account should be set to the main current account you use for payments to suppliers If you do not use invoice discounting or factoring the ABL 2 accounts are not relevant to your business and can be ignored Sort code Account no Description Currency Further details Master account 00 00 00 00000000 Barclays current Current Ordinary Sterling Click here ABL Collection 00 00 00 ooooo000 bank_description ABL Collection Sterling Click here ABL Drawdown 00 00 00 00000000 bank_description ABL Cleared d d Sterling Click here To edit details click on relevant white cell in the grid above Use further details to set faciity levels for an account Page 22 of 182 E support foreCASH co uk fo re C A S H j In addition to basic information such as currency account name sort code and account number you can enter information on the extent of any borrowing facilities multiple start from dates and levels of facility can be entered and the interest rules on the account lf your company maintains a large petty cash balance you may wish to use one bank account for your Petty Cash account Banking Facilities f Account Description Euro account Current account ordinary 9 Hater etaik Facility detadk Eup m Auto Sweep Options edad Q gt Apply utosweep transfer to from main bank account JV rate 4o 01 Mar 08 30 000 Click here Each Day ce Eac
149. interest charge and or commission The advance is repaid when your customer settles the invoice involved The customer balance debtor remains on your company balance sheet Map an import file specify how the field column order in an imported file relates to the key fields required Manufacture Mode See Item Product Mode Mark Up foreCASH collects Gross Margin Margin as a of sales price data rather than the Mark Up percentage on cost Gross Margin Mark Up 1 Mark Up Master currency the main currency of your business and the currency in which the forecast will be presented Management Action planned or actual changes to your base forecast as a result of flexing sales or stock levels or as a result of changing the normal expected settlement date of an invoice Mode a setting in foreCASH which determines whether the software operates in Item Product Mode or Supp lt gt Cust Mode MSP Merchant Services Provider a company which processes credit card transactions on your behalf Net month end terms a form of business terms by which invoices fall due at a month end rather than on numerous days over a month New transaction in foreCASH a payment or receipt to settle a transaction that occurred after the start date of your forecast such as receipt for a sale occurring after the start date Non working day a Bank Holiday or Shutdown Day Overhead an expense incurred by
150. irregular overheads e Other sundry creditors which will be paid during the forecast period can be entered against one of four categories using a calendar view See Opening data gt Long term and Sundry creditors gt You should only enter sundry creditors here if you are sure that they will not be addressed within recurring or irregular costs Long Term and Sundry Creditors Sundry creditors payment details Use this section to enter creditors for expenses that are not gj modelled elsewhere in the forecast Ongoing expenses recurring and irregular will calculate opening accruals automatically based on the invoice payment timing you specify Direct costs Edit Details Property Edit Details Other overheads Edit Details Long term other creditors Not paid during this cash forecast NB Do NOT use this section to enter long term bank loans a Only impacts Long term 9990 00 Balance Sheet Close If at the start of your forecast you have long term creditors which are not included within your main supplier ledger and are not expected to be paid during the period of the forecast they can be entered via Opening data gt Long term and Sundry creditors gt this will not affect your cash flow but will be reflected in your balance sheet Page 72 of 182 E support foreCASH co uk fo re CA S H 3 6 9 Fixed assets Opening fixed assets together with depreciation rules can be set These amounts are entered via Opening d
151. ith the exception of section 3 4 importing of ledgers is not generally necessary you may however wish to revisit and refine the rules parameters you have chosen Should a period of cash strain be identified within the Base Forecast foreCASH is designed to help you to plan a solution This is discussed in detail in section 4 Page 127 of 182 E support foreCASH co uk 3 15 5 1 Daily cash flow report review By default after running a cash flow forecast calculation foreCASH displays the daily cash flow forecast You can change the default view to Weekly or Monthly via Reports gt Report Options The upper grid shows a summary of payments and receipts by one or more sub categories If there are a lot of categories you can condense the payments and or receipts into a single line by clicking on the first column on the relevant total Al foreCASH gt gt gt Compan File Edit Banksetup Drivers key accounts Opening data 76 ResellerPack v 3 Electrical wholesaler local data Forecast data OE Oe A Se Galculate cash flow St 01 01 2008 Lq View Forecast If you click on a payment or receipt category line it will bring up a second level of detail showing which customers or suppliers make up the category This can also be done on the Receipts Drawn down from ABL Customers top 5 Customers other Other receipts Receipts Total lt gt Payments Total Transfer Exchange g l Daily move on cash Net
152. its can be set to have their own terms in which case there is the option to set invoices as being raised in arrears In Supp lt gt Cust you have the option to allow the phasing of invoice recognition in the P amp L if this option is chosen on the File gt Change Start Date and mode screen Page 21 of 182 E support foreCASH co uk fore CAS H i 3 2 Setup bank accounts and loan facilities Bank facilities should be considered in two parts i current accounts overdraft accounts stock based lending see section 3 2 3 and Asset Based Lending Facilities where trading transactions are being processed on a regular basis see section 3 2 4 ii loan facilities where there is a preset schedule of capital repayments and interest charges see section 3 2 5 3 2 1 Current accounts and overdrafts Three bank accounts are created by default a master current account and two accounts related to Asset Based Lending ABL If your business does not use factoring or invoice discounting facilities you will not need to use the ABL accounts You can choose to set up a further standard non ABL bank accounts via the Other accounts tab If you operate multiple invoice discounting facilities these can be added via the Other ABL factoring invoice disc Tab A maximum of 99 standard and 99 ABL related bank accounts can be added Bank Details set account name and facility information Other bank accounts Other ABL factor
153. l sales or can display the specific customer that has driven the sales This option is set within the main Bank settings screen Bank facility details Account Description GBP Invoice Discount HSBC Asset based lending cleared draw down account Interest details m ABL details Attate of 0 Draw down tule Exact Min z Variable rate C Fone above Percentage of Pool sales that are factored 0 se rate Default advance percentage 85 000 Allow negative borrowing bank owes you Interest charged comes Processing delay days Invoices 27 Monthly C Quarterly Default borrowing cap limit 7 000 000 C Annual ww Draw into account cer Current HSBC z Facility details m Charges paid from ABL account Monthly charges 0 Per draw 0 Commission charges on invoices 0 When exporting statment show sales by cust J Add the period and extent of borrowing facilities for this account using the Add F Details button Add Details B Save Close Page 147 of 182 E support foreCASH co uk foreCASH 7 6 Monthly reports Profit and Loss Balance sheet and funds flow report This report provides a monthly summary Profit and Loss account Balance Sheet and Funds flow The balance sheet and funds flow are prepared on a cleared basis Debtors and creditor balances will be adjusted for any un cleared payments and receipts f foreCASH gt
154. last__ iG HDTVOO02 High Definition TY Corp Vat 30d 1 last__G SONYO01 Sony Corp Nil 30d tlast___ G PIONEEROO2 Pioneer VAT 30d 1 last__ sG TELACCOO2 Tele Accessories Ltd VAT 30d 1 last__ iG RADIOS Digital Radio UK VAT 30d 1 last__G DUTY_OTHER Smaller accounts where du iat 30d 1 last_ 6 To set the default VAT rule for general unranked costs of sales go to menu option Drivers key accounts gt VAT and Tax from within the VAT and Imports top level main tab choose VAT second level tab VAT and Imports VAT parameters r Standard VAT rate rm Share of pool sales that are zero rated excludes key accounts Fixed gt T T 0 lt Fixed Mar 11 Apr11 May 11 dun 11 Variable gt pr i Variable gt VAT VAT Import VAT Nil Share of pool COS purchases that are zero rated excludes key accounts 0 G lt Fixed Mar 11 Apri May 11 Jun 11 C Variable gt M VAT return frequency and timing Page 36 of 182 E support foreCASH co uk fore CAS H j By default foreCASH models Import VAT on the basis that you have an account with HMRC and are able to defer Import VAT payments until the 15 day of the month following the import arriving in the UK If import VAT applies to your business and you do not have an account with HMRC change the relevant setting via menu option Drivers key accounts gt VAT and Tax from within the VAT and Im
155. le purchase 45 days net fortnightly Two payments per month one mid month for the second fortnight of the month before last and one at month end for the first fortnight of the previous months transactions Payment occurs 60 45 days after the sale purchase 60 days net month end A single payment at the end of each month for the month before lasts transactions Payment occurs 90 60 days after the sale purchase 60 days net fortnightly Two payments per month one at mid month and one at the month end for transactions from the month before last Payment occurs between 75 and 60 days after the sale purchase 90 days net month end A single payment at the end of each month Payment occurs 120 90 days after the sale purchase 0 days net fortnightly Two payments per N only month one at mid month and one at the month end for transactions in the previous 15 days Payment occurs between 15 and 0 days after the sale purchase x days net month end A single payment per S only month Payment occurs x days after the month end Where x can be set by the user between 1 and 28 E F 31 59 I J or 61 89 M N C only UDT x days net month end A single receipt per month Receipt occurs x days after the month end Where x can be set by the user between 1 and 28 G H 31 59 K L or 61 89 O P Net month end payment is split 50 50 across x days and y days net month end User defined R UDTr x y Split days Net month
156. lidated Consolidated monthly cash flow P amp L Balance Sheet and Funds Flow will be available in later versions The consolidated weekly cash flow report is generated within an Excel file and contains a summary sheet a sheet for each company in the consolidation and a sheet containing the exchange rate scaler data foreCASH Conversion Rates 1 Z_Demodata 2 Z_Demodata 3 DemoCompany 4 Z_Demodata ulalwly MN zeen L 38 39 40 41 52 57 Property 47 Direct Costs Readv J G D E F G Delta Group 1to6 7 to 13 14 to 20 21 to 27 2 Jan 2008 Jan 2008 Jan 2008 Jan 2008 Feb 7 days 7 days 7 Drawn down from ABL 1 Z_Demodata 10 455 14 405 40 700 13 650 2 Z_Demodata 5 858 8 399 1 815 3 DemoCompan 286 821 131 185 38 T 26 42899 76 832 38 127 ft 9 909 61 792 126 115 73 629 7 Scaler Inverse 7 795 5 850 2 110 2 140 i 1 1 p 2 F 1 65 0 606060606 1 5 0 666666667 pam 5 S a a 1 5 0 666666667 5 000 m a A B a D 2 703 6 a i i 1 Z_Demodataffcv 2 21 2 1to6 7 to 13 7 964 11 3 Jan 2008 Jan 2008 1 349 4 6 days 7 days 1 2_Demodata 2 475 EAO propery e E D 44 Other Overheads 376 118 2 Z_Demodata MAE var 5 3 DemoCompan 564 lt 46 Corporationtax of 1 000 4 2 Demodata 3 713 47 Other Taxes o 1 000 48 Pool capex __ 50 000 o 42 Other overheads 49 Capex 50 000 o 50 Payme
157. ll sales and stock forecasts should be entered in the Master Currency If a forecast calculation has not yet been run in the current forecast you can edit the master currency via File gt Set Master Currency gt Set Master Currency Chonan art SAEY All summary tables and reports will use the Master Currency Currency Chinese Ringit CR Other It is possible to view a single foreign currency bank account in its foreign currency using the Now Showing drop down box on the daily cash flow forecast See 7 1 The account s and currency of the weekly cash flow view follows the current Now Showing setting of the daily cash view Screens which include amounts shown in a foreign currency include light blue cell shading where a white cell would normally be seen foreCASH gt gt gt Company 128 Z_Demodata v 6 Blue retail by bank tests localdata St01 01 2008 Lgth 10 Std le Edit Banksetup Drivers nts Opening data Fo ta Calculate cash How view Forecast Reports Flex Help Ie OF 2 4 Cash movements weekly to Friday or Month end Tto4 St 1218 19w02 26to 31 Tol 2to8l 3t015 Jan 2008 Jan 2008 Jan 2008 Jar 2008 Jan 2008 Feb 2008 Feb 2008 Feb 2008 Receipts _ 4 days 7 days 7 days 7 days 6 days 1 days 7 days 7 days 604500 384 000 174 000 174 000 468 000 o a o 604 500 384 000 174 000 174 000 468 000 0 0 0 110 414 o o o o 0 o o 0 o o
158. lolololololololole Siclelolololclolciolco P Please review line s 28 29 29 30 Line 28 Ref field empty Line will be excluded from Import Line 29 Ref field empty Line will be excluded from Import Line 29 Name field empty Line 30 Non numeric amount q lt Back Next gt Close If there is non numerical data in your import file in a field marked as an aged balance the given field will be excluded from the import of data If a row does not cross cast that is the sum of the aged columns does not match the column marked as the column containing totals you will also receive a warning Warning messages do not prevent you from importing the data as a whole but lines with warnings will be partially or wholly excluded If a row does not cross cast the aged columns will be used to build a revised total Clicking Next gt will import the data Page 46 of 182 Esuppon toecasHoouk SS FOCASH 3 4 3 1 Mapping bank accounts terms and VAT codes If your file includes bank account references terms of business references or VAT codes you will need to specify the correlation between values in your accounting system and those in foreCASH 13 BUSFUSUU Business Fost Ib 2D2 u b 2D2 19 TNTOVNOO TNT Overnight 12 000 0 12 000 20 STPROPOO ST Property Services 20 000 0 20 000 21 PRUDENOO Prudential 4 000 0 4 000 22 ABCWHAOC ABC Warehouse Automation 50 000 50 000 C 23 SONY0
159. low you to retain current sales stock and cost information If the length of your forecast remains the same and you have changed the start date by one month foreCASH will assume that sales and stock levels remain flat and will populate the new last month of your forecast for you Capital expenditure where applicable will be added into the new opening fixed asset figure If you always want the forecast produced by foreCASH to end at the same date as your financial year end you will need to shorten the length of the forecast each month 8 2 Changing the length of your forecast If you wish to change the length of your forecast select gt File gt Change length of forecast from the menu bar This option is only enabled if you have not yet run the forecast calculation If you have previously run a calculation you will need to clear it down losing any rescheduling amendments reconciliation of actual daily cash flows and flexes you have made before you proceed Page 159 of 182 E support foreCASH co uk fore CAS H i 9 Foreign currencies The foreCASH main summary screen shows all figures in the Master currency The default master currency is sterling For payments or receipts made in a foreign currency a user specified exchange rate is applied When foreign currency is transferred to or from another bank account any exchange difference arising is accounted for All imported ledger balances should be in the Master Currency A
160. ment of the import duty for each supplier can be set to a strict number of days from delivery or for periodic payment at the end of each week fortnight or month Page 38 of 182 E support foreCASH co uk fore CAS H j 3 3 3 1 Import duty COS and stock Import duty is included in the value of goods held in stock and in the COS shown in the sales forecast Import duty example Example1 Example 2 Total value of stock COS inc Duty 110 10 9 09 100 90 91 Import duty payments are shown within the Other Taxes category of the payments section of the main cash flow report 100 Import Duty rate for supplier Amount paid as duty Amount paid to supplier Property Other Overheads Other Taxes Interest Payments Total 0 0 1 200 Transfer Exchange g l Daily move on cash 0 3 730 1 780 Net Cash overdrafts 14 498 10 768 8 988 8 5 Overdraft facilities Headroom Shott fall 25 000 25 000 25 000 25 10 502 14 232 16 012 16 0 Import YAT Corporation tax Sub Total Page 39 of 182 E support foreCASH co uk fore CAS H 3 3 4 Supplier and Customer ledger defaults Past business terms will be applied to opening ledger balances New business terms are applied to activity driven by new sales and purchases Drivers and rules Supplier customer m Supplier and purchases Defaults m Customer and sales Defaults
161. ments of selected version of consolidation Eler Ejement of consolidation 5 2009 1 00000 O Source Local 7 3 2009 1 00000 Edit element Company 2Z_Demodata z Delete now Version 2 Demo_manufacturing 1 2008 4 2008 z Latest version number A Yy 1 Demo_standard 1 2008 4 2008 2 Demo_manufacturing 1 2008 4 2008 3 v2 edited 1 2008 3 2009 4 v1_adjusted std 1 2008 4 2008 5 Electrical Wholesale Ltd 8 2008 11 2008 6 Blue Retail Ltd 1 2008 12 2008 7 Blue Retail Ltd 2 adj graphs 1 2008 4 21 You can select a specific version of a company forecast or alternatively select the latest version number option so that your consolidation will automatically consolidate the latest version of a company p Elements of selected version of consolidation Element of consolidation a Smee Exch Scaler Select Delete PEA 5 2009 1 00000 O m Source SharectC Users dger Documents foreCASH vb6 fC_sharedD ata 7 10 2008 1 20000 O Edit element Company 2 DemoCompany z Delete now Version Latest version number 7 Exchange scaler 0000 ey vl Save Run weekly Exit If your group operates in multiple currencies each element of the consolidation can be scaled to allow for exchange rates Page 171 of 182 E support foreCASH co uk 12 3 Multi company consolidation reports As at version 2 7501 of foreCASH only the weekly cash flow forecast can be conso
162. ments should be entered excluding VAT If VAT will apply to the particular capital expenditure item check the box shown on the calendar view You can set the VAT Point relative to the payments using the VAT month drop down box Capital Expenditure Description or reference New XP PC rollout 0 invoiced in same month as payment 1 invoiced in month before payment Invoice date VAT point offset relative to payment date in months fa Capital expe Total amount 2750 Depreciation option Straight line over 3 years Please add the capital expenditure amounts excluding VAT on the expected PAYMENT DATES 01 Feb 2008 02 Feb 2008 03 Feb 2008 04 Feb 2008 05 Feb 2008 06 Feb 2008 07 Feb 2008 Saturday Tuesday Wednesday Thursday 23 Feb 2008 0 lt p2 gt of 13 Depreciation will be charged on capital expenditure from the month of payment onwards Capital expenditure items will be rolled into fixed assets when starting a new forecast if the payment date falls before the start date of the new forecast Page 119 of 182 E support foreCASH co uk 3 11 2 New finance leases can be added in the same way as existing finance leases See section 3 6 10 A new finance lease is one with a lease start date after the start date of your forecast If a lease is a new finance lease you will be asked to choose a depreciation method for the asset being purchased foreCASH will add
163. n the ledger aggregation section and from the Reports menu 3 5 7 6 Credit notes and unallocated cash in Ledgers Where credit notes or unallocated cash exists on an account in a ledger if the net balance in a given month is sufficient to result in a debit supplier credit customer the debit credit will be pushed back against any earlier amounts owing in order that the cash credit note is used at the earliest possible stage and to avoid paying older invoices which have already been credited paid but where the allocation of the credit note cash has not yet been made on the ledger If an account has a total net credit debit unless the account is marked as Never Pay or a schedule of payments has been imported the unused credit debit will be applied against any new invoices arising for this account from overhead and sales forecasts Page 62 of 182 E support foreCASH co uk fo re C A S H 3 6 Enter Opening Balances At the start of your cash forecast period certain data will be known This data will derive from the past activities of the business This opening data is collected through a number of manual screens and automated import processes Where data is imported a file is required in Comma Separated Variable csv or Microsoft Excel format 3 6 1 Bank reconciliations The opening book and bank position for each bank account must be entered The book figure is the figure reported in you accounting
164. n for past items in ledgers Invoices gt 1 month old paid immediately Remainder of opening balances will be paid on a weekly basis split over each Friday of the first month of the forecast P only P only Payment plan for past items in ledgers Invoices gt 3 months old paid immediately Each months activity paid over 90 days in even tranches on each Friday Items aged 60 90 days paid in m1 30 60 days over m1 m2 0 30 days over m1 m3 Page 57 of 182 E support foreCASH co uk Terms reference code past Never Exclude write_off Never Annual invoice model with recurring Retail A C cash chq cards mix Payment Plan A E Weekly spread Stage Payments A C 4payments defined split and days Variable terms foreCASH Notes Description The ledger balance will play no part in the P only forecast Can be used for bad debts or long term intercompany balances that are not expected to be repaid If you have an annual invoice sitting in your S P purchase ledger which is payable over the Unranked course of the year it is simpler to instruct only foreCASH not to schedule the ledger balance Instead set up a recurring cost to drive the payments This method is ideal for costs such as insurance where no VAT is involved Three user defined terms reflecting a mix of sales by cash cheque and credit cards Useful for retail store customers User defined customer receipt payment plans A mont
165. n the date of the final repayment Delete now Click Next gt to go to the Step 2 summary tab for a detailed schedule of the loan you have set up including interest Next gt Close Loan manual schedule Step 1 settings Step 2 summary 100 000 0 2 648 100 000 0 2 648 0 2 648 100 000 0 2 648 0 2 648 100 000 0 2 648 40 000 2 648 60 000 0 1 589 0 1 589 60 000 0 1 589 0 1 589 60 000 0 1 589 0 1 589 60 000 0 1 589 0 1 589 60 000 0 1 589 0 1 589 Page 34 of 182 E support foreCASH co uk fo re C A S H i 3 3 Set General Drivers Rules Drivers or rules are used to drive the automated features of the forecast Drivers menu path gt Drivers Key accounts gt Cover rules for Supplier and Customer ledger defaults working days exchange rates and for VAT Corporation tax Typical values have already been set up for many of the default drivers Over time you can refine or vary the choices you have made It is worth giving proper consideration to your choices before you start using the advanced management features of foreCASH as any rescheduling or flexing you apply to the forecast must be cleared before you are able to revise your choices 3 3 1 VAT foreCASH will calculate and schedule payments for VAT automatically You can specify the standard VAT rate during the forecast If paying VAT quarterly it is important to configure the VAT return frequency and
166. nciliation feature ensures that the forecast can be tightly bound to actual cash flows Reconciliation should not be used for major re scheduling of payments but is intended for corrections to cash transaction dates e g a cheque clears a day later or making minor changes to cash values e g a query on one invoice meant a slightly lower payment was raised Using reconciliation for rescheduling will mean that a lower profile will be given to the deferrals and you may not be aware of the full extent of underlying cash strain that was managed in your forecast Reconciling a transaction is quick and simple with the built in functions offered Reconcile Fecancie detas Account COLLIN002 Date 02 May 08 Forecast total BK ICCUBNS Barclays Barlcays Euro Not specified 2 Not specified 3 Not specified 4 Not specified 5 Summary 6650 00 J I Local currency I a Adjustment Feconcie actions Increase next payment Increase last payment in forecast Pay balance tomorrow Add payment to last day of forecast Do not reallocate difference small amount Attribute change to a credit note Choose date dd mm py Page 140 of 182 E support foreCASH co uk fore CAS H 6 View Forecast Your forecast can be considered to be in one of two states i Pre calculation of the cash flow ii Post calculation of the cash flow 6 1 View forecast pre calculation of cash flow Befo
167. ng 22 000 11 350 10 650 10 000 3 250 750 Date 01 Jun 10 1 Weekfs 5 000 2 000 3 000 End of stage Stage plus 0 days 4 Week s 250 0 250 End of stage Stage2 plus 12 days 20 Day s 6 000 0 6 000 End of stage Stage3 plus 0 days 1 Quarter s 750 100 650 Start of stage Staged plus 0 days 0 Quarter s Delete Enter as oe x Amount Materials booked out Job a Terms al Amount 4 000 Start of project From stock Percentage an ii 2000 Star of project 7 D From stock Amount 0 01 U Pre forecast start date Proj end gt NME 30 Month in advance 2 weeks in advance 1 week in advance Start of stage Evenly over stage Page 86 of 182 E support foreCASH co uk fore CAS H Once the project value and costs have been set up use the Next button to move to the second tab invoicing You can opt to specify the invoicing to your customer for the project as a whole or by each stage For the project or stage you can then specify one or more invoice phases The example below shows stage 5 invoicing being made up to main invoices plus a retention The invoice date for main invoices can be specific relative to the completion of a phase or the project as a whole or have a specific date entered Default invoice terms can be specified for the project invoices but any given invoice can have specific terms using e net month end days e strict days or e specific payment date Pryypsur sr y
168. ntegrity testing Flexing stock Fissany apa Month jun 07 Supplier AAPAPE O02 Current total Change 0 Revised total Allow cascade of stock change Limit any stock cascade TS A Cs OO Stock COS Purchases Stock COS Purchases Stock COS Purchases Stock COS Purchases 3 000 800 000 807 000 10 000 0 990 000 1 000 000 0 O 1 000 000 8 000 8 000 Sales COS flex 160 062 160 062 0 0 0 0 0 0 0 0 0 0 3 000 960 062 967 062 10 000 0 990 000 1 000 000 0 0 1 000 000 8 000 0 0 0 0 0 0 Flexed new total 3 000 960 062 967 062 10 000 0 990 000 1 000 000 0 O 1 000 000 In Item Product mode the user can flex the level of Raw materials for a supplier WIP Work In Progress for a product group and FIN Finished product stock for a product group Flexing stock AFREKENT OPNS Month Jan08 7 Supplier TUBULAROO1 x RAW materials s Current total RAW materials WIP Change 0 Revised total Allow cas FIN goods Limit any Supplier Feb 08 Mar 08 RAW materials Stock toWIP Purchases toWIP Purchases Stock toWIP Purchases Stock toWlP Purchases 50 000 79 793 109 793 5 49 777 19 777 50 000 41 102 41 102 50 000 40 199 40 199 0 0 0 0 Sales COS flex Finished goods flex 0 0 0 0 0 0 Raw mat flex 0 0 49 777 Is 50 000 41 102 50 000 40 199 Flexed new total J 2 A 2 50 000 Page 138 of 182 E support foreCASH co uk fore CAS H 5 Delivering a s
169. nts system the next time you import a ledger Page 47 of 182 E support foreCASH co uk fore CAS H 3 4 4 Ledger Import file structure format 3 4 4 1 Users of formal accounting packages If you are using a formal accounting package you first need to export your aged customer and supplier ledgers also known as sales and purchase ledgers into Excel spreadsheets or into CSV comma separated variable files From version v1 0 40 onwards the ledgers can be in a summary format with one line for each customer or supplier or on a by invoice aged basis If you import an aged ledger with every invoice detailed foreCASH will aggregate the invoices into a single line for each company If importing on a by invoice basis your file should not include sub total figures after each company There is not a prescribed field order for the exported files as you are able to set up a mapping order within foreCASH before importing your data The file must however include the following fields i Customer supplier name ii Customer supplier code or abbreviated form of name iii total balance and iv at least one aged balance field A maximum of twelve aged fields can be accommodated Once your ledger files are ready they can be imported into foreCASH To begin the import process select Opening Data gt Ledgers import from the top menu bar within foreCASH Page 48 of 182 E support foreCASH co uk fore CAS H 3 4 4 2 User
170. nts total 51 275 1 118 Salary zu 52 Weekly move on cash 246 502 1 031 53 62 Other Taxes 54 Net Cash overdr 246 502 245 472 55 Closing bank facili 25 000 25 000 56 Undrawn ABL 36 99 57 58 Closing Headroom deficit 271 538 270 570 59 Max deficit Min Headroom 26 284 270 570 60 t 61 5 62 t 63 Exp 06 09 2015 42 27 29 64 a N E12 Demodata E2_Z_Demodata E3_DemoCompan E4 Z Page 172 of 182 E support foreCASH co uk fore C A S H i 13 Activity patterns As it is rare for business to flow evenly over the month foreCASH offers you the chance to pick purchasing sales and pool collection patterns that are closer to that experienced by you business Pattern Very strong Weak Weak Rising rapidly to very softening rapidly strong in last days Strong softening Fair strengthening to strong Fair softening to Weak Weak Weak rising to very weak strong in last few days Back tick Strong softening to Weak Weak Weak rising to fair weak very rapidly Fair Fair Fair Fair Fair Fair Strong Strong ae ee ae First day All on first day Nil Nil Nil sales purchases only First ten days 7 days 3 days Nil Nil collections only Manual import Set by calendar view or calendar data import V shape Fair softening Weak strengthening Ramp down N shape Week 3 push Last day sales purchases only Patterns U shape
171. nvoices should be paid Un cleared payment receipt a payment or receipt that is recorded in only one of a your accounting system and b your banks records for an account but NOT both Standard Mode this was formerly the Supp lt gt Cust mode However following enhancements in the Item product mode the default Mode is now the ltem product mode and first new forecasts are generated in this mode Shutdown day a day normal Banking Day on which your business chooses not to open or operate such as a company wide break between Christmas and New Year or a summer period when factory maintenance takes place and the business does not operate Trading day a day of the week on which your business is normally open Some businesses have Trading Days of Monday to Friday others open on Saturday or Sunday but not say on a Monday WIP work in progress Raw Material stock items that in the process of being manufactured into Finished Goods XLT a template file for Excel which creates a new Excel xls file with certain formatting or content preset XLS a standard Excel format file Excel 2003 and prior XLSX an Excel 2007 format file Y E year end or year ended according to context Page 180 of 182 Index Accruals 72 Accrue accrued income 121 irregular overhead complex 117 Activity patterns 173 Add new delete See Housekeeping Tab Aggregating accounts 51 Asset Based Lending 28 ABL 22 28 16
172. o o 0 o o 0 o o o o 0 Oo 110 414 0 0 0 0 0 0 576 977 312 000 174 000 174 000 540 000 o 0 o 27 414 71 586 0 0 72 000 0 0 0 42414 114000 114000 114000 42 000 42 000 42 000 42 000 Q 0 o Q o 0 o 42414 114 000 114 000 114 000 42 000 42000 42 000 42 000 42 000 42 000 ELA EAA ELA Max deficit Min Headroom 15 000 42 311 Page 160 of 182 E support foreCASH co uk foreCASH 10 Asset Based Lending ABL 10 1 ABL Factoring and Invoice Discounting foreCASH models confidential invoice discounting where debtors remain reported in the balance sheet within ABL debtors The same feature can be used to model the Factoring of customer balances albeit the debtors will remain on balance sheet in balance sheet reports Monthly charges and interest can be attributed and paid through the ABL account Daily charges or commissions must currently be set up as direct costs or an overhead Section 3 2 gave a brief overview of how to set up the bank account details for your ABL accounts This section will look at the use of the ABL features in more detail 10 2 ABL in the main daily cash flow summary screen The main daily cash forecast screen can refer to ABL in two places A foreCASH gt gt gt Company 115 ResellerPack Invoice Discount was 76 2 v 2 ABL ON testi File Edit Banksetup Drivers key accounts Openingdata Forecast data Calculate cash How Repor AM OB 2 4 h ES rR 7 316 Bank Holiday 02Jan 2008
173. o uk Sales flex step 2 Flexing sales precision Step 3 supplier payment schedule Step 2 customer payment schedule By default flexed receipts are allocated on default terms To allocate a specific payment schedule check the Manual box of the appropriate customer then click to allocate or edit Amountinc VAT Manual Click to 10 000 11 750 allocate f Close ID CLIMBIO03 Day Total amount 750 Balance all 11 750 Outstanding to match base figure 11 750 Adj Balance 01 Jan 08 02 Jan 08 03 Jan 08 04 Jan 08 05 Jan 08 06 Jan 08 07 Jan 08 Tuesday 08 Jan 08 15 Jan 08 16 Jan 08 17 Jan 08 18 Jan 08 19 Jan 08 20 Jan 08 21 Jan 08 If you are reducing the level of payments receipts you need to apply the manual adjustments to payments receipts that relate to the month that you are flexing such amounts are highlighted in the dark grey rows of the calendar grid Page 137 of 182 E support foreCASH co uk fo re C A S H j 4 2 2 Flexing stock In Supp lt gt Cust mode stock can be flexed by individual supplier When making the flex you can choose to either Limit any stock cascade impact whereby any increase is unwound in the following months subject to available sales out or to Allow cascade of stock change whereby increasing stock in one month will lead to an increase in the following month s Please note stock flexing has in built i
174. oard to move between boxes on a form Edit Issue No Save Exit Page 8 of 182 E support foreCASH co uk fore CAS H 2 1 Master Currency Once your security keys are accepted you will be offered the chance to set the Master Currency of your forecast This is the functional currency of your business Sales and stock forecasts are entered using the master currency All tables and reports are summarised in the master currency 2 2 Company and version selection foreCASH allows you to make forecasts for a number of companies A number of forecast versions for each company can also be created More information on companies and versions can found in section 11 foreCASH Select Company Version Add company Import comp Delete now Delete now Copy shared gt lt Copy local Shared Data iE LLL Standard 19 01 2011 2 Demo_manufacturing 9 Manuf 19 01 42011 3 Project Comp l Standard 1970172011 4 Electrical Wholesale 2 l Standard 1970172011 Delete now Standard 19 01 2011 H m 2 j Local gt shared Selected database ref local wkforecash111_5 mdb Companies licenced E e Some users will see a demonstration company with preloaded data to provide you with an example set of data to allow you to explore foreCASH Companies versions can be stored in two locations locally on your PC hard drive and ata shared drive location such as your company network The
175. ode foreCASH assumes sales flexes occur at the standard rate of gross margin for that item product If lowering stock levels it is worth considering whether there will be an impact on either current or future levels of sales 4 2 1 Flexing sales Flexing sales precision Step 1 flex amounts if it Month j an 08 X pranoni Current total i C Prorata a 5 A single month may be changed Specific CLIMBIOO3 ga 10 000 Range of change Increase 99m Decrease 23 625 in any one flex Revised total Flex Product Pro rata Specific Rank 1 2 a 5 6 7 8 g Other Other Standard ABL Grand Customer ACORNOO4 BQDIYOO3 CLIMBIOO3 JLEWISO02 JONJONOO2 WESTLAOO7 WEBSHEOO7 KENTCCOO1 CRISSCOO2 __ standard ABL total total Total ABL F F Base Sales 23 625 23 625 15 750 7 875 7 875 7 875 7 875 7 875 7 875 47 250 0 157 500 0 157 500 Sales flex 0 0 0 0 0 0 0 0 0 0 0 23 625 23 625 15 750 7 875 7 875 7 875 7 875 7 875 7875 47 250 157 500 0 157 500 Flex now 0 0 10 000 0 0 0 0 0 0 0 10 000 0 10 000 All sales in forecast 23 625 23 625 25 750 7 875 7 875 7 875 7 875 7 875 7 875 47 250 167 500 0 167 500 1 2 3 E es 6 7 8 E 10 Climbing Frar Climbing Frarr Climbing fram Tricycles Wheelbarrow Sheds HI __ Sheds MID Sheds Low Birdtables Product pool Base Sales 20 000 40 000 20 000 5 000 5 000 15 000 30 000 5 000
176. of supplier payments You can import a payment schedule list for an individual account at a time or import a schedule addressing multiple accounts If there are suppliers set to Import List you can individually import a list of payments for each supplier using a file with a format of Payment date in column 1 and Amount in column two Payment Date Amount 15 6 2010 1 000 30 6 2010 Alternatively for the opening ledger you can use the Import Multi Button to import several accounts at once The first three columns of the import file should be the account reference payment date and amount Where foreCASH detects amounts relating to an account that is not set to import list the items will be ignored Account reference Payment Date Amount JVC002 15 6 2010 1 000 ee JVC002 30 6 2010 750 Po HDTV002 23 6 2010 2 200 SONY001 31 8 2010 4 300 Will be ignored If the ranked key suppliers customers include aggregated accounts foreCASH will look for sub accounts that should be imported and attributed to the top level account Page 67 of 182 E support foreCASH co uk Importing a list of supplier payments for one or more accounts Opening Data Manual entries foreCASH Manually entered payment schedules and imported lists if applicable are administered from this screen Opening credit note accruals are also administered here Past Opening ledgers GIT and GRNI New Pu
177. ogether H foreCASH gt gt gt Company 128 Z_Demodata v 2 Demo_manufacturing loca File Edit Banksetup Drivers key accounts Opening data Forecastdata Calculates LE BB B t20 Sales and stock forecast Step 1 Products services Step Mar10 Apr10 May 10 Jun 10 E 171100 171 000 171 000 171 000 127 010 127 000 127 000 127 000 44 090 44 000 44 000 44 000 25 77 2573 273 25 73 171 100 171 000 171 000 171 000 Sheds super dit 50 000 50 000 50 000 50 000 Sheds general i 75 000 00 75 000 75 000 75 000 Wheelbarrows i 25 000 00 25 000 25 000 25 000 gt gt Units hanng 100 gt gt SP per unit Benches Group5 D efaultl Group6 D efaultl Group Defaultl Group8 D efaultl Group9 D efaultl Product pool 127 010 127 000 127 000 127 000 COS Sheds super 32 000 32 000 32 000 32 000 COS Sheds general 60 750 60 750 60 750 60 750 COS Wheelbarrows 21 250 21 250 21 250 21 250 COS Benches 13 000 13 000 13 000 13 000 COS Group5 Default 0 0 0 0 COS Group6 Default 0 COS Group Default 0 COS Group8 Defaultl 0 COS Group9 Default 0 D D D D D COS Product pool 0 0 0 0 0 0 Select cell and use F2 for copy to all months options Note the option to use F2 key to copy a value to all later or prior months Page 81 of 182 E support foreCASH co uk fore CAS H Click on the COS line for a product to bring up a summar
178. olution Having decided upon a plan to work through a period of cash strain the foreCASH programme offers a number of features to help deliver the plan in a controlled manner 5 1 Status reports The status of cash transactions that have had cash dates revised is reported upon See also 4 1 5 The available statuses for a change are outstanding discussion agreed no agreement being sought Reports can be run which will show all deferred cash payments with the varied cash dates by account and by status see section 7 13 5 2 Payment release control sheets The purpose of payment release control sheets is to ensure that the actual payments made correspond to the plan devised within foreCASH The sheet highlights all un reconciled payments that are expected to clear your banks up to the date 10 days from the date Items can be approved for release deferred in which case they are pushed back beyond the end of the 10 day period under review or left pending a decision A list of payments approved for release during this visit to the Payment Release Control can be printed for circulation to the purchase ledger department or financial controller that raises payments Payment release control FEINEN release conned 2 From 16 Jul 08 to 23 Jul 08 Supplier Forecast date Rayment Forecast Previously New approval Defer Approved New approval Adjustment to Decision
179. on at the bottom left of the screen FIVE z 21 667 G78 Item sneds View total View enter gt gt Copy the Total amalgamated view les and stock forecast Step 1 Products services Customer Mar 10 Apr 10 May 1 E E Grand Total 171 100 171 000 171 Customer specific 75 000 75 000 fia Sales items with own 50 000 50 000 5C Perc based mix 46 100 46 000 4 BODIYO03 79 610 739 600 7 WEBSITE 3 688 3 680 g TREETOPOO a227 3 220 4 WEBSHEOO 2 766 2 760 A WESTLAOO 2 305 2 300 E JLEWI5002 2 305 2 300 Z JONJONOO2 1 844 1 840 1 INDGAROO1 1 844 1 840 1 KENTCCOO1 1 844 1 840 1 ltem Sheds 50 000 50 000 5C Key customers 149 433 149 380 14 Pool 21 667 21 620 21 Page 99 of 182 E support foreCASH co uk foreCASH 3 7 2 Supplier lt gt Customer split sales mode Supp lt gt Cust In Supp lt gt Cust mode you have a number of options for entering sales and stock forecast data a By customer Sales then by Supplier Margin sales stock b By Supplier Margin sales stock then Customer Sales c By customer Sales then by Supplier Purchases stock sales Options a and c also allow a list of daily sales and or purchases to be imported for one or more key accounts Choose the order that best suits your business approach Sales and stock forecast ql Step 1 Order preference Step 2 Sales by Customer group Step 3 Purchases stock sales by Supplier Customer or pro
180. ond and third levels department categories When running in Item Mode you have the option to add a second and third level of department category to apply to sales Cost centres and departments Cost centres Top Level 1 Top Level 1 Sub Level 2 Sub Level 3 3 Engine parts 4 General click here Defa 5 Area 1 existing stores 6 Area 2 new stores 3 9 2 Assigning a cost to a cost centre Individual expenses costs can be assigned a given cost centre department via their set up forms Page 112 of 182 E support foreCASH co uk fo re C A S H 3 10 Overheads payroll and taxes 3 10 1 Payroll Wages and salaries Costs such as payroll can be set up to recur throughout your forecast Payroll can be set up for employees paid on a weekly fortnightly pattern Wages and or on a monthly quarterly annual pattern Salaries Payroll costs can accommodate variable commission elements related to forecast sales or margin The payment date of monthly pattern salaries can be set to a certain day of the month or the last Monday Tuesday etc Wages and salaries Salaries Monthly Qtr Ann m Monthly payroll r Salary r Payment Frequency Monthly Quarterly Annual Description General Fixed C Variable Frequency Monthly z Dept General z Annualised 276 000 r Payment of net salary to employees Day of month Last Wednesday 7 Method rm Tax and pensions PAY
181. ons you may choose to draw None or to enter a Manual amount Any manual amounts will be moderated by both the uncapped amount available and by the overall borrowing cap your lender has set for you The only time the cap will be exceeded by foreCASH is due to the application of a forecast interest charge onto the account foreCASH gt gt gt Company 115 ResellerPack Invoice Discount was 76 2 v 2 ABL CN testing recalc run local da File Edit Banksetup Drivers key accounts Openingdata Forecastdata Calculate cashflow Reports Flex Help E m OM 2 4 L ES vB 7 316 Bank Holiday O2Jan 2008 O3Jan 2008 04 Jan 2008 05 Jan 2008 Ot Tuesday Wednesday Thursday i 1 098 606 1 098 606 QO 0 0 Asset based lending ABL b f uncapped Sales impact 10 486 25 424 19 151 Collections impact 150 000 1 634 1 215 Rate change impact E Available today uncapped 1 098 606 1 259 092 eee 20 366 oO Drawn down 0 1 259 092 27 057 90 ICCA 0 Draw rule All All Rounded m C F in available uncapped 1 098 606 0 All 0 Interest and charges 0 0 0 Amount borrowed ABL 0 259 092 275 2 None 24 Cap 1 000 000 1 000 000 1 000 01 Rounded 00 Ledger balance Bank 1 302 478 314 814 cee tree 64 Borrowed 0 82 30 82 4 Exact Min Manual Reconcile As for sales on a given date the draw down amount can be locked by reconciling it however reconciling the draw
182. onthly Amount e 500 Day in month Last Wednesday 7 AddNew Delete now Page 122 of 182 E support foreCASH co uk fore CAS H 3 15 Calculate a Base Forecast Once you are happy with your Drivers Opening Data and your Sales and Stock forecast you are ready to calculate a Base Forecast This is run by selecting gt Calculate cash flow gt Calculate and display You now have your Base Forecast By default the display you will see on the screen is of the Daily Cash Flow On the bottom right of your screen you will also have two buttons to change to e Weekly View of the cash flow see 7 2 e Monthly View of P amp L Balance Sheet Funds Flow and Cash Flow See 7 6 You can change the default view from daily to weekly or monthly via Reports gt Report Options 3 15 1 Clearing the Forecast At this point the Base Forecast is locked If you want to go back and amend supplier rules or base forecasts you need to clear the current calculation This option is accessed by selecting gt Calculate cash flow gt Clear calculation and amend base data gt or from v2 74 onwards from the status button If you clear the calculation you will lose any flexing reconciliation and rescheduling amendments you have made therefore it is important to check you are happy with you base data at this stage Creating a forecast Step 1 Step 5 Os ow os o Yn oO o Oo S calculation
183. ore purchase until O to 120 days after the purchase A cap can be applied to the overall facility When you run the forecast calculation foreCASH will convert this information into the overall facility level As it is likely that purchases are being forecast on a regular daily basis the facility forecast will also vary frequently You have the option to manually edit the facility once the precise amount available becomes known Page 27 of 182 E support foreCASH co uk fo re C A S H i 3 2 4 Asset Based Lending Invoice Discounting This section gives an overview of Invoice Discounting Asset Based Lending For further details please refer to section 10 For the ABL account you will need to set the rules governing e the advance rate that is the percentage amount your lender allows you to borrow against invoices e the proportion of sales outside of your key ranked customers groups that will be dealt with individually that are covered by the ABL agreement e the borrowing cap e interest rate and typical monthly charge Bank facility details Account Description LTSB CID sterling Asset based lending cleared draw Facility r ABL details Default advance percentage 85 000 Processing delay days Invoices hx Default borrowing cap limit 875 000 this ABL account S m all ABL Accounts Percentage of Pool sales that are factored oo Draw into account Barclays Curent gt Draw down tule fExactMin
184. ort foreCASH co uk fore CAS H Stock levels can be set by entering amounts manually or by using stock driver rules Stock driver rules set the e Maximum stock e Minimum stock e Stock days to be held These drivers determine a target stock Please note foreCASH will apply integrity checks meaning that stock levels may not fall as quickly as you hope if there is an insufficient sell through of products to use up stock or raw materials Step 1 Products services Step 2 Sales and CUS Single item stock Sheds super Has stock Vv Has WIP N Stock calculation method JUse max min days drivers Mar 10 Apr 10 May 10 Jun 10 Jul 10 Aug 0 0 D D D Maximum stock 1 000 000 1 000 000 1 000 000 1 000 000 1 000 000 1 Stock days 30 2000 an an 30 Target stock 32 000 21 3 Copy to all later gt gt 32 000 _ Stock B F 0 32 00 lt lt Copy to all earlier 32 000 Additions 64 000 21 3 Cancel 32 000 cos 32 000 32 00 a a 32 000 Stock C F 32 000 21 333 32 000 32 000 32 000 Minimum stock WIP calculation method Manual entry Mar 10 Apr 10 May 10 Jun 10 Jul 10 Aug Stock B F 0 5 000 5 000 5 000 5 000 Additions 69 000 21 333 42 667 32 000 32 000 to Fin goods 64 000 21 333 42 667 32 000 32 000 Stock C F 5 000 5 000 5 000 Note the option to use F2 to copy values to later or prior months Page 91 of 182 E support foreCASH co uk fore CAS H
185. oun To edit details click on an item from either of above grids To Reset ranked Reset pool promote demote items to from the top 9 use the Suppliers Top 9 tab View ledger No No No No General OH No Property No General OH No Direct cost No default No Direct cost No Direct cost No default No default No cos No Property No cos Na General 0H 30d 2 15 30_ Cheque 30d 1 last___ 61 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 61 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6 Cheque 30d 1 last___ 6l Cheque 30d 2 15 30_ Cheque 3Nd 1 last Fil Chenue INNNNNNNNNNNNNNAN Jao0o0000000000000 The process for customers mirrors that for suppliers Page 53 of 182 E support foreCASH co uk fore CAS H 3 5 5 Table of business terms As there are many options for terms of business it is worth learning the protocol used in foreCASH for describing terms Xd Y z zz zzz A B nnnnnnnnnnn where Xd is the minimum days credit Y is the number of payments made each month or the payment day of each week if weekly payments take place and Z ZZ ZZZ is if applicable the date s of the month that payments take place A B is the range of days credit received and nnnnnnnnnn is some additional narrative description
186. p usa Project code f Project name Proj 09a r Project revenue invoicing Default invoice payment terms Retention invoicing if applicable Specify for project as a whole Specify for each stage Basis a4 days Net month end x Period fe x Monthis 7 r Project stages Stage Amount Inv Phases Retention All 22 000 10 000 8 5 000 1 250 1 6 000 1 750 2 m Invoice phases for stage 5 Stage5 Phase amot Phase Perc i ny Point gt Terms gt Delete 33 33 End of this project plus O days Project Default Delete 56 67 End of this project plus 0 days Project Default Delete 75 10 00 Retention If retention applies the retention period can be set in days weeks months quarters or years This will drive the invoice date after completion of the retention Page 87 of 182 E support foreCASH co uk fo re C A S H 7 Once invoice phasing has been specified use the Next button to move to the third project tab Summary ar of eevee MYOCD O1Jun 10 07 Nov 10 Invoice __22 000 Due date As Work Done Ej DMJun10 O8Jun 10 DJun10 1 000 14 Jul 10 08Jun 10 O6Jul 10 5 000 07 Nov 10 1 000 14 Dec 10 Export Inv Stage1 2 8 Stage 3 8 18Jul 10 07 Aug 10 250 Stage1 4 8 07 Nov 10 QO 14 Dec 10 07 Aug 10 07 Nov 10 Stage1 5 8 07 Nov 10 QO 14 Dec 10 07 Aug 10 07 Aug 10 Stage1 6 8 07 Nov 10 QO 14 Dec 10 St
187. port to excel the monthly reports a VAT summary report is included which gives an overview of the movement on the VAT and Import VAT balances t EE A D E F G H l J K L M Z_Demodata fcv 2 5 Feb 08 Mar 08 Apr 08 _ May 08 Jun 08 Jul 08 Aug 08 Sep 08 Oct 08 2 3 Std Vat rate 20 20 20 20 20 20 20 20 20 4 5 Sales 9 000 13 000 19 253 18 795 18 795 18 795 18 795 22 920 20 628 6 COS 13 730 21 135 21 730 21 730 21 730 21 730 25 735 24 275 23 850 7 Flex net 8 Cust rebates 871 2 501 3 854 2 531 2 074 5 976 2 444 2 024 6 794 9 Supplier rebates 4 115 30 719 3 389 3 335 36 221 3 407 3 636 39 165 10 Overheads and direct costs 581 5 532 821 628 7 628 828 628 5 686 863 11 Capex 120 120 240 120 120 12 Other income 200 200 200 200 200 200 200 200 200 13 Sub total 6 102 11 973 23 526 2 506 9 102 26 562 6 406 5 228 28 366 14 15 Import VAT reclaim 2 550 3 075 3 075 3 075 3 075 3 075 3 750 3 375 3 375 16 VAT On Activity 8 652 15 048 20 451 5 581 12 177 23 487 10 156 8 603 24 991 17 18 B F 15 843 24 495 12 701 7 751 2 170 6 758 16 729 6 573 7 759 19 20 VAT On Activity 8 652 15 048 20 451 5 581 12 177 23 487 10 156 8 603 24 991 21 Payment refund of VAT 26 843 A 3 249 a E 5 729 22 Payment refund of VAT flex 23 C F 24 495 12 701 7 751 2 170 6 758 16 729 6 573 7 759 17 232
188. ports top level main tab choose Import VAT second level tab VAT and Imports Corporation tax Import Duty m Import YAT parameters m HMRC account Have account with HMRC all Import VAT paid on 15th of following month No HMRC account import VAT paid straight to HMRC or to agent on other payment terms m Import YAT shipping date versus landing date Proportion of imports where processing delay around month end delays payment of Import VAT into following month Import VAT scheduled for payment is then net off the VAT payable in the next return following the goods arriving in the UK Page 37 of 182 E support foreCASH co uk fo re CA S H 3 3 3 Import Duty If applicable a general level of import duty can be applied to each ranked supplier and the pool COS Drivers and rules VAT and Imports Corporation tax Import VAT Import Duty Import Duty Rates and payment terms Supplier J COO2J C 7 Strict PANA00 Panasonic 7 Strict HDT 002 High Definition TY Corp 7 Strict SONY001 Sony Corp Strict PIONEEROO2 Pioneer TELACCO002 T ele Accessories Ltd 7 net Fortnight RADIOO09 Digital Radio UK 7 net Monthly DUTY_OTHER Smaller accounts where duty applies 7 Strict Pool O Strict change the relevant setting via menu option Drivers key accounts gt VAT and Tax from within the VAT and Imports top level main tab choose Import Duty second level tab The pay
189. pping 3 Validate r Do you want to import the Supplier or Customer ledger Supplier C Customer File to import C Users dger Documents4201 O foreC4SH sub_task_specification 409 testing import data suppliers121022_Disti_Demo_with_extraFields xls Close Next gt Page 42 of 182 E support foreCASH co uk fore CAS H j Please note that when importing Excel files if foreCASH detects ten consecutive lines that are blank in the first column it will assume it has found the end of the data that needs to be imported 3 4 2 Ledger import settings mapping In order to limit any manipulation of the ledger data exported from your accounting system foreCASH allows you to set up your own mapping of the field order and fields present Ledger information can be imported from either a Microsoft Excel or comma separated variable CSV file The first time you import a customer and a supplier ledger file you will need to set up the field mapping Settings which govern field order and field existence In subsequent months these will be remembered and so if the import file format is maintained you will not need to amend the settings Import supplier ASH sub_task_specification A09 testing import data suppliersi21022 Disti_Demo_with_extraFieldsods 2 Set mapping 3 Validate 4 Imported m File format Flexible format aged columns option extra information fields summary by account or by
190. predefined schedule of capital repayments and interest payment dates Simple loans can be scheduled using the Autocalc loan option More complex loans should be scheduled using the Manual loan option As well pre existing loans future loans can be scheduled foreCASH will calculate the opening loan balance for your forecast period for inclusion in the balance sheet Only include the relevant loan advances repayments and interest payments will be included in the cash forecast 3 2 5 1 Autocalc loans If your loan follows a simple regular pattern use an Autocalc loan if the pattern is more complex you can enter all details manually An Autocalc loan allows you to define the loan repayments based on a fixed total amount or a fixed capital element Page 32 of 182 E support foreCASH co uk fore CAS H Auto calc loan Step 1 settings Step 2 summary a Type Autocale loan bd Description RBS Loan repayable in quarterly installments Initial amount 10 000 Start date D M 01 Apr 2008 Repayment frequency C Monthly Quarterly C Annually Payment day Last Day z Number of repayments 3 Last repayment 1 2009 Repayment profile Regular capital amount Regular total repayment amount Set up method C Repayment amount Interest Rate Annual Rate per quarter Rate percentage 10 000 2411 lt Back N
191. rade these can be entered at this stage The forecast needs to know where it is starting from so you must enter opening information for bank balances including un reconciled amounts opening stock balances and any significant accruals brought forward Opening fixed assets finance leases and share capital may also be entered In default standard mode your sales and stock levels are entered based on the key accounts you set up in step 5 Margin levels can be varied across ranked suppliers or products In item product mode sales levels are set by key item product groups Some costs are directly related to the level of sales or purchasing activity You can set up such costs as a percentage of the sales or purchases in a given month Direct costs can also be entered as specific amounts Page 17 of 182 E support foreCASH co uk Step 9 Overheads and taxes Set salary information Set regular and irregular overheads Step 10 Capital expenditure and new finance leases Step 11 Rebates and cash discounts Step 12 Other income Step 13 Dividends and new share capital Step 14 Calculate foreCASH Salary settings can accommodate variable elements related to sales or margin forecasts Regular cash flows such as rent rates and other overheads can be set up to repeat on a monthly quarterly or annual basis throughout this and subsequent forecasts Irregular overhead payments can also be configured If
192. rchasing activity High Definition TY Corp Sony Corp Pioneer Tele Accessories Ltd Digital Radio UK Panasonic High Definition TY Corp Sony Corp Pioneer Tele Accessories Ltd Digital Radio UK New bus terms_ New amounts 30d Tlast___ 60 30 30d 1 last__60 3 30d 1 last___60 3 30d 1Jast__60 3 30d 1last___60 3 30d 1 last___60 3 30d 1 last 60 3C 1 586 250 00 828 375 00 403 781 25 160 387 50 0 1 371 930 00 465 300 00 Page 68 of 182 Further details Further details Further details Further details E support foreCASH co uk fore CAS H 3 6 4 2 Manually scheduling supplier payments Any suppliers set with manual allocation will offer the chance to click here which will bring up a Calendar View that allows the allocation of payments over the forecast period Manual Allocation Supplier name Panasonic Supplier id PANAOOZ merona a4 0 Opening Data Manual 30 60 days J 0 Suppliers Man CN 0 30 days 1234900 Manually entered pa GIT GRNI credit note accruals al Total amount 12 349 00 Supplier ref Outstanding to match base figure J 349 00 12 000 00 0 12 000 00 29 Feb 2008 0 Page 2 lt gt Save Close pe of 13 e 3 6 5 Opening customer balances sales ledger The import of the file containing customer balances was addressed in 3 4 Manual allocation of receipts mirrors the process described for payments in section 3 6 4
193. re the calculation of the cash flow you can view a preliminary Profit and Loss report As the cash flow calculation has not been run interest charges have not been calculated and so the report stops at the EBIT Earnings before interest and Tax level 6 2 View forecast post calculation of cash flow Once the cash calculation has been run interest charges and corporation tax will be applied to your Profit and Loss forecast The Profit and Loss forecast is shown on a monthly basis Monthly balance sheet reports funds flow reports and cash flow reports are generated alongside the profit and loss After calculating the cash flow you can opt to access the cash flow report in monthly weekly or daily detail You can switch from one format to another once opened In monthly format you can also view the P amp L balance sheet and funds flow reports In daily view you have the ability to re schedule or reconcile the cash flow forecast see steps in sections 4 1 and 5 3 Page 141 of 182 E support foreCASH co uk fore CAS H a 7 Reports Please note certain Reports are only available after a cash flow calculation has been run and the cash flow report is being viewed The primary report in foreCASH is the daily cash flow report From here you can navigate to a weekly or monthly cash flow report You can change the default view from daily to weekly or monthly via Reports gt Report Options Report options r Default cash fo
194. recast view period Set whether default cash forecast view is Daily Weekly on Monthly Daily Show mid week month max deficit min headroom When exporting weekly or monthly ll cash flow report include mid week month max deficit min Vv headroom gt Show monthly cash flow Il detail When exporting monthly cash flowfll report as part of multi sheet report include detail by customer rr and supplier account r Show monthly cash flow Il sales COS and stock movement memorandum data When exporting monthly cash flow II report include memorandum data on sales COS and change in Vv level of stock to aid the understanding of cash flow If you move into the monthly cash flow report mode you also have the option to view monthly P amp L and balance sheet reports Screen print reports can be generated as an integral part of foreCASH The main forecast can also be exported as a comma separated variable CSV or Microsoft Excel file In addition there are a number of primarily graphical reports that are generated by the foreCASH reports module These reports are generated with the assistance of Crystal Reports XI You do not require a full installation of Crystal Reports in order to view these documents as a viewer is deployed under licence within the foreCASH reports application From within the foreCASH reports module you can export reports into Microsoft Word Microsoft Excel Adobe Acrobat PDF
195. rking days to clear Bank reconciliation a schedule which explains the difference for a given bank account between the balance recorded by your bank and the balance shown in your accounts system Differences arise because cheques you have issued have not been presented to the bank or because a cheque you have received has not yet been processed and cleared by the bank Business terms see Terms of Business Calendar View a format in foreCASH where entries are made by entering values on specific dates one month at a time Capex capital expenditure expenditure on items that will be used within a business for a number of years such as IT equipment or machinery CHAPS Clearing House Automated Payment System a form of electronic settlement that clears on the same day it is initiated Cleared payment receipt a payment or receipt that is recorded in both your accounting system and your banks records COS cost of sales the cost of goods or services that is incurred in fulfilling a sales order for example through the issue of a product to a customer Creditor a company that has extended credit to you a company that you owe money to Creditors Ledger a list of Creditors and the amount of money you owe them usually in an Aged Format CSV comma separated variable a file format often suitable for import Customer Ledger a list of Customers and the amount they owe to you usually in an
196. rt data POP_SOP POP_ItemMode_c161v3 xlsx Page 92 of 182 E support foreCASH co uk foreCASH iii Set mapping and options You can specify the existence of any header or footer data which will be excluded from the data import as well as the order column that the required information sits in Purchase Order Committments import 1 Choose accounts 2 Select file 4 Validate m Header and footer for exclusion from import rm Header footer and sheet Sheet Poc v Account reference ER ja First line s contain headers Arrival date invoice point In column e z J Number of header lines to be oa anon Incom 30 excluded from import 1 9 Last line s contain footers totals IV Get payment due dates from import file In column fap 7 IT Number of footer total lines to be zj excldued from import J Get shipment date from import file In column 5 Purchase orders include duty if applicable JV Include POs in GIT when shipped For x Days prior to landing First lines C161 v3 test di offie Ac code expected amt pay date ship date other other 2 15 01 2008 80 000 14 02 2008 18 12 2007 04 02 2008 10 000 05 03 2008 07 01 2008 24 02 2008 5 000 25 03 2008 27 01 2008 15 03 2008 4 000 14 04 2008 16 02 2008 04 04 2008 4 000 04 05 2008 07 03 2008 24 04 2008 4 000 08 06 2008 27 03 2008 14 05 2008 4 000 28 06 2008 16 04 2008 20 03 2008 4 000 04 05 2008 21 02 2008 03 04 20
197. s Print Screen Ctrl P Set Master Currency Clear this entire forecast and settings Backup data for this forecast version Exit foreCASH applies a date stamp to the file name to indicate the date the backup was made but you may rename the file as required If you have a network enabled version of foreCASH you can also copy companies from your local PC drive to a shared or network folder location Page 7 of 182 E support foreCASH co uk fo re C A S H 2 First time use and security keys On first use you will be asked to provide some user and security information The company name you enter is not security critical but will appear on many reports generated by foreCASH The software code sequence will have been provided in your order confirmation e mail and or will be shown on your CD box Register Details Company details Master Company name Tip use the TAB button gt Jon your keyboard to move between boxes on a form Software code sequence All keys are time limited and will need to be refreshed on a periodic basis usually annually Your initial security keys and software licence expiry date will have been issued with your order confirmation e mail mE Security Details le Number ZIU 07 06 Comp Unlock pass number fio m fiz fis fia fhs Expiry mm py 03703 Max companies 5 Expiry confirmation number fo B le z le EE Tip use the TAB button gt on your keyb
198. s N only one for every day of month UserDefined A B Strict Two user defined strict payment terms can be N S only UDTa_ x _days_strict set by the user The user may set the payment terms from 1 100 days via the General Drivers tab UserDefined C D Strict Two user defined strict receipt terms can be N C only UDTc_ x _days_ strict set by the user The user may set the terms from 1 100 days via the General Drivers tab This option can also be useful when modelling credit card receipts Rent and Rates Cc Cc o o 4 4 10over1 2AJ 1 Apr to Jan payments 1 Ledger assumed to contain the remains of an SP only 10over1 2AJ 15 Apr to Jan payments invoice scheduled to be paid over ten UDT 15 instalments from April to Jan The total balance will be split between into 1 10 payments depending on how many payment months remain up to next January Payments are paid on the 1 15 day of the month Payment day in month can be edited via the user defined terms options Page 56 of 182 E support foreCASH co uk Terms reference code past 10over12MF 15 May to Feb payments 15 25d 1 25 55 25 25 days net month end Manual or Import Manual entry Import list Miscellaneous 30d 3 5 15 25 35 25 days on x5th 45d 3 5 15 25 50 45 days on x5th 45d Wed 52 45 days Wednesday 30d_Pool profile 60d_Pool profile 90d_Pool profile 30d F ri Payment Plan 90d F ri Pa
199. s can be added to the parent item of a change Bank Data Calculate Reports Flexing Help PS EN 360 01 Sep 07 02 Sep 07 03 Sep 07 04 Sep 07 05 Sep 07 06 Sep 07 07 Sep 07 08 Sep 07 09 Sep 07 10 Sep 07 11 Sep 07 12 Sep 07 13 Sep 07 Saturday Sunda Monday Tuesda Wednesday Thursday Friday Saturday Sunday Monda Tuesday Wednesday Thursday E 2 370 012 85 003 100 000 0 0 0 2 637 072 367 059 367 059 1 185 006 0 0 0 0 0 0 0 0 0 0 0 i 0 0 0 0 0 0 0 3 300 009 2 370 012 85 003 Details gt feako detai Account A4PAPE002 04 Sep 07 367 060 Operation Origin date Parent date Value date Current amt Cascade amt Create date Comments 330 Base Past Parent na 04 Sep 07 04 Sep 07 04 Sep 07 1 101 178 Base Past 1 001 1 Child Spread 04 Sep 07 04 Sep 07 04 Sep 07 734 118 30 Aug 07 Clicktoadd O Outstanding 1 002 Child Spread 04 Sep 07 04 Sep 07 05 Sep 07 367 059 30 Aug 07 1 003 Child Spread 04 Sep 07 04 Sep 07 06 Sep 07 367 059 30 Aug 07 Page 135 of 182 E support foreCASH co uk fore CAS H j 4 2 Flexing sales and stock levels Changing the stock and sales forecasts can alter cash flow significantly When making such changes it is important to remember that modifying your base case sales and stock levels may carry a cost In Supp lt gt Cust mode foreCASH allows you to vary the percentage gross margin achieved on flexed sales In ltem Product m
200. s such as a retailer should consider setting up some suitable groupings that help reflect the structure and payment terms of its customers e g Smith Stores Limited operates from two branches and also operates a web site All the web customers pay by credit card but visitors to the branches can pay by cash cheque or credit card The Merchant Services Provider retains credit card payments for 30 days before transferring money into Smith Stores bank account These arrangements can be modelled in foreCASH by setting up three customer groups with the following terms and payment methods Smith Stores Ltd Customer groupings Customer group name Customer Code New Business Terms reference code Collection Terms Method Branch A cash ACASH Retail A ___cash cha cards mix 2 Branch B card BCARD Retail B RetailB cash chq cards mix Cash 3 Web WEB 4 days User defined C _ strict TT TT electronic telegraphic transfer Page 60 of 182 foreCASH Three different retail mixes can be configured in foreCASH The mixes reflect the proportion of sales paid by cash cheque and two categories of credit cards The delay expected before cleared funds reach your bank account can be set for each element E support foreCASH co uk Retail collection mix Payment plan settings Strict UDT Net M E UDT r Receipt mix details Share of sales Days delay Retail mix A Cash J wf 79 Retail mix B Retail mix
201. s without a formal accounting package If you do not use a formal accounting package to record your customer and supplier invoices you will need to summarise the balances due from to customers suppliers in a spreadsheet ready for inclusion in your forecast When summarising your invoices you should use one file for customers and a second file for suppliers You have the option of i importing a list of invoices giving the Account Code invoice date and Amount or ii creating an aged ledger report If creating an aged ledger You should use a single line to summarise each customer supplier For each customer supplier you should provide the following information Customer supplier name Customer supplier code this could be an abbreviated form of the name Total balance the total balance outstanding At least one and up to nine aged balances the aged balances show the ageing split of the total balance That is the value of invoices that were raised last month two months ago three months ago e g A customer called Smith Brown and Co owe you 5 000 relating to invoices from January 10 000 relating to February 7 500 relating to March and 8 000 relating to invoices from April You decide to summarise the situation in a spreadsheet as follows Name Code Total M 2 M 3 and older Smith Brown SMITHB 30 500 8 000 7 500 Pee Co Note how the balances from January and February were combined in the
202. t able to clear through bank accounts and hence the foreCASH cash flow which reflects cleared payments on weekends or bank holidays You may add to or edit the pre set list of bank holidays You may also set up a list of Shut down days these are where the banks are open but your business is not No purchases or sales will be forecast for days which are marked as Shutdowns this may be important for modelling the impact of sales on your ABL accounts 14 3 Past new and flex lines foreCASH splits the transactions for each supplier and customer into a number of categories including Past New and Flex This is done because of the varying levels of certainty that are attributable to each category Past items are based your imported ledgers or other opening figures As such the amounts should been seen as fact New amounts are based on sales and stock estimates and therefore attract a greater level of uncertainty In turn a beneficial flex above a base forecast such as over achieving sales might carry a further level of risk or variability Page 175 of 182 E support foreCASH co uk fo re C AS H j 15 Terminal Server Installations It is possible to run multiple copies of foreCASH on a single PC or server at the same time such as is necessary when running an application on terminal server All intended users of foreCASH will need to have access to the program data directory found at C ProgramData Wellk
203. ted when the forecast date was set then foreCASH will allow you to enter sales based on products sales items or projects Sales by product can be based on e an amount in base currency or foreign currency e a number of units and the sales price per unit in base currency or a foreign currency e asa project with one or more defined stages In this mode there are three possible levels of stock e Raw materials e Work In Progress WIP e Finished Goods Items can be set to have no stock such as service items finished goods stock or WIP and finished goods stock Project items have WIP but not finished stock There are four stages to building a item product mode sale and stock forecast and the sales forecast is based around products product groups Page 79 of 182 E support foreCASH co uk fo re C A S H a 3 7 1 1 Product group or item definition Define e tem product group names Department category up to three levels of category available see 3 9 The sales input method amounts units or specify as a project Whether item has finished goods stock or WIP Set to No for services Whether item is sold to a single customer or a group of customer or has its own terms collection pattern o If an item has its own terms collections pattern the item can be set to be invoiced in arrears for example if work is performed but not invoiced until the next month once timesheets have been collated e
204. the business that is not a Cost of Sale such as rent rates salaries Past transaction in foreCASH a payment or receipt to settle a transaction that occurred before the start date of you forecast such as the payment of an invoice from your imported suppliers ledger Payment Plan a user defined set of terms detailing the start point and number of weeks over which invoices will be settled by customers Payment Release Control a report in foreCASH showing items due for payment in the next ten days from which you may approve for release or mark for deferment each item Prepayment an asset recorded in your balance sheet reflecting that you have been invoices for goods or services you have not yet received Prepayments are driven by invoices and do not reflect whether payments have actually been made P amp L profit and loss account a record of the income expenses and net profit loss of a business over a given period POD proof of delivery a document from a courier company typically detailing the weight and time of deliveries made to your customer A POD may be demanded by an Asset Based Lender in order to prove a sale invoice is genuine and valid security against which to lend money POC Purchase Order Commitment s orders already placed at the start of the forecast where invoice and goods not yet received but order cannot be cancelled and must be paid for during the forecast Product Mode see Item
205. the item into the forecast level of New finance leases foreCASH fixed assets in your balance sheet and apply a depreciation charge If you change the start date of your forecast and opt to roll the data foreCASH will look for lease items that should be capitalised and placed into your opening fixed assets 3 12 Rebate schemes and cash discounts 3 12 1 Some customer sales and supplier purchase agreements involve volume or target rebates that in effect refund part of the sales purchase price of items foreCASH allows you to Rebate Schemes model rebates that accrue on a daily monthly and quarterly basis Rebate scheme settings are entered via Forecast data gt Rebate schemes and cash discounts Rebates and cash discounts E Supplier rebate rates on new business and cash discounts Tu Edit rebate and cash settlement discount schemes p Key Customer Key cc001 Key Key Key GP GP Ger Customer rebate rates on new business Daily basis m Prompt settlement discount percentage of net invoice Percentage rate 0 Days delay 30 Percentage rate past ledger b f 3 00 Effective when paid Galesauk basis G Percentage rate new activity 3 00 Effective when paid m Monthly basis m Returns Monthly basis Percentage rate 20 00 Days delay 30 Percentage rate l 0 Days delay 0 Ea are Goods returned are assumed to be damaged and have
206. tion If some invoicing was expected to already have taken place at the start date of the forecast it will be assumed that the relevant invoices have already been posted to the suppliers ledger If the invoicing from your supplier is behind schedule or an invoice has not been posted to the suppliers ledger at the expected time you can force foreCASH to accrue the relevant amount in the lower grid Page 117 of 182 E support foreCASH co uk foreCASH Step 3 involves scheduling the payment of any invoices scheduled to be received after the forecast start date Irregular complex expense Step 1 expense description Step 2 invoice schedule New Invoicing OlJul 2008 02 Jul 2008 O3Jul 2008 10 Jul 2008 16Jul 2008 17 Jul 2008 23Jul 2008 24 Jul 2008 30Jul 2008 Any unallocated amounts will be excluded from the cash flow forecast Page 118 of 182 04 Jul 2008 11 Jul 2008 18Jul 2008 25Jul 2008 Step 3 payment schedule 12Jul 2008 13Jul 2008 O6Jul 2008 13Jul 2008 20Jul 2008 27 Jul 2008 14 Jul 2008 21 Jul 2008 28 Jul 2008 E support foreCASH co uk fore CAS H 3 11 Capital Expenditure and New Finance Leases 3 11 1 Capital Expenditure To model capital expenditure patterns there is a specific section Forecast Data gt Capital expenditure gt The capital expenditure capex section allows you to add items of capital expenditure together with a payment schedule Pay
207. to from main bank account Each Day Single Target Level Always Action depends if balance positive negative Alyy ays Set to Zero Use full facility If positive balance Clear down to zero oe If balance exceeds 100 000 then lower to balance of 35 O00 If negative balance Always bring back to zero Cc If exceed facility bring back to zero C Bring back into credit balance of If balance exceeds facility then transfer funds to bring icy back 25 000 into facility Close Page 24 of 182 E support foreCASH co uk fo re C A S H i 3 2 3 Stock based lending import loans Some lenders provide facilities using stock as security The stock may be held by you already or be in transit from a supplier and may be linked to a letter of credit 3 2 3 1 Stock based facility month end stock level If your stock based facility is based on the level of stock you carry foreCASH can calculate facility levels based on your forecast closing stock at the end of each month For raw materials you can select which suppliers the facility applies to If you are operating in Item Product Mode and have manufactured goods you can also apply a percentage advance for any WIP or Finished Goods that your lender provides ks Account Description Stock Based lending Stock based lending Facility Interest and charges r Stock Based Lending Closing stock Import Loan C Percentage advance 201
208. tomers paying by cash or credit card 3 5 7 4 Adding New Customers using the ledger housekeeping Method s s s 35 7 5 Ledger report 6xporhy sencundananen an nilasciintiiinincteeatnenieiitapeiirasiseal sisi vidn natn nner neta 3 5 7 6 Credit notes and unallocated Cash in LEAQers c eecceseeseeseceseteeeeaeeesecaeeeseseaeeaeeeaesseeeaeeeaeseeesaeeeaeseesaesneetaeesaeseeteaeseatens 3 6 Enter Opening Balances eeeeeseeeeeeeeeeeeeeeees 3 6 1 Bank reconciliations 3 6 2 Stock and goods in transit 3 621 StOCK TCC niinn 3 6 3 Opening Salary and Tax accruals 3 6 4 Opening ledger balances allocated manually or by import 3 64 41 Importing alist of suppli6r payments ve sis cic teveewest ese vl cseeee adrian iy Ain asia eeeneci thai Page 2 of 182 E support foreCASH co uk foreCAS H 3 6 4 2 Manually scheduling supplier payments 0 0 0 0 ceeeeceesesseesceeseeeaetseeeaeeeeeseeeseseaeeseesaesseeeaesaesseeeaeeseesaeeeaesaeeaeeeaeseeseeseateas 3 6 5 Opening customer balances sales ledger 3 6 6 Opening credit note accrual 00 c eeeee 3 6 7 Other debtors 3 6 8 Other creditors and accruals 3 6 9 Fixed assets Si6H0 Finante leasesi ssieie viens nisin wide nie ete ia Eaa EA EAE a AnA Iate seas aeciraiiaa aise reeninederiea tannin 3 6 11 Share Capital and resem eS aicsin isnaad a a iain ani aeai a daa area EEE Daaa edia eraai au aiiin 3 6 11 1 R
209. tory PENINKOO2 Pen and inkcase Ltd PHONE4_0 Phones 4U Qyvcool QVC RDYASOO1 Robert Dyas RYMANSOO Rymans Aggregate multiple unranked accounts based on account balance Account balance gt 0 Re assign accounts already in a Group B and lt 1 000 Assign to group v Addito group Bl Saye Close To aggregate a number of accounts at once you can use the range based tool at the bottom of the screen Page 51 of 182 E support foreCASH co uk fore CAS H a 3 5 3 Setting Ranked Items Once you have imported your ledgers and set any aggregation of accounts you should set the rankings for the most important accounts groups gt Drivers Key Accounts gt Ledger drivers and key accounts gt If you are expecting a new customer or supplier which is not present in your ledgers to be significant in your forecast these can be added through the housekeeping Add new delete tab The Key Suppliers Customers tabs show the current balances for each customer and supplier and show the percentage of the current ledger that are represented by your ranked items Items can be added to the key accounts list by selecting an item in the left box and pressing the Add gt button Individual items are removed by selecting them in the right box and pressing lt Rem All items can be removed from the right box by pressing lt lt All Ranked items can be promoted demoted using the Up
210. total across my suppliers 1 Import data file must have a field order of Account Code Date Amount 2 When WIP is applied you are not currently able to apply sales flexing Revenue recognition phasing option must have been selected when forecast start date was set If you wish you can use the Customer analysis sub tab to assign key customer groups to cost centres departments see section 3 9 The screen shots in this section assume option a by customer then by supplier has been chosen Page 100 of 182 E support foreCASH co uk fo re C A S H s 3 7 2 1 Sales by customer Once you have entered sales forecasts in one month you have the option to quick fill later months e gt gt Copy total will copy the total in the month selected to all later months however the percentage mix by customer will remain unchanged e gt gt Copy each option will copy each individual value into all later months and will therefore result in the same percentage mix being applied to all later months e gt gt will copy the percentage mix by customer to all later months without changing the total monthly sales in later months e gt boxes can be used to copy the value or percentage for a single customer to the next following month If one or more accounts have been set to the Manual Import highlighted by cells with an orange background some of the quick fill options may be disabled
211. ty liability oo Salary commision 0 Depending upon where you are in your VAT cycle you may need to enter your opening VAT balance in two parts For example if your prior VAT quarter ended on 31 March but you have not yet paid over the VAT due this part of the balance would be entered in VAT gt prior return period section If your forecast start date is 1 May the VAT balance from April trading would be entered in VAT gt current return period VAT will be scheduled in accordance with the VAT settings in General Parameters except where part of an opening balance is assigned to a payment plan If you have agreed a deferred schedule of payments with HMRC you can enter the schedule using a Calendar View accessed via the Edit button Corporation Tax payments are scheduled manually using a Calendar View which can be accessed via the Edit Details button Page 66 of 182 Esuppot rrecasicouk SCCCSCAASSX 3 6 4 Opening ledger balances allocated manually or by import The import of the file containing supplier balances was addressed in 3 4 and in most cases these balances will be scheduled for payment automatically The exception is where you have selected the option for Manual allocation or Import payment list In these cases the Suppliers tab found via Opening Data gt Supplier manual allocations and credit notes should be used 3 6 4 1 Importing a list
212. unt a customer pays into supplier is paid from e Terms reference o This can be used to automatically set the business terms for a customer supplier e VAT code o This can be used to automatically set the VAT status of a customer supplier Page 44 of 182 E support foreCASH co uk foreCASH 3 4 2 2 Mapping Setting the order of Fields included in your file The order of the field descriptions can be changed by selecting an item in the fight hand box see 2a and then pressing the Up or Down buttons to promote or demote an item within the list This will change the headings on the top of the preview grid see 2b Items marked X are not used by foreCASH and will not be imported 3 4 2 3 Excluding the header and footer from your import file If your data file has a header and footer it will need to be stripped out Use the settings in box 3a see above to specify the number of rows to be excluded max 10 The excluded rows are shaded in the preview grids 3 4 2 4 Check the sense of supplier ledger imports For supplier ledgers it is important that you correctly set the radio button see box 4 above determining whether amounts payable are represented by a positive or a negative balance in the file being imported 3 4 2 5 Automatic ranking of new accounts If you frequently have major new customers or suppliers being added to your ledgers you can opt for foreCASH to rank an
213. up A COS supplier which feeds into another supplier will have its stock balance zeroed at the end of each month by a stock transfer into the relevant receiving supplier see section 3 7 1 5 2 If a COS supplier feeds into another account it will not be available as a COS element of an item product Page 65 of 182 E support foreCASH co uk foreCASH 3 6 3 Opening Salary and Tax accruals Any salary or tax accruals should be entered on this screen PAYE amp NI will be scheduled in accordance with the settings in General Parameters except where part of an opening balance is assigned to a payment plan If you have agreed a deferred schedule of payments with HMRC you can enter the schedule using a Calendar View accessed via the Edit button Opening Data Manual entries Salary and taxes Please enter opening salary and tax accruals in the cells below m PAYE and NI VAT gt prior return period closed VAT quarter period r Corporation tax PAYE N I 2 000 VAT liability refund due D Opening liability asset 1 000 PAYE N I on payment plan 0 Edit VAT on payment plan 0 Edit Schedule of payments 1 000 Edit refunds PAYE N total J 2000 VAT prior return period total J D r Pension VAT gt current return period Pension 0 VAT liability refund due 35 000 r Payroll accruals over payments r Impor duty gt current return period CASSEL TSE 0 Import du
214. vity 350 003 z c SupB flexing 17 SupB reconciliation 18 Sub Total 350 003 0 0 0 a 0 500 000 O 00 000 100 003 100 003 o 0 1 400 003 1 100 003 0 4 999 000 7 999 000 mEn nET aasas m 7 amp i hold 8 8 203 e e a g o o o o o lo o o o o o o o o o o o o o o o lof o o o l o o o jo o o o o o o o o o o o o o o oO 0 0 0 0 0 oo PS cles ests 41 All outside top 5 a 170 006 85 003 50 000 78 Hon stock payments 1 100 11 000 mw 1 Gi Payments Total 1401 11 000 2 720 015 o O 85 003 1 999 000 o 0 o 0 o o 100003 550 000 o 116 Receipts 117 Receipt from factor 0 o 0 118 Customers top 5 100 000 200 000 1 750 006 o 0 0 0 0 oO 0 0 o o 0 1 500 003 602 803 40 1 000 000 155 Customers other 10 85 003 42 502 42 502 135 004 192 other receipts 193 mKGsaa 199 Sub Total o o 0 o o o 0 o o o o o o o o o 205 Receipts Total 100 010 200 000 1 835 009 o O 1542505 602 803 42 502 o o o o o 40 1 135 004 o 206 Exchange gain loss 7 gt formatted linked data lt gt i Draw a dl es adl o g AET Ready Page 145 of 182 foreCASH E support foreCASH co uk 7 4 Cash bank statement view Current account balances and movement can be shown in a
215. y new accounts it finds see box 5 above Page 45 of 182 E support foreCASH co uk fore CAS H j 3 4 3 Validate the file The third step validates the file prior to importing the data If any of the rows of data you are planning to incompatible with the format that foreCASH is expecting you will see some cells highlighted in red and will receive warning note in the box below the grid Import supplier cation A09 testing import data ledgers xls sense check suppliers081002_Disti_Demo_minusnumbers xis Select File 2 Set mapping i 4 Imported Name 781 007 729 731 Oyez Print Group 13 400 12 500 Hertz Group x 6 000 345 970 14 SE ELECTO SE Electricit 765 15 BGAS001 _ British Gas 761 16 GBCOUNCI G Borough Council 2 3 256 17 BUSPOSO0 Business Post 6 252 18 TNTOVNOO TNT Ovemight J 12 000 19 STPROPOO ST Property Services l 20 000 20 PRUDENOO Prudential l 4 000 21 ABCWHAOC ABC Warehouse Automation 0 22 SONY001 Sony Corp 75 870 23 PIONEEROC Pioneer 2 57 400 24 J CO02 JVC 127 892 25 PANAOO Panasonic 125 777 26 HDTVO02_ High Definition TV Corp 5 100 000 27 RADIO009 Digital Radio UK J 30 000 no ref 30 000 me refere 30 000 30 000 30 000 ooooooqcoooqcoooqooqooqceooo Ojo ooooococoococcocecc cee cece 0c 9e 0c 0c 0 00 Ojo gqgoooooooqcooocoaoooc0coo e20coo Ojo oooocc cc ccc cc cc ccc ccc c oO o oooooocooceceoceceoeoee eo Sa S
216. y of the supplier elements that make up the costs Then enter COS data A foreCASH gt gt gt Company 128 Z_Demodata v 2 Demo_manufacturing local data St 01 03 2010 Lgth 15 File Edit Banksetup Drivers key accounts Openingdata Forecastdata Calculate cash How Yiew Forecast Reports i ae eo Pea Step 2 Sales and COS Mar 10 Apr 10 May 10 Jun 10 Jul 10 Aug 10 Sep 10 171100 171 000 171 000 171 000 171 000 171 000 171 000 127 010 127 000 127 000 127 000 127 000 127 000 127 000 44 090 44 000 44 000 44 000 44 000 44 000 44 000 25 77 25 73 25 73 25 73 25 73 25 73 25 73 Single item Sheds general Mar 10 Apr 10 M au aly ae al an L als ep 10 edit 75 000 75 000 75 000 addele 60 750 60 750 60 750 60 750 60 750 60 750 60 750 TIMBEROO edit f 45 000 45 000 45 000 45 000 45 000 45 000 gt of Sales 60 00 60 00 60 00 60 00 60 00 60 00 60 00 PLASTICOO2 edit 2 250 2 250 2 250 2 250 2 250 2 250 2 250 FELTRO002 edit 6 000 6 000 6 000 6 000 6 000 6 000 6 000 edit 7 500 7 500 7 500 7 500 7 500 Page 82 of 182 E support foreCASH co uk fore CAS H To add a new cost element to a product use the button at the bottom left of the screen A foreCASH gt gt gt Company 128 Z_Demodata v 2 Demo_manufacturing localdata 5St01 03 2010 File Edit Banksetup Drivers j key accounts Openingidate Forecast date Calculate cash ow View Forecast f Bia 0m 24 2
217. yment 16 667 16 667 0 33 333 16 657 0 0 0 0 0 0 0 Dividends 0 0 0 0 0 0 0 1 000 0 0 0 0 New Capital 0 0 0 0 0 0 0 1 000 0 0 0 Cash flow 7 535 80 582 23 341 113 319 125 012 72 556 84 395 136 580 48 204 79 346 51 519 116 684 157 24 Opening net cash debt 93 366 83 373 145 686 163 027 243 013 356 606 429 162 513 557 649 364 697 567 776 914 827 638 944 32 Cash inflow outflow 7 535 80 582 23 341 113 319 125 012 72 556 84 395 136 580 48 204 79 346 51 519 116 684 187 24 Lease net change 862 1 602 0 0 752 0 0 773 0 0 795 0 Loans net change 16 667 16 667 0 33 333 16 667 0 0 0 0 0 0 0 Closing net cash debt 83 373 145 686 169 027 249 013 356 606 429 162 513 557 649 364 697 567 776 914 827 638 944 322 1 101 56 Cash foverdraft ABL 7 535 88 118 111 459 224 778 349 790 422 345 506 740 643 320 691 524 770 870 822 389 939 073 1 096 31 Finance leases 3 171 7 569 7 569 7 569 6 817 6 817 6 817 6 044 6 044 6 044 6 249 5 249 5 24 Bank loans 66 667 50 000 50 000 16 667 0 0 0 0 Closing net cash debt 83 373 145 686 169 027 249 013 356 606 429 162 513 557 649 364 697 567 776 914 827 638 944 322 1 101 56 4 gt 2 Export Print Close Having produced your first forecast the process of producing a forecast in subsequent months becomes much quicker as steps in sections 3 2 to 3 5 w
218. yment Plan foreCASH Description Notes Ledger assumed to contain the remains of an SP only invoice scheduled to be paid over ten UDT instalments from May to Feb The total balance will be split between into 1 10 payments depending on how many payment months remain up to next February Payments are paid on the 15 day of the month Payment day in month can be edited via the user defined terms options 25 days net month end A single payment on P Only the 25 day of the month following purchase or sale Useful for 25 of month rent payments Use a calendar view to allocate payments to All P any banking day of the forecast Only ranked N User to import a schedule of payments by date P only from an excel or csv file Average of 30 days credit but with three payments per month on the 5 15 and 25 of the month Payments occur 35 25 days after the sale purchase Average of 45 days credit but with three payments per month on the 5 15 and 25 of the month Payments occur 50 45 days after the sale purchase Minimum of 45 days credit Payments made weekly on every Wednesday Payment occurs 52 45 days after the sale purchase Primarily 30 days net month end but with CP only element outside of standard terms Primarily 60 days net month end but with CP only element outside of standard terms Primarily 90 days net month end but with CP only element outside of standard terms PO Payment pla
219. your business incurs capital expenditure a schedule of expected payments can be entered using a Calendar View If you plan to finance fixed assets via new finance leases schedules of payments can be created If you offer your customers volume related rebates or if your suppliers offer a rebate scheme to you foreCASH can model the P amp L and cash effects of the schemes against each key ranked account group Enter other income such as royalties on a regular or irregular basis if applicable You may schedule dividend payments or cash receipts from new share issues using a calendar view You have now provided all the information needed by foreCASH to produce an initial forecast and a calculation can be run Running a calculation produces the daily cash flow From here you can select the weekly or monthly view The monthly view includes P amp L balance sheet and funds flow reports Page 18 of 182 E support foreCASH co uk fo re C A S H i 3 1 Setting the start date length and mode of your forecast Select gt File gt Change start date from the menu bar then enter the starting month for your forecast The format for the data entry should be mm yy that is two digits for the month and two digits for the year separated by a forward slash For example 03 07 should be entered for a forecast starting in March 2007 By changing the start date you are creating a new forecast If this is not your first forec

foreCASH User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents