cancel
Showing results for 
Search instead for 
Did you mean: 
Alibi69
Level 1

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

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. 

2 Comments 2
Ryan_M
Moderator

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

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:

  1. Sign in to your QBDT company as an admin. (Ensure you're in Single-user Mode)
  2. Go to the File menu.
  3. Select Utilities.
  4. Highlight Import, then choose IIF Files.
  5. Locate the IIF file you want to import, then tap Open.
  6. 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. 

Fiat Lux - ASIA
Level 15

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

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us