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:
- Prior to importing them into QuickBooks Desktop (QBDT), launch the IIF file in Excel.
- Subsequently, under the DOCNUM column, input "DD" to direct deposit transactions.
- Navigate to the File menu.
- Choose Save, then Yes.
- 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.
