QuickBooks - Deposits

If you use QuickBooks Online to manage your accounting, you'll be happy to know that OwnerRez integrates with QuickBooks Online.  Read about how it all works in our QuickBooks Overview article, or jump right to the QuickBooks Setup & Connecting guide to get started.

This article focuses on the relationship between OwnerRez deposits and QuickBooks bank deposits, and how to automatically sync those entities for easy reconciliation.

• Why Deposits
• Comparing Deposits in OwnerRez and QuickBooks
• Prerequisites to Deposit Syncing
• Turning On and Configuring Deposit Settings
  • Deposit Bank Account
  • Fees Expense Account
• Settings and Options

Why Deposits

As a business, you want your "quote to cash" process to be as automated, streamlined, and complete as possible.  You can't have an accurate quote-to-cash process if your deposits are a mess or if your financial reports show lump sums that aren't categorized cleanly.

When someone books your property, the guest pays you money that you account for, deposit in the bank, pay taxes out of, and so on.  As the money moves along, the accounting gets more complicated at every step.  Payments come from many places (i.e. channels, websites, etc.) and may be deposited in different forms.

Further complicating things, fees are often charged by those channels, websites, and credit card processors — sometimes multiple fees at the same time — leading to a deposit amount that does not reflect the original payments.

In other words, lump sums hit your bank account from places like Airbnb, Stripe, Vrbo, and even paper checks — so how do you reconcile them?

OwnerRez creates invoices and payments automatically in QuickBooks, but you still have to match up the final QuickBooks bank transactions.  QuickBooks will automatically show you the bank transactions imported from your bank account, but which deposits go with those invoices and payments?

We have fixed this problem with "deposit syncing," where OwnerRez will create "Bank Deposits" in QuickBooks with the exact amount of the final deposit and include an itemized list of payments and fees that make up that exact amount. With these Bank Deposits, you can then match the bank transactions imported by QuickBooks from your bank account and be "to the penny" with no manual adjustments.

Comparing Deposits in OwnerRez and QuickBooks

OwnerRez and QuickBooks have very similar deposit structures.  Both are made up of a list of payments, fees, and adjustments that lead to a final balance.

Here is a side-by-side comparison of a deposit that is in both OwnerRez and QuickBooks.  The red arrows demonstrate which parts of the OwnerRez deposit map to the QuickBooks deposit.

It is important to understand the relationship between the deposit amount and the payments, fees, and adjustments that make up the deposit. The deposit itself has no set amount other than the sum of all the payments, fees, and adjustments that are part of it.  Notice in the screenshot above that the deposits (on both sides) show an amount that exactly equals the payments, fees, and adjustments inside it with no ability to change that amount.

Prerequisites to Deposit Syncing

Deposit syncing runs as a secondary step after booking and payment data have already finished syncing to QuickBooks. Put differently, deposits cannot be synced until bookings and payments have been synced first.  So, if you haven't connected QuickBooks to OwnerRez and successfully synced bookings and payments, do that first.

If you already have a solid reconciliation process and don't want to change anything, you don't have to. Deposit syncing is an additive step that does not affect bookings or payments.

If you have the "Push Payments" setting turned off, deposits cannot be synced to QuickBooks.  This is because deposits are made up of payments and fees.  If payments don't exist on the QuickBooks side, deposits cannot be created either. 

Deposit syncing requires "Undeposited Funds" to be used as the bank account for payments when your payments are created in QuickBooks.  If you do not use Undeposited Funds, deposits cannot be synced to QuickBooks.  However, you can quickly change your QuickBooks payment settings in OwnerRez to start using Undeposited Funds anytime.  You may need to change individual bookings as well if they have already finished syncing.

Turning On and Configuring Deposit Syncing

If your QuickBooks connections and mappings are in good standing, and already working, you're ready to configure deposits.  Go to your QuickBooks connection in OwnerRez (Settings > QuickBooks > click on the Quickbooks account you want to configure) and look for the Deposit Settings tab in the middle of the screen.

As the Deposit Settings page shows, payments must be mapped to the "Undeposited Funds" account in QuickBooks.  If you enable deposit syncing, OwnerRez will automatically change your payment settings to use Undeposited Funds.

The Deposit Settings page is simple.  At the top, you have a master switch called "Sync Deposits" that lets you turn the entire thing off or on with one checkbox.  Turning it off has no effect on other aspects of the QuickBooks integration.  Bookings and payments will still continue syncing even if deposits do not.

When "Sync Deposits" is selected, there are two fields beneath it that are required: Deposit Bank Account and Fees Expense Account.

Deposit Bank Account

All deposits in QuickBooks must be mapped to a bank account.  A bank account is typically a physical bank like Chase, Bank of America, etc and is usually a Checking or Savings account.  However, it is possible to have other forms of bank accounts like "Uncategorized Assets" or other placeholders.  You can add or edit your bank accounts in QuickBooks using the banking area.  This is the same place where you match transactions and manage "bank feeds".

Think of the Deposit Bank Account as the actual place where the money was sent.  For example, if you get payouts from Airbnb, where did Airbnb actually send that money?  An "Airbnb payout" is the same thing as a deposit in OwnerRez, so the bank account that Airbnb transferred the money to is the Deposit Bank Account you should select in your settings.

By default, the Deposit Bank Account setting will show a single drop-down list of your bank accounts in QuickBooks.

If you don't see an up-to-date list of bank accounts, use the Refresh References button at the top of the page.  The Refresh References function will reach out to your QuickBooks account live while you wait, get the latest list, and update your OwnerRez account.  The drop-down should then show all the bank accounts that are in QuickBooks.

If all of your deposits go to the same bank account, select that account, and you're done.

However, some users have deposits going to different bank accounts depending on which channel, website, or payment processor the booking came through.  If that's you, no worries - we've got you covered.

Select the second option "Use different bank accounts depending how the deposit was processed", and you'll see a mapping table called "Deposit Types" open below.

This table allows you to select a different bank account for each type of processor that sent you money. Currently, there are five options: Airbnb, Stripe, Lynnbrook Group, Manual, and All Other Types.

• Airbnb - If you use our direct integration for Airbnb to manage your Airbnb listings, OwnerRez automatically imports your Airbnb payouts as deposits.  This option allows you to pick a different bank account from where your other deposits go.
• Stripe - If you use Stripe as your credit card processor, OwnerRez automatically imports deposits for you. This option allows you to say where your Stripe deposits go, allowing you to pick a bank account different from where your other deposits go.
• Lynnbrook Group - If you use Lynnbrook Group as your credit card processor, OwnerRez automatically imports deposits for you. This option allows you to say where your Lynnbrook deposits go, allowing you to pick a bank account different from where your other deposits go.
• Manual - If Airbnb, Stripe, and Lynnbrook do not cover all of your payments, you have to manually record your deposits.  Even if you use one of the automated deposit methods, you might still have other manual deposits for occasional checks or cash payments.  This "Manual" option allows you to specify which bank accounts your manually-recorded deposits go to.  At this time, all manually-recorded deposits must go to the same bank account.
• All Other Types - This option should never really be used by the system, as the other four options cover all possible deposit scenarios currently supported by OwnerRez. We added "all other types" as a fall-back option in case the system does not know what to select or a new automatic option is added without a QuickBooks setting.

Fees Expense Account

Under construction

Settings and Options

Under construction