Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a thousand transactions in more than one Bank Feed to enter into the appropriate registers. Each transaction needs to be pegged to an account in the Chart of Accounts. Doing this one by one will take weeks. Is there another way to proceed?
I don't know of any way to have QB automatically assign accounts to transactions that are for new payee names.
I'd think I could record two or three transactions a minute, and if so that would take far less than weeks.
It's my priority for you to categorize the downloaded bank transactions with the right account in QuickBooks Desktop, Joseph_N.
In QuickBooks Desktop, we can create rules to categorize transactions for things you often spend money on, like supplies or business expenses. If you are using an Express Mode, just follow the steps below:
You can also create Bank Feeds rules automatically by following the steps below:
If you have multiple transactions with the same criteria, you’ll receive a Rules Creation message. You can ignore or edit the rule. If you are using Advanced Mode, just follow the steps and details in this article: Create rules to categorize transactions in QuickBooks Desktop. From there, you can also create a rule directly on the transactions. Then, try downloading bank feed transactions again in QuickBooks Desktop.
For the duplicate transactions downloaded earlier, we can remove duplicate transactions from your bank feed. Here's an article you can refer to for more insights about removing duplicate transactions in QuickBooks Desktop. Before doing so, just create a backup copy if you ever run into problems so we can use your backup to restore your data.
Feel free to visit our Banking page for more insights about bank feeds and reconciling accounts.
Do you need more help completing other tasks in QuickBooks? Please let me know and I'll assist you with some guides and other pointers. Have a great day.
You can prepare your Deposit data with the following template
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 |
then utilize one of these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
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