Hi Team,
I have a scenario wherein the webstore (Shopify) is integrated to NetSuite using Celigo Shopify and NetSuite Integration.
How the process works is that:
- A customer orders a transactions in the webstore then;
- Celigo automatically posts a sales order in NetSuite
- Then fulfillment happens also in NetSuite
- Payment is being done through Shopify then Shopify remits the payments in bulk for the transactions ordered
The situation right now is that the transactions are not being shown in the match bank data page. Which does not allow for an actual reconciliation. I believe it occurs that way since there are no transactions that impacts the bank since the payments is being coursed through a bulk transaction from shopify.
I'm assuming this is related to the celigo integration since what is being created are "sales orders" which are non posting transactions.
My question is that in line with this process.
- How do companies usually account for revenue?
- Does celigo integration create invoices automatically based on committed/fulfilled orders?
- Do we simply create invoices from the sales order and record manual payments and deposits? I find this approach very tedious and really defeats the purpose of integration since there are a lot of transactions being created.
What would be the best way or practice to approach this particular scenario. This is quite common in the ecommerce industry wherein payments are being received by webstore providers then remits it to the customer in bulk.
Please advise.
Thanks