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 <Enter Batch Transactions> to cut and paste check #, date, Payee and amount. If I enterred these individually in <Batch Tranactions> once I type in the Payee QB will remember what the usual account is that is associated with that Payee and Populate the account field automatically. However, because I am cutting and pasting this doesn't happen. I am in Enterprise 20.
I have found that if after pasting into Batch Transactions, I can go to the payee field and cut the payee and paste it into the same field and the Account field will then populate. However, this will only work in the top 2 rows and stops working after that.
So I need help with the above or a work around.
Hello there, @MJB212.
Let me share some information about entering transactions by batch. I'll make sure you'll be able to add details by cutting and pasting.
I understand how time-consuming it is to enter the details manually. Since you can't continue what's working until the second row, let's perform some troubleshooting steps. I believe running a rebuild and verify on your file is one of the steps to resolve this.
Here's how:
1. From the File menu, click on Utilities.
2. Select Rebuild Data.
3. Go back to Step 1, then choose Verify Data.
For your reference, here is an article that can further guide you on troubleshooting data damage within your file: Resolve data damage on your company file.
Then, you can enter transactions by batch. Refer to this article: Enter multiple transactions QuickBooks Desktop.
Additionally, check on this article to guide you if you'll have damaged transitions: Fix damaged transactions in QuickBooks Desktop.
If you have more questions about transactions, I'm always here to help you. Have a great day.
I did not see my reply from ealier today. SO if this is a dupliate I apologize. My data is fine and no errors. I can usually cut and paste just fine in QB. However, this time I want QB to add in the "usual" account when I cut and past the vendors Names in the Batch Transactions: Such as if I enter
AAA Exterminating as the Payee - I want QB to know that that is Repairs and Maintenance - and as such add it in to the corresponding column Just like it would if I typed in AAA Exterminating into that field.
Can QB not do this or am I missing a step?
Thanks for coming back, MJB212.
Once you copy and paste the vendor name or account, it will only match the data you have in the QuickBooks Desktop. The details will turn red if they are currently not listed in the company file. We'll need to select the detail in red and tap Quick Add or Set Up to enter it in the corresponding column under Payee and Account. To enter transactions by batch, just follow the steps below:
To learn more about this one, see the Enter transactions by batch in QuickBooks Desktop article. Just in case you need to delete or void multiple transactions at once, follow the steps in the Batch delete or void transactions in QuickBooks Desktop Accountant Edition article.
Feel free to our Banking page for more insights about managing your bank feeds and reconciling accounts.
I'm just one post away if you need to batch print forms or any QuickBooks-related. Just reply to this post and I'll get back to you. Have a great day.
I have no problem with the function of cutting and pasting. nor do I have an issue with the Payee turning red if it is not already in the system.
My question has always been: If I cut and paste a list of Payees in the system. I would only be entering the check #, date, payee and amount.
how can I get QB to populate the Account field, on its own, using each Vendors Usual Account perferences.
Quickbook will use the vendor's account preference when I type it individually
If I type that Payee's name instead of cutting and pasting. QB will populate the account field with the "usual or Last or Only" account used for that Payee. However, I currently have to go back and individually add the accounts which involves me remembering what account it is usually coded to. QB already knows this information.
A possible work around would be :
I can use bank download to enter the Payees names and QB will populate the Accounts automatically. But the check dates would all be incorrect and I would need an easy was to Adjust the check dates (without doing it individually)
So, is there a way to batch edit a group of checks. For instance, Checks #100 to Check #200 - change the date to 8/1/2021 by cutting & pasting.
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