Skip to main content
G
GingerAccounting
August 10, 2022
Question

Batch enter Transactions ERROR: paste from spreadsheet is only pasting into one cell

  • August 10, 2022
  • 1 reply
  • 0 views

I am trying to paste credit card transactions from a spreadsheet to batch enter. 

I'm on a different server but I tested copying from a file on that save server.

When I paste all information is put into one cell. Please assist.

1 reply

C
Charies_M
August 10, 2022

Good thing you came here for support, GingerAccounting.

 

I can help batch enter transactions seamlessly. 

 

Since the pasted information is only put in one cell, 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.

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 transactions by batch in QuickBooks Desktop.

 

Additionally, check on this article to guide you if you'll have damaged transitions: Fix damaged transactions in QuickBooks Desktop.

 

You know where to go if you have other questions about entering bank transactions. Have a good one. 

G
GingerAccountingAuthor
August 10, 2022

I appreciate your response. I rebuilt and verified data. Same issue. 

A
AileneA
August 10, 2022

Hello, 

 

I appreciate your time in following the steps provided by my colleague.  

 

Since issue persists after verifying and rebuilding your data, Let's perform other troubleshooting steps to help you sort this out. 

 

Let's go ahead and download and install QuickBooks Tool Hub.  

 

  1. Close QuickBooks.
  2. Download the most recent version (1.5.0.0) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it (like your Downloads folder or your Windows desktop). Note: If you've installed Tool Hub before, you can find out which version you have. Select the Home tab. The version will be on the bottom.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install and agree to the terms and conditions.
  5. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.

 

For more details and other fixes once issues occur, please review this article: Fix company file and network issues with QuickBooks File Doctor. 

 

If same thing happens, I'd recommend contacting our technical support team. This way, we'll be able to look into your account setup and investigate the issue. You can connect with us through this link: Contact QuickBooks Desktop support. 

 

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.  

 

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

Terms & ConditionsAccessibility statement