In certain situations, you may encounter missing checks in your payroll data that need to be imported into QuickBooks Desktop. QuickBooks Desktop, a powerful accounting software, allows you to customize your payroll imports by creating and updating Intuit Interchange Format (IIF) files. By following a few simple steps, you can streamline your import process and ensure accurate payroll records. In this article, we will guide you through the process of creating an updated IIF file that includes only the missing checks and importing it into QuickBooks Desktop.
Creating the Updated IIF File
To create the updated IIF file that includes only the missing checks, follow these steps:
Open a text editor, such as Notepad, on your computer.
Create a new blank document.
Copy and paste the following lines at the beginning of the document:
!TRNS TRNSTYPE DATE ACCNT CLASS AMOUNT NAME DOCNUM MEMO CLEAR TOPRINT
!SPL TRNSTYPE DATE ACCNT CLASS AMOUNT NAME INVITEM MEMO REIMBEXP
!ENDTRNS
Save the document with a recognizable name, such as "Missing_Checks.iif".
Make sure to add the ".iif" file extension at the end of the file name to indicate it as an IIF file.
Updating the IIF File with Missing Checks
To find and open the IIF file in a text editor, please follow these instructions:
Locate the downloaded IIF file on your computer. It is typically saved in your designated download folder or the location you specified during the download process.
Right-click on the IIF file.
From the context menu that appears, choose the option "Open With."
Select a text editor, such as Notepad or any other preferred text editing software.
The IIF file will now open in the selected text editor, displaying the contents in plain text format for editing.
Identify the missing checks that need to be included in QuickBooks Desktop.
Copy the sections of the missing checks from the original IIF file. including everything between the labels "TRNS" and "ENDTRNS" including the lables
Paste the copied sections between the lines starting with "TRNS" and ending with "ENDTRNS" in the updated IIF file.
Verify that the inserted check sections are accurate and complete.
Save the file
Importing the Updated IIF File into QuickBooks Desktop
Once you have created the updated IIF file with the missing checks, proceed with the following steps to import it into QuickBooks Desktop:
Open QuickBooks Desktop on your computer.
From the main menu, select "File" and choose "Utilities".
Click on "Import" and select "IIF Files" from the dropdown menu.
Browse to the location where you saved the updated IIF file ("Missing_Checks.iif") and select it.
Follow the on-screen prompts to complete the import process.
QuickBooks Desktop will incorporate the updated data, importing only the missing checks.
Conclusion
By creating an updated IIF file that includes only the missing checks and importing it into QuickBooks Desktop, you can streamline your payroll import process and maintain accurate payroll records. Create a new IIF file, starting with the provided headers, and update it by adding the missing check sections copied from the original IIF file. Then, import the updated IIF file into QuickBooks Desktop to include the missing checks in your payroll records.
It is essential to note that this process is specifically for importing missing checks into QuickBooks Desktop and should not include previously imported payroll totals. By following the steps outlined in this article, you can efficiently customize your payroll imports, import the necessary missing checks, and ensure accurate and up-to-date payroll data within QuickBooks Desktop.
Thank you for using Fingercheck. If you have any questions on this article's topic, you can reach out to our team at 1-800-610-9501, or use the chat option below.