Our 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?
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?
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.
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!