# Sage Intacct integration

Get answers to all of your questions regarding Brex

**URL Source:** https://www.brex.com/support/sage-intacct-integration

---

## Overview

The Sage Intacct integration is one of our many accounting integrations that improve reporting accuracy and accounting control, saving finance teams hours each week.  
  
Our direct integration with Sage Intacct lets you sync over the expenses from your Brex dashboard without the need for data entry or the risk of manual errors. Your synced transactions will include basic transaction details, category mappings, receipts, departments, locations, memos, custom dimensions, etc. You will also be able to tag transactions as billable and assign customer codes before exporting them.  
  
Before exporting, you can manually code your transactions to their respective GL account in the Brex dashboard, or set up rules to make this happen automatically. Cardholders can also manually categorize their own transactions when they attach their receipts and memos.

## Setup

Account admins, card admins, bookkeepers and any other users with the [specific product capability](https://www.brex.com/custom-roles) can integrate their Brex account with Sage Intacct by following the steps below.  
  
**Step 1: **Ensure that you have full admin access to Sage Intacct.  
  
**Step 2: **Click your name in the top right of your dashboard and go to _Integrations_.  
  
**Step 3:** Click _Connect_ next to Sage Intacct and follow the instructional steps, which you can also find below.

## Configure Web Services

**Step 1:** Go to _Company_ > _Admin_ > _Subscriptions._**  
  
Step 2: **Scroll down to the bottom of the page and turn on _Web Services.  
  
_**Step 3:** On the Sage Intacct home page, click _Company_ > _Set Up_ > _Company_.  
  
**Step 4: **Go to the _Security_ tab and click _Edit_.  
  
**Step 5: **Scroll down to _Web services authorizations_ and click _Add_.  
  
**Step 6**: In the _Sender ID_ field, enter “BrexMPP.” Ensure that the _Status_ is marked _Active_.  
  
**Step 7:** Click _Save_.

## Create a Brex role in Sage Intacct

_This section can be skipped if you plan to assign an admin role to the Web Services User you’ll create in the next section.  
  
_**Step 1: **Create a new role by going to _Company_ > _Admin_ > _Roles_ > _Add_.  
  
**Step 2: **Name the new role “Brex role” and Click _Save_.  
  
**Step 3:** Find the new Brex role in the _Roles_ table and click _Subscriptions_.  
  
**Step 4: **Select the following modules:

1. Company
2. Cash Management
3. General Ledger
4. Accounts Payable
5. Accounts Receivable

**Step 5:** Choose the following permissions for each module:

- **Company**
   - Departments: List, View
   - Entities: List, View
   - Locations: List, View
   - Class: List, View
   - Employees: List, View
   - Attachments: List, View, Add, Delete
- **Cash Management**
   - Credit card accounts: List, View
   - Credit card transactions: List, View, Add, Edit
   - Checking accounts: List, View
   - Savings accounts: List, View
- **General Ledger**
   - Accounts: List, View
   - Journal Entries: List, View, Add, Edit, Reverse
- **Accounts Payable**
   - Pay Bills: Run
   - Approve Payments: List, Level 1 - Level 6
   - Approve Bills: List
   - Manual Payment: List, View, Add
   - Payment Requests: List, View, Edit
   - Vendor: List, View, Add, Edit, Bank Details
- **Accounts Receivable**
   - Customers: List, View
   - Projects: List, View
- **Projects**
   - Customers: List, View
   - Projects: List, View
   - Items: List, View

## Create a Web Services User

**Step 1: **Create a new _Web Services User_ by going to _Company_ > _Admin_ > _Web Services User_ > _Add_.  
  
**Step 2:** Add values for these fields:

- User ID
- Last name
- First name
- Email address
- User type (select _Business_)
- Admin privileges (select _Off_)

**Step 3:** Under _User entities_, assign this user the entities you need to access entities you’d like to connect with Brex, and allow top level access.  
  
**Step 4:** If you have role-based permissions, go to _Roles information_ and assign this web service user the Brex role. Alternatively, an admin role can be assigned to this web service user. If an admin user is selected, update the_ Admin privileges_ to _FULL_ (step 2.6 above).   
  
**Step 5:** Click _Save.  
  
_**Step 6:** If you do not have role-based permissions enabled, then after you click _Save_, you’ll be prompted to configure this user’s permissions.  
  
See the “Create a Brex role in Sage Intacct” section for details on which permissions are needed.

## Create a credit card account in Sage Intacct

Follow these steps to export Brex transactions as credit card transaction types to Sage Intacct:  
  
**Step 1a:** Create a new credit card account in Sage Intacct.  
  
**Step 1b: **Configure an existing credit card account by selecting the entity and clicking _Cash Management_ > _Credit Card _> _Add_.  
  
**Step 2:** The credit card will represent multiple employee cards issued from Brex. Input values for these fields:

- ID
- Type (select _Mastercard_)
- Account type (select _Credit_)
- Expiration Month (select _1_)
- Expiration year (select _2033_)
- Credit Card Offset (select the GL account where you want the liability to be impacted)
- Default location (select the entity)
- Vendor ID (select _Brex_)

**Step 3:** Click _Save_.

## Configure custom field for expense URL links

**Step 1: **Click _Top level _and go to _Platform Services_ > _Custom fields _> _Add_.  
  
**Step 2:** Click _Credit Card transaction/GL entry_ and click _Next_.  
  
**Note: **This step will depend on your export settings configuration  
  
**Step 3: **Select _URL_ and click _Next_.  
  
**Step 4a:**_ _In_ Label, _enter_ Brex Expense URL.  
  
_**Step 4b:** Input _Field ID _as_ BREX_EXPENSE_URL _and click _Next.  
  
_**Step 5: **For _Deployment Options_, click the dropdown under _Tab where field appears. _Select_ Transaction and click Done._

## Complete the connection

**Step 1**: If you’ve been following the steps initiated from the Brex integrations page, you’ll come to a screen asking for your Sage Intacct sign-in details. Enter the username for the Web Services User you created earlier and the temporary password that you received for this user via email.  
  
**Step 2:** Select the entity you want to connect to Brex.

## Configure your GL settings in Brex

**Step 1:** Go to _Accounting > Sage Intacct settings > Entity settings_.

**Step 2:** Map Brex categories to **Sage Intacct** GL accounts, once per entity:

- **Accounts payable**: Credit card liability.
- **Manual payments** Bank account.
- **Card repayment receivables**: Accounts receivable.
- **Rewards:** Other income.
- **Reimbursement liability:** Liability.
- **Card accruals liability:** Credit card accrued liability account
- **Reimbursement accruals liability:** Reimbursement accrued liability account
- **Local reimbursement and bill pay payouts:** Local reimbursement Bank Account, non-USD bank, if used.

## Create your Mappings

**Step 1:** Go to _Accounting > Fields Library > Mappings_.

**Step 2:** On Categories, map Brex categories to Intacct GLs; optionally add Merchants rules.

You can learn more about Accounting Automation [here](https://www.brex.com/accounting-automation), and about other features in the Fields Library [here](https://www.brex.com/accounting-fields).

Once you've mapped your categories and created any merchant or custom rules you'd like, go to the _Accounting Dashboard_ to export transaction data from your selected time period.

## Exporting transactions to Sage Intacct

For a step-by-step tutorial on how to prepare, review, and export your transactions to Sage Intacct, read this [help article](https://www.brex.com/brex-dashboard-accounting-page).  
  
You can use rich metadata to choose how your expenses appear once they’re synced to Sage Intacct. You can also export transactions and reimbursements to your top level in Sage Intacct, so it handles your intercompany journals.



**Note:** Choosing CSV won’t automatically send the expense data to Sage Intacct — the CSV will need to be imported into Sage Intacct. We’ll mark these transactions as exported to avoid duplicates the next time you export.

### Exporting card expenses as credit card transactions (Optional)

The steps below let you export Brex card expenses to Sage Intacct as credit card transactions in the Cash Management module. This can be helpful if you reconcile card activity directly in Cash Management.

Before you switch your export type in Sage Intacct, keep the following in mind:

- **Export type limitations:** Only card expenses can be exported as credit card transactions through Cash Management. Reimbursements, repayments, and rewards aren’t eligible for credit card export and must be exported as journal entries or vendor bills instead.

**Posting level differences (Journal Entry versus Credit Card Transactions):**

- **Journal entries** export to the top level in Sage Intacct by default and don’t require additional configuration to change the posting level.
- **Credit card transactions** export to the entity level by default. If you need top-level posting, please reach out to Support to confirm eligibility and setup requirements.
- **Batching behavior:** Journal entries can be exported as single entries or batched entries, depending on your close and review workflow. Credit card transaction exports aren’t batched; they're sent individually to Cash Management.
- **Additional setup requirements:** Credit card exports typically require additional configuration in Sage Intacct, as referenced below, including setting up the correct credit card or clearing account structure and confirming your vendor configuration.

**Note:** If you need batching flexibility or top-level posting by default, continue exporting transactions as journal entries instead.

****

**Follow these steps to export Brex transactions as credit card transaction types to Sage Intacct:**

**Step 1:** Create or open the credit card account in Sage Intacct.

- **Step 1a:** Create a new credit card account in Sage Intacct.
- **Step 1b:** To configure an existing credit card account, select the entity, then go to _Cash Management > Credit Card_ and click ‘_Add’_.

**Step 2:** Enter the credit card details. This credit card represents multiple employee cards issued from Brex. Complete the following fields:

- _ID_
- _Type:_ Mastercard
- _Account type:_ Credit
- _Expiration month:_ 1
- _Expiration year:_ 2033 (a future year)
- _Credit Card Offset:_ Select the GL account where you want the liability to be recorded
- _Default location:_ Select the entity
- _Vendor ID:_ Brex

**Step 3:** Click _Save_.

## Exporting journal entries to different journal templates in Sage Intacct

You can export journal entries to a custom journal in Sage Intacct to create a custom journal, configure the export settings in Brex, and validate the export.

### Create a Custom Journal in Sage Intacct

**Step 1:** Log into Sage Intacct and go to the _General Ledger_ module.  
  
**Step 2:** In the _General Ledger_ menu, click _Setup_** > **_Journals_.  
  
**Step 3:** Click _Add_ to create a new journal.  
  
**Step 4:** Enter the following information:

- **Symbol**: Use BRXJ (recommended best practice for Brex Journals).
- **Title**: Enter "Brex Journal" or any clear name for easy reference.

**Step 5:** Click _Save_ to create the new journal.  
  
**Step 6:** Contact Brex Support to configure the export settings so that your journal entries are directed to the custom journal you created. Inform them of the journal symbol (e.g., BRXJ) and any specific requirements for your setup.

### Validate the Journal Export

After configuring the export settings, test that the export is working correctly:  
  
**Step 1: **Log into Sage Intacct and go to _Export History_.  
  
**Step 2: **Verify that the journal entry appears under BRXJ (or your specified custom symbol).  
  
**Step 3: **Make sure the reconciliation process functions as expected.  
  
**Step 4: **Use the custom symbol (e.g., BRXJ) to filter transactions, simplifying reconciliation.  
  
If you have issues during this process, Brex Support can help.

## Disconnect Sage Intacct

**Step 1:** Click your name in the top right of your dashboard, and go to _Integrations_.  
  
**Step 2: **Next to Sage, click the three dots, and choose _Disconnect_.Disconnecting will not remove any mapping rules previously created, in case you’d like to reconnect Sage Intacct with the same sign-in credentials at a later time.

## Troubleshooting

#### Error: _This transaction is missing the Location dimension for Account XXXX_

This error can happen if you have a location dimension required in Sage Intacct, or if your entity is mapped to top level.  
  
**Step 1:** Remove the _Location_ requirement from Sage Intacct and try exporting again.  
  
**Step 2:** Adjust your entity mappings by going to _Accounting _> _Sage Intacct settings > Entity settings _in your Brex dashboard.  
  
**Step 3:** On _Spending entity_, choose the Brex entity to be mapped to the Sage entity. Click the entity and change the mapping from _Top level_ to _Entity level._

#### Error: _You do not have permission for API operation CREATE on objects of type checking account_

This error occurs when the Brex integration role lacks the necessary permissions in Sage Intacct.

**Step 1:** Adjust permissions on the _Cash Management_ module by going to _Company _> _Admin _> _Roles _in Sage Intacct.  
  
**Step 2: **Next to to Brex integration role, click _Edit _> _View Subscription. _Then, under _Cash Management, _click _Permissions_.  
  
**Step 3: **Ensure these permissions are enabled:

- Checking Accounts → List, View
- Savings Accounts → List, View

![HC - Sage Intacct 02](https://brand.brex.com/m/1b675f38ae50fe3f/webimage-HC-Sage-Intacct-02.jpg)

**Step 4: **Ensure general ledger permissions are correct by going to _Company _> _Admin _> _Roles_ in Sage Intacct.  
  
**Step 5: **Next to _General Ledger, _click _Permissions _and enable the following:

- Accounts → List, View
- Journal Entries → List, View, Add, Edit, Reverse

**Step 6:** Save the changes.  
  
**Step 7: **In your Brex dashboard, go to _Accounting _> _Sage Intacct settings.  
  
_**Step 8: **Under _Integration management,_ click _Refresh_ and make a new attempt to export

![HC - Sage Intacct 03](https://brand.brex.com/m/4ec5da0e5b3fe3ec/webimage-HC-Sage-Intacct-03.jpg)

![HC - Sage Intacct 04](https://brand.brex.com/m/5a968612c8beaaba/webimage-HC-Sage-Intacct-04.jpg)

![HC - Sage Intacct 05](https://brand.brex.com/m/30ae6acde7cdf3bb/webimage-HC-Sage-Intacct-05.jpg)

If the error persists, please reach out to Brex for assistance.

#### Error: _You do not have permission for API operation QUERY on objects of type class._

This occurs when you try to refresh the Sage Intacct integration but lack the correct permissions.  
  
**Step 1: **Make sure that you’re an admin in Sage Intacct.** **A bookkeeper does not need admin access but must have the correct permissions.  
  
**Step 2:** Go to _Company _> _Admin _> _Roles _> _Brex Role _and click _Edit.  
  
_**Step 3: **Click _View Subscriptions _> _Company _> _Permissions.  
  
_**Step 4: **Make sure that _Class _is set to _List and View_ and click _Save._

![HC - Sage Intacct 06](https://brand.brex.com/m/3685331714d0ebc3/webimage-HC-Sage-Intacct-06.jpg)

**Step 5:** In your Brex dashboard, go to _Integrations _> _Sage Intacct _and click_ Refresh integration.  
  
_If the error persists, please reach out to Brex.