Guide to EZRentOut Sync and QuickBooks Desktop Integration

ezrentout sync app and quickbooks desktopGetting 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!

Prerequisites

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

  • An active ezrentout.com (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.

ezrentout qb installer

  1. Open the extracted folder and launch the Setup.exe file (highlighted in the image below)

setup.exe file

  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 shortcut 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 shortcut

ezrentout syncHint: 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 should be enabled in QuickBooks as well. To do so, launch QuickBooks, load your company file and go to Edit >> Preferences >> Sales Tax (see image below).sales tax in QB

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.items and inventory in QB

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 www.ezrentout.com using your admin username and password.
  2. Go to Menu on top-right of the page >> Settings >> Add Ons (see below).api integration
  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.Enable API

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:

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.ezrentout sync launch overlay

  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
  1. 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 to your data in QuickBooks.
Account Title QuickBooks Account Type Description
Rental Income Account Income An account of type ‘Income’ to be associated with rental income.
Sales Income Account Income An account of type ‘Income’ to record sales income.
Sub Rentals Account Income An account of type ‘Income’ to record sub-rentals income.
Asset Account (for Inventory) Other Asset An account of type ‘Other Asset’ used to record and track the value of current inventory items.
COGS Account (for Inventory) Cost of Goods Sold An account of type ‘Cost of Goods Sold’ used to record the purchase cost of inventory.
Discounts Account Income An account of type ‘Income’ to record discounts.
Damages Account Income An account of type ‘Income’ to record damages.
Custom Entries Account Income An account of type ‘Income’ to record custom entries.
Refunds Account Income An 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 positive value, then it is also synced to your ‘Custom Entries Account’ in QuickBooks Desktop.

However, if the value is in negative, then 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 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.

QuickBooks COA not found

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

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

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.

sync now

  1. Upon completion, you shall see the following on the application screen (indicating a successful sync session).last sync on

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.

sync-now

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:

memo field in QuickBooks

A Payment Mode will always be specified here. 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

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 an order in EZR for a specific date, and now need to sync it with QuickBooks Desktop.

sync by date

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.

Frequently Asked Questions

Integrating EZRentOut with QuickBooks Pro – Desktop Version

Versions of QuickBooks Desktop that can be integrated with EZRentOut

Looking up Error Log for EZRentOut – QuickBooks Desktop Sync Utility

Troubleshoot – Unable to update Inventory Average Cost and Total Quantity in QuickBooks

Troubleshoot – Inventory not visible in QuickBooks

Common Questions for QuickBooks Desktop – Canada Edition

Installing latest version of EZRentOut – QuickBooks Sync Utility

Share Your Queries

For more assistance, drop us an email at info@ezrentout.com. You can also share your ideas on our Community Forum. Visit our blog for more support posts on our equipment rental software.

Follow/Join us: Twitter | Facebook

ezrentout sync app and quickbooks desktop