Core-QuickBooks Online Integration

Overview

Data integration between Core and QuickBooks® Online (by Intuit) can make your time billing, accounting and financial management tasks easier. Although Core is a full-featured business management and accounting program, you might still want to use QuickBooks Online for general accounting, online banking or payroll. Our Core web app is available on the QuickBooks App store. There are some differences between Core and QuickBooks Online that should be understood to ensure smooth and accurate data synchronization. Core is project-centered and supports a hierarchical structure. In contrast, QuickBooks Online is client -centered and uses a flat job (project or sub-customer) structure. Click to watch this video on managing data integration with QuickBooks Online.

Core integrates with all editions of QuickBooks Online 2018 or above; however, you must check the edition you have for the features it includes. In addition, only the QuickBooks Online account owner can carry out the data sync between the two programs. Core can sync data bidirectionally with QuickBooks Online, which means it can send data as well as get data. The table below shows the direction in which specific data can flow between Core and QuickBooks Online. Whether it flows in one direction or the other (or both) depends on your sync settings. Click here for detailed mappings.

Core Data Data Flow QuickBooks Data
Chart of Accounts

<->

Chart of Accounts
Activity Items

<->

Service Items

Expense Items

<->

Inventory/Non-Inventory Items
Employees

<->

Employees
Clients

<->

Customers
Vendors

<->

Vendors
Projects

<->

Projects and Sub-Customers
Time Entries

<->

Time Entries
Expense Entries

<->

Expenses (Checks, Credit Cards, Vendor Bills)
Estimates

<-

Estimates
Invoices

<->

Invoices
Payments

<->

Payments
Vendor Bills

<->

Bills
Classes

<->

Class List

 

During data synchronization, Core either overwrites the duplicate data, if any, or leaves it as is, depending on the overwrite rules specified by you in Sync Settings. If you are sending Core data from individual screens using the Actions > Send To option in the detail view, it does not obey the sync rules and filters set in the Sync Settings screen. The sync settings are effective when doing a batch sync from the Integrations screen. Sometimes you might have to enter data separately in both programs. You can manually check and merge the duplicate data or else, use the smart match Record Mappings option to match or un-match synced data between the two databases.

Although you can use our built-in data integration tool to sync your data between the two programs, there are some limitations in doing that. We recommend that option only if you continue to use both QuickBooks and Core for your business needs and plan to sync the data regularly. However, if you plan to switch to Core completely and want to transfer all the accounting data and detailed transactions, we recommend using our Custom Conversion Services.

Field Descriptions

Synchronization Rules

Basic Tasks

Connect with QuickBooks Online

Specify Sync Settings

Sync Data with QuickBooks Online

Advanced Tasks

Assign Accounts for Data Sync

Get Data from QuickBooks Online

Send Data to QuickBooks Online

Map Records

Un-Map Records

Verify Synced Data

Field Descriptions

Field Name Field Description
Integrations > QuickBooks Sync Detail > Details
History

Displays a history of previous synchronizations taken place between Core and QuickBooks Online, if any. This sync log shows you the date, time, description and action taken.

More: Clear Sync Log

You can clear the sync log if you do not want to see the sync history between the two programs.

Export as CSV

You have an option to export the sync log as a comma-separated values (.csv) file that can be viewed in Microsoft Excel or any other spreadsheet program. This allows you to focus on the most recent sync history while maintaining a record of the previous history.

Integrations > QuickBooks Sync Detail > Sync Settings > Get >
If record exists, overwrite?

You can specify the rule for overwriting data in Core when getting it from QuickBooks Online, if that record already exists here. For instance, if both Core and QuickBooks Online have a record for employee John Doe, this rule determines whether upon synchronization that record will be updated or not.

  • Never: Data will not be overwritten in Core. Thus, you will have two versions of that record. For example, if an employee record has a different address in each database, those fields will not be updated upon synchronization.
  • Most Recent: Core compares the last modified date of fields in Core and QuickBooks Online. The more recent one replaces the older data in either databases. For example, if an employee record has a different address in each database, the older fields will be updated upon synchronization.
  • Always: Data will always be overwritten in Core. Thus, you will have one version of that record. For example, if an employee record has a different address in each database, the Core fields will be updated upon synchronization.

QuickBooks Items as Activity Codes

Activity items in Core are linked to service items in QuickBooks Online. You must select the QuickBooks items from the drop-down that you want to get as activity items. By default, the items that have previously been synced from Core to QuickBooks Online appear disabled or grayed out in the list.

Note: Typically, this has to be done just once; however, you have to revisit this option whenever you add new service items in QuickBooks.

Default Bill Rate

You need to set a default bill rate of employees received from QuickBooks Online. By default, the value is taken as 1. You can also change these values later in Core > Employees.

Default Cost Rate

You need to set a default cost rate of employees received from QuickBooks Online. By default, the value is taken as 1. You can also change these values later in Core > Employees.

Set bill rate as pay rate multiplier of

Core allows you to set the bill rate of employees received from QuickBooks Online based on a pay rate multiplier. Thus, if pay rate changes in QuickBooks Online, the bill rate can be easily updated in Core.

QuickBooks Items as Expense Codes

Expense items in Core are linked to inventory or non-inventory items in QuickBooks Online. You must select the QuickBooks items from the drop-down that you want to get as expense items. By default, the items that have previously been synced from Core to QuickBooks Online appear disabled or grayed out in the list.

Note: Typically, this has to be done just once; however, you have to revisit this option whenever you add new items in QuickBooks.

Skip getting bills You can check this option if you do not want to get expenses tied to vendor bills as separate expense items.
Ignore payment method Check this option to get all types of purchases from QuickBooks Online irrespective of the payment method used there. It then brings all the purchases, including billable and non-billable expenses, into Core. This option is checked by default when getting expenses from QuickBooks.
Integrations > QuickBooks Sync Detail > Sync Settings > Send >
Ignore last sync date

Core ignores the date when it last synced data with QuickBooks Online for the selected module. The last sync date is used for reference when we want Core to send data since this date.

Do not send purchase tax

When sending expense entries and vendor bills to QuickBooks Online (as vendor bills), you can choose to exclude the purchase tax amount specified in Core. When this option is checked, Core sends the expense costs only and uses the purchase tax rate assigned to the item in QuickBooks for the product and service items. This option is available for Expense Entry and Vendor Bills.

Mapping: Core Employee -QuickBooks Vendor

You can map the Core employees with the corresponding QuickBooks Online vendors so that the correct association is made when sending Core employee expenses to QuickBooks as vendor bills. You can also select a vendor when sending the employee expenses to QuickBooks from the Expense Entries screen.

Send joint invoices as single invoice to QuickBooks

When sending joint/combined or phased invoices to QuickBooks Online, Core creates multiple invoices there with the same invoice number and client, depending on the number of projects or phases on that invoice. However, you can choose to send the joint invoices for non-phased projects as a single record and link it to the client. For joint phased invoices, you can send them as a single invoice too, but you must choose as to what Core should associate it with:

  • Client (customer)
  • Parent Job (immediate parent project)
  • Top Level Job (root parent project)

This option is unchecked by default. 

Map TE memo to QuickBooks description

For time records only: Maps or sends Core time entry memos to QuickBooks Online time entry description.

Transfer Hours

For time records only: Sends actual hours worked to QuickBooks Online instead of billable hours (Client Hours).

Map Reference to QuickBooks reference

For vendor bills only: Maps the Reference Number of vendor bills in Core to the QuickBooks Reference field. Else, it gets mapped to the Bill Number in QuickBooks Online.

If record exists, overwrite?

You can specify the rule for overwriting data in QuickBooks Online when sending it from Core, if that record already exists there. For instance, if both Core and QuickBooks Online have a record for employee John Doe, this rule determines whether upon synchronization that record will be updated or not.

  • Never: Data will not be overwritten in QuickBooks Online. Thus, you will have two versions of that record. For example, if an employee record has a different address in each database, those fields will not be updated upon synchronization.
  • Most Recent: Core compares the last modified date of fields in Core and QuickBooks Online. The more recent one replaces the older data in either databases. For example, if an employee record has a different address in each database, the older fields will be updated upon synchronization.
  • Always: Data will always be overwritten in QuickBooks Online. Thus, you will have one version of that record. For example, if an employee record has a different address in each database, the QuickBooks fields will be updated upon synchronization.
Integrations > QuickBooks Sync Detail > Sync Settings > Accounts > Default >
Default Income Account

Every service item in QuickBooks Online must be assigned to an income account. For detailed invoices having service line items, you can set the default income account and tax code here at the item level. The account selected here is assigned to the Core activity items sent to QuickBooks.

Default Expense Account

Every expense item in QuickBooks Online must be assigned to an expense account. For detailed invoices having expense line items, you can set the default expense account and tax code here at the item level. The account selected here is assigned to the Core expense items sent to QuickBooks.

Default Item Sales Tax Code

QuickBooks Online offers a Sales Tax center for non-regional companies (in countries such as Australia, Canada and UK) that allows them to track and submit sales tax to the concerned tax authority if they have turned on the Sales Tax management option there.

To handle taxes for the vendor bills, expenses and invoices sent to QuickBooks, you can specify the item-level tax code for sales tax here. This tax code applies to the synced activity and expense line items as the item-level sales tax code in QuickBooks.

Note: This option is available only for QuickBooks Online Canada and Australia regional settings and not US regional settings. You can see this if you have turned on the Sales Tax option in QuickBooks Online.

Default Item Purchase Tax Code

To handle taxes for the vendor bills, expenses and invoices sent to QuickBooks, you can specify the item-level tax code for purchase tax here. This tax code applies to the synced activity and expense line items as the item-level purchase tax code in QuickBooks.

Note: This option is available only for QuickBooks Online Canada and Australia regional settings and not US regional settings.

Default Income Account for Services Invoiced

The income account selected here is where the service total of your Core invoices transfer upon synchronization with QuickBooks. For summarized invoices where you are not sending time and expense details, you must specify a default income account for services being billed.

Default Income Account for Expenses Invoiced

The income account selected here is where the expense total of your Core invoices transfer upon synchronization with QuickBooks. For summarized invoices where you are not sending time and expense details, you must specify a default income account for expenses being billed.

Bank Account

You can select a default QuickBooks bank account here that is assigned to all the payments sent from Core to QuickBooks Online on sync. Synced payments directly get deposited in this bank account in QuickBooks.

Do not send MST/MET/Item Taxes as a line item to QuickBooks

You can ignore the main taxes (MST/MET) and item taxes (Tax 1/2/3) as line items when sending the invoices to QuickBooks Online by selecting this option. This makes sure that only services and expenses billed are transferred to QuickBooks and the taxes assigned to the product and service items in QuickBooks are used.

For Canada and Australia regional settings, this option is checked by default.

Skip getting sales tax from QuickBooks

You can choose to ignore the sales tax (MST/MET) associated with invoices when getting them from QuickBooks Online in to Core. This can be used to avoid doubling the tax amount and causing any accounting discrepancy with respect to the invoice amount.

QuickBooks Income Account

Every invoice item in QuickBooks Online must be assigned to an account. For project types where you are not sending time and expense details (summarized invoices), you must specify default QuickBooks income account here for various invoice items. These are the accounts into which the service, expense, tax, retainer , late fee and other income amounts on Core invoices transfer upon synchronization.

QuickBooks Expense Account

Every invoice item in QuickBooks Online must be assigned to an account. For project types where you are not sending time and expense details (summarized invoices), you must specify default QuickBooks expense account here for various invoice items. These are the accounts into which the service, expense, tax, retainer, late fee and other expense amounts on Core invoices transfer upon synchronization.

Integrations > QuickBooks Sync Detail > Sync Settings > Accounts > Project >
Assign To: Project/Project Group

When sending summarized invoices to QuickBooks, Core assigns default accounts to the invoice items. You can override those accounts and assign different G/L accounts to invoice items on a project or project group basis. When assigning accounts for the summarized invoices for the project groups, you should set the selected project group as a default group in Core before syncing invoices to QuickBooks Online. For the selected project or group, each item on a Core invoice like tax, discount, retainers, etc. can have a specific G/L account assigned to it. When you sync invoices with QuickBooks, the corresponding G/L account is updated there.

Note: By default, all projects in Core are a part of the default All Projects group.

 

You can select QuickBooks accounts for each invoice line item at the project level that is transferred from Core to QuickBooks. This way, the correct accounts are posted for every transaction. Tax items should be assigned to liability accounts. Example: Service Tax Amount can be assigned to Sales Tax Payable account and so on.

  • Service Amount: Labor or service amount billed on an invoice. It does not include item taxes (Tax 1/2/3 of time entries) nor the Main Service Tax.
  • Service Tax Amount: Tax charged on the services in the Invoices screen. It is the sum of Tax 1/2/3 for the time entries and excludes Main Service Tax.
  • Expense Amount: The expense amount billed on an invoice. It does not include item taxes (Tax 1/2/3 of expense entries) nor the Main Expense Tax.
  • Expense Tax Amount: Tax charged on the expenses in the Invoices screen. It is the sum of Tax 1/2/3 for the expense entries and excludes Main Expense Tax.
  • Main Service Tax: Main Service Tax is the main tax charged on billed services or labor. It can be assigned at the client or project level but finalized in the Invoices screen.
  • Main Expense Tax: Main Expense Tax is the main tax charged on billed expenses. It can be assigned at the client or project level but finalized in the Invoices screen.
  • Invoice Discount: Discount applied to an invoice in the Invoices screen before processing it. It reduces the final invoice amount after taxes have been added.

  • Retainers Applied/Paid: Total amount of retainer paid by the client and recorded in the Payments screen.

  • Invoice Misc. Amount: Any miscellaneous charges added to the bill amount in the Invoices screen. This applies to the manual invoices only.

  • Invoice Amount Paid: Payment amount received on a manual invoice. It is recorded in the Amount Paid field of the Invoices ( Manual Invoice ) screen.

  • Late Fee: Late fee calculated on the outstanding invoice balance in the Invoices screen.

  • Fixed Fee for Cost Plus: Amount charged as a fixed fee for projects with Cost Plus contracts. It is added to the Net Bill amount in the Invoices screen.

  • Tax Code: When sending service and expense line items on invoices to QuickBooks Online, Core allows you to associate the default tax code to those line items. You can see this option if you have turned on the Sales Tax option in QuickBooks Online.

Integrations > QuickBooks Sync Detail > Sync Settings > Invoices >
Do not send time/expense details... You can choose not to send the time and expense details on invoices for specific project types (contracts). For such summarized invoices, you must specify default QuickBooks income and expense accounts on the Accounts tab for various line items.

 

Synchronization Rules

To ensure accuracy and completeness of data synchronization, Core uses some synchronization rules. Some of these rules might not be relevant for the first-time data synchronization between Core and QuickBooks Online, but are applicable in future.

Company Start Date
Core to QuickBooks QuickBooks to Core
QuickBooks accepts the transfer of transactions only if their dates are after the start date of the QuickBooks company. Syncing of time, expense, invoice, and payment data is possible only if the record dates are after the start date of the company. Thus, when you are syncing data with QuickBooks for the first time, and manually entering invoices or payments from a prior fiscal year, be sure to check the start date of the QuickBooks company to prevent loss of data.  
Date
Core to QuickBooks QuickBooks to Core
  When data is received from QuickBooks Online, the system date is converted to UTC (Coordinated Universal Time) and is recorded in the Last Modified date field for each record.
Placeholders
Core to QuickBooks QuickBooks to Core
  Because QuickBooks does not require or have the same data fields as Core, Core inserts placeholder data in the required fields—FromQuickBooks—when receiving data. As a part of the data checking procedure, you should change ‘FromQuickBooks' to whatever value you want for the field.
Synchronization Order
Core to QuickBooks QuickBooks to Core
When you send or get data using the Send or Get menu, follow the order of the listed items. For example, sync clients before projects and invoices before payments. When you send or get data using the Send or Get menu, follow the order of the listed items. For example, sync clients before projects and invoices before payments.
Accounts
Core to QuickBooks QuickBooks to Core
Core syncs the Bank ( IOLTA ) account as a normal operative bank account to QuickBooks. If you are re-syncing an account from QuickBooks that has trust fund transactions associated with it, Core does not allow updating its account type. However, if there are no transactions associated with it, the account type is changed to 'bank' in Core.
Activity Items
Core to QuickBooks QuickBooks to Core
  For activities or service items, tax rate, minimum hours and billable status do not exist in QuickBooks Online. When getting this data, a placeholder of 0 is kept in Tax Rate and Min Hours fields in Core. By default, service items transferred from QuickBooks to Core are made billable.
Expense Items
Core to QuickBooks QuickBooks to Core
  When you get Other Charge Items (expense) from QuickBooks Online, markup percentage is calculated from Sales and Purchase > Purchase Cost and Sales and Purchase > Purchase Price.
Employees
Core to QuickBooks QuickBooks to Core
You can map Core employees to Core vendors that are linked with QuickBooks Online vendors so as to send the expenses there to become vendor bills. When transferring employee data from QuickBooks, Core checks to see if the optional bill and cost rate fields in QuickBooks contain values. If they do, it transfers them to an employee’s profile. If the fields are blank, Core inserts $0 placeholder value in the Bill Rate and Cost Rate fields in the Employees screen.
Clients
Core to QuickBooks QuickBooks to Core
Client contacts are automatically sent to QuickBooks Online when you sync client records. When customers and customer contacts are transferred from QuickBooks, they are saved as clients and client contacts in Core.
Vendors
Core to QuickBooks QuickBooks to Core
You can map Core employees to Core vendors that are linked with QuickBooks Online vendors so as to send the expenses there to become vendor bills. When vendors are transferred from QuickBooks Online, Core inserts $0 as a placeholder value in the Bill Rate and Cost Rate fields in the vendor records.
Projects
Core to QuickBooks QuickBooks to Core
  Both sub-customers as well as projects sync from QuickBooks Online to Core as projects. There is no need to convert the sub-customers to projects in QuickBooks to get any transactions like invoices or payments recorded against them.
Core-QuickBooks Online sync supports project currency. Clients who have been designated a custom currency in QuickBooks have their project currency in Core mapped to the currency preference in QuickBooks. The setting automatically flows to their invoice templates. Core-QuickBooks Online sync supports project currency. Clients who have been designated a custom currency in QuickBooks have their project currency in Core mapped to the currency preference in QuickBooks. The setting automatically flows to their invoice templates.
  Project data is transferred from QuickBooks only if a customer record is tagged as ‘Is sub-customer’ in its Customer Information screen while time entries are associated with projects only if the ‘Bill this customer’ option is checked there. You can also sync the projects to Core if you maintain project/job records in QuickBooks.
  When sub-jobs or phases are received from QuickBooks, they are saved as project phases in Core.
 

Core bypasses some project rules when getting transaction data like time and expense entries, bills, etc. because it restricts entering data on sync, leading to sync failures. These rules are ignored during sync:

  • Memo is required for time/expense entry

  • Prevent time/expense entry for the project

  • Prevent time/expense entry after reaching allocated hours/units

  • Prevent time and expense entry after reaching contract amount

Time Entries
Core to QuickBooks QuickBooks to Core
When sending time entries to QuickBooks, only basic information like project, activity and hours is sent. The associated taxes can be sent as line items when we send the related invoices.

When time entries are received from QuickBooks, following scenarios are possible:

  • If time entries are against a job, a phase called Legacy is created for this project and then those entries are recorded against it.
  • If time entries are against a customer, a project and phase called Legacy are created and then those entries are recorded against them.
QuickBooks does not support negative time entries, and so these entries do not transfer during synchronization. You cannot sync time entries older than January 1, 1901 in Core. If entries older than this are received in Core, they are saved with the date January 1, 1901.
When time entries are sent to QuickBooks, they cannot be sent again. In other words, changes made to synced time entries are not transferred to QuickBooks. For example, if you send a time entry to QuickBooks (say for 40 hours) and then change it in Core, it cannot be re-sent as it creates duplicate hours. Even if you delete it in QuickBooks, it cannot be re-sent from Core because it has already established a Link ID for it. QuickBooks does not save rates at the time entry level and so the time that comes from there has no bill rate and cost rate. You have an option to set the rates on the Employees screen before you get the time entries to have them use the correct rates. If the rates are project-specific, then assign the fee schedules to the projects and batch update the rates for historical time.
If employees log more than 24 hours in a day (e.g., entering historical entries) in Core, QuickBooks does not accept this and such time entries do not sync. When getting data from QuickBooks, if there is no value for Duration there, a placeholder of 0 is kept in the Client Hours and Actual Hours fields.
You cannot send unapproved time entries to QuickBooks. When getting data from QuickBooks, if Billable has no value there, then True is assigned to the time entry’s Billable flag.
If time entries have been billed prior to sending them to QuickBooks, those entries are not available for billing there. Core bypasses project assignments, DCAA rules and employee control restrictions while getting time entries from QuickBooks into Core.
Expense Entries
Core to QuickBooks QuickBooks to Core
Core receives and sends bills, checks, cash and credit card purchases from and to QuickBooks as expenses, respectively. Core receives and sends bills, checks, cash and credit card purchases from and to QuickBooks as expenses, respectively.
Core can send approved expense entries tied to vendors as bills to QuickBooks Online. There is no mapping needed between these Core vendors and QuickBooks vendors as it is a direct sync. Bills and checks (expenses) can be marked as billable or non-billable and received along with their status from QuickBooks into Core.
Core does not support updating synced expense entries. It can re-send records only if that data is missing in QuickBooks. So you can delete synced expense entries (vendor bills) in QuickBooks and then re-send them from Core, if needed.

When expenses are received from QuickBooks, following scenarios are possible:

  • If expense entries are against a job, a phase called Legacy is created for this project and then those entries are recorded against it.
  • If expense entries are against a customer, a project and phase called Legacy are created and then those entries are recorded against it.
  • If expense entries are against a vendor not assigned to a job, that vendor is assigned to a project on the fly.
  • If expense entries are against a charge item not assigned to a job, a default expense item called FromQuickBooks is used.
If Core expenses are set as 'Reimbursable', they can be sent to QuickBooks from the Expense Entries screen as vendor bills because they are considered as system vendor bills. Here, Core employees have to be mapped to Core vendors who are linked to QuickBooks vendors. When you get expenses from QuickBooks, Core pulls the items from the Expenses tab as well as Items tab of the Enter Bills screen. However, we recommend using the Items tab because Core gets them as 'QBExpense' along with their description. If you use the Expenses tab, they transfer as FromQuickBooks.
You can send multiple expense entries from Core as a single vendor bill to QuickBooks when syncing from the QuickBooks Sync Detail screen using the Send menu. However, this cannot be done from the Expense Entries screen. Checks and credit card charges can be received from QuickBooks as expense entries if they are associated with a job there. If they are not associated with jobs, then Core receives them as vendor bills. If you get QuickBooks credit card credits, they get synced as negative expense entries the same way Core records a negative expense entry when you enter a credit card refund or credit in Core.
When sending expenses to QuickBooks, they do not include the purchase tax by default. You can choose this option under sync settings. Core bypasses project assignments, DCAA rules and employee control restrictions while getting expense entries from QuickBooks into Core.
All approved, un-billed (not tied to vendor bills in Core), reimbursable, and billed expenses tied to employees or vendors sync over to QuickBooks. The approved expenses tied to vendor bills already in Core do not sync over to QuickBooks, In this case, you have to sync the vendor bills directly to QuickBooks.  
Invoices
Core to QuickBooks QuickBooks to Core
Draft and zero value invoices in Core cannot be sent to QuickBooks. This includes the phased invoices. The only exception to transferring a zero value invoice is in case of discounts and retainers. Prior to the first synchronization, all invoices should be moved to the projects in QuickBooks. Syncing invoices directly from the clients can result in complications. Project-level accounts are used for invoices received from QuickBooks.
When sending invoices to QuickBooks, separate line items are created for taxes, service amount, expense amount and late fee. Markup is added to the expense amount. When invoices are transferred from QuickBooks to Core, they are transferred as manual invoices. The related billed time and expense entries are also transferred.
It is not necessary to send time and expense details to QuickBooks in order to send detailed invoices. You can send manual invoices to QuickBooks, whether they have activity or expense items associated with them. Pending invoices in QuickBooks cannot be received in Core.
When invoices are sent to QuickBooks, they transfer with their time and expense details. If you are sending an adjusted time entry (WUD) whose activity has an income account in QuickBooks, the whole amount goes into that account. If you are applying a WUD to the billing record affecting multiple time entries, it will show up on the invoice as an extra line item in QuickBooks with an automatically created service item, GEN:WUD. This happens only when there is a mismatch between the bottom line amount and details of an invoice. In QuickBooks, you can associate invoices and payments directly with clients unlike in Core. In order to get these invoices and payments into Core, they must be linked to jobs, not customers. If not, Core creates new projects on the fly based on the clients and then associate all these transactions to those projects.
When you are sending invoices to QuickBooks with some write-up/down adjustment, Core checks if the project has a class associated with it. If it has, then the same class is assigned to the WUD line item. When receiving invoices from QuickBooks, details like associated items, units, rates and credit payments can also be synced to Core.
When credits applied to invoices are sent to QuickBooks, they transfer as discounts because QuickBooks does not support credit type payment at the invoice level. If a discount is applied to invoices using the ‘Discounts and Credits’ option on the Payment screen in QuickBooks, Core does not sync this payment. We recommend using the Credit Memo option in QuickBooks to discount invoices. Credit memos are received from QuickBooks into Core as invoices with negative amounts so as to balance the accounts. The invoice number is set as CM + Reference Number of the credit memo.
When sending invoices to QuickBooks, Core sets the due date based on the payment terms set for the project. When getting invoices from QuickBooks, sometimes the imported invoice numbers can be the same as that of the voided invoices in Core. In this case, existing invoice numbers of void invoices can be re-used.
For sales transaction lines that do not contain a Tax Code reference, QuickBooks Online treats that line item as if the TaxCodeRef is TAX and determines the taxability of that line based on the item’s taxability. When getting invoices, Core posts the related taxes to MET instead of the expense tax.
When sending joint invoices to QuickBooks, it creates multiple invoices there with same invoice number and client, depending upon the number of projects or phases on the joint invoice . So, overpayments and credits on such invoices can be transferred to Core as project retainers, not client retainers. When getting invoices from QuickBooks Online into Core, the ePayments option is turned on by default for those synced invoices.
When syncing split billing invoices from Core to QuickBooks, they sync as multiple invoices against the clients that are associated with the projects part of the split billing invoice. However, only the time and expense details of the project that has Split Billing enabled in Core are synced; for other projects involved, time and expenses sync as summarized items against the adjustment items 'CoreServiceAmt' and 'CoreExpenseAmt'.  
As with retainer payments, Core syncs 'Accept as Trust Fund' payments as a zero value invoice to QuickBooks against the Core adjustment items 'CoreRetainerChargeItem' and 'CoreRetainerPayment'. Core also syncs the 'Use Trust Fund' payment as a negative invoice line against the adjustment item 'CoreRetainerChargeItem', thus adjusting the invoice amount with respect to the payment amount.  
Retainers
Core to QuickBooks QuickBooks to Core
When sending retainer payments from Core, QuickBooks saves them as client credits in a liability account. When transferring Client Credits from a liability account in QuickBooks, Core saves them as client and project retainers.
Negative payments do not transfer to QuickBooks (retainer refund). You must reduce that amount in Core using a credit memo or directly from the QuickBooks Retainer account. You can issue a refund check from QuickBooks to the client. If you have overpayments in QuickBooks at the job level, Core receives them automatically as project retainers; or at the customer level, as client retainers. You do not need to enter credit payments as retainers manually.
Retainer invoices are not available for record mappings. Retainer invoices are not available for record mappings.
The retainers show up in QuickBooks only if you have applied them to the invoices in Core; otherwise, if you apply the retainers to the projects, they are not sent to QuickBooks.  
Payments
Core to QuickBooks QuickBooks to Core
Payments from Core do not transfer to QuickBooks if the invoices do not exist there. Both debit and credit type payments are synced between Core and QuickBooks. Retainer payments are sent as ‘check’ type by default. Payment write-offs transfer as credits or discounts. Credit transaction gets transferred to Core as a credit memo, not as a payment.
Core does not allow updating of synced payments in QuickBooks. It can re-send records only if that data is missing in QuickBooks. So, you can delete synced payments in QuickBooks and then re-send them from Core. If payments are applied to customers in QuickBooks and then invoices related to jobs are paid, they get transferred to Core as client payments and are associated with the correct project.
When paying invoices in Core using a retainer, Core debits the liability account in QuickBooks. Payments from QuickBooks do not sync if there are no invoices in Core to which those payments are applied.
When sending payment applied to multiple invoices to QuickBooks, they are sent as multiple line items of the main payments. If you receive an overpayment in QuickBooks at the job level, Core receives that payment automatically as a project retainer; or at the customer level, as a client retainer. You do not need to enter overpayments as retainers manually.
Payment refunds cannot be sent to QuickBooks. Project-level accounts are used for payments received from QuickBooks via data integration.
Accept Trust Fund payments that serve as an opening balance for the Trust Fund accounts sync over to QuickBooks as zero value invoices. Use Trust Fund payment syncs over to QuickBooks as invoice line item against the CoreRetainerChargeItem adjustment item. Credit payments in QuickBooks are transferred to Core as retainer payments.
Payments made in Core that are directly deposited into the bank account sync over to QuickBooks as direct deposits (payments hitting the bank account that has been specified at the Core payment level instead of the Un-Deposited Funds account).

Payments associated with clients as well as jobs in QuickBooks are synced to Core.

 

Vendor Bills
Core to QuickBooks QuickBooks to Core
You can map Core employees to Core vendors that are linked with QuickBooks Online vendors so as to send the expenses there to become vendor bills. Only job-related line items on a vendor bill are transferred from QuickBooks into Core.
Core does not support updating synced vendor bills. It can re-send records only if that data is missing in QuickBooks Online. So, you can delete synced vendor bills in QuickBooks and then re-send them from Core. You can edit vendor bills in QuickBooks and transfer them again to Core, The date associated with the line items is not changed.
When sending vendor bills and expenses to QuickBooks, they do not include the purchase tax by default. You can choose this option under sync settings. If the line items of a vendor bill do not have any value, then the Expense Description is used from the Expense table. If Expense Description is also not present or if the expense does not exist in Core, then Payee Name is used for the description. If Payee Name is not present, then FromQuickBooks is assigned as a placeholder for the description.
While syncing vendor bills and expenses from Core to QuickBooks, if you change the Tax Code value at the QuickBooks item level and have a different Tax Code set in Core sync settings, the preference is always given to the tax code set in QuickBooks. Core bypasses project assignments, DCAA rules and employee control restrictions while getting purchase orders and vendor bills from QuickBooks into Core.

Connect with QuickBooks Online

Core allows you to sync your data with your QuickBooks Online database by adding that software. You can then connect to your QuickBooks Online data file. The authentication and company selection process is handled by Intuit but Core provides the synchronization feature to initiate the data transfer.

To add QuickBooks Online in Core, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

    1. On the Integrated Products tab, select your accounting software, QuickBooks, from the list and click to connect with it.

    2. Core tries to connect to your QuickBooks database and prompts you to sign in. When the information is verified, Core establishes a connection with your QuickBooks Online account.

    1. You are prompted to select the company database and also authorize the sharing of data between the two programs. Click Authorize.

 

 

On the QuickBooks Sync Detail screen, you can first set your synchronization rules, and then start syncing data with QuickBooks Online.

Specify Sync Settings

Core provides you the ability to sync your data with QuickBooks Online. But before doing that, you must review and set the synchronization rules and settings for a smooth and accurate data integration. Before specifying the sync settings, read the above section on Synchronization Rules.

To specify your sync settings for QuickBooks Online, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

 

    1. On the Integrated Products tab, click QuickBooks on the grid (if you are already connected to the company file; else you have to add the software and log in).

    2. On the QuickBooks Sync Detail screen, go to the Sync Settings > Send tab to select the default settings for sending data. Check Field Descriptions above for details.

    1. Next, go to the Get tab to select the default settings for getting data. You can also assign accounts to various items being synced. Check Field Descriptions above for details.

    2. Click Save Settings.

Sync Data with QuickBooks Online

Core allows you to sync your data with QuickBooks Online. After specifying the synchronization settings, you can start the process of syncing data one module at a time in the given order (in the Get or Send menu). The Get > All Items option should not be used unless the data between the two has been mapped beforehand. It is especially not recommended for large amount of data.

To sync your Core data with QuickBooks Online, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

 

    1. On the Integrated Products tab, click QuickBooks on the grid (if you are already connected to the company file, else you have to add the software and log in).

    2. On the QuickBooks Sync Detail screen, click on the Get or Send menu, depending on whether you want to get data from QuickBooks or send data to QuickBooks.

 

    1. On the drop-down menu, click the data you want to get or send, say Activity. It is best to follow the order of the menu for syncing data. Check Field Descriptions above for details.

Assign Accounts for Data Sync

QuickBooks Online requires accounts for every item and transaction. Before syncing your data with QuickBooks Online, you must specify the default General Ledger accounts for the service, expense and invoice items in Core. Normally, the transactions debit or credit these accounts. You can assign accounts at the item, project and invoice level. It is preferable to create service and expense items in QuickBooks and get them into Core. This reduces the step of creating or assigning G/L accounts for them in Core. You can delete the Chart of Accounts in Core and replace it with the QuickBooks accounts by syncing them over from QuickBooks Online first. Similarly, you should also get the QuickBooks class list into Core and then assign both accounts and classes to items. Doing this ensures that all the items are correctly mapped to the correct income and expense accounts as well as classes.

Tax items (such as Service Tax, Expense Tax, MST, MET) should be assigned to liability accounts. For example, Service Tax Amount can be assigned to the Sales Tax Payable account and so on. If you leave this blank, default accounts specified at the item level are used and these items are tagged as 'service' type. Associating tax items to service items has two flaws:

      • It treats the tax revenue as income, which is incorrect.
      • What you owe to the tax agency does not show up in your Sales Tax Liability report in QuickBooks.

To avoid these flaws, we highly recommend that you assign proper liability accounts to these tax items in Core before sending data to QuickBooks Online.

Note: You can assign accounts to individual service and expense items from their respective screens in Core. The item-level accounts get precedence over the global default accounts.

To specify accounts for Core items to be synced to QuickBooks, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

 

    1. On the Integrated Products tab, click QuickBooks on the grid (if you are already connected to the company file; else you have to add the software and log in).

    2. On the QuickBooks Sync Detail screen, go to the Sync Settings > Accounts > Default tab.

 

    1. Select the default QuickBooks income accounts for your activity and expense items. Check Field Descriptions above for details.

      • Default Income Account

      • Default Expense Account

    2. If you prefer sending summarized invoices, select the default QuickBooks income accounts for them. Check Field Descriptions above for details.

      • Default Income Account for Services Invoiced

      • Default Income Account for Expenses Invoiced

Note: If you are using 'Make Expenses and Items Billable' feature of QuickBooks Online, we recommend that you use one of the following account types: expense, other expense, other current liabilities, other current assets, other assets, fixed assets, or COGS when specifying an account for expense items. QuickBooks Online does not allow billable expenses that uses account types other than the ones mentioned above.

    1. Non-regional companies (in countries such as Australia, Canada and UK) that want to track sales tax can set their default tax codes for service and expense line items on invoices. You can see these tax codes if you have turned on the Sales Tax option in QuickBooks Online.

    1. Then select the default QuickBooks income and expense accounts for invoice line items. This applies to the project types for which you are not sending any time and expense details (summarized invoices).

    2. Click Save Settings.

    3. Next, go to the Accounts > Project tab.

    4. You can override the default accounts set above by assigning different G/L accounts to invoice items on a project level. Select a Project or a Project Group from the drop-down lists. Check Field Descriptions above for details.

    5. For the selected project or group, select an account and assign it to invoice items like tax, discount, retainers, etc.  
      Note: If you assign accounts to a project group (say the default All group), you do not have to go back to the Sync Settings every time you add a new project to that group. Core automatically assigns these settings to the new project in that group.

    6. When you have finished, click Save Settings.

    7. Finally, go to the Invoices tab and select the invoice types (contract types) for which you do not want to send time and expense details. When you have finished, click Save Settings again. Check Field Descriptions above for details.

Get Data from QuickBooks Online

QuickBooks users who are new to Core should start by transferring their existing data to a new Core database. After creating your Core company and specifying settings, you can get your QuickBooks data into Core using the Integrations feature and then verify the transferred data. As a best practice, you should delete the Chart of Accounts in Core and then get the Chart of Accounts from QuickBooks Online. This ensures that the activity and expense items synced are properly mapped to the QuickBooks accounts. The Get > All Items option should not be used unless the data between the two has been mapped beforehand. It is especially not recommended for large amount of data.   

To get your QuickBooks Online data into Core, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

 

    1. On the Integrated Products tab, click QuickBooks on the grid (if you are already connected to the company file, else you have to add the software first and log in).

    2. On the QuickBooks Sync Detail screen, go to the Sync Settings > Get tab and specify your sync preferences for getting data, especially the date filters. 

    1. Click Save Settings.

    2. Then go to the Get menu and click the data you want to get, say Activity. It is best to follow the order of the menu for syncing data.

Note: We recommend that you do not get the time and expense entries from QuickBooks that are already invoiced. Use the date filters on Sync Settings to get only entries that have not been invoiced yet.

Send Data to QuickBooks Online

Core allows you to send your data to QuickBooks Online using the Integrations feature and then verify the transferred data. After setting the synchronization preferences in Core, you can send your data to QuickBooks and then verify the transferred data.  

To send your Core data to QuickBooks Online, watch this video or follow these steps:

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

    1. On the Integrated Products tab, click QuickBooks on the grid (if you are already connected to the company file, else you have to add the software first and log in).

    2. On the QuickBooks Sync Detail screen, go to the Sync Settings > Send tab and specify your sync preferences for sending data, especially the date filters. Check Field Descriptions above for details.

    1. Click Save Settings.

    2. Then go to the Send menu and click the data you want to send, say Activity. It is best to follow the order of the menu for syncing data.

Map Records

After syncing your data between the Core and QuickBooks Online databases, you can view the mapped records as well as the unmapped records. You have an option to un-match the mapped records if they are not correctly matched in both databases. Similarly, you can match the un-mapped records, if needed.

 

Note: Groups are not included under this smart match feature.

 

To map the records between QuickBooks Online and Core, watch this video or follow these steps:

 

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

  1.  

    1. On the Integrated Products tab, click QuickBooks Online on the grid if you are already connected to the company file (else you have to add the software and log in).

    2. On the QuickBooks Sync Detail screen, go to the Record Mappings tab.

 

  1. Choose an option from the 'I want to map' drop-down and then review the un-mapped records of that module on the Unmapped Records tab.

  2. Select the records on both sides of the grid that you want to map and click Map Selected.

 

After your confirmation, these records disappear from the Unmapped Records grid and appear on the Mapped Records grid.


Un-Map Records

After syncing your data between the Core and QuickBooks Online databases, you can view the mapped records as well as the unmapped records. You have an option to un-match the mapped records if they are not correctly matched in both databases. Similarly, you can match the un-mapped records, if needed.

 

Note: Groups are not included under this smart match feature.

 

To un-map the records between QuickBooks Online and Core, watch this video or follow these steps:

 

    1. Open the Integrations screen from the side menu > Productivity Tools > Integrations.

  1.  

    1. On the Integrated Products tab, click QuickBooks Online on the grid if you are already connected to the company file (else you have to add the software and log in).

    2. On the QuickBooks Sync Detail screen, go to the Record Mappings tab.

     

  2.  

    1. Choose an option from the 'I want to map' drop-down and then review the mapped records of that module on the Mapped Records tab.

    2. Select all the records on the grid that you want to un-map and click Remove Mapping.

     

  3. After your confirmation, these records disappear from the Mapped Records grid and appear on the Unmapped Records grid.

  4.  

Verify Synced Data

You should verify the transferred data in Core and QuickBooks Online after the synchronization process. This ensures that your information is accurate and complete before you begin normal processing. Data adjustments are needed especially in Core after getting data from QuickBooks because it requires certain fields that might be optional in QuickBooks. You can verify the accuracy of data either by running reports or checking screens in detail.

Make sure to check the following data:

    • General: Check the names or IDs of records (e.g., employees or projects) transferred from QuickBooks. You can change them or replace the placeholders with actual data.

    • Employees: When you get employees from QuickBooks, make sure to check their profile, bill and cost rates, and security settings in Core. Before entering time, review each employee record in Core to make sure the Bill Rate and Cost Rate is correct. In addition, if special bill rates (and special cost rates) apply to work done by employees on a project, be sure to define an appropriate fee schedule and assign it to related projects before entering time. Core uses these rates to calculate the bill amount and cost amount of time.

    • Vendors: If you enter time for vendors in Core, be sure to change the Bill Rate and Cost Rate in their profile. When you get vendors from QuickBooks, Core inserts a $0 placeholder value in their records.

    • Clients

    • Projects: Alt. Contact in QuickBooks corresponds to Project Manager in Core. If alternate contact is not specified in QuickBooks, Core fills a placeholder FromQuickBooks in the Manager field. Change that to the appropriate names. You must assign a manager to all projects in Core.

    • Activity and Expense Items

    • Time Entries: When you get time entries from QuickBooks, make sure to update the bill and cost rates in Core because QuickBooks does not require them. If special bill and cost rates apply to projects, make sure to define fee schedules and assign them to projects before entering time.

    • Expense Entries: When you get expense entries from QuickBooks, make sure to update the cost rates in Core because QuickBooks does not require them. If special cost rates apply to projects, make sure to define fee schedules and assign them to projects before entering expenses.

    • Invoices

    • Payments

    • Accounts: Compare Core and QuickBooks accounts and aging reports. If the data is the same, your integration is successful. If it is not the same, the cause could be a journal entry that adjusted A/R or A/P. Or a record that did not transfer. The solution is usually making a manual adjustment in Core.

After checking the data, you can change your sync settings to suit day-to-day synchronization, if you plan to do so.

Was this article helpful?
0 out of 0 found this helpful