Importing Bank Statements into QuickBooks using PDF Bank Statements or CSV files

[@HectorGarciaCPA]

UPDATED VIDEO (2021): kzbin.info/www/bejne/nnOXaoCYpLSZeJo

[@bfourney]

Dude this video saved my life. I waited way too long to connect my bank account to quickbooks and only had old PDF statements available.

[@HectorGarciaCPA]

awesome

[@HectorGarciaCPA]

+blondre3000 great.. the PDF converter is great

[@lcdebaca]

Thank you so much for doing these videos. You have been extremely helpful. I recently switched from using 2013 desktop version. It is definitely a learning process and you have made my transition much easier. These videos have been more helpful to me than quickbooks customer support. Thanks again for saving me from banging my head against the wall in pure frustration.

[@Thediamondaire]

Books were already set up online for current transactions, but for loading past years' statements this is a life saver.

[@commonwealthinvestigations5241]

I was an .iif user till version 2017. Thanks to your video I know a better way! Excellent detail. Please continue to share your videos!

[@lesliesimmons9951]

Hector - you are amazing! Everytime I have a question, you have a video that methodically, clearly explains options, workflows and resources that help me work smarter. Thank you!

[@HectorGarciaCPA]

+Leslie Simmons Thanks, glad this helps you.

[@andrewmiller7886]

VERY LOOOONG Very Helpful. NEW TIP FOR FUTURE USERS! You can ONLY upload 1000 lines from Excel to QBO. I had to select the from the top left to line 999, then copy and paste into a new file, RENAME IT so i could find it, Then repeat for the rest of the lines and copy and paste into new file, and or RENAME IT AS WELL then 2 separate uploads and i was almost done. THE QBO ALSO asked me to identify which columns were debits, credits, date and description of each transaction VERY IMPORTANT

[@HectorGarciaCPA]

Great point

[@debbiewhite1139]

I was so frustrated. I knew there had to be a better way to batch enter transactions from a very long statement on PDF. Thank you for your video!!!! Best software and tutorial ever!!

[@HectorGarciaCPA]

Awesome!

[@theodorethomas8010]

Hector, I just stumbled upon this QuickBooks video. Thank you so much! I have been doing bookkeeping as a side job, and have not been uploading bank statements, credit card statements, etc. This knowledge will totally change my business.

[@somenmondal1245]

Hector Garcia CPA , has changed my life. I don't know, how to operate QB online. I following his Video clips and now I know a little bit of QB. I believe that I will be master pitch after one year. be happy and live long "Garcia"

[@jefflester5014]

A great teacher speaks well to his students! More power sir hector!

[@bazmanmedia2050]

This video is really really good. Not sure why it has not hit one million views yet.!!!!!

[@carolinewheeler8197]

Wow, this was excellent and super helpful! Thank you for the clarity, simplicity and efficiency of your explanation. I’m so happy to have found a great resource for help with QuickBooks! Thank you! BTW: I have never before left a review on KZbin.

[@sweetchild1975]

THIS INFORMATION IS A REAL TIME SAVER!! WILL BEGIN USING IMMEDIATELY! THANK YOU VERY MUCH!! :)

[@somenmondal1245]

I am a new beginner of QB. I saw everything. I am very pleased to watch the clip. it will my best pathway for learning. Thanking you "Hector Garcia CPA"

[@HectorGarciaCPA]

ok great

[@dapoirierinc]

Fantastic video. Thanks for taking the time to make it. This will really help me with posting entries.

[@BayareaSolutions]

You just made my life easier, thank you much

[@HectorGarciaCPA]

:)

[@TravelWithLynna]

Hector, thank you for the video. I have a CVS file ready to go into quickbooks and I wanted to confirm that I need to make my credit card charges negative and any credits to the card positive. I use the Advance COA online quickbooks program. I know this video was done over a year ago and I have a lot of transactions to import. Just want to make sure I'm importing them correctly. Thanks!

[@HectorGarciaCPA]

Travel With Lynna process has not changed... positive are charges.. negatives are refunds or payments to the CC

[@liuguiyan4620]

Thank you very much for this helpful and informative video, I subscribed your chanel without any hesitation.

[@aliharatian5666]

Hector ; I have a question for you , what is the best way to quick add credit card payment by checking account ?

[@HectorGarciaCPA]

sorry dont understand the question.

[@aliharatian5666]

Sorry... when we import credit card & checking transactions into the quickbooks , then there are transactions of payment of credit card bills in both account ( checking & credit card ) , Now if we quick add those transaction in section of checking , so do we need to remove them from credit card section , am I right?

[@HectorGarciaCPA]

+ali haratian right. dont duplicate them

[@aliharatian5666]

Thank you so much !

[@danchurchillcooks]

Mate amazing help... thank you Dan

[@HectorGarciaCPA]

+Dan Churchill :)

[@jamesminer7492]

Helpful, easy to understand, good presentation.

[@statwizard]

Thank you! Thank you! Thank you!..... Excellent video, saved me an enormous amount of time.

[@melindaburnside7189]

2 👍🏻👍🏻 THUMB'S UP AND I ENJOY WATCHING 💯

[@carlosizquierdo3923]

i found it! it was hidden under the "Update" button! THANK YOU SO MUCH!

[@HectorGarciaCPA]

yes..

[@CaptainDeebag]

Great video. Finally learned to do this. Will save time and money!

[@HectorGarciaCPA]

+CaptainDeebag great

[@Mymusicfmw33]

I could sure use your help! I’m new to QB. PREMIER DESKTOP. ITS A CHALLENGE. I WILL USE YOUR VIDEOS TO LEARN. I sure hope I learn before I get fired. .

[@HectorGarciaCPA]

There are many videos in KZbin

[@kristinawilliams5064]

I'm a bookkeeper/accountant. Your video was quite informative. I am wondering though if there is a less expensive method to convert a pdf bank statement to a qbo file as my budget doesn't allow me to purchase the converter tool at this point. Recently my work has been seasonal only. Any suggestions for my specific need would be appreciated.

[@bradlehrer3470]

Have you found a program to convert a payable into QB? As an example, I receive a weekly UPS bill. It has many shipments that need to be job cost to different projects. BTW your videos are very clear. Thank you for your presentation.

[@hexgarcia]

bill.com

[@nathanhay9157]

Thanks so much for your very helpful videos!! Just wondering if you have a video on how to reconcile your accounts after Quickbooks online has imported all your data from Xero so I can get back to a clean slate?

[@HectorGarciaCPA]

i dont do much with Xero, so I am afraid I am not an expert in that subject.

[@EXCELCORAL]

Excellent Hector , thanks for the advice

[@dennisbeyer2108]

Great coverage on all aspects on importing. I have questions related to the Transaction List with the import of my Business Checking. I also have a Business Savings. I've only imported the Checking and not the Savings yet... After I just finished Quick Add (not so quick for 1500+ transactions) for the majority of them, I'm down to 19 Online Transfers from Savings to Checking. The "Payee" is what is throwing me off... and I've been a double entry person 20+ years ago. I ran into this with Owners Equity. I added myself as "OE-My Name" as the Payee. Since this is just a Single Entry system, do I just create an "Other" type of Payee called "Business Savings" and the Account would be my Business Checking? I'm about to Import my Business Savings QBO file into the Transaction List. Would I see double the entries? Or Import it and do the same by creating a "Business Checking" as the Payee and Account would be Business Savings? Was the way I did the Owners Equity correct? I'm trying to get use to this single entry system... Thanks! D

[@teresahutchinson4029]

Thank you for the information, got it uploaded

[@davidr4523]

Excellent video! I am buying an 2018 version of Quickbooks Desktop Pro. Can I still import banking activity or do I need to upgrade to a Quickbooks subscription version to be able to utilize this feature. I was informed that May 2023 was the cut off date for banking activity imports from Desktop versions without a subscription. Can you please confirm. Thank you!

[@HectorGarciaCPA]

No you must be in a supported version

[@savealot2]

This video was great! Thank you very much!

[@macbelwoldie631]

Wonderful job hector! just one question...how do you enter your SALES (invoices) if you have account receivables and your customers pay you? thanks a lot

[@HectorGarciaCPA]

through bank feeds, you cannot import Invoices

[@angeladimalanta858]

Hi Hector, thanks for all your videos they were awesome i learn a lot! can i ask my client is using QBO and wanted to convert to QB Desktop the problem is they are using QBO Canada and like to convert it to QB Desktop Canada. i heard that there is no direct conversion. Using excel to qb destkop is the best way to do it? thanks

[@HectorGarciaCPA]

Angela Dimalanta probably... i dont know Canada

[@kaygrooves]

Very helpful, thank you!

[@juntodorovic4175]

Very useful information

[@HectorGarciaCPA]

Thanks

[@paulaaradi5849]

Hector, any recommendation how I could learn Quickbooks? Any good online classes? what is the cost? Thank You

[@HectorGarciaCPA]

For free via KZbin, just watch all the videos

[@TheBellafiore]

Great job Hector, thank you for all your support through your KZbin videos. I inadvertently duplicated an entry when I did the conversion process as shown in this video. How do I delete it in QuickBooks? Thanks A Bunch, Tina

[@HectorGarciaCPA]

You can delete them in the banking module, where is says “in Quickbooks” or “entered”

[@TheBellafiore]

@@HectorGarciaCPA I'm sorry but I'm in banking QB ESS. online version and I don't see a prompt to delete. Banking/for Review Your thoughts...

[@HectorGarciaCPA]

@@TheBellafiore “UNDO” maybe

[@TheBellafiore]

@@HectorGarciaCPA Hi Hector, I figured it out. How to delete duplicate transactions after you import them to QB. In the For Review tab / select the duplicate transactions / click Exclude In the Excluded tab, check the boxes for these duplicates / then Delete.

[@RioSteveston]

These import can only import the credit card transactions into qb as transaction. How can I import the credit card say 10 expenses in to a check payment and split line in item, so that I can call that payment with detail lines split below ? this is more accurate in dealing monthly statement of credit card.

[@vatsalthakkarcpa]

Hey Hector, Really very beautiful way to teach quickbook.Can you please upload a video for how to close fiscal year in quickbook? or if you have it, can you please share link of video.

[@rupanshi87]

HI, Thank you for your videos... they are really helpful... Just wondering, if there is a tool which links the receipts of certain places, for say eating joints and your bank statements so tht u dont have the entry twice?

[@HectorGarciaCPA]

Receipt Bank is probably the best app for that

[@RevmasterofIN]

You're the man! Subscribed!

[@HectorGarciaCPA]

Thanks :)

[@aliharatian5666]

Great Job Hector!

[@aamiriqbal8346]

Hi i watch this video it really helpful i have one question as you said from CSV converting into QBO we should have only three columns date, Description and Amount but i have Bank Statement with Debit and Credit and then Balance in this situation i should have only three columns and then which column i will take last one with Balance or two of Debit and Credit?

[@HectorGarciaCPA]

debit/credit...... balance is irrelevant

[@holdontight1981]

If this conversion software is working well, why doesn't QB buy this software and incorporate it? It has been more than 5 years since this converter came out. I am curious.

[@HectorGarciaCPA]

They never cared for it I guess.. is a good question

[@MrJohnreggie]

You say that the bank chase gives many options to download the activities of the accounts, but the csv options does not lower the same format that shows in the bank online ... being that other banks similar appears in the account online activity. How to then have the same format with the columns Date, type, descriptions, Debit, credit, Balance

[@HectorGarciaCPA]

Crystal Crusher you are at the mercy of what the bank allows you to download

[@MrJohnreggie]

I did not understand your answer, I said that the other banks give you the option to download the csv in the Excel worksheet the same way that the agent sees in the account activities (DATE, TYPE, DESCRIPTION, DEBET, CREDIT, BALANCE)

[@hexgarcia]

I dont know what else you want me to say..

[@beyenetekle8429]

Hi Hector, after uploading the file, does QB tell you of any duplicate transactions ? Please advise.

[@HectorGarciaCPA]

No.. you can certainly get duplicates this way

[@roomgallery6957]

Dear Hector, I have just discovered your amazing tutorials that detail everything i need. I do however have a question ...as I am working as a non profit organisation in South Africa focused on emerging visual arts i really need to research software before we attempt to purchase it (the exchange rate is incredibly unfavourable)...how do i use the 2qbo software to convert into South African Rand as well as associate it to my bank here in South Africa?

[@HectorGarciaCPA]

ROOM Gallery I really have not tried it outside US

[@roomgallery6957]

Can you advise me who to speak to at teh company who is distributing /making teh software?

[@roomgallery6957]

i am using desktop pro and need to import a whole lot of statements what would be the best way? Excel seems like the option as entering many years statements manually is a nightmare. Please advise

[@HectorGarciaCPA]

ROOM Gallery if you have it in excel; you can convert to .QBO to be able to import

[@HectorGarciaCPA]

ROOM Gallery in QuickBooks? I don’t know in SA

[@matth.4932]

great video! I had Quickbooks pro 2014 desktop and they told me I had to update to 2017 to be able to download bank transactions and then into quickbooks; I download the qbo file from my bank. Is you PDF to QBO file a work around so I don't have to update quickbooks every three years? I am a one man business so don't have much money to renew every three years. thanks so much!

[@HectorGarciaCPA]

Matt H. I think you may have to.. because QB itselft may not launch Bank Feeds

[@matth.4932]

Ok thank you so much. In that case my bank and credit card allows qbo files. Going to install QB Pro 2011 which is out of support and see if I can import manually. Thank you so much!

[@WmRedd]

Thank you for this video.... I have used QB in the past 2000-2009 Due to an injury I was unable to work. Just getting back to starting my new business. I have QB 2013. I use Chase. Can I stop on the Video where you show how to use the .QBO or do i need to learn how to convert the PDF file also? Thank you so much for your help.

[@HectorGarciaCPA]

+Mark Pollard .qbo files work great if you can get them!

[@carlosizquierdo3923]

Hector, we just purchased Quickbooks Online this morning and I have been trying to upload my QBO file all day, but have been unable to. Your video shows an "Upload File" option in the upper right hand corner, but when I am logged in on the Bank Transactions page, I do not have that option! Why wouldn't I have that button/option!?

[@HectorGarciaCPA]

+carlos izquierdo is there...

[@leonorrivera6379]

What about the sales tax? How will it be recorded if it's for example office supplies because you're uploading the total amount?

[@HectorGarciaCPA]

In the us, there is no need to record sales tax from expenses

[@leonorrivera6379]

@@HectorGarciaCPA Thanks. In Canada, it's a requirement. I'll have to split then some transactions and enter the sales tax portion manually. Overall, still efficient to import data.

[@jandemirkan8073]

Hi Hector, I was hoping that you have a solution for me. I'm working with QBO-PRO+ to convert bank PDF files. PNC Bank statements have many characters on item lines before the Payee Description. I have for many item lines, 20 garbage characters before the actual Payee name. I always convert PDF file to CSV first, clean up the data before converting to QBO file. Does QBO-PRO+ software allow more than 31 characters on a conversion before importing into Quickbooks. .. thanks Jan.

[@markharvey5001]

Hector, when showing the .csv example, I did not see a total of credits and debits on the top. Is that feature available on the .csv conversion? It showed up on the PDF version and you illustrated the fact. But again, on the CSV example, it did not appear that summations of credits and debits were provided. Please comment.

[@HectorGarciaCPA]

+Mark Harvey the banks dont include the totals in the CSV file

[@rbljackson]

My bank data normally downloads automatically in QBO. But im missing about a 4 month period of bank transactions for 2019. If I download the CSV file and then delete all the unnecessary data (rows) within excel and then import the CSV file directly ( I dont have the converter you are discussing here), im guessing it imports that data that I have left on the CSV file. BUT>...will it overwrite/ will I loose all the other transactions that are currently in the Review screen that are for 2020. I have lots of transactions that I still need to review. ??

[@sarahalloush3170]

Hi Hector, thanks for the video! Could you please explain how to do this with macbook quickbooks 2016. When I go to utilities tab I don't get an import option, I get options to verify data, rebuild data and codense data. Do you know how I can import Excel?CSV files? Thanks!

[@HectorGarciaCPA]

Mac version can import data this way..

[@sarahalloush3170]

@@HectorGarciaCPA I see. So the only way to import CSV/Excel files is to convert it to QBO using the program? Do you know of any free programs that could do the conversion? Thank you so much for your help!

[@HectorGarciaCPA]

Sarah Alloush i don’t know if one... moneythumbs is $60

[@donnafletcher5386]

Smart dude! Thanks.

[@NBS_Jerry]

It converts well, but having problems downloading all transactions. How is Customer Support?

[@HectorGarciaCPA]

emailed them

[@DriveBigTrucks]

I agree. I can only download 11 of 286 transactions. Stumped. =(

[@hexgarcia]

if you send them your statement, they can tell you if there is something wrong with source file

[@michellhemingway2091]

I have downloaded the converter page it works great. I was able to do one transaction. One issue I'm having after I converted it and go to upload it my Web Connect say " There are no new transactions available. Please check again tomorrow. I'm going to keep trying it and do a different month. The one thing I'm having a problem with is the deposits. They are coming up but when I check my QB Check register my deposits are not there. Do you have a link on how to upload deposits. Thank you

[@HectorGarciaCPA]

Michell Hemingway try tech support.. hard to tell from your description

[@brilove-ur4vo]

hi there! I am new to quickbooks on a Mac. in the past I would manually type in the bank statement information (i.e. deposits, transactions, checks, etc.). how do I do that on the new quickbooks for Mac?

[@HectorGarciaCPA]

+brilove1126 import the .QBO files from the bank.. or convert them using 2qbo.com Convert Pro software

[@aliciafowler3933]

I appreciate your videos. How can I convert (bank statements) scanned pdf files into .CSV files (Mac)? My Quickbooks Online for Self-Employed does not accept .QBO files...

[@HectorGarciaCPA]

+Alicia Self-Employed QuickBooks Self-Employed does not handle this.. you may need to upgrade to QuickBooks Online Essentials.

[@aliciafowler3933]

+Hector Garcia (CPA) Do you think I'd be able to use a program that you mentioned (or any other) to add some extra steps and that would convert SCANNED PDF --> QBO --> EXCEL --> CSV ? It seems like a lot of extra work, but if it's possible and that's what it takes...

[@deloreswilliams5744]

Hi I am more interested in assigning the Account numbers/categories etc to the bank transactions after they are downloaded. I have 753 transactions that I do not want to touch each one of them. I have the information in excel already

[@HectorGarciaCPA]

QB desktop or Online

[@vistron888]

Hi Hector, When you're telling Quickbooks how to categorise each debit on your imported bank statement - is it automatically making the bill for it and showing it as paid? Because currently I create a bill with 'Enter Bills' then go to Pay Bills to show which account they are paid from and what date.

[@HectorGarciaCPA]

V T no... ir you create the bill.. you must “pay bill” first, then match it via Online Bank Feeds

[@vistron888]

Ok, but if I don't create the bill first, will it create it automatically once matched to the bank feed? Currently I work through the bank statement just making the bill as I see the entry on the bank statement, not from receiving an actual bill.

[@HectorGarciaCPA]

V T no it would just create a “check”

[@vistron888]

Ok, thanks. I don't see the time saving advantage over just entering from a physical statement then. :-)

[@HectorGarciaCPA]

V T it’s night and day.. just don’t create the bills

[@mariadelfierro5442]

Hi Hector, Would you know if it is possible to import an estimate to QuickBooks Construction 2016 via excel? Thanks for your help in advance.

[@HectorGarciaCPA]

+SavEli Story you need a 3rd party software like TPI or Zed Axis

[@fahimsblog3282]

Dear Hector is there any free software by which I can convert a pdf file into qbo? Pls, let me know. thanks for your video.

[@HectorGarciaCPA]

Fahim Shahriar I don’t think so... that is very complex technology. There are “alternatives” like Able2Extract or PDF2XL but they are just not designed to work as well as 2qboConverter

[@fahimsblog3282]

@@HectorGarciaCPA Ah I understand, thank you for your positive and quick responses. At this moment I cant buy the software. Could you help me converting a pdf file into proper QB or CSV format? Thank you again.

[@epowell1017]

Hector, thanks so much for the video. This is super helpful. I just purchased QB for Mac and am attempting to import old transactions from my credit card into QB. I downloaded the QBO file but when I try to import it, it doesn't give me my credit card as an option to import it into. It lists the account type as "creditline" and the only accounts it will allow me to import the file into are "payroll liabilities" or "new." I tried to create a new file, but it didn't work. Can you help? Thanks!

[@sueinvermont1171]

You did create an account for the credit card in your QB company before attempting the import, yes?

[@hexgarcia]

you must have chosen BANK when creating the conversion

[@vickyholland7130]

I am trying to download a citibank visa CSv file into QB online. It appears I have a formatting problem between formats. I keep getting an error. Is there a special conversion program? Citibank does not have a qbo format download. It is frustrating. I have not tried pdf files yet. Vicky

[@HectorGarciaCPA]

The best think I could do for you is quickly glance at the CSV File to see. But usually I never see a formatting error from the bank files. And YES, there is a conversion tool, is called CSV2QBO, is worth like $60 at www.2quickbooks.com

[@teresas.7969]

I've been stumped with using pdf2qbo converter...worked on a couple of pdf downloaded bank statements but now when I try to convert it's only reading all the transactions as Credits. Have you seen this or know a fix? Thanks!

[@susayshafer7749]

Major question. QuickBooks Premier 2013 has locked me out until I update to 2016. We have closed the company this year so I do not want to purchase another expensive software package, but I need to close out the year end books. When I try the work around I still cannot import the checking account information for the QBO files. Is there any other way to get the information around their lockout?

[@HectorGarciaCPA]

+Susay SHAFER Bank feeds is not supported in 2013 or older!

[@ruthchaverra7936]

Great video!! thank you

[@judebierau]

My 2016 qb desktop account will it still let me do pdf2qbo web connect? - I've used it in the past and a life saver but now having trouble b/c 2016

[@somenmondal1245]

Ok. I will inform you very soon. Best wishes to you.

[@supermom6094]

How do I fix reconciliation discrepancy? This is first time I'm doing this and there is a missing check payment in QB, but on bank statement. How do I fix this?

[@HectorGarciaCPA]

there are other videos on that topic.. search it, its too long to explain via comments

[@nannonriechel3179]

Hi Hector. I'm having issues with PDF2QBO. The conversion is not bringing all my transactions into qbo? How do I fix this? It is leaving a few transactions out?

[@HectorGarciaCPA]

Nannon Riechel i have the same problem sometimes... it reads maybe 95% of the transactions. This happens with abnormal bank statements. There isn’t much you can do.

[@nannonriechel3179]

Thanks Hector. Much appreciated. How do I add the ones it leaves out? Just record as an expense and the in account history mark it as C?

[@HectorGarciaCPA]

Nannon Riechel add each one by one.. then reconcile it in the bank reconciliation screen... DONT CLEAR THEM MANUALLY WITH THE “c”

[@pakbar]

When I add the account and payee and select action (Quick Add) it only adds that single transaction and not the other 50 similar transaction. My software is up to date. Quickbook does not seem to learn!!

[@HectorGarciaCPA]

close and open again

[@jillworkman3902]

I am trying to sync my bank with QBs more than 3 months ago, but I use direct connect, not web connect. How can I do this?

[@HectorGarciaCPA]

Direct connect is limited to whatever the bank sends you. But you can still import a .QBO webconnect file even with a direct connect bank via the menus

[@MrRayraychung]

Hihi I have use iif upload method to import bank transaction as general journal to quick. after import, all type becomes checks instead of general journal may I know why

[@HectorGarciaCPA]

+Chung Ray stop using IIF method... use .QBO file Via Bank feeds

[@vbhunny13]

Hector does this work if I am trying to upload into the desktop version as well? I am struggling to figure it out

[@HectorGarciaCPA]

Yes; works with both

[@gisellediaz2637]

Hi Hector, I converted all the statements to QBO but when I'm uploading them after I click WEB CONNECT the window to select the credit I would like to use doe not open instead the window to download from Bank of America opens which ask for my password and it says that there is nothing to download.Please help me

[@HectorGarciaCPA]

call support 1-800-4INTUIT

[@debrawise7749]

I tried to Export Transaction History via Web Connect with my bank who has the Quickbooks.qbo selection. However, I received this error '[Window Title] C:\Users\User\Downloads\Acct_5228_03_01_2019_to_06_02_2019 (5).QBO [Content] This file does not have an app associated with it for performing this action. Please install an app or, if one is already installed, create an association in the Default Apps Settings page. [OK]. I've checked through my Default Apps setting but don't see one for .qbo which I'm assuming is what I need. Is this app something I have to purchase or can I add it somehow? Thanks for the help. I imported through Quickbooks from my bank but it only pulled in the last 6 months but I need to pull data into QB prior to this date so was trying to manually export following your tutorial. Any help would be appreciated! Thanks

[@HectorGarciaCPA]

Don’t double click on it... just do the import inside QB

[@debrawise7749]

@@HectorGarciaCPA It worked. Thank you so much for your help. I'll be viewing your videos for further knowledge!

[@jandemirkan8073]

Hi Hector, I'm working with QB Desktop 2021.. always having a problem importing QBO files with TD Bank. Would the QBO-PRO software allow me to download CSV files from TD Bank ... convert to QBO file with QBO-PRO. Would this path solve my issues for TD Bank QBO imported files... thanks... Jan

[@HectorGarciaCPA]

Yes, thats exactly what it does. You only need the $60 software

[@jandemirkan8073]

@@HectorGarciaCPA Thanks Hector...

[@jandemirkan8073]

@@HectorGarciaCPA Hi Hector, I purchased the CSV File to QBO converter just like you advised... In addition, I need the PDF to QBO converter too.. Do you know if there is an add on option ?

[@HectorGarciaCPA]

@@jandemirkan8073 yeah contact them

[@dianaking199]

I downloaded my account from the bank. I worked on it. I got out of the program. I am not sure if I saved it, or didn't save it correctly. Somehow when looking at it again, the information I typed in was gone. Now I don't get the full information I downloaded - and it won't let me re-download it - I think because it is somewhere in there but I can't find it now.

[@HectorGarciaCPA]

call QuickBooks, I cannot diagnose it without looking at it

[@jewlizardjane9696]

what about bank statements with cancelled checks how do they download to quickbooks

[@devildark5971]

HI I want to Change the address in one cell when I have a location colum in my table when I filter the location in table I want the address to be changed in one cell that it would reflect the address in one cell

[@HectorGarciaCPA]

I think I would need to see it, I can’t follow

[@bethmaldonado9241]

Wait so this is transactions or bank statements? Our bank goes back only 6 months of transactions but we need to get 2 yrs worth data into QuickBooks. I know how to do transactions but how bout if statements is all there is?

[@HOAREGROUP]

Great tutorial , thank you , can PDF2QBO manage multi currency PDF statements, i would be uploading statements with up to 4 different currency's

[@hexgarcia]

i would ask them.. i dont know

[@danielcharles8898]

Hi Hector! I have learned so much from you, and the above video is the latest example. One question though. How do you categorize a transfer between your business checking and savings account in quickbooks?

[@HectorGarciaCPA]

Daniel Charles no category.. just choose the account where the money is going to... the ACCT must be in the cart of accounts as well

[@jackmarris7576]

Hi I have downloaded a trial version to check this works with my bank's pdf statements and it claims it cannot find text in the document despite it being an original digital pdf downloaded direct from the bank website. Any help or tips?

[@HectorGarciaCPA]

+Jack Marris get the PLUS version of the software that does OCR

[@jaandel1]

do you have the template to upload to Quickbooks regardless the bank format?

[@HectorGarciaCPA]

There is no template.. the file is coded in a very specific way.. you need a CSV2QBO converter.

[@davidklein1989]

Awesome, thanks!

[@AmySatori]

Does it matter if I download with transaction details?

[@HectorGarciaCPA]

+Amy Satori yea

[@markofibo]

I have csv from PayPal and want to convert to qbo. I'm looking for someone to help me massage the csv prior to converting it to qbo for optimum functionality in quick books. Lots of repeat transactions in PayPal and no categories. PLEASE HELP

[@HectorGarciaCPA]

Mark Ledermann look at Nerd Enterprises (Seth David)’a channel

[@juliusmart2878]

this QB include Payroll?

[@HectorGarciaCPA]

cant import payroll

[@marthamedina4533]

This video is from a few years ago is there and New easy way PDF to convert CSV

[@HectorGarciaCPA]

Nope... everything in this video is 100% current

[@marthamedina4533]

@@HectorGarciaCPA ok thank you

[@CAGauravVerma]

Can we do that in QB desktop pro UK edition.

[@HectorGarciaCPA]

I dont use UK version sorry

[@michaelmohan6628]

I imported it but i cant see the transaction listings on the Quickbooks??

[@HectorGarciaCPA]

+Michaell Mohan they are in bank feeds, you need to add them now

[@eliudgathungu6773]

thank you CPA Eliud