Novice with question about Batch Enter Transactions

I run QB Accountant 2018. I often download my bank statements as an Excel file (.xls), and then edit that file as needed to prepare it for batch entry of transactions into QB. It generally works very well with only one significant problem: After I have copied the Excel file I want to load into QB and then pasted it into the Batch Enter Transactions window appropriate for that particular account, and appropriate for the kind of transaction(s) being loaded (checks, or deposits or whatever) it is common for me to find a number of records displayed in red type and the warning that the "text is not valid for that field" or similar language-- for the PAYOR, the PAYEE, or the ACCOUNT. Sometimes for both ACCOUNT and either Payor or Payee depending on the transaction being a debit or credit.

I try to be careful to make the column for the payor or payee in my Excel file, before I paste into the Batch Enter Transactions window, to use exactly the same name as that used in my list of customers or vendors. (Same spelling, punctuation if any, and upper or lower case characters consistent between the two). For the account column, I try similarly to use in the Excel file exactly the name of the QB account, pasted from QB's list of Vendors or Customers into the Excel file.  Despite doing so, unpredictably I will get the red lettering and the warning that the Payor or Payee is "not in the Names list" and the offer to set that up as a Quick Add or more formally. For the Account column, I sometimes (not consistently) have the experience of being told "That name is already in use" and that I must use a different name for the account. I usually opt just to add a single digit after the "name that is already in use" and that suffices. But sometimes the warning will recur with pasting of later statement files and results in the demand again to use a different name.

It turns out that, in a column containing multiple red-lettered entries stating "invalid text" for the Payor or Payee, sometimes just clicking on that "invalid text" will remove the red lettering and the text somehow is now valid-- but the click must be performed on each subsequent occurrence of the red-lettered text in question-- the change of merely the first entry from invalid to valid does not validate the same name in all subsequent entries.

After the appropriate corrections/validations have been made, the Batch Entry continues without trouble.

This problem is not catastrophic and correcting it is not enormously labor intensive as such tasks go, but I was wondering if anyone can advise me on what I'm doing wrong and how best to correct it before I even try to copy the Excel file into the Batch Enter Transactions window. Once pasted into that window, is there any way to make the correction to one name/account extend automatically to every other occurrence of that same name or same account?

Related question about this annoying need to invent new names for the accounts that I have associated with a given payor or payee. Why is this happening and can it be avoided?

Thanks so much.



Hello there, ggoodman,

I appreciate you taking time to share your experience when uploading transactions using an Excel file in QuickBooks.

When you upload a file into the Batch Enter Transaction window, you need to double check each and every single detail it contained. Every item should match with what's recorded in QuickBooks since it reads even a single space indicated in it.

Once you paste the Excel file and made sure that your spreadsheet contains all the required data that will be imported, QuickBooks will no longer be giving you invalid text and will let you upload the file smoothly.

For additional reference, you can check out this article: Enter Transactions by Batch in QuickBooks Desktop.

Please let me know how it goes and if you need further assistance in uploading transactions in QuickBooks. I'm just around if you need help.

Was this answer helpful? Yes No
IntuitRea , Community Support Specialist
Employee SuperUser

No answers have been posted

More Actions

People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Qb community
Looking for advice from other business owners?

Visit our QuickBooks Community site.