I recently prepared a YouTube Video illustrating my own technique to import large amounts of bank data from Excel/CSV into QuickBooks Accountant using 3 Built-in tools. Of course you must either have access to, or be able to download, a bank transaction file in Excel/CSV format to use this methodology.
In this approximate 20 minute Video (accessible below) I will illustrate how to:
1) Easily clean-up bank transactions you have downloaded into a CSV or Excel format (these are some Excel commands you may or may not already be familiar with);
2) Add/Edit Multiple Vendors and Customers using the Add/Edit Multiple List Entries tool;
3) Copy and paste the transactions from Excel into QuickBooks using the Batch Enter Transaction feature found only in QuickBooks Accountant versions;
4) Reconcile all the transaction in one shot within QuickBooks, and
5 Reclassify the transactions using the Reclassify Transaction feature's sort function to quickly assign transactions to their appropriate accounts in QuickBooks.
Importing Bank Data into QuickBooks
Hector Garcia, CPA shows you his very own techniques to import large amounts of bank data from Excel/CSV into QuickBooks Accountant using 3 Built-in tools.
Editor's comment:
Hector has provided a very interesting and informative video illustrating a technique that many ProAdvisors might want to use if they are confronted with a situation in which a new client (most likely) asks if it is possible to convert their prior Excel bank data into a QuickBooks file for them. While there are 3rd party tools that could assist with such a project, they require an additional 'capital expense' as well as 'learning curve' in order to accomplish the same end result that Hector has demonstrated and which can be performed within the existing capabilities of QuickBooks Accountant or QuickBooks Enterprise Accountant.
Way to go Hector......and thanks for sharing your video with our readers.
Murph
About the contributor:
Hector Garcia is a CPA and Advanced QuickBooks ProAdvisor from the Miami Florida area. Prior to working in public accounting, Hector was a small business banker for several years. Hector holds master's degrees in both Finance and Taxation, bringing knowledge and experience from the finance and accounting sectors to his small businesses clients.