1. Home
  2. Cloud
  3. How to Export data to Import Journal Entry into QuickBooks Desktop
  1. Home
  2. The Uniform Solution eCommerce
  3. How to Export data to Import Journal Entry into QuickBooks Desktop

How to Export data to Import Journal Entry into QuickBooks Desktop

The Journal Entry Report and Accounting Export provides an easy way to record or transfer a summary of the financial activity in the program to an accounting package. By recording a journal entry of the summarized information in your accounting package, you will be able to maintain a complete financial picture of your company. The journal entry report creates a journal entry for deposits based on payment type and is used to reconcile the deposits you receive in your bank account.

The Journal Entry Report and Accounting Export creates a summary of the financial activity for sales, sales tax payable, cash received, accounts receivable, customer deposits, inventory, and cost of goods sold. This procedure can do a few things, as listed below:

  1. Create a summary journal entry in report form to be entered by hand into an accounting package
  2. Create a file that can be easily imported into a supported accounting package
  3. Create both a report and an import file

Note: If you wish to transfer the summary data in this program to your accounting package, you should begin creating Journal Entry Reports or Exports after you begin creating sales in the program. The report and export features may not be available for all countries.

 

  1. Navigation: Reports > Sales > Daily > Journal Entry/Accounting Export
  2. Select the date ranges and options for what data you want to export > export report into a .IIF File
    1. Select Export Folder will allow you to select the folder destination for the files
  3.  From there you can follow the instructions below or others you may find online on how to import the IIF File into QuickBooks
    1. Import into Quickbooks Desktop
    2. Import into Quickbooks Cloud/Browser copy and paste the following link into your web browser for help:
      1. https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/import-products-services-quickbooks-online/L4o3mXx2u_US_en_US#new

 

Updated on April 15, 2026

Was this article helpful?

Related Articles