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

How to copy and paste General Journal entries from MS Excel to Quick Books

For Checks I have seen option "Batch Enter Transactions", where bulk entries can be posted at once, similar to that is any way to post JE, through google search I have come across Quick Books IIF format import and some third party paid tools for import and export of JE, instead is there any other way.

 

I opened a entered JE in QB and selected Transaction Journal and extracted it as Excel report, thought of importing it into QB with new data but could not find a way.

 

 

6 Comments 6
FritzF
Moderator

How to copy and paste General Journal entries from MS Excel to Quick Books

Welcome back to the Community, @RAVIKARRA.

 

To get the General Journal Entries from the Excel to QuickBooks Desktop (QBDT), you can import them as Intuit Interchange Format (IIF) files. The steps to do this are pretty quick. Before doing so, make sure to create a backup of your company file.

 

Once done, here's how to import IIF files:

 

  1. Sign in to QBDT as an admin, then go to the File menu at the top to Switch to Single-User Mode.
  2. Once done, go back to the File menu to get to the Utilities and Import.
  3. Choose Import IIF Files, then locate the file. 
  4. Tick Open and OK to confirm.

 

To learn more about the process such as the limitations, consider checking out this article: Export, import, and edit IIF files.

 

Reach out to me in the comment section if you have any other issues or concerns. I'm always here to assist. Have a wonderful rest of the day!

BigRedConsulting
Community Champion

How to copy and paste General Journal entries from MS Excel to Quick Books

If you won't want to learn to write your own IIF files, use our BRC IIF Transaction Creator  to create them from your worksheet data.  It creates IIF files tailored to your company file for reliable importing.

Fiat Lux - ASIA
Level 15

How to copy and paste General Journal entries from MS Excel to Quick Books

leeq
Level 1

How to copy and paste General Journal entries from MS Excel to Quick Books

How do you form an IIF file from excel?  I know the steps to import an IIF file, but I was wondering if you can have a journal entry in excel, then copy paste it to the "make general journal entries".

AileneA
QuickBooks Team

How to copy and paste General Journal entries from MS Excel to Quick Books

Hello, leeq. 

 

Yes, you're able to import lists and transactions using MS Excel, CSV, and IIF file formats into QuickBooks Desktop (QBDT). Here are the following list you can perform to process the transaction:

  • Chart of Accounts
  • Employees
  • Vendor Types
  • Items
  • Account beginning balances
  • Cash sales to customers
  • General journal entries 

 

For the complete tally of lists and transactions that you can import to QBDT, I'd recommend checking out this article: Import and export data in QuickBooks Desktop (Lists and Transactions you can import drop-down). It also includes helpful links on ways to import info in QuickBooks. 

 

You'll first have to install the QuickBooks Import Excel and CSV toolkit to import the list in the CSV format. Before doing so, please know that you can't undo the info you import. You should make a backup just in case. Whenever you're ready, here's how:

  1. Open the file download window for the toolkit, then select Save.
  2. Go to your Windows Desktop, then select Save.
  3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Select Browse, choose the folder where you want to install the toolkit (such as your Desktop), then OK.
  5. Click Unzip to extract the contents, and then select Close to close the WinZip Self-Extractor window.
  6. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4. 

Feel free to mention me in the comment section if you have more file management concerns. I'm here to back you up always. Stay safe and have a great day!

Fiat Lux - ASIA
Level 15

How to copy and paste General Journal entries from MS Excel to Quick Books

@leeq 

Prepare the JE data with the following template

RefNumberTransaction DateAccountDebit Credit MemoNameClassBillableIs AdjustmentCurrencyExchange RateHome Currency AdjustmentAmounts in Home Currency
127/09/2020Checking  130PR 092518John Smith NN    
127/09/2020Wages200 PR 092518John Smith NN    
127/09/2020Payroll Taxes Payable 50PR 092518John Smith NN    
127/09/2020Health Insurance Payable 20PR 092518John Smith NN    

 

then utilize one of the importer tools as I mentioned earlier.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up