All Collections
Integrating Moxie with Quickbooks Online
Integrating Moxie with Quickbooks Online

Sync clients, invoices, payments, and expenses with QB Online

Geoff Mina avatar
Written by Geoff Mina
Updated over a week ago

Integrating your Quickbooks Online account with Moxie will enable automatic synchronization of Clients, Invoices, Payments, and Transaction fees. Additionally, if you have complex sales tax scenarios, Moxie will integrate your Quickbooks Sales Tax rules directly into the invoicing flow to make compliance a breeze.

Note: Quickbooks Self-Employed is NOT supported. Quickbooks doesn't allow any API access to their Self-Employed product.

To begin, click your workspace settings > connected apps > accounting. Click "Connect Quickbooks Online" and proceed with authenticating with Quickbooks and granting access to Moxie.

Once your Quickbooks Online account is connected, you will need to map your GL accounts to the appropriate Moxie events. (If you don't know what this means, you should ask your CPA for assistance here).

There are 3 fields that require mapping:

Income account - This is the account where payments will be allocated to. Typically this should be mapped to a "Sales" category.

Payment processing expense account - If you accept online payments via either Stripe or PayPal the amount deposited into your account will be less the processing fee amount of Stripe or PayPal. An automated expense will be added to this account to allow for accurate tracking of fees associated with accepting online payments.

Sales tax account - If you have complex sales tax requirements you can build your sales tax profile in Quickbooks and select the option here. The sales tax % on the invoices will be automatically set based on the profile from Quickbooks. Invoices and payments that are sent to Quickbooks will have accurate sales tax identifiers associated with the line items.

Undeposited Funds - IMPORTANT - Please ensure you have the original "Undeposited Funds" account in your Quickbooks Chart of Accounts as that is the account that all payments will be placed into for the clearing account.

Now that your GL and sales tax accounts are mapped, all of your future invoices, payments, and transaction expenses will automatically synchronize with Quickbooks.

What to Expect:

  • You will begin seeing customer records automatically added to Quickbooks. When you send your first invoice after connecting Quickbooks, Moxie will try to find an existing customer with the same name. If no customer is found, Moxie will create a new customer with the basic information that was entered into Moxie.

  • Once an invoice or payment is sent to Quickbooks you will see a Quickbooks icon confirming that the synchronization was successful.

  • If you make any changes to an Invoice or Payment after the initial synchronization, Moxie will update the corresponding records appropriately to keep everything in order.

Notes for your CPA:
Moxie places the payment for invoices into the Undeposited Funds account. Any electronic payment fees are added as an expense into the selected Payment processing expense account. The bank transaction can be matched against the Undeposited Funds and the Payment Processing account to fully account for the deposit.

Important: If a payment is received outside of Moxie, make sure you mark the invoice paid in Moxie before performing any matches within Quickbooks.

Still have questions? Feel free to chat with us using the icon in the lower right to get more info. We are always happy to help!

Did this answer your question?