Case Study

How Blue Onion Reduced Month-End
Close From Days to Minutes

Client Name
Stealth

Industry
Ecommerce

Order Management System
Amazon Seller & Shopify

Payment Processor
PayPal & Shop Pay

About Full Stack Finance, an Escalon Company

Full Stack Finance embeds teams of experienced finance, accounting and HR professionals within Startups and high-growth businesses according to their operational needs. Full Stack ensures that their client's financials are ready for internal and external stakeholders.

Full Stack has a high-growth ecommerce client within the food and beverage industry. When the store first launched, it generated millions of revenue on the first day. The client acquired expert help from Certified Public Accountant Suzanne McNulla of Full Stack Finance to assist with their finance and accounting needs, including monthly close and financial reporting.

Reduced month-end data
processing time from:

Increased time efficiency
by over:

It used to take me 20+ hours per month per client to sync and download the order and payout data - not yet cleaned nor reconciled. It only takes me 15 mins with Blue Onion, and all the records are already reconciled.”

Suzanne McNulla
Full Stack Finance

Challenges

Given the high volume of daily transactions, Suzanne experienced layers of challenges before she could access the data to begin the process of month-end close.

Manual Data Download

With the large transaction volume from the ecommerce client, it took Suzanne 3+ hours to download order information from Shopify. Frequently, the files were too large to open, and the export would fail halfway through the process. To combat the file size downloading constraints, Suzanne started downloading the data in 3-day increments, adding even more time to the process. The data downloading process was then repeated for the payment processor and bank data. There was also a risk of an incomplete data set due to the arduous and manual downloading process.

Data Aggregation

All downloaded data was then aggregated and matched into a large spreadsheet, adding five more hours each month to the workload. In total, Suzanne spent more than 20 hours each month downloading, then aggregating the data set before she could reconcile the data for accounting and financial reporting. These challenges were time-consuming, frustrating, and inefficient.

THE Ecommerce client met Blue Onion

To streamline the monthly accounting close for the ecommerce client, Suzanne looked into different accounting software that could automate the order-to-cash reconciliation process. Her most important request was that the data from all three pillars - order management systems, payment processors, and bank payouts be synced. With Full Stack Finance's COO Andrew Chen's recommendation, Suzanne onboarded this stealth client to Blue Onion, a SaaS company that syncs and automates order-to-cash reconciliation and financial reporting for accountants in ecommerce companies.

20 minutes to onboard

Unlike typical accounting or SaaS software implementation time, it only took Suzanne 20 minutes to fully onboard the client onto Blue Onion's platform.

Automatically organized and clean data
ready to go

The process that previously took multiple frustrating hours, now with Blue Onion only takes about 15 minutes. The data is already synced and reconciled from the order to the payment processor, then to the bank payout.

Accessible information for actionable insights

With a streamlined workflow and a clean dataset, Suzanne can focus on delivering high-impact accounting and finance recommendations to her clients. For example, because Blue Onion offers an exportable audit trail of records, it's easy to find fulfilled and unfulfilled transactions. The Blue Onion platform provides accurate, accessible, and easy overviews of reconciled data, which translates to fast, and high-confidence data proof when the client asks Suzanne for advice.

Blue Onion Pro-tip from Suzanne

In addition to the time savings, when Suzanne calculates COGS for the month's end, she can do a direct match on fulfilled orders through Blue Onion, giving both her and the client's accounting team more accurate information and greater confidence that the business is scaling efficiently.

The journey continues

Blue Onion has eliminated the arduous process of manual data downloading, syncing, and reconciling. Suzanne has not only saved days each month but done so with data integrity and confidence. With no more manual data pull and reconciliation, Suzanne and the client's accounting team can focus on growing and scaling the business. Through Full Stack Finance, Suzanne has introduced and onboarded her portfolio of ecommerce clients with Blue Onion.

* 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!