Not very sure if anyone had same scenario as my customer.
I’m having customer doing online trading particularly sales of consumable solution. The model are similar to amazon where the goods are delivered by third party ( they order and request from supplier to sent to designated customer)
Usually each week, they copy pasted table data from live online banking details (they don’t provide exporting to spreadsheet, had to copy paste every chance they get). They created they own columns to defined whether is an income, expense, loan, or pass-through transaction. That can be used later on by filtering feature in excel.
I had this idea about bank rules will read whether there is matching strings in the data to be import.
Since they already sent to me bank complete bank transactions in excel, which in turn I convert it and replace delimit semi colon to coma to be import in manager, (proven works in tested dummy books).
Can additional column be added for so in bank rules are guarantee will be detected as per configured in bank rule feature?
additional of three column if possible.
What they did,
The first column will first describe whether is an income or expenses, the second is describing the details of transaction where to post to relevant account, the third is name of sender or receiver.
In bank rules also I like it the matching text string not limited to one sentences or one word.at least 2 more matching strings to narrowing down the criteria. (Let it be optional)