We are manually tracking our foreign exchange contracts with regard to outstanding balances, expiration dates,
Foreign Exchange Contract system
Answers
Most of the treasury
We use Capella (from Hedgetrackers) which is a web based (SaaS) solution for managing your FX contracts. It has a front end system that can connect to trading portals and allow you to upload trading information directly. It also allows you to upload trade data from spreadsheets. In addition, you can also input the information directly into the system while on the phone with the banks. It generates summary and trade level journal entries by functional currency by trading entity. It can even prepare disclosure tables for external reporting. It allows non traders to do the accounting so you can have segregation of duties. When the trade (for an associated exposure) is executed, it automatically generates the special hedge accounting and required designatation documentation when needed. It also calculates effectiveness tests and includes calculated ineffectiveness and excluded time value in the journal entries and disclosures.
We have been very pleased with the software and have been able to rely on Hedgtrackers to keep it current with the latest accounting requirements. For all that we get from the above, we believe the pricing for this software is quite reasonable and I would highly recommend that you contact Hedgetrackers and look into it!