Import Excel to QB Desktop PC

I can share some information about import Excel files in QuickBooks, @vhaili.

At this time, you can only import Customer, Vendor, Items, and Chart of Accounts in your QuickBooks Desktop Premier account. We've based the reports that you can generate in QBDT on the transactions you've recorded and added to the account. 

You can import those lists from the File menu. Here's how:

1. Go to the File menu, select Utilities then Import, and then Excel Files.
2. If you get the Add/Edit Multiple List Entries window, click No.
3. Follow the wizard in importing files.

Check this article for more information: Import or export MS Excel files.

I also invite you to visit the Firm of the Future site. It contains resources and tips to help easily use QuickBooks.

I'm always here to provide help and answer any questions that you may have with adding transactions to your QBDT account. Let me know in the Reply section below. Have a great rest of the day!

@vhaili 

You may utilize an importer tool to do so.

https:// transactionpro.grsm.io/qbd

or you may explore this connector to reconcile Square transactions into your QBD file.

https:// synder.grsm.io/quickbooks

How to import excel to QB MAC

Hi 6011 0284!

It's quick and easy to import the data from Excel to QuickBooks Desktop for Mac. Let me show you.

1. From the File menu, select Import, then Items.
2. Select the item type to copy to QuickBooks.
3. In your spreadsheet, press Command + C to copy the info. In QuickBooks, press Command + V to paste the column.
4. Make sure that the Import box is selected for every item row.
5. Tap Import, then OK when the import is successful.

You can also check this article for the detailed steps: Import data into QuickBooks for Mac.

I also added this article if you need to connect your bank account: Set up online banking for QuickBooks Desktop for Mac.

Leave a comment again below if you need more assistance with this. Take care!

Can you import transactions in to QuickBooks Enterprise?

Hi KatieV1,

Yes, you can bring in your transactions to QuickBooks Desktop. 

When doing so, you'll have two options on how you can import the data. You can use either Standard or Advanced import. 

I've added this article as your guide for the detailed steps to import: Import or export MS Excel files.

Afterwards, you can categorize the items.

Let me know if there's anything that I can help in categorizing the transactions. I've got your back!

@KatieV1 

Another option, utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2