> ## Documentation Index
> Fetch the complete documentation index at: https://docs.francis.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle NetSuite

> Connect Oracle NetSuite to feed actuals into your financial model.

Connect your NetSuite account to import actuals into Francis. You can connect multiple accounts if you operate across several companies. Once connected, your chart of accounts is available in the [Mappings](/features/using-francis/data-mappings) view, where you map NetSuite accounts to line items in your model.

## Connect NetSuite

Go to **Settings > Integrations > NetSuite > Connect**. A prompt will appear asking you to authorize Francis as an application in your NetSuite account. This requires Admin rights.

## What Francis sources

Francis pulls the following data from NetSuite:

* Journal entries: amount, date, and description
* GL accounts

Dimensions ("Classifications") are not currently supported for NetSuite, but are on the roadmap.

## Adjustments

Francis automatically adjusts imported data in two ways.

<Tabs>
  <Tab title="Number convention">
    Francis flips the sign for income, expenses, liabilities, and equity accounts to follow the Francis sign convention:

    * **Positive (+):** Income (I), Asset (A), Liability (L), and Equity (EQ)
    * **Negative (-):** Expense (EX)
  </Tab>

  <Tab title="Balance sheet">
    Francis presents balance sheet values as accumulated amounts at a point in time, not as period movements. Imported data is adjusted on the way in to match this convention.

    For this reason, in Francis, summarize balance sheet items using `ENDING` instead of `SUM`.
  </Tab>
</Tabs>

### Retained earnings

NetSuite does not expose its retained earnings account via the API. Francis automatically adjusts for this on other accounting systems, but it is not yet supported for NetSuite. For now, calculate retained earnings manually by adding net profit to equity:

```typescript theme={null}
= "Retained earnings"[-1] + "Net profit"[0]
```

Reach out to [support@francis.app](mailto:support@francis.app) if you have questions.

## Settings to enable adjustments

### Account types

Francis applies its adjustments based on account types (Income, Expense, Asset, Liability, or Equity), so every account in NetSuite needs one assigned.

To update an account type:

1. Navigate to **Lists > Accounting > Accounts**.
2. Click **Edit** next to the account.
3. Update the **Type**.
4. Click **Save**.