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

Рет қаралды 226,454

Күн бұрын

Purchase 2qbo Convert Pro+ for $499 at www.moneythumb.com/converters... (converts QBO, CSV, EXCEL, PDF, and QIF file types )
NOTE: Updated Video 2021 = • Importing PDF Bank & C...
Topics covered in this video:
00:00:00 - Introduction (how to download bank transactions into QuickBooks).
00:00:48 - File formats from the bank (.QBO file, CSV file, QIF file, PDF bank statements) and explaining each one of them.
00:03:02 - Chase bank example to download a type of file (step by step) (QBO, CSV, QIF).
00:06:04 - After downloading the file you choose, search your file by the name of the one you download and open it.
00:06:42 - Access to QuickBooks online and convert the file from different formats (.QBO in this case).
00:06:44 - How to upload the file in QuickBooks online (go to transactions, banking and click on file upload, then choose the file clicking on browse and importing it from downloads, hit next and select the bank account that you want to connect).
00:07:54 - Categorizing accounts on QuickBooks online.
00:09:06 - Explaining the same process to upload the file but in QuickBooks Desktop (steps: file menu, utilities, import, web connect files, import your .QBO file).
00:10:38 - Categorizing accounts QuickBooks Desktop.
00:11:23 - PDF bank statements (could be an original PDF downloaded from the bank account or scanned PDF from paper bank statements).
00:12:12 - How do you know when a PDF is an original version from the bank.
00:12:37 - Tool 2QBO convert pro and how it works.
00:17:09 - Difference when the PDF has been scanned from the bank statement.
00:17:48 - PDF plus version (tool that can read scanned statements).
00:19:25 - How to manually add payments in case the program misses a payment.
00:19:51 - CSV or Excel files (obligatory 3 columns: date, payee, amount) and how it works.
00:22:40 - Options.
00:23:55 - Convert software website.
Or, more defined use tools that only convert CSV or PDF files:
PDF2QBO+: www.moneythumb.com/shop/pdf2q...
CSV2QBO: www.moneythumb.com/shop/csv2q...
If you have the transactions in a PDF Bank Statement, or CSV / Excel file, .QBO, .QIF, or OFX files, then this comprehensive guide will show you all the options built into QuickBooks (all versions: Pro, Permier, Accountant, Enterprise, Mac and/or Online) and a 3rd party tool you can purchase to accommodate different file types. Manual Upload of qbo webconnect files converted from .pdf or .csv
QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
(30% discount offer to expire 9/30/2021)

Пікірлер: 230

@HectorGarciaCPA 3 жыл бұрын

UPDATED VIDEO (2021): kzfaq.info/get/bejne/nqhkbLCT1LXKcmw.html

@lcdebaca 7 жыл бұрын

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.

@commonwealthinvestigations5241 7 жыл бұрын

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!

@Thediamondaire 7 жыл бұрын

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

@theodorethomas8010 8 жыл бұрын

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.

@lesliesimmons9951 8 жыл бұрын

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 8 жыл бұрын

+Leslie Simmons Thanks, glad this helps you.

@jefflester5014 2 жыл бұрын

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

@carolinewheeler8197 3 жыл бұрын

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 KZfaq.

@bfourney 8 жыл бұрын

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 8 жыл бұрын

awesome

@HectorGarciaCPA 7 жыл бұрын

+blondre3000 great.. the PDF converter is great

@dapoirierinc 7 жыл бұрын

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

@somenmondal1245 8 жыл бұрын

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"

@bazmanmedia2050 4 жыл бұрын

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

@sweetchild1975 8 жыл бұрын

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

@debbiewhite1139 4 жыл бұрын

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 4 жыл бұрын

Awesome!

@jamesminer7492 8 жыл бұрын

Helpful, easy to understand, good presentation.

@savealot2 8 жыл бұрын

This video was great! Thank you very much!

@teresahutchinson4029 7 жыл бұрын

Thank you for the information, got it uploaded

@statwizard 8 жыл бұрын

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

@EXCELCORAL 8 жыл бұрын

Excellent Hector , thanks for the advice

@liuguiyan4620 2 жыл бұрын

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

@somenmondal1245 8 жыл бұрын

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 8 жыл бұрын

ok great

@kenyagrooves 8 жыл бұрын

Very helpful, thank you!

@aliharatian5666 8 жыл бұрын

Great Job Hector!

@CaptainDeebag 7 жыл бұрын

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

@HectorGarciaCPA 7 жыл бұрын

+CaptainDeebag great

@andrewmiller7886 5 жыл бұрын

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 5 жыл бұрын

Great point

@kristinawilliams5064 3 жыл бұрын

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.

@ruthchaverra7936 8 жыл бұрын

Great video!! thank you

@BayareaSolutions 26 күн бұрын

You just made my life easier, thank you much

@HectorGarciaCPA 26 күн бұрын

@donnafletcher5386 3 жыл бұрын

Smart dude! Thanks.

@melindaburnside7189 3 жыл бұрын

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

@dennisbeyer2108 8 жыл бұрын

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

@davidklein1989 7 жыл бұрын

Awesome, thanks!

@teresas.7969 7 жыл бұрын

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!

@Revmasterofin5 5 жыл бұрын

You're the man! Subscribed!

@HectorGarciaCPA 5 жыл бұрын

Thanks :)

@rbljackson 3 жыл бұрын

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. ??

@danchurchillcooks 7 жыл бұрын

Mate amazing help... thank you Dan

@HectorGarciaCPA 7 жыл бұрын

+Dan Churchill :)

@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.

@judebierau 4 жыл бұрын

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

@carlosizquierdo3923 8 жыл бұрын

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

@HectorGarciaCPA 8 жыл бұрын

yes..

@jewlizardjane9696 7 жыл бұрын

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

@juntodorovic4175 Жыл бұрын

Very useful information

@HectorGarciaCPA 5 ай бұрын

Thanks

@TravelWithLynna 7 жыл бұрын

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 7 жыл бұрын

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

@nathanhay9157 8 жыл бұрын

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 8 жыл бұрын

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

@eliudgathungu6773 8 жыл бұрын

thank you CPA Eliud

@rupanshi87 8 жыл бұрын

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 8 жыл бұрын

Receipt Bank is probably the best app for that

@macbelwoldie631 8 жыл бұрын

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 8 жыл бұрын

through bank feeds, you cannot import Invoices

@markharvey5001 8 жыл бұрын

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 7 жыл бұрын

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

@angeladimalanta858 7 жыл бұрын

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 7 жыл бұрын

Angela Dimalanta probably... i dont know Canada

@beyenetekle8429 3 жыл бұрын

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

@HectorGarciaCPA 3 жыл бұрын

No.. you can certainly get duplicates this way

@somenmondal1245 8 жыл бұрын

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

@vbhunny13 4 жыл бұрын

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

@HectorGarciaCPA 4 жыл бұрын

Yes; works with both

@mariadelfierro5442 8 жыл бұрын

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 7 жыл бұрын

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

@brilove-ur4vo 8 жыл бұрын

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 8 жыл бұрын

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

@MrRayraychung 7 жыл бұрын

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 7 жыл бұрын

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

@bradlehrer3470 7 жыл бұрын

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 7 жыл бұрын

bill.com

@vatsalthakkarcpa8583 7 жыл бұрын

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.

@susayshafer7749 8 жыл бұрын

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 8 жыл бұрын

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

@davidr4523 8 ай бұрын

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 6 ай бұрын

No you must be in a supported version

@hugoloyo7796 3 жыл бұрын

very well

@vickyholland7130 6 жыл бұрын

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 6 жыл бұрын

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

@TaxHelpUSA 9 жыл бұрын

Thank you! Anastasiya D.

@carlosizquierdo3923 8 жыл бұрын

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 8 жыл бұрын

+carlos izquierdo is there...

@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

@aamiriqbal8346 7 жыл бұрын

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 7 жыл бұрын

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

@Mymusicfmw33 5 жыл бұрын

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 5 жыл бұрын

There are many videos in KZfaq

@gisellediaz2637 8 жыл бұрын

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 8 жыл бұрын

call support 1-800-4INTUIT

@supermom6094 7 жыл бұрын

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 7 жыл бұрын

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

@jackmarris7576 8 жыл бұрын

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 7 жыл бұрын

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

@bethmaldonado9241 4 жыл бұрын

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?

@markofibo 5 жыл бұрын

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 5 жыл бұрын

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

@AmySatori 7 жыл бұрын

Does it matter if I download with transaction details?

@HectorGarciaCPA 7 жыл бұрын

+Amy Satori yea

@epowell1017 8 жыл бұрын

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 8 жыл бұрын

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

@hexgarcia 7 жыл бұрын

you must have chosen BANK when creating the conversion

@jaandel1 5 жыл бұрын

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

@HectorGarciaCPA 5 жыл бұрын

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

@nannonriechel3179 5 жыл бұрын

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 5 жыл бұрын

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 5 жыл бұрын

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 5 жыл бұрын

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

@deloreswilliams5744 8 ай бұрын

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 6 ай бұрын

QB desktop or Online

@sarahalloush3170 5 жыл бұрын

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 5 жыл бұрын

Mac version can import data this way..

@sarahalloush3170 5 жыл бұрын

@@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 5 жыл бұрын

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

@debrawise7749 4 жыл бұрын

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 4 жыл бұрын

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

@debrawise7749 4 жыл бұрын

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

@aliharatian5666 8 жыл бұрын

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

@HectorGarciaCPA 8 жыл бұрын

sorry dont understand the question.

@aliharatian5666 8 жыл бұрын

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 8 жыл бұрын

+ali haratian right. dont duplicate them

@aliharatian5666 8 жыл бұрын

Thank you so much !

@michellhemingway2091 7 жыл бұрын

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 7 жыл бұрын

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

@devildark5971 4 жыл бұрын

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 4 жыл бұрын

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

@fahimsblog3282 5 жыл бұрын

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 5 жыл бұрын

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 5 жыл бұрын

@@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.

@aliciafowler3933 8 жыл бұрын

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 8 жыл бұрын

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

@aliciafowler3933 8 жыл бұрын

+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...

@pakbar 8 жыл бұрын

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 8 жыл бұрын

close and open again

@paulaaradi5849 2 жыл бұрын

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

@HectorGarciaCPA 2 жыл бұрын

For free via KZfaq, just watch all the videos

@matth.4932 7 жыл бұрын

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 7 жыл бұрын

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

@matth.4932 7 жыл бұрын

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!

@dianaking199 4 жыл бұрын

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 4 жыл бұрын

call QuickBooks, I cannot diagnose it without looking at it

@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

@leonorrivera6379 3 жыл бұрын

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 3 жыл бұрын

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

@leonorrivera6379 2 жыл бұрын

@@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.

@cecevandermeer738 7 жыл бұрын

i'm having trouble finding the bit.lyPDFQBO. I find a lot of ads for it & i'm worried that they are not the right downloads.

@HectorGarciaCPA 7 жыл бұрын

Cece Vandermeer www.2quickbooks.com

@vistron888 6 жыл бұрын

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 6 жыл бұрын

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

@vistron888 6 жыл бұрын

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 6 жыл бұрын

V T no it would just create a “check”

@vistron888 6 жыл бұрын

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

@HectorGarciaCPA 6 жыл бұрын

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

@CAGauravVerma 10 ай бұрын

Can we do that in QB desktop pro UK edition.

@HectorGarciaCPA 10 ай бұрын

I dont use UK version sorry

@HOAREGROUP 7 жыл бұрын

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

@hexgarcia 7 жыл бұрын

i would ask them.. i dont know

@roomgallery6957 6 жыл бұрын

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 6 жыл бұрын

ROOM Gallery I really have not tried it outside US

@roomgallery6957 6 жыл бұрын

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

@roomgallery6957 6 жыл бұрын

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 6 жыл бұрын

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

@HectorGarciaCPA 6 жыл бұрын

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

@TheBellafiore 3 жыл бұрын

Great job Hector, thank you for all your support through your KZfaq 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 3 жыл бұрын

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

@TheBellafiore 3 жыл бұрын

@@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 3 жыл бұрын

@@TheBellafiore “UNDO” maybe

@TheBellafiore 3 жыл бұрын

@@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.

@danielcharles8898 6 жыл бұрын

Thanks

@HectorGarciaCPA 6 жыл бұрын

@michaelmohan6628 8 жыл бұрын

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

@HectorGarciaCPA 8 жыл бұрын

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

@NBS_Jerry 8 жыл бұрын

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

@HectorGarciaCPA 8 жыл бұрын

emailed them

@DriveBigTrucks 7 жыл бұрын

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

@hexgarcia 7 жыл бұрын

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

@danielcharles8898 6 жыл бұрын

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 6 жыл бұрын

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

@MrJohnreggie 7 жыл бұрын

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 7 жыл бұрын

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

@MrJohnreggie 7 жыл бұрын

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 7 жыл бұрын

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

@holdontight1981 3 жыл бұрын

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 3 жыл бұрын

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