You can definitely import those invoices from Excel using IIF files, Sara.
QuickBooks Desktop uses the Intuit Interchange Format (.IIF) files to let you import or export data from different programs. Before you import the invoices, please ensure that your Excel file is already formatted to the supported file type.
This process also comes with limitations. I've got you an article that lists all of the limitations when importing Excel files into QuickBooks. Once you're all set, you can follow these steps to start the import process:
- Log in as Admin to your QuickBooks Desktop company file.
- Switch to Single User Mode.
- Click the File menu at the top left corner.
- Select Utilities, Import, and then, choose IIF Files.
- Find the IIF file that you saved, and then select it.
- Click Open.
- Click OK when you get a message to confirm that your data has been imported.
I'm always around if you need more help with this. Thanks for dropping by the Community.
