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

matching invoices that are imported through AccountingLink to payments made thru my Credit Card terminal that are downloaded to my bank register.

Hello Everyone, first time asking a question.

 

So my system is setup with NAPATRACS that records my invoices including costs of part and labor and sales tax. I downloaded AccountingLink which exports those invoices and payments to my QBO. In QBO I download my bank register and see grouped payments coming from my credit card machine that we use to process credit cards that goes directly into the bank acct. I want to match multiple imported Invoices to the downloaded deposits from my credit card machine. How? And when I manually match Multiple invoices together to match the deposit amount and make them a bank deposit, it creates a new deposit along side the downloaded one from the bank. do i need to do this for all of them and exclude the deposits that get downloaded from the bank so they don't keep showing up every time I update it?

Hopefully you can follow my train of thought, Thank you.

1 Comment
QuickBooks Team

matching invoices that are imported through AccountingLink to payments made thru my Credit Card terminal that are downloaded to my bank register.

Welcome to Community, @AutoRepairShop.

 

I have some information about how to match your downloaded transactions with multiple invoices. You'll only need to match the transactions that are already in your register (imported invoices). Then, exclude downloaded deposits to avoid duplicate records. Let's go to your banking page to see it.

 

  1. Go to the Banking menu, and then hit the Banking tab.
  2. If QuickBooks has found a possible match for the bank transaction, QuickBooks displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
  3. Tick the boxes next to the transaction and then Accept.
  4. For multiple invoices, click the deposit transaction and then tap the Find match radio-button. This will open the Match transactions page where you can choose the transactions to match.
  5. For duplicate records, mark the box next to the transaction and then choose Exclude.

The screenshots below will show you how it looks like.

 

 

For details about matching downloaded transactions, check out these guides:

 

Additionally, you can set up a bank rule to automatically categorise your transactions. Please refer to this article for the steps: Setup bank rules to categorise online banking transactions in QuickBooks Online.

 

If you need help with other banking tasks, click this link to go to our general banking topics with articles.

 

Feel welcome to message me anytime if you still have questions or concerns. I'm always here to help. Take care and have a lovely day ahead.

Need to get in touch?

Contact us