Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Simple transactions 

...


How to Upload using Simple Transactions?

1. Login to Engine

2. Click on Data Upload, Simple Transaction

3. Choose your specific account

Image Modified

4. Choose the type of transaction. (refer to Transaction Types for list of transactions)

5. Fill up all the details as required and then click validate

Image Modified

6a. It will either say No errors found at the top of the page. You can proceed to upload your transaction OR

Image Modified

6b. It will recognise the error you may have made and prompt you to change it accordingly before its ready for upload

7. Click on upload.

8. Run/re-reun NAV to see your changes in Visualizer.




Further explanation Examples: 

...


Trade Date & Value Date scenario:

i) Today's Date =   Default as Trade Date =  and Value Date =  

ii) If the user overwrites Trade Date field to  then Value Date field will change to  

iii) If user then makes changes to Value Date field, no changes are needed to be made on Trade Date field  

1. Cash



Buttons
Remarks
InflowCredit to Account
OutflowDebit from Account
Misc Income
Misc Expense
SpotFXOnce User clicks this button, 2 rows of transactions should be shown. 
Because technically 1 transaction will be SpotFX In and 1 will be SpotFX Out.



Mandatory Fields
Field Type
Remarks
Trade DateDate FieldDefault: Today's Date
Value DateDate FieldDefault: Value date = Trade Date
AmountNumeric
  • If Inflow, Amount > 0, Transaction Type = Money In
  • If Outflow, Amount < 0, Transaction Type = Money Out
  • If Amount < 0, Transaction Type = SpotFX Out
  • If Amount > 0, Transaction Type = SpotFX In
NarrationText

If input is empty transaction cannot be uploaded.

Input is mandatory to execute the transaction upload


...


Buttons
Remarks
BuyTransaction Type = Purchase
SellTransaction Type = Sale
Dividend & Coupon

Transaction Type = Distribution

Transfer In

Transaction Type = TransferFOP In

Transfer OutTransaction Type = TransferFOP Out
ReinvestmentTransaction Type = Reinvestment
ContributionTransaction Type = Contribution



Mandatory Fields
Field Type
Remarks
Trade DateDate FieldDefault: Today's Date
Value DateDate FieldDefault: Value date = Trade Date, but still allow User to overwrite Value Date field
AmountNumeric
  • Exception for Derivative, Insurance and Other Contracts, Amount can be <>= 0 for Purchase and Sale
NarrationTextUser will not be able to use the upload button until this field is filled out
TickerText
QuantityNumeric


  • Exception for Derivative, Insurance and Other Contracts, Quantity can be <>= 0 for Purchase and Sale

  • Transfer In, Quantity > 0 for all contracts
  • Transfer Out, Quantity < 0 for all contracts
  • reinvestment Quantity <>= 0
PriceNumeric
  • Buy, Sell, Transfer In or Transfer Out, or Reinvestment (Upcoming DOT-2787 - [LOOP-354] [S3 update] Allowing transacted price to be editable for reinvestment transactions ICEBOX):
  • Price > 0 for all contracts,
  • Exception for Derivative, Insurance and Other Contracts, Price can be <>= 0


...


Fields on Screen
Field Type
Remarks
Trade DateDate FieldDefault: Today's Date
Value DateDate FieldDefault: Value date = Trade Date, but still User is allowed to overwrite Value Date field
AmountNumeric
  • Loan Create, Amount > 0
  • Loan Repay, Amount < 0
  • Loan Cost, Amount < 0
  • Reinvestment: Amount <=0 for all Contracts
NarrationTextUser will not be able to use the upload button until this field is filled out
TickerText

Numeric
  • Transfer of Loan:
  • reinvestment Quantity <>= 0


4. Deposit


Buttons
Remarks
Deposit CreateTransaction Type = Deposit Create
Deposit RepayTransaction Type = Deposit Repay
InterestTransaction Type = Interest
Deposit Transfer

Transaction Type Deposit Transfer

ReinvestmentTransaction Type = Reinvestment



Fields on Screen
Field Type
Remarks
Trade DateDate FieldDefault: Today's Date
Value DateDate FieldDefault: Value date = Trade Date
AmountNumeric
  • Deposit Create, Amount < 0
  • Deposit Repay, Amount > 0
  • Interest, Amount <> 0
  • Reinvestment:Amount <=0 for all Contracts
NarrationTextUser will not be able to use the upload button until this field is filled out
TickerText
QuantityNumeric
  • Transfer of Deposit:
  • "Quantity" is > 0, Transaction Type = TransferFOP Deposit Create
  • "Quantity" is < 0, Transaction Type = TransferFOP Deposit Repay
  • reinvestment Quantity <>= 0


Video Guide on Creating a Simple Transaction

...