Seller ledger

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.

Go to Sellers > Seller Ledger section in StoreHippo Admin Panel.

In the seller ledger, two tabs are present:

All: In this tab, all the transactions will are present with the complete list of credit and debit entries for all sellers or selected sellers.
Order wise: In this tab, the order wise transactions are listed as shown below.

You can click on an order and all the transactions related to that order will be listed. You can also filter the transactions by a time range.

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 Shipping Fee: If an Order Shipping Fee is defined, then a transaction will be created with the order shipping fee for every order that is shipped.

Order Placed: When an order is placed, the paid amount of the order will be credited to the seller.

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.

COD Remittance: For COD orders, the amount of the order will be credited to the seller once the amount is received from the logistics provider.

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.

Charges on a seller order

Following is a sample calculation of charges on a seller order:

ITEM	AMOUNT (RS.)
Selling Price (decided by the seller)	1500
Commission (Product Selling Fee)	150 (assuming 10%)
Shipping Charges	30
Total Marketplace Fee	180
Service Tax (assuming 15%)	27
Total deductions	207
Net Amount credited to the seller	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.

Adding New Seller Ledger

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:

Seller

In the Seller field, you can add the seller you want by choosing from the existing sellers. It is a mandatory field.

Type

In this field, the type of transaction,i.e. credit or debit is chosen. It is a mandatory field.

Amount

The amount which you want to takeas a fee/commission from the seller is provided here. It is also a mandatory field.

Action

The action about the product is provided here.

Description

Any description regarding the seller is provided in this field.

Tax

In Taxes, you can add the taxes.

Chargeable

You can mark the checkbox if you want it to be chargeable. It is valid only under the debit field.

Generating Invoices

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.

Importing Seller ledger

Import Seller Ledger functionality is available only in Business plans and onwards.

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.