Overview
Finance teams that work heavily with checks rarely get a true picture of available cash, because posted bank balances ignore checks that are still under collection or already endorsed out. This module adds a one-screen wizard that, for each bank or cash journal you pick, computes the posted opening balance and folds in checks under collection and checks endorsed to give an adjusted balance. It exports the results to a formatted Excel workbook with a summary sheet and a per-journal detail sheet listing every relevant check, so accountants get a reconciliation-ready cash flow statement in seconds.
Key Features
- Wizard to select a date range, a due-date range, and one or more bank/cash journals before exporting.
- Computes each journal's posted opening balance directly from account move lines for the chosen period.
- Adds checks under collection (deposited) and subtracts checks endorsed to produce an adjusted bank balance.
- Generates a styled XLSX summary sheet with one column per selected journal and a computed balance row.
- Creates a dedicated per-journal Checks sheet splitting checks under collection and checks endorsed side by side.
- Lists check name, check number, due date, customer/vendor, amount, and check bank for each entry.
- Filters journal selection to bank and cash journals only to keep the statement focused.
- Auto-sizes worksheet columns and names the file with the selected from/to dates for easy archiving.