Create Transaction - MF, Shares, Bonds, FD, Other Assets

Path:
Data Management > Create Transaction

Objective:
Create Transaction is where you add and view transactions across all clients, for every asset class. You can enter transactions manually for Mutual Funds, Shares & Bonds, Fixed Income/Fixed Deposits and Other Assets (such as Gold, PMS, AIF, Real Estate or any other type of asset), one at a time or through Excel bulk upload. Every transaction entered here appears in the client’s portfolio and reports.

Tabs:

Mutual Funds:
This tab shows mutual fund transactions across all clients from every source: RTA feeds, CAS imports and manual entries.

To add a transaction manually, click Add Transaction:

1. Select the investor, enter the transaction date and choose the transaction type. Purchase, Sell and all other mutual fund transaction types can be entered.
2. Choose the folio type (Existing or New) and enter the folio number.
3. Search for and select the scheme. The NAV fills in automatically.
4. Enter the units. The amount is calculated automatically. Click Submit.

Bulk upload: click the upload icon beside Add Transaction, download the sample format, fill it in and upload it.

Third-party files: transaction files downloaded from NJ, Prudent and FundsIndia can be uploaded here. They’re added to the client’s portfolio as manually entered mutual funds.

Share & Bond:
Share and bond transactions have to be entered manually. The tab has two views.

Summary view:

• Each row is one scrip held by one investor, across all clients.
• Click the SOA icon on a row to see all of that client’s transactions in that scrip, along with current quantity, market rate with price date and market value.
• To assign an external asset manager, select the rows using the checkboxes and click Assign External Asset Manager.

Transaction view:
Here you can view, create and delete share and bond transactions. There are three ways to add them:

• Add Transaction: manual entry. Choose Listed Securities for exchange-traded scrips or User Defined Securities (Domestic) for securities you created yourself.
• Bulk Upload: Excel upload using the sample format.
• Contract Note: upload a contract note PDF from a supported broker. Investwell reads the purchase and sale transactions from the PDF.

Contract notes are supported for 84 share brokers: Airan Finstocks, Alice Blue Financial, Ambit Capital, Amit Jasani, Anand Rathi, Angel Broking, Anugrah, Arihant Capital, Ashika, Axis Direct, Bajaj Financial Securities, Bhogilal Trikamlal Securities, Birla, Bonanza, Choice Equity, Dayco Securities, Dhani Stocks, Elite Wealth, Equirus Wealth, Eureka, Finance Monitor, Geojit Financial, GEPL Capital, Globe Capital, Groww, HDFC Securities, Hem Securities, HSB Securities, ICICI, IDBI Capital, iFAST Financial, IIFL, Indiabulls Securities, Indira Securities, Indo Thai Securities, ITI Securities, iVentures, Jainam Broking, JM Financial, Julius Baer, KIFS, Kotak Securities, Kunvarji Finstock, Lakshmi Shree, Latin Manharlal Securities, LD (Gandhi Securities), LKP Securities, Marwadi Shares, Master Trust, Mirae Asset Capital, Monarch, Motilal, Nirmal Bang, NSE Now, Nuvama (Edelweiss), Paterson Securities, Phillip, Prabhudas, Pragya Securities, Pune Stock, Rainbow Securities, Religare, RRS Shares, Sajag, Samco Securities, SBI Cap Securities, SG Securities, Sharekhan, Shree Kanha Stock, Shriram Insight, SMC, Smifs Limited, SSJ Finance and Securities, Standard Chartered, StockHolding Services, Sunidhi Securities, Systematix Shares, Tradejini, Upstox (RKSV Securities), Ventura Securities, VSE, Way2wealth Brokers, WMG, Zerodha.

Fixed Income / Fixed Deposits:
Fixed deposits and other fixed income products have to be entered manually. Click Create Transaction to add one. You can also edit or delete existing entries.

• The create/edit form has a dropdown for selecting an External Asset Manager.
• The system calculates the current value in the portfolio from the interest rate and tenure you enter.

Other Assets:
Used for assets such as Gold, PMS, AIF, Real Estate or any other type of asset.

1. Click Create Asset and enter the initial purchase value and current value.
2. Add new current values with their dates periodically, using the Add Current Value button beside each asset’s row.
3. Record any further purchase or sale using the Add Transaction button beside each asset’s row.
4. Assets can be edited or deleted.

The tab has two views:

• Current Value view: shows each asset’s value history. From here you can add a new current value with its date, or add a transaction for the asset.
• Transaction view: shows the asset’s purchases and sales. From here you can add, edit or delete transactions.

Bulk upload: there are two Excel formats, one for transactions and one for current values. Upload the transaction file first, because it creates the asset. Then upload the current value file.

FAQs:

Q1. What is the Create Transaction menu used for?
Data Management > Create Transaction is used to add and view transactions across all clients, for Mutual Funds, Shares & Bonds, Fixed Income/Fixed Deposits and Other Assets.

Q2. Can I view transactions of all clients in Create Transaction?
Yes. Create Transaction shows transactions across all clients, not just one client at a time.

Q3. Which mutual fund transactions are shown in Create Transaction?
The Mutual Funds tab of Create Transaction shows RTA, CAS and manually entered transactions.

Q4. Which mutual fund transaction types can I enter in Create Transaction?
Purchase, Sell and all other mutual fund transaction types can be entered in the Mutual Funds tab of Create Transaction.

Q5. Do I need to enter the NAV when adding a mutual fund transaction in Create Transaction?
No. When you select the scheme, the NAV fills in automatically. You enter the units and the amount is calculated.

Q6. Can I upload transaction files from NJ, Prudent or FundsIndia in Create Transaction?
Yes. These files can be uploaded in the Mutual Funds tab of Create Transaction and are added to the client’s portfolio as manually entered mutual funds.

Q7. Are share and bond transactions received automatically in Create Transaction?
No. Share and bond transactions have to be added in Create Transaction, either manually, by bulk upload or from a contract note.

Q8. What does the Summary view show in the Share & Bond tab of Create Transaction?
Each row is one scrip held by one investor. Click the SOA icon to see all of that client’s transactions in that scrip.

Q9. How do I assign an external asset manager to shares in Create Transaction?
In the Summary view of the Share & Bond tab, select the rows using the checkboxes and click Assign External Asset Manager.

Q10. Can I delete share transactions in Create Transaction?
Yes. Share and bond transactions can be deleted from the Transaction view of the Share & Bond tab.

Q11. Are corporate actions applied to shares entered in Create Transaction?
Yes. Dividends, interest and splits are applied automatically and backdated, whether the shares were entered manually, by bulk upload or from a contract note. This keeps the portfolio value correct.

Q12. Are mergers and demergers handled automatically in Create Transaction?
No. Share mergers and demergers are not handled by the system and have to be entered manually in Create Transaction.

Q13. Which brokers’ contract notes are supported in Create Transaction?
Contract notes from 84 share brokers are supported, including Zerodha, Groww, HDFC Securities, ICICI, Kotak Securities, Angel Broking and Upstox. The full list is in the Share & Bond section of this article.

Q14. How do I add an external asset manager to a fixed deposit in Create Transaction?
In the Fixed Income/Fixed Deposits tab, pick the External Asset Manager from the dropdown in the create/edit form.

Q15. How is the current value of a fixed deposit calculated in Create Transaction?
The system calculates it from the interest rate and tenure entered in Create Transaction.

Q16. Can I edit or delete fixed deposits in Create Transaction?
Yes. Fixed income and fixed deposit entries can be added, edited and deleted in Create Transaction.

Q17. What types of assets can I add under Other Assets in Create Transaction?
Gold, PMS, AIF, Real Estate or any other type of asset can be added in the Other Assets tab of Create Transaction.

Q18. How do I add Gold, PMS or AIF in Create Transaction?
In the Other Assets tab of Create Transaction, click Create Asset and enter the purchase and current value. You can then add current values and transactions over time.

Q19. How do I update the current value of an Other Asset in Create Transaction?
In the Other Assets tab of Create Transaction, click the Add Current Value button beside the asset’s row and enter the value with its date.

Q20. What are the two views in the Other Assets tab of Create Transaction?
The Current Value view shows each asset’s value history and lets you add a current value or a transaction. The Transaction view shows purchases and sales and lets you add, edit or delete them.

Q21. Can I edit or delete an Other Asset transaction in Create Transaction?
Yes. Go to the Transaction view of the Other Assets tab in Create Transaction to edit or delete a transaction.

Q22. In what order should I upload the Other Assets files in Create Transaction?
Upload the transaction file first, because it creates the asset. Then upload the current value file.