Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering QuickBooks 2021

You're reading from   Mastering QuickBooks 2021 The ultimate guide to bookkeeping and QuickBooks Online

Arrow left icon
Product type Paperback
Published in Jan 2021
Publisher Packt
ISBN-13 9781800204041
Length 414 pages
Edition 2nd Edition
Arrow right icon
Author (1):
Arrow left icon
Crystalynn Shelton Crystalynn Shelton
Author Profile Icon Crystalynn Shelton
Crystalynn Shelton
Arrow right icon
View More author details
Toc

Table of Contents (26) Chapters Close

Preface 1. Section 1: Setting Up Your Company File
2. Getting Started with QuickBooks Online FREE CHAPTER 3. QuickBooks Online Advanced 4. Company File Setup 5. Migrating to QuickBooks Online 6. Customizing QuickBooks for Your Business 7. Managing Customers, Vendors, Products, and Services 8. Section 2: Recording Transactions in QuickBooks Online
9. Managing Sales Tax 10. Recording Sales Transactions in QuickBooks Online 11. Recording Expenses in QuickBooks Online 12. Reconciling Downloaded Bank and Credit Card Transactions 13. Section 3: Generating Reports in QuickBooks Online
14. Report Center Overview 15. Business Overview Reports 16. Customer Sales Reports in QuickBooks Online 17. Vendor and Expenses Reports 18. Section 4: Managing Employees and Contractors
19. Managing Payroll in QuickBooks Online 20. Managing 1099 Contractors in QuickBooks Online 21. Section 5: Closing the Books and Handling Special Transactions
22. Closing the Books in QuickBooks Online 23. Handling Special Transactions in QuickBooks Online 24. Shortcuts and Test Drive 25. Other Books You May Enjoy

Uploading banking transactions from an Excel CSV file

If your financial institution does not integrate with QuickBooks, then you need to download your banking transactions as an Excel CSV file. Most banks allow you to download your transactions to a PDF or CSV file. Log into your bank account and look for the Download Transactions option. If you don't see this option, contact your bank and inform them that you need your banking transactions in a CSV file so that you can download them to QuickBooks. 

To upload banking transactions from an Excel CSV file to QuickBooks, go through the following instructions:

  1. At the beginning of this chapter, we showed you how to add a new account to the chart of accounts list. Follow those step-by-step instructions and add your bank account to QuickBooks. 

Your bank account setup screen should resemble the one in the following screenshot:

The following is a brief explanation of how to fill in the new bank account fields:

  • Account Type ...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image