Bank Reporting Software | Flex Reports and Action Items

Reporting Made Easy

Open a report, set the dates, and narrow it by officer, branch, market, or product. Customer and account names are links, so a row worth asking about opens the record behind it in CRM.

Switch to another layout, change the sort, filter a column, group the rows, print letters, then export what you are looking at to CSV, PDF, or a Meeting Package. Customize opens the layout behind the report, which is where the columns are chosen.

Easy filtering
Drill through to the customer or account
Sort, filter, and group as you read
Switch layouts without leaving the page
Favorite a report to keep it at hand
About says what the report covers

More Than 250 Reports, Already Written

Almost every report in the catalog began as a request from someone with a problem to solve or a process to improve. It was built for that institution and then added to the product for everyone else. The catalog has grown that way since 2008.

Permission is granted by report type or by individual report, so a lending group can be given every loan report in one move. The list shows when you last opened each report, and favoriting one puts it alongside the customers, accounts, and audits you are working on.

Accounting Audits BNControl Cleanup Debit / ATM Cards Deposits Escrow Loans Management Marketing Operations Overdraft Referral Tracking Teller

Written in answer to a real request
Search by name or subject
A description on every report
A suggested use alongside it
Permission by report type or by report
Last viewed date on the list
Favorite the ones you open daily

Flex Reports

Flex Reports are a framework we built ourselves, and most of the reports in BNControl sit on top of it. A report is a dataset rather than a fixed page of output. Layouts are what you do with it - sorting, filtering, grouping, formatting, adding notes, and printing letters.

Add and remove fields and drag a column header to move it. Two fields can share one column, so the account number rides under the customer name. A field can be kept off the screen and still be included in the export, for the data that belongs in the file but not in the meeting.

Your own user-defined fields are available, along with the ones imported from the core, referral and sales opportunity fields, and note fields that put the most recent note of each type on the report with the user and date beside it.

Add, remove, and reorder columns
Stack two fields in one column
Export-only fields
User-defined and core imported fields
Note fields with the user and date
Employee accounts masked by permission

BNControl - Reporting - Flex Report Editor

The fields on a Flex Report are not only what appears on screen. The same definition drives the CSV and the PDF, the notes a user adds without leaving the report, the scheduled extract that emails the file overnight, the Action Item that puts a count on the home page, and the copy that goes into a Meeting Package. Build the report once and it becomes whichever of those you need.

Sorting, column filtering, grouping, aggregates, and conditional formatting belong to the framework rather than to any one report. A column can hold a sum, a count, an average, a minimum, or a maximum. It can also hold a rate weighted by a balance field you pick. Conditional formatting colors the rows that need a second look. A report written next year gets all of it the day it ships.

Layouts

A layout saves the whole arrangement under a name - the columns, the default filters, the sort order, and the grouping. Global layouts can be limited to certain groups and users. Personal layouts are yours until you share them.

Sharing does not make a copy. There is one layout, and everyone it is shared with sees the same columns. When someone builds a layout everyone should have, an administrator converts it in place rather than rebuilding it, so existing favorites and saved links keep working.

Global and personal layouts
Shared layouts New
Default filters, sorting, and grouping
Top record limits and paging
A total count label on the report
Notes added straight from the report
Promote a personal layout to global

Column Filtering

Every column filters on its own. Conditions cover text, numbers, and dates - contains, between, is one of, has a value, and the rest - and one column can hold several of them joined with And or Or.

A filter can compare one column against another instead of against a fixed value, and date filters can be set relative to the current date instead of a fixed day, so a maturity filter still means the same thing next month.

Conditions across all field types
Several filters on one column
Compare a column to another column
Date math on any date filter
Saved to a layout as a default

BNControl - Reporting - Column Filtering

Grouping

Grouping collapses the report to one row per group, so totals by officer, branch, or product are readable without scrolling past every record underneath them.

Pick more than one field and you get one group for each combination of values rather than groups nested inside groups, so each officer and branch pairing has its own row. Numeric fields summarize with sum, average, minimum, maximum, or count, and every other field can be counted.

Group by any combination of fields
Totals in the group header
Groups keep the report's sort order
Top limits count groups, not rows
Exports keep the grouping

Action Items

Action Items put what needs attention on the home page as a set of tiles with a count on each one. A number of them ship with the product, and any Flex Report layout can be turned into one, which makes the trigger whatever that report returns.

They refresh with every import. Turn on the officer filter and each user sees only their own work, and a manager with the right permission can switch officers to review anyone's. Each Action Item keeps its own comments explaining why it was triggered and what to do about it.

Any layout can become an Action Item
Counts on the home page
Filtered to the responsible officer
Assigned to groups and users
Comments explaining what triggered it

Flex Letters

Any Flex Report with customer or account data can generate letters. Check the ones you want or print them all, and a single PDF comes back with a letter for each record.

Letters are written in an editor with the customer and account fields dropped in where they belong. Use your letterhead, merge a custom PDF behind the letter for disclosures, and add or subtract days from the current date inside the letter itself.

A letter can also be saved back as a notice on the customer or account, so the copy that went in the mail is on the record in CRM.

Deposit and loan maturity notices
Overdraft and past due notices
Birthday and new account letters
Print selected rows or all of them
Letterhead and merged PDF pages
Saved as a notice on the account

Reports That Deliver Themselves

A Data Extract runs a report on a schedule and delivers the file. CSV, PDF, or both, saved to as many folders and emailed to as many people as you need. Flex Reports, Flex Form reports, and financial reports can all be the source.

Schedules run daily, weekly, or monthly, after the day's import has finished. An extract can skip its run when the processing date has not changed - a Saturday schedule when Friday is still the latest data - and skip delivery entirely when there is nothing to send. Every run is logged with its record count and any error it hit.

Flex, form, and financial reports
CSV and PDF, file share and email
Daily, weekly, and monthly schedules

Dashboards

The Dashboard is each user's own page of charts. Pick widgets from a library organized by category, drag them where you want them, and size them to fit.

Balance, count, and rate history are all here, along with income, expense, and net income. The loan and deposit graphs filter by officer and branch, and most of the charts are interactive, so a point on a trend line opens up rather than sending you off to build something.

Access is granted by dashboard category, so a teller and a CFO can share the same page and see different widgets on it.

Deposits, loans, and general ledger
Net interest margin, ROA, ROE, Tier 1
Portfolio delinquency and loan volume
Referral activity by branch and user
Calculators, geocode, TRID dates
Permission by dashboard category

Verification and Validation

A verification checklist prints every report of a report type with its validation reference, its description, and blank columns for an initial and a date. Export it to CSV and work through it.

Data validation runs against the import itself. Pick a processing date, verify total loans and deposits by account type against the core, verify assets, liabilities, and capital, and put in writing the reason for any total that does not match. The tool also flags account relationship problems and unmapped general ledger accounts, which are the two things most likely to throw a total out of balance. Administrators see a warning once it has been more than ninety days since the last completed validation.

A checklist per report type
Validation reference on every report
Initial and date columns to sign off
Totals verified against the core
Unmapped accounts flagged first
Comments required on any mismatch
A 90-day reminder to revalidate

Built to Be Changed

Columns, filters, sorting, grouping, and formatting are all yours, and a layout keeps the arrangement for the next time you open the report.

Waiting When You Arrive

Action Items refresh with every import and scheduled extracts deliver themselves, so the report you need every morning is already done.

Ready to Share

Export to CSV or PDF, print letters from the rows, or send the report straight to a Meeting Package.

Are you ready for a demo?

See BNControl for yourself. We'll show you the modules you're interested in and answer questions along the way.

Reporting

View your data like never before.

More than 250 reports across loans, deposits, compliance, operations, and marketing. Add the columns you want, filter, group, save the layout, and schedule the delivery.