# Trade Book
Your trade book is the record of all executed trades. It provides detailed transaction history and serves as a critical tool for monitoring trading performance and market trends.
* **Click** on '**Reports**.'
* '**Trade Book**' will be located at the top of the sidebar.
#### This Section Contains :
* [How do I view my trade report?](#how-do-i-view-my-trade-report)
* [How do I view my Average Analysis Report ?](#how-do-i-view-my-average-analysis-report)
* [How to view/add manual transactions?](#how-do-i-view-add-manual-transactions)
* [How do I view the MF Transaction Report ?](#how-do-i-view-the-mf-transaction-report)
### How do I view my trade report?
Trade report is the detailed record of your transactions, including the scrip name, product, transaction type (buy/sell), quantity, rate (executed rate), and order value. To view your trade report, follow the below steps :
{% embed url="" %}
* Tap on the '**Reports**' tab.
* Tap on the arrow mark 🔽 right next to the 'Trade Book.'
* A drop-down menu will appear, with the option '**Trade Report**' displayed at the top.
* Select **'Trade Report.'**
* Choose the preferred **segment, exchange,** and **date** (either you can set a custom date range using the calendar icon 📅 or choose from the preset options given below the date bar).
* Click on **Submit.**
* Your trade report with details like **scrip name, mode of transaction** (buy/sell), **quantity, rate (executed rate, i.e., actual buy/sell rate), order value, total buy value, total sell value,** and **transaction date** will be listed chronologically.
* In-depth details of each transaction, like **order ID** and **time**, can be viewed by clicking on the '**More**' button  given towards the **right-hand side of each scrip.**
* You can **search for a specific transaction** from this list by entering the symbol name in the **search bar** given at the top.
* If you wish to **download the report,** click on the '**download button**' **⬇** given at the top right corner.
* Excel downloads now include **Settlement Numbers** for easier tracking.
### How do I view my Average Analysis Report ?
Like the trade report, the average analysis report is also the detailed record of your transactions. But additional information like average rate, brokerage, GST, STT, and statutory levy is provided in your average analysis report. To view your average analysis report, follow the below steps:
{% embed url="" %}
* Tap on '**Reports**' tab.
* Tap on the arrow mark 🔽 right next to the '**Trade Book**.'
* A drop-down menu will appear.
* Select **Average Analysis Report**
* Choose the **preferred segment**, **exchange**, and **date** ( either you can set a custom date range using the calendar icon or choose from the preset options given below the date bar).
* Click on **Submit**
* Your average analysis report with details like **scrip name**, **mode of transaction** (buy/sell), **quantity,** **rate (expense-adjusted rate)**, **order value**, and **transaction date** will be listed chronologically.
* **Also, in-depth details** of each transaction, like **brokerage,** **GST**, **STT**, **Stamp Duty**, **Statutory Levy** and **Total Charges**, can be viewed by seeking the screen towards the right.
* You can search for a specific transaction from this list, by entering the symbol name on the search bar given on the top.
* If you wish to download this report, click on the 'download button' given at the top right corner.
### How do I view/add manual transactions?
You may have acquired securities through off-market transactions or received new scrips via IPO or other means. The system cannot automatically determine details of shares transferred off-market, dematerialized, or allotted through IPOs and corporate actions such as rights issues, mergers, etc. As a result, **the average rate** shown in FLIP may appear blank or inaccurate until it is updated manually.\
To enter these transactions manually, you can use the MyGeojit. Here’s how:
{% embed url="" %}
* Tap on the '**Reports**' tab.
* Tap on the arrow mark 🔽 right next to the '**Trade Book**.'
* A drop-down menu will appear.
* Select **Manual Transactions**.
* Click on '**Enter Transaction.'**
* Enter the **date, security, head, transaction type, quantity,** and **net rate**.
* Click on **'Save.'**
* Your newly made entry can be viewed under the '**Manual Transactions**' tab.
* **To see all your manual transactions**, proceed to the **manual transaction page** and **enter the segment** and **date** > **Click on Submit**.
* Your newly entered manual transaction entry can be found under the manual transaction page. These transactions will be reflected in your P\&L and tax calculation statements.
### If you have multiple *entries* to add, then you can use the '**upload** **option.'**
{% embed url="" %}
* In the **manual transaction page**, you can see an **upload icon**.
* Click on it, and a **pop-up message will appear**, asking you to '**Upload Excel Sheet**.'
* The Excel sheet format will be given in this pop-up window. Click on [**'*****Download Format***.'](https://1464797116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEX31Xx9NZFHlRfi6I1mp%2Fuploads%2FCOkOTGAqLl4EhLv1ro5J%2Fnew%20manual%20transaction%20excel.xls?alt=media\&token=102b40fb-d462-4bdd-94ca-bc88368f4eb7)
* An Excel sheet will be downloaded, in which you have to enter your transaction.
* Enter the date (in DD-MM-YY format), symbol/ISIN/Geojit security code, buy/sell, quantity, net rate, and transaction type (off-market/IPO/others/opening balance).
* Once you have entered the transactions in the Excel sheet, **save the sheet**.
* **Go back to the manual transaction page** and **click on the upload icon** again.
* **Drag and drop** the 'saved Excel sheet' or **browse the file**.
* Your **file will be uploaded successfully.**
* Your entries as per the Excel sheet will be displayed on the '**Manual Transactions**' page itself. These transactions will be reflected in your P\&L and tax calculation statements.
### Edit/Delete the entries in manual transactions
* On the '**Manual Transactions**' page, choose the desired **segment** and **date range**.
* Click '**Submit**.'
* Your preferred entries will be displayed.
* Find the option button  and **click on it.**
* You will be provided with two options: **Edit** and **Delete.**
* If you click on the edit button, you can make changes to the already entered transaction. Once done, click update.
* Click on the '**delete**' button to delete the entry made.
### How do I view the MF Transaction Report ?
You can view your mutual fund transactions—both redemption and purchase—in MyGeojit too.
{% embed url="" %}
* Tap on the '**Reports**' tab.
* Tap on the arrow mark 🔽 right next to the '**Trade Book**.'
* A drop-down menu will appear.
* Select **MF Transaction Report**.
* Select **Account ID** from the drop-down menu.
* Select **Transaction**.
* **Enter the date** (either you can set a custom date range using the calendar icon 📅 or choose from the preset options given below the date bar).
* **Click on Submit**.
* All your **MF transactions** of that specific date range will be listed out.
* You can **search** for a specific transaction from this list by entering the symbol name on the **search bar** given at the top.
{% embed url="