View a markdown version of this page

QuickBooks integration - Amazon Quick

QuickBooks integration

With the QuickBooks action connector, you can access QuickBooks Online directly in Amazon Quick through natural language. You can manage invoices, customers, vendors, accounts, and generate financial reports without leaving Amazon Quick.

Amazon Quick supports multiple authentication methods for QuickBooks. Choose the method that best fits your organization's security requirements.

  • Default OAuth app – Uses an AWS-managed OAuth application. No additional credentials are needed. Users authenticate directly with their Intuit account.

  • Custom OAuth app – Uses a customer-managed application registered in the Intuit Developer portal. This option gives your organization full control over the OAuth configuration.

For more information about the authentication methods that Amazon Quick supports, see Authentication methods.

Before you begin

Make sure that you have the following before you set up the integration.

Configuring QuickBooks

If you are using Default OAuth app authentication, skip this section and proceed to Setting up the connector in Amazon Quick.

For Custom OAuth app authentication, complete the following steps in the Intuit Developer portal before configuring Amazon Quick.

Create an Intuit Developer app (Custom OAuth app)

Create an app in the Intuit Developer portal to obtain the client credentials that you need for Amazon Quick. For more information, see OAuth 2.0 on the Intuit Developer website.

  1. Sign in to the Intuit Developer portal on the Intuit website.

  2. From your workspace, choose the plus (+) button to create a new app.

  3. For Type, select the QuickBooks Online platform.

  4. Enter an App name for your application.

  5. For Permissions, under QuickBooks Online and Payments, select the authorization scopes that your integration requires. For the recommended scopes, see Recommended scopes.

  6. Complete the app creation. On the confirmation page, choose Show credentials to view your development credentials.

  7. Record the following values. You need them when you configure Amazon Quick.

    • Client ID

    • Client secret

  8. In the app settings, choose the Redirect URIs tab. Add the Amazon Quick callback URL: https://{region}.quicksight.aws.amazon.com/sn/oauthcallback

  9. Choose Save.

Recommended scopes

When you create an Intuit Developer app, select the following authorization scopes based on the actions that you want to use.

QuickBooks recommended scopes
Scope Description
com.intuit.quickbooks.accounting Accesses QuickBooks Online accounting data, including invoices, customers, vendors, accounts, and financial reports.
com.intuit.quickbooks.payment Accesses QuickBooks Online payment data, including purchases and payment transactions.
openid Authenticates the user's identity.
email Reads the user's email address.
profile Reads the user's profile information.
phone Reads the user's phone number.
address Reads the user's address.
Note

The openid, email, profile, phone, and address scopes are used for user authentication with Custom OAuth app.

Setting up the connector in Amazon Quick

Connect from the Available tab

If you want to use Default OAuth app authentication, you can connect directly from the Available tab without additional configuration.

  1. In the Amazon Quick console, choose Connectors.

  2. On the Available tab, find QuickBooks and choose Connect.

  3. Complete the QuickBooks sign-in flow and grant the requested permissions.

To configure a connector with Custom OAuth app instead, use the Create for your team tab as described below.

Create from the Create for your team tab

After you complete any required QuickBooks configuration, create the connector in Amazon Quick.

  1. In the Amazon Quick console, choose Connectors.

  2. Choose the Create for your team tab.

  3. Find and choose QuickBooks.

    Note

    If a QuickBooks connector already exists, a dialog appears with your existing connectors. To use an existing connector, choose it. To create a new one, choose No, create new.

  4. Enter a Name for your connector. Optionally, choose + Add Description to add a description.

  5. For Connection type, choose Public network.

  6. For OAuth Configuration, choose one of the following authentication methods and configure the required fields.

    1. For Default OAuth app:

      No additional credentials are needed. Choose Next to continue.

    2. For Custom OAuth app, configure the following fields:

      • Base URL (Optional) – The QuickBooks API base URL. Example: https://quickbooks.api.intuit.com

      • Client ID – The client ID from your Intuit Developer app.

      • Client secret – The client secret from your Intuit Developer app.

      • Token URL – The token endpoint. Example: https://oauth.platform.intuit.com/oauth2/v1/tokens/bearer

      • Authorization URL – The authorization endpoint. Example: https://appcenter.intuit.com/connect/oauth2

      • Redirect URL – Pre-filled with the Amazon Quick callback URL.

  7. Choose Next.

  8. If you chose Default OAuth app or Custom OAuth app, an Intuit authorization window opens. Review the requested permissions and choose Connect.

  9. On the Review page, review the available actions for the connector. Choose Next.

  10. On the Publish page, choose who can access the connector. You can enable access for everyone in your organization or search for specific teams or groups.

  11. Choose Publish.

Available actions

After you set up the connector, the following actions are available.

QuickBooks available actions
Category Action Description
Queries Search Entities Searches across QuickBooks entities using a query.
Accounts Get Account Details Retrieves details for a specific account by query.
Accounts Get Account Retrieves a specific account by ID.
Accounts Create Account Creates a new account in the chart of accounts.
Invoices Get Invoice Retrieves a specific invoice by ID.
Invoices List Invoices Lists invoices with optional filtering.
Invoices Create Invoice Creates a new invoice.
Customers Get Customer Retrieves a specific customer by ID.
Customers Create Customer Creates a new customer record.
Vendors Create Vendor Creates a new vendor record.
Purchases Create Purchase Creates a new purchase transaction.
Purchases Create Bill Creates a new bill from a vendor.
Journal entries Create Journal Entry Creates a new journal entry.
Reports Get Profit and Loss Report Generates a profit and loss report.
Reports Get Customer Balance Report Generates a customer balance summary report.
Reports Get Customer Balance Detail Generates a detailed customer balance report.
Reports Get Vendor Balance Report Generates a vendor balance summary report.
Reports Get Vendor Balance Detail Generates a detailed vendor balance report.
Reports Get General Ledger Report Generates a general ledger report.
Batch operations Batch Execute Operation Runs multiple operations in a single batch request.
Company Get Company Info Retrieves information about the connected company.
Note

The actions that you can use depend on the company data accessible to the authenticated user.

Managing and troubleshooting

To edit, share, or delete your connector, see Managing existing integrations.

Authentication issues

  • Sign-in fails (Default OAuth app or Custom OAuth app) – Verify that your Intuit account is active and that you can sign in to quickbooks.intuit.com on the Intuit website directly. For Custom OAuth app, confirm that the redirect URI in your Intuit Developer app matches the Amazon Quick callback URL.

  • Invalid client credentials (Custom OAuth app) – Verify that the Client ID and Client secret match the values in your Intuit Developer app. You can view your credentials from the app settings in the Intuit Developer portal.

  • Insufficient permissions – Verify that the scopes configured for your Intuit Developer app include the permissions required for the actions that you want to use. See Recommended scopes.