Importing Journal Entries into QuickBooks Desktop from Excel/CSV (see description for updated link)

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ต.ค. 2024

ความคิดเห็น • 178

  • @christinalyons6174
    @christinalyons6174 4 ปีที่แล้ว +1

    Just gave this a try in Premier 2020 Contractor Edition sample file and it worked, with multiple entries and with the class and name column deleted, using Excel 2016 on Windows 10. I had issues importing at first, but I think it was how I was saving the original iif file. The key was once I made changes in your template and saved when asked again to save upon exit, I'd say no. If I said yes, saved to csv and then changed the extension, the file would not import - operator error☺. Hector you have helped me manage so many projects efficiently over the years. Thank you for sharing your expertise with us!

    • @HectorGarciaCPA
      @HectorGarciaCPA  4 ปีที่แล้ว

      Christina Lyons great comment, thanks!

  • @emoflo63
    @emoflo63 ปีที่แล้ว

    HUGE HELP! THANK YOU SO MUCH! Started a new job 3 days ago and they were entering large JEs into the GL line by line.. They think I'm a superstar after this video!

  • @SandraBaptist
    @SandraBaptist 5 ปีที่แล้ว +1

    This is a life saver Hector! Thank you so much. We have 600+ lines to upload for 4 years for a client!

  • @jessicaandermann8936
    @jessicaandermann8936 3 ปีที่แล้ว +1

    Hey Hector, Here is my full Account Number - 5000 Cost of Good Sold (COGS):5020 Labor:5020.01 Labor - Straight Time. Would the account number in my import be the full string (5000:5020:5020.01) or just the final segment (5020.01)? Thanks for the helpful video!

  • @miningcrew3505
    @miningcrew3505 2 ปีที่แล้ว

    Thanks Hector!! This just saved me a whole day of key punching data into QB. Yous explanations clears.

  • @keishrich
    @keishrich 6 ปีที่แล้ว +2

    Thank you very much for walking us through this Hector! Bless you!

  • @billogden7975
    @billogden7975 2 ปีที่แล้ว +1

    This looks really good. I am using Access to assemble information maintained by different people. It looks like either the macro or the program would work great. We are using QB Pro 2018. Does the Pro work with all versions of QB? Or do I need an updated version?

  • @JenniferSmith-ci2vp
    @JenniferSmith-ci2vp 5 ปีที่แล้ว

    Thank you! The free template you provided and the video instruction were just what I needed to save me hours and hours of data entry. I got it down to a science and can import a 40 line journal entry in less than a minute. Thank you!!!

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Awesome

    • @EmranChary
      @EmranChary 4 หลายเดือนก่อน

      Whether it can import multiple journal or you have to import one journal upon other

  • @ThemiRush
    @ThemiRush 4 หลายเดือนก่อน

    Hi Hector! Your videos have been a lifesaver. Thank you for everything you do for the Quickbooks community! I have been using your JE (IIF) file to update journal entries for a few months now and it has been working wonderfully without issue. This month, all of a sudden, when I save the spreadsheet with my journal entry, it is saving as a text file rather than an IIF. Any thoughts on what I might be doing wrong?

    • @HectorGarciaCPA
      @HectorGarciaCPA  4 หลายเดือนก่อน

      Are you using my MACRO excel file, or just the sample IIF?

  • @IndiaLacey-g1w
    @IndiaLacey-g1w 3 หลายเดือนก่อน

    This is great! Thanks! Can i put multiple journal entries in the same IIF file? Or I can just keep adding multiple splits that are related to different transactions and it'll just be one long journal entry?

  • @mosesmbugua5848
    @mosesmbugua5848 7 หลายเดือนก่อน

    Very helpful, not sure whether its the version am using , Quickbooks 2021, the transaction type that worked for me is GENERAL JOURNAL

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 หลายเดือนก่อน

      Yeap.. some are “general journal” and others “jounral” its so weird

  • @jcqq8
    @jcqq8 5 ปีที่แล้ว

    thank you for this! I wish I watched this before importing 100 line JEs only to realize QB created bank accounts because the account were not in the right format...even though they existed in COA. Now I'll have fun deleting the accounts and re-import.

  • @dtexter
    @dtexter 3 ปีที่แล้ว

    Thank you for all your videos, Hector. They have been very helpful! I made an IIF file and it worked well but drops the CLASS from the very first line of the IIF upon import. Same line as TRNS. Curious if you know why that might happen? I can easily go to the journal entry and fix the first line to have the class again, if not.

  • @eddiehassell1760
    @eddiehassell1760 5 ปีที่แล้ว

    You are an amazing guide thru the QB jungle - thanks for all your vids

  • @Hds.Incorporated
    @Hds.Incorporated 6 ปีที่แล้ว +3

    In the current 2019 version, Trnstype Journal will not work. Try General Journal and it will work :)

  • @jacobscheiner1376
    @jacobscheiner1376 ปีที่แล้ว

    Hi I'm not a seasoned QuickBooks. I'm a small business owner trying to save $ on QB payroll I write about 50 Payroll checks a year. I found a cheap payroll software that does 941 w-2 and state returns also. There software generates an Excel file with all the payroll deductions. Can I use your tools to import the payroll data to quickbooks. I would like to then be able to also use the payroll reports from QuickBooks

  • @mneo2801
    @mneo2801 2 หลายเดือนก่อน

    Thank you for taking your time to explain this !!!

  • @res46555
    @res46555 ปีที่แล้ว

    Hi Hector, thanks for this very helpful tool. Do you have the same thing for QBO?

  • @dianalegaspiflores9535
    @dianalegaspiflores9535 3 ปีที่แล้ว

    Hector thank you for this video. Very helpful. Does the Transaction Pro Importer website still exist? It doesn't seem to take me to the site where I could purchase that. Thank you!

  • @mariongonzalez994
    @mariongonzalez994 3 ปีที่แล้ว

    I have used the macro it is great thank you - but how can I make the entries NOT billable? I am trying to assign costs to customer but not have them be billed for it?

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 ปีที่แล้ว

      You need to turn off the “make expenses billable” preferences, the macro doesnt make them billable by default

  • @ladyesther3400
    @ladyesther3400 4 ปีที่แล้ว

    Hi Hector, I find your template very helpful. Just a question, do you have an IIF Template for Bills import (with Cost Codes/Item) to QuickBooks Desktop?

  • @hak10491
    @hak10491 2 ปีที่แล้ว

    Hector thank you for the video, question; I see coloumn for class amount and memo what column do i use for JOB?

  • @ExpertTax-w1l
    @ExpertTax-w1l 8 หลายเดือนก่อน

    Just checking before buying your macro: does it work current Excel version (Microsoft 365) and 2023-2024 QB Desktop Accountant version? Thanks!

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 หลายเดือนก่อน

      It does… and if you have issues, we will issue a refund, so no risk

  • @sunchardmarket7365
    @sunchardmarket7365 3 ปีที่แล้ว

    This is awesome and saves a lot of time! Will this work for the quickbooks desktop mac version?

    • @sunchardmarket7365
      @sunchardmarket7365 3 ปีที่แล้ว

      I'm referring to the IIF Journal Entry Template

  • @arunachalamkarunadeva1006
    @arunachalamkarunadeva1006 5 ปีที่แล้ว

    Hi on your video you mentioned that I should not have the Bank account as the first entry. Is this only for the steps 1 (Copy and Paste) or even if I use your Macro and or Pro Importer?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Arunachalam Karunadeva is better if you don’t have a bank for the Macro or the IIF... but Transaction Pro Importer it doesn’t matter.

  • @ren5629
    @ren5629 3 ปีที่แล้ว

    Hector, I'm not an accountant so bear with me. If I take my down'loaded Bank of America Excel credit card statements and I put them into the IIF file template, how does quickbooks know where to put this data? I have lots of accounts (especially other credit card accounts) in my Quickbooks folder. It's also unclear what constitutes a transaction. Is each individual credit card charge a transaction or does this have something to do with date?

  • @mohammadhayati1386
    @mohammadhayati1386 ปีที่แล้ว

    Do you have solution for company NAME in the file , it gives me error even the customer name is available in customers list and exactly typed the same as quickbooks!!

  • @joanvann6059
    @joanvann6059 5 ปีที่แล้ว

    Hi Hector, Thank you so much for your videos they are very helpful. I purchased your macro on Nov 3, 2019 and it works wonderfully until line 68 on the "Tool" tab. After that point I receive an error message regarding the formatting of the date on line 103 (I believe this refers to line 103 of the .IIF file which likely corresponds to line 68 of the "Tool" tab). Is there any way to fix this as I have many journal entries to upload.

  • @mazenbira1776
    @mazenbira1776 5 ปีที่แล้ว

    Hi first thank so much for your videos
    2nd I just bought the macro u mentioned and I need to know if I have full year data and has multiple dates would it work or every day must be loaded separately

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      There is a limit to the number of lines that can be imported... is limited to 1000

    • @eddiemartinez9092
      @eddiemartinez9092 4 ปีที่แล้ว

      @@HectorGarciaCPA Hi Hector you didn't specifically answer Mazen's question..... can you use the tool to upload multiple journal entries with different dates. eg. i wanted to upload a year's worth of rent expense entries can I do them all on one upload or does the date have to be the same on each entry line item?

  • @michelephelps4421
    @michelephelps4421 5 ปีที่แล้ว

    Hector - thank you for the video. Can multiple journal entries be uploaded with the free template or does a new file have to be saved for each journal entry? If I can use this template, do I need the "!ENDTRANS and ENDTRANS lines before each entry? Can you please elaborate on how to do this?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Yes.. but i don’t provide IIF support...

    • @dariusanderton3760
      @dariusanderton3760 3 ปีที่แล้ว

      I'm new to this, but I did get several JE's to import at once. At the end of the JE, I just have one row that says ENDTRANS and then the next row is the next JE. The !ENDTRANS seems to only be needed on line 3, after the other stuff with exclamation marks

  • @denarinderknecht2547
    @denarinderknecht2547 4 ปีที่แล้ว

    Hello Hector. We are using QuickBooks Desktop Contractor 19.0. We just started using a third party payroll company to handle all things payroll. We are trying to import our first payroll file and we are not sure how to import the job costing information (from Item list). The journal entry they have provided only includes Job Names and Class.

    • @HectorGarciaCPA
      @HectorGarciaCPA  4 ปีที่แล้ว

      Journal entries can’t include items, only accounts, jobs, and classes.
      To use items you would need some major workarounds using a check instead of a Journal Entry.

    • @denarinderknecht2547
      @denarinderknecht2547 4 ปีที่แล้ว

      @@HectorGarciaCPA Thank you for the information, very helpful. I am going to share this with our 3rd party payroll admininistrator.

  • @crypticsoul9953
    @crypticsoul9953 5 ปีที่แล้ว

    Hector. my man!! thank you soo much for this. You have saved me hours of data entry.

  • @stormmatthews
    @stormmatthews 5 ปีที่แล้ว

    Hello Hector...quick question. I'm trying to import multiple JEs at a time. I have classes included on these JEs, however, some are not being reflected in QB. It seems to not work ONLY in the 1st lines of each JE, which is the TRNS line but it is correctly showing for all the split lines (SPL). Any clue why the class isn't showing up correctly in the TRNS line? BTW, these are P&L accounts. Thanks.

  • @treasuresofnature9808
    @treasuresofnature9808 3 ปีที่แล้ว

    Hi, I have imported by following this procedure and it really worked. My worked load was decreased. But, this month, unfortunately (although it is working) but it has generated all the entries through '"deposit form" and not from "General Entry". Quickbooks has automatically generated duplicate ledger accounts categorizing it as "Bank". Can you help me out.

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 ปีที่แล้ว

      Change the account type after the import.

  • @jilljung5029
    @jilljung5029 5 ปีที่แล้ว

    Thank you for this! Do you happen to know if it is possible to have the Billable? box unchecked when using your macro to import?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว +1

      it doesn't work with the IIF, I tried it so many ways.. cant get it to work right

  • @mariamendoza8362
    @mariamendoza8362 4 ปีที่แล้ว

    Can this be used for Checks that have splits and for deposits?

  • @sovannaliv1508
    @sovannaliv1508 4 ปีที่แล้ว

    Thanks for your iif template. Your iif version of TRNSYPE is JOURNAL, what kind of QB version can use it? I always work with iif for QB 2015 which TRNSYPE is GENERAL JOURNAL but it doesn't work with QB premier 2019.

    • @HectorGarciaCPA
      @HectorGarciaCPA  4 ปีที่แล้ว +1

      In 2019 and on, it needs to say GENERAL JOURNAL, yes is weird like that

  • @kingelpat
    @kingelpat 4 ปีที่แล้ว

    Hector: is it possible to do different date journal entry with your macro from 1 excel sheet or do i need to split them?

    • @HectorGarciaCPA
      @HectorGarciaCPA  4 ปีที่แล้ว

      kingel patel my macro allows multiple

  • @annapetronik9817
    @annapetronik9817 4 ปีที่แล้ว

    How big of a journal entry can be imported? I wasn't able to import, as it said it was too big. I have around 500 lines in one entry. Does the macro allow importing bigger entries?

  • @frankchen1586
    @frankchen1586 6 ปีที่แล้ว +1

    This is fantastic tips. Thanks Hector

  • @eliharris2575
    @eliharris2575 หลายเดือนก่อน

    Hi;
    I exported my GL of qbooks desktop mac to Excel. Subsequently I lost the company file and backups...I know stupid Mac blew up and external backup was off.....
    How do I convert the excel GL file back into QB my 2024 version does not have. import Excel option and IIF (Changed the extension didnt work...).
    Hi any help would be appreciated.
    Thanks

    • @HectorGarciaCPA
      @HectorGarciaCPA  หลายเดือนก่อน

      @@eliharris2575 unfortunately there is no path to do that easily

  • @banthonyl
    @banthonyl ปีที่แล้ว

    This was an absolutely awesome video! Thanks

  • @mrthai6169
    @mrthai6169 3 ปีที่แล้ว

    The template IIF can import General Journal only ? if want to import such as enter bill, pay bill...

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 ปีที่แล้ว

      Mr Thai you need a different IIF template for that

    • @mrthai6169
      @mrthai6169 3 ปีที่แล้ว

      @@HectorGarciaCPA how can i have other templates IIF file ?

  • @braddemaso3874
    @braddemaso3874 3 ปีที่แล้ว

    Well done! You are a QB rockstar. Thx

  • @bethany7479
    @bethany7479 6 ปีที่แล้ว

    Can any of these tools be used in Multi-user mode? Or does QB have to be in single-user mode when importing?

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Jessica Rabbit IIF is single user.. TPI works in multiuser

  • @sarahwideman1559
    @sarahwideman1559 2 ปีที่แล้ว

    Hi Hector, having trouble getting the iif to import into QB 2022. I receive a fail message. Are there any updates to the procedure? Thanks so much!

    • @HectorGarciaCPA
      @HectorGarciaCPA  2 ปีที่แล้ว

      Try the second option (“import anyway, ill fix it later”) see what happens

  • @gyoung4597
    @gyoung4597 2 ปีที่แล้ว

    Such an incredibly helpful video!

  • @doramichelleazurdia859
    @doramichelleazurdia859 5 ปีที่แล้ว

    This is so helpful, thank you for sharing your knowledge!

  • @marymarlatt2695
    @marymarlatt2695 3 ปีที่แล้ว

    Great tutorial! Thank you so much for sharing.

  • @sheilamullins6976
    @sheilamullins6976 3 ปีที่แล้ว

    I keep getting a date error? ;[2020-01-31] The date in the distribution line must be the same as the transaction header [11081] Can i only use one date?

  • @alicecccc2768
    @alicecccc2768 5 ปีที่แล้ว

    Hi Hector, I was following your tutorial of importing template iif to quick book desktop Enterprise but it said importing transactions failed. I’m not sure what could be reason causing the importing failures....any ideas? Do u know what are the possible solutions?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Cccclol hard to troubleshoot like this

  • @neakniporn4121
    @neakniporn4121 3 ปีที่แล้ว

    I am interested to buy the tool Journal Entry Macro to IIF, doest work for bulk entry with a different date of transaction?

    • @HectorGarciaCPA
      @HectorGarciaCPA  3 ปีที่แล้ว +1

      Yes it can do multiple entries

    • @neakniporn4121
      @neakniporn4121 3 ปีที่แล้ว

      @@HectorGarciaCPA multiple entries with multiple date?

  • @bradleyerickson4264
    @bradleyerickson4264 5 ปีที่แล้ว

    This is my GL Account number directly from Quickbooks.
    404000 · Other Operating Income:404400 · Reimbursment:404404 · Pass Thru Utility-Electricity
    It does exist but the IIF import error report says it does not. Importing with simple GL names like Electricity is simpler.
    Does the IIF lose the · ? Or does it change it to something else?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      You can’t use numbers and names in the IIF need to be either/or

    • @bradleyerickson4264
      @bradleyerickson4264 5 ปีที่แล้ว

      @@HectorGarciaCPA Do you know a way to pull the Numbers and the stupid "dot" out of the GL numbers using excel?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Bradley Erickson yes.... but is better to turn off account number in QB prior to export and that will do it.

    • @bradleyerickson4264
      @bradleyerickson4264 5 ปีที่แล้ว

      @@HectorGarciaCPA Good idea but I getting my Excel file as an export from Access where I need the Numbers. I used SUBSTITUTE to get rid of them. Kind of ham-handed.

  • @NikMeyers
    @NikMeyers 4 ปีที่แล้ว

    Will this entry help track job cost?

  • @celinelambino4392
    @celinelambino4392 6 ปีที่แล้ว

    Thanks for this! Is the IIFF only be used for General Journal entry type of transactions? Or can I use Bill/ Credit as the "TRANSTYPE"?

  • @jessecase5706
    @jessecase5706 6 ปีที่แล้ว

    Hi Hector, In my 'List of Selected General Journal Entries' the 'Debit/Credit(+-)' column doesn't show the full total. Am I doing something wrong?

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Not sure what you are looking at... but it’s probably fine

  • @accountingrd3582
    @accountingrd3582 5 ปีที่แล้ว

    Hi Hector, thank you so much for this! I've been searching for a template. I have 1 issue. I'm in Canada so I have a TAX ITEM column that I need to enter the tax type. What is the name of this column header so that I can add it to the template? Thanks again!

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      I can’t help with Canadian version :(

    • @accountingrd3582
      @accountingrd3582 5 ปีที่แล้ว

      @@HectorGarciaCPA Too bad, thank you just the same Hector. Have a great day.

  • @carrenmarino2376
    @carrenmarino2376 4 หลายเดือนก่อน

    Thank you, this is indeed big help.

  • @praveenmeher87
    @praveenmeher87 4 ปีที่แล้ว

    Hi... how to import multi-currency transactions to QuickBooks using Excel/IIF files

  • @jazelramirez1628
    @jazelramirez1628 5 ปีที่แล้ว

    This is helpful! But for some reason my computer keep saving this template as an excel not as an IIF file.

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว +1

      You need to save it as a CSV file (tab delimited) and then rename the extension to IIF

  • @asiffazal3399
    @asiffazal3399 5 ปีที่แล้ว

    Hey Hector, what if your journals involve job numbers ?

  • @ginaromano1950
    @ginaromano1950 ปีที่แล้ว

    Great video! Super helpful.

  • @ellensmith5674
    @ellensmith5674 4 ปีที่แล้ว

    Hi Hector--will this work for Quickbooks Enterprise Desktop?

  • @mnasim1000
    @mnasim1000 6 ปีที่แล้ว

    Can we design a voucher by yourself and use as journal entry in iif file

  • @angelaf6769
    @angelaf6769 5 ปีที่แล้ว

    Hi, I am trying to test out importing a JE, and it defaults to "text(Tab delimited)' when attempting to save it. I noticed even when i opened my template to work on, it only says 'Journalentry -Excel;, not journalentryIIF - Excel as it does in yours, so i'm wondering if i'm having an issue downloading the template it in the first place. This is not allowing me to import it correctly as there is error.

    • @angelaf6769
      @angelaf6769 5 ปีที่แล้ว

      To add to this, in case i'm confusing, when i am working off the template and try to close it, it asks to if i want to save changes to my "journaltemplate(1)IIF' so assuming i have successfully downloaded your template, but it wont successfully save due to the default save file type.. I tried it, and it imports with errrors.

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      Maybe you should try the Macro template creator.. is easier to use:
      www.quickbooks-training.net/macro/

  • @lorenLA
    @lorenLA 2 ปีที่แล้ว +1

    been helpful :) thanks alot

  • @healthandwellness8525
    @healthandwellness8525 6 ปีที่แล้ว

    Hector, How can I find the field names like ACCNT, DOCNUM, etc. from my desktop version?

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Dayanand Shahapurkar those are the Account and Transaction Number fields

    • @healthandwellness8525
      @healthandwellness8525 6 ปีที่แล้ว

      Thank you fro the quick reply. I enter the following for sales entry, namely, CUSTOMER J, CLASS, DEPOSIT TO, DATE, SALE NO., ITEM, DESCRIPTION, QTY, RATE, MEMO, for Deposit into ,"Undeposited Funds" account. Then I enter FROM ACCOUNT, MEMO, CLASS and AMOUNT to make the deposit for each transactions, Can I use capitalized names as the filed names to generate the IIF file?

  • @simona7924
    @simona7924 6 ปีที่แล้ว

    Hello, I receive the error: "Error on line 4: Imported record has an invalid date. It should be MM/DD/YY."
    I use this format, but it doesn't work... Could you please give me an advice to solve this error?

    • @simona7924
      @simona7924 6 ปีที่แล้ว

      If I use other iif file it says "Your data has been imported.", but actually no data was imported.

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Remember that IIF is not a supported format by Intuit, so there is really no way to troubleshoot beyond what the error messages say. I would say, Check the date formatting.

  • @waleedramadan998
    @waleedramadan998 4 ปีที่แล้ว

    Thank you Hermano

  • @heatherbosworth679
    @heatherbosworth679 5 ปีที่แล้ว

    Would you be willing to look at my file to find out why I'm receiving the 'Type 13 Mis-match' error

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      You can call my office and schedule an appointment

  • @loriporten9664
    @loriporten9664 3 ปีที่แล้ว

    The download doesn't work anymore. Is the template still available?

  • @cbr600325i
    @cbr600325i 4 ปีที่แล้ว +1

    Cool stuff.

  • @sandman89chan
    @sandman89chan 3 ปีที่แล้ว

    If the class column is blank, will it still import?

  • @sayedmohammadmostafawy
    @sayedmohammadmostafawy ปีที่แล้ว

    thanks how to add currancy into iff file

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 หลายเดือนก่อน

      Cant.. is home currency only

  • @auditw2073
    @auditw2073 4 ปีที่แล้ว

    OMG! God bless you!

  • @estebanpicornell7762
    @estebanpicornell7762 4 ปีที่แล้ว

    This is awesome!

  • @pwhcpa224
    @pwhcpa224 6 ปีที่แล้ว

    I have all the account names entered correctly, however when I import it still sets up new bank accounts with the exact same name as the liab and expense accounts.

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Paul Hansen that means they are not the same names... you need to make sure they are verbatim letter by letter identical

    • @pwhcpa224
      @pwhcpa224 6 ปีที่แล้ว

      Hector Garcia CPA They are, in fact I imported a Iff file from my payroll provider which set up the accounts as banks, so I edited them so they are now the proper type (expense, liab). When I imported the next payroll IFF file, it set them up again as bank accounts.

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Paul Hansen if you want to hire us for support that is an option

    • @pwhcpa224
      @pwhcpa224 6 ปีที่แล้ว

      Hector Garcia CPA I would be interested. How do we proceed?

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 ปีที่แล้ว

      Paul Hansen email me hector@garciacpa.com or call my office 954-414-1524

  • @m.faisaltayyab3152
    @m.faisaltayyab3152 5 ปีที่แล้ว

    Im am getting a Runtime Error 13 "Type Mismatch" while generating the IIF File. Plz Help

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      What are you generating it with ?

    • @m.faisaltayyab3152
      @m.faisaltayyab3152 5 ปีที่แล้ว

      @@HectorGarciaCPA an IIF files to be imported into Quickbooks

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      M.Faisal Tayyab I guess I would have to look at it.

  • @AllanGulaman
    @AllanGulaman 6 ปีที่แล้ว

    Hi it says "Not allowed to multi user mode"

  • @mahmoudkousa766
    @mahmoudkousa766 5 ปีที่แล้ว

    I need The template for multi-currency iif journal import ?

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      mahmoud kousa can’t import multi currency... can only import at Home currency.

    • @mahmoudkousa766
      @mahmoudkousa766 5 ปีที่แล้ว

      @@HectorGarciaCPA Ok Thank you 😍

    • @mahmoudkousa766
      @mahmoudkousa766 5 ปีที่แล้ว

      @@HectorGarciaCPA I saw on youtube that zid axis software can import multi currency

    • @HectorGarciaCPA
      @HectorGarciaCPA  5 ปีที่แล้ว

      mahmoud kousa not a journal entry...

    • @mahmoudkousa766
      @mahmoudkousa766 5 ปีที่แล้ว

      @@HectorGarciaCPA Do you know how to import transferslip from excel to quickbooks POS version ?I tried zid axis but it import each item to one transferslip and I need to import many items to one transferslip if is there a solution I will pay for ?

  • @HongKongTamilan
    @HongKongTamilan 4 ปีที่แล้ว

    Hi, can anyone please send me the latest IIF journal entries excel format to import

  • @DT_123
    @DT_123 ปีที่แล้ว

    What if we don’t have any classes?
    Great video by the way