Quickbooks Integration: Refunds

When I have a cancellation, the OR integration with QB seems to zero out the original invoice. It would be preferable if it created a refund instead.
The way it appears to be working now is that the QB invoice is updated to a $0 sale, which leaves me with orphaned deposits and refunds in my QuickBooks.

Hi Dori,

It only zero's out the invoice if the charges in OwnerRez are zero'd out. The QB invoice is always designed to mimic (ie. be an exact copy) of the charges on the booking. So when the booking charges change (whether for a refund or any other reason) the QB invoice will match.

The problem is that refunds are not created in QB (as a credit memo or whatever) so it does leave a problem with cancellations/refunds.

We plan to update our QB process to handle sales in a way where money is transferred from liability (for the initial payment) to an invoice or sales receipt later when the booking arrives. This will also help with the refund issue.

Thanks, I'll watch for the update.

Grrrr. This is such a frustrating issue for me; I really can't get my head around how it's considered okay for OR to reach back in time and change historical transactions on my QB side. I know you all go in and zero out the invoice on the OR side in the case of a cancellation, but please please please don't update that to a past invoice on the QB side. It messes up my registry. I still have to refund the cash, which I do on my QB side.
There has got to be a better way!!

The QB sync is designed to update charge changes on bookings in OwnerRez to invoices in QB. If you're making a change you don't want to sync to QB, you could first go to the QB tab of the booking and turn off the sync for just that one booking -- then the change won't sync to QB and you can update on the QB side.

Hi Dory and everyone,

This is a one of the most important accounting issues we face. I have included this in the list mentioned below. I am trying to create urgency with addressing Quickbooks Integration / Accounting issues in OR by having all key stakeholders join together to create a louder voice. To do so I have tried to summarize all the open issues in this theme and have created one master feature request that I am asking everyone that would like to see this addressed cast a vote for so we concentrate our voting and allow OR to see the magnitude of the need. I do have some ideas for a rapid resolution but at this time want to focus on identifying and prioritizing the issues/problems and have OR engage in prioritizing this fix.

The comprehensive thread is that this Feature request (full link below). If you feel this is a need PLEASE VOTE. If you have any additions, corrections, or comments please reply and I will try to keep the top post updated.

https://www.ownerrez.com/forums/go/70573

Thank you for your support and lets get a roadmap for this once and for all!!

Manel

Hey Paul, it's been a few years now, and refunds are still not getting sync'd into QB, making the process of matching invoices and deposits quite tedious.

Any update on when this feature will be available?

I see that all the action is happening in the other thread. I'll follow there, thanks

@Paul / OR, can we please close out the various QB threads and create one cohesive channel for communication.

@Leti,

I empathize with your issue and have been trying to push for urgency in addressing key accounting deficiencies. We all have to work together to communicate the challenges and needs. Please see the thread I mentioned above for the latest discussion.

OR has finally said they will fix the issue (see Paul’s last post) but we don’t have a timeline yet.

I understand you wanted to create one post and are pushing hard to run any updates to accounting by you or a group you create. However, I think it would be helpful to split the request out. Then it can be show which feathers are wanted and by how many. That seems to be a better method than one large thread on all accounting features. Not everyone had the same accounting needs and wants.