NetSuite and FTP: Daily Aged Receivables Export Template
A scheduled Spojit workflow pulls your open NetSuite invoices, groups them into age buckets, and drops an aged-receivables CSV onto an FTP folder your finance team collects each morning.
What It Builds
A Schedule trigger fires once a day. A NetSuite Connector node queries open invoices with their balances and due dates, a Transform node sorts each invoice into current, 1-30, 31-60, 61-90, and 90+ day buckets and builds a CSV, and an FTP Connector node uploads the file to a collection folder.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every weekday at 7am, queries all open invoices in NetSuite with their customer name, invoice number, amount due, and due date, groups each invoice into aged-receivables buckets (current, 1-30, 31-60, 61-90, and 90+ days overdue), builds a CSV summarizing the totals per bucket plus the line-by-line detail, and uploads it to the /receivables folder on our FTP server named with today's date.Connectors Used
- Schedule trigger - runs the export on a daily cron, in your timezone.
- NetSuite - reads open invoices, balances, and due dates.
- FTP - uploads the finished CSV to a shared folder.
Customize It
Change the run time, the bucket ranges, or the /receivables path right in the prompt. You can add columns like salesRep or terms, filter to a single subsidiary, or switch the file name pattern. To email the report instead of (or alongside) the upload, add a Send Email step.
Tips
- Your NetSuite connection needs read access to invoice and customer records.
- Use Direct mode on the FTP node for a predictable single upload; no AI cost.
- Aging is calculated from the due date at run time, so the buckets stay accurate every morning.