Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
SSLOG
June 29, 2022
Question

Customer Transaction List is Incomplete

  • June 29, 2022
  • 1 reply
  • 19 views

I am new, using QuickBooks online and my bank account automatically feeds to QB.

 

For each deposit we made at the bank (=sales revenue), once it showed up in QB in the 'for review' category of transactions, I categorized it with the correct customer name/category, and/or for a deposit representing multiple customer payments, I split the transaction and listed by line item each customer's name, category of sales, and amount received/paid. (I did not go back and enter the outstanding invoices previously created into QB before I made the deposits at the bank.)

 

When I go to my customer list, and click on a customer, and then select the 'all transactions' tab, the report does not include any of the revenue received this way. It only shows revenue that was matched to an invoice. 

 

Is there a solution for this?

 

If I need to go back and enter all/historical invoices, how do I then match them to the revenue that was already deposited at the bank and categorized in QB?

 

Thank you!

1 reply

JoesemM
JoesemMQuickBooks Team
QuickBooks Team
June 29, 2022

Thanks for joining the Community space, @SSLOG.

 

When you're unable to see all of your customer transactions, it's possible that it was filtered on a different type or deleted. To display the sales transactions, let's make sure to select All transactions from the Type drop-down list and All dates in the Dates column.

 

  1. On the left panel, click Sales > Customers.
  2. Select the customer's name and click the Transaction List tab.
  3. Hit the Filter drop-down and choose All transactions from the Type drop-down menu and All dates in the Dates column.
  4. Click Apply. 

 

However, if you're still unable to see all of the transactions, let's isolate this unexpected behavior by accessing your QuickBooks Online account using a private or incognito window. This way, we can see if this is a web browser-related issue. You can use any of these keyboard shortcuts:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P

 

Once logged in, you can try viewing your Customers list again. If you're able to view all of your sales transactions for each customer, I'd recommend clearing your regular browser's cache. Also, you can use other web browsers. 

 

You can also go to the Reports page and run the Transaction List by Customer. This will display all of your transactions (income and expenses), grouped by customer. 

 

I'm sharing these articles to see other reports and how to customize them:

 

 

Please keep me posted on how things go after trying out the suggestions I've provided. I’ll be around to help you through. Take care and have a great week!

S
SSLOGAuthor
June 29, 2022

Thank you for your reply.

I did ensure I searched for all transactions/all dates, still missing any sales without an invoice attached.

I used a private browsing window, same result.

I also tried the report you suggested "Sales by Customer Detail" and still the only transactions for any customer are those with an invoice number.

 

I am worried I need to go back and enter all our historical invoices. This is not an impossible task because there are  fewer than 100 I would need to enter. However (1) I am concerned about why the system is not rolling all this customer data together and (2) IF I did all that data entry, how would I then match them to prior deposits? Would I be required to search/find and 'undo' all deposits without an invoice, and then match them?

Thank you !

G
GebelAlainaMQuickBooks Team
QuickBooks Team
June 29, 2022

I know how you feel right now if I'm in your case, @SSLOG. I'm here to help you. 

I'd also appreciate you for following the troubleshooting process provided by my colleague.

Yes, I agree with you. It's more likely that you'll need to undo all the bank deposits that haven't matched. Proceed to match it with the existing invoice in QuickBooks Online. Let me guide you with the steps provided below:
 

  1. Go to the Banking.
  2. Select tile for the bank or credit card account you downloaded the transaction from.
  3. From the Categorized tab.
  4. Locate the transaction you want to unmatch.
  5. The click the blue transaction link in the Added or Matched column to see the matched transaction.
  6. Then select Undo from the Action column.
     

You can check out this article for more details: Unmatch downloaded bank transactions or move them to another account.

After that, you can match it to the existing transaction. Please refer to this article for the detailed steps: Categorize and match online bank transactions in QuickBooks Online.

Moreover, In case you ready to review your accounts in QuickBooks to make sure they match your bank and credit card statements. I'll be sharing you this article: Reconcile an account in QuickBooks Online.

Let me know if you have any other concerns or if you have clarification about the process. I'll be here to help you anytime. All the best to you and your business!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement