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 BrexExporting transactions to Sage IntacctDisconnect 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. 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. 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, 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
    2. New for Fall Journal Entries: List, View, Add, Edit
  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. New for Fall 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.

Step 1: Select Top level. Go to Platform Services > Custom fields > Add. New for FallStep 2: Select 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: 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.

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. 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 that it takes care of your intercompany journals. Note: Choosing CSV won’t automatically send the expense data to Sage Intacct — they'll need to be added to Sage Intacct manually. We’ll mark these transactions as exported to avoid duplicates the next time you export.

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?