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.
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
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
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
What EliseAI got back
“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