Accounting for Ecomsync
Setup:
Create new GL Code for the following:
a. Lazada (Current Asset) - this GL also serves as Contra GL for payment side
b. Lazada Supplier - this GL also serves as Contra GL for the AP side
b. Lazada Commission (Expenses)
c. Lazada Shipping Fee (Expenses)
2. Create new cashbook for Lazada and link it to Lazada GL
Transactions:
3. EMP will auto-create SO and RCT based on the syncing from Ecomsync.
4. The RCT should auto-select Lazada Cashbook.
5. Next, user need to convert SO to INV.
6. The following are the Journal entries for INV and RCT
INV (GL) | DR | CR |
---|---|---|
AccReceivable | RM 100 |
|
generalSales |
| RM 100 |
RCT (GL) | DR | CR |
---|---|---|
Lazada Cashbook | RM 100 |
|
AccReceivable |
| RM 100 |
7. When receive the report from Lazada for the deduction, user need to create SINV and PV to offset the amount.
8. The following are the Journal entries for INV and RCT
SINV (GL) | DR | CR |
---|---|---|
Lazada Commission | RM 15 |
|
Lazada Shipping Fee | RM 5 |
|
accPayable (Lazada) |
| RM 20 |
PV (GL) | DR | CR |
---|---|---|
accPayable (Lazada) | RM 20 |
|
Lazada Cashbook |
| RM 20 |
9. The amount has been offset for Lazada Cashbook and Lazada (supplier). The balance amount at Lazada cashbook is RM 80, after deduct the commission and the shipping fee.
10. The following is the Profit and Loss and Balance Sheet report.
Private & Confidential