PEXA is pleased to present the release of PEXA Projects (PoT and MoT) — Release 4.3.0, scheduled for business go live 26 October 2018.
New bulk Financial Upload
We’ve made it easier for you to efficiently upload bulk financial data to PEXA. This is the first iteration of the Bulk Upload Financials tool that lets you import bulk Financial Settlement Schedule (FSS) data from an Excel file to PEXA via a wizard.
You can now use a wizard to import the following data to your project’s Workspaces:
Financial Settlement Schedule (FSS) data
Destination line item
Source line item
The data in the file will be mapped and once uploaded, will create or replace the financial line items in the PEXA Workspace.
Note: The option to upload bulk financial data via PEXA Connected is still available, however, the link to PEXA Connected via PEXA Projects will no longer exist. Instead, this link directs you to the new Bulk Upload Financials tool. To use PEXA Connected, you will need to access it via the PEXA Core dashboard.
How do I access this new feature?
You can access the Upload Bulk Financials tool via the updated side navigation menu under Manage Workspaces > Upload Bulk Financials.
For destination financial line items, your file will need to include a Destinations tab and include specific columns (e.g. Subscriber Reference, Lot Number, Destination Category, Amount, Transaction Description).
Similarly, for source financial line items, your file will need to include a Sources tab and include specific columns (e.g. Subscriber Reference, Lot Number, Source Category, Amount, Description, Source Account).
These templates can be downloadable within PEXA Projects for your reference.
The Bulk Upload Financials wizard comprises three simple steps:
Select an Excel file that contains financial line item data and click Next to upload it into PEXA Projects.
2. Map your data
After your file is uploaded, map your fields (right column) to PEXA line item fields (left column).
Based on the data in your Excel file, you may map:
Destination financial line items with locked accounts (if this option has been selected for your project),
Destination financial line items with unlocked accounts, and/or
Source financial line items.
Mapping of Destinations
Mapping of Sources
3. Confirm your FSS line items
After mapping is complete, review and confirm your FSS line items.
Any errors, such an incorrect format or incorrect account details, will be highlighted on the screen and must be rectified.
When all errors are rectified, click Update Workspaces to confirm the upload. All Workspaces in the project and any financial line items marked for update are updated in one bulk action. Existing financial line items in the Workspaces are replaced with the new financial line items from the file.
In addition to updating your Workspaces, you may also choose the following:
Export - export financial line items to a spreadsheet for reconciliation purposes.
Save draft - save as draft and upload this file at a later time.