Sign Up  |  Already Signed Up? Login

The OwnerRez Blog

A blog about our thoughts, services, upcoming features and the industry at large.

QuickBooks integration has arrived

OwnerRez can now sync booking and payment records automatically with QuickBooks without you lifting a finger!

If you use QuickBooks Online to manage your accounting, you'll want to set this up immediately.  Go to Settings > QuickBooks to get started.

After you click the Connect button, you'll be redirected to Intuit's website where it will ask you to login, select your QuickBooks company (if you have more than one) and authorize OwnerRez to make changes.

The process is dead simple, and if you're already logged into QuickBooks, you won't even have to type anything.  Just a couple clicks.

After you've clicked Authorize, you'll be redirected back to OwnerRez where we'll show you the authorized connection and present you with a page where you can map your charge line items, taxes and properties.

Take a minute to read over the mapping options.  The options allow you to specify how invoices and payments will be created on the QuickBooks side from your OwnerRez bookings.  It's important that you get the mappings right.  If you don't understand the mapping options, please contact us directly for help.

Which bookings will be synced?

Once QuickBooks is configured for a property, all bookings that are changed thereafter will start syncing with QuickBooks.  Even changing the name or guest count on the booking will trigger a sync.

To keep track of whether a booking has synced or is still pending, and to see the result of the sync, visit the QuickBooks tab under the booking.

You can also manually trigger it to sync from the same page.

If you have historical bookings that you want synced to QuickBooks, you'll need to manually trigger each one by visiting the booking > QuickBooks page and clicking the Sync Now button.  If you have more than few bookings, let us know and we'll bulk update them all from our side.

What exactly is synced with QuickBooks?

When any bookings are created, updated or canceled in your OwnerRez account, our system will create corresponding updates in your QuickBooks account.

Specifically, each OwnerRez booking is mapped to a single "invoice" in QuickBooks and payments are synced as well.  If you search QuickBooks with your OwnerRez booking number, you should find a corresponding invoice with the same number.

That invoice will have the same payments in QuickBooks that you see in OwnerRez.

What type of financial transactions are not included?

For the moment, refunds and security deposit are not synced with QuickBooks, only payments are.  This is because there are several ways "credits" can be recorded in QuickBooks and the way you do your accounting makes a difference.  Security deposits, likewise, would create complications, so we've left them out too.

We do not create "deposit" records in QuickBooks because there is no way for OwnerRez to know which payments settled together or if you deposited them at different times.  You will need to manually record deposits on your own, though having OwnerRez payments automatically entered should make that process significantly easier.

Beta program

Please be aware that this update is a beta release.  Some functionality may feel a bit brittle as we work through issues.  Accounting programs, like QuickBooks, are large and complicated by nature.  There are many ways of mapping data or displaying transactions.  If you have a different way of doing things, and our sync isn't playing ball, please let us know so we can create options for you.

This QuickBooks integration may eventually be a pay-for option.  At the moment, we're releasing it free and open to all users, but it may become part of a Power User feature that has a monthly cost in the near future.  If it does, we'll let you know with plenty of time to spare, but please be aware of that up front.

The fastest, most-professional way to book is with OwnerRez, the leader in online vacation rental software.  Sign up for your free account!

8 Comments (add yours)

Mar 23, 16
5:20 pm
Wendy@A-List says:

Will we be able to integrate with the desktop version of quickbooks?
Love this idea!
Thanks,
Wendy

Mar 23, 16
6:30 pm
Sam Westcott says:

Wendy, we'd love to support QB Desktop but it's really hard to build integration in a way that is as seamless and powerful as the Online version. With Online, our system just talks to their system directly under the covers. Everything moves right across with zero interaction from you. There is **supposed** to be a way to do that Desktop too but, at the moment, we're focusing on the Online version. Best, ~Sam

Mar 23, 16
7:02 pm
Wendy@A-List says:

Ok, that's a bummer, do you think you'll be trying to adapt it to the desktop after you get the online version done?
Thanks,
Wendy

Mar 24, 16
8:01 am
Sam Westcott says:

Short answer is yes, but it may take awhile. QB does have a "web connector" that can be used to to keep Desktop up to date, and there's good documentation for it. But it's also a matter of priority. As usual our development roadmap keeps growing faster than we can work on things! :-)

Mar 24, 16
9:13 am
Wendy@A-List says:

Totally understand, thank you for putting that feature on the list!
Wendy

Mar 24, 16
8:21 pm
Southern Florida says:

I was glad with the Online Quickbooks integration but when I tried to integrate OwnerRez told me that my Canadian version of QuickBooks isn't integrated yet.

Does OwnerRez have plans to integrate the Canadian version as well? Because, I assume, that OwnerRez should have some Canadian clients as well (probably second after the U.S. clients...)...

Mar 25, 16
10:40 am
Sam Westcott says:

Hi Southern Florida, that's a great suggestion. I *believe* that it's just a matter of flipping on other countries, but I'll note that down in our dev roadmap to check into for you. It may require some additional testing and such on our side. If there's no major issues, we'll get that turned on for you.

Mar 25, 16
5:15 pm
Sam Westcott says:

Southern Florida, I flipped Canada on for our QB app integration. Looking at the docs, I don't see any reason it wouldn't work. Could you try it out and let me know what you find? It should move your bookings and payments into QB perfectly fine. Let me know, ~Sam

In order to leave a comment, please login.  If you don't have an account, get one now in less than 30 seconds.
What is OwnerRez?

We are an online booking service for vacation rental property that helps managers and owners save time, create quotes and bookings faster, look professional and keep detailed records without needing an accountant or staff.