Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Transaction Report Doubling invoice and deposits

Hello everyone,

 

We are new to book keeping on a large scale and are running into some issues. When pulling a transaction report, it is adding both our invoices and bank deposits as income. We run Square for all of our transactions unless someone pays cash. For example, on a day we made $355, and after Square fees it was $344. But the problem is that Quickbooks is adding both of those as income ($699 total income). It is nearly doubling our total profits for the entire year and we are not sure what happened. Is there a way for our transactions to show just our bank deposits and not include the invoice totals? Thank you all in advance for your help!

1 Comment
QuickBooks Team

Transaction Report Doubling invoice and deposits

Hello Backcountrysands!

 

I'll guide you in handling your square invoices and bank transactions.

 

Square sales are imported as invoices and the customer payments are imported as payments. The payments are the matching entries to the bank transactions. To avoid doubling up your sales income, you'll want to match the bank transactions with their corresponding square payments.

 

Right now, you can undo your bank transactions to bring them back to the For Review tab. Then, find a matching payment for each transaction and match them.

  1. Go to the Banking menu or Transactions menu.
  2. Go to the Banking tab.
  3. Select tile for the bank or credit card account you downloaded the transaction from.
  4. Select the Categorized tab.
  5. Find the transaction you want to undo and click Undo.

If you have bank rules that auto-adds your bank transactions, you may disable them as of the moment until you're comfortable using them in the future.

 

Let me know if you have more questions in mind.

Need to get in touch?

Contact us