Guides

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

Curtosis diagram: How to automate weekly sales reports from NetSuite or QuickBooks

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.

SectionWhat to show
SalesNet sales for the week, against last week and the same week last year
CustomersTop customers and the biggest changes
ProductsBest sellers, and products that dropped
OrdersOpen orders and what ships next week
CollectionsOverdue 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.

AI agents & automationAsk Destila: case studyPricing

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.

Book a 20-min call (opens a booking calendar)