cancel
Showing results for 
Search instead for 
Did you mean: 
vaolivas051909
Level 2

Unmatched cash received to existing invoices.

Hello everyone. My client has bill.com and Stripe connected to Quickbooks online. My first time to encounter.

 

All payments of Invoices from these applications were added in QuickBooks bank feeds as Sales. Hence, the Cash Received was not matched in the outstanding invoices.

 

I found out that some Invoices are manually applied (per confirmation of client and per audit log history.)

 

And when I checked the Customers area, the invoices(for manually added) are Closed not seen Paid status. And these are floating amounts in the bank statement.

 

The owner just clicked Received Payment in the invoices paid. While Cash received in bank feeds were all recorded as Sales.

 

Am I right in my understanding?
Overstated both cash in bank (per Quickbooks) and Sales?

 

Can I adjust these in a Journal entry or I will undo the reconciliation for 2018/2019 and Undo Review and then match 1 by 1? So terrible.

 

The below picture is part of the Bank Reconciliation. Can I adjust like this entry👇?
Debit sales
Credit Cash

 

I have already checked the Invoices unmatched in the link per line item in the picture below.

 

PLEASE I BADLY NEED YOUR ADVICES. HIGHLY APPRECIATE YOUR HELP 😊

7 Comments 7
Jen_D
Moderator

Unmatched cash received to existing invoices.

Thanks for reaching out to us about this, @vaolivas051909,

 

You're correct about the overstatement after transactions are not linked properly. All existing sales or expenses in QuickBooks should be matched to the bank entry in the Banking page to avoid double income.

 

The discrepancy you're seeing comes up if there are duplicate entries in the register. This is likely resulted from adding the data from the bank without linking it to the transactions in QBO.

 

Therefore, we do not recommend doing journal entries to correct this. It will only create additional problem to your reports and future reconciliation. The best thing to do is properly matching the entries to correct the balance moving forward.

 

Since you're the accountant of this client, you have the option to undo a reconciliation and manually find matching items.

 

These links will help you categorize bank items and do other Ban Feed tasks in QuickBooks Online:

Let me know if you need further assistance about this. I'm just a click away to help you. Have a great weekend!

vaolivas051909
Level 2

Unmatched cash received to existing invoices.

Thank you Jen. So what I did is, I check undid reconciliation. I undid sales deposit, in the "Reviewed" center, which I believe it's the corresponding payment of the invoices. I also undid the Payment Received in the invoices. But I have encountered payment received via QBO. I cannot delete payment received until I unmark in the Deposit. Then I unmarked in the (Deposit center). I then matched the Cash received, in the "For Review" center, and matched to outstanding invoices.

 

I am just so worried now, why there is a popped out WARNING  in the client's QBO homepage

"! Alert. Some Quickbooks payments deposits weren't automatically recorded. After you received the funds in your account, record them manually as Bank Deposit. Take Action." 

 

How can I know which funds are those? and where will I find it? 

 

 

Adrian_A
Moderator

Unmatched cash received to existing invoices.

You have me to help you fix this alert message, vaolivas051909.

 

With QuickBooks Payments, when you process credit cards and bank transfers, QuickBooks will automatically try to record the deposit to your bank account.

 

We can determine which payments are causing this message, we'll have to log in to your QuickBooks Payments account. I'll show you how:

 

From the Gear icon, select Account and settings.

Select Payments, and then Manage Account.

Select Activity & Reports, then Deposits.

Choose your recent deposit to see the individual payments.

 

Afterward, we'll have to record the deposit:

 

  1. Select + New, and then Bank Deposit.
  2. Go to the QuickBooks Payments section.
  3. Match the payments in the list to the payments in the Merchant Service Center report.
  4. Once you're done matching the payments to the deposit, select Save then Close.

 

To prevent this issue from happening again, make sure QuickBooks knows which account to record deposits to. There are two ways on how to do it:

 

The first option, click the Gear icon and then select Account and settings. Then, select Payments. The second one, go to the Accounting tab and select Chart of Accounts. Then, select the bank and expense accounts that QuickBooks should use.

 

I'm just around to help. Keep safe!

vaolivas051909
Level 2

Unmatched cash received to existing invoices.

Thank you Adrian. The transactions I'm referring to are 2018 transactions and I already reconciled it(the other day) until January 2019. I saw the popped out Alert earlier before I reconcile February 2019.

 

Will your suggestion affect the reconciled months?

 

Please find attached screenshot of +New, Bank Deposit, where can I find here the Quickbooks Payments Section?

MadelynC
Moderator

Unmatched cash received to existing invoices.

It should be added to the 2018 reconciled transactions, @vaolivas051909.


Allow me to share some details and help you fix this.

 

This will affect since those are parts of the 2018 transactions. You’ll have to include the payment deposit that wasn’t recorded yet, to remove the alert you’ve received. This way, transactions will no longer tag as pending.

 

With regards to QuickBooks payments, it will automatically record to your client’s bank account if their payments account is link. So you don't need to record deposits manually.


I recommend contacting our Payments Support team to verify these transactions first. This way, we can avoid any duplicates and we will know the best actions to get rid of the prompts. You can refer to this link to contact them: https://quickbooks.intuit.com/learn-support/en-us/payments/contact-payments-support/00/376458.


You can read through these articles for more details in troubleshooting reconciliations:

 

The Community is always here to help. Take care.

vaolivas051909
Level 2

Unmatched cash received to existing invoices.

Thank you. Yes Quickbooks recorded it's deposits automatically. Quickbooks Deposits and Deposits under Manage Merchant center are tally. I don't understand why there is still a pop out alert.

 

ALERT! Some QuickBooks Payments deposits weren't automatically recorded. After you receive the funds in your account, record them manually as a Bank Deposit. Take action.

 

What does this mean?

JasroV
QuickBooks Team

Unmatched cash received to existing invoices.

Thank you for sharing a screenshot with me, @vaolivas051909.

 

Let me share some information on why you received the alert message "Some QuickBooks Payments deposits weren't automatically recorded. After you receive the funds in your account, record them manually as a Bank Deposit."

 

The alert usually shows if there's a problem when processing your credit cards and bank transfer with your Payment Account. Since the issue persists after following the steps provided by my colleague Adrian_A. I recommend contacting our Merchant Support team.

 

There, they can securely check your account and look deeper as to why you're still having the alert message in your dashboard. To reach them, you can refer to the link provided by MadelynC.

 

On top of this, when you're ready to reconcile the account, you can read this article that guides through the process: Reconcile an account in QuickBooks Online.

 

You can always get back to me if there's anything else you need help with. Have a good one!

Need to get in touch?

Contact us