Stahr Treasury Software Help Reporting - NETTING INVOICE & EXPORT
To get an overview about Netting as a topic, please read our arcticle. All single intercompany invoices previously captured in menu Transactions -> Netting are summarized in this reporting as an invoice, a pre-check to minimize the monthly reconcilation efforts and to export in to a free definable format according Microsoft supported files. 1. Select the settlement date of the invoice. This is the date when funds are transferred to/from the invoicing party to/from Corporate Netting Center. By clicking on any specific date only the companies with existing intercompany invoices will be monitored. 2. Enter the date of the netting-invoice. 3. Select a fx-rate previously entered in menu Standing Data -> FX Rates, submenu Rate Type. 4. Select finally the company which is going to invoiced resp. credited. 5. Choose one of these reporting possibilities: a) The regular netting invoice b) A pre-check before issue of the netting invoice. This is quite helpful in order to minimize the monthly reconciliation work and ensures a fast monthly / yearly close of the books. c) Export of the respective invoice into a file, e.g. Microsoft Excel. Netting Invoice The structure of this invoice resp. credit note allows among the general netting benefits also a significant reduction of the fx-exposure by calculating the net amount automatically in the functional currency of the invoice receiver. Thus, all companies of the group have no more foreign currency out of internal transactions in their books and all currencies are netted only in the corporate netting center. More about this very beneficial procedure in our article. Fields 1. Title: Depending on the net- amount in nr. 16  below, the title is automatically “Credit Note” or “Debit Note”. 2. Receivers Address: Full address of the reciveiver of the credit / debit note. 3. Senders Address: Usually a fix address for the Corporate Netting Center at the Group Head Office. 4. References: Block with the basic reference information for invoice date, the unique reference of the invoice and the VAT number of the sender, i.e. Head Office. 5. Account: Internal account of the invoice receiver in the books of the invoice sender, i.e. Head Office. All single internal invoices, i.e. the basis of the calculation previously entered in menu Transactions -> Netting, are summarized by company and cash flow (+ or -). In this example, the company with short-code Test1 (=netting invoice receiving party) invoiced to the company with short code Sampl two invoices for USD 50’000 and EUR 10’000 and has received from Sampl one invoice for CHF 51’000. 6. Inv. Date: Date of the internal invoice. 7. Reference: Reference of the internal invoice. 8. From: Short code of the invoicing party for the internal invoice. 9. To: Short code of the receiver, i.e. ower of the internal invoice. 10. Category: Definition of the invoice’s purpose. 11. Trans.Date: Transaction date of the internal invoice. 12. Curr: Transaction currency of the internal invoice. 13. Amount: Amount of the internal in the currency mentioned before. 14. FX Rate: Exchange rate previously selected, see above vs. the functional currency of the netting invoice receiver. 15. Amount in Functional Currency: Amount of nr. 13 expressed in the functional currency of the netting invoice receiver. 16. Overal Balance: Net amount,expressed in the functional currency of the netting invoice receiver which has to be settled on the selected date. Pre-Check for Netting Invoice in order to minimize the monthly, quarterly and yearly internal reconcilation efforts and to ensure a fast close for the books this function allows the user to send out weekly or just a view days before the closing date such a pre-check note. All possible differences can be investigated in this step and when sending out the final netting invoice, all involved parties can book acccordingly without loosing time. Basically the content of the pre-check is the same like the official netting invoice mentioned above. The differences are in numbers 1 - 4, see on the right. They make clear that this document is not invoice. Instead, it is just used for reconcilation purpose. Netting Export All internal transactions which are subject of group netting might want to be analyzed further in ad-hoc reports. Thus, this Treasury Software allows to export all transactions into all possible formats 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: If you like to export as an Excel file, the result looks like this: