Entering Batch Tranactions and Cutting and Pasting

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:

1. From the Accountant menu, choose Batch Enter Transactions.
2. Select the appropriate Transaction Type and Account.
3. Open the spreadsheet containing the transactions you need to record in QuickBooks Desktop. Arrange the columns in your spreadsheet to match the order of the columns in the Batch Enter Transactions window.
4. Highlight the information, right-click, then tap Copy.
5. On the Batch Enter Transactions window, right-click the first date field and press Paste. Details will turn red if they are currently not listed in the company file. Select the detail in red and tap Quick Add or Set Up.

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.