Integrating QuickBooks Online with EZRentOut

Quickbooks online

This blog is for setting up our QuickBooks Online Integration. You can also read the troubleshooting guide for this integration or check out the tutorial for our QuickBooks Desktop Integration.

Contents

1. Connecting to QuickBooks
2. How things map
3. Importing Customers
4. Importing Orders
5. Actions that prompt Order details to sync
6. Frequently asked questions

1. Connecting to QuickBooks

To start off, we need to connect EZRentOut with QuickBooks Online.

1. From your EZRentOut account, head to Settings → Add Ons → Integrate QuickBooks Online

2. Click the connect button.

Quickbooks online

3. The Intuit App Center pop-up will appear. To ‘authorize Intuit to securely share your data to EZRentOut’, hit the Authorize button. This will connect EZRentOut and QuickBooks.

Note: This process is much quicker if you sign into QuickBooks before attempting this step.

4. After signing in, specify the Chart of Accounts for Sales,Payments, and Items.

5. The next step is syncing your taxes.

Before you start, it is important to know how to handle Manual Sales Tax and Automated Sales Tax in QuickBooks.

Next, go to Settings → Add Ons → Integrate Quickbooks Online → Sync Taxes From QuickBooks and select this checkbox.

This causes customer invoices to sync, pulling the tax from QuickBooks to EZRentOut. If changes are made to the Order, you will be shown a message to manually sync the taxes again to update the rate:

You can do this using the ‘Sync Taxes from QuickBooks’ button under More Option to the right of the Order:

Please note that this manual sync will delete all taxes applied to the Order within EZRentOut, and sync the tax over from QuickBooks. The Order will then be synced directly to QuickBooks.

2. How things map

EZRentOut manages rental and sale transactions through Orders. An Order can go through various stages and is always associated with a customer. There is also an invoice attached to an Order. You charge payments, apply taxes, add discounts, give refunds etc. in Orders.

This is how mapping works from EZRentOut to QuickBooks:

EZRentOutQuickBooksLocation in QuickBooks
ItemsServicesSettings icon → Products and Services
OrdersInvoicesSide panel → Sales → All Sales
CustomersCustomersSide panel → Sales → Customers
PaymentsPayments Create → Recieve Payment

You can run reports on payments, finances, orders, customers etc. from EZRentOut More Reports or from QuickBooks Reports.

A more in-depth guide to mapping is given below:

EZRentOutQuickBooks Online
BusinessCustomers
CustomersCustomers
PaymentsPayments
Customer/Business’ Billing AddressInvoice Billing Address
Custom TaxCustom Tax
Custom EntriesService Item
DiscountsService Item
Default Line ItemsService Item
Default Line Items in an OrderService Item
Items (Assets, Asset Stock, Inventory)Service Item
Late feeService Item
OrdersInvoices

You can also map the Invoice Date, Due Date, and Invoice Number per your requirements 

Note: Default Line Items that are not present within an Order are synced as Service Items with their new Invoice.

3. Importing Customers

Once you enable the QuickBooks Add On in EZRentOut, a new field will appear against all your customers. This is the QuickBooks Display Name (Side Panel → Sales → Customer Edit). All QuickBooks Display Names are unique. This is the customer identity that maps from EZRentOut to QuickBooks and vice versa.

Let’s begin importing customers from QuickBooks Online!

Go to the Customers tab in EZRentOut. Click on the ‘Import From QuickBooks’ button.

This redirects you to a page displaying all the QuickBooks Online Customers that are going to be imported. Hit the ‘Import’ button and that’s it!

Additionally, whenever you rent out an Order in EZRentOut, a new customer is automatically created in QuickBooks if they don’t already exist. Customer details and payments are synced whenever the relevant transactions are synced.

Note: If you haven’t filled in a Display Name for a customer in EZRentOut, the field is auto-filled with the customer’s first and last name, prior to sync.

4. Importing Orders

open invoice in QB
invoice in QB
Customers in QB

Let’s begin with an Order in EZRentOut. This Order invoice will appear in QuickBooks once it’s rented out so let’s go ahead and rent it out. The invoice will appear under ‘All Sales’ in QuickBooks → Side Panel → Sales.The above is an open invoice (not paid) until the Order is completed in EZRentOut. The EZRentOut Order is added as a QuickBooks transaction. Customer, their address, rent out and due dates also appear here:
From QuickBooks → Side Panel → Sales → Customers, you can see that ‘Catherine Ross’ has been added here:

When you charge the payment for an order in EZRentOut, the invoice is marked as ‘Partial’ if payment isn’t made in full. Once, you return/complete the Order, or charge payment in full, the invoice is marked “Paid” in QuickBooks. A payment transaction is also added with “closed” status:

Invoice and payments in QB

5. Actions that prompt Order details to sync

Order information syncs from EZRentOut to QuickBooks and vice versa if any of the following actions are taken:

  • Order is rented out or booked in EZRentOut, provided your QuickBooks Add On preferences allow for these syncs. Update them from Settings –> Add Ons –> Integrate with QuickBooks Online in EZRentOut.
  • The invoice is marked Paid in QuickBooks.
  • When a Booked Order is cancelled in EZRentOut, it’s invoice is deleted in QuickBooks.
  • Whenever you press the ‘Sync Invoice with QuickBooks’ button from the EZRentOut Order Details page, all updates are synced to QuickBooks. This button becomes available once an Order is rented out/booked(based on the settings enabled).
  • Any payment made in either QuickBooks or EZRentOut prompts a sync to the other application. However, other details such as invoices, customers or taxes are only pushed from EZRentOut to QuickBooks, not the other way around.
    Note: For a payment to sync both ways, an Order’s invoice must exist in your EZRentOut account.

6. Frequently asked questions

I am receiving the error: “Failed to update invoice on Quickbooks: XYZ is deleted or is marked inactive on Quickbooks”. How do I proceed?

We love hearing from you!

Your suggestions and feedback are important to us. Let us know what enhancements would you want to see at support@ezrentout.com.

Join the Conversation: Twitter | Facebook | LinkedIn

Don't forget to share this post!