Forum Discussion

AaronCo's avatar
AaronCo
2 years ago

QIF Format for importing statements

My question is around QIF imports into various MYOB products - MYOB business and then also the MYOB AE ledger. So far I have been able to find the format to convert my data to and that is as follows;

!Type:Bank

D - <data>

T - <Amount>

N - <currently unknown to me but works if left blank>

P - Description

^

 

Does anyone know what the N is used for the in MYOB accepted QIF format?

And secondly, is there anyway that I can add to this to also quantities, account codes and GST codes so I can allocate directly from the QIF import?

 

Thanks

Aaron

 

  • Komal_S's avatar
    Komal_S
    2 years ago

    Hi AaronCo 

    I have attached an image showing the meanng of all fields. 

     

     

    With regards to your second query, it's not possible to add those fields directly to the QIF file. Please feel free to post if you have more questions on this. 

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    2 years ago

    Hi AaronCo 

    I have attached an image showing the meanng of all fields. 

     

     

    With regards to your second query, it's not possible to add those fields directly to the QIF file. Please feel free to post if you have more questions on this. 

    • AaronCo's avatar
      AaronCo
      2 years ago

      Aweosme, thanks. Is that from a publicaly avaiable document by any chance? It has been difficult finding useful information on the matter. 

       

      Cheers

       

      Aaron

      • Komal_S's avatar
        Komal_S
        MYOB Staff
        2 years ago

        Hi AaronCo 

         

         QIF is a common file format shared by a number of different programs and systems. If you need further information that format there are a number of different external articles on it. As an example, detailed information on the QIF file format can be found on the publicly available QIF format wikipedia page. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.