DealBook — User Guide

Introduction

What is DealBook?

DealBook is a SaaS CRM designed for forex and commodity trading brokerage firms. It manages a multi-level hierarchy of Masters, Brokers, and Clients, calculates commission distribution from imported trade history, and generates profit-sharing reports.

Role	Login URL	Notes
Admin	`https://metacrm.builcon.uk/public/login`	Tenant owner. Full access to all features.
Master	`https://metacrm.builcon.uk/public/login`	Numeric login code + password.
Broker	`https://metacrm.builcon.uk/public/login`	Numeric login code + password.
Client	`https://metacrm.builcon.uk/public/login`	Numeric login code + password.

ℹ️

After logging in, every user lands on their role-appropriate dashboard.

Structure

User Hierarchy

DealBook uses an N-level tree. Commission flows upward from the client trade through every ancestor to the top of the chain.

Upline (optional, above Admin — receives a fixed %)
  └── Admin (tenant owner, starts with 100% pool)
        ├── Master
        │      └── Sub-Master (any depth)
        │              └── Client
        └── Broker (commission per trade, not hierarchy %)

⚠️

Upline users can only be created by Admin and only one is allowed per account.

Understanding %

Commission Model

When creating a Master, you enter the percentage you want to keep from that node's pool.

Example

Admin (enters 20 → keeps 20%)
└── Master A (enters 25 → keeps 25% − 20% = 5% net)
└── Sub-Master B (enters 60 → keeps 60% − 25% = 35% net)

User	You Enter	Net Earnings per Trade
Admin	`20`	Admin earns 20% of total profit
Master A	`25`	25% − 20% = 5% net
Sub-Master B	`60`	60% − 25% = 35% net

✅

Rule: Each Master must enter a higher % than their parent. E.g. if Admin entered 20, Master must enter at least 21.

Step 1

Market Setup — Segments & Scripts

Before creating users or importing trades, set up your trading segments (e.g. NSE, MCX, FOREX) and the scripts within each segment along with their lot sizes.

Create a Segment

1

Go to Market Setup → Segments & Scripts

From the sidebar, click Market Setup → Segments & Scripts.

2

Click "Add Segment"

Enter the segment name (e.g. NSE Cash, MCX) and save.

Add Scripts (Instruments) with Lot Size

1

Click the segment name

Opens the scripts page for that segment.

2

Add scripts manually or bulk upload via CSV

Each script needs: Script Name, Lot Size, and optionally a Global Rate (₹/lot). Download the sample CSV from the page.

⚠️

Set lot sizes correctly before your first import — they are used to calculate brokerage.

Script CSV Format

Column	Field	Example
A	Script Name	RELIANCE
B	Lot Size	250
C	Global Rate (₹/lot)	20

Step 2

Creating Users Manually

Go to Users → Create User. The form adjusts based on which user type you select.

Creating a Master

1

User Type → Master

Select Master from the dropdown.

2

Fill Basic Info

Enter Full Name, Login Code (numeric, unique), and Password.

3

My Percentage

Enter the % you want to keep from this master's trades (e.g. enter 15 to keep 15%). Valid range is shown in the hint below the field.

4

Click Create User

Creating a Client

1

User Type → Client

Broker selection section appears.

2

Select Master

Choose which master this client belongs to. The master's brokers load automatically.

3

Select Brokers & click Create User

Creating a Broker

1

User Type → Broker

Enter Name, Login Code, Password.

2

Set Commission Rates per Segment

For each active segment, enter the broker's rate (₹/lot).

3

Click Create User

Step 3

Bulk Import Masters via CSV

Go to Users → List and click the green Import Masters button.

Col	Field	Required	Notes
A	Name	✅	Master's display name
B	Login Code	✅	Unique numeric code
C	Password	✅	Min 6 characters
D	Percentage	✅	% you want to keep (e.g. `15`). Must be greater than parent's % for sub-masters.
E	Parent Login Code	Admin only	Leave blank to create directly under you. Enter a master's code to create a sub-master.

💡

Click Download Sample CSV on the import modal to get a pre-filled example file.

Step 4

Bulk Import Clients via CSV

Go to Users → List and click the blue Import Clients button.

Col	Field	Notes
A	Name	Client display name
B	Login Code	Unique numeric code (also used as trade login ID)
C	Password	Min 6 characters
D	Master Login Code	The master this client belongs to
E	Broker Login Code(s)	Comma-separated if multiple: `1001,1002`

ℹ️

If the file contains unknown login codes, an assignment screen appears. Select a master and broker for each and click Add — they are created immediately. Once all are assigned, Proceed with Import becomes available.

Step 5

Import Trade History (Excel)

Go to Import File from the sidebar. All commission calculations flow from trade imports.

1

Select Valan (Period)

Choose or create a Valan — the accounting period this trade batch belongs to (e.g. April Week 1).

2

Upload the Excel File

The system reads columns A–V starting from row 4. Key column is Profit. Script names must match your Market Setup.

3

Handle Unknown Users (if any)

Select master and broker for each unknown login code and click Add. Row locks when done.

4

Click Proceed with Import

Commission ledger entries are generated automatically for all users in the hierarchy.

💡

You can re-import or delete a batch from the Import Report page. Deleting a batch reverses all its ledger entries.

Step 6

Reports

Summary Report

Go to Accounts → Summary Report. Shows the commission breakdown per master, per valan. Filter by Valan and click any master row to drill down.

Trade History Report

Go to Trade History from the sidebar. Shows every trade imported, filterable by client, script, valan, and date. Use the export buttons for Excel/PDF.

Account Ledger

Go to Accounts → Account Ledger. Shows all debit/credit entries per user.

Entry Type	Description
`client_pnl`	P&L settled between client and their direct master
`broker_comm`	Commission paid to each broker
`hierarchy`	Commission flowing up through the master hierarchy

Trial Balance

Go to Accounts → Trial Balance. Shows each user's net running balance. Positive = money owed to them; negative = they owe.

Cash Entry / JV Entry

Manual accounting entries outside of trade imports. Found under Accounts → Cash Entry and Accounts → JV Entry.

Reference

Quick Reference

Workflow Checklist

1

Market Setup

Create segments → Add scripts with lot sizes and rates.

2

Create Brokers

Add brokers with per-segment commission rates.

3

Create / Import Masters

Manually or via CSV. Set correct % for each level.

4

Create / Import Clients

Assign each client to a master and one or more brokers.

5

Import Trade Excel

Select valan → Upload file → Resolve unknown users → Confirm.

6

Review Reports

Summary Report → Account Ledger → Trial Balance.

Common Issues

Issue	Fix
Unknown login codes on import	Use the assignment popup to create the client.
Commission not calculating	Ensure all masters have a percentage set and clients are assigned to a master.
Script not found on import	Script name in the Excel must exactly match Market Setup (case-insensitive).
Login code already taken	Each login code must be unique across all users.
Percentage entry rejected	Your entered % must be higher than your parent's entered %. Check the hint text on the form.