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 of Bank account

Sidd123456

Hi All

When i am importing a bank statement, it is showing error again and again.

I am importing the statement as follow-

1. I have selected spend money under File type and choose the OFX file to upload
2. In format tab i made no changes
3. In Match field, i drag the file in Cheque account, Allocation account, Ex-tax amount and Inc-tax amount
4. After clicking on import it is showing error as attached- showing invalid account number and i have also attached the file which i want to import

JUL to SEP 2015 Bank Statement.xlsx

Error.txt

Find more posts tagged with

Accepted answers

Komal_S

Hi @Sidd123456

For multiple spend money transactions to import successfully, you need to ensure that there is a blank line in excel after each spend money transaction as shown in the image :

The screenshot you have provided does not have any blank lines to separate multiple spend money transactions, due to which the software treats it as one spend money transaction resulting into "Unbalanced transaction" error.

All comments

Sidd123456

Hi Tracey

Thank you for your reply.

I have done the same as you said but it is still showing the same error.

Second reason for such error may be due to Match field, in match field it is not auto matching with the fields showing as star (*), see attached screeshot for your reference.

Kind check the same and request you to suggest so that i can import the statement as our working is affecting so much.

Thanks

SS.PNG

Tracey_H

Hi @Sidd123456

As that error relates to an Invalid Account Number I would recommend checking that the accounts are in the AccountRight Accounts List. I would also check that they are Detail accounts and are active. You can also try removing the hyphen so the format is xxxxx instead of x-xxxx.

Please let me know how you go with this.