check reconciliation - allow csv upload of multi voucher checks
In the bank reconciliation, checks paying multiple vouchers do not get matched with the csv upload and have to be reconciled manually. This makes the bank recon more time-consuming and leaves room for more errors. is there a way to fix this so that all checks get matched with the csv upload? We had over 100 checks paying multiple vouchers last month - would be great not to have to reconcile manually. Issuing several checks to the same vendor is not an option - sometimes there are dozens of vouchers linked to one check/vendor and it would make check signing quite burdensome.
Didi De Almeida
shared this idea
- (02-13-2025) Bank Reconcile - Settings: Add a new setting "Enable Bank Reconcile Approval". Enabling this setting will add a new column to the Bank Reconcile list of accounts titled Approved By. This will allow a user (with display and list permissions to Bank Reconcile) the option to approve the reconciliation. The user that approves the bank reconciliation must be different from the user that reconciled the account. If the account is unreconciled, the approval will be removed. Two additional columns, reconciled by and approved by, were added to the bank reconcile page. These columns will be populated by the user that reconciled and approved the reconciliation from this point forward. Historical reconciliations will display Foundant Technologies in the Reconciled By column.
- Bank Reconcile - Log: Add the actions for reconcile, approve, and unreconcile to the logs.
- Bank Reconcile - Notes and Files: Add a left-side menu option to add a note or file to a bank reconciliation. Notes and files will remain connected to the reconciliation if the account is unreconciled. If the reconciliation is cancelled, notes and files will be orphaned. This will require the user to add them again to the new reconciliation.
- Bank Reconcile: Add a column to the Bank Reconcile List titled Status. The status will be "start" or "continue" depending on the status of the last reconciliation for that account. Add Filters at the top of a reconciliation to filter the list to debits, credits, credits (checks), credits (electronic) for easier reconciliation. Shift Click will work in this table to clear transactions from the list. Updated the the top box of the reconciliation to display Bank Balance, total unreconciled, then book balance. Unreconciled transactions will have a total. Add a confirmation step when cancelling a reconciliation.
- Closed accounts will display at the bottom of the Reconcile Bank Account List.
-
Anonymous
commented
I would add the ability for credit card donations to total to match the deposit into our checking account instead of each one listed separately.
-
Michele Jeican
commented
This happens to me when we use multi-fund grants as well so I stopped using the csv upload to clear my checks, which is very time consuming and more prone to error.