QB online IIF file is adding check numbers for direct deposit check

I hear your sentiments, @Christine171.

Dealing with manual adjustments after importing can indeed be quite exasperating, and I understand how much of a setback this situation can be for your workflow.

The allocation of check numbers to direct deposits imported into our system has the potential to cause accounting complications. To steer clear of this situation, I've outlined a workaround that you'll find beneficial.

Here's how:

1. Prior to importing them into QuickBooks Desktop (QBDT), launch the IIF file in Excel.
2. Subsequently, under the DOCNUM column, input "DD" to direct deposit transactions.
3. Navigate to the File menu.
4. Choose Save, then Yes.
5. Exit Excel. You'll get a prompt to save the IIF again. Select Don't Save.

Additionally, feel free to take a look at our guide on exporting, importing, and modifying IIF files to gain insights: Export, import, and edit IIF files.

If you've come across errors during your attempts to import .IIF files, the subsequent resource outlines the solution: Enhanced IIF Import in QuickBooks 2019 and beyond.

Please know that I'm here to assist you should you need further guidance or support in navigating this issue or any QuickBooks-related matters. 

Again, this is a manual fix. I might as well do what I am already doing. Thanks but This is a work around and not a technical solution. 

My client just upgraded to QBDT 2024 and is having this issue.  Using QuickBooks online payroll, when importing the iif file, the desktop adds a check number to record for direct deposit employes and it's causing huge issues for accounting and reconciling due to duplicate check numbers.  The check numbers don't exist in the iif file.  QuickBooks needs to fix this issue.  You are charging a premium for this software so please support it and fix the issue.

Marilyn [removed]

Proadvisor

Hello there, Marilyn.

Know it isn't the experience we want you and your clients to have when using QuickBooks Desktop (QBDT). We recognize the importance of this matter and that we want to make sure this issue gets addressed. In this situation, we recommend contacting our Customer Care Team so they can gather more details and determine the root cause of this problem. We'll write down the steps to get you going:

1. Open QuickBooks.
2. Go to Help, then select QuickBooks Desktop Help/Contact Us.
3. Select Contact Us.
4. Give a brief description of your issue, then select Continue.
5. Sign in to your Intuit account and select Continue and then Continue with my account.
6. We'll email you a single use code. Enter your code and select Continue.
7. Choose chat with us or Have us call you.

For more details about the support availability, please see this page: Contact QuickBooks Desktop support.

On the other hand, we got this article to help you learn more about importing and exporting data into QBDT and help you secure a backup copy in case you encounter any error when using the program:

• Export, import, and edit IIF files.
• Back up your QuickBooks Desktop company file.

We value your time reaching out here in the Community space. Know we're always ready to assist if you need help importing files or managing data inside the program. Feel free to visit us anytime so we can help you out again. Keep safe.

Going back to what Marilyn said - we PAY for a premium service... why should WE contact support to request a fix it when she just did?  Don't you get paid by this premium service?

We recommend reaching out to our support team to further investigate this issue. Let me elaborate on this matter.

Our customers are encouraged to contact our support team for any issues that require further examination. Certain concerns necessitate the expertise of our support team to thoroughly investigate the details and conduct a review, ultimately providing a resolution.

We understand the urgency of addressing this matter promptly. If you have any inquiries, please feel free to respond below. We are available and prepared to assist.

Instead of jumping through all these hoops I figured out that if you add a dummy check onto the check register with a number of DD1 with the date of your payroll, the direct deposits will be added using this number and adding sequentially to it so as to not duplicate your printed stock (bank) check numbers.  Then you can just delete the dummy check once you've imported.  It's a lot fewer steps and works every time.