CASHUG - Cash Usage/Flow
What is
The cash flow reports, using value date and estimated maturity (TRADE) for each currency, separating debtor and creditor positions, using accounting values and the contents of the physicals trade database for non-invoiced purchases and sales.
The objective is, using expected maturity dates, to show the movement in/out by date. There are several options to map the 'Time' columns by days, weeks, months.
The report matrix is columns of dates/periods and rows of 'already invoiced and not matched', 'cash not yet used in matching', 'not yet invoiced', ‘pre-payments’, ‘F&O Liquidation’, ‘Costs not invoiced’ and ‘workable LC’ values.
The accounting rows use their value date to determine which column to populate. The accounting includes posted items and those marked as 'held' in the DOCENT subsystem i.e. authorised but not yet posted because of their forward accounting dates.
The rows identified as 'not yet invoiced' and ‘costs’ use their TRADE 'expected maturity date' as maintained on each contract part. The value of yet to be invoiced is determined by also applying the TRADE/Final Invoice required setting whereby TRADE which have been invoiced but are indicated as requiring a Final will be included in the analysis. The ‘pre-payments’ are sectioned with Cash advances to suppliers in Debtors and Cash Deposits from customers in Creditors.
The ‘F&O Liquidation’ value is a net value to be shown in either debtor or creditor and is considered as Spot for it’s column presentation.
TRADE that are designated as 3rd Party or Brokerage or Spot or Internal are excluded from goods cash flow, as will be TRADE that are closed..
There is an option to only include TRADE that are allocated; using this feature will exclude future commitments that might not be shipped /delivered.
The workable LC row using the LC Expiry date to position it’s value. The value reported is the total LC less any drawings made.
Other selections are;
- To show individual currency pages or consolidated into your specified target currency using spot exchange rates.
- To sequence the report by department, counter-party or single summary
- To report TRS/FX positions i.e. non-matured FX deals; only available when individual currency pages selected
- To include costs/commissions from open status TRADE which are not brokerage, nor internals nor Spot classified
- To show NOM budget/forecasts when the report style selected is Month Columns. All NOM budgets for those periods will be accumulated and shown so sale proceeds, Purchase costs and Overheads would be offset to show one value.
Filtering, using CLI static, is also available.
You can drill-down to view the detail when the 'summary' report style is used and the results are shown in target currency equivalent.
See CCYEXP for reporting on currency exposure, which is similar to this procedure but also links FX and other instruments into the modelling.