The lengthy field is in fact can be searched as other shorter field. The problem is that if the fields are lengthy, some parts will be split and messed into other columns, see below highlighted in yellow. If you filter the field of “Debit”, some non-numerical text will appear which is in fact belongs to the field of “General Ledger Transactions”.
We can export the transactions by using the Summary sheet and click on the account balances then copy the transactions, but the drawback is that we need to click and copy the transactions of each balance one by one but cannot export the ledger in one go.
As for why we prefer pass an exported excel to auditor is that we do not prefer to export the entire manager file to them as there is lots of business data, and having an excel with easy to filter the account names can facilitate view of the transactions during the year.
