Importing Excel (CSV or any Spreadsheet) file into QuickBooks with built-in tools. Plus Zed Axis

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 55

  • @ramonav6476
    @ramonav6476 4 роки тому +1

    Thank you! This helped me today, 4 years after you posted this vid. This will save me tons of time!

  • @tinabutters-hargrave7911
    @tinabutters-hargrave7911 3 роки тому

    this is an older tutorial, however, my question is in similarity to this training. I have excel sheets from bank and other accounts, I want to update my journal but dont want to loose what is already there. it will not import over stating the format is not excepted. Note: beginner base knowledge only. thanks for any help

  • @normitabennett9185
    @normitabennett9185 2 роки тому

    do you have experience importing ADP General Ledger to QBO?

  • @vickiepartridge6499
    @vickiepartridge6499 6 років тому

    Thank you Hector!!! Very informative!

  • @jamesmann8183
    @jamesmann8183 4 роки тому

    Hector,
    How do 3rd part apps like Zed Axis comply with QB Online new security measures (instituted yesterday 12/18/19)

  • @angelicaortega3994
    @angelicaortega3994 6 років тому

    Hi Hector, can you send me the journal entry template. I would really appreciate it. You are amazing you make everything look so easy. I am using Quickbook Enterprise new to it and its not that easy. I am having a hard time using the iif file.

  • @michaelcarver4024
    @michaelcarver4024 7 років тому

    Hector - very thorough, very good video. I tried to go to the QB link for the IIF toolkit file and it was not active -- would you be able to provide an updated link for that toolkit?
    Also, are you able to provide/forward a copy of the PowerPoint for review?

  • @johnsabino3489
    @johnsabino3489 7 років тому

    Hi Hector good day! I have a question can I upload journal entries with QB premier 2017 or is this only available with the accountant version?

  • @merceditadeleon6294
    @merceditadeleon6294 8 років тому

    Hello Hector...I am trying to import A/P Aging Detail with: type, date, num, name, due date, aging, and open balance into a new QB...do you think is it possible on QB 2016 in some way? Thanks!

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому

      with QB Accountant 2016 you can..

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому

      if you got pro or premier, you gonna have to use a 3rd party app like Zed Axis

  • @angelicaortega3994
    @angelicaortega3994 6 років тому

    Hector, I am using quickbook enterprise and I was trying to import my chart of accounts from an excel spreadsheet and we couldn't. I called quickbook support and they could not help. I would like to talk to you to see if you can help us.

    • @HectorGarciaCPA
      @HectorGarciaCPA  6 років тому

      You can call my office: 954-414-1524 and Setup an appointment

  • @MsPJ1965
    @MsPJ1965 4 роки тому

    can you import excel project budgets into quick books on line?

  • @angelicaortega3994
    @angelicaortega3994 6 років тому

    Thank you so much for your knowledge.

  • @lekker01234
    @lekker01234 8 років тому

    Hi Hector. How can I import sheets from google sheets online to quickbooks online?

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому +1

      no Batch Enter in QuickBooks Online.. but you export your google sheet to CSV and use Zed Axis for that.

  • @davidfeliciano6915
    @davidfeliciano6915 7 років тому

    Hector will i need a third party tools in order import charges into customer statement?

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому

      +David Feliciano yes statement charges need to be imported with Zed or TPI

  • @learningwithmrandmrsjames4686
    @learningwithmrandmrsjames4686 5 років тому

    I import my banks statement into but i forgot to change the negative figure that was in excel how can i change ir

  • @debrawatterson5390
    @debrawatterson5390 7 років тому

    I would like to import an excel spreadsheet in QB Enterprise to a purchase order template in QB?

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому +1

      Debra Watterson you need a 3rd party app like Zed Axis

  • @eCabinetstipsandtricks
    @eCabinetstipsandtricks 8 років тому

    Hi Hector,
    I was wandering if it is possible to import data from an excel spreadsheet into QuickBooks for estimating?

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому

      yes, you can import estimates using Zed Axis (as illustrated here) or Transaction Pro Importer

    • @eCabinetstipsandtricks
      @eCabinetstipsandtricks 8 років тому

      +Hector Garcia (CPA) Thanks Hector,
      That was very helpful.

    • @ymk1804
      @ymk1804 8 років тому

      Which is better Zed Axis or Transaction Pro?

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому

      +YMK180 good question. each has its own pros and cons.... Zed Axis has a 30day fully functional trial.. try it, if it works 100%; then dont worry about TPI

  • @jrojasmaroto
    @jrojasmaroto 7 років тому

    Hi Héctor,,can you help me? I want to import Price list? it is posible?

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому

      +Lic. Jorge A. Rojas Maroto yes... it is.. call my office for an appointment or email me

    • @jrojasmaroto
      @jrojasmaroto 7 років тому

      Mr. Héctor I am from Costa Rica,,,can you give me your email? please

    • @hexgarcia
      @hexgarcia 7 років тому

      hector@qbkaccounting.com

  • @davidfeliciano6915
    @davidfeliciano6915 7 років тому

    Hector, can one import Statement charges?

  • @bettytumani7986
    @bettytumani7986 7 років тому

    Hello Hector, I would like to speak with you about training to so a budget for my Company

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому

      betty tuman email me hector@garciacpa.com or call my office 954-414-1524 to schedule a 1 hour session

  • @pedrosandino6464
    @pedrosandino6464 7 років тому

    Hector, how can I contact you? I would like to hire you to help me with some QB issues. Thank you.

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому

      Peter Sandino call my office 954-414-1524 to setup an apptmt

    • @HectorGarciaCPA
      @HectorGarciaCPA  7 років тому

      +Peter Sandino email: hector@garciacpa.com

  • @ivanov568
    @ivanov568 8 років тому

    how would you import a budget from excel

    • @HectorGarciaCPA
      @HectorGarciaCPA  8 років тому

      +Ivan G. posted here: www.quickbooks-training.net/create-or-edit-your-quickbooks-budget-in-excel/

  • @somenmondal1245
    @somenmondal1245 8 років тому

    Thanks a lot

  • @somenmondal1245
    @somenmondal1245 8 років тому

    I need your email for knowing some information.