import credit card transactions into quickbooks desktop from iif

In respect of full disclosure, I would like to share that my team created Vendorsync, and as an accountant that uses both desktop and online, I am familiar with the pain points we all feel in respect to data entry. Instead we use Vendorsync to accomplish the same task in the least amount of time possible. Personally I find that the renaming rules can cause the program to slow down quite a bit so be careful. 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. You aren't going to be able to just upload a file either way. If you want to enter transactions, you'll want to use 'Batch Enter Transactions' by going here: 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

Import credit card transactions into quickbooks desktop from iif