> ## 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.

# Microsoft Business Central

> Connect Business Central to feed actuals into your financial model.

Connect your Business Central instance to import actuals into Francis. You can connect multiple instances 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 Business Central accounts to line items in your model.

## Connect Business Central

Business Central supports two connection methods.

### Method 1: Standard connection

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

The connection is tied to the user who authorizes it and inherits their permissions. If that user is later deactivated (for example, when they leave the company), the connection breaks and must be reestablished via **Reconnect** in Francis.

Use this method when possible. It's the simplest to set up. If your user permissions don't allow it, or you need a connection that isn't tied to an individual user, use Method 2.

### Method 2: App installation

Register the Francis app directly in Business Central via Microsoft Entra. This requires Azure Admin rights. Unlike Method 1, the connection isn't tied to an individual user, so it won't break if someone leaves the company. The app gets access to all companies in the environment where it's added.

<Accordion title="Show installation steps">
  1. Log in to Business Central at [businesscentral.dynamics.com](https://businesscentral.dynamics.com) and select your company.
  2. Click the **Search** icon and type "Entra".
  3. Select **Microsoft Entra Applications**.
  4. Click **+ New**.
  5. Set **Client ID** to `7a116fc0-e506-453f-b354-5c5b48af13a3`.
  6. Set **Description** to "Francis App".
  7. Change **State** to "Enabled".
  8. Accept the automatic creation of a new user.
  9. Set the permission set to `D365 READ`.
  10. Click **Grant Consent** and then **Accept** when prompted.
  11. Go to the BC Admin Center, select your environment, and copy the **URL** property.
  12. Send that URL to [support@francis.app](mailto:support@francis.app) to complete the setup.
</Accordion>

## What Francis sources

Francis pulls the following data from Business Central:

* Journal entries: amount, date, and description
* GL accounts
* Dimension tags, available for [breakdowns](/features/using-francis/breakdowns) within Francis

## Adjustments

Francis automatically adjusts imported data in three ways. All adjustments are based on account categories, so it's important that these are set correctly to ensure correct numbers.

<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>

  <Tab title="Year-end closing entries">
    Throughout the fiscal year, Business Central holds net profit in a system-generated "Retained earnings current year" account that isn't exposed via the API. To capture this, Francis recreates it as a synthetic account named "Årets foreløbige resultat".

    When a fiscal year is closed, Business Central creates system journal entries that zero out the P\&L and post the result to the Retained Earnings account (marked as a system account). Francis already includes this via the synthetic account, so it excludes these system postings. This also maintains a continuous flow rather than an abrupt zeroing in the final month.
  </Tab>
</Tabs>

## Settings to enable adjustments

### Account categories

Francis applies its adjustments based on account categories (Income, Cost of Goods Sold, Expense, Asset, Liability, or Equity), so every posting account in Business Central needs one assigned.

This is usually a non-controversial, one-time update, and it takes around 10 minutes since Business Central lets you copy and paste the category down the column.

To set account categories:

1. Navigate to **Chart of Accounts**.
2. Choose **Edit List**.
3. Update **Account Category** for all **Posting** accounts. **Account Subcategory** and **Total** accounts can be left blank.

<img src="https://mintcdn.com/francis/Euj3heJHJJyNBom7/images/integrations/accounting/business-central/account-categories.svg?fit=max&auto=format&n=Euj3heJHJJyNBom7&q=85&s=fef745daec68f3ca98093535334d5385" alt="Setting account categories in the Business Central Chart of Accounts" width="1862" height="1208" data-path="images/integrations/accounting/business-central/account-categories.svg" />
