Payment files can be uploaded automatically (SFTP/FTP) or manually in a number of common file formats, including support for many of the industry’s leading accounting packages. Assistance is available to quickly map your payment file format to enable your payments to flow through Cambridge Online with your unique payment identifier attached, for easy reconciliation.
In a single payment file, Cambridge can process different payment types and currencies which can be used to process your spot and future payments. These files can be transmitted with full beneficiary information or with unique ID.
Once your payments are finished processing and are on their way to beneficiaries around the world, an automatic and comprehensive payment information statement is sent back to your electronic payments support department. This statement easily integrates into your proprietary system, or can be reviewed by key personnel to support current business needs, such as managing merchant queries or reconciling merchant account details.
Custom Return File
Cambridge Online’s return file feature allows you to receive comprehensive information on all your payment transactions, delivered via email or SFTP at an interval of your choosing. These files are customized to match the format required by your ERP or accounting platform, allowing you to easily upload and integrate payment data into your in-house system. This data can be used to track your payment history, reconcile pending payables and to manage vendor enquiries. The return formats supported by Cambridge Online include (but are not limited to) CSV, XML, Fixed Width and Character Delimited, apart from industry standards such as BAI and MT940/942.
In addition to the return file, Cambridge Online is able to deliver an Upload Status File whenever you make use of our file upload capabilities, detailing the status of each transaction and errors, if any, within the uploaded file. The system can also generate scheduled and ad-hoc exchange rate files for currencies of your choice, enabling you to create periodic budget rates from your ERP or accounting system.
For our Cambridge Enterprise Solution data sheet, please click here.