Import Journal Entries into QuickBooks Online

Import Journal Entries in QuickBooks Online US or Canada Version

Searching for value-added information for Importing and exporting things in QuickBooks accounting. Read this blog to learn how to import journal entries in QuickBooks Online. Import is necessary to share your data with all other users. With QuickBooks online in-built importing features, you can easily import journal entries. Before going to the importing process, ensure to turn off your account number, this will make processing smooth. Once you are done with the import process, the account numbers are automatically turned back. Get brief knowledge on specific topics edit and delete journal entries in QuickBooks (Desktop or Online) in a minimum period.

How to Import Journal Entries in QuickBooks Online

Before going through any process, everything looks fine in your spreadsheet. The things you have to look out for in your spreadsheet are listed below. Learn how to import journal entries in QuickBooks Online.

Step 1: Prepare the Spreadsheet

  • Journal Code
  • Account Name
  • Credits
  • Journal Number
  • Debits
  • Journal Date
  • Choose Date Format

Step 2: After Ensuring the above Steps, you are all set to Import your Journal Entries

  • Open the “Settings” menu and then choose “Import Data
  • Now, go to the “Journal Entries” field
  • Choose the Browse from the download option.
  • If you need any help to make proper formatting for the journal entries, then click on the “Download a Sample file
  • Locate and choose the Excel or CSV file
  • Hit the click on the “Open” button and then move forward by hitting the Next button
  • The next thing you have to do to map all your filled information
  • The field shows the headers on the spreadsheet.
  • Then, go to the small arrow icon, then choose the one that matches a section in QuickBooks Online.
  • Hit the Next button, if you find any difficulty then make new changes in the file
  • Choose the “Start Import” from the drop-menu options.
  • Click on the “Done” to finish the program.
  • Wait until the process is completed.
  • After this, you can utilize search processing to verify and edit the journal entries.

Guidance to Make the Sheet Properly and to so Accurate Settings

QuickBooks SectionBusiness Importer IdentitySpecification
Document Number (DocNumber) Document NumberInclined reference number for all transactions
PrivateNotePrivate NoteThe user is required to enter, an organization-private note all about the transaction. You won’t find this appears on your invoice to the customer. On the invoice form, map to your Memo fields. The limit is given up to 4000 characters
Transaction Date (TxnDate)Journal  DateThe information is entered by the user when this transaction appears. You can choose the date format as per your according.
LineLine: Brief DescriptionFree from the text description of the line product that pops up in the printed record. The given limit is up to 4000 characters
 Line: AmountThe total amount of the line product
 Line: Debit or CreditShows whether the journal Entry is a credit or debit. Limitations: Valid Values: Credit/Debit. If that particular line unable to process under the following rules
 Line: NameReference data for the entity linked with the journal entry line. Linked entities can be vendors, customers, or employees.
 Line: AccountRecommendation to the account name linked with the journal entry line. Ensure that you give only its name
 Line: Billable statusTime activity marked as billable
 Line: ClassReference to the class which is linked with the JournalEntry line
 Line: LocationIt shows the department reference which is linked with the journal entry line.
 Line: DescriptionNo need to write the description of the product item that shows in the printed record  
 Line: Tax AmountRequirement: if the tax code is given a Minimum up to zero and the maximum limit is mentioned in the given field
 Line: Tax ApplicableRequirement: When TaxCode reference is pointed. It gives you a sign of whether the applicable tax on the line is a purchase or sale
 Line: Tax CodePurchase/Sales tax code linked with the journal entry line.
 Total TaxTotal tax
TransactionLocationType Transaction Location TypeAccount location: Valid values

The above information wraps up all main points on import journal entries in QuickBooks Online including all related data. For more queries regarding QuickBooks, connect with QuickBooks Online Experts via live chat, email, or call. They provide 24/7 availability service to help you figure out your all issues.


  • How to Import Journal with Classes?

    To do this, choose the one to every row in the transaction settings specifically for the class to show while importing.
    ● Open the settings menu, choose the “Account & Settings
    ● Click on the “Advanced” option and then choose “Categories
    ● Go to the classes, choose one from each row in the transaction
    ● Click on the Save button to finish the program

  • How would I Enter Multiple Journal Entries in QuickBooks?

    ● Hit the first click on the NEW button
    ● Choose the “Journal Entry” from the drop-down options
    ● Enter the Journal Number and Journal Date in the given section
    ● Fill in all required details to create the entry
    ● If you want to add multiple entries on the same date, then sum up another line for them
    ● Click on Save and Close to end this process.

  • What are the Rules & Regulations of the Journal Entry?

    ● The first rule of note the debiting the receiver and crediting as the giver introduces, to sum up your accounts.
    ● Debit: What comes in and Credit: What goes out. Real accounts (Fixed Assets, Accounts Receivable, and Payable)
    ● Debit losses and expenses, credit comes from gain and income.