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
  • 1 view

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
August 11, 2022

Thank you. My file isn't corrupted. I tried with a sample file and it produces the same issue. 

Additionally, per support on the phone I uninstalled QB and reinstalled a new fresh version. Same problem.


@GingerAccounting 

Consider using the trial version of an importer tool to isolate the problem.