# Connect Mosaic to NetSuite > Automate the flow of actuals, budgets, and forecasts between your strategic finance platform and your ERP so your numbers are always in sync. **Canonical page:** https://tray.ai/connectors/mosaic-netsuite-integrations/ **Mosaic connector:** https://tray.ai/connectors/mosaic-integrations/ **Mosaic documentation:** https://tray.ai/documentation/connectors/service/mosaic **NetSuite connector:** https://tray.ai/connectors/netsuite-integrations/ **NetSuite documentation:** https://tray.ai/documentation/connectors/service/netsuite ## Overview Mosaic and NetSuite do different jobs. NetSuite owns the authoritative record of your actuals, invoices, and transactions. Mosaic takes that raw financial data and turns it into strategic plans, forecasts, and board-ready insights. Keeping the two aligned manually is slow, error-prone, and creates a dangerous gap between what happened and what finance knows about it. Integrating Mosaic with NetSuite via tray.ai means actuals flow automatically into your planning models, headcount data stays current, and scenario analyses always reflect the latest operational reality. Finance teams that rely on manual exports from NetSuite into Mosaic are fighting a losing battle against stale data, spreadsheet errors, and hours lost to reconciliation every month. Connecting Mosaic and NetSuite through tray.ai cuts out the manual pull-and-paste cycle entirely. Real-time or scheduled syncs push NetSuite's general ledger actuals, vendor bills, revenue recognition records, and departmental spend directly into Mosaic's planning engine, so FP&A teams are modeling against current numbers rather than last week's CSV. The reverse flow matters just as much — approved budgets and headcount plans authored in Mosaic can be pushed back into NetSuite to drive purchase order limits, approval thresholds, and cost center controls. The result is a single source of truth across both systems, faster monthly closes, more accurate forecasts, and a finance team that spends its time on analysis instead of data wrangling. ## Use cases ### Automated Actuals Sync from NetSuite to Mosaic Every time NetSuite closes a period or posts new journal entries, tray.ai automatically pulls the updated general ledger actuals and pushes them into Mosaic. FP&A teams always have current variance analysis without running a single manual export. No more end-of-month scramble to reconcile plan versus actual. - Eliminates manual CSV exports and uploads between NetSuite and Mosaic - Cuts variance reporting lag from days to minutes - Keeps Mosaic forecasts current with the latest NetSuite actuals ### Real-Time Revenue Recognition Feeds into Mosaic Forecasting NetSuite's Advanced Revenue Management module produces recognized revenue schedules that feed directly into Mosaic's ARR and revenue forecasting models. tray.ai syncs recognized revenue records on a scheduled or event-driven basis so Mosaic's revenue waterfall reflects real contract performance. Finance teams can model growth scenarios against actual recognition data rather than bookings proxies. - Keeps Mosaic revenue models in sync with NetSuite's recognition schedules - Supports accurate ARR, MRR, and churn reporting in Mosaic - Reduces manual reconciliation between revenue and bookings data ### Departmental Spend Tracking and Budget vs. Actual Reporting NetSuite captures departmental expenses at the vendor bill and journal entry level, while Mosaic holds the approved departmental budgets. tray.ai bridges the two by syncing actuals by cost center and department class from NetSuite into Mosaic's budget-vs-actual dashboards. Department heads and finance business partners get live visibility into spend performance without waiting for month-end reports. - Provides real-time budget vs. actual visibility across all departments - Cuts month-end close reporting effort by automating data aggregation - Gives department heads self-serve spend dashboards in Mosaic ### Headcount and Payroll Actuals Synchronization Approved headcount plans are built in Mosaic, but actual salary and payroll costs flow through NetSuite payroll or payroll journal entries. tray.ai syncs payroll actuals from NetSuite back to Mosaic so headcount models reflect true loaded costs, benefits, and taxes rather than estimates. Workforce planning stays accurate and supports real-time headcount-driven forecasting. - Keeps Mosaic headcount models updated with real NetSuite payroll actuals - Improves accuracy of loaded cost calculations in strategic workforce plans - Reduces manual effort to reconcile HR budgets with finance actuals ### Approved Budget Pushback from Mosaic to NetSuite Once finance approves a budget cycle in Mosaic, those approved figures need to exist in NetSuite to drive spend controls, purchasing limits, and approval workflows. tray.ai automates the pushback of approved budget data from Mosaic into NetSuite's budget module, so operational systems enforce the plans finance has approved. That closes the loop between strategic planning and ERP-level controls. - Eliminates manual re-entry of approved budgets into NetSuite - Keeps NetSuite spend controls current with the latest board-approved plan - Speeds up the operationalization of new budget cycles across the business ### Cash Flow Forecasting with NetSuite AR and AP Data Mosaic's cash flow forecasting models are only as good as the receivables and payables data feeding them. tray.ai pulls open AR aging, AP schedules, and payment terms from NetSuite into Mosaic so cash projections reflect real invoice timing rather than assumptions. Treasury and FP&A teams get a dynamic cash runway view without manual data pulls. - Feeds live AR and AP data from NetSuite into Mosaic cash flow models - Improves cash runway accuracy and cuts down on forecasting assumptions - Gives treasury teams a real-time view of near-term liquidity ### Multi-Entity Consolidation and Intercompany Reconciliation Companies running multiple subsidiaries in NetSuite need to consolidate financials and eliminate intercompany transactions before reporting in Mosaic. tray.ai orchestrates multi-entity data pulls from NetSuite, applies consolidation logic, and pushes clean consolidated actuals into Mosaic for group-level reporting and planning. That cuts a meaningful amount of the intercompany elimination and consolidation work required each period. - Automates multi-entity actuals consolidation between NetSuite and Mosaic - Cuts intercompany elimination effort at period close - Supports accurate group-level forecasting and board reporting in Mosaic ## Templates ### NetSuite GL Actuals to Mosaic — Scheduled Period Sync On a configurable daily or weekly schedule, this template pulls posted general ledger transactions from NetSuite filtered by accounting period, maps them to Mosaic's chart of accounts structure, and uploads actuals to the corresponding Mosaic metrics and dimensions. Ideal for teams that want automated actuals refresh without triggering on every individual journal entry. Connectors used: NetSuite, Mosaic ### NetSuite Revenue Recognition Records to Mosaic Revenue Model This template listens for new or updated revenue recognition arrangements in NetSuite's Advanced Revenue Management module and syncs recognized revenue by customer, product line, and period into Mosaic's revenue metrics. Keeps ARR and MRR dashboards in Mosaic current with NetSuite's authoritative revenue recognition schedule. Connectors used: NetSuite, Mosaic ### Mosaic Approved Budget to NetSuite Budget Module When a budget is marked as approved in Mosaic, this template automatically extracts the approved figures by department, account, and period and creates or updates corresponding budget records in NetSuite. NetSuite's purchasing controls and approval workflows always operate against the current approved plan. Connectors used: Mosaic, NetSuite ### NetSuite AP and AR Aging to Mosaic Cash Flow Forecast This template pulls open accounts payable and accounts receivable aging buckets from NetSuite on a scheduled basis and feeds the data into Mosaic's cash flow planning model. FP&A gets a dynamic, data-driven view of near-term cash inflows and outflows without manual AR/AP report exports. Connectors used: NetSuite, Mosaic ### NetSuite Payroll Journal Entries to Mosaic Headcount Model After each payroll run, this template extracts salary and benefits journal entries from NetSuite, maps them to employees or roles in Mosaic's headcount model, and updates actual compensation costs. Mosaic's workforce planning view stays current with real payroll spend rather than modeled estimates. Connectors used: NetSuite, Mosaic ### Multi-Entity NetSuite Actuals Consolidation into Mosaic For companies with multiple NetSuite subsidiaries, this template queries each subsidiary's GL actuals, applies configurable intercompany elimination rules, and loads consolidated financials into Mosaic's group-level reporting model. It takes most of the manual consolidation work off the table at each period close. Connectors used: NetSuite, Mosaic ## Challenges Tray.ai solves ### Chart of Accounts Mapping Complexity NetSuite's chart of accounts structure, account classes, and department hierarchies rarely map directly to the dimensions and metrics Mosaic uses for planning. Manual mapping is brittle and breaks whenever either system is updated, leading to mismatched actuals and reporting errors. **How Tray.ai helps:** tray.ai's data transformation layer lets finance teams build and maintain reusable account mapping tables inside integration workflows. When NetSuite account codes or Mosaic metrics change, only the mapping configuration needs updating — the workflow logic stays intact and reusable across multiple data flows. ### NetSuite API Rate Limits and Large Data Volumes NetSuite's REST and SuiteScript APIs enforce rate limits and return paginated results, which causes problems when syncing large volumes of GL transactions or multi-period actuals in a single run. Naive integrations either time out or hit throttling errors during busy periods. **How Tray.ai helps:** tray.ai handles NetSuite's pagination and rate limit responses natively, automatically implementing retry logic, exponential backoff, and chunked batch processing. Large GL syncs are broken into manageable page sizes and run reliably without manual intervention or workflow failures. ### Multi-Subsidiary and Multi-Currency Complexity Organizations running NetSuite across multiple subsidiaries and currencies need to handle currency translation, intercompany eliminations, and subsidiary-specific account structures before data is usable in Mosaic. Building this logic manually in spreadsheets or scripts is error-prone and hard to audit. **How Tray.ai helps:** tray.ai workflows can embed configurable currency conversion logic, subsidiary filtering, and intercompany elimination rules directly in the integration pipeline. Each subsidiary's data is processed with the appropriate transformations before being consolidated and loaded into Mosaic, with a full audit trail of every record processed. ### Keeping Integrations Resilient Through System Updates Both Mosaic and NetSuite evolve their data models, APIs, and field structures over time. A new NetSuite release or a Mosaic metric restructure can silently break an existing integration, stopping actuals from flowing without any alert — a dangerous situation for FP&A teams that depend on data freshness. **How Tray.ai helps:** tray.ai has built-in error handling, alerting, and workflow monitoring so any failed API call or schema mismatch triggers an immediate notification to the integration owner. Teams can also version and test workflow changes before deploying them, reducing the risk of silent failures during system updates. ### Controlling Data Access and Audit Compliance Financial data flowing between NetSuite and Mosaic is highly sensitive. Finance teams need confidence that only authorized workflows are reading or writing to these systems, and a complete audit trail of every data transfer for SOX or internal audit purposes. **How Tray.ai helps:** tray.ai enforces role-based access controls on every workflow, so only authorized team members can create or modify integrations that touch financial systems. Every workflow execution produces a detailed log of data inputs, transformations, and API calls — a complete audit trail that satisfies SOX and internal audit requirements. ## Learn more - Intelligent Integration: https://tray.ai/platform/intelligent-ipaas/ - Merlin Agent Builder: https://tray.ai/platform/merlin-agent-builder/ - Agent Gateway for MCP: https://tray.ai/platform/agent-gateway/ - Book a demo: https://tray.ai/contact/