Alliance & Leicester statement upload does not include interest/bank charges
When uploading an Alliance & Leicester Commercial Bank statement, the upload does not import interest/bank charges into FreeAgent.
The reason is because the bank charges and interest items are given a transaction id of zero in the OFX export file. It looks like FreeAgent ignores all FITID's of zero or one.
I managed to fix this manually by editing the file and changeing the FITID to 2+, but it'd be great if they got imported automatically. Would it be possible for you to query the user about the import of the transactions with invalid id's rather than ignore them?
Here's an example of the offending OFX item ...
The reason is because the bank charges and interest items are given a transaction id of zero in the OFX export file. It looks like FreeAgent ignores all FITID's of zero or one.
I managed to fix this manually by editing the file and changeing the FITID to 2+, but it'd be great if they got imported automatically. Would it be possible for you to query the user about the import of the transactions with invalid id's rather than ignore them?
Here's an example of the offending OFX item ...
<stmttrn>
<trntype>CREDIT
</trntype><dtposted>20080416120000
</dtposted><trnamt>63.22
</trnamt><fitid>00000000
</fitid><name>CHARGES 01MAR-31MAR
</name><memo>CHARGES 01MAR-31MAR
</memo></stmttrn>
2
people have this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
The company marked this problem solved.
-
Inappropriate?Hi there
Would you be able to send me the original OFX file so we can add support for this before the next release? Feel free to anonymize the data if you like, but please keep the structure intact. olly at freeagentcentral dt com.
Cheers, Olly
I’m confident
-
Inappropriate?This seems to have happened to me too with Alliance and leicester statements... I use the .qif files from the export on A & L
-
Inappropriate?Turns out my issue was user error, my interest charges were shown on the instant reserve account (my balances on FreeAgent now exactly match those on my alliance and leicester statements). So therefore it does work with QIF statements. Sorry to have confused the issue.
I’m red with embarassment
1 person says
this solves the problem
Loading Profile...



