NetSuite and FTP: Monthly Trial Balance Export Template
A Spojit template that exports your NetSuite trial balance as a CSV and drops it into an FTP archive folder on the first of every month, ready for the close.
What It Builds
A Schedule trigger fires on the first of each month and runs a financial query against NetSuite in a Connector node. A Transform node formats the returned account balances into a clean trial balance, the csv utility turns it into a file, and an FTP Connector node uploads it to your archive folder. Your accountant pulls the same file path every cycle.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs on the first of every month, queries NetSuite for the current trial balance (account number, account name, debit, and credit per account), formats the results as a CSV with a header row, and uploads the file to the /accounting/trial-balance folder on our FTP server named with the reporting month, for example trial-balance-2026-06.csv.Connectors Used
- NetSuite - runs the financial query that returns account balances. Schedule trigger.
- FTP - uploads the finished CSV to your archive folder.
- csv - built-in utility that builds the file from the query rows.
Customize It
Change the cron timing in the prompt for a weekly or quarterly run, swap the /accounting/trial-balance path for your own folder, adjust the included columns (add subsidiary or period), or change the filename pattern. You can also point the upload at a different subsidiary's books by naming it in the prompt.
Tips
- Give the NetSuite connection read access to your financial/saved-search data so the query can return balances.
- Use a Connector node in Direct mode for the NetSuite query when the report shape is fixed; it runs with no AI cost.
- Confirm the FTP archive folder exists and the connection has write permission before the first scheduled run.