Forum Discussion

Watty2487's avatar
Watty2487
Experienced Cover User
3 years ago

import invoices from a third party program to a specific myob account

We are a small NFP using third party software to generate client invoices which we then import into MYOB as a CSV. We want these imported amounts to go to a specific MYOB account and not the standard...
Mike_James's avatar
Mike_James
Ultimate Cover User
3 years ago

Hi Watty2487 , my question was, are they item or service sales?

Watty2487's avatar
Watty2487
Experienced Cover User
3 years ago

Sorry, item sales

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 years ago

    Hi Watty2487 , thanks. Every item in AccountRight has a GL account for income pre-set, so every sale using that item code will allocate revenue to the same GL account. If you want imported sales to go to a specific GL account, you will either need multiple item codes, or have imported sales distinguishable in some way (eg use a different journal memo - instead of "Sale; xyz customer", use "Import; xyz customer"), then use the find transaction screen to filter for these entries in a month, and journal the total revenue from one acount to the other. 

    • Watty2487's avatar
      Watty2487
      Experienced Cover User
      3 years ago

      Thanks Mike, we will give it a go and let you know how this works.

      • Watty2487's avatar
        Watty2487
        Experienced Cover User
        3 years ago

        Hi Mike, I have attached a CSV report that we are trying to import as I mentioned above. I am sorry but I don't quite get what you mean by a different journal memo. The attached may help. Cheers.

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.