How to tally for e-commerce sales.

2959 views 3 replies

hi, 

my name is amit and i am very new to accounts and tally as well.

i have a lot of doubts on how to work with tally for accounting online sales on ecommerce websites.

lets start with a example with which alot of questions arose in my mind.

1. i am selling a product "xyz" on a ecommerce website "PQR"

so how do i start with tally.what all ledgers i need to create and how the transaction is billed in tally.

2.i am selling on "PQR" but the buyer is "MNO" so how do i create a sales voucher, because i will be getting money from "PQR" and not from  " MNO" but the billing should be done on "MNO".

so with doubt no 2. what all group items ledgers and sales voucher are created accordingle.

3. i am selling product "XYZ" which includes all the taxes and shipping fees and packing charges and handling charges for a fixed amount of "abc.xy" but the shipping is taken care by the "PQR". so how do i input the necessary things in tally with all the data.

 

lets start with these 3 doubts .

but trust me i have many more doubts which i dont even know how to describe them accordingly.

Replies (3)

1. Create Stock Item "XYZ"

2. Create a Ledger "PQR - Marketplace" under Sundry Debtors

3. Go to Gateway of Tally (GOT) -> Accounting Vouchers -> Sales -> Press F12 (Configure) and Enable "Accept Supplementary Details"

4. Go back to the Sales Invoice and Enter Party name as "PQR-Market place". After that it will ask the Buyer Name etc, where you can enter the Customer MNO and the address. etc.

5. Complete the other details as usual and Now Check the Invoice and ledger reports. I think this will meet your requirement.

6. You can see that Invoice prints the customer MNO, while if you check the ledger reprot of "PQR-MarketPlace" you will find this particular invoice as its outstanding

 

For the complete integrated solution from sales to sales return to settlement of the orders without customizations in Tally visit www.ecom2tally.com 

UN - demo @ ecom2tally.com

PW - 789

 

Dhaval Goradia - 7710010371

Hello!

How did you solve your problem no. 3? I have same issue. 

How do I account the commission (less vat) and the processing fee deducted by ecommerce on Tally. Of course I get an invoice from ecommerce for their charges (excluding the total money paid by customer online).


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register