Forum Discussion

SNoss's avatar
SNoss
Contributing User
9 months ago
Solved

Import Spend Money Error 19

Hi There,

 

I have previously had success in importing Spend Money transactions. However, I am now getting error message 19 (unbalanced transaction) for this. 

 

Could you please review my template and let me know what needs to be edited?

  • Hi SNoss,

     

    Thanks heaps for attaching the Excel file! I can't pinpoint the exact problem, but typically, the "unbalanced transaction" error pops up when the totals for a transaction don't match up. This often happens if the sum of the line items isn't the same as the total amount listed. Make sure the debit and credit amounts in your import file are balanced and the data's formatted right. I'd suggest using an import template and having a look at this related post that might help sort out the issue.

     

    Cheers

    Princess

7 Replies

  • AnthonyAlt's avatar
    AnthonyAlt
    Experienced Cover User
    3 months ago

    HI all,  Firstly thanks for replying to a soled / old thread.  on Further (or should i say proper reading_ of the old thread i did click link to another thread that states import of Spend moneys MUT be a two-line  import not a single line import. I wish i had looked on the community first rather than spend hours in trying ti get what i thought was a simple import like sales import to work. 

  • SNoss's avatar
    SNoss
    Contributing User
    3 months ago

    Hello. Yes I resolved it. From memory it had something to do with there being a space in the cell with the number or the number not being formatted as a number. 

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 months ago

    Hi AnthonyAlt​ , can you attach a copy of the text file you are importing, and the import log created? Note this is a public forum; if you don't wish to disclose the contents, send them to me (mike at database dot co dot nz, turn this into a proper email address of course...) and I'll post some comment back. 

    Have you previously imported these files without error?

  • AnthonyAlt's avatar
    AnthonyAlt
    Experienced Cover User
    3 months ago

    import fields say Amount - but when you try to import the file  has two required fields Ex-Amount and Inc - Amount. i have tried using both as coloums  but get Error 19. have tried using each and get same error ,  have tried  Inclusive  yes and No , still no  luck . some times  ill go in and do the extact same import to find the  Available fileds in the file have changed completely  ????

     

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    9 months ago

    Hi SNoss​ , if you are importing to current versions of AccountRight on the desktop, normally your file requires a pair of braces in the first line, like so: {}

     

    But I think the columns in your file are designed for importing to v19 files, which uses field names like Ex-Tax Amount and Inc-Tax Amount.  Can you clarify which program you are using?

     

    See Import and export fields for the import fields for Spend Money transactions in the current AccountRight versions.

  • Hi SNoss,

     

    Thanks heaps for attaching the Excel file! I can't pinpoint the exact problem, but typically, the "unbalanced transaction" error pops up when the totals for a transaction don't match up. This often happens if the sum of the line items isn't the same as the total amount listed. Make sure the debit and credit amounts in your import file are balanced and the data's formatted right. I'd suggest using an import template and having a look at this related post that might help sort out the issue.

     

    Cheers

    Princess