Frequently Asked Questions

AssetReader imports native Excel, report format Excel, Crystal Reports Excel, PDF, Text (TXT, RPT, PRN), Delimited Text, HTML, DOC, DOCX

Because the system is ABL specific, the reports are not just cleaned-up (normalized) data, they also include summary and detailed reports, ineligible summary and detailed reports, frequency distribution, concentrations, slow moving inventory (based on selected methods) and related reports.  

All reports can be output to Excel or PDF.  Some reports are final reports that are PDF outputs.  The system generates a workbook in Excel with all related reports such as all AR reports.

FinSoft has been calculating electronic ineligibles since 1998 and the list includes all standard ineligible items such as over eligible days, cross-aging, concentration limits, international not backed by credit enhancements, aged credits, debit memos, finance charges, affiliates, etc.  There are ample user defined ineligibles as well.

Yes.  The inventory ineligibles are user defined based on specific identified items, part numbers, types, coded-type, etc.  The detail and options are the best in the business.

Yes.  There are many options such as date of transaction, cost of goods sold imported, cost of goods sold calculated, units sold, imported turns or imported turnover days.  In addition, the data can be driven from the inventory report alone (rare) or an automatic join with an imported cost of sales or usage report and the number of days of activity in that report.

Yes.  We've actually revised this four times to accommodate more sophisticated needs and that includes importing accrued expenses to combine with the AP.  It is not based on just the first word.  We can also use specific matches such as Job Numbers an not just the AR vs. AP names.

Yes.  We built a custom math calculator that offers both conventional math (+ - * / and parentheses order), and Boolean functions (If, Then, Else).  The system also includes specific functions to get things out of data or to evaluate things contained in data.

Yes.  Invoice Date and Due Date are a given.   But we offer options to use the Invoice Date and Due Date, credit terms or even override specific customers that get extended terms such as 120, 150, 180, etc.

Yes.  We have the best use and interface in the business for that.  Walmart and Sam's Club can easily become Walmart and Sam's Club Combined.  AR and AP contras can also be combined as one (e.g., Abe's Trucking on AR and XYZ Freight on AP).  We also support sophisticated wildcards to get the hard ones.

Yes. We have revised and enhanced this logic several times and it is class-leading for the needs found in ABL.  We can easily pluck-out finance charged, debit memos, etc.  But the logic includes more sophisticated options such as less than, greater than, etc.  We can also pull-out small balances or small invoices based on user-defined parameters and needs.

Yes.  Since day-1 and it is included in every version of the software.  The system can also convert currencies inside the report.  So while most reports are all USA, all Canadian, All Euro, etc., the system can take one report that has currency codes per item and translate those to one common currency for the entire report.

Yes.  Overrides are a simple click to enable.

Yes.  Overrides are a simple click to enable and the limits can be by percent, by amount or both.

Yes.  We have many trap levels available and can copy down, copy up or not copy.

Yes.  The consolidation is 100% built-in and automatic.  From 2 to 1000 divisions are consolidated instantly.

Yes.  We have a step-wise expert import wizard to import a single test, many test, an entire division and even pieces of the Writeup.

Yes.  The word-processor is built-in and it is a lot like MS-Word.  Spell-check too.

Yes.  We invested over 2000 hours on the AI component alone.  It performs the Writeup and executive summary Writeup.  The system uses the summary Writeup grids and the workpapers and the footnotes too.  It uses our own libraries for specific topics like dilution, turnover and trend changes.

Yes.  Much like the old paper exams, you made a copy from a blank.  We do something similar with a lender template.  This Template" concept extends into changes made by the lender over-time so that upgrades are instant and no rework is needed for those updates and changes.

Yes.  AssetReader exports the collateral and concentrations to AssetWriter.

Yes.  The Borrowing Base can handle multiple divisions, multiple advance rates, multiple caps (collateral cap, line caps, even inventory type caps).

Yes.  Each test has a global footnote field and for those tests that use rows such as Trends, Stats, Billing Test, Count, Cost, etc., the notes are also per row.  In addition, the system has "source" notes for each test to assist the next examiner in finding the source documents.

Yes.  We recently expanded this to include both report-level global notes and the row notes while in the Writeup screen.  These notes are also used by the optional AI engine.

Yes.  All reports export to one workbook.  We have options for consolidated, not consolidated or both consolidated and not consolidated.

Yes.  We support copy and paste from Excel on all screens with input grids.

Yes.  It will upgrade the re-exam and if a lender has enhanced the "Template", those Template changes will also be in the re-exam.  For example, a lender might want to add an AR Trends Graph to the Writeup and that would appear in all new exams.

Yes.  We have graphs as Writeup enabled options and as Excel outputs.  The Settings screen allows the lender to specify the graph type, optional regression lines, etc.

Yes.  This is an extensive screen that shows tick-and-tie by division and it notes any missing footnotes, data sources, blank Writeup sections and highlights trends that exceed specific thresholds.

Yes.  Since day-1 and it is an optional module. 

Yes.  Users can add checklist names and then the related questions.

No.  Most examiners have Microsoft Office.  AssetWriter does not need Microsoft Office to run.  Outputs to Excel and Microsoft Word would require Office.

AssetReader data is specific to any import at that date.  AssetArchive holds prior import data so that time-series analysis can be done across different reports.  A series of analysis metrics are setup for each borrower such as new customers that exceed 2% of average AR or any debtor or invoice that is 300% or ore of average.  Because the data is detailed, it can even show the step-down test by month, by debtor and by invoice for exceptions.  It has trends of AR, AP, and Borrowing Bases, plus concentrations for AR and AP across time.

Yes.  Because the metrics are per borrower, the data is much like the Factoring industry with details.  The time-series allows the system to calculate MAX, MIN, AVERAGE for specific criteria and then flag items that exceed those limits.  Those items can then be investigated once the data comes in.  Seasoned users request supporting documentation for those flagged items.

Yes.  An optional confirmation module includes the same metrics as the main product and custom letters with customized invoice tables for each Borrower are part of those letters.  Confirmation items can be done based on:  Only metrics, phone confirmation, fax, or e-mail.  The system includes confirmed balances or specific invoices, special reports and confirmation reason codes that can be customized as needed.