Inputting Year's Worth of Data to Create P&Lfit &

Forum|Forum|5 years ago
May 24, 2021
2 replies
21 views

I need to input an entire Year's Data so that I can run a Profit and Loss statement. Data was NOT recorded in QB as it occurred. What is most direct way to input all income and expenses from notes and totals now existing created from bank statements? Time is critical, of course. Thank you.

QuickBooks Desktop

Ryan_M

Moderator

Hi @Alibi69,

I've got you covered, and answer this question for you.

You can use the Intuit Interchange Format (IIF) files to import the necessary data, in bulk, to run a Profit and Loss statement in QuickBooks Desktop (QBDT).

If you're not familiar with this type of file, see this article: IIF Overview: import kit, sample files, and headers. It has a list of sample files that you can download and use to import your company data in QBDT.

Before proceeding with the upload, I suggest you backup your company file. When you're ready to proceed, follow these steps:

Sign in to your QBDT company as an admin. (Ensure you're in Single-user Mode)
Go to the File menu.
Select Utilities.
Highlight Import, then choose IIF Files.
Locate the IIF file you want to import, then tap Open.
Press OK to confirm.

To see a complete list of what you can import and export using IIF files, check out this article: Export, import, and edit IIF files.

Tag me in the comments below if you have other questions about the import process in QBDT. I'll get back to you as soon as I can.