Sage Intacct integration

OverviewSetupConfigure Web ServicesCreate a Brex role in Sage IntacctCreate a Web Services UserCreate a credit card account in Sage IntacctConfigure custom field for expense URL linksConfigure custom field for receipt URL linksComplete the connectionConfigure your accounting fields in BrexDisconnect Sage Intacct

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. Brex integrates with Sage Intacct directly for card expenses, which are exported to the cash management module as credit card transactions. Reimbursements can be exported via CSV. This includes basic transaction details, category mappings, receipts, departments, location, memos, etc. Before exporting, you can code your transactions to their respective GL account in the Brex dashboard. Cardholders can also manually categorize their own transactions when they attach their receipts and memos. Note: You'll need to map the IDs exported from Brex to your Sage field IDs.

Setup

Account admins, card admins, and bookkeepers 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:

  1. Company
    1. Departments: List, View
    2. Entities: List, View
    3. Locations: List, View
    4. Class: List, View
    5. Employees: List, View
  2. Cash Management
    1. Credit card accounts: List, View
    2. Credit card transactions: List, View, Add, Edit
  3. General Ledger
    1. Accounts: List, View
  4. Accounts Payable
    1. Vendor: List, View
  5. Accounts Receivable
    1. Customers: List, View
    2. Projects: 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:

  1. User ID
  2. Last name
  3. First name
  4. Email address
  5. User type (select Business)
  6. 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

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:

  1. ID
  2. Type (select Mastercard)
  3. Account type (select Credit)
  4. Expiration Month (select 1)
  5. Expiration year (select 2033)
  6. Credit Card Offset (select the GL account where you want the liability to be impacted)
  7. Default location (select the entity)
  8. Vendor ID (select Brex)

Step 3: Click Save.

Step 1: Click Top level and go to Platform Services > Custom fields > Add. Step 2: Click Credit Card transaction > Next. Step 3: Select URL and click Next. Step 4a: Input Label as 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.

Step 1: Select Top level. Go to Platform Services > Custom fields > Add. Step 2: Select Credit Card transaction and click Next. Step 3: Select URL and click Next. Step 4a: Input Label as Brex Receipt URL. Step 4b: Input Field ID as BREX_RECEIPT_URL and click Next. Step 5: For Deployment Options, click the dropdown under Tab where field appears and select Transaction. 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 accounting fields in Brex

Step 1: In the Brex dashboard, go to Accounting and click Manage Sage Intacct underneath Export settings to configure your accounting fields. Step 2: Select your account information from the dropdown menus to the right of Accounts payable, Bank account, Reimbursements bank account, and Rewards credits. Step 3: Under Accounting, select Manage accounting fields and mappings. Step 4: Click Categories to map each Brex category to a Sage Intacct account. Merchants and custom rules are optional. Step 5: Once you've mapped your categories and created any merchant or custom rules you'd like, click Accounting and Prepare transactions to export transaction data from your selected time period.

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.

Was this article helpful?