I hope someone can help me with this question: How can I register the bank accounts for a transaction in Manager?
Explanation: I am writing a program to enter transactions from the CAMT.053 download from my bank.
I know Manager has such a facility in CAMT Import, but I find it lacking in functionality. For example, transfers between two of my banks are classified as either payments or receipts, but they are neither. I have to delete them after import, then enter a suitable inter-account transfer by hand. I find this unsatisfactory. Same can happen with transactions that should be modeled as journal entries.
Another issue is that, with multiple banks and download files, I need a way to identify transfers between them, because both sides will report it in their download. The second one should then be skipped. Again, especially with inter account transfers and journal entries, the existing import function cannot do that.
So, I decided to write my own program. It creates a suitable file that then is entered by hand using Batch Create, or programmatically through the API2 interface. On the whole, it works fine. But occasionally, there is confusion whether a transaction is already in the database or not. And the only secure way I can see to solve it, is when I would have access to information identifying the banks and account numbers on both sides of the transaction.
My question in technical terms than becomes: Is there place in the database records to record that information? My CAMT.053 downloads certainly have it. Are any of the fields in the records for payment, receipt, transfer, or journal, meant to, or suitable to, receive that information?
Thanks for all insights on this issue!