Revel to QuickBooks: Daily Sales Export Template
A nightly workflow that pulls the day's Revel sales and pushes a summary into QuickBooks so your daily takings land in the books automatically.
What It Builds
A Schedule trigger fires every night and a Revel Connector node (Direct mode) pulls the day's sales. A Transform node rolls them into a daily summary, and because QuickBooks has no native tile, Spojit's http connector posts that summary to the QuickBooks REST API. The result: each morning your accounting books already show yesterday's takings.
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:30 PM, pulls the day's sales totals from Revel, summarizes them into total revenue, tax collected, and order count, and then connects to the QuickBooks API to create a daily sales receipt for that amount in my accounting books.
Connectors Used
- Schedule - the nightly trigger that starts the run on a cron schedule.
- Revel - reads the day's sales, tax, and order totals from your POS.
- QuickBooks - no native tile, so Miraxa connects to its REST API through the http connector to record the daily takings.
Customize It
Change the run time in the prompt to match your closing hour and time zone, adjust which figures you summarize (gross sales, discounts, tips, refunds), and tell Miraxa whether to post one combined receipt or split takings per location or payment type.
Tips
- Your QuickBooks API credentials need write access to create sales receipts; add them as a connection before the first run.
- Keep the Revel read in Direct mode for a predictable, no-AI-cost pull of the day's totals.
- Run it shortly after close so the day's sales are final but the books are ready by morning.