Skip to main content
August 31, 2021
Question

Hi I have just realised after 5 months that quickbooks is counting my bank transaction labelled as sales, and my paid invoices which were services as separate transactio

  • August 31, 2021
  • 1 reply
  • 0 views
So where I would have 30k or so in sales I have 65k in income. I need to exclude one or the other I would rather keep my bank account linked and categories as sales for purposes of profit and loss, but I have to send invoices and receipts to customers for their benefit they dont have to go into my profit and loss report which they seem to be along side sales in my bank ( which is the customer paying ) which then doubles the apparent income

1 reply

KlentB
August 31, 2021

I'll help you fix this, userlp.

 

Once you connect your bank account, your transactions will be downloaded in the For Review tab. After that, you would need to match the downloaded transaction with the one you already entered into the program. This way, you'll be able to link them together and avoid duplicates.

 

To correct your financial reports, you'll have to undo the categorized transactions and match them to the existing ones. Here's how:

 

  1. Select Banking or Transactions from the sidebar menu.
  2. Go to the Banking tab, then choose the appropriate bank account.
  3. Click the Categorized tab, then find sales transactions.
  4. Select Undo from the Action column, then head back to the For Review tab.
  5. Click the transactions, then click them to expand the view.
  6. Choose the Find Match option, then review the matching records found in QuickBooks.
  7. Select the matching invoice or sales receipt for this payment, then hit Save.

In addition, here are some references that you can visit to learn how to speed up the categorization process of your online banking transactions:

 

I'm just a post away if you have any other concerns or further questions about how bank feeds works in QuickBooks. Have a great rest of the day.