Commerce QBO UI Preview

This project is not covered by Drupal’s security advisory policy.

Description

A first of its kind, Commerce Quickbooks Online UI (QBO UI for short) offers site maintainers the ability to connect their websites to their QuickBooks Online account and process multiple types of reports automatically. It's built with flexibility in mind, allowing an admin to fully customize when, how, and what kind of data is sent.

Some features:

  • Six report types available: Invoice, Estimate, Payment, Sales Receipt, Refund, Credit Memo
  • Import data from QuickBooks such as Taxes and Accounts
  • Map QuickBooks Taxes to Drupal Taxes for full tax automation support
  • Customer and Item matching when possible
  • Customer and Product exporting when matching isn't possible!
  • Report fields accept tokens for full customizability
  • Rule based report triggering, to offer full flexibilty for when a report is sent
  • Safety checks: Reports sent before the module is fully configured are captured and stored for later processing; self-maintained error logs; Full OAuth integration

Requirements

This module requires the following modules:

Configuration

This module relies on the Quickbooks Online API module to function properly. Before configuring this module, make sure you have enabled and followed all configuration steps for Quickbooks Online API. A warning will be displayed that this module will be unusable until this step is completed.

  • Do basic setup and import some basic QuickBooks data (optional, but recommended) in Administration » Store » Quickbooks » Config

    - Populate some entity fields with data from Quickbooks
    This will allow you to select things like what kind of account a report should withdraw or deposit funds into, and map your QuickBooks tax types to your Drupal tax rates.

  • Configure your first report type in Administration » Store » Quickbooks » Report Types » Select a Report Type

    - Choose a report type to configure.
    Report types act as templates to be used for structuring the request to QuickBook when a report is being generated. Some fields accept tokens for true templating capabilities.

    For report types with configurable QuickBooks Line Items, each line item produces one-to-many lines in your QuickBooks report. Example: a Line set to be created for Product type line items will generate a line in the report for each Product that appears in the order.

  • Set up a rule for when a report should be generated in Administration » Store » Quickbooks

    - Click "Add a QuickBooks Report Rule"
    Follow the standard Rule setup process, choosing what even should trigger sending a report, selecting a report to be sent and if it should be sent immediately or stored for review and manual export. Note: you will be unable to create a rule if you haven't set up at least one report type.

Supporting organizations: 

Project information

Releases