Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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
RefNumber | Deposit to Account | Transaction Date | Deposit Memo | Received From | From Account | Memo | Chk No. | Payment Method | Class | Amount | Currency | Exchange Rate |
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Janie Smith | Construction Income | Monthly | 125 | Check | 15 | |||
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Johnny Jones | Construction Income | Monthly | 302 | Check | 15 | |||
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Charlie Mac | Construction Income | Monthly | 418 | Check | 15 |
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:
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.
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
RefNumber | Deposit to Account | Transaction Date | Deposit Memo | Received From | From Account | Memo | Chk No. | Payment Method | Class | Amount | Currency | Exchange Rate |
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Janie Smith | Construction Income | Monthly | 125 | Check | 15 | |||
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Johnny Jones | Construction Income | Monthly | 302 | Check | 15 | |||
1 | Checking | 01/10/2020 | 10/1/2020 Daily Deposit | Charlie Mac | Construction Income | Monthly | 418 | Check | 15 |
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here