User Guide: Bank Positions Import
Manual Import of Positions
Introduction
Re:Luna Platform has a feature that allows to upload one or many Positions at once. The system includes a feature for automatic reconciliation of positions with bank data. This feature aims to address the issue of obtaining bank positions when bank integration is not enabled, and when it does not receive data from the bank, automatically.
User with permission have ability to import data on bank positions for each day using a CSV file. The import function in the system allows the creation of raw bank positions for subsequent comparison with bank data. The system processes the data from the file and automatically creates raw cash and security positions based on this data.
Terminology | Description |
|---|---|
File (CSV) | A text file that has a specific format which allows data to be saved in a table structured format. |
Where is manual import of positions in the system?
Go to Positions tab from the dashboard > Click on Import.
The system redirects to this page. On the Raw Positions tab > Click on Import File option.
What information is loaded to the system?
Template for manual import of positions is available by clicking on icon Import File > Download Template.
The CSV file template gets download on the system, open and fill in the columns to further save and upload.
The template contains all the necessary fields for creating raw position in the system, data for selection from a list, and validation of input values in columns where necessary.
Manual Positions Import Template
Field Name | Description | Mandatory | Example |
|---|---|---|---|
Instrument identifier | ISIN Code for security transaction or Currency indicator for cash transaction or ticker or id (for private assets) | Yes | US0378331005 EUR
|
Date | Date of Position (YYYY-MM-DD) | Yes | 2022-07-06 |
Bank Account | Bank Account.ExternalName | Yes | TD67789990 |
Custodian | Custodian.Bаnk | Yes | Check in the list of existing |
Qty | Qty | Yes | rounding 2 decimals |
Currency | Instrument Currency | Yes |
|
Accrued | Accrued | No | rounding 2 decimals |
Value (in instrument currency) | Value | No |
|
Market price | Market price | No | rounding 2 decimals |
Purchase price | Purchase price | No |
|
Description | Description | No |
|
How to Import Files
Go to Import File > Upload file template with Raw Positions to the system.
The following pop-up window opens. Drag/Drop/Select the File from the PC.
Once the file is uploaded > Click on Save.
How to find my loaded Positions?
The following screen appears > The Positions have been uploaded manually.
The system also shows if there are any Errors while uploading the file or on to the template file fields.
Check your CSV file for common errors:
Strictly adhere to the format of all fields, especially containing dates and numbers;
If there is no value for the particular field, leave it empty and separated by semicolons;
When adding records, check for and remove any duplicates;
Preserve the proper structure and format when save added data.
You can further Delete the positions uploaded manually by selecting them or to Edit by double-clicking on each fields and entering the changes (auto-saves).
