Why has my bank account stopped quick matching transactions that worked last month?
On a month-by-month basis, ExpensePlus will learn your recurring transactions and memorize them for future quick matching. Read these articles for more details:
Note: if you have just switched to open banking and automated bank feeds, see this helpguide article: Why are my transaction descriptions different when using automated bank feeds?
From time to time, your bank provider may change the format or labelling of the data exported via their CSV functionality. This may disrupt your memorized transactions.
Payee Reference or Description changes
If the payee reference (name of payee or donor) or the transaction description changes you will need to manually reconcile the transaction and ask ExpensePlus to remember it for future purposes with the new details. Alternatively, you can manage your memorized transactions in the Manage Remembered Transactions settings screen.
Bank CSV format changes
ExpensePlus supports all bank accounts from all providers. In the majority of situations, you will be able to export your transactions from your bank as a CSV file and then import these into ExpensePlus within the Bank Reconciliation module.
When your bank accounts are first set up in ExpensePlus (with the Bank and Petty Cash accounts settings screen) you will have specified which bank provides the account. All the major providers are supported.
Once a provider is selected, ExpensePlus will know and follow the format of the CSV export to correctly match transactions accordingly. However, from time to time, banks may change the format of their CSV export. Barclays and Co-op are 2 examples of this within the past 12 months. Where this is the case, the system may need to learn the new format and then re-remember some of the recurring transactions as the format and labeling of the data has been changed by the bank. We regularly review the CSV formats of the main providers and often update the system with changes promptly. If you are aware of a change that we haven't yet updated, please send us a message using the yellow 'Send us a Message' button in the help guide.
To better understand the Bank Reconciliation module, please view the module overview video here.