Solved

Batch Enter

Forum|Forum|2 years ago
October 12, 2023
2 replies
0 views

Im on QuickBooks Desktop Pro Plus 2022. I need to enter Batch JE Entries. How do I map the excel sheets with Account #, Debit, Crédit, Memo Etc..

Thanks!

QuickBooks Desktop

Best answer by JenoP

I wanted to join you here and answer your inquiry about moving data into your account, MW95.

Currently, there are only two methods available for directly importing journal entries into QuickBooks Desktop. The first option is through an IIF file, and the second option is by requesting your accountant to send you a General Journal Entries file.

To learn more about these options, I recommend checking out the following articles:

Importing journal entries using an Excel sheet is not supported for now. However, there are third-party apps available that can help import transactions into your company file. These apps can be integrated with QuickBooks to facilitate easier data exchange.

To find approved and accredited apps, you can visit this link: https://desktop.apps.com/home.

I would like to provide you with some additional resources that can be helpful when importing data in QuickBooks. Please check out the following articles:

If you have any more questions or need assistance with data management, feel free to reach out to the QuickBooks Team in the Community. We are always available to provide guidance and support.

E

Ethel_A12

Welcome to the Community, @MW95.

I'll help you prepare your excel sheets for Journal Entries before importing to QuickBooks Desktop.

Make sure your Excel sheet contains columns for Account Number, Debit, Credit, Memo, and any other relevant information. Ensure that the data is organized correctly.

Please note the following limitations when importing and exporting data using IIF files in QuickBooks:

There is a limit to the number of list entries that can be imported. For more information, refer to the documentation on the maximum number of list entries.
Importing IIF files does not automatically link transactions. After the import, you will still need to manually link transactions such as invoices and invoice payments. To link transactions, navigate to the Receive Payments or Pay Bills window. Alternatively, you can explore third-party apps that offer import and linking capabilities.
When importing assembly items, it is not possible to import data into the item's custom fields. Keep this in mind when working with assembly items and their associated custom fields.
Price levels that are set up on a per-item basis cannot be exported or imported using IIF files. This limitation should be considered when managing price levels in QuickBooks.
IIF files can only be used to export payroll data from Core, Premium, and Elite Standalone Payroll. Ensure that you are using the appropriate payroll version for your export needs.
It is not possible to import or export IIF files between different country versions of QuickBooks. For example, you cannot import an IIF file from the US version of QuickBooks into the Canadian version.
When creating an IIF import file, Microsoft Excel does not allow entering numbers with leading zeros. As a workaround, you can format the column cells as Custom to retain the leading zeros.

You can read this article to learn more about importing excel files in QuickBooks Desktop: Export, import, and edit IIF files.

For future reference, here is a guide in running and customizing reports: Customize reports in QuickBooks Desktop.

Feel free to click the Reply button below if you have questions about importing Journal Entries. I'm always here to help. Have a great day.

M

MW95Author

i dont believe i am doing IIF File i would like to do an excel sheet is that possible? Also, i am doing one JE that will have ~50 lines.

JenoPAnswer