Bank Feeds - Mapping for Bank Rules
Description against each transaction on the bank item should come through as "PAYEE" and not "Description". Bank Feed coming as "description" makes it difficult for bank rules as you cannot see the full description against each transaction when reconciled and this is sometimes stressful as you have to refer to bank statement all the time for full description.
Why when bank statements are imported, the description against the transaction is put through "PAYEE" and bank rules are much easier to make and the full description comes through.
Why not on a Bank Feed?
Mayuri Taank
shared this idea
Hi Mayuri, the way data is imported into your bank account in Xero is through information provided and mapped by the bank. This isn't something we're able to control on an individual basis.
The only way to control how data is mapped into the fields in Xero would be to stop the bank feed and manually import statements to your org via CSV where you can map columns of your statement file to fields in Xero, however appreciate the efficiency you likely find from have statements automatically import to Xero.
-
Caroline Bell
commented
I agree, the bank feed I have is missing the payee details and so the bank rule is not working as it should. All the payee details are in the 'particulars' column and so I have to go into each transaction to add the Payee/contact name defeating the object of the bank rule.
-
Ellie Heasman
commented
It would be great if Xero could work with the banks to rectify this. It's extremely time consuming for businesses with hundreds of transactions a week to have to manually enter in the Payee details, when the payee details are there but just feeding into the wrong column. For example for a NAB Visa feed, the payee details comes through in the bank feed statement under the 'Particulars' column. Could this be updated to come through under the Payee column instead?