AssetReader – ABL Ineligible and Data Mining Software

Efficiencies begin with the ABL industry’s leading ineligible calculations for accounts receivable and inventory, which are easy to set up and maintain. AssetReader calculates less desirable collateral for the Borrowing Base Certificate (BBC) and summarizes sales, cash, and G/L activity for field examinations and more.

AssetReader is an industry‑specific tool for electronic file analysis and calculations that are truly Asset Based Lending specific. From a one‑page report to a 10,000‑page report, AssetReader can import data in popular formats and quickly calculate ineligible collateral, statistics, summaries, and other ABL‑specific data with no programming needed by the user.

FinSoft wrote the ineligible definition and “guidebook” with ABL‑Help, the leading reference tool in the ABL industry. This leadership in creating and maintaining the most complete ABL collateral and underwriting calculation reference is used at most major asset based lending institutions and outsource firms.

Our efforts to automate calculations and speed the gathering of statistics come from over 40+ years in the ABL profession in field examinations and back‑office management. We are an ABL data and data mining‑focused software company.

AssetReader invented the import wizard idea back in 1998 and has extended and refined it to all import types: receivables, payables, accruals, inventory, sales, cash, G/L, customer addresses, vendor addresses, and more.

We have been doing machine learning (ML) since 1998, and there is nothing as refined and detailed in the ABL industry because of the time invested. Others are 20+ years behind in development on their generation 1 and 2 products; AssetReader is far beyond that with asset audit software development.

AssetReader provides the best and most detailed ways to analyze agings, journals, ineligible accounts, and transactions in record time. It is a better idea for ABL ineligible software than any other solution on the market because it has real ABL artificial intelligence (AI) and business intelligence (BI) analysis built in.

A simple wizard‑based interface uses ML with the power to get the job done well for the ABL community, allowing users to log onto almost any format (fixed length, parsed, Excel, and PDF) in about five minutes—not hours. This is both ABL audit report and ABL operations software that can be shared between those two user groups.

We also have borrower support through the AssetReader‑Web product, allowing borrowers to report through a web portal using the same calculations as the lender.

Ineligible calculations include the ability to specify different cross‑aging percentages, concentration limits for different customers, trap transaction codes that should be removed from collateral, and group items to common names such as “Wal‑Mart Stores Combined.”

Field examiners can import years of data and instantly group by transaction code for the fastest statistics gathering possible. AssetReader can perform complex analysis, import multiple reports to build one large report (aging, inventory, sales, cash, G/L, etc.) from multiple divisions or months—even from different accounting system formats.

Data is summarized in an expert manner for ABL‑specific ineligibles for receivables and inventory or statistics analysis. Bank operations, examiners, CPAs, consultants, due diligence professionals, and borrowers needing ineligible calculation support now have a common tool to analyze agings, inventory reports, and company data.

AssetReader includes a wide range of ABL‑specific features designed to eliminate manual programming, reduce fraud risk, and accelerate analysis.

Feature	Benefit
Wizard‑based setup interface	Spend minutes, not hours, parsing data
Formatted imports (TXT, RTF, DOC, DOCX, XLS, XLSX, PDF, HTML)	Imports formats that others can’t, enabling more imports
Delimited imports (comma, semicolon, colon, tab, etc.)	Imports any delimiter for flexible data handling
Trap aging customer name rows and header rows	Traps rows above data, customer name rows, credit term rows, etc.
Consistent interface	Learn fast, finish faster, fully utilize staff
Eliminate programming	All ineligibles and setups are point‑and‑click
Expert ABL analysis already programmed in	Real ABL ineligible reports not available elsewhere
Floating traps for customer/vendor/part names	Trap names that float in position; automate ineligible calculations
ABL‑specific ineligibles from ABL‑Help authors	Cross‑age different debtors at any percent; recalc in seconds
Credits over eligible days (three methods)	Experiment with options in seconds
Credits under eligible days option	Add back credits within eligible limits
Automatic reversal of aged credits	Prevents double counting of credits
Sortable columns in predefined reports	Sort as needed; exports retain sorts
Concentration limits by percent and dollar	Control credit and concentration risks
Concentration grouping and finder	Group like‑named accounts (e.g., Wal‑Mart and Sam’s)
Wildcard traps for code sequences	Trap invoice sequences such as 99* or *DM
Smart contra analysis	Net of invoice ineligibles; more matches on similar accounts
Tag ineligible invoice and inventory codes	Trap codes such as FC, DM, Scrap, Pkg without programming
Visual drag‑over tagging	Tag items for receivables and inventory ineligibles
Stand‑alone system with support	Fast performance with expert support
Duplicate invoice and sequence anomaly detection	Prevents fraud and allows exceptions to be tested
Round‑dollar amount detection	Reduce fraud by finding integer‑value items
Re‑age entire reports	Test 100% for proper aging and column totals
Shipping/billing test	Perform tests electronically in minutes
Inventory report imports	Yes, AssetReader handles inventory too
Usage / cost of sales imports	Automates turnover calculations with inventory
Aged inventory and excess value calculations	Calculates age and excess value on hand
Inventory cross‑aging	High excess quantity can make items ineligible
Join inventory on hand with cost of sales	Automatic joins with no programming
Inventory grouping and subtotals	Automatic subtotals regardless of grouping
Multiple division handling	Accurate, quick analysis of combinations
Template‑based import database	Portable files contain setup and imported data
Regular feature additions	Won’t become obsolete from technological changes
Flexible date format support	Reads unusual formats, including no delimiters
Freeze aging columns	Prevent re‑aging; isolate unaged credits/chargebacks
Retainage aging support	Splits retainage and aged invoice amounts on same row
Future‑day aging buckets	Allows future items to be aged
Monthly sales, cash, and G/L summaries	Automatically splits out months
Transaction‑code cross‑tab reports	Summarizes by transaction code
Flexible negative sign handling	Reads left, right, parentheses, and CR formats
Export to AssetWriter	Save field exam time (ineligibles, concentrations, more)
Export to AssetArchive	Real‑time fraud detection and historical trends
32‑bit and 64‑bit support	Take advantage of faster Windows environments
Multiple CPU core support	Automatically uses all available cores

AssetReader is designed for institutions worried about aging accuracy, fraud risk, staff overload, and the need for additional peace of mind. It saves time while improving accuracy by removing manual analysis and formatting headaches that spreadsheets or general import tools require.

AssetReader provides a turnkey, state‑of‑the‑art solution for in‑depth analysis, consistent reports, clear presentations, faster report preparation, better outsourcing, computer support, and cost control. It is backed by training, quarterly updates, and employee‑owner technical support.

With AssetReader you can:

• Calculate borrowing bases for receivables and inventory with repeatable setups that learn as you work.
• Trap more detailed ineligible collateral using refined tricks, tweaks, and methods developed since 1996.
• Automate analysis of agings, sales journals, cash journals, inventory reports, and more.
• Reduce fraud risks with report accuracy confirmation and expert analysis of unusual data and patterns.
• Reduce back‑office costs by allowing processors to handle more reports in less time.
• Improve coverage of testing by getting more done in far less time.
• Use templates for repetitive tasks, account groupings, risky customers, and report setups.
• Export to AssetWriter for field exam time savings and to AssetArchive for real‑time fraud detection and trends.

AssetReader and related modules support multiple functional areas, including examiners, operations, data processing, and web‑based borrower reporting. The focus is on technical capability and workflow, not pricing.

Functional Area	Role	Key Capabilities
Examiners	Field examiners at institutions or outsource firms	Import agings, journals, inventory; perform ABL‑specific analysis and export to AssetWriter
Operations	Back‑office operations at lending institutions	Process borrower records, run ineligible calculations, and support ongoing collateral monitoring
Data Processing	Non‑lender companies supporting ABL lenders	Handle data mining, exception processing, custom setups, and technical support for lenders
AssetImport	Import raw data and push to operations systems	Clean up and organize upload streams for downstream systems and APIs
AssetReader‑Web	Borrower‑side web interface	Borrowers report through a web portal using the same calculations as the lender

• 8 GB of RAM (minimum)
• Desktop: Windows 10 or Windows 11 (also runs in Citrix, Remote Desktop, and other VMs)
• Cloud: Windows Server 2016 or higher
• Virtual machines (Windows VM, Citrix/Xen, etc.) within the past 4 years
• 50 GB of hard drive space for install, plus space for borrower data files and database storage
• Mouse or similar pointing device
• Display at 1200 × 800 or higher

“How Much Time Can You Save Today?”™