Quickbooks Integration
11 min
connecting regpack to quickbooks online plan requirement the quickbooks integration is available on mid market, enterprise, and custom plans only it is not available on the smb plan, even if api admin access is enabled on your account if you see a message saying your plan does not include integrations, contact support at support\@regpacks com to discuss upgrading the quickbooks online integration automatically sends your registration and payment data from regpack to quickbooks once connected, you no longer need to manually enter customer records, invoices, or payments; regpack handles that for you regpack is always the source of truth quickbooks receives a copy of your data for accounting purposes nothing in quickbooks will affect or change your regpack data what gets sent to quickbooks what's in regpack what gets created in quickbooks your products and sessions service items registrants (parents / students) customers and sub customers registration carts and payment plans invoices payments collected payment records refunds issued in regpack refundreceipts chargebacks refundreceipts cart lines removed from closed invoices credit memos before you connect make sure you have the following ready before starting setup you are logged into regpack as an organization administrator your organization is on the mid market, enterprise, or custom plan your regpack account has an api admin set up this is required for payment sync if you are not sure whether you have one, contact support\@regpacks com you have a quickbooks online account quickbooks desktop is a separate product and is not supported you know which quickbooks income accounts you want to map to each of your regpack product categories you will be asked during setup how to connect your quickbooks account setup takes about five to ten minutes and has two steps step 1 — set up your account mapping in regpack, go to project settings and click integrations find the quickbooks card and click connect you will be taken to quickbooks to log in and authorize regpack use your quickbooks admin credentials and click authorize once you are brought back to regpack, a settings screen will appear map each of your product categories to a quickbooks income account using the dropdown menus select your accounts receivable (ar) account click save to complete step 1 step 2 — run your first sync after saving your mapping, a sync dialog will appear automatically click sync to begin regpack will start sending your products and registrants to quickbooks depending on how many registrants and products you have, this may take a few minutes once the first sync is complete, the integration is live and regpack will keep quickbooks updated automatically going forward {% hint style="info" %} products are always synced before registrants and invoices this is by design; quickbooks needs your service items set up before it can attach them to invoices {% endhint %} how ongoing sync works after setup, regpack syncs changes to quickbooks automatically whenever any of the following happen a payment is collected or its status changes a registrant's cart is updated (items added, removed, or changed) a product's price or name is updated these updates typically appear in quickbooks within a few minutes how invoices are updated if a registrant's cart changes after an invoice has already been sent to quickbooks, regpack updates the invoice automatically if the invoice is already fully paid (closed), a new supplemental invoice is created instead this keeps your quickbooks records accurate and consistent with standard accounting practice if an item is removed from a closed invoice, a credit memo is posted automatically to keep your accounts receivable in balance how payments flow into quickbooks all payments, refunds, and chargebacks are routed through undeposited funds in quickbooks this is the standard approach that accountants expect when reconciling against bank deposits payments land in undeposited funds and close the related invoice refunds post as refundreceipts, reducing undeposited funds chargebacks also post as refundreceipts your undeposited funds balance at any point reflects the net cash your payment processor owes you, making future bank reconciliation straightforward what you can control once connected, you have access to the following options from your integration settings resync — manually trigger a full sync of all your data, useful if you think something is out of sync disconnect — removes the connection between regpack and quickbooks and stops all future syncing your existing data in quickbooks is not deleted you can also view pending and failed sync jobs, and a detailed error log, directly from the integration settings panel things to know family accounts if a parent registers multiple children in your program, regpack sends the parent as the main quickbooks customer and each child as a sub customer invoices are created at the child level, which matches how quickbooks handles family billing free registrations and scholarships even if a registration has a $0 balance — such as a scholarship recipient — regpack still sends the invoice to quickbooks this keeps your enrollment and financial records consistent, and is useful for reporting purposes refunds when you issue a refund in regpack, a refundreceipt is created in quickbooks automatically you do not need to enter refunds manually chargebacks when a chargeback occurs, regpack posts a refundreceipt in quickbooks to reflect the cash out registrants in multiple projects if the same person registers across more than one of your regpack projects, they share a single quickbooks customer record regpack links registrants by organization, not by individual project deferred revenue (advanced) if your organization runs sessions or events with future start dates, regpack supports deferred revenue accounting when enabled, invoice lines for future dated sessions are routed to a liability account at the time of invoicing, and a journal entry is posted automatically on the session's start date to move the revenue to income contact support\@regpacks com if you are interested in this feature troubleshooting if quickbooks data looks wrong check that your integration is showing as active in regpack's integration settings if you see an error status, try the resync button you can also open the error log from the integration settings panel this shows a record of every sync event and any failures if data is still missing or incorrect after a resync, contact support\@regpacks com and let us know which records are affected if a payment or refund didn't sync payment sync requires an api admin on your regpack account if payments are not appearing in quickbooks, confirm that an api admin is configured on your account if you are unsure, contact support\@regpacks com if your connection expires quickbooks connections can expire if the authorization token is not refreshed regpack handles this automatically in most cases if you see a message saying your quickbooks connection needs to be re authorized, click reconnect and log back into quickbooks no data is lost during this process frequently asked questions does quickbooks data sync back to regpack? no this is a one way connection regpack sends data to quickbooks changes made in quickbooks do not affect your regpack account can i connect the same quickbooks account to multiple regpack projects? yes each regpack project connects to quickbooks separately, but they can share the same quickbooks account a registrant who appears in more than one of your projects will have one quickbooks customer record shared across both i'm on the smb plan — can i still use this integration? no the quickbooks integration requires a mid market, enterprise, or custom plan enabling api admin access on an smb account does not unlock this feature contact support\@regpacks com to discuss upgrading what happens if i disconnect the integration? disconnecting stops all future syncing your existing data in quickbooks stays in place — nothing is deleted you can reconnect at any time and run a new full sync does this work with quickbooks desktop? no this integration is for quickbooks online only how long does the first sync take? it depends on the size of your account small accounts may finish in under a minute larger accounts with hundreds of registrants may take several minutes you can watch progress on screen during the sync what if an invoice is already paid and a cart item is removed? regpack will not modify a closed (fully paid) invoice instead, it automatically posts a credit memo in quickbooks to reflect the change and keep your accounts receivable accurate
