Sales commission and vendor commission

A/c entries 103 views 1 replies

Hi, i need help with a tally prime entry.

Lets understand the business model.

1. My business sells services to clients and not a retail product.

2. I have got a sales person to make sales and get a percentage of 5 % on gross sale

3. I got another person/vendor who helps to complete the service on the sale made and receives 10% on gross sales.

4. How can i make an entry so that i can easily track things on tally based on sales commision due to be paid and vendor commission to be paid for each of the clients 

 

Thanks in advance 

 

 

Replies (1)

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:

  1. Ledger Setup

  2. Voucher Entry (Journal or Sales Invoice with cost centers)

  3. 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:

 
Dr. Salesperson Commission A/c โ‚น5,000 Cr. Salesperson A (Raj) โ‚น5,000 (To record payable) Dr. Vendor Commission A/c โ‚น10,000 Cr. Vendor A (Akash) โ‚น10,000 (To record payable)

โžก๏ธ 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:

  • Go to: F11 > Accounting Features > Enable Cost Centers (Yes)

  • Also: Enable "Use Cost Centre for: Ledger"

Step 2: Create Cost Centers for Each Client or Sale

  • E.g., "Client – ABC Ltd."

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:

  • Cost Centre Breakup

  • Outstanding Payables to Salesperson/Vendor per client


๐Ÿ’ก 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:

  • Outstanding Payables (Display > Statements of Accounts > Outstanding > Ledger)

  • Cost Centre Reports (Display > Cost Centres > Ledger Break-up or Cost Centre Break-up)


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register