I believe an easier and simpler solution to this problem to implement could be to use the existing Batch Update feature to Bulk update transactions in Receipts & Payments. I routinely use Batch Update to bulk add the BankClearDate by copying and pasting the Date field in excel. This saves me having to individually open every transaction that I have imported from the bank and used a Bank Rule to allocate.
However, what is really frustrating is that the Tracking Code field is not part of the Batch Update fields available. It includes every other field imaginable and even includes my custom fields such as Notes, but the Tracking Code field is not there, even though it is a built in part of the Receipts and Payments data. I understand that the Tracking Code field appears per line in the detail which complicates exporting for multiple line transactions that have detailed allocation, but the system must be able to extract the Tracking Code from the first line as the Bank Rule function can allocate an Account and Tracking Code to the first line on imported transactions from the bank.
Once the Tracking Code field appears in the Receipts & Payments Batch Update fields you can paste the transactions into a spreadsheet to manipulate. I usually insert a sort column at the beginning then fill down numerically starting at 1 to whatever to return data to original order after multiple sorting and manipulation. Then sort the transactions appropriately to get the ones you want, using description or date or reference, then delete the transaction you don’t need to change. You can then paste the Tracking Code you want on the spreadsheet and copy paste the data back into Manager for the Batch Update as it uses the unique Key to match the transactions being updated. Using this method, you would still have to manually update transactions with detailed allocations.
I use Tracking Code on every Receipt and Payment for profit centre reporting. Occasionally a large number of transactions will get imported without Tracking Codes because there is no rule in place which means a lot of work to update every transaction. The only other option at present is to restore the backup, create lots of bank rules and redo the import. It would be easier to use Batch Update.
Can you add the Tracking Code field to the Batch Update?