Government Reporting & Cash Environment (Project Grace)

Government Banking Service (GBS) require a Financial Transaction Reporting (FTR) solution that can report intraday position data using transactional data which is used to supply HM Treasury with key financial information, allowing them to effectively deliver government cash management objectives. GBS require a solution that can capture and consolidate data for multiple entities (i.e. The Government Departments bank accounts) and return the information in a format acceptable to GBS and HMT. The solution must be banking industry standard, scalable, flexible, easy to maintain and must have the ability to debt and credit customers' accounts using various file uploads. Additionally, it must have the ability to 'zero' customer accounts, GBS currently utilises a SWIFT bureau and continues to require this method of connecting to the banks.

HMRC uses SAP Ariba Sourcing Pro (thereafter referred to as HMRC's SAP Ariba) and this must be used to express an interest and/or bid for the opportunity. (Further information about HMRC's SAP Ariba is available on the HMRC website: www.hmrc.gov.uk/about/supplying.htm) Economic operators who have used HMRC's SAP Ariba previously will be registered and you should access the system to obtain your account ID number. Previously registered users having difficulty recovering their account ID number or identifying users within their organisation should email for assistance [email protected].

Economic operators using HMRC's SAP Ariba for the first time, will need to register at http://hmrc.supplier-eu.ariba.com/ad/register/SSOActions?type=full. (You must ensure that you are directed to the registration page for HMRC's SAP Ariba, identified with the HMRC logo, You will receive a system generated email asking you to activate your SAP Ariba supplier account by verifying your email address. When you have completed the activation process you will receive a further email confirming the 'registration process is now complete' and providing you with 'your organisation's account ID' number. If an email response from HMRC is not received within one working day of your request, please re-contact [email protected] (after first checking your spam in-box) notifying non-receipt and confirming when your registration request was first made.

When you have obtained 'your account ID' number, please email [email protected] with the following information as confirmation that you wish to express an interest for the opportunity. The contract reference: MFA SR131673967 Your HMRC SAP Ariba account ID: AN Your organisation's name: Your name: Your email address: Your telephone number: Economic operators who have complied with the foregoing will receive an e-mail confirming access to the Event. If access is not provided within one working day, please contact [email protected] notifying non-receipt and confirming when your request for access to the online questionnaires was first made

Additional information: The current application has been modified to allow the Authority to create the required outputs, however the intention is, where possible, to move to a more standardised solution.

The current system produces the following- • 6 Intraday Transactional based Swing reports (utilising intraday transactional data) • 1 Next Day Swing report (utilising next day reports of Bacs debits and credits supplied by the banks plus Bacs Grade 3) • 2 Cash Management files (utilising End of Day transactional data to allow Actual v Forecast comparison) • End of Month balances of all sterling accounts (utilising end of day statements cleared balance information) • 2 Overdrawn reports (utilising end of day statements balance information) • 2 Reconciliation reports GB & Euro pools (utilising end of day statements balance information) • The creation of journal payment files specific to each electronic banking system from Bank of England files (i.e. Bacs Grade 3) • The creation of journal payment files specific to each electronic banking system from HM Treasury files (i.e. Vote Funding, HMT Interest)

The key output requirements are summarised as - • The production of 6 intraday banking activity reports on an agreed schedule and one next day report for HMT using data received from supplier banks • Creation of one Cash Management Files for HMT (to enable them to compare actual movements with those forecast by the Government Departments) • Creation of journal (internal transfers) files specific to each electronic banking system from Bank of England files (i.e. Bacs Grade 3) • Creation of journal (internal transfers) files specific to each electronic banking system from HM Treasury files (i.e. Vote Funding, HMT Interest) • Ability to recreate historical reports of specific files (i.e. Cash Management Files) • Zeroing customers' and Government Banking accounts; • Reporting Monthly Balances of all GOVERNMENT BANKING Accounts for HMT using an agreed structure; • Overdraft Monitoring (Intra and End of Day); • Volumes and values of GOVERNMENT BANKING customers; • Audit reports; • Reconciliation reports (Euro and GB pool's) • Ability to create ad-hoc reports • Management Information reports

Minimum Requirements for bidders wishing to provide an Initial Tender are - • The key output requirements listed above • The Functional Requirements • HMT Interest (passing of HMT Interest to Government Department accounts) • HMT Vote (passing of HMT Voted money to Government Department accounts) • Miscellaneous Transfer (internal transfers) • Intraday/Next Day 'Swing' Reports • Cash Management Daily/Monthly File • End of Month Balance Report/Reconciliation • GBS Functionality/Functional Requirements