Forum Discussion

blacklabelit's avatar
blacklabelit
Contributing User
7 days ago

Importing Spend Money Transactions

I am having an issue trying to import Spend Money transactions. I have exported as recommended to get a template however when importing again, I get an error. This has been my last attempt at importing even a single transaction.

 

I took the below lines from a file that MYOB created when exporting Spend Money for January 2025.

 

Google,3/01/2025,21110,,11.09,

Google,3/01/2025,,53000,10.08,1.01

 

I created a separate text file with the following (only changing the year)

{}

Co./Last Name,Date,Cheque Account,Allocation Account No.,Amount,Tax Amount

 

Google,3/01/2026,21110,,11.09,

Google,3/01/2026,,53000,10.08,1.01

 

When attempting to import, I get this in the import log:

0 records imported without errors.

0 records imported with warnings.

1 records skipped.

 

Summary of errors

Error -15: Account number not found in list of postable accounts.

 

-15

,Google,3/01/2026,21110,,11.09,0

,Google,3/01/2026,,143,10.08,1.01

 

From what I can see, the import process has somehow changed my 53000 'Cost of Sales' account to 143 (account/record ID number?). The 21110 account definitely refers to a credit card account in MYOB that I use to manually enter Spend Money transactions.

 

I've gone through a number of forum posts however haven't found a solution.

 

What am I missing to make this work? Hopefully someone can shine some light on it for me.

No RepliesBe the first to reply