Import/export transactions with IIF file from one QuickBooks Desktop company file to another
Vložit
- čas přidán 28. 06. 2018
- QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary from $195 to $545) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com
Purchase QuickBooks DESKTOP:
www.quickbooksprice.com - Věda a technologie
Thank you for this video. The trick showing how to open Tech Support menu is invaluable!
Thanks so much! I was able to export my transactions and import them into a new company file (effectively the last step to merge two company files.) Huge help! :-)
Great
This trick really saved me! On another note if you're downgrading from Quickbooks Enterprise to the Desktop version you will need to delete the first two lines in the iif files. Thanks Again!
Great point.
The tech support trick really did save my day
Your videos are totally informative! You saved me a ton of headache! Thank you so much!!!
You welcome
Thank you so much for this video! Very helpful!!
Wow😍thank u sir u saved my holiday👍
great video, that short key to access support menu is priceless, i have this question by mistake some transactions where created on a company file instead of the correct company file for near 2 months, if there a way to export the transactions created on the wrong file to be imported into the correct file? i will appreciate any suggestion to adjust the correct company file with the missing transactions
Very good overview of how importing works. thank you.
:)
Thank you so much. I could import my files following your video.
Don’t know
amazing video Hector!
Awesome.
OMG You are amazing! THANK YOU!!
You welcome
Thank you so much, Hector!
You welcome
I have an iif file working well to import Bank transactions in the home currency Canadian dollars. However it is giving errors when importing USD amounts (multi-currency mode QuickBooks desktop pro 2018). I have the GL bank account setup as USD and I have the vendor set-up as USD. It still gives me an error stating that bank account and the payee have to be the same currency which they are. Have you come across this and solved this issue?
Nice video Hector
Thank you so much teacher
Super Ayuda, Millon de Gracias!!
Thank you Sir. Very Helpful!!
Backcountry Goods Trading you welcome
Tech support hidden menu saved me Thank You
Great
Great Job 😀
Thank you! Cheers!
It doesn't work where entries in the previous QB have another currency. Eg my company is in EUR and I have transactions in USD (therefore I've input the USD/EUR rate on previous while recording entries). However, when I migrated data in the new QB, it took the entries in USD and disregarded the rates. Can you please help? Thank you.
It Works 100% Brother Thank you and have A Grate DAY,
Mahery Tech TV awesome
Hi Hector,
This is a great video, it really helpful.
How I can Excel data from QBE to Excel without blank colunm?
Thank in advance for your assistance
OMG! THANKS! LIFE SAVER! Can downgrade from Enterprise to Pro, make Enterprise files backwards compatible from QuickBooks Enterprise to Pro without the BS! Awesome
Its not perfect, but it can convert most transactions
Do you know what would happen if you import to a new company that has already been in use? Same company different EIN different states.
If you do not have excel, can you still perform this import/export?
thanks brother I very like this video .
You're Awesome!
Great information.
Will this work if it is not the accountant version?
Hi how to merge 2 files? an exported file to an existing file from primary PC of Quicbooks
You are a master
It's very helpful ! Do you know if we can export only some periods of the company file ? For instance, the company file data is from Jan 2018 to April 2019 and we need only the data from January to April 2019 .
You can’t... that would be incredible.
its really helpful vedio
I only need to import 3 bank account files into a new company. How do you do this?
Thank you, that was helpful! I wonder if this would work if we are moving to QB file without classes from the QB file with classes, the rest all the same.
never tried it.
Very helpful! Do you know if this can be done on the Mac desktop version?
It cant
Hi i have lost my admin password and no export iif transaction file without admin password please guide me thanks
hi dear hictor i have one problem , i am owed from a company the company bought ticket for me now i want to pay to company 131 every Month and the total amount is $3000.00 how can i record this to QuickBooks?
Thanks!
Welcome!
Hello Hector - Can you import only the last years information and transactions rather than all?
No.... unless you open the IIF file and identify the transactions some how.
Sorry Write what to show tech Support ??
Hi, Hector, is possible to export only the transaccion that we need, example: only estimate or invoice ?
No
Did you find the way to export payroll and payments? Actually I want all data to be imported to another software I.e., Odoo
Cant do it
I changed to multiple currency can I go back to single currency since I want income tracker and bills tracker icon to show on my screen
Bakari Mogere no
I am working in QB Enterprise 2020. I don't have the "tech support" in my help tab. Any suggestions as to how I would import my invoices? That is all I am needing. I am working via server. Thank you.
beinggood4U this is not supported by Intuit.. so if the video doesn’t work, you might not be able to. Or use a 3rd party app like transaction pro importer.
Did you do the CTRL/ALT DB thing?
I am unable to find tech support option under help menu. Could you please help me on that?
You need to use the keyboard combination
Héctor, I really need your help. I followed exactly your tutorial. how to export then import. when I got my IIF file and I import to quickbooks immediately I got an error message. what does this mean did I miss something can you help
When you import, there is a second option called “import anyway, ill fix later” something like that
Hae if I wish to import gls into a new quickbooks how do i go about it?
Eliud Gathungu there is a video on Journal Entries in my channel
Is there a way to set parameters on the lists to export, such as active vendors only?
No... would be nice
Is it possible to import from a certain date on? I need to export and then import from 1/1/2019
Santi Susbielles i wish!
@@HectorGarciaCPA Maybe deleting those transactions before from the excel?
Santi Susbielles yes that would be the only way
very good
Thank you
I am trying to follow your instructions - does this work for Quickbooks Desktop 2016? It doesn't seem to be working for me. Thank you!
Melina Nmili should
@@HectorGarciaCPA on a MAC? I am finding About quickbooks not under help but under Quickbooks and when I follow the steps of selecting it and ALT Control DB nothing happens :(
Melina Nmili PC only.
Any way we can export data from quickbook for last year and input in new qb file with out condance data?? If yes than how
No.
@@HectorGarciaCPA your company provide qb condance support..? We try but so many error..
hello Hector , i wonder if i can transfer QBO data to QBD data once the QBO tool is not working as it is a global version
There are no free tools for this out there
@@HectorGarciaCPA
Thank you for your fast response which tool do you suggest to use even if it is not free
Thanks again
have you ever setup quickbooks desktop pro to track Crypto Trading ?
I don’t have a video on that
Is this possible for Quickbooks Desktop 2020 Mac? Thanks in advance.
No
Hector Garcia CPA that’s too bad.
Thanks for the response 👍🏻
Is there a keyboard shortcut to File->Utilities->Import->Timer Activities
No, feature was removed in 2022
Is exporting possible from quickbooks online?
Not in this matter
What is the crazy time number in the HDR of the time sheet IIF file?
No clue
@@HectorGarciaCPA The best I could find is that QB calls that the time the file was exported. But, what format? Seconds, minutes, ?? If you don't know I'm sure no one does!!
I can't see the Tech Support from Help Button...
US version only
@@HectorGarciaCPA - I have US Version but don't have the Tech Support Option. Bummer
One question can i do the same with Quickbooks online?
No.. QBO cannot do this.
@@HectorGarciaCPA Is it possible to save all of these transaction files from a desktop version and import them into a Quickbooks online file?
Anybody know how to open tech menu on quickbooks 2015?
Should be the same
Can I choose foreign currency in general journal iif file ?
Not sure
@@HectorGarciaCPA or invoice ?
How can I convert from Enterprise to Desktop Pro plus? These steps did not work and I am kicking myself that they convinced me to switch UGH HELP PLEASE
Customer Service that is not an option.. there are no builtin tools for downgrading from enterprise
UGH I find an option to download from enterprise to online but nothing from enterprise to desktop pro one would think if you are using desktop pro in enterprise and go back to regular desktop pro that they would be one in the same I have been going back and forth with quickbooks since August and its beyond frustrating and crazy!!!!!
Customer Service there just isn’t a process for that. Is not design to convert down.
export from QB enterprise to QBO then convert back to QB desktop pro plus. it's worked for our firm in the past. takes about 30 min to an hour to do it.
I don't have "Open a second company file"
Because you don’t have Accountant Edition.
I’m asking that because i was using quickbooks for one month but i open a new account so i can have the discount 50% off
Not sure what your question is..
Hector Garcia CPA w puedo pasar toda la información que tengo en la otra cuenta ? Pues pague este mes de enero precio normal pero anoche agarre la promoción de el 50% no hay manera de pasar todo automáticamente o tengo que hacerlo de manera manual?
Angie Diaz si hay pero te va costar más..
Angie Diaz hay un app que se llama Rewind
Hector Garcia CPA ok
Thanks A lot Hector . Is There any way for faster way
abdelwahab ahmed no
@@HectorGarciaCPA We did the importing , but we faced an issue that The iif imported "Inventory Transfer " as Journal and it did mess up the inventory valuation. What is your advice
abdelwahab ahmed it’s not a perfect process. You would need to add the missing transactions manually.
hector are you live
yes I am Alive