Editing Default Export to QuickBooks Settings
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
If you are syncing SME with QuickBooks, choose which forms in SME export to QuickBooks by default. | If you are syncing SME with QuickBooks, choose which forms in SME export to QuickBooks by default. | ||
− | [[File: | + | [[File:DefaultExportOptions.png]] |
Line 13: | Line 13: | ||
'''Default Export New Proposals''' - If checked, new proposals entered in SME will export to QuickBooks as an estimate. | '''Default Export New Proposals''' - If checked, new proposals entered in SME will export to QuickBooks as an estimate. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
== Export Options for Purchase Orders == | == Export Options for Purchase Orders == | ||
− | + | <videoflash>9K5J9KmqIUs</videoflash><br> | |
Check one of the next two options for how SME exports purchase orders to QuickBooks: | Check one of the next two options for how SME exports purchase orders to QuickBooks: | ||
Line 31: | Line 26: | ||
<br>'''-OR-''' | <br>'''-OR-''' | ||
− | <br>'''Default Export Bills for New POs''' – If checked, when material is received on POs in SME, SME will export a bill to QuickBooks what you owe the vendor for the part received | + | <br>'''Default Export Bills for New POs''' – If checked, when material is received on POs in SME, SME will export a bill to QuickBooks what you owe the vendor for the part received. This is usually checked. |
Line 47: | Line 42: | ||
<br>8. '''Export Purchase Orders & Bills''' – check here if you chose to default purchase orders and bills for SME purchase orders. This is uncommon. | <br>8. '''Export Purchase Orders & Bills''' – check here if you chose to default purchase orders and bills for SME purchase orders. This is uncommon. | ||
<br>9. Click '''Save''' at the bottom. | <br>9. Click '''Save''' at the bottom. | ||
− | |||
− | |||
== Export Options for Subcontractors == | == Export Options for Subcontractors == | ||
Line 56: | Line 49: | ||
[[File:SubContractorOnServiceItem.jpg]] | [[File:SubContractorOnServiceItem.jpg]] | ||
− | <u>Choose | + | <u>Choose the following three options :</u> |
− | [[File: | + | [[File:DefaultExportOptions_Subcontractors.png]] |
+ | |||
+ | '''1''' - '''Send Bill for Subcontractor Cost when you invoice the order''' | ||
+ | <br>In SME, check '''Default Export Subcontractor Bills on Invoice'''. | ||
+ | <br>In SQLink, click '''File''' > '''Setup''' > '''Invoice/Proposal Options tab''', check '''Export Bills for Subcontractor''' | ||
− | |||
− | |||
− | |||
<br>When the order is invoiced and the invoice is synced to QuickBooks, the bill is generated in QuickBooks. A bill will also be generated if you create a new itemized invoice in SME, a bill will be generated in QuickBooks. (image below) | <br>When the order is invoiced and the invoice is synced to QuickBooks, the bill is generated in QuickBooks. A bill will also be generated if you create a new itemized invoice in SME, a bill will be generated in QuickBooks. (image below) | ||
+ | [[File:SubcontractorBill.jpg]] | ||
− | + | '''2''' - '''Send PO for Subcontractor Cost when you invoice the order''' | |
+ | <br>In SME, check '''Default Export Subcontractor POs on Invoice'''. | ||
+ | <br>In SQLink, click '''File''' > '''Setup''' > '''Invoice/Proposal Options tab''', check '''Export Purchase Orders for Subcontractor''' | ||
− | |||
− | |||
− | |||
<br>This option is used by companies that have subcontractors on many service orders. Rather than generating separate bills for every order, they export purchase orders to QuickBooks. In QuickBooks, they can then add the purchase orders to one bill to pay subcontractor. The PO will be generated when you sync the ''invoice'' for the service order to QuickBooks. | <br>This option is used by companies that have subcontractors on many service orders. Rather than generating separate bills for every order, they export purchase orders to QuickBooks. In QuickBooks, they can then add the purchase orders to one bill to pay subcontractor. The PO will be generated when you sync the ''invoice'' for the service order to QuickBooks. | ||
− | + | '''3''' - '''Send Bill for Subcontractor Cost when you close the order''' | |
− | |||
If you prefer to send the subcontractor bill to QuickBooks when you ''close'' the order instead of sending over with the invoice, then make sure you check the following: | If you prefer to send the subcontractor bill to QuickBooks when you ''close'' the order instead of sending over with the invoice, then make sure you check the following: | ||
<br>- In SME, '''Setup''' module > '''Order''', check '''Default Export Bills for Closed''' | <br>- In SME, '''Setup''' module > '''Order''', check '''Default Export Bills for Closed''' | ||
− | <br>- In SQLink, click '''File''' > '''Setup''', check '''Export Bills for Closed Orders''' (circled in image below | + | <br>- In SQLink, click '''File''' > '''Setup''', check '''Export Bills for Closed Orders''' (circled in image below) |
− | <br> | + | <br>[[File:ExportBillsForClosedOrders.png]] |
+ | |||
+ | <h3>Related SQLink Setup</h3> | ||
[[File:SQLink_SubcontractorSettings.png]] | [[File:SQLink_SubcontractorSettings.png]] | ||
+ | |||
+ | <br>1. Open SQLink. | ||
+ | <br>2. Click '''File''' > '''Setup'''. | ||
+ | <br>3. Click '''Edit''' at the bottom. | ||
+ | |||
+ | <br>4. If you are exporting Bills for Subcontractors: | ||
+ | <br> * On the Import/Export Options tab, check '''Export Bills for Closed Orders'''. | ||
+ | <br> * Click the Invoice/Proposal Options tab. | ||
+ | <br> * Check '''Export Bills for Subcontractors'''. | ||
+ | <br> * Click '''Save''' at the bottom of SQLink. | ||
+ | |||
+ | <br>5. If you are exporting POs for Subcontractors: | ||
+ | <br> * Click the Invoice/Proposal Options tab. | ||
+ | <br> * Check '''Export Purchase Orders for Subcontractors'''. | ||
+ | <br> * Click '''Save''' at the bottom of SQLink. | ||
+ | |||
<h3>Subcontractors on Labor Items</h3> | <h3>Subcontractors on Labor Items</h3> | ||
Line 89: | Line 100: | ||
<br>4. Click '''Edit''' at the bottom | <br>4. Click '''Edit''' at the bottom | ||
<br>5. Check '''Include Labor Records on Subcontractor Bills and POs''' | <br>5. Check '''Include Labor Records on Subcontractor Bills and POs''' | ||
− | <br>6. Click '''Save'''. | + | <br>6. Click '''Save'''. |
+ | |||
== Export Options for Inventory Items == | == Export Options for Inventory Items == | ||
Inventory is managed in one of two ways when SME is syncing with QuickBooks: | Inventory is managed in one of two ways when SME is syncing with QuickBooks: | ||
− | <br>· '''As SME Only Inventory''' – | + | <br>· '''As SME Only Inventory''' – Items are maintained in SME and inventory Cost of Goods, Inventory Asset, and Sales Income accounts are passed through SMP_Item. (After your initial sync with QuickBooks, you will see '''SMP_Item''' in your QuickBooks Item List. Set the income, sales, and COGS account on the SMP_Item) |
<br>· '''As SME and QuickBooks Inventory''' – inventory items are synced and are maintained in both applications. Invoicing for material in SME decreases stock in QuickBooks. Creating Purchase Orders for material in SME increase stock in QuickBooks. Manually changing stock numbers will have to be done in both SME using [[Inventory Quantity Reconciliation]] and also in QuickBooks. | <br>· '''As SME and QuickBooks Inventory''' – inventory items are synced and are maintained in both applications. Invoicing for material in SME decreases stock in QuickBooks. Creating Purchase Orders for material in SME increase stock in QuickBooks. Manually changing stock numbers will have to be done in both SME using [[Inventory Quantity Reconciliation]] and also in QuickBooks. | ||
Line 107: | Line 119: | ||
<br>[[File:InventoryItemFields SyncToQB.png]] | <br>[[File:InventoryItemFields SyncToQB.png]] | ||
− | Individual inventory items can be setup with accounts other than those set as defaults in SQLink. | + | Individual inventory items can be setup up with accounts other than those set as defaults in SQLink. |
<br>1. Open SME. | <br>1. Open SME. | ||
<br>2. Go to the '''Inventory''' module > '''Inventory'''. | <br>2. Go to the '''Inventory''' module > '''Inventory'''. |