NS Setup for Retail/Ecom Businesses For companies...
# general
l
NS Setup for Retail/Ecom Businesses For companies with relatively low dollar but high volume sales which may result in about a million of standalone cash sales and/or SOs in a year especially those with a lot of locations/retail stores (e.g., grocery business), how do you record your sales transactions? Do you use a third-party ETL tool that aggregates the data before it gets pushed into NS? Due to our volume of sales transactions, we are planning to aggregate the daily sales. For POS, we would just create one standalone invoice per day per location with separate customer payments per payment method. Any thoughts?
f
If you have the POS system already, then better to aggregate the daily sales transaction per location. And keep in mind that total lines in Invoice should not be beyond 500. I do this approach for all of my F&B clients
a
Hi Luis - our Netsuite integration solves for exactly that if you want to reach out
👍 1
l
@Fakhri Hilmi what tool do you use to aggregate the data?
Alex, do you base the reconciliation off the aggregated data?
a
Hi Luis - we can do either a daily payout reconciliation, or we can do a transaction level reconciliation that will deposit all of the cash sales as a deposit record into netsuite, while recording on the related fees/chargebacks/etc that are included in the payout from each payment processor. Happy to setup some time to quickly go through either setup if you want to email me at alex@blueonionlabs.com
f
I summarized the data using google big query before sending it to NetSuite