====== Exporting to Quickbooks Desktop Software Using The Quickbooks Link Overview ======

~~CONTEXTID:491~~

~~OLDHREF:qbdesktopoverview.html~~

Here is the video that covers this content:

[[quickbookslink:newtopic17:qbdesktopvid|How To Use The Quickbooks Link To Export To Quickbooks Desktop]]

For more information on how transactions are brought over into **Quickbooks**, please view the following video:

[[quickbookslink:newtopic17:qbtransactionsvid|How Transactions Flow From Quickbooks Link to Quickbooks]]

===== Opening The Quickbooks Link =====

To begin your first **Quickbooks** export, open up the **Quickbooks** link and enter in your serial number if you have not already done so.

  - **Open** the **Liberty REACT Inventory Module** and then click the **QB Link** icon. \\ {{libertyreact:lib:newitem1189.png|NewItem1189.png}}
  - If this is the first time you have ever opened the **QB Link**, you will be prompted to enter in your serial number.  If you do not have the serial number, please contact Resaleworld at 1-800-785-4800

===== Company File Selection and GL Account Settings =====

You will need to select which **Quickbooks** solution (**Quickbooks Desktop Software or Quickbooks Online**) you will want to use.  It is best to consult with a certified public accountant (**CPA**), if you are unsure which option is right for you.

  - With the **Quickbooks** Link open, click the **File** menu at the top left corner and select **Settings**. \\ {{libertyreact:lib:newitem1188.png|NewItem1188.png}}
  - Select the **General** tab on the left, then select the radio button next to either **Desktop** if it is not already selected. \\ Next click the **Browse Folder** button. \\ {{libertyreact:lib:newitem1187.png|NewItem1187.png}}
  - Search for the company file you wish to work with and click **Open**. \\ Note: In most cases the company file will be located at: C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\ \\ {{libertyreact:lib:newitem1186.png|NewItem1186.png}}
  - If you receive the following message, click the **OK** button and close your **Intuit Quickbooks** program, then click **Open** again. \\ {{libertyreact:lib:newitem1185.png|NewItem1185.png}}
  - Click on the **Advanced** Tab. \\ From here you can edit the Liberty specific GL account names that get inputted automatically when Liberty syncs. \\ You can also select whether you want to separate consignors as vendors in **Quickbooks**. \\ {{libertyreact:lib:newitem1184.png|NewItem1184.png}}
    * **Consignment Payable**: \\ This is an Accounts Payable **General** Ledger account that maintains all of the consignor obligation owed to consignors.  When a check is written, the total consignor obligation owed will decrease from this account.
    * **Consignment Non-Payable**: \\ This is a sub-account of the consignment payable general ledger account. This account maintains all of the non-payable obligation owed to all of your consignors.  When a consignor’s store credit is used towards a purchase, the value maintained within this sub-account will decrease.
    * **Item Fee**: \\ This account maintains the total item fee dollar value you have received when items sell with an item fee.
    * **Web Surcharge**:

This account tracks any fees you have collected

===== Setting Up Your Quickbooks Company File =====

  - **Open** the **Quickbooks** application and select your **Company File** if **Quickbooks** does not automatically open it. \\ {{libertyreact:lib:newitem1183.png|NewItem1183.png}}
  - Click the **Edit** menu option and then click **Preferences**... \\ {{libertyreact:lib:newitem1182.png|NewItem1182.png}}
  - Click on the **Accounting** option to the left, then click on **Company Preferences**.
Make sure that **Use account numbers, Require accounts** and **Use class tracking** are all checkmarked.

Then Click the **OK** button.

{{libertyreact:lib:newitem1181.png|NewItem1181.png}}

===== Exporting For the First Time To Quickbooks Desktop =====

  - **Open** **Intuit Quickbooks** and make sure that the **Company File** you are syncing to is open. \\ {{libertyreact:lib:newitem1180.png|NewItem1180.png}}
  - You can verify the **Company File** that is open by looking at the top left corner of the **Intuit Quickbooks** application. \\ {{libertyreact:lib:newitem1179.png|NewItem1179.png}}
  - **Open** the **Liberty REACT Inventory Module** and then click on the **QB Link** icon. \\ {{libertyreact:lib:newitem1178.png|NewItem1178.png}}
  - If you see any **Red** entries, they will need to be corrected first. \\ Click once on the **Red** entry and then click the **Edit** button. \\ {{libertyreact:lib:newitem1177.png|NewItem1177.png}}
  - Type in the **G/L Account** name you would like Liberty to create or sync into if **Quickbooks** has the account already created. \\ {{libertyreact:lib:newitem1176.png|NewItem1176.png}} \\ Note: To export into sub-accounts, simply use the colon (:) symbol between two accounts Example Bank of America:Check
  - Scroll down until you get to the bottom and make sure there are no more **Red** entries missing required information. \\ {{libertyreact:lib:newitem1175.png|NewItem1175.png}}
  - Click the **Export** button. \\ {{libertyreact:lib:newitem1174.png|NewItem1174.png}}
  - You will now be prompted for the start date you wish Liberty to export from. \\ Click the **Month Year** option at the top to quickly flip through the past years. \\ {{libertyreact:lib:newitem1173.png|NewItem1173.png}}
  - You can use the left or right arrows to move backwards or forwards between the different years. \\ Once you have found the year you wish to export from, select the **Month** you want to start the export sync from. \\ {{libertyreact:lib:newitem1172.png|NewItem1172.png}}
  - Select the date of the **Day** you wish to export from and then click the **OK** button. \\ {{libertyreact:lib:newitem1171.png|NewItem1171.png}}
  - Confirm that the date is correct on the following prompt and then click the **Yes** button. \\ {{libertyreact:lib:newitem1170.png|NewItem1170.png}}
  - We now must give **Liberty REACT** permission to export to **Intuit Quickbooks** without having the **Quickbooks** program open in the future.  You can use any of the other options if you wish, just keep in mind you will have to have **Intuit Quickbooks** open if you do. \\ Click **Yes; allow access even if Quickbooks is not running**, then click the **Continue** button. \\ {{libertyreact:lib:newitem1169.png|NewItem1169.png}}
  - When prompted **Are you sure you want to allow access**?, click the **Yes** button. \\ {{libertyreact:lib:newitem1168.png|NewItem1168.png}}
  - Click the **Done** button. \\ {{libertyreact:lib:newitem1167.png|NewItem1167.png}}
  - The **Liberty Quickbooks Link** will now sync to your company file from the date you selected prior. \\ {{libertyreact:lib:newitem1166.png|NewItem1166.png}}
  - When you see **The sync has been completed successfully**, this means that the export is finished. \\ {{libertyreact:lib:newitem1165.png|NewItem1165.png}}

Note: If you see a message stating that there was an error during the export, please visit our Troubleshooting **Quickbooks** article.
==== Next Article In Section ====

Click the following link to move to the next article in this section: \\ [[:quickbookslink:qbdesktop:companyfilesettings|Company File Selection and GL Account Settings]]

==== Related Topics ====

[[quickbookslink:qbdesktop:qbdesktopoverview]]
[[quickbookslink:qbdesktop:companyfilesettings]]
[[quickbookslink:qbdesktop:qbcompanyfile]]
[[quickbookslink:qbdesktop:qdfirsttime]]
[[quickbookslink:qbdesktop:subqbdesktop]]
[[quickbookslink:newtopic17:qbdesktopvid]]
[[quickbookslink:newtopic17:qbtransactionsvid]]
[[quickbookslink:newtopic17:qbonlinevid]]
[[quickbookslink:newtopic17:subaccountsvid]]
[[quickbookslink:qbonline:qbonlinefirsttime]]
[[quickbookslink:qbonline:qbonlineoverview]]