MySQL + QuickBooks Online

Create new QuickBooks Online journal entries from new MySQL rows with custom queries

Effortlessly manage your bookkeeping by setting up this streamlined workflow. Whenever a new row is added in your MySQL database, entries will be instantly created in your QuickBooks Online Journal. This seamless process helps you track transactional data without having to manually input information, enhancing efficiency and accuracy in your financial records.

Effortlessly manage your bookkeeping by setting up this streamlined workflow. Whenever a new row is added in your MySQL database, entries will be instantly created in your QuickBooks Online Journal. This seamless process helps you track transactional data without having to manually input information, enhancing efficiency and accuracy in your financial records.

  1. When this happens...
    MySQLMySQL
    New Row (Custom Query)

    Triggered when new rows are returned from a custom query that you provide. Advanced Users Only

    TriggerScheduled
  2. automatically do this!
    QuickBooks OnlineQuickBooks Online
    Create Journal Entry

    Creates a new journal entry.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Table/ViewRequired

    Trigger
    Scheduled
    Try It
    • QueryRequired

    Trigger
    Scheduled
    Try It
    • Table/ViewRequired

    • Primary KeyRequired

    • Order ByRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • TableRequired

    • ID ColumnRequired

    Action
    Write
    • Table/ViewRequired

    • Order By

    • Dedupe Key

    Trigger
    Scheduled
    Try It
  • MySQL triggers, actions, and search

    New Table

    Triggered when you add a new table.

    Trigger
    Scheduled
    Try It
    • TableRequired

    Action
    Write
    • TableRequired

    • Lookup ColumnRequired

    • Lookup ValueRequired

    Action
    Search
mysql logo
mysql logo

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.
Learn moreHelp

Related categories

  • Databases

Similar apps

SQL Server integrationsSQL Server integrations

SQL Server

Databases
Quickbase integrationsQuickbase integrations

Quickbase

Databases
Firebase / Firestore integrationsFirebase / Firestore integrations

Firebase / Firestore

Databases
quickbooks logo
quickbooks logo

About QuickBooks Online

QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.
Learn moreHelp

Related categories

  • Accounting

Similar apps

Xero integrationsXero integrations

Xero

Accounting
FreeAgent integrationsFreeAgent integrations

FreeAgent

Accounting
Wave integrationsWave integrations

Wave

Accounting