Experience the difference of "Elite".

Quickbooks Integration: Refunds

Status: Requested 4 Votes
Dori123
Mar 30, 2021 11:18 AM
Joined Sep, 2020 72 posts

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.

Paul W
Mar 31, 2021 12:01 PM
OR Team Member Joined Jun, 2009 706 posts

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.

Dori123
Mar 31, 2021 1:07 PM
Joined Sep, 2020 72 posts

Thanks, I'll watch for the update.

Dori123
Dec 10, 2021 7:25 PM
Joined Sep, 2020 72 posts

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

Chris Hynes
Dec 11, 2021 9:30 AM
OR Team Member Joined Oct, 2012 1348 posts

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.