Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
August 10, 2022
Question

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

  • August 10, 2022
  • 1 reply
  • 3 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

Level 9
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. 

August 10, 2022

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

Fiat Lux - ASIA
Level 14
February 15, 2023

I have the same problem. Is the only solution to pay for a 3rd part app to help import into QuickBooks Desktop Enterprise?


@Kristi Bob 

The importer tool is only to isolate the problem. If the same error persists, it means that your company file is corrupted. You may need to purchase a 3rd party file repair service.