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

Importing bank deposits

I am using QuickBooks 2020 Desktop. 

I tried to import direct deposit transactions from my bank account into QuickBooks. The information picked up by QuickBooks showed the payer's name under the column "Download As" and the amount of deposit. I was able to transfer the deposited amount into the right account but the payer's name under "Download As" won't show up in QuickBooks. I chatted online with a QuickBooks representative. He said it is a bank problem but QuickBooks did receive the information from the bank. How do I transfer this information together with the deposited amount?.

Solved
Best answer February 21, 2020

Best Answers
Fiat Lux - ASIA
Level 15

Importing bank deposits

As another option, utilize this tool to import Deposit data into your QBD.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

RefNumberDeposit to AccountTransaction DateDeposit MemoReceived FromFrom AccountMemoChk No.Payment MethodClassAmountCurrencyExchange Rate
1Checking01/10/202010/1/2020 Daily DepositJanie SmithConstruction IncomeMonthly125Check 15  
1Checking01/10/202010/1/2020 Daily DepositJohnny JonesConstruction IncomeMonthly302Check 15  
1Checking01/10/202010/1/2020 Daily DepositCharlie MacConstruction IncomeMonthly418Check 15  

 

View solution in original post

4 Comments 4
JenoP
Moderator

Importing bank deposits

I'll help you make sure your banking transactions are record with accurate details, ikzpeds.

 

Follow these steps on how you can add the payee's name in the correct column:

 

  1. Select a downloaded transaction in your Bank Feeds.
  2. Click the drop-down list under the Action column.
  3. Select Add More Details.
  4. Click the drop-down list for Payee and select the correct name.
  5. Enter the correct amount in the Amount column.
  6. Click Add to QuickBooks

Follow the same steps for the rest of the transactions. I'd also like share this article with you about categorizing banking transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

You can also reply or tag my name below if you need anything else. 

Fiat Lux - ASIA
Level 15

Importing bank deposits

As another option, utilize this tool to import Deposit data into your QBD.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

RefNumberDeposit to AccountTransaction DateDeposit MemoReceived FromFrom AccountMemoChk No.Payment MethodClassAmountCurrencyExchange Rate
1Checking01/10/202010/1/2020 Daily DepositJanie SmithConstruction IncomeMonthly125Check 15  
1Checking01/10/202010/1/2020 Daily DepositJohnny JonesConstruction IncomeMonthly302Check 15  
1Checking01/10/202010/1/2020 Daily DepositCharlie MacConstruction IncomeMonthly418Check 15  

 

ikzpeds
Level 1

Importing bank deposits

Hi JenoP

 

I am new and clicked on the Problem solved button by mistake. I still need help.

I followed your instruction. It did work but I could only import 1 transaction at a time. I need to import more than 500 transactions with multiple payers.

I found an icon labeled as "Rule" on the Import Transaction screen. When I opened it, there are 4 columns. The 3rd one says "leave name of payers blank". I tried to change it to see whether that makes a difference. I could not change it. I tried the icon at the bottom left for New or Edit rules. It didn't work. I would appreciate it if you can offer me a solution.

RCV
QuickBooks Team
QuickBooks Team

Importing bank deposits

Thanks for coming back, ikzpeds.

 

At this time, you can only import one transaction at a time. You'll want to try the Transaction Importer tool provided by my colleague to import batch transactions into QuickBooks.

 

On the other hand, it's possible you are in the Classic Mode settings preventing you from creating a new bank rule. Let's got to Preferences page and update it to Express Mode option.

 

Here's how:

 

  1. Click Edit on the top menu.
  2. Tick Preferences.
  3. Choose Checking.
  4. Hit Company Preferences.
  5. Select Express Mode in the Bank Feeds section.
  6. Tap OK.
  7. Press OK for the prompt message to close QuickBooks to apply the changes.

Once done, create a renaming rule for your Bank Feeds again. Just follow the steps and details in this article: Use renaming rules for Bank Feeds. Then, go to Create a renaming rule section.

 

I've got a link here where you can find articles about managing bank feeds: https://quickbooks.intuit.com/learn-support/en-us/banking/07?product=QuickBooks%20Desktop.

 

Keep me posted if you need a hand with matching/categorizing your bank transactions or any QuickBooks related. I'll be here to help.

Need to get in touch?

Contact us