Upload NetSuite XLSM and CSV financial exports into ReturnPro staging tables.
npx skills add https://github.com/clenisa/optimal-cli --skill upload-netsuite
Please help me install this Agent Skill. Skill: upload-netsuite Source: https://github.com/clenisa/optimal-cli/tree/main/skills/upload-netsuite Command: npx skills add https://github.com/clenisa/optimal-cli --skill upload-netsuite
Automates ingestion of NetSuite financial exports into ReturnPro staging to eliminate manual parsing, mapping, and inconsistent staging data that slow FP&A workflows.
Run optimal upload-netsuite with the --file path and optional --month to parse and load a NetSuite XLSM or CSV into ReturnPro staging, using --dry-run to validate without writing.
High-intent search queries and answers about installing and using this skill.
You can upload NetSuite XLSM exports by running the tool with your file path, which auto-detects multi-sheet workbooks with monthly tabs and batch-upserts parsed rows into staging tables.
The best way to parse NetSuite CSV financial exports is using automated format detection that extracts account codes, names, amounts, and periods, then validates account codes against dim_account before loading.
Yes, you can validate NetSuite financial data before writing by using the dry-run flag, which checks account codes against dim_account and parses rows without executing the batch upsert into stg_financials_raw.
Yes, it supports multi-sheet XLSM workbooks with monthly tabs by auto-detecting the file format and parsing each sheet to extract account_code, account_name, amount, period, and source_file data.
Account code validation works by checking parsed NetSuite export rows against the dim_account table during ingestion, ensuring only valid codes are batch-upserted into stg_financials_raw.
oimiragieoGenerate multi-sheet Excel workbooks with formulas, charts, and formatting.
clenisaDetect foreign key resolution failures and month-level data gaps in staged financial data.
clenisaGenerate NetSuite upload templates with account codes and program mappings.
clenisaCompare staged NetSuite financials to confirmed income statements and report per-month accuracy.
