Forum Discussion

Watty2487's avatar
Watty2487
Experienced Cover User
2 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 Partner

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

Watty2487's avatar
Watty2487
Experienced Cover User
2 years ago

Sorry, item sales

  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    2 years ago

    Hi Watty2487 , thanks. Every item in AccountRight (and the new Essentials) 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
      2 years ago

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

      • Watty2487's avatar
        Watty2487
        Experienced Cover User
        2 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.