Create a Transaction (Engine - Simple transactions)

Simple transactions 


How to Upload using Simple Transactions?

1. Login to Engine

2. Click on Data Upload, Simple Transaction

3. Choose your specific account

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

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

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

2. Securities




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

3. Loan



Buttons
Remarks
Loan CreateTransaction Type = Loan Create
Loan RepayTransaction Type = Loan Repay
Loan CostTransaction Type = Loan Interest
Loan Transfer

Transaction Type = Loan Transfer

ReinvestmentTransaction Type = Reinvestment


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

A short introduction on how to enter a transaction via the Simple Transaction feature.