Lockbox Bank Deposit Upload

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: 

1. On the left pane click Banking menu and choose Banking. 
2. Choose Upload transaction manually. 
3. Click Browse and upload a transaction from CSV file. 
4. Tap Next. 
5. Drop-down arrow select the Account type, or click the + Add new. 
6. Hit Next.
7. Fill out the field from the pop up message. 
8. Click Save and Close. 
9. Map the CSV columns, tap Next.

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:

• Connect your bank account ti QuickBooks Online
• Import a CSV file from your bank to 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!