cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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? 

3 Comments
Highlighted
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.  

 

exp.6.PNG

 exp.7.PNG

 

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.

Highlighted
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?

Highlighted
Moderator

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!

Need to get in touch?

Contact us