In a multi-seller marketplace, admin and sellers need to keep a track of different transactions that take place in their accounts. It allows you to view and manage these transactions.
In the seller ledger, two tabs are present:
Transactions in seller ledger are generated for the following actions:
Product Listing Fee: If a Product Listing Fee is defined in Seller Ledger Rules, then a transaction will be created with the product listing fee for every product added.
Product Selling Fee: If a Product Selling Fee is defined in Seller Ledger Rules, then a transaction will be created with the product selling fee for every product that is sold.
Order Cancelled: When an order is canceled, the paid amount of the order will be debited from the seller's account.
Order Shipped: If the seller has used the shipping services to ship the product then the shipping charges will be debited from the seller's account.
TCS: If TCS tax is enabled in your store, the tax is payable by a seller. The debit entry of 1% of the total amount of the order value is added in seller ledger.
|Selling Price (decided by the ||1500|
|Commission (Product Selling Fee)||150 (assuming 10%)|
|Total Marketplace Fee||180|
|Service Tax (assuming 15%)||27|
|Net Amount credited to the ||1293|
StoreHippo's multi-seller implementation uses the marketplace model where the seller is selling the products directly to the customer and the marketplace is acting as a facilitator. Seller is responsible for generating the invoice to the customer. Seller is also responsible for charging the applicable taxes (VAT, GST, etc.) on the product which will be applicable to the product selling price.
You can add new seller ledgers by clicking on Add New. By clicking on add new, a new tab will open with the following fields:
In the Seller field, you can add the seller you want by choosing from the existing sellers. It is a mandatory field.
In this field, the type of transaction,i.e. credit or debit is chosen. It is a mandatory field.
The amount which you want to take
The action about the product is provided here.
Any description regarding the seller is provided in this field.
In Taxes, you can add the taxes.
You can mark the checkbox if you want it to be chargeable. It is valid only under the debit field.
You can generate the invoices for all or specific sellers. You can also define the period for which the invoices should be generated. Thus, the unbilled transactions lying in the specified time period only are included in the invoices. You can opt to generate invoices for the current month, last month, last 30 days, any custom range or since the beginning by clicking on Generating Invoices.
You can import seller ledger in bulk through CSV file.
Go to Sellers panel and click on Export under ellipses.
You will see a pop-up dialogue box with various export options. You need to check the 'Show Ledger Columns' and then press the 'Send email' option.
Your CSV will be exported instantly. It will be sent to you via email on your registered email ID. You can also check the CSV file out in the Logs section.
Click on the Export Logs section and look up the latest entry. Be sure to check the timestamp to verify if it's the right exported file.
Click on View File link in the Records as shown below
This opens a CSV/Excel file, it looks something like this.
You can define multiple seller ledger entries in this CSV file, in bulk. Go to the columns named Type, Amount, Action, Description, etc. Fill in the relevant ledger entries to set up the rules you want.
Go back to the Seller Ledger section under the Sellers menu. Click on the ellipses and click on the Import button.
A pop-up box will appear asking you for a file to import. Select the file and then click the import button.
After the import is done, go back to the Seller ledger section. You will see the new rules you applied in the CSV file.
Your bulk import is done. Very easy.