Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
I
ikzpeds
February 21, 2020
Solved

Importing bank deposits

  • February 21, 2020
  • 2 replies
  • 4 views

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

Best answer by Fiat Lux - ASIA

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  

 

2 replies

JenoP
JenoPQuickBooks Team
QuickBooks Team
February 21, 2020

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. 

I
ikzpedsAuthor
February 26, 2020

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.

R
RCVQuickBooks Team
QuickBooks Team
February 26, 2020

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.

Fiat Lux - ASIA
Fiat Lux - ASIAAnswer
Level 14
February 22, 2020

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  

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement