Forum Discussion

blacklabelit's avatar
blacklabelit
Contributing User
7 days ago

Importing Spend Money Transactions

Hi,

 

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.

 

Thanks

5 Replies

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    6 days ago

    Hi blacklabelit,

     

    Nice pickup on the account mismatch, that’s usually the clue. The Error -15: Account number not found in list of postable accounts means the account in the import file is a header account, and header accounts can’t be posted to. A good check is to look at 53000 in your Chart of Accounts and make sure it isn’t set up as a header. If it is, swap it to the correct detail account, then test importing the transaction again. If it’s still not playing nicely after that, it’s worth reaching out to our team so they can take a closer look. You can contact them on Live Chat via our virtual assistant, MOCA, or by submitting a support case via My Account.

     

    Cheers,

    Doreen

  • blacklabelit's avatar
    blacklabelit
    Contributing User
    6 days ago

    Hi Doreen,

     

    Thank you for the reply. I've just checked and the account is already set as a Detail Account. 

     

    Is there anything else I can try before having to reach out to support?

    Thanks

  • blacklabelit's avatar
    blacklabelit
    Contributing User
    6 days ago

    Sorry, I just realised that I'd posted a picture of the wrong account. The Cost of Sales account I was trying to use is not a header account either.

     

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    3 days ago

    Hi blacklabelit,

    Appreciate for the screenshot. This would require further assistance on the back end, so please reach out to our team for more help. You can reach them on Live Chat via our virtual assistant, MOCA or by submitting a support case via MyAccount.


    Regards,
    Earl

  • blacklabelit's avatar
    blacklabelit
    Contributing User
    3 days ago

    Thanks Earl. Turns out the issue was the blank line between the header line and the data line. I'll be trying multiple entries in a single file this week so hopefully they go through smoothly as well.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home