![]() ![]() After sorting you could change the top name to be an actual vendor name, such as Best Buy, and leave off the rest of the data in the field, then copy and paste the name through the rest of the transactions that use that vendor. Many bank transactions have unique numbers in them that would require adding a new name in QB for each transaction, causing a possible problem with list size limitations in QB. The only thing I would do differently in Excel before the import process would be to sort by Payee name and then standardize the vendor/customer names more. Thanks so much for posting this tutorial, which is very timely for me. 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. ![]() Prior to working in public accounting, Hector was a small business banker for several years. Hector Garcia is a CPA and Advanced QuickBooks ProAdvisor from the Miami Florida area. Way to go Hector.and thanks for sharing your video with our readers. 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. 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. ![]() 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. In this approximate 20 minute Video (accessible below) I will illustrate how to:ġ) 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) Ģ) Add/Edit Multiple Vendors and Customers using the Add/Edit Multiple List Entries tool ģ) Copy and paste the transactions from Excel into QuickBooks using the Batch Enter Transaction feature found only in QuickBooks Accountant versions Ĥ) Reconcile all the transaction in one shot within QuickBooks, andĥ Reclassify the transactions using the Reclassify Transaction feature's sort function to quickly assign transactions to their appropriate accounts in QuickBooks. 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. 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |