cancel
Showing results for 
Search instead for 
Did you mean: 
bjamwal
Level 1

Income report, Sales and Uncategorized income double counting

Hi

When i pull the report, I see that Sales is counting all the invoices correct but then i have categorized all the payment received and its double counting my income.

 

 

3 Comments 3
ChristineJoieR
QuickBooks Team

Income report, Sales and Uncategorized income double counting

Let me help you remove the duplicates, @bjamwal.


 
If you downloaded your bank transaction, QuickBooks Online has option to undo and match and delete transactions under Banking tab.  
 


If you’ve matched a downloaded transaction and need to unmatch it:

 

 

  1. Choose Transactions > Banking.
  2. Make sure the correct account “card” (at the top of the page) is selected.
  3. Click the In Quickbooks tab.
  4. Find and select the downloaded transaction you want to unmatch. Tip: to find your transaction more easily, click a column header to sort up or down by amount, date, description, and so on.
  5. Click the Undo button in the Action column.

You can unmatch many transactions at once by checking the box to the left of each one. From the Batch actions drop-down menu, choose Undo.

 


The transaction is returned to the New Transactions page after it has been downloaded. The matching QuickBooks transactions, whether single or several, are now available to match, add, or exclude.
 
You can also remove a transaction from the register by unmatching it.

 

  1. Choose Transactions > Chart of Accounts
  2. In the row of the appropriate account, click View Register.
  3. Find the transaction and click it in the register.
  4. Click Edit.
  5. At the top of the transaction, click Online banking matches.
  6. Click Unmatch.
  7. The downloaded transaction moves back to the New Transactions tab.

 

You can delete a matching transaction from the register if you want to.

 

  1. Choose Transactions > Chart of Accounts.
  2. In the row of the appropriate account, click View Register.
  3. Click to highlight the unwanted transaction and then click the Delete button to the bottom right of the transaction line.
  4. Click Delete Both to delete the transaction, as well as the downloaded transaction from the bank and it will not show in the downloaded transaction area to be rematched.

 


NOTE: A transaction can also be erased by selecting it on the Register, choosing Edit, and then selecting More > Delete. To confirm, select Yes. When a matching transaction is erased this manner, both the transaction and the downloaded transaction are deleted, and the downloaded transaction area is no longer visible.
 

 

Check out these articles for future reference:

 


Please let me know if you require anything else. I'm always willing to assist on the Community forum.

bjamwal
Level 1

Income report, Sales and Uncategorized income double counting

Hi

When i go to transactions, I don't get chart of accounts.

Also, when i go to transactions -> banking -> I don't see the options / tabs you mentioned.

 

Regards

 

 

 

ZackE
Moderator

Income report, Sales and Uncategorized income double counting

Thanks for following up with the Community, bjamwal.
 

Your chart of accounts screen can be found in the Accounting section of your left navigation bar.
 

I've included an image showing where to find it:


I can also provide clarification on the steps provided by ChristineJoieR to unmatch downloaded transactions:

  1. To unmatch your transactions, you'll need to go to Banking in the left navigation bar. Once you're there, make sure you're on the Banking screen.
  2. Find the account you're working with and click it to make sure its selected. The displayed account will be highlighted in blue instead of gray.
  3. Find the transaction you want to unmatch. You can utilize your available drop-down lists to specify a date range or sort by different statuses.
  4. Once you've found the appropriate record, select Undo under its ACTION column.


If you need to unmatch multiple records at one time, you can use their checkbox column to specify which ones you're working with, then choose Undo.


I've also included a detailed resource about working with the chart of accounts screen which may come in handy moving forward: Learn about the chart of accounts
 

If there's any additional questions, I'm just a post away. Have a lovely day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us