About the Airbnb Payment Clearing Account in Bnbtally

Within Bnbtally, when adding a QuickBooks Online account, you'll be required to set the Payment Clearing Account.

We recommend to have Bnbtally create the "Airbnb Payment Clearing Account" in QuickBooks for you. If you select for us to create it for you, we will create it as a type of Current Asset Account. In your Bnbtally invoice settings under your listing rules, you will have the option of setting automatic payments to invoices using the payment clearing account. If you were to disable this option in your invoices, then in QuickBooks you would need to match your invoices to your Airbnb bank transactions manually, which is not usually recommended.

Create a Bank Rule in QuickBooks

If you're using the payment clearing account, we also recommend to create a bank rule within QuickBooks to automatically transfer all Airbnb bank statement lines to the same Airbnb Payment Clearing Account. Otherwise, if you didn't do this, you'd need to manually reconcile the bank statement lines, which takes time and is prone to errors.

Steps to create a bank rule:

  1. On the left dashboard, click "Banking", select "Rules".

  2. Click "New rule".

  3. Give the rule the name "Airbnb Payouts".

  4. Select "Money in" and choose any bank account in which you receive your Airbnb payouts.

  5. For the condition, set "Description", "Contains" and then type in the text your bank statement uses to indicate an Airbnb payout (e.g.) "Airbnb"

  6. For transaction type, select "Transfer" and for account, select the Airbnb Payment Clearing Account.

That's it! Now your reconciliation is completely automatic!

Disclaimer: Just like any other recommendations we provide, please check with your accountant to make sure the correct bank rules and QuickBooks settings apply to your specific business. The above Bank Rule settings are what we find to be the most common.

Automatic Payments to Invoices using Payment Clearing Account

On the bottom of each invoice in your listing rules of Bnbtally, there is the following option:

When this is enabled, Bnbtally uses the Payment Clearing Account to make automatic payments to invoices and ultimately free you from reconciliation.

Here's a diagram of what happens when you use a payment clearing account to automatically apply payments to invoices and set a bank rule to automatically reconcile Airbnb transactions to the same payment clearing account. With this setup, reconciliation is completely automatic.

Why should I use a Payment Clearing Account to make automatic payments to invoices?

The reason we offer the option to apply payments automatically to a Payment Clearing Account is to make reconciliation entirely automatic and remove the extra step of matching each invoice to bank statement lines. Most users prefer this. You would no longer have to deal with manually matching or reconciling Airbnb reservations. Reconciliation would be automatic.

However, in Bnbtally you shouldn't use a Payment Clearing Account if you're not receiving the money directly from Airbnb. If you're receiving money from someone else other than Airbnb, you'll need to collect from them directly and reconcile your invoices with your deposits from them.

What if I DON'T want to automatically apply payments to invoices? What if I prefer to match invoices to Airbnb bank statement lines manually in QuickBooks?

That's totally fine, this is completely optional. If you decide not to have payments applied automatically to invoices, you would instead have to match your invoices to your banks statement lines manually on your own within QuickBooks. If this is what you wish, just deselect "Apply Payment using Payment Clearing Account" under your invoice settings within each of your listing rules. You can always re-enable this setting at a later time.

How to disable Auto-Payment Settings

For each listing...

  1. Select the listing from the Listings Manager page

  2. Under any Invoices and Refund Receipts, de-select the bottom checkbox "Automatically Apply Payment". This is all you need to do in Bnbtally.

  3. Within QuickBooks, it's also a good idea to remove any automatic Bank Rules that transfer money to your Payment Clearing Account. And be sure to communicate to any of your stakeholders to let them know you're no longer using the Payment Clearing Account to reconcile Airbnb income.

IMPORTANT NOTE: If you decide not to have payments applied automatically to invoices, there are two major disadvantages. First, you'll need to manually reconcile your invoices in QuickBooks. Second, Bnbtally is not able to rollback invoices that have been manually reconciled in QuickBooks. In order to rollback manually reconciled invoices, you would first need to undo the reconciliation within QuickBooks, which is another manual step.

Here's a diagram of what happens when you do not automatically apply payments to invoices. You'll need to manually reconcile Airbnb transactions to invoices.

What is a Payment Clearing Account?

A Payment Clearing Account is a general accounting practice and is defined as "an account you use to move money from one account to another account when you cannot move the money directly. This account normally has a balance of $0.00 because you always take out the same amount that you put in. It may also be called a Clearing Account, Barter Account or Wash Account" (source)

Specifically for Airbnb, the Payment Clearing Account is used to apply payments to Airbnb invoices upon the day the Airbnb reservation payout is posted. Payouts can take 3-5 days (or longer) to arrive in the bank account after posted from Airbnb. Monies owed are held in this clearing account until the payouts are received in the bank. This account also helps to automate the reconciliation process.

Disable Automatic Apply Credits in QuickBooks

One more thing! Within QuickBooks Online settings, under "Advanced Settings", look for the setting "Automatically apply credits" and make sure this is disabled. Although not always, this setting can cause conflicts with payments to invoices for any customers that have other existing payments.

Common Mistakes

There are scenarios where a payment clearing account can be misused. Make sure you're not making these mistakes...

  1. Some have made the mistake of using the Airbnb Payment Clearing Account to directly connect their bank feed. This is not correct. Your bank feed should be connected to a completely separate account.

  2. Applying payments to invoices automatically with Bnbtally but forgetting to transfer bank statement lines from Airbnb transactions to the payment clearing account in QuickBooks. We recommend to follow the instructions above to create a bank rule.

  3. Forgetting to disable "Automatically apply credits" in the advanced settings of QuickBooks. See instructions above on how to disable this setting in QuickBooks.

  4. Opposite to item 1, transferring bank statement lines from Airbnb transactions to a Payment Clearing Account yet later deselecting automatic payments to invoices in Bnbtally. In this case you may have decided that you want to manually match invoices with bank statement lines but may have forgotten to remove any bank rules in QuickBooks for automatic transfer to payment clearing account.

  5. Changing the payment clearing account used in Bnbtally but using the previous payment clearing account in QuickBooks.

Did this answer your question?