I have had nothing but trouble balancing our big bank statement since we started with Merchant in October 2024. Overall, it's just not very user-friendly.
Things I would like to see:
When entering transactions, there needs to be a way to lock out dates (one time my issue was instead of entering 6/2/25 for a transaction; I fat fingered it and entered 6/2/02 [I missed the 5 in 25], I realize this was my fault but 2002 shouldn’t even be allowed)
When entering transactions, the date/period should be forced to match (I’ve had issues where the date/period don’t match so it doesn’t play nice in the reconcile process)
When in the bank reconciliation, I wish it showed the total debits and total credits for the current reconciliation. My bank statement shows the total credits and debits for the month. It would be nice to be able to match these and quickly figure out which side of the ledger to focus on when trying to find a mistake
I wish the bank reconciliation were its own “file”. In my old system, I could save and delete the “file”. I could save as I went, and if I struggled to get it to balance, I could press delete and it would erase everything I had marked to clear, and I could start over. There is no way to do that now. If I accidentally clear something, I shouldn’t have to click through several different screens to try to find the mistake.
I don't understand why wire payments automatically "clear" the bank. There are times when a wire gets missed. I currently can't figure out which ones were entered and which ones were missed without running an extra report. If the wires were shown on the outstanding list with the paper checks and "cleared," this issue would go away.
Get rid of the "cleared after the As Of date" lines. What is the point of putting in the dates that I'm reconciling if it is still going to factor in the items "cleared after"? The only values that should be affected should be from the last reconciliation to the end of the current reconciliation.
Date Submitted | Aug 13, 2025 |
MerchantAg Modules | Cash Management |
MerchantFIN Modules | Cash Management |
Product | MerchantFIN |
Who will benefit from this idea? (Department and/or Job Title) | Anyone who has to reconcile the bank statement |
What problem does this Idea solve?
The stress and headache of trying to reconcile the bank statement. |
I agree with the totaling the reconciled debits and credits and being able to export these to excel as part of the reconciliation process. Also the reconciliation should start with the GL balance as of the month end Reconciliation date, not todays balance. Future items are not relevant to the process.
I have noticed the system is not very human error friendly. Things get fat fingered and should be easily fixed at least by the end of the day. I have this issue with AP invoices and have to reverse but that burns a check every time you do that. Invoice Numbers and dates should have the ability to be corrected easier or reopen the invoicing screen to correct it within a certain period.