How does Yoraito work with NetSuite?
Short answer: Yoraito connects to Oracle NetSuite through NetSuite's OAuth 2.0 / token-based authentication, using only published REST and SOAP APIs, with no SuiteApp to install. It pulls the trial balance, GL and subsidiary data, runs the close as SQL, and posts approved journal entries, bill payments and vendor bills back with read-back validation.
What syncs between NetSuite and Yoraito?
| Direction | Data |
|---|---|
| NetSuite → Yoraito | Trial balance, general ledger detail, subsidiary data, saved searches and custom report definitions, custom segments (mapped to Yoraito fields) |
| Yoraito → NetSuite | Approved journal entries, bill payments and vendor bills, with read-back validation |
| Also | Entity consolidation across subsidiaries in one workflow |
How do we connect?
- Enter your NetSuite Account ID; Yoraito uses NetSuite's OAuth 2.0 flow.
- Select the roles and subsidiaries to sync. Least privilege is the default.
- Map NetSuite custom segments to Yoraito workflow fields.
Security: token-based authentication; SuiteCloud-compliant, published APIs only; per-tenant isolated connector process.
How does the close run on NetSuite?
| Close step | On NetSuite with Yoraito |
|---|---|
| Cut-off and accruals | Accrual candidates found from vendor bill history; approved entries post back |
| Bank reconciliation | Bank data (Plaid or statements) matched to NetSuite cash with written rules; tie-out to $0.00 |
| Balance sheet reconciliations | Tie-outs and rollforwards per subsidiary, each with its query |
| Intercompany and consolidation | Consolidation across subsidiaries in one workflow |
| Flux | GL lines behind each change found by query; labelled AI commentary |
| Sign-off | Preparer and reviewer recorded; period ready to lock in NetSuite |
What does an example NetSuite reconciliation look like?
| Field | Value (illustrative) |
|---|---|
| Subsidiary / account | US Operating · 1010 Cash |
| NetSuite GL balance | $180,932.80 (query Q02, from GL detail) |
| Bank balance | $191,035.40 (query Q01) |
| Outstanding checks | -$3,640.00 |
| Bank-only items to record | -$1,337.40 (proposed JE, awaiting approval) |
| Ledger duplicate to reverse | $7,800.00 |
| Difference after items | $0.00 · balanced |
How is this different from reconciling inside NetSuite?
| NetSuite native reconciliation | Yoraito on NetSuite | |
|---|---|---|
| Bank matching | NetSuite's match bank data tools | Written matching rules in passes, recorded on every match |
| Balance sheet accounts | Usually outside NetSuite in spreadsheets | Tie-outs and rollforwards with saved SQL |
| Evidence for auditors | Reports and attachments | Query, inputs, result and signer per reconciliation |
| Flux | Saved searches and spreadsheets | Driver transactions by query; labelled commentary |