All Collections
Accounting Systems and Processes
Month-end and Reconciliations
Troubleshooting clearing accounts
Troubleshooting clearing accounts

Month-end accounting tasks

Updated over a week ago

While reconciling your clearing accounts, you may notice that some guests either lack a corresponding payment or journal entry transaction. There are various reasons why this may occur.

The following scenarios are:

There is a missing payment in the clearing account

Sometimes you will have a journal entry recorded in your clearing account without a corresponding payment. Make sure to sort the clearing account reconciliation by payee so that all transactions related to each guest appear together.

To troubleshoot a missing payment, perform the following steps:

  1. Navigate to the guest profile in Quickbooks for which there is a missing payment by searching the guest name in the search box and selecting the contact customer profile.

  2. Ensure that the missing payment is not recorded in the list of transactions. Sometimes, a payment is recorded to the wrong clearing account. If the missing payment is generated by VRPlatform, and not recorded manually, perhaps your initial configurations or current configurations are set incorrectly, causing the payment to be recorded to the wrong clearing account. Check your Reservation Payment automation configurations to ensure the payments are being directed to the correct clearing account.

  3. If the payment is missing, run your Reservation Payment automation for the guest by navigating to your automations page, selecting your reservation payment automation, run the automation, and search the guest or reference ID for the missing payment transaction.

  4. Go back to your clearing account reconciliation in Quickbooks, refresh your browser, and the payment will show in your reconciliation.

  5. Each payment recorded against the invoice should have a matching journal entry. If you search the guest name in the search box, and there is one payment, and two journal entries for the same payment, delete the duplicate journal entry. Be sure to delete the duplicate journal entry transaction that is not matched to your bank feed.

There is a missing journal entry in the clearing account

You may notice that there is a payment recorded, with no matching journal entry. This can happen for one of three reasons: There is a duplicate payment being recorded that needs to be deleted in Quickbooks, the journal entry was not generated and matched to the deposit in your bank feed, or your journal entry configurations are set incorrectly, causing the reservation deposit amount to be recorded to the wrong account.

To troubleshoot a missing journal entry, perform the following steps:

  1. Navigate to the guest profile in Quickbooks for which there is a missing journal entry by searching the guest name in the search box and selecting the contact customer profile (Step 1 above). There should be one invoice, recorded payments, and one journal entry for every payment received. You can easily see if there is a duplicate payment being recorded. Delete the duplicate payment.

  2. If the journal entry is not in QBO, run the Payment Journal Entry automation for the guest name, and refresh your clearing account reconciliation screen in Quickbooks to see the missing journal entry. Make sure the journal entry is matched to the deposit in your bank feed.

  3. If you suspect that your Payment Journal Entry configurations are incorrect, as you notice many payments without matching journal entries, review that all payment reservation amounts are directed to the proper clearing accounts in the mappings page under "journal account." The line types should be set to the clearing accounts as indicated below:

Did this answer your question?