nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Spend Money Error 19

SNoss

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?

Template - Spend Money.csv

Find more posts tagged with

Accepted answers

Princess_R

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

All comments

AnthonyAlt

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

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

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

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 ????

AnthonyAlt

@Mike_James DID THIS GO ANYWHERE? I HAVE SAME ISSUE ? using AccountRight plus 2025.9.1.3

Mike_James

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.

Princess_R

Hi @SNoss,

Cheers

Princess