How to account for Revel System POS transactions

Just to clarify the question: Revel POS software is linked to QBO and uploads daily transactions as an Invoice (A/R) with matching payments (Undeposited Funds, Employee Tips, Cash on Hand). Unfortunately, the payments recorded by the POS do not match the bank deposits: 1) dates are off by several days, and 2) deposits amounts may vary from recorded payments (due to fees, refunds, etc.) 

At this time, my Invoices are showing as Paid but not Deposited and my bank deposits are showing up as duplicate sales. 

How can match the uploaded payments with the appropriate deposit and account for any additional fees?

Any help is greatly appreciated!

I've got the steps you'll need on how to handle these transactions and match them in QBO, Nazcar.

You'll have to create a Bank deposit from the payment, add the fees as a negative value then manually Find a match.

Let me show you how to accomplish it:

1. Click the + New button.
2. Choose Bank deposits.
3. Select the payment you want to deposit.
4. Enter the amount of the fee charge as a negative amount in the Add other funds to this deposit section.
5. Select the appropriate expense account to track the fees.
6. Click Save and close to record the transaction.

Check out this article for additional details: Enter a bank service fee while using a third-party merchant service.

You can now match the entries to the correct ones. You can refer to this link to see the process: Match and categorize online banking transactions.

If QuickBooks can't find a match, it may be due to the date that is off by several dates.

Regarding duplicate sales, you can exclude them from your account. Check this article for detailed steps: Exclude bank transactions you downloaded into QuickBooks Online.

Once done, please click this article to view detailed steps on how you can reconcile your accounts: Reconcile an account in QuickBooks Online.

Let me know if you have additional questions about matching transactions in QuickBooks Online. I'd be happy to help.

Glinette,

Thank you for your response!

It helps getting closer to the answer, but the part that is not clear to me still is how do I match the 'Payments' to Undeposited Funds created by the POS integration with the actual 'Deposits' from my bank feed.

1) Bank Feed Review: How do I process the actual bank deposits: Categorize, Find Match or Transfer? I don't seem to be able to match these with the deposits with the payments as they don't show up as an option

2) If I attempt a new Bank Deposit, all I see are the 'Payments' from the POS, not my actual deposits

Thanks again for your help and happy to provide additional details if helpful,

Nazcar 

I'm glad you came here, NazcarCC.

There are a few reasons why transactions like bank deposits are not showing when trying to Find Match in QuickBooks Online (QBO). I've listed them below:

• The transactions entered in QBO doesn't simply match the number, amount, date or payee of your downloaded bank deposits.
• The transaction/s you want to match have been reconciled.
• The transaction entered in QBO has already been matched to another downloaded transaction.
• The transactions was downloaded twice. If these transactions have already been added to QBO and have a lightning bolt in the CLR column, it will not be matched again.

Once everything is verified, we can use the Find Match option to display all the possible matched transactions. To do that, follow the steps below:

1. Go to Banking and select the Banking tab.
2. Click Find other records button.
3. In the Match Transactions window, put a check mark on the transactions that should match to the downloaded transaction.
4. If the transaction you want to match is outside the date range displayed, update it. Select the date field to manually change the From and To dates.
5. Select Save if the total amount of both transactions is the same.
6. Click Save.

Once done, the transactions will now show under the In QuickBooks tab.

This article serves as your complete guide on how to add and match downloaded transactions in QBO: Add and match downloaded banking transactions.

To learn more about how to use transfers and how to categorize transactions, check out the following articles:

• Transfer funds between accounts
• Categorize and match online bank transactions in QuickBooks Online.

Get back to me if you have follow-up questions managing bank feeds. I would also appreciate if you'd let me know the results as I want to make sure this issue gets resolved. Have a good one.

Hi Nazcar,

Were you ever able to get this resolved? We are thinking about using the revel import into QBO but are hesitant for this very reason. Any input would be greatly appreciated.

Thanks,

Greg