Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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 😊
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!
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?
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:
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!
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?
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.
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?
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here