How to automate weekly sales reports from NetSuite or QuickBooks
Start with what's built in: NetSuite can email saved searches and reports on a schedule, and QuickBooks Online can email saved custom reports automatically. When you need numbers from more than one system, week-on-week comparisons, charts or a written summary, an automation pulls the data through the API, builds the report and sends it on schedule.
By Curtosis · Updated

What can NetSuite and QuickBooks do on their own?
In NetSuite, saved searches and reports can be scheduled and emailed to people or groups. In QuickBooks Online, save a report as a custom report, then set a schedule to email it, for example every Monday morning.
If one report from one system is all you need, stop there.
Where do the built-in schedules stop?
- numbers from more than one system, like the ERP plus a CRM or a spreadsheet
- comparisons with last week, last year or a target, worked out for you
- charts, and a written summary of what changed
- a different version of the report for each manager
What should a weekly sales report include?
Decide first whether “sales” means orders booked, invoices issued or cash collected. They give different numbers.
| Section | What to show |
|---|---|
| Sales | Net sales for the week, against last week and the same week last year |
| Customers | Top customers and the biggest changes |
| Products | Best sellers, and products that dropped |
| Orders | Open orders and what ships next week |
| Collections | Overdue invoices and the total outstanding |
How Curtosis does it
Curtosis builds reports that build themselves: daily or weekly reports with totals, charts and tables, sent to the right people on schedule.
Ask Destila, the AI agent about 1,000 people use at a manufacturer, builds a report from one sentence and runs it on a schedule, like every Monday at 9:00, exported as HTML or PDF.
What we build runs in your accounts. Access is read-only by default, we don't keep your data, and training by AI providers is turned off.
Projects start at $1,000, at a fixed price agreed in writing before work starts.
Questions
Where does the report go?
By email, or wherever your team already works. Tell us on the call and we'll confirm.
Can it pull from more than one system?
Yes, if each system has a database, an API or exports: your ERP, your CRM and the spreadsheets people keep on the side.
How much does it cost?
With Curtosis, projects start at $1,000, at a fixed price agreed in writing before work starts. Ongoing changes, if you want them, are billed monthly.