Direct Excel Export of Reconciliation
It would be really handy to have an export to excel for the account reconcilations.
9
votes
Jenise Bohbrink
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.
