Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Let's make sure you'll be able to import your file, tjalves.
You can use the Intuit Interchange Format (.IIF) to import or export files in QuickBooks Desktop. Here's how you can do it:
Don't hesitate to post again if you have any questions about QuickBooks.
How do I tell Quickbooks which account to import the file into ? I am trying to import checks from Intuit Payroll on line but when it imports the check it creates a new account to put it into.
Hi there, @Harolddds.
Thanks for joining this conversation. Allow me to chime in and share information about importing checks in QuickBooks.
Are you trying to import the checks to QuickBooks Desktop (QBDT) too? If so, you can choose the accounts for each wage expense or liability upon setting up your Export preference.
Here's how to do it:
For further guidance on how to go about the process, you can check out this article: Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll.
You may also visit our website for more tips and other resources: Self-help articles.
Please post again or leave a comment if you need more help with importing payroll or anything else. I'll be here to help.
How does the .llf file have to be formatted? I’m using a 3rd party payroll provider and they’re requesting the format of the imported payroll data?
I know how important it is to import your payroll information, High end. I'm here to share some insights.
Currently, the option to import payroll data is unavailable. In QuickBooks Desktop, we can only import IIF files like your bank transactions, journal entries, and more. You can also import lists like your customer, vendor, and employee lists.
As a workaround, you may consider using a third-party application to import your payroll data. To do so, I'd recommend visiting our QuickBooks Apps page.
Additionally, you can import the checks as standard-type transactions in QuickBooks. You can use the IIF file format as a sample. This way, you can make sure the data are placed in the correct field.
Please come back and keep us posted on your progress in searching for the app that suits your needs. I'm determined to get this resolved.
Which file formats does your payroll provider offer? .csv or .xls?
Do I need to change my Excel file to, Intuit Interchange Format (.IIF) first? If so how do I do that?
Hi there, @222Rebecca.
Thanks for following along with the thread and sharing your concerns.
Depending on what information you're trying to import, you can import Excel files into QuickBooks Desktop. You can import Customer, Vendor, Items, and Chart of Accounts from an Excel spreadsheet. There are several options available when importing Excel files from QuickBooks.
For additional information about importing Excel data, check out Import or Export MS Excel files.
However, if you're looking to import other data, then yes, you'd need to convert your files into IIF format or use another format type. To do this, you may consider using a third-party application to import your data. To do so, I'd recommend visiting our QuickBooks Apps page.
Please let me know if you have any questions or concerns. Take care, and have a wonderful day!
Another option, utilize one of these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here