Purpose
If your company is using other accounting systems, including Quickbooks Online, for Accounting, read this article!
Following these steps will make sure that your Accounting System is successfully synced with Aspire. This article is also for those using QuickBooks Online!
Table of Contents
Setup in QuickBooks Online
Records will sync automatically in your accounting system when information gets entered into Aspire. Without completing the sync, the information recorded in Aspire would need to be manually entered to your accounting system.
Without successfully syncing QuickBooks Online may not be up-to-date and your team might be doing extra work! The sync prevents duplicate work for the administrator that is transferring the information and saves time.
Accounting
Confirm if you have these accounts in QuickBooks Online.
Checking Account
Account Type - Bank Account
❗ Note: If you enter your bank account here, this will still go into Undeposited Funds, but the account would still need to be added.
Accounts Receivable
Account Type - Accounts Receivable
Accounts Payable
Account Type - Accounts Payable
Add the following accounts to your Chart of Accounts in QuickBooks Online if you do not have them already.
Inventory Holding
Account Type - Other Current Asset
The accounts below are Sub Accounts under Inventory Holding.
Inventory Holding - Material
Inventory Holding - Equipment
Inventory Holding - Sub
Inventory Holding - Other
Account Type - Other Current Asset
If you use SAAS Based Accounting
For SAAS based accounting, you will need to add additional accounts in your Chart of Accounts. These do not need to be added for the sync, but will need to be added before using Aspire.
Over/Under (Earned Revenue Greater than Invoiced)
Account Type - Other Asset
Over/Under (Invoiced Revenue Greater than Earned)
Account Type - Other Current Liability
Revenue Variance
Account Type - Income
Other Steps to Complete
Set up a customer called Aspire System in QuickBooks Online.
All active vendors go to Aspire; make sure the vendors are all currently used and active. Aspire pulls vendors from QuickBooks Online from the company name field first and if that field is blank, it will look at the vendor name.
Aspire recommends cleaning up your vendor list and deactivating any vendors that you do not use in QuickBooks. Once vendors come over into Aspire, deactivate any vendors you would not use in Aspire. This ensures you do not use the incorrect vendor for Purchase Receipts.
Examples: utilities, notes payable, insurance, etc.
Syncing QuickBooks Online With Aspire
After you have entered your QuickBooks information, you can move forward with the set up in Aspire.
⚠️ Note: QuickBooks Online will need to be closed for this step.
Select Settings in the blue side menu, then select Administration.
Click the Configuration.
Select the Accounting Sync.
On the drop down Integrate with External Accounting at System Level, choose QuickBooks Online from the dropdown.
Then, select the blue Accounting Sync button.
This opens the login screen for QuickBooks. Enter your credentials for the administrator account, and authorize Aspire to connect with your QuickBooks Online account to complete the sync set up.
Return to Aspire, and select the Chart of Account numbers from each drop down.
📌 Note: The Purchase Tax Account, the Revenue Account and the Misc. Invoice Amount are for Aspire's Canadian clients, only.
If you have successfully finished entering the sync information on this page, the Sync Meeting for QuickBooks Online could be skipped.
Sync Meeting for QuickBooks Online
If you need additional support when syncing QuickBooks Online to Aspire, a sync meeting is also an option. The meeting will discuss the steps listed above.
🧠 Depending on your sales tier, an Aspire Accounting Specialist will schedule a call for your QuickBooks sync. If you are a Cohort client or are not in Implementation, to get your sync call scheduled, please submit a support ticket to AspireCare.
Make sure you have access to the Administrator account for QuickBooks, so you can make necessary changes during the call.
You will need to screen share to display QuickBooks and Aspire on your computer.
This meeting will confirm that your Chart of Accounts in QuickBooks Online is configured correctly.
Once synced, you'll select the Chart of Account information from the drop down in Aspire under Accounting Sync in Administration.
Set Up in Other Accounting Systems
⚠️ Coordinate time with your accounting system support team to complete the sync steps.
Without successfully syncing your accounting system it may not be up-to-date and your team might be doing extra work! The sync prevents duplicate work for the administrator that is transferring the information and saves time.
Confirm if you have following accounts in your accounting system Chart of Accounts:
Checking Account
Account Type - Bank Account
Accounts Receivable
Account Type - Accounts Receivable
Add the following accounts to your Chart of Accounts if you do not have them already.
Inventory Holding
Account Type - Other Current Asset
The accounts below are Sub Accounts under Inventory Holding.
Inventory Holding - Material
Inventory Holding - Equipment
Inventory Holding - Sub
Inventory Holding - Other
Account Type - Other Current Asset
If you use SAAS Based Accounting
For SAAS based accounting, you will need to add additional accounts in your Chart of Accounts. These do not need to be added for the sync, but will need to be added before using Aspire.
Over/Under (Earned Revenue Greater than Invoiced)
Account Type - Other Asset
Over/Under (Invoiced Revenue Greater than Earned)
Account Type - Other Current Liability
Revenue Variance
Account Type - Income
Additional Accounts to Add
This is not for the sync but will need to be added before creating your first payroll from Aspire and before completing journal entries from your End of Month reports: copy from up above the information
Payroll Holding Account
Account Type – Other Current Liability
Holding Burden Account
Account Type – Other Current Liability
Other Steps to Complete
After you have finalized your chart of accounts, complete the last steps in your accounting system before moving over to Aspire to enter your Accounting Sync details.
📌 Note: If you need assistance on setting up your chart of accounts in your accounting system, please reach out to your accounting system representative directly.
Set up a Customer called Aspire System.
Aspire recommends cleaning up your vendor list and deactivating any vendors that you do not use in your accounting system. Once vendors come over into Aspire, deactivate any vendors you would not use in Aspire. This ensures you do not use the incorrect vendor for Purchase Receipts.
Examples: utilities, notes payable, insurance, etc.
Aspire pulls vendors from certain fields in your accounting system.
Example: Acumatica and Great Plains pull vendors from the company name field.
Enter Sync Details in Aspire
Next, setup your Accounting Sync details in Aspire.
❗ Note: There is no sync call for other accounting systems. Follow the steps below to ensure that your sync is correct between your accounting system and Aspire.
Click Settings.
Click Administration.
Select the Configuration. Then, click Accounting Sync.
Choose Integrate with External Accounting at System Level and pick your accounting system from the list.
Setup Web Service Address, User ID, and Password.
This information is obtained from your accounting system.
Enter Account Details in Aspire
On the same Accounting Sync screen, you'll also enter your Account Information from your accounting system. If you have questions on how to enter account numbers in Aspire, please contact your accounting system representative.
AP Account
This is your Accounts Payable Account.
A/R Account
This is your Accounts Receivable Account.
Deposit Account
This is your Checking Account.
Materials Account
This is your Inventory Holding - Materials Account.
Equipment Account
This is your Inventory Holding - Equipment Account.
Sub Account
This is your Inventory Holding - Sub Account.
Other Account
This is your Inventory Holding - Other Account.
Purchase Tax Account – Leave this blank.
Save the Accounting Sync information with the green icon when everything is entered.
