Feature/Request:
-
Current Behavior: Post-reconciliation reports currently include transactions dated after the statement/period-end date. Because upcoming/future-dated transactions are displayed, the final calculated balance on the report does not match the General Ledger bank account balance (Trial Balance / Chart of Accounts snapshot) as of that statement date.
-
Proposed Solution: Implement a strict statement-date cutoff on post-reconciliation reports that restricts included transactions strictly to those occurring on or before the reconciliation end date.
-
Functional Logic:
- Date Restriction: Display only cleared and uncleared transactions dated on or before the selected reconciliation statement date (e.g., July 31st).
- Exclusion of Future Activity: Automatically exclude all transactions dated after the statement end date (e.g., August 1st onwards) from the report view and balance calculations.
What financial, time savings, or quality of life improvements will occur with this:
Enables formal GAAP and audit compliance. The reconciled amount as of a particular date should match the trial balance of the same. If future uncleared transactions are removed from the reconcilliation report this will be accurate.
Attempted solutions so far:
Using GL Account Activity Report to do manual filtering and math to determine if the reconcilliation and the TB are aligned.
Digging deep - Any additional Why behind this request / How was this accomplished before Striven:
This is necessary accounting audit practices that are standard for larger companies