Hi Srinivas2019,
Good job on going as far as importing some of the transactions in QuickBooks. I'll be happy to assist you with making sure you're able to import all your transactions without any issues. QuickBooks allows you to import Customer, Supplier, Items, and Chart of Accounts from an Excel spreadsheet. It's important to note that there are several options available when importing Excel files from QuickBooks.
Option 1: Standard import
Option 2: Advanced import
Option 3: Add/Edit Multiple Lists
I encourage you to check out more about these options using this link.
There's a helpful article I'd like for you to check out. The article will share more info on importing using QuickBooks and I encourage you to check it here. If you're still having issues, I suggest calling our phone support team at 877-772-9158. One of our knowledgeable agents will be happy to take a look your screen and provide the support you need. Feel free to ask questions.