Case Study

NetSuite Integration: How It Works

Accounting for Ecommerce Has Become Increasingly Complex

Businesses are frequently selling online and in physical retail locations, offering several different payment methods, accepting multiple currencies, and adding third-party applications to power return services, gift cards and loyalty programs. This is in addition to the sheer volume of transactions that may get processed on a daily or weekly basis.

Why it Matters

In its simplest form, the business sells a good or service and you want to confirm the payment in the bank account. This process maintains the integrity of key financial figures and ensures there’s no unexpected cash loss occurring.

The Current Challenge

Orders and refunds are flowing into NetSuite but there’s not an easy way to match the cash sale (or customer deposit) to a payout in the bank account. The challenge comes from both the complexity and volume of transactions for a typical ecommerce merchant.  

We see teams solving this in two ways today:

  1. Investigating each payout and manually matching each order to a bank settlement in order to clear out the holding account. In a time of limited resources, this can be an extremely expensive, monotonous, and time-consuming task.
  2. Not matching each cash sale to a payout and instead booking top-side journal entries to clear the holding account and reconcile the bank account. This approach makes it difficult to find and correct errors in key financial figures and identify areas of cash loss.


Have confidence in key financials with an order audit trail from point of sale to bank payout

Blue Onion leverages proprietary algorithms to automatically match each cash sale to a bank settlement, creating an order audit trail and automating the order-to-cash reconciliation process for each transaction.

Save days by automating bank reconciliation

Eliminate the time-consuming task of manually applying cash settlements to orders. Blue Onion automates the process so you can simply click ‘approve.’

Quickly and easily identify issues in your NetSuite order data

Connect to the source data for your orders and payments, which allows us to independently verify your NetSuite order data and identify discrepancies or missing transactions.

Connect all of your payment processors— or easily reconcile new ones

Blue Onion offers a breadth of payment processor integrations (20+ and growing) so you can easily reconcile new payment methods without additional cost.

How It Works

Verify NetSuite Sales with General Ledger Order Reconciliation

Before beginning the process of reconciliation Blue Onion verifies the order dataset in NetSuite and identifies discrepancies for easy investigation. Blue Onion connects to the order and payment source data, which uniquely allows us to run a reconciliation between your NetSuite orders and the already reconciled Blue Onion data.

Three-Way Match Between Sale, Payment, and Bank Payout

Easily see bank account settlements reconciled to the payment processor detail in Blue Onion, which has been reconciled to your NetSuite transactions. You can then select the reconciled bank settlements that you would like to import into NetSuite, which generates a detailed journal entry that includes originating order and cash sale information along with transaction and payout-level fees.

Automate Bank Reconciliation

The Blue Onion entries clear out the holding account with transaction-level detail. In the bank account detail, you’ll now be able to see account transactions that match to cash settlements in the bank account. Run the reconciliation rules within NetSuite and the settlements are automatically matched and ready for your review.

Customize with Chart of Accounts Mapping

Easily map payments, orders, transactions, and payout fees to your custom Chart of Accounts.

* While we are a team of former accountants, we are not in the business of providing professional services. The information presented is for informational purposes only and is not intended to be a substitute for professional accounting, tax, or legal advice. We recommend that you consult with a qualified accountant, tax advisor, or lawyer who is familiar with the specific needs and nuances of your business.

Ready to learn about Blue Onion?

Trusted by top brands, Blue Onion revolutionizes the order-to-cash reconciliation process, slashing closing times, ditching manual reconciliations, streamlining data cleaning, and boosting revenue visibility. Get to know more about us and see our solution in action today!