Stahr Treasury Software Help Reporting - REPORTS WITH A FIX DATE
Basically, there are three kind of possibilities for reporting: a) Reports for specific items, e.g.  loan agreement, fx-deal confirmation b) Reports with a specific reporting date, e.g. balance sheet c) Reports with contents within a defined period, account ledgers This menu is for reports b) with one fix reporting date. Most of all reports are as of a specific date. A) Please select in the block “Reporting Date” the starting resp. fix-date. The content of the report includes this date.You may enter the date directly in the format of your system (i.e. DD.MM.YY or in the US MM/DD/YY etc.) or you click on the calendar-icon right next of the date-field and choose a date in the calendar. B) Select then in the Block “Balance Sheet Exchange Rate” the desired fx rate for evtl. foreign currency conversions. Source of these rates is menu Standing Data -> FX Rates. Following reports are available in this menu: a) FX Transaction Position Report  b) FX Export function into Excel c) FX Deals Check d) All guarantees by guarantor e) All guarantees by bank f) All credit facilities g) The total external Financial Status of a group by currency per  instrument (e.g. bank/loans/facility) for a booking date g) The total external Financial Status of a group by currency per instrument for a value date h) The total external Financial Status of a group by company, currency and availability for booking- and value dates (Cash Report) i) Payment Proposal Report for all kind FX-, MM- and Interest payments FX Transaction Position Report After having marked one of these possibilities, click on “Get Report” and the desired report resp. submenu will appear. The report is designed to summarize all open fx-transactions by currency and instrument and group it by internal or external transaction. This allows the Treasurer to have a comprehensive position vs. internal parties and vs. external parties and as a result, the net position per currency. On top, the total open position is summarized at the bottom of the report and shows the total amount of open fx- transactions.  That means, with this report the Treasurer is able to manage a complete fx portofolio and can change the position throughout the whole currency spectrum while having always the total net position under control. FX Transaction Export into Excel Foreign Exchange Deals might want to be analyzed further in ad-hoc reports. Thus, this Treasury Software allows to export all fx-transactions into all possible formats wich Microsoft supports. First a message appears with instructions: By click on OK you are asked to choose the format into which you like to export: In case you like to export into Microsoft Excel, the result looks like this. Now you are able to analyze all fx-transactions by whatever you like to analyze it for. FX Deals Check Open FX-Deals should be confirmed regularely, not only when having made the deal and confirmed with the FX-Deal Ticket. This report shows all fx-deals by entity and has a field to check and confirm it by manual signature. Fields: 1. Entity: Owner of the fx-deal vs. the internal or external bank. 2. Bank: Bank with which the fx-deal has been agreed. Can be internal or external. If an entity has deals with more than one bank, all banks with their trades will be listed after another. All Guarantees by Guarantor Guarantees are daily business in every treasury department. Because guarantees require just rarely attantion, mostly just when they expire or when they should be renewed, the threat of loosing control is given. With an easy and fast generated report the Treasurer has always a full overview about all outstanding guarantees. Fields: 1. Reporting Date: Reporting date as previously selected, see above. 2. Guarantor: Company, who stand surety for the guarantee. 3. On behalf of: The company for which the guarantee is intended (i.e. not the beneficiary). This might be the guarantor itself or any other company. In case one guarantor stands surety for more than one company, the other “on behalf of” are listed one after the other, see 3a. 4. Detail Block: All relevant information about the gurantee. If the currency of the guarantee is not the same like the group’s functional currency, the equivalent amount in the functional currency (in this example EUR) is calculated by the exchange rate having selected previously, see above. In case one guarantor stands surety for more than one company, the other details are listed one after the other, see 4a. 5. Total for [on behalf of]: The subtotal of all gurantees per “on behalf of” company, expressed in the group’s functional currency and converted at the fx rate previously selected, see above. 6. Total [Guarantor]: The total amount of all guarantees the guarantor stands surety for, expressed in the group’s functional currency and converted at the fx rate previously selected, see above. All Guarantees by Bank The report Gurantees by Bank is basically the same like the report Guarantees by Guarantor. Just with the difference that now the analysis is made by primary bank instead of primary guarantor. All Credit Facilities The credit facility report is an important source of information for the group’s capital management. It monitors all credit facilities of a group as per company, bank, currency and very important, with a segregation of committed and non-committed facilties. Fields: 1. Reporting Date: Reporting date as previously selected, see above. 2. Company: Short code and name of the company who is the borrower of the facility. 3. Bank: SWIFT code and name of the facility giving bank. 4. Detail Block: All relevant details about the specific facility. If a facility is committed or syndicated it will be indicated in a tick-box. 5. Total Bank: The total amount of the facility xpressed in the group’s functional currency and converted at the fx rate previously selected, see above.  6. Total Company: total amount of all facilities for the company in the group’s functional currency. 7. Total committed Facility: The total of all committed  facilities in the group’s functional currency. 8. Total non-committed Facility: The total of all NON- committed facilities in the group’s functional currency. 9. Total Facility for the Group: The sum of all committed and non-committed credit facilities. External Financial Status The financial status is one of the most important informations to manage a safe and efficient optimal cash management.  This report  summarizes per currency all bank- accounts, deposits, borrowings = total cash, adds the facility and calculates then the net- availability. The user has the choice between entries for booking date (Fin Status FX Book) and entries for value date (Fin. Status FX Val.) . As soon any loan, deposit, facility, bank- account entry is made, the software is calculating immediately the new status. This ensures a maximum fast information.  Source for this comprehensive report is: Currency: Standing Data -> Currencies Bank-Accounts: Transactions -> Account Balances Deposits and Borrowings: Transactions -> Loans and Investements Facility: Transactions -> Credit Facilities Restrictions: Standing Data -> Countries and Regions Exchange Rate to convert the totals: see above. However, the multinational treasuer knows that there is a very important difference between available funds and restricted funds, i.e. trapped cash. Hence, the financial status report has three blocks: 1) Non-Restricted Funds 2) Restricted Funds 3) Total External Financial Status by Company (Cash Report) To manage a funds-portfolio, the Treasuer needs two informations for a safe and efficient cash management. The first is the porfolio by currency, see above, and in the second step. the information where the funds are. This report is intended to monitor the funds-owners by availability and with a comparison to a second date, free definable (e.g. actual vs. last day, week, month or year). The user has the choice for these four reports: 1) Basically the distinction between booking dates and value dates, then a) All companies whose funds are non-restricted and available for group-treasury. At the bottom of the report a summary of restricted funds is also included, as well as the overall net cash / debt position number that gives this report the character of an overall cash flash. b) All companies whose funds are restricted, i.e. trapped cash. The information of which funds are available and which funds are not available is made in menu Standing Data -> Countries and Regions by setting a tick in restriction type “IC-Clearing Crossborder”. The report has three blocks, one for the reporting date, one for the comparison date and one for the difference between those two. Depending on the flag “Internal “in menu Standing Data -> Companies all such companies are part of this report. There are three total-lines: 1. Total of all Non-Restricted funds 2. Total of all Restricted funds 3. Total of all funds = Net Cash / Debt Position Payment Proposal for FX-, MM- and Interest Payments This is a very useful report! Based on the entries made in the Transactions Menu for FX-Trades and Money Market Loans/Deposits Stahr Treasury Software provides the user with a detailed proposal report for the upcoming payments to be made. 1. The user select in the previous menu “Fix Date Reports” the value date up until all unsettled payments shall be reported and tick the box “Payment Proposal”. 2. In the selection box all internal companies are listed and for which company what kind of payment is unsettled up until the date previously selected. a) If you like to get a report for a specific company, select the desired entity and click in the box below on “specific”. b) If you like to get a payment proposal report for all companies, simply click “All”. This is especially very helpful for Shared Service Centers. 3. Select the payment item, Foreign Exchange-, Money Market or Interest and click on “Get Report”. Report The Foreign Exchange Report is used here as an example, the Money Market- and the Interest Report is analogue: Fields: 1. Due Date: All payments with due date until and inluding that date are considered for the report, as long they are not marked as “paid” in the respective transaction menu. 2. Debit Party: Thats’s the internal company who has to make the payment. 3. Beneficiary: This is the internal- or external party who recieves the payment. 4. Beneficiaries Bank: This is the bank of the beneficiary to which the the payment has to be made. Among the name and address all relevant payment information such as SWIFT etc. are mentioned. 5. Beneficiaries Account: If the account has an IBAN, this one will be reported, otherwise the normal external account number is mentioned. 6. Value Date: The value date for the payment. 7. Payment Details, Currency, Amount: The trade reference, the instrument and currency of the payment, followed by the amount in the payment-currency. All amounts are converted also in the groups functional currency (Trigger: menu Standing Data -> Currency). 8. Payment Control: Very important! The person who is responsible to make the payment must be also responsible to mark the fiields “Payment made”, goes afterwards to the respective transaction menu (Foreign Exchange or Loans/Investments) and marks the transaction as paid and set a cross to “Marked in Menu FX Transactions” resp. “Loans/Investments”. Secondly this person verify that by signing the payment report with the first signature. Usually, all groups have at least  two signatures for a payment. That means, Person #1 who made the payment in the banking software is forwarding this payment report to Person #2 who confirm and release the payment finally and as last step, signs the report as well.