Manager - Finance & Accounts
56856 Points
Joined June 2010
Hi Sumeet,
You're on the right track wanting to track both sales commission and vendor payout separately for each client in Tally Prime. Below is a clear breakdown of:
-
Ledger Setup
-
Voucher Entry (Journal or Sales Invoice with cost centers)
-
Tracking Outstanding Commissions
๐ 1. Create the Following Ledgers in Tally Prime
Ledger Name |
Under |
Type / Notes |
Sales A/c |
Sales Accounts |
For gross sales |
Salesperson Commission |
Indirect Expenses |
Optional: use cost centers for client-wise |
Vendor Commission |
Direct Expenses |
Optional: use cost centers for client-wise |
Salesperson A (e.g., Raj) |
Sundry Creditors |
For tracking payable |
Vendor A (e.g., Akash) |
Sundry Creditors |
For tracking payable |
Client Name (e.g., ABC Ltd.) |
Sundry Debtors |
To record client sales |
๐งพ 2. Voucher Entry Options
Option A: Use Journal Voucher (Simple Method)
This is ideal if you're only recording commissions after a sale is done.
Example Sale Amount: โน100,000
-
Salesperson Commission @ 5% = โน5,000
-
Vendor Commission @ 10% = โน10,000
Journal Voucher:
โก๏ธ Now, you can track outstanding balances under Sundry Creditors and make payments later.
Option B: Use Sales Voucher with Cost Centers (Advanced/Better Tracking)
Step 1: Enable Cost Centers:
Step 2: Create Cost Centers for Each Client or Sale
Step 3: In Sales Voucher
-
Record Sales with service details
-
Split commission amounts using Journal Voucher (as above), but assign the cost center to each line item
โก๏ธ Later, generate reports like:
๐ก Tips:
-
Create separate ledger groups under Commission Payables if you want to better classify them.
-
Use Voucher Class in Tally to automate entries if commissions are fixed per sale.
-
You can also add narration like “Commission for ABC Ltd. on Invoice #123 dated xx-xx-xxxx” to trace back later.
๐ Reports You Can Use: