Treasury and Cashflow Accountant

The Finance department is looking for a focused, self-motivated & dynamic individual to join their team. You must be highly numerate, well organised, with the ability to work to deadlines. Accuracy is a must.

All Groups
1. Forex Trading and Management
1.1. Weekly Trade requests as per combined Group Fund requests.
1.2. Provide trade instructions to Monex and ensure reconciliation between amounts sent and converted amounts received.
1.3. Periodic review of conversion rates between Datacash/Stenham/Monex
2. Overall cash flow administration
2.1. Compilation of weekly consolidated cash flow report_ All Groups
2.2. Cash flow balance overview and comments on available funds
2.3. Ensure consolidation of intercompany transactions and funding
2.4. Report on variances, mainly on variances per Processor (Timing delays, re-allocations of volumes, etc)
2.5. 6 weeks forecast per Group & combined
2.6. Completion of liquidity, Purchase/Cash in and Hold calculations
3. Consolidation of monthly cash flow statement and forecast
3.1. Reconciliation to bank account balances and Group Reporting
3.2. Comments to monthly variances
4. Consolidation of Quarterly cash flow statement and forecast
4.1. Reconciliation to main Cash flow Template
4.2. Comments on variance per Quarter
5. Oversee treasury team
5.1. Weekly cashflow position
5.2. Monthly cashflow dataports
6. Ration analysis
6.1. Liquidity
6.2. Cash position
Group 2
1. Bank Reconciliations
1.1. Bank Account reconciliations on Navision
2. Overall cash flow administration
2.1. Compilation of weekly consolidated cash flow report
2.2. Cash flow balance overview
2.3. Report on variances, mainly on variances per Processor (Timing delays, re-allocations of volumes, etc)
2.4. 6 weeks forecast per group
2.5. Completion of liquidity and hold calculations
3. Datacash Processing
3.1. Create and code the merchant dataport receive from DC on a monthly basis
3.1.1. Post dataport
4. Cash Book Management – Bank Accounts
4.1. Update weekly excel cashbooks for all Group 2 Bank accounts
4.2. Apply receipts to correct processors from Direct Integration Processors to bank accounts
4.3. Send details of receipts to Datacash
4.4. Consolidate into cashflow report
4.5. Weekly cashflow forecast
4.6. Cash flow management and optimization
5. Update weekly direct ledgers with settlement information
6. Update monthly cashbooks (Group 2)
6.1. Apply receipts to correct processors from Direct Integration Processors to bank accounts
6.2. Create cashbooks dataports for Navision and post
6.3. Post receipts to individual vendor account (ledgers)
6.4. Bank Recons in Navision
7. Cash Book Management – Datacash Cashbooks (Grp2)
7.1. Update weekly excel cashbooks for all group 2 bank accounts
7.2. Apply receipts to correct processors from Datacash Processors to bank accounts
7.3. Request funds in surplus or instruct funding where required
7.4. Receive monthly treasury dataport from Datacash
7.4.1. Code and import into Navision
7.4.2. Bank Account Reconciliation
8. Review progressive balance / forecast and fund if required (Grp 2)
8.1. Ensuring monthly 3rd party credits are applied i.e. Mega Moolah
9. Review Clearing house balances and fund if required (Grp2)
9.1. Clearing house
9.2. Processors for as per payment departments request
9.3. Datacash as required or settle
10. Cashins in Transit Vendor Matching
11. Reporting (Grp2)
11.1. Compile and reconcile Processor and Reserve note for Group Balance Sheet Report by the 20th of each month
11.2. Monthly cash flow forecast
12. Assistance with Quarterly Audit file
13. Projects
13.1. Combined Digifeed/Cash flow template to evaluate on a daily basis completeness and timing of Processor inflows.

Requirements:
• Relevant Finance qualification
• Proven experience in a similar role
• Advanced Excel knowledge and ability
• Knowledge of Navision or other accounting software
• At least 3 years Cashflow Management experience
Skills required:
• Proven ability to drive tasks and projects
• Highly numerate
• High level of accuracy with a high attention to detail
• Pro-active and organized
• Excellent verbal and written communication skills
• Deadline driven
• Adaptable
• Service orientated
• Ability to work under pressure and to strict deadlines