Enrollsy allows you to sync transactions occurring within our platform with your QuickBooks Online (QBO) account.
You will map the Charge Items and Discount Items created within Enrollsy to your QBO accounts and subaccounts. You can sync all transactions within Enrollsy to QuickBooks one month at a time.
We recommend building your pricing model and Charge/Discount Items with this syncing process in mind.
Step 1: Reach out to Enrollsy
Email support@enrollsy.com or chat in letting us know that you want to use our QBO integration.
Step 2: Clean Up Any Customer Records
Every time you sync with QBO, Enrollsy will automatically create a new record within your QBO Company File for each of your Enrollsy Primary Account Holders. If you already have some customer records within QBO and don't want to create duplicate accounts after syncing, please ensure that your existing customer accounts are formatted correctly. Every customer record that Enrollsy finds this way will be updated instead of duplicated. The required formatting is as follows:
[LAST NAME], [FIRST NAME] with the comma character in the middle (Example: John Doe is the primary account holder. His customer name should read Doe, John).
We send the following contact information for each account:
Primary Account Holder first and last name
Primary Account Holder email address
Primary Account Holder street address
Primary Account Holder cell and home phone numbers
Step 3: Map Enrollsy with QBO
Mapping Enrollsy with QBO is an essential step to syncing your Enrollsy account with QuickBooks. You need to map out what information should be imported and where this information should be recorded. Enrollsy creates a QuickBooks account for every account/subaccount specified in the mappings. We also create a QuickBooks item associated to those accounts for the "Product or Service Name." You specify a mapping for every Charge Item and Discount Item. This gives you full control over which accounts the Charge Items and Discount Items get mapped into.
To do this, select the person icon at the top right side of your screen, select the "Items" tab, and scroll down to the bottom of the page. From here, you will see a link to complete your QuickBooks mappings.
Three Different Item Types:
Now we'll go over each of the different Item Types. There are three different Item Types: Company Mapping, Fee, and Discount. Each mapping will have ONE of these three items.
1 - Company Mapping - Refers to system static mapping settings. These come with every account. You likely have the following Company Mappings on your account:
Tuition Mapping - This company mapping was required for our old billing system. Unless you know that you are still on Version 1 billing, please disregard this company mapping.
Manual Adjustment Mapping - Adjustments are made by Admins within Individual Customer Accounts. The Discount Item "Misc Credits" MUST be mapped to this company mapping.
Misc Sales Mapping - Uncategorized sales recorded within Enrollsy. All charges with no specific Charge Items will be mapped to this company mapping.
Undeposited Funds Mapping - Cash or check payments.
Fee - Refers to the Charge Items you created in My Company > ITEMS > Charge Items. Every Charge Item that you create will have a corresponding Fee created automatically.
Discount - Refers to the Discount Item name that you created in My Company > ITEMS > Discount Items. Every Discount Item that you create will have a corresponding Discount created automatically.
Mapping Item Types to your Quickbooks Account
Each of the above Item Types requires specific mappings to ensure they are synced correctly into your QBO account. Each item requires the following information to be provided in the QBO Mapping page fields, ensuring they correspond with your QBO account.
*Account (REQUIRED)
Whenever a transaction is recorded within Enrollsy (e.g., a discount is provided or a specific charge occurs), determine which of your QBO accounts to sync with. If you have QBO accounts already created that you would like to sync transactions into, ensure you map that account name in exactly as it appears in QBO. For example, "Tuition" or "Revenue."
If you haven't created any QB accounts yet, simply type the name of the account you want to create in the Enrollsy mappings page. During your first sync, accounts will be created based on your mappings. *This is REQUIRED.
*Product or Service Name (REQUIRED)
Every item listed on your mappings page must be mapped to a Product or Service Name. Like accounts, you can either add the names of products or services that have already been created in your QBO account or create new labels within your Enrollsy mappings page.
During the first sync, those new labels will create new products or services within your QBO account. Once you have completed your mapping for each type listed, you are ready to process your first QB sync! *This is REQUIRED.
Sub Account (Optional)
In QuickBooks Online, you can create subaccounts to break down your expenses, income, and other account types in more detail. If desired, record which subaccount you would like the transaction recorded into.
Append Enrollment Period to Sub Account (Optional)
If a transaction is tied to a specific Enrollment Period, would you like this information recorded within QuickBooks? If so, select the "Append Enrollment Period to Sub Account" checkbox. This allows you to differentiate between tuition collected for one Enrollment Period versus another. NOTE: At this time, we do not sync any transactions to specific Programs or Classes.
Important Mapping Information
It is important for you map "Misc Credits" to the Company Mapping: "Manual Adjustment Mapping." Misc Credit is used when a credit or discount is given without a discount item. If this is not in your mappings, your QBO sync will fail.
NOTE: If you have a transaction with no Charge Item, this item will be automatically mapped under the Company mapping: "Misc Sales."
Step 4: Complete your first QBO Sync
If this feature is available on your plan within Enrollsy, head to your reports page to start the exporting process. MENU > Reports > QuickBooks Online Export.
Select the date range to sync (one month at a time) and select the desired classifications. Start by clicking "Start Sync." After this, you will begin the integration with Enrollsy by authenticating with QuickBooks Online.
Once complete, head into your QBO account to see the synced transactions. Keep in mind that QuickBooks uses a double-entry system, which means you will need to reconcile your bank statement with the transactions synced from Enrollsy. The transactions will likely show within the "Undeposited Funds" account directly after syncing, ready for you to complete your reconciliations.
Future Syncs
Sync your QBO account with Enrollsy every month by following the sync instructions outlined in Step 4.
Errors When Syncing
If your import into your company file in QuickBooks Online was unsuccessful, please see this troubleshooting article before contacting us. Be sure to do all the steps in the article. Revert your company file to your backup. We don't want corrupted data in your company file.
If you have completed all steps in the troubleshoooting article and are still getting an error message, please note the date and time of the error and screenshot/download any errors you are displayed and contact us on the admin portal chat box.
Check Console for Errors
Check Console for Errors
When you get that error message, you can look in your console for the error. Follow these steps:
Right-click anywhere in the browser window and select Inspect from the pop-up menu.
By default, the Inspect will open the "Elements" tab in the Developer Tools. Click on the "Console" tab, which is to the right of "Elements".
Clear the console by right-clicking in the console, clicking "Clear console" and choosing to show errors only.
After you've cleared the console, could you try to reproduce the issue?
Any errors that occur will appear in red — could you please take a screenshot of those.