Importing (Copy/Paste from Excel) Bank Data into QuickBooks Desktop Accountant *
Vložit
- čas přidán 5. 08. 2024
- QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
(30% discount offer to expire 9/30/2021)
*MUST USE QUICKBOOKS ACCOUNTANT EDITION, WILL NOT WORK ON PRO OR PREMIER! To upgrade to QuickBooks Accountant 2019 for $599:
quickbooksprice.com/collectio...
MUST USE COUPON CODE: ACCOUNTANT for $50 off
Topics covered in this video:
00:00:43 - How to clean up the data before import.
00:04:56 - How to split or separate my debits from my credits.
00:06:53 - Select all the payees and come into QuickBooks to create all those payees as customers (step by step) and then the same process but as vendors.
00:08:58 - Go to accountant menu, click on batch enter transactions and start with checks or bank debits (copy/paste checks/debits).
00:12:10 - Create an account and copy down to put every single transaction to an expense account in this case (example).
00:12:55 - Copy/paste deposits or credits from excel to QuickBooks.
00:14:35 - Reconcile (steps: click on reports, company financial, profit and loss standard, dates, last fiscal year, then click on banking and begin your reconciliation process).
00:16:12 - Reclassify transactions (income and expenses).
00:21:08 - Profit and loss progress after reclassifying transactions.
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:
Add/Edit Multiple List Entries
Batch Enter Transactions
Reclassify Transactions
Check out this video as well on Batch Enter vs. Bank Feeds:
• Video - Věda a technologie
Just wanted to say thanks for this wonderful video and to let you know that it is still helping people after 6 years! This is one of the best tutorial videos I have ever watched on CZcams. Thanks again!
Thank you, this is just what I was looking for. Your video was informative and very easy to follow and understand. Thank you again.
Great video Hector! Definitely helped me to deal with a large number of transactions that needed to be imported! Thanks!
This is a great video. This is absolutely a reason to get QuickBooks Accountant. Hector does a great job of explaining this time saving technique!!!
yes for sure!
Hector, Thank you for offering your knowledge on Quickbooks. I just wanted to let everyone know that I was able to use these steps in Quickbooks Small Business 2016 on Mac. There are some things you have to figure out how to transfer but your video pretty much helped me step by step using another version of Quickbooks!
+Dave Ward nice.. yea MAC has some of these features, but very different style
Wow Hector ! You rock and roll here brother ! Thank you so much ! I am first year in business and it is a tax season ! BOOOM !!! I am scared ! Never used quickboocks and never knew how to use PDF statements with Excel ..... ough....
Just learning. Your video is a step 2 into my learning and it seems that it should work. Maaan, would I ever think that I will need to deal with such stuff :-D
I am freaking out here bro....
Thank you Hector for taking the time to do this
+Nimesh Vakharia :)
This is the best thing that has ever happened to me. I just got a client where I have to catch up 3 years of work, and they have excel sheets of their bank accounts. You have saved me a ton of hours, thanx
Elaine Swart great... feel free to send royalty checks
Thank you for this information! It's exactly what I've been looking for (for years)!!
Great
Nice work. Thank you for sharing your expertise
I was looking that for days.
Great presentation.
Thanks for your collaboration.
glad you liked it!
VERY helpful! Great instruction
thank you so much for your time and knowledge...
very informative. you solved my problem. Thanks Hector Garcia
Thank you !! Very informative, direct, and useful.
Jodie Larson great
Wow. This video saved me hours. Thank you, Hector.
Max Chung you welcome
Thank you, it was very helpful!
:)
Hector you are doing great thanks a lot for posting such vedios
Thank you
Thanks boss I have learnt alot !
You welcome
This is a real informative video. Thanks for posing it.
:)
Good job!! A great video and very helpful!
Thanks for sharing your knowledge, I really Appreciate this!!!!!!!
+P Trevino no problem
Hector
Thanks so much.
What an awesome video.
+Audrey Neamtan glad you liked it
Great presentation!
Thanks
Thanks so much. Very helpful. 😊 gracias
great video! testing it out today
+Julianne Autry great!
Great video, very helpful
Souleymane Baldé glad you liked it....
What a great video, thank you very much.
+Rick Duval you are welcome
Hector.. I searched high and low on the Net for exactly what you have deivered here. Muchas gracias
Shaw Ali good
Awesome. Total fan!
Linda Florence cool!
These videos have really helped me out tremendously. Question, I am using qbo for the first time with my business and I am adding 3 years of info and 2 different accounts, one closed and the second one active. Do I add the transactions from the closed account under the current open account? Of add the closed account as a separate account? Thanks
This video is just great_ truly.
I feel like I could even conquer the financials from an enterprise in just a short time😮
:)
thanks so much, so used to paste another accounting software.some one called if i can help to import to quick books been battling with it for hours came across this and so useful, i thought i will need to export the template on excel and fill it up to import,but i saw your previous video which indicate i need to do mapping,cos have tried importing it using the first steps shown on the screen when trying to import but the response i got was the excel type is not the same with the quick book.
Hector, is there a way to merge data from an old company file into a new company file. We have records in 2008 thats needs to be placed into the new file that is running starting into 2009
Excellent video. I was doing a lot of the same things in excel, but I don't yet have the accountant version. I will certainly get that now. Thank you for the video!
thats right.. love that accountant edition!
great job!!!! thank you
Welcome
Thanks alot
Sir Hector Garcia is a great Man, This is a million dollars video.
Thanks.
Dilbar Chohan hehe: you welcome.
Hey, thanks for video. How can we see the excel shortcuts on the screen like your excel?
good excel tips and import to qb
Great video. Is there a way to do this without the accountant version and just the Pro version?
Thanks for the tips!!!
you are welcome
+Ngan Menegay no problem
Is there a easy way to split transactions under cheques or deposits between multiple classes, for eg. I need to split bank charges or agent fees between 'n number of classes
Can I classify transactions to the appropriate account and then paste into QB?
Hello, could I use the same steps to import credit card transactions??
Hi Hector, given all of the importing tools for QB which do you believe are the best and why?
I use notepad++ when downloading my bank information to cleanup and separate the info into usable columns. I download into a Text file and use the con/alt and Control arrows to quickly align everything and then copy and past each column into excel, access or quick books which I am having to learn.
That was amazing!
glad it was helpful
Hi.. Hector, can you email me the Quickbooks setup? I can't find any free version
My email is : jasonsukasuka@gmail.com, thank's
Thank you Accountant from Nairobi
you welcome
Hello Hector. Great video. I prepared my excel spreadsheet per your instructions. However, I do not have the accountant version. Is there a way to give my excel data to my accountant to be entered into quickbooks and then transferred into my quickbooks. I have Quickbooks Pro 2016? Thank you your response is greatly appreciated.
TrishSellsFloridaHomes.com yes is possible... and if your accountant cannot do it, we can do it for you and you can send you QB completed to your Accountant for tax prep... office email me.
Hi~ Hector. Thanks for giving me a good information. I have a question. My colleague imports bank transactions(excel file) to QuickBooks using the IFF Creator feature, but occurs errors while importing data (finally completes though). What is different your method and IFF creator(besides expenses). I mean what are the drawbacks using your method. Thanks in advance.
There are pros and cons to many options
That was awesome!!! I love it. I just tried it with one bank account and loved it. However I do have one question.....when you have a client with multiple checking accounts, and they transfer funds from one account to the other, how will the batch entry catch the duplicate transactions, or will it???? Or do I need to catch it before I import? Thanks in advance!!!
it wont catch it! you have to delete them from the other side before importing them... or send all transfers to a bank account called "transfers" which will just zero out when you are done
Your video are very helpful. When you enter things into the register, do you still have to enter them anywhere else in QB?
no.
Hector, do you know if I convert file from qxf to qbo (money thumb tool) when I import the transactions would it import something if any part of the transaction is already on my register to avoid duplicate entry?Thanks
A P if you bring in through bank feeds, it will identify the match on any unreconciled transaction.
Hector, awesome video. I was able to do this until I hit the "batch transactions" which you say is not available in QB Pro 2016 Desktop, only the accountant version. Am I stuck at this point? I have my tabs in my excel spreadsheet organized exactly as yours except I don't have a memo column, only payee. My bank does not support QBO downloads.
Sal Livreri you need to upgrade to QB Accountant Edition 2018 is $450
Hi Hector. Great videos! I work AP and use QB Desktop. When I "Enter Bills," is it possible to paste multiple lines of data at once in the Memo section? I can only seem to paste one line at a time. Thanks for any feedback. 😁
Unfortunately not, just one line
Hi Hector: When you made this 2/6/15 video, the best of us did as you expertly show. However, I trust you know bank statement converters & custom transferrable QB Online machine learning rules made it unnecessary (for any QBO). QBO ACCOUNTANT users also can give QBO users Accountant Toolbox with Reclassify Transactions.
I guess you like QBO better?
That is a very good observation Hector. Yes, I do like QBO better for most clients. However, there is no reason that QBO bank statement converter output could not go to Excel, where I could automate all the conversions.
I actually showed MY accountant how to do this using your video as my learning guide. Him and I owe you some beer, can you send an address?
+Dave Ward haha, not a problem... i am glad it helped you
Following your instructions to transfer from excel to QB I find that QB 2020 does not have the accountant tab.
if anyone can help me, I appreciate it.
You need to have the Accountant’s edition. You probably have Pro or Premier
Thank you for an excellent tutorial. I do have a question, once all the data is loaded, can I change the Transaction type? FOr example for Checks to Credit card charges, etc?
No, you can only import one transaction type at the time.. and cannot be changed
not possible to change transaction typr
Hector, is it possible to batch import with QB 2012? I cannot find that option.Thanks.
+Leigha Anthony no
Excellent Video. However please note QuickBooks 2014 & 2015 Accountant Edition and QuickBooks Enterprise Solutions 14.0 & 15.0 Accountant editions allow batch entry of transactions. I have 2013 Pro and had to stop in the middle as there was no accountant menu. Is there a work around?
2013 accountant can do it too
+Tajinder Singh Can we import invoices
Your videos are great! Do you have any videos on how I can import an xcel spreadsheet with credit card charges into my quickbooks online version?
Elizabeth.. you can use an app called CSV2QBO to convert the excel file into a .QBO file that will import into QuickBooks Online
bit.ly/CSV2QuickBooks
+Elizabeth McCord also look at this video czcams.com/video/a7z-fS60ihY/video.html
Hi Hector is there a way to import Bank data using Quickbooks Premiere , this is a very good video btw
No
Hector is a awesome presentation, thank you for sharing!
Indeed I have a question, because I am struggling with an issue, I want to import invoices from a program called Magaya, to quickbooks, and I have my excel data, but obviously when i imported the data the amounts in accounts receivable will be open, how can match the payments from the data bank vs the accounts receivable? is possible in an automatic way? thank you in advance
you would have to import the payments as well
Can you do that through Zed Axis?
Hector-i love your videos. I watched this multiple times, and worked 8 hours straight downloading CSV files to my desktop. I formatted all of the CSV data as you formatted yours, manually added transactions from PDFs and saved. I thought I would import them into QB tomorrow. Aghhhhh-when I went to open the CSV file, ALL the formatting was gone and any new worksheets I had created in the excel workbooks were gone. I think I was suppose to save the data as an xl workbook and not csv😩 I think I have to start over. Any suggestions?
CSV's dont save formating
you need to save it as an EXCEL document
i have the QB Accountant 2012 version. Is there a way to perfomed batch entries in this version? If not, what is the best version to adquired. I have a significant amount of batch transactions to do on a daily basis....
nope.. you need to upgrade to 2016, need a price quote?
+Hector Garcia (CPA) Sure! Tks.
+Michelle Herger email me hector@garciacpa.com
I have QB pro 2015 , Is not possible to do a batch transaction right?
need to upgrade to QuickBooks Accountant, email me for quote.
Hi Hector?
do you know how to import lockbox file into QB desktop?
Rechel Puerto I don’t know what I lockbox file is...
amazing what happens if already you have existing vendors and suppliers in qb
Use those instead or it might duplicate them
Great video, I have a question. I tried pasting the data however when pasting into QB Accountant 2015 it pastes into one box not everything.. is there a setting in excel perhaps I'm missing?
+Garcia Business Solutions, Inc | Bookkeeping Services in Los Angeles are you pasting in the Batch Enter window? you cant just paste in an invoice or bill like this
Hi Hector, I must have misunderstood something. I basically followed step by step what your video shows. Entered the data into Excel, divided by Payee, Date, etc.. If I'm not mistaken you copied and pasted into the QB Batch section in the Accountant Version..
+Garcia Business Solutions, Inc | Bookkeeping Services in Los Angeles that is right
Can you do this with Quickbook Pro 2015 or do you need the Accountant version?
SSiter2 Only Accountant Edition.
For all the Expenses, do you still need to create a bill and for all the credits (in my case customer payments), do you still need to create an invoice?
Can we import Bank transactions from Excel to Quickbook pro premier?
No.
Can Import Copy /Paste bank transaction into QuickBooks from CSV or Excel Premier Pro 2021
No… Accountant only
Is there a way to quickly clean up/merge those vendor names?
no.. I wish..
Hector can I hire you to teach me to import and get my data into QB Pro for 2016? I;am in a class now, but need help importing and sorting my data to prepare for a meeting with the IRS
Mark Deaton yes, call 954-414-1524
Hi thanks Hector for the useful tutorials,i just want to know how i can transfer bank transactions manually to quick books premier?
You would need an importing tool like TPI for $200
Can you reclassify transactions as a batch on premier as well or do you need third party tool like Zed Axis as well?
not in premier..
Zed Axis can't do reclassification of transactions?
Hector this is informative and I thank you for sharing your knowledge.
However, I think it is time we come up with a better system. QuickBooks whether it is Desktop or Online is an antiquated system who's backbone and framework appear to be out of MS-DOS. I haven't had a system restrict me in the number of characters of information I can write into a transaction in years with any other piece of software, but QuickBooks. In addition, If we have to do that much clean up to our files to import them into a software, then the problem is the software. Thank you for listening to my rant. As you can see I am really frustrated with QuickBooks.
Fish Sleep Relax what’s better?? I’m always open to alternatives
Hector Garcia CPA Good reply sir. I’d love to provide the answer. I’m working on a solution. Keep you posted.
Can you do a video on importing paypal transactions?
yes.. search it in the channel
genius
`how to over come the two problem areas you pointed out ?
Travismcdee353 which ones..
Capital contribution from the owner and bank cheques ? Also the export data from the bank is miss formatted. it is sometimes dd/m/yyyy, dd/mm/yyyy. Would the ? correct for this ? I have a sort method, but its time consuming.
When can I find the items I matched?
+Awilda Ramirez there is no MATCHING mechanism with Batch Enter Transactions
Does it work on QuickBooks online..?
No
Seria bueno tenerlo en Español
i love you
:)
My qb enterprise only copy it on the first cell.
Is you enterprise on a remote computer? Or doesn’t work remotely
Hola Hector, por favor necesito contactar contigo, para unos trabajos en Quicbooks? como podemos conversar?
Llama a la oficina para hacer cita 954-414-1524
This screws up your vendor and customer lists though
It adds stuff to it.. but doesn’t screw it up, if that is what you want to bring
hello Hector i tried what you just did not working.thought gotten a solution, but ..........................................................
email me if you want to setup a private training.
+Hector Garcia (CPA) i need a clue, am used to sage pastel evolution,and i thought it the same procedure to import, i just a need a clue, am just helping some one out.
BHT HARD
?
Check out this video as well,
Batch Enter vs. Bank Feeds:
czcams.com/video/rNkOqvGZiZQ/video.html
This method does not take into account outstanding checks
you have to enter those manually
Sorry Hector - at about 8:19 I couldnt' take any more - it looks like a complete mess on steroids.
Yeah, its def. Not a simple as must people imagine it
Do a better job with correcting yourself when you use terminology, you’ll say deposits” I mean debits” it’s just confusing be precise and concise
Shakur Morrow please show me your videos that I can learn from....
Shakur, if he dumbs it down for the slowest kid in the class, the entire group suffers... . Double or triple or quadruple tap the left side of the youtube video and it will rewind for you so you can listen again... Also, there is a setting that lets you slllloooooowww it doooown. If you need it.