Associate transactions with receipts

[dgor82]

Two stages: 1) Manually 2) Automated.

1) Manually

As a user I want to be able to drag and drop receit files onto a transaction to associate that receipt with that transaction.

2) Automated

As a user I want to be able to dump all my receipt files and scans from a certain period into a single folder and have it processed via PDF reading or even OCR (in case of scans) so that they then get assigned to the most likely transactions they belong to, based on data identified in the receipt. I want to be able to review these automatic allocations and see for each how confident the system is i.e. be able to also sort them by confidence.

Permanent association between Receipt and Transaction

In both cases, manual and automated:

If MW Scripts supports the automated attachments of receipts to transactions then subsequently do that. If not, then at least that association will be permanently stored in the data of FinAuxTool. See also detailed thoghts about this in #17

[dgor82]

Update based on 15/04/2024 decision: I will STOP attaching receipts/invoices into MW and instead keep them separate in Dropbox, also to make future auditing easier. See also this GPT chat.

This means, the automated process would have to:

• Allocate receipts to existing (bank) transactions
• Organise into folders and name receipt files by some convention
• Possibly add a nctCode to both the receipt name and the transaction's description in MW for easy search or other use cases of computer-readable allocation in the future.

[dgor82]

Update based on today's realisation of how MW manages/associates receipts to transactions: Every transaction has a 'Sequence No.' which also gets exported when I export transaction (and can be seen in the 'Transaction Info' dialogue). The attached picture, inside the folder MoneyWorks Custom Plug-Ins/Pictures for Neocortek Ltd/Transactions/ simply contains all the PDFs named after that sequence number.

=> An auditor could thus look at an export of transactions plus shared access to this directory for full access, while I keep the convenience of having the receipts in their right place inside MoneyWorks and also avoid duplication !!

Next, find out how FinAuxTool might manage to attach the receipt automatically, after doing the matching. AppleScript? XML Import? If none of these are possible, then at least attempt some RoboticProcessAutomation which recognises which transaction I'm currently looking at and automatically picks the file if it exists. so I can drag and drop it easily