Importing Spend money transactions

Question

Hi AllIve been importing spend transactions for many years into Account right. No problems in the past.&nbsp;Just upgraded to 2025 and imports are no longer working. Seeing some odd data when viewing the import log against -15 no postable account.&nbsp; The bank account number is 111000, import log is seeing this as 3?This is the test file in text format:{}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cheque AccountCheque No.DateInclusiveCo./Last NameFirst NameAddr 1 - Line 1Addr 1 - Line 2Addr 1 - Line 3Addr 1 - Line 4MemoAllocation Account No.&nbsp; Amount&nbsp;&nbsp;Job No.Tax Code11100EFT6067/07/2023X&nbsp;SRO Land tax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Land Tax&nbsp;672.65&nbsp;&nbsp;&nbsp;&nbsp;EFT6067/07/2023X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Land Tax22000391.9230: Admin&nbsp;N-T&nbsp;&nbsp;EFT6067/07/2023X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Land Tax22140120.3114: 29 Spenser&nbsp;N-T&nbsp;&nbsp;EFT6067/07/2023X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Land Tax22150160.4215: 3/1 Acland&nbsp;N-T&nbsp;&nbsp;This is what import log reads:Viewing import file in notepad shows correct data but import does not. :&nbsp;Have set account number to number in excel - no difference. Have cleared local app cache in case this was the cause but problems persist. Have many hundreds of transactions to import.&nbsp; Appreciate any guidance on this one.&nbsp;Thanks RC

mike_james · Answer

Hi rcaver , the import log now displays an internal number in place of the account number. This means the account number has been found, and has the advantage that if an account number on a long import has a typo, that log field will be blank, which helps identify the line with the incorrect number.&nbsp;
So the error indicates that one of the account numbers used is not a detail account. Have you checked that none of them are header accounts?
&nbsp;

gavin12345 · Answer

Hi rcaver&nbsp;&nbsp;As Mike_James indicated, when MYOB finds the account (eg 11100) it replaces it with the recordID of that account. Note this did not happen with account 22000 - usually indicating MYOB did not find a postable account record ID. So while 1-1100 might be a postable account, I would suggest 2-2000 is not - likely a header.&nbsp;RegardsGavin

rcaver · Answer

Hi MikeThanks for reply.&nbsp; The account number 11100 is a detail account per screen shot below.&nbsp; Have imported many times using same template &amp; this account number, this new behaviour is puzzling?&nbsp;I restored the company file from last years backup and get same errors on import.&nbsp; The only change from last year is upgrading to 2025.2.1.&nbsp; I wonder if this is the problem. Not sure if its possible to roll back AR to previous version.&nbsp;&nbsp;&nbsp;

rcaver · Answer

Hi GavinThanks for tip.&nbsp; You are correct 22000 was a header. my mistake.&nbsp; However have corrected that account number &amp; retried import.&nbsp; Same errors 15 not postable &amp; now 19 unbalanced.&nbsp; Import log &amp; Notepad excerpts below&nbsp;Not postable sample data:File in Notepad:&nbsp;Unbalanced:File in Notepad:Appreciate suggestions - Im getting desperate !

mike_james · Answer

Hi rcaver , have you resolved this yet? If not, either post the text file you are importing (note this is a public forum) and the whole log file, or send them to me at my email address (see the datawise.co.nz home page).&nbsp;

Forum Discussion

Importing Spend money transactions

5 Replies

Looking for something else?

Related content

Import Spend Money Error 19

Importing Spend transactions with similar cheque numbers

Cant find spend money transaction

Deleting a Spend Money Transaction

Spend Money Transaction Disappeared

Spend Money Transactions annoying popups

Import Error - 19 - Unbalanced Transaction

Spend Money transactions in the P & L report