You can define native integrations for sending your end customer Account Bills generated in m3ter outbound into your QuickBooks system:
First, create the integration.
Second, set up authentication for the integration to connect with QuickBooks.
To create and configure a native integration, you can follow a three-stage process:
Stage 1. Select the Entity Type that the integration is for. Currently, only native integrations for Bills are supported.
Stage 2. Select the external system that is the destination for the integration.
Stage 3. Configure the details required for the selected integration destination and create the integration.
Note: QuickBooks or QuickBooks (Sandbox Mode)? The difference between these two integrations is selecting QuickBooks means an integration destination into your QuickBooks production environment, selecting QuickBooks (Sandbox Mode) means an integration destination into your QuickBooks Sandbox environment. The configuration settings are the same for both destinations.
Tip: Reviewing Integration Runs! When you've set up an integration with Quickbooks for your Organization in your production environment, you can review details of the integration runs performed for the integration. See Reviewing Integration Run Details.
To define a m3ter - Quickbooks integration:
1. Select Integration>Configurations. The Integrations Configurations page opens.
2. Select Create Integration. The Create page opens at Stage 1: Select the type of entity you want to integrate with an external system.
3. Use the Entity Type drop-down to select the entity type you want to create the integration for. Currently, only Bill is available for selection.
4. Select Continue. The page adjusts to show Stage 1 as checked and completed and shifts focus to Stage 2: Select an external system to integrate with.
5. In the Destination drop-down list, select QuickBooks or QuickBooks (Sandbox Mode).
6. Select Continue. The page adjusts to show Stage 2 as checked and completed and shifts focus to Stage 3: Configure and create. The Entity Type and Integration Destination you've selected are shown.
7. Select the Accounts you want the integration to apply to:
Account Ids. Select the Accounts you want to include - all selected Accounts are treated as allowed for the integration.
Restricted Account Ids. Select the Accounts you want to exclude - all selected Accounts are treated as disallowed for the integration.
Note: If you want to include all Accounts in the integration, leave both Accounts Ids and Restricted Account Ids empty.
8. Use the Entity Configuration panel to configure the m3ter entity you'll be synchronizing with for the integration. In the case of an outbound Bill integration, this entity will be the Bill generated for a customer Account in m3ter:
Only Send Bill On Approval. Enable this if you only want Bills to be sent when they have been approved. If disabled, the Bill will be sent every time it is regenerated. Default is disabled. Note that:
The frequency of Bills sent will depend on the billing frequency defined for the Account Plan attached to the Account - such as daily/weekly/monthly/annually.
If an Account has a Prepayment on it and the billing for Prepayment fees is configured to run on a customized schedule, Bills will be sent when scheduled Bills are generated.
If a Bill is manually recalculated the updated Bill will be sent.
If you enable this, then the integration will not run for all Bill Jobs.
Use External Mapping Account Code. Enable this if you want the integration to look in the External Mappings for the Account identifier code, which means you can use an external Id. If this is disabled, the m3ter Account Id is used. Default is disabled.
Excluded Line Item Types. Optionally filter the Bill line items you send to the destination system. For example, only send charges or credits and exclude all other line items.
For details of line item types, see Bill Line Item Types.
Sort Line Items By. Optionally, select a property to sort line items by before they are sent out to the external system. Three options:
9. Use the Destination Configuration panel to enter the settings specific to the destination system. These settings include field mappings as well as other system-specific configurations. Note that these settings will change for each destination:
Split Usage Line Items. This setting determines how m3ter will create usage invoice items in QuickBooks. QuickBooks items can be mapped to a product, an aggregation/compound aggregation, or to an individual pricing band:
Item per usage band
Item per product
Item per aggregation
QuickBooks Item Mapping. This setting allows you to specify the QuickBooks item ID for mapping these line item types. If left blank, then the item will be sent to QuickBooks without being mapped to a product or service:
Send Zero Quantity Line Items. Enable this switch if you want zero quantity line items to be sent through to QuickBooks. Default is disabled.
Allow Bank Transfer Payment. Enable this switch if you want to allow invoices to be paid with online bank transfers - corresponds to bank transfer online payment checkbox in QuickBooks. Default is disabled.
Allow Credit Card Payment. Enable this switch if you want to allow invoices to be paid with credit cards - corresponds to Cards checkbox in QuickBooks. Default is disabled.
Bcc Invoice Email Address. Enter the email address to be set as the BCC email address in QuickBooks invoices. Required - if you try to save the integration configuration without entering an email address or use an invalid email address format, you'll receive an error message.
Account Manager Email Custom Field. Enter the Account custom field name that contains the email address of the Account Manager. Used to populate the email CC field when an invoice is sent to QuickBooks. Optional.
10. Select Create Integration. You are taken to the details page for the integration, where you can immediately complete the configuration by setting up authentication to allow the integration to connect with your Quickbooks system - see the following Setting Up Authentication section for details:
Note that if you are not ready to continue your workflow immediately and set up authentication, you can do this at a later time.
When you have created a QuickBooks integration, you can set up authentication to allow the integration to connect with your QuickBooks system:
Note that if you've followed the workflow given in the earlier section for creating the integration, on creation you'll be taken directly to the integration details page to continue and immediately set up authentication. The procedure described in this section assumes you've returned at a later date to set up authentication for the integration - the main steps you need to follow if you're setting up authentication immediately after creation are the same.
To set up authentication for your m3ter - QuickBooks integration:
1. Select Integration>Configurations. The Integrations Configurations page opens.
2. Select the ENTITY TYPE hotlink text of the QuickBooks integration you want to set up authentication for. The Integration Details page opens:
A warning is shown that the integration is not yet authenticated for connection to your QuickBooks system.
The ID of the integration configuration is shown at the bottom of the Details card, and you can copy the ID directly to your clipboard.
3. Select Connect. A QuickBooks Connection modal appears advising that you'll need to provide authentication details on the QuickBooks website.
4. Select Go to QuickBooks. You are taken to a Sign in page where you can use your Intuit account credentials to sign in to QuickBooks and approve access for m3ter.
5. Use your browser back button to return to the integration details page;
The integration will now show as CONNECTED.
Tip: Testing your Native Integration Setup? Your QuickBooks integration is now available for use. However, it remains in Beta release and we strongly recommend you test the implementation in your m3ter Sandbox or QA environment before releasing it to your Production environment. See section 7. of our Terms of Service for Beta Usage.
Tip: Integrations API Calls? When you have set up your Quickbooks integration, you can review and manage the integration using a full set of API Calls. See the Integrations section of our API Reference Docs.
Login to the Support portal for additional help and to send questions to our Support team.