Showing results for 
Search instead for 
Did you mean: 
Level 1

Lockbox Bank Deposit Upload

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? 

5 Comments 5
QuickBooks Team

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.


exp..PNG exp.1(1).PNG exp.2.PNG exp.3.PNG exp.4.PNG exp.5.PNG


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.

Level 1

Lockbox Bank Deposit Upload

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?


Lockbox Bank Deposit Upload

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!

Level 1

Lockbox Bank Deposit Upload

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. 

QuickBooks Team

Lockbox Bank Deposit Upload

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:


  1. Sign in to your QBO account.
  2. Click Apps from the left menu.
  3. In the Find Apps tab, search for an app that can import your paid invoices.
  4. Select the app and click Get app now.


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.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up