Overview

Background

The purpose of this project is to improve a current manual reconciliation process that is carried out by the FIS section in Finance. Currently FIS carry out a manual reconciliation process:

- Transactions are made via ePay and WPM and Worldpay posts Daily Totals to the Bank Account

- FIS manually post a total figure of transactions taken via WPM into Finance

- Financial Accountants then try to reconcile the figures using reports from Worldpay and WPM

The issues with this process are:

- it's a time consuming process

- the monies are posted to eFinancials late (ie. not in month)

- the manual journal that posts to eFinancials is one figure rather than idividual transactions which Financial Accountants don't like

- the amount is incorrect does not include VAT or carriage costs

Scope

The scope of this project is to look at the following things:

- ePay Transactions only

- eeFinancials

Out of scope

- To fix the way that partial refunds are handled by WPM

Objectives

- To automate the posting of transaction information to eFinancials

- To ensure transactions are posted individually including VAT and Carriage costs

Deliverables

Essential

 1. Extend the functionality of JAMS to automate the process of getting the information from WPM that is done manually at present, and post this to eFinancials.  This should be done as multiple entires per transaction and not a single amount as happens just now

Optional

2. Auto Create journals to post the correct information to the sales ledge account (students accounts etc).

3. Automate the reconciliation.

The constraint on these deliverables will be the budget available. This project has 75 days allocated to it.

Benefits

- Posting transactions on time

- Posting individual transaction will make reconciliation easier

Success Criteria

Transactions posted individually and on time