>
Welcome to Pay-As-You-Go. This product enables users to quickly find discrepancies and errors in data. Load 2 sets of data in this browser, in the first tab above. Then the software will find matches in a uniquely smart way with proprietary technology. Watch the videos below for more help.
|
|
|
|---|---|
|
Enter Data
|
Enter Data
|
| Results | Left | Right | Difference |
|---|---|---|---|
| Matches | |||
| Details | |||
| Not Matches | |||
| Zeroes | |||
| Totals | |||
| Filtered | TBD | TBD | TBD |
| Important Columns | Left | Right |
|---|---|---|
| Match Columns | 0 | 0 |
| Sum Column | 0 | 0 |
| Possible Missing Rows | Left | Right |
|---|---|---|
| Month / Count of Rows | No Problems | No Problems |
| Search | |
| Found | |
| Compare | |
| Score | |
| Show Rows* |
| Left | Right |
|---|
Coming Soon
| Fuzzy Dedupe Threshold (The lower, the more fuzzy matches) | Default | Level |
|---|---|---|
| Fuzzy Dedupe First Pass | 50 | |
| Deeper Secondary Pass | 90 | |
| Appearance of Gray Background | 65 |
Status:
Replace:
With:
Note:
Name:
Organization:
As Of Date:
Text at top 1
Text at top 2
Text at top 3
Display Settings
Template for how Fuzzy is Presented (Example: count, left, right, differences, common)
Combinations of Columns Scanned : of
Rows matched left : right:
Rows remaining left : right:
Elapsed time :
------
Other ways to add columns is with the Crush Language for Apps
Sample line from Crush Language
Contact Crush with questions. Also get white paper.
Iteration strategy: find all the rows that are perfect. Then exclude them, using "Exclude" button. Then change settings like reduce number of keys or use Fuzzy matching. The next set of results will only show the less than perfect rows ... it allows you to drill down and find the problems.
What best describes your situation?
Drag the columns to the appropriate box. Left side columns can only go on left. Right on right. You need to have the same number of Group By columns on both sides. If you are going to use Sum columns, then you must have one on each side. Use ALT to drag all columns.
HOWEVER
If you share an App that retrieves data, that data will be available to anyone who has access to that App. So like everything with the Internet, be careful who you share data with.
This is real data, but it's been obfuscated so that nobody will know the original source. The Credit Card data was taken directly from a statement. The QuickBooks data was taken from QuickBooks, but it was pre-filtered and a few columns were removed. The data doesn't have headers in order to show how Crush's Artificial Intelligence can understand which columns to try to match up. It knows that the amounts on the right are the negative equivalent of those on the left, so it suggests to reverse their signs. Out of hundreds of rows of data, it finds the problems very quickly.
| Description | Load Case Data | Video |
|---|---|---|
| 1) Load Case Study, Run App, See Differences | Video | |
| 2) Do POWER Crush, See Report | Video | |
| 3) Reconcile Remaining | Video | |
| 4) Finished |
This is real data, but it's been obfuscated so that nobody will know the original source. The task is to match 9 months of bank statements against a General Ledger. The statements originally come from a PDF. They are scanned by a service called PerfectAudit and converted to a CSV. The GL comes from QuickBooks. The user loads the data and presses the Crush Artificial Intelligence button (looks like a brain). Then Crush builds an App specifically for that data. Then does a POWER Crush. This finds the perfect matches and moves them to the reporting system, so that the user can FOCUS on the rows that do not match. The user enters the beginning and ending dates, balances of both the GL and Bank, to do a proper reconciliation. The user then starts to find the discrepancies. Each discrepancy is RATED with a STAR, with 5 stars being the best. Crush has several reporting methods to show results. Errors are typically:
| Description | Load Case Data | Video |
|---|---|---|
| 1) Load Case Study, Run App, Power Match, Fill in Beginning and Ending Balances | Video | |
| 2) Look for fraud | Video | |
| 3) Complete Manual Reconcilations | Video | |
| 4) Look at reports | Video |
Instructions. Load data. Then try to search for an existing App or let Crush use its Artificial Intelligence to build one for you. To load, do one of (A) paste from any spreadsheet, (B) drop and drop file (not available in all browsers), or (C) click "Choose File" to navigate to your file. Optionally, describe your data's location with some text and the column and row of first cell.
Note that the AI tools have been relocated to the AI tab.
Created by:
Contact:
Created:
Share App with link below:
Tags:
/// output // could be a problem with appTagsAfter running an App, it gets parked here.
Select an App from the App store to quickly crush your errors. Or you can make your own. You can submit your app for consideration to be included in Crush's App store. At some future date, Crush will have a way for you to sell your app.
Advanced users can make a simple App by starting from scratch by clicking the button below. Or you can make a more sophisticated one using the "Make an App" tab that has an easier user interface to create your own Apps.
To make your own App
Advanced users can make a blank app with the button below.
Title of your App
Description of your App (include links to YouTube or images .. enter anything in HTML):
Surround links with single apostrophe, like:
<a href='https://MatchData.AI'
target='_blank'>Crush</a> tel: 622-111-4444
App Creator (less than 30 characters):
Main information, link back to your website, phone number, email, or other identifying
information (enter in HTML):
Background Image URL (must start with HTTP - shown in App Store):
Logo Image URL (must start with HTTP - shown in App Store and when App Runs):
Will look better if 100 x 100 (can be GIF, JPG, or PNG):
Tags to help users find your App
/// input
Type:
Link to data*:
Brief (15 character) description
Prompt user for LEFT side data (e.g., Paste Account, Debits, Credits):
Link to data on LEFT side*:
Brief (15 character) description
Prompt user for LEFT side data (e.g., Paste Chase entries last month):
Link to data on RIGHT side*:
Brief (15 character) description
Prompt user for RIGHT side data (e.g., Paste QuickBooks data last month):
*Input link to TXT or CSV file for Left and Right sides. They must be accessible from any website. You can upload the file to your own website or to dropbox's Public section. Here's a sample file. Here are instructions how to use dropbox's file system.
If anyone has these links, they will have your data. Crush Errors never sees this data. It does not record the link. The Crush software will retrieve the data and bring it into your browser. So it will get on your machine, but it completely bypasses Crush's server. Absolutely 100% of the calculations are done in your own browser. So it's as secure and private as your own computer.
If you choose NOT to enter a link, the App that's created will not load any data. In some cases, that's acceptable. If you want to create a template for someone else to use, you may want to create some fictitious data and create a link to that data.
App that you can resuse to create same setup
Copy the full App into a public location, like your dropbox*.
* See warning on Basics tabl. Generally, if you have confidential information in your App,
share it wisely.
Also consider using the obfuscate tool in the tools tab to hide confidential information.
Link that you can share to create same setup
This tool will obfuscate your data so that if when you put it in your App, users will not see the real data. You'll need to paste it back to a spreadsheet and save it as CSV. That can be source for data for your app.
| Fields in Report | Excluded |
|---|---|
| Errors in Report | Excluded |
|---|---|
| Side | LEFT | RIGHT |
|---|---|---|
| STARTING BALANCE | ||
| ENDING BALANCE |
Enter notes and star the quality of the note
[1,s],[2,s],[3,s],[4,s],[5,s]
| Left | Right |
|---|---|
| Total= | Total= |
| Rows | Rows |
This is an animated dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.
This is an animated dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.
These items will be permanently deleted and cannot be recovered. Are you sure?
| Left fields | Left Text Diff fields | Right fields | Right Text Diff fields |
|---|---|---|---|
|
|
|
|
|
Settings for each Column
Settings for the Entire Search Replace
| Matched Rows | UnMatched Rows | Price per Matched Row | Discount for Unmatched | Pay to See Details |
|---|---|---|---|---|
Replace with
Never replace any of these
Enter Custom Replace:
Enter Note (optional):
Enter File, then click 'Open' button
This is a scrollable dialog.