SQLink Settings

From High5Wiki
Jump to: navigation, search

Import/Export Options tab

On Import section

Importing from QuickBooks to SME
ImportExportOptionsTab1.png


Merge unmatched invoices and payments - When you do an initial import there may be payments that are not attached to invoices – this brings them in and it should always be set
Skip inactive customers on import/export - Skips inactive QB customers on import
Don’t update next invoice number - Read the Invoice Numbers in SME and QuickBooks page for more information.
Export bills for closed orders - If checked, when an order is closed, a bill will be created in QB for subcontractor costs on labor and service items. Also have to have “default export bills for closed orders” in SME.
Import/Export Proposals - If checked, proposals will sync from QB to SME
Use Markup on Export - This is a Proposal related setting – calculates the proposal on markup from QB
Billing Name Options - http://high5software.com/mediawiki/index.php?title=SQLink#SQLink_Billing_Name_Options

Initialize employee Wage Information - If checked it will not import any wage info into SME from QB
Do not import or export inventory - Inventory will not sync between SME & QuickBooks
Set inventory cost/price - If this setting is checked, if you edit the cost or price of an inventory item in QB, the inventory item cost and price will be updated in SME. If unchecked the cost / price changes made in QB will not update SME inventory item.
Auto Process Timer - http://high5software.com/mediawiki/index.php?title=SQLink#Auto_Process_Timer

On Export section

Exporting from SME to QuickBooks
OnExportSection.png
Transfer Tech Time / Replace Tech time Records on Change
http://high5software.com/mediawiki/index.php?title=SQLink#Tech_Time_.28syncing_time_sheets_to_QB.29


Include SMP Items on Purchase Orders - Set this to transfer info to PO’s for items not in QB, either because you do SME only inventory, or some items have not made it to QB and are on a PO
Export all uninitialized customers - Works with the SME setting and if unchecked, it will only sends Billing customers to QuickBooks.
Use general ledger entries for Default Material Item - This setting is recommended to be checked if you keep your inventory items in SME only, not in both SME and QuickBooks. See the GL Entries for SME Inventory page for details.


Purchase Order Options section
If you are creating Purchase Orders in SME, you need to decide how your SME POs are going to sync with QuickBooks. You have the following options: 

- Create PO in SME and SME will send the same PO to QuickBooks on the next sync. You would have to receive stock on both POs.

- Create PO in SME, receive items on the PO in SME, on next sync SME will put a bill in QB for the items received. The bill will increase the stock in QB. 

- Create PO in SME and send both the PO and the Bill in QuickBooks.




Click this link for details on setup in both SQLink and SME:
http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Purchase_Orders


Initialize PO Bill Date to from Received Item: - If checked, the date on the bill that goes to QB will be the date you received the item, not the PO date. 

Initialize by PO Item - Sets the date on the Bill in QB to the line item receipt date from the SME PO

Invoice/Proposal Options tab

Taxable Code - Set the tax code taxable items on SME invoices will be assigned to when the invoice is synced to QB
Non-Taxable Code- Set the non-taxable code non-taxable items on SME invoices will be assigned to when the invoice is synced to QB
TaxableNontaxableCode.png
TaxCodeOnQBInvoice.png

Summarized Labor, Material, Service Line Item

If you check Summarize Labor into One Line Item, then there will only be one line on your QB invoice for all labor on the SME invoice. The Description will say Labor Summary Line Item and the income will pass through the item selected in the Summarized Labor Line Item field.


Image 1 below shows SQLink set to summarize both Labor and Material.
Image 2 below shows an SME Invoice with 2 Material Items and 2 Labor Items.
Image 3 below shows the invoice in QB with the Material and Labor items summarized.


SummarizeLaborLIneItem.png
SummarizedLaborImage2.png

Default Labor, Material, Service Line Item

This is where you will select your default pass through items for Labor, Materials and Services. They will be defaulted to SMP_Labor, SMP_Item and SMP_Service. You can choose a different item if you would like, but for the Material Line Item make sure you choose a non-inventory item.
These items will be used in the following types of scenarios:
- If an inventory item isn’t in QB, then when item is invoiced the income will pass through the Default Material Line Item.
- If you are invoicing labor and you didn’t choose a service item in the labor editor, the income for labor will pass through the Default Labor Line item in QB.
- If a service item isn’t in QB, then when the item is invoiced, the income will pass through the Default Service Line Item.
- If you are using Fix Rate invoices, the labor, material and services will pass through these items by default.


Default Labor Line Item-
Go to QB and open the SMP_Labor item from your item list and set the income account and if you don’t tax labor, change the tax code to non. You will also need to mark SMP_Labor as non-taxable in SME if you don’t charge tax on labor. In SME > Inventory Module > Services, search for SMP_Labor and check non-taxable.


Default Material Line Item -
Go to QB and open the SMP_Item and set the income account.
NOTE - If you want to change to use a different item, make sure you select another non-inventory item. Inventory items are not supported.


Default Service Line Item -
Go to QB and open the SMP_Service in the QB Item List and set the income account
If you don’t charge tax on services, set SMP_Service to the tax code of Non. You will also need to go set the item in SME as non-taxable. Go to SME > Inventory module > Services and search for SMP_Service. Check non-taxable.

Line Item Order

You can choose the order that labor, material and service items show on the invoice in QB.
LineItemOrder SQLin.png

Other Options

OtherInvoiceProposalOptionsTab.png


Show Services Requested - If checked, the Services Requested will show on the QB invoices
Show Services Performed - If checked, the Services Performed will show on the QB invoice
Export Purchase Orders for Subcontractors - Check this if you selected Default Export Subcontractor PO on Invoices in SME Setup
Use Invoice Reference Number - if checked will use ref number instead of invoice number.
Default Export Bills for Subcontractors - Check this if you selected Default Export Subcontractor Bills on Invoices.
Use Invoice Reference Number - if checked will use ref number instead of invoice number.
Include labor records on SubContractor Bills and POs - If you are setting SME to send bills or POs to QB for subs, then with this settings checked it allows subcontractors scheduled on Labor to go to QB as a bill or PO. Without this checked, it only sends bills or POs for subs selected on a service item.
Mark Invoices as ‘To Be Printed’ in QB - if checked, the invoices that syncs to QB will have To be printed checked
Use invoice/proposal number for QB P.O. Number' on invoice - If checked, it will sync the invoice number to the PO Number field on the QuickBooks invoice. If unchecked, the PO number on SME Invoice will sync to PO Number field on the QB Invoice. Also used for Proposal number on proposals.
Show Technician Name in Labor Line Item - If checked the technicians name will show on the labor line in QB. Uncheck and it won’t show the tech name.
Ignore SME Billing Address - If this is checked and you change the address on the billing tab on an invoice in SME, the invoice will sync to QuickBooks with the billing address on the customer record, not the billing address changed on the invoice. If unchecked, if you change the address on a SME Invoice, the invoice will go to QB with the edited billing address.

Service Location

This setting drives where the “services requested” and “services performed” description show on the QuickBooks invoice.


ShowServiceAtTop.png


ShowAtBottom service.png

Payments and Credits tab

Charge Buckets

The Charge Buckets are related to fields on the Totals tab on an invoice in SME.
PaymentCreditTab ChargeBuckets.png


Here is the Totals tab on an invoice in SME. The fields circled are related to the Charge Buckets in SQLink. If there is a charge in any of these fields on the totals tab, the income will pass through the related Charge Bucket in QuickBooks shown in the invoice image below.
ChargeBucketsOnTotalsTab.png


The above SME invoice had a charge in the Premium, Trip Charge, Other Charges, and Freight fields. On the invoice that synced to QB from SME, you will see the charges pass through the items set in the related charge buckets.
QBInvoice ChargeBuckets.png


You will need to make sure you set the income account on all or the items set in your charge buckets. Also, if the charge isn’t taxable, make sure you change the item to non-taxable. (image below)


BucketITemsInQB SetAccounts.png

Credit Buckets

SQLink CreditBuckets.png


Prepaid Used Bucket - If you are using Prepaid Services or labor, the amount of prepaid used on an order or invoice will go into the Prepaid Used field on the Totals tab (image below) and sync to QuickBooks through the item selected in the Prepaid Used Bucket.
PrepaidUsed TotalsTab.png
Invoice sent to QuickBooks shows the prepaid amount used, passing through the Prepaid Used Bucket item, circled in image below.
SMP Prepaidbucket.png
In QuickBooks, go to your Item List (Lists > Item List) and select SMP_Prepaid. Set the income account on the item and the Tax Code to determine if the discount is applied before or after sales tax.
SMP Prepaid QuickBooks.png


Discount Bucket - If you apply a discount on an invoice, you will see the amount in the Discount field on the Totals tab (circled in image below)
InvoiceTotalTab DiscountField.png
The invoice sent to QuickBooks shows the discount amount passing through the Discount Bucket item. (image below)
DiscountBucketOnQBInvoice.png
In QuickBooks, go to your Item List (Lists > Item list) and select the SMP_Discount Item. Choose the tax code to determine if the discount is applied before or after tax. Also set the income account.
SMP DiscountInItemList.png


Credit Bucket - If you create a credit to a SME Invoice, the credit will pass through the Credit Bucket when the invoice syncs to QuickBooks (circled in image below). An example of when a credit could be applied to an invoice is returning material from customer and creating a credit invoice
CreditOnQBInvoice SMP Credit.png
In QuickBooks, go to your Item List (Lists > Item list) and select the SMP_Credit Item. Set the income account.
SetAccountOnSMP Credit.png

Classes and Accounts Options tab

ClassesAndAccountOptionsTab SQLink.png

Classes Section

Labor Class - If you have a class assigned to a labor item in SME and the class isn't in QB, the the class used on the labor item in QB is the default item selected in this field.
Material Class - If you have a class assigned to a material item in SME and the class isn't in QB, the the class used on the material item in QB is the default item selected in this field.
Services Class - If you have a class assigned to a service item in SME and the class isn't in QB, the the class used on the service item in QB is the default item selected in this field.

Miscellaneous Accounts section

Time Tracking Service Item - This default service item is related to transferring tech time (time sheets) to QB for labor in SME. If you enter a labor item in SME without a service item or with a service item that isn't in QuickBooks, then the service item used on the timesheet entry will be the item selected in this field.
SMP Tax Code - Should leave this as SMP_Tax.
If you are using QuickBooks Canadian Version, you must manually create an item in QuickBooks for SMP_Tax. Do a full sync between SME & QB. Then assign SMP_Tax in the SMP_Tax Code field.

Wage Items section

Default Pay Wage Item- If your pay wage item on the labor item is only in SME, then the timesheet that exports to QB will use the Default Pay Wage Item.

Accounts section

Default Accounts Receivable Account - When invoices are exported from SME to QB, the invoice will have this account receivable account on them.
Default Payment Deposit Account - When a payment is sent form SME to QB, it will use this deposit account.
Default Inventory Asset Account - If the Use general ledger entries for default material setting is set, then when the Bill for PO is sent from SME to QB, the GL transaction will be made to this asset account. See the GL Entries for SME Inventory page.
Default COGS Account - If the Use general ledger entries for default material setting is set, then when the invoice form material is sent to QB, the GL transaction will be made to this COGS account. See the GL Entries for SME Inventory page for more info.
Default Service Expense Account - Select your default expense account
Default Sales Income Account - Select your default income account