LONG READ BUT STEPS are SUPER SIMPLE once you know how to do it!

Yes it's possible with Batch Transactions. I am using QuickBooks Desktop Pro 2017 for this example. Please note import is misleading - when you open up Batch Transactions there is NO import button, you need to copy and paste from Excel to QB.

A previous response said that Batch Transactions would be located under the Company Tab if I didn't have the Accountant's version but it wasn't there for me. I worked around this by adding it as a shortcut by clicking on the "Customize Shortcuts" at the bottom of the panel (see attached png).

Once it was added I needed to prep my excel file by making one tab for checks and one tab for deposits. (I can't seem to add more than one file to upload in this reply so I'll try to reply to this comment once it's posted with the additional screenshots).

At minimum for expenses I needed to have the following columns:

1. Date
2. Number (for the check number)
3. Payee
4. Account (this matches up to one of your chart of account accounts)
5. Amount
6. Memo (not required but helpful!)

For the deposits I needed to have the following columns:

1. Date
2. Payee (not required but necessary if you've returned items and want the return under the correct payee)
3. Account (this matches up to one of your chart of account accounts)
4. Check No (not required but necessary if you're logging the check number a customer paid you with)
5. Amount

It doesn't matter which order your columns are in BUT, when you go to the batch transaction screen you must customize those columns to match the order in your excel spreadsheet. All you need to do is copy all the columns and rows of data from Excel and then paste them into the Batch Transactions Window once you open it (remember it's under your shortcuts panel if you following my example above).

If you're pasting the expenses then make sure to choose Checks, if you're pasting the deposits, make sure to choose Deposits.

Make sure once you've pasted the data that NOTHING IS RED. If it's red that means QB isn't matching it up to an existing thing (vendor, customer, chart of account, etc).

Lastly, make sure at the top of the Batch Transactions window you've chosen the correct BANK ACCOUNT (checking, savings, etc) that you want these transactions to be imported to.

At the bottom click "Save Transactions" button and you're good to go!