Our bank (Raiffeisenbank) doesn't have a feed supported by Xero, so I hacked together a script that munges our bank statements (which we receive by email) into .qif files that Xero can import. I've been calculating the amount of each transaction by subtracting any fees charged by the bank.

Since we enter the actual transaction amount (we don't know the bank fees ahead of time), the automatic reconciliation can't match the majority of our transactions, and we need to search for them by hand. It would be amazing if the matching algorithm used by Xero were a bit more forgiving, so it could match, say, transactions that happened on or around the right date with an amount within 1% of the one on the bank statement.

(It would be even more amazing if Xero could be configured to treat any difference as a bank fee automatically, unless we specify otherwise.)

How do others handle this? Should I change my script so that it separates the actual transaction and the bank fees into two separate statement lines so at least the first one will match up automatically?