Customer story

How EliseAI automated reconciliations with SuperAgent

When EliseAI moved from QuickBooks Online to NetSuite, years of history stayed behind in the old system, and every customer statement inquiry meant stitching exports together with lookups and scripts. Financial Controller Jace Lau connected SuperAgent to both systems, taught it the team’s rules once, and now his billing, collections and revenue leads get reconciled statements ready for a final review.

“
We haven’t had to reprompt SuperAgent once. At first we checked every answer. Over time, we came to trust it completely.
Jace LauJace LauFinancial Controller, EliseAI
90%
of the work is done by SuperAgent, humans do one final review
Seconds
to prepare a customer statement that used to take exports, lookups and scripts
0 retraining
teammates reuse what one person teaches it

EliseAI is an artificial intelligence company. Its finance, accounting, engineering, and customer success teams all build with AI under a company-wide mandate to go out and build. Jace Lau is the financial controller, leading a team across billing, collections, and revenue.

Industry
Artificial intelligence
Role
Financial Controller
Data lives in
Salesforce, NetSuite, QuickBooks Online, Google Sheets
Team
13 across finance and accounting, including the CFO
How EliseAI’s controller team changed its data work

Before

  • Every customer statement inquiry started with two NetSuite saved searches exported to CSV
  • Each report was pasted into its own sheet and reconciled by hand
  • The analysis ran on XLOOKUPs, VLOOKUPs, pivot tables, and custom scripts
  • Pulling prior QuickBooks Online history alongside current NetSuite data meant stitching two systems together

After

  • SuperAgent connects to both QuickBooks Online and NetSuite and pulls the data on its own
  • It prepares the statement and the reconciliation, and the team reviews and confirms accuracy before sending to the customer
  • What one person teaches SuperAgent, the whole controller team reuses without retraining it
“SuperAgent does the reconciliation. We do the sign-off.”

Jace Lau · Financial Controller, EliseAI

The long version

For anyone sizing up the same build

THE PROBLEM

A single “what do I owe?” from a customer meant two reports, copy-paste and lookups

EliseAI keeps its transactions in NetSuite. Answering a customer question about an account meant generating a saved statement-of-account report and a separate transaction report, downloading both as CSVs, and pasting each into its own sheet. The team then stitched the two together and reconciled them so the numbers held up before anything went back to the customer.

The analysis ran on lookups, pivots, and scripts

Each reconciliation ran on XLOOKUPs, VLOOKUPs, and pivot tables, plus some scripts the team wrote to automate parts of the work. It still took real time on every request.

Prior ERP history sat in a second system

EliseAI migrated from QuickBooks Online to NetSuite a little over a year ago, and not every transaction moved across. Analyzing anything from before the move meant stitching two systems together by hand.

“
That process was extremely time-consuming. We exported saved search reports from NetSuite, then copied and pasted that data into a Google Sheet or Excel. We ran XLOOKUP, VLOOKUPs, pivot tables, all the good things.

Jace Lau · Financial Controller, EliseAI

THE BUILD

Jace connected SuperAgent to both QuickBooks Online and NetSuite, and to the Google Sheets the team already works in through Coefficient's connectors. SuperAgent pulls the data and prepares the analysis, and the team reviews the result and confirms it before sending anything to a customer.

SuperAgent also picked up how EliseAI works. It learned the rules the team runs on, including the 30-360 day proration logic specific to how EliseAI bills, and the team has not had to reprompt it to rerun the numbers. If I teach it something new, the rest of the group just inherits the update, no one has to retrain it.

“
Before migrating to NetSuite a little over a year ago, we were using QuickBooks Online, so there is a lot of legacy activity we have maintained. We were able to connect both QuickBooks Online and NetSuite, and SuperAgent could run the analysis and understand the queries we were trying to prompt.

Jace Lau · Financial Controller, EliseAI

WHAT CHANGED

SuperAgent learned how EliseAI works

Because SuperAgent holds the context, the team asks a question and gets an answer that already follows EliseAI's rules. Confidence in the output grew as the team checked early results against the source and found them right.

“
We haven't really needed to reprompt SuperAgent to rerun the numbers for us. The fact that the information is readily available gives us confidence that the data is accurate.

Jace Lau · Financial Controller, EliseAI

One knowledge base the whole team reuses

Jace is not the only one on SuperAgent. Alex, the accounting billing manager, runs it on billing. Sarah, who leads collections, runs it on collections. Brett, the assistant controller, runs it on revenue. Each person works independently, and because their roles overlap, what one person teaches SuperAgent the others can pick up.

“
As I train SuperAgent to do a particular task, I know for a fact that my other team members can use the same knowledge base. They can go right into SuperAgent and ask their questions without needing to retrain the agent.

Jace Lau · Financial Controller, EliseAI

The team still drops into a spreadsheet to drill in

The team reads the snapshot in SuperAgent first. When a question needs more digging, they export into Google Sheets or Excel and work there.

“
As accounting professionals, we live and die by Excel and Google Sheets. We look at the snapshot in SuperAgent, and when we need to drill into more data, we export into a Google Sheet or Excel.

Jace Lau · Financial Controller, EliseAI

Data sources
QuickBooks Online, NetSuite, Google Sheets
Surface
SuperAgent, with exports to Google Sheets and Excel
What runs on it
Customer statement-of-account inquiries, invoice reconciliation, reporting
Who uses it
The controller team across billing, collections, and revenue
Built by
Jace Lau and his controller team
Replaced
Exporting NetSuite saved searches and reconciling them in spreadsheets by hand
Results

What EliseAI got back

90%
of the work is done by SuperAgent, humans do one final review
Seconds
to prepare a customer statement that used to take exports, lookups and scripts
0 retraining
teammates reuse what one person teaches it
“I keep my advice pretty simple. The barrier to entry is low and upside is real. What matters is that you start somewhere. The longer you wait, the further you might fall behind. SuperAgent will help your team focus on the work you want to do, and free up the time you spend on mundane tasks.”

Jace Lau · Financial Controller, EliseAI