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

Question

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 default account. We have tried to include the MYOB specific account number into the CSV but it does not work. Looking for a solution so we can easilt identify this particular group of sales.

mike_james · Answer

Hi&nbsp;Watty2487&nbsp;, thanks for attaching the CSV. &nbsp;I note that the column layout is designed to suit version 19.x of AccountRight, as per this help page:&nbsp;https://help.myob.com.au/prem19/win/impexptables.htm. However, the current version of AccountRight will attempt to import this file correctly.&nbsp;&nbsp;If this sale were entered manually, the journal memo field would read"Sale; Care Connect - COMPACKS". In your import file, the journal memo is blank, It would be useful to amend it to read "Import;&nbsp;Care Connect - COMPACKS", then these sales can be easily filtered using Find transactions.&nbsp;&nbsp;I note there is a cardID column. If you are matching on the customer name this column should be unmatched during the import. If you are matching on the card id, the customer name should be unmatched.&nbsp;I note that the job code column reads 4-0205. This may be the account number that you want the sales to appear in, but it will be interpreted as a job code, so this code must pre-exist in the file or you will get import errors. If you do have this value set up as a job (as well as all possible values that the import file may contain), then you could run a job P&amp;L to find the sales amounts to be transferred to other GL accounts, per your original question. However, if you do not want to use a job code in the import, this column should be blank, or should be unmatched during the import.&nbsp;The column headed Terms contains a text phrase. This column does not match any of the available Terms columns, and should be unmatched.&nbsp;&nbsp;The item code icrm is linked to a particular GL income account, and this cannot be changed during import, hence my suggestion to use journals to transfer sales amounts to other accounts.&nbsp;&nbsp;If you have any questions please post again.

watty2487 · Answer

Mike, this looks like it has worked. We will be doing a big import next week and will load the journal memo as suggested. It worked on the test I did and I was able to search for the transaction and located it. I will get back to you next week. Cheers.

mike_james · Answer

Hi&nbsp;Watty2487&nbsp;, are you importing these transactions as service or item sales?

watty2487 · Answer

Hi Mike, thanks for getting in touch.&nbsp;We are importing the invoices as sales.

mike_james · Answer

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

Forum Discussion

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

9 Replies

Related content

WHY HAS THIS PROGRAM BECOME SO BAD?????

email export from specific date

Downgrading Program

MYOB & Flare employee benefits program

search description column for specific information

How to create a report of all invoices with a specific item number?

Job specific with specific supplier report

Bank feed not showing a specific transaction