Reconciliation Assignment - Broker Company "A"

Reconciliation Assignment - Broker Company "A"

Cancelled

Job Description

Hello,

This job require someone that is already working in a broker company and most specifically that has experience with reconciliation of banks.

Please check the link:
https://www.dropbox.com/s/otwqhssznsxgn99/Assignment.zip

and downloads the files.

Please go over the below instructions carefully and follow them.

In some cases you'll be required to use your judgement, as not all is specified in the instructions.

-----------------
Instruction:
------------------
As part of your monthly matching process for March 2013, you are required to reconcile the deposits (incomings) through credit cards, between the company's data base (BackOffice) and the external processors reports.

In order to do so, you have the attached files:

1. backoffice deposits 3.2013 task- detailed transactions for 3/2013 from the company BackOffice system.

2. 201302_BO_Deposits_02 task- detailed transactions for 2/2013 from the company BackOffice system

3. barclaycard data 3.2013 task- detailed transactions for 3/2013 from one of the
company's credit card processors system (Barclaycard).

4. BarclayCard data Apr 13 task- detailed transactions for 4/2013 from one of the
company's credit card processors system (Barclaycard).

5. Deposits & CO - GCS Mar 13 task- detailed transactions for 3/2013 from one of the company's credit card processors system (GCS).

6. CardTransaction_2-wirecard mar task v.1- detailed transactions for 3/2013 from one of the company's credit card processors system (Wirecard).

You are required to reconcile the deposits only between the each processor and the
company data base (the BackOffice) and send a summarized report with your findings to the head of finance.

The report should include only totals (per processor, per currency) and explanations for differences that were found (if any), per transaction.

Note that the company BackOffice data includes deposits from all processors. You will need to select only the relevant data in order to compare with the specific processor.