Connect with and learn from others in the QuickBooks Community.
Join nowOur company receives a CSV file from our bank for the lockbox each day. We then individual type in the invoice number to "Receive Payment" and then type the check number. This is an incredibly manual process, but there doesn't seem to be a way to upload this report to receive payments for multiple invoices at a time. Has anyone found a way to upload this report as a batch payment of some kind?
Hi there, @mharmening.
Thank you for reaching out to the Community. You can manually upload the file using CSV and match it to the invoice. Let me walk you through how:
Once done, you can check all the transactions uploaded under for Review.
If you don't want to connect your bank, you manually upload the transactions to QuickBooks Online.
Once done, we can now match and categorize your bank transactions.
That's it. This should help you point in the right direction. Let me know if you have further questions. I'll be here to answer them.
So, I think there may be a potential issue with this though. Our lockbox deposit comes through automatically as one line item in our banking transactions. So if I also upload the CSV, it would be counting it twice, correct?
Thanks for getting back with additional queries, mharmening.
You have two options to bring your bank transactions in QuickBooks Online:
These options are already provided by my colleague AileneA. I'll further explain these options before I answer your question with a Yes or No.
The first option downloads your cleared bank transactions to QuickBooks Online automatically. Hence, it will provide a real-time update of your bank balance which you can compare it to QuickBooks. Also, it is not necessary to import the CSV if you have already connected your bank.
The second option applies if you can't or don't want to connect your bank to QuickBooks Online. Since your bank already provided the CSV file, you can import it and manage the bank transactions.
Regardless of which option you choose, you still need to categorize the transactions before it hits your QuickBooks bank register. Hence, it doesn't automatically cause duplicates.
You can select Add if the transaction is not yet recorded in QuickBooks. Otherwise, you can exclude them to avoid duplicates in your register.
Meanwhile, you can select Match if the transactions are already recorded in QuickBooks. You can also use the Find a match option to manually look for the transaction.
For more details about how to manage your bank transactions, you can refer to this article: Match and categorize bank transactions in QuickBooks Online.
Now, the answer to your question is No. Uploading the CSV won't cause duplicates as long as you categorize the bank transactions correctly. If you know that the transaction (from CSV) is already recorded in QBO, you can Exclude it. Another option is to Match those transactions.
The detailed steps to Add, Match, Transfer, or Exclude the bank transactions are included in the articles I've provided above.
We're always here if you have clarifications about your queries. Please let us know if you have additional one. We'll be glad to help you more. Have a great day!
We have two different banks that we work with that can send us lockbox files in CSV format. I want to be able to import the file into QBO to post against open invoices. The invoices are not tied to a specific bank account so I need to just post/match the invoices against payments.
The bank connection is for credits and debits from my accounts... the lockbox file is a listing of paid invoices... the credit to my bank account for $1,000 may be one invoice or three invoices... I want to be able to import the file of paid invoices and not have to select a bank as this file has nothing to do with the bank deposit.
I'm here to help import your paid invoices in QuickBooks Online (QBO), @npicard71.
At this time, there's no direct way to import paid invoices into QBO. You may consider looking for a third-party application that can help you accomplish this. Here's how:
If you need further information on the selected application, you can contact their customer support team.
For your future reference, you might want to review all your sales transactions in QBO. Here's an article you can read for more guidance: View sales transactions.
It's nice working with you, @npicard71. Please know that I'm just a reply away if you need any further assistance importing transactions in QBO.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.