I use natwest for my banking. Every month I import my statement and tag the transactions.
Sometimes my accounts get a bit mixed up and I end up having to check from a historic period of time to present day, to make sure all tansactions are in. However, because natwest and quickfile don’t order the transactions exactly (one transaction may be below or above another) it can be hard to quickly compare against.
So, could either of the following be implemented:
- Quickfile mirrors the bank statements transaction order on natwest statement exactly, so they can in essence be mirrored (each transaction is above/below the other correctly). Or,
- Each transaction is encoded in a unique number/letter format, like XHGQ. This would be like a MD5 hash or similar. From there, I can easily download both quickfile transactions and banks, then use something like vlookup on excel to compare which transactions are missing.