
The banking center also allows you to take advantage of the renaming rules to help speed up your import process. Whenever possible, importing through the bank feed section is the best method and will help you reduce the chance of duplicates. These should be captured during a proper statement reconciliation but it will still add extra time. If you have a situation where your clients are also entering data into their QuickBooks company file, it is possible that you can create duplicate transactions. There are both positive and negative reasons to use the batch enter feature within QuickBooks Desktop for Accountants. Hey I see that this question has already been answered but I wanted to chime in here as well for future people that may need some help. I would also suggest that you make sure your Payee names are already in Quickbooks and are typed in your spreadsheet exactly as they are in Quickbooks. I would highly suggest that you paste one column at a time. You can customize the columns to best fit your spreadsheet as well. etc) then the account you want to use next. When batch entering transactions, be sure you pick the transaction type first (checks, deposits, credit card. You will need to copy and paste from your excel spreadsheet.

If you want to enter transactions, you'll want to use "Batch Enter Transactions" by going here:Īccountant -> Batch Enter Transactions You aren't going to be able to just upload a file either way.

This is going to allow you to copy and paste from Excel - but it will only be for Customer, Vendor and Item Lists. The instructions you are reviewing are specifically for Quickbooks Online, not desktop, which is why you are having difficulties.įile -> Utilities -> Import -> Excel Files
