How To Import Bank of America Credit Cards to QuickBooks Desktop for Mac

In today’s blog post, I’m going to take my Bank of America – Alaska Airlines Credit Card and download all of the transactions to my QuickBooks 2019 for Mac file.

To begin, I’ll start by clicking Banking at the top of my screen and then click Online Banking Setup.

Online Bank Setup in Quickbooks

Clicking that menu-item will now bring up a screen titled Online Banking Assistant. How you use this page may vary slightly because I don’t expect you to use the same bank and credit card. For my example, I’m using Bank of America. To quickly navigate to that item, we use the search bar and begin typing in the name of our bank. Once we find our bank, select it, and click next.

Find your bank in Quickbooks

On the next screen, we need to give QuickBooks some instruction on how to perform the synchronization between your bank and your QuickBooks file. The two options are Web Connect and Direct Connect. The Direct Connect option allows a more persistent connection that can save time. Web Connect will require a log-in through your bank account’s website each time you want to download the transactions. For this example, we’re going to use Web Connect.

Web connect a bank in Quickbooks

Now that’s we’ve selected Web Connect, the screen will prompt us by saying we need to download the transactions from our bank. Replacing the Next button will be a button labeled “Website,” and QuickBooks will open the web page where we download the transactions.

Downloading bank transactions in Quickbooks

Once we’re on Bank of America’s website and logged in to our account, we’ll need to grab a download of the transactions we plan on importing. To do that, select the Credit Card we’ll be downloading, click the download button on the middle right-hand side of the screen. Clicking that download button will prompt us to enter the Transaction Period as well as the file type. The file type we’re interested in here is a WEB Connect for QuickBooks 2017 and Above file. Lastly, we click Download Transactions, and a file will be saved to our computer locally.

Downloading bank transactions in Quickbooks
Downloading bank transactions in Quickbooks

The next step now is to get these transactions into our QuickBooks file. We’ll start by clicking Banking at the top of the screen and then selecting Downloaded Transactions. In the Downloaded Transactions screen, we’re going to click on the paper and right-arrow to initiate the import of the file.

Viewing Downloaded transactions
Viewing Downloaded transactions
Viewing Downloaded transactions

Next, we need to associate the newly imported transactions with an account in QuickBooks. When we opened the file, QuickBooks pulled some data off of the file regarding the account number and type. Now we need to tell QuickBooks which account we want to use. And in this case, it’s the account titled Bank of America (AK Airlines).

Selecting the account you want to use

Now all of our transactions are imported and assigned to a QuickBooks account, we’ll need to do a little housekeeping to add information to the transactions we’ve imported. In the first screenshot below, you’ll see that the file we imported contained three transactions. The downloaded transactions will appear in the following screen but will not have all the information required to make them useful in QuickBooks. For each item, we need to select the Payee and Account. So for the first, we’ll use the payee of Streak and notice that that payee does not exist in our system. QuickBooks knows exactly how to handle this situation and will prompt us to “Quick Add” the payee. The only other thing we need to tell QuickBooks is that Streak is a vendor, and then we click OK. Next, we click Account and tell QuickBooks how to classify the transaction, and this one is Office Supplies. Follow these steps for all the transactions you import.

Classifying transaction
Classifying transactions
Classifying transactions
Classifying transactions
Classifying transactions

We’ve imported the Transactions and assigned the payee and account; now, we have to finalize all this data by clicking “Add Multiple.”

Finally, the last step of this whole process is to check our work. To do that, we look at the Register for the credit card and confirm all the data is correct.

Confirm everything has imported correctly

Thank you so much for reading our blog. If you have further questions, please set up a time to meet with Rachel by clicking the green button below.

☕ If you found this helpful you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog

And if you want to see a video tutorial on how to execute these steps, watch the video below.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.