QuickBooks Integration App (Beta)

Wonderful news! We are now offering integration with QuickBooks Online via an App in the QuickSchools App Store. The app is still in private beta (as of Aug 11, 2014), so if you don’t see it on your App Store menu, please come chat with us to request access.

This first beta version will allow users to do the following:

  • Connect with your QuickBooks Online Account
  • Map products/services in your QuickBooks Online Account with Fee Tracking Categories in your QuickSchools Account.
  • Map customers in your QuickBooks Online Account with either students or primary payers (for Family Billing) in your QuickSchools account. If customers have not been created in your QuickBooks Online Account, you can export them (exported records will be mapped automatically)
  • Export Charges, Invoices and Payments from your Fee Tracking Module in QuickSchools into your QuickBooks Account
QuickSchools QuickBooks Equivalent
Fee Tracking Categories Products / Services
Students / Primary Payer Customer / Accounts
Fee Tracking Charges, Invoices and Payments Invoices and Payments

In this article, we’ll run through a few quick steps on setting up integration with your QuickBooks Online account. For a list of supported countries check out:

https://qboe.custhelp.com/app/answers/detail/a_id/3680

The first time you access the QuickBooks App, you will be faced with the following screen:

Connect to QuickBooks
Connect to QuickBooks

Simply click on the “Connect to QuickBooks” button to log into QuickBooks. The following login screen should pop-up:

Logging into QuickBooks Online from QuickSchools
Logging into QuickBooks Online from QuickSchools

Once connection has been established, you’ll be faced with the following options:

Setting Up QuickBooks Integration
Setting Up QuickBooks Integration

The screen already organizes the steps for your. Mapping of the products and services are optional, depending on whether you use the Fee Tracking Categories menu:

Mapping Categories in QuickSchools to QuickBooks Products and Services
Mapping Categories in QuickSchools to QuickBooks Products and Services

Step 1 is obviously to synchronize the customers first. You have 2 options here: (1) Map and (2) Export. When mapping customers, you’re matching either students in your QuickSchools account, or Primary Payers (if Family Billing is turned on) to customer accounts in QuickBooks:

Mapping Customers in QuickBooks
Mapping Customers in QuickBooks

If you do not have the customer created in QuickBooks yet, you have the option of exporting the customer:

Exporting Customers to QuickBooks
Exporting Customers to QuickBooks

Step 2 (once customers have been mapped) is to export your Fee Tracking Transactions (which include Charges, Invoices and Payments) into QuickSchools.

Exporting Transactions from QuickSchools to QuickBooks
Exporting Transactions from QuickSchools to QuickBooks

Some things to note about exporting transactions:

  • You can select individual transactions, or groups of transactions to export.
  • When a transaction is exported, the system notes when it was exported in the last “Export” column on the far right.
  • Once a transaction is exported, you do have the option of re-exporting the transaction. However, this does not update the existing record in QuickSchools. Instead, it re-inserts the record as a new entry in your QuickBooks account. You will need to offset the original transaction manually.

We’re always looking for ways to improve our software. Please do let us know if you have any further suggestions for improvement.

Leave a Reply