Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
G
GingerAccounting
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

C
Charies_M
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. 

G
GingerAccountingAuthor
August 10, 2022

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

P
PorchLightHomesINC
March 8, 2023

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


Hello There, I have downloaded a 3rd party importer(Transaction Pro). The importer is able to import into QuickBooks but I still cannot Paste into the Batch Entry. Any ideas on what to do from here? Thank you in advance.

 

Backstory:

I am also having trouble with Pasting into QuickBooks. I have QuickBooks Enterprise Solutions 21.0 Desktop and have been trying to import my Batch transactions from a Spreadsheet to QuickBooks. I copy my data from the spreadsheet, open the Batch Enter Transactions, and when I try to paste the data, it attempts to enter it all into the first cell. When I test the data by Pasting into something else such as Notepad, it comes out perfect.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement