Asset Intelligence and Management

Asset Intelligence and Management

EZRentOut Blogs Guide To Ezrentout Sync And Quickbooks Desktop Integration

[How-To] Guide on QuickBooks Desktop and EZRentOut Sync

Integrate QuickBooks Desktop with EZRentOut

Getting Started

EZRentOut Sync enables you to quickly and effortlessly sync EZRentOut data (Taxes, Assets, Inventory, Asset Stock, Customers, Orders & Payments) with QuickBooks (desktop). EZRentOut Sync is a Windows application that runs on your PC side by side with QuickBooks (desktop). This guide will walk through the process of installing and configuring EZRentOut Sync in a few easy steps. We will have you syncing your data with QuickBooks in no time!

Contents:

1. Prerequisites
2. Install the EZRentOut Sync Application
3. Configure QuickBooks
4. Enable Syncing on your EZRentOut Account
5. Perform the Sync for the First Time
6. Creating an Account that Doesn’t Exist in the System
7. What Kinds of Data do we Sync?
8. Different Sync Types in EZRentOut
9. Map Existing Customers/Businesses to QuickBooks
10. How Things Map to QuickBooks

1. Prerequisites

You will need the following to successfully install and run EZRentOut – QuickBooks Sync.

  • An active EZRentOut (subscription/trial) account. If you don’t have a subscription or trial account, register here.
  • A PC with Windows 7 (all versions), Windows 8 (all versions), or Windows 10 (all versions).
  • A PC with QuickBooks 2012 (or later) installed. All desktop versions of QuickBooks are supported such as:
    • QuickBooks Standard
    • QuickBooks Pro
    • QuickBooks Pro Plus
    • QuickBooks Premier
    • QuickBooks Enterprise

Hint: For a seamless installation process, it is recommended that you restart your PC before installing the EZRentOut Sync application.

Important: If you do not have QuickBooks installed on your computer, it is important that you install it before attempting to install EZRentOut Sync.

Step 1: Install the EZRentOut Sync Application

Hint: Due to known QuickBooks issues, it is recommended that you restart your PC before installing the EZRentOut Sync for a seamless installation process.

  1. Click here to download the latest EZRentOut Sync application zip file.
  2. Open the folder where you downloaded the zip file and extract its contents as shown below.
  1. Open the extracted folder and launch the Setup.exe file (highlighted in the image below)
  1. The installer will now launch and install the QBFC components followed by EZRentOut Sync (Important: Please make sure QuickBooks is not running in the background while the installation takes place)
  2. The setup will install the EZRentOut Sync app and place application shortcuts on the desktop and Programs Folder/Start Menu. The following screen shows the shortcut as they appear on a computer running Windows 10.
ezrentout sync

Hint: You may simply click on either the shortcut on the desktop or launch EZRentOut Sync from Start -> Programs Menu.

Step 2: Configure QuickBooks

Before performing your first sync there are a few quick checks that you need to perform in QuickBooks to ensure that it is configured properly.

  1. If you collect taxes on orders in EZRentOut, it is required that Sales Tax be enabled in QuickBooks. To do so, launch QuickBooks, load your company file and go to Edit >> Preferences >> Sales Tax (see image below).

Note: If no tax previously exists, QuickBooks will force you to create a ‘default tax’ and a ‘default Tax Agency’ (as shown above)

  1. (Optional) If you are interested in tracking and viewing Fixed Assets synced from EZRentOut, enable the ‘Items and Inventory’ setting by going to Edit >> Preferences >> Items and Inventory as shown below.


Step 3: Enable Syncing on your EZRentOut Account

This step ensures that your account in the EZRentOut’s web application is ready for exchanging data with QuickBooks in a secure and private manner.

  1. Login to ezrentout using your admin username and password.
  2. Go to Menu on the top-right of the page >> Settings >> Add Ons (see below).
  1. Scroll down to the section titled ‘API Integration’ and enable it as shown below:

a. Select the Enabled option and click the Save button at the bottom of the page.

b. The system will generate a secret key and display it for you (as shown in the image below).

c. You will need this key, later on, to configure and authorize the EZRentOut Sync app to exchange data with your EZRentOut account.

Hint: You could copy/paste the key into your favorite text editor to use later.

Note:  For this to work well, make sure to enable QuickBooks Desktop Integration as well in Settings > Add Ons > Integrate QuickBooks Desktop > Click ‘Enabled’. Once done, hit ‘Save Settings’ at the bottom of this page.

Step 4: Perform the Sync for the First Time

  1. Having followed steps 1 through 3, at this point:
    • EZRentOut Sync application should be installed successfully on your PC
    • QuickBooks should be installed and configured (as described in the previous section)
  2. Now launch QuickBooks and open the desired company file. (This is important, as QuickBooks needs to be running so that the EZRentOut Sync app can exchange data with it during the syncing process).

Please note that Steps 3 & 4 are to be performed just once. 

  1. Launch EZRentOut Sync:
ezrentout sync launch overlay

You will be presented with the screen shown below. This screen enables you to grant permission to the EZRentOut Sync application to exchange data with QuickBooks. Proceed by selecting the options shown as shown below.

  1. Ignore the warning shown below, this is caused by the fact that the EZRentOut Sync isn’t assigned a digital signature yet since this is an early access release version of the application. This warning will go away in a subsequent update of the app.
    warning overlay
  2. This will launch the EZRentOut Sync application (see image below).
    • In the Settings section, enter your Secret Key generated in Step 3.
    • In the Account Mapping section, select the QuickBooks account that you want to associate with your data in QuickBooks.
Account TitleQuickBooks Account TypeDescription
Rental Income AccountIncomeAn account of type ‘Income’ to be associated with rental income.
Sales Income AccountIncomeAn account of type ‘Income’ to record sales income.
Sub Rentals AccountIncomeAn account of type ‘Income’ to record sub-rentals income.
Asset Account (for Inventory)Other AssetAn account of type ‘Other Asset’ is used to record and track the value of current inventory items.
Credit Account (for Inventory)Other Current Liability,
Accounts Payable,
Bank,
Credit Card
An account of this type is used to record and track the outstanding liabilities and/or payable amounts to suppliers, and vendors for the inventory purchased.
COGS Account (for Inventory)Cost of Goods SoldAn account of type ‘Cost of Goods Sold‘ is used to record the purchase cost of inventory.
Sub-Rentals AccountIncomeAn account of type ‘Income’ to record discounts.
Damages AccountIncomeAn account of type ‘Income’ to record damages.
Custom Entries AccountIncomeAn account of type ‘Income’ to record custom entries.
Refunds AccountIncomeAn account of type ‘Income’ to record refunds.

Under Rules and Coupons, if a ‘Pricing Discount Coupon’ is set as ‘Charge’ category, then it will be synced to your ‘Custom Entries Account’ in QuickBooks Desktop.

Moreover, if there are more than one ‘Pricing Discount Coupons’ created and the cumulative of those Pricing Discount Coupons (whether set as category ‘discount’ or ‘charge’ in EZRentOut) added to an order is in a positive value, then it is also synced to your ‘Custom Entries Account’ in QuickBooks Desktop.

However, if the value is negative, it is synced to your ‘Discounts Account’ in QuickBooks Desktop.

Creating an Account that Doesn’t Exist in the System

The EZRentOut Sync application searches the QuickBooks Chart of Accounts (COA) and presents you with the best-matched options. If, however, an account of a certain type does not exist in the COA, you will need to create it in QuickBooks. In the example below, the 4th and 5th fields are empty because no accounts of type ‘Asset‘ and ‘Cost of Goods Sold’ exists in the COA.

  1. The following screens walk through the process of creating such (missing) accounts in QuickBooks. Go to Home >> Chart of Accounts >> Account >> New.
add new account

Note: You can safely skip this and the next step if these accounts already exist in your case.

configuring accounts
new account details
  1. After creating the accounts in QuickBooks, refresh the accounts list by clicking on ‘Refresh Accounts List’. The account list will be reloaded as shown below.
  2. Click on the Settings section to hide the settings (optional) and click the Sync Now button to launch sync. For details on all 3 sync options we offer, click here.
  1. Upon completion, you shall see the following on the application screen (indicating a successful sync session).

<Important: Since the application will remember all the settings, you will only need to launch the application and click the Sync Now/Sync All/Sync By Order Date button for subsequent sync operations.

QuickBooks help

What Kinds of Data Do We Sync?

It is important to note that payments made in either QuickBooks or EZRentOut will be synced over to the other platform. To learn how to avoid common errors when syncing payments, click here.

Details other than payments (such as invoices, customers, or taxes) are only pushed from EZRentOut to QuickBooks. Here is a list of the data we sync from EZR to Quickbooks.

  • Sync all taxes from EZR to QuickBooks
  • Sync all customers from EZR to QuickBooks
  • Sync all assets in EZR to fixed assets & service items in QuickBooks (including retired items).
  • Sync all asset stocks in EZR to inventory & service items in QuickBooks (including retired items).
  • Sync all inventory in EZR to inventory in QuickBooks (including retired items).
  • Sync all orders (with single tax applied) in EZR to invoices in QuickBooks.
  • Sync all payments associated with orders in EZR to QuickBooks, and from QuickBooks to EZR.
  • Sync all comments and transaction IDs (recorded in ‘Charge Payment’ form) with orders in EZR to QuickBooks. In QuickBooks, this data is shown against the memo field in the Customer Payment Page:

A Payment Mode will always be specified here. A transaction ID will appear if a CC payment has been made. Comments will only appear if you have recorded any in the ‘Charge Payment’ form. You’ll see the data here in this format:

Payment Mode : [payment mode] | Transaction ID : [transaction id] | Comment : [comment]

Example: Payment Mode: Credit Card | Transaction ID: ct_1CplqU8TQQCYx1VKI | Comments: Payment Completed

Note: Orders that include Item level discounts cannot be synced to QuickBooks Desktop

Different Sync Types in EZRentOut

Here are the 3 kinds of data syncs we offer:

  • Sync Now: This enables you to sync all data created or modified since the last sync. The sync utility will always tell you when the last successful sync occurred.
  • Sync All: This enables you to sync all data from your EZR account since inceptionThis might take some time if you have a considerable amount of items in EZR. Please note that this sync will override all corresponding data in QuickBooks, based on the data present in EZRentOut. 
  • Sync By Order Date: This enables you to sync only those orders from EZRentOut that fall on or after a specific date defined by you. This is useful in scenarios where you have updated order in EZR for a specific date, and now need to sync it with QuickBooks Desktop.

To reiterate, you can see the data we sync between each platform by referring to the section above.

And with that, you’ve learned all you need to about syncing data between EZRentOut and QuickBooks. You can download the EZRentOut – QuickBooks Sync Utility here.

Map Existing Customers/Businesses to QuickBooks

Most users face a common problem mapping their existing EZRentOut customer or business to an existing customer in QuickBooks. Here’s how you can do that:

a) Mapping Existing Customers

Instead of creating a new customer, you can map an existing EZRentOut customer to an existing QuickBooks customer. Go to Customers → Customer Details Page → Edit → QuickBooks Display Name → enter the QuickBooks customer name to which the EZRentOut customer is to be mapped.

Here’s what it looks like after you’ve successfully mapped it to QuickBooks:

b) Mapping Existing Businesses

Instead of creating a new one, you can map an existing EZRentOut business to an existing QuickBooks customer. Go to Customers → Businesses → Business Details Page → Edit → QuickBooks Display Name → enter the QuickBooks customer name to which the EZRentOut business is to be mapped.

Here’s what it looks like after you’ve successfully mapped it to QuickBooks:

How Things Map to QuickBooks

Here’s a list of how all the important fields in EZRentOut are mapped to QuickBooks Desktop:

EZRentOutQuickBooks Desktop
Asset StockService Item
BusinessCustomers
CustomersCustomers
Customer/Business’ Billing AddressInvoice Bill To
Order Shipping LocationInvoice Ship To
Custom TaxCustom Tax
Custom EntriesService Item
Default Line ItemsService Item
Default Line Items in an OrderService Item
DiscountsDiscounts
Fixed AssetsService item/Fixed Asset
InventoryService Item/Inventory
Late FeeService Item
OrdersInvoices
PaymentsPayments

Note: Default Line Items that are not present within an Order are not synced in QuickBooks Desktop.

Share Your Queries

For more assistance, drop us an email at support@ezo.io.