Revel to NetSuite: Daily Sales Posting Template

Each night this Spojit template pulls the day's Revel orders and posts a sales summary into NetSuite, so finance has POS revenue in the ledger without manual entry.

What It Builds

A Schedule trigger fires once a night and a Revel Connector node pulls the orders closed that day. A Transform node rolls them up into a single sales summary (gross sales, tax, discounts, order count), then a NetSuite Connector node writes that summary as a record in the ledger. The result is a clean, repeatable nightly post with no spreadsheets in between.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that runs every night at 11:30pm, pulls the day's closed Revel orders, totals up gross sales, tax, discounts, and order count, and posts that daily summary as a record in NetSuite so finance has the POS revenue in the ledger.

Connectors Used

Schedule trigger - runs the workflow once per night on a cron time and time zone you set.
Revel - reads the day's closed orders and their totals.
NetSuite - posts the daily sales summary as a ledger record.

Customize It

Change the run time in the prompt to match your close-out, adjust the date window if your business day crosses midnight, and edit the summary fields (add tips or per-location splits). You can also name the exact NetSuite record type or account you want the summary posted to.

Tips

Give the NetSuite connection write access to the record type you are posting, and the Revel connection read access to orders.
Use Direct mode on both Connector nodes for predictable, AI-cost-free reads and writes.
Run a manual test for one day first to confirm the totals line up before letting the schedule take over.