BILL Token Creation
The first step to initializing the FloQast BILL integration is to create an API token inside your account. BILL has two different types of accounts: Organization and Console. Identify which type of BILL account your organization uses and follow the accompanying steps to create your Bill API token.
- Organization Accounts: Only manage a single company inside of BILL.
- Console Accounts: Manage many companies.
Organization Account Token Creation
- From the Spend & Expense Menu inside of BILL, enter the Settings page.
- From the Settings page, open the Sync & Integrations dropdown and select “Tokens”.
- From here, click the New button and follow the instructions to name and create a new API token.
Important: Bill will only show the API token once as a security precaution. Please make sure to save the token in a secure area. If the token is lost, BILL users can generate new tokens to replace existing ones.
Console Account Token Creation
-
Enter the console management area in BILL.
-
Navigate to “Staff” from the BILL console panel.
-
Click on the Admin user who will own the API token. Ensure the target user has access to the clients that will be connected to FloQast.
-
From the user profile page, open the Actions dropdown and select “Generate API token”.
-
Follow the instructions in the modal to generate and store an API token.
Important: Bill will only show the API token once as a security precaution. Please make sure to save the token in a secure area. If the token is lost, BILL users can generate new tokens to replace existing ones.
Adding a BILL Connection in FloQast
Once a BILL API token has been generated and stored, BILL can be connected to FloQast! FloQast stores and displays its connections to other applications through the “Connection Manager” in the Admin Settings Connections tab. The FloQast Connection Manager contains information on connected applications and the ability to manage connections. To add your BILL integration, follow the steps below.
-
Click the Add Connection button.
-
Select Bill.com as the target application.
-
Select your BILL account type so FloQast can pull the proper data.
-
Enter your credentials:
-
- Connection Name: Choose how this connection will be identified moving forward.
- Username: The email address linked to the BILL account.
- Token: The BILL API token generated in the previous steps.
Entity Mapping
Once a successful connection has been made, you will immediately map your BILL organizations to FloQast Entities.
- BILL organization tokens: Only one BILL organization will appear.
- BILL console token: A list of available BILL organizations underneath the console will be displayed.
This image shows a console account with six organizations mapped to different FloQast Entities.
Each BILL organization can also be optionally assigned to a single FloQast entity. This will ensure that BILL data does not mix between organizations when FloQast pulls in new data. Verify that you have selected the appropriate entity mapping and save the new settings.
Reconciliation Mapping
With Entity access defined, the last step is tying the BILL data to your Reconciliation.
Follow the below steps to change the reconciled balance data source for a given Reconciliation.
-
Navigate to the Reconciliations tab within FloQast.
-
Hover over the BILL Reconciliation and click on the settings gear icon.
A right-hand panel will slide out and provide the option to edit General Settings. -
Select Edit under General Settings.
Inside General Settings is the option to connect your BILL data source to the given Reconciliation. -
Set the Auto Sign-Off Type to “Subledger Tie-Out”.
-
Change Subledger Source to “Bill.com”.
-
Lastly, ensure the Subledger Type properly reflects the type of account represented in the reconciliation.
-
Save and Exit the Reconciliation Settings
Congratulations! There is now an active connection between your FloQast Reconciliation and BILL!
- To update the BILL balance and transaction data on the Rec, simply use the Recs Refresh button at the top of the page as normal.
- You can view additional details through the available file export next to the reconciled balance.