- When you're comparing one set of numbers to another set with key field (required) or multiple key fields, theoretically, you'll end up with numbers that equal each other, except for those that don't. So a graph is generated automatically that shows the amounts that match... They basically form a 45 degree line. Those that do not match fall outside the line. You can mouse over any point to see what's off.
- If you're looking at only one set of data because you want to find out certain things about the data. It's not a reconciliation situation. Like let's say you want to check for strange activity in vendor accounts. So you can upload a table with disbursements. Each line will have an amount and a vendor. Crush will create something like an Excel Pivot table that summarizes the disbursements by Vendor. But Crush will also show a graph that plots the number of vendor transactions against the sum of all of the transactions. So you can quickly isolate the vendors with infrequent payments, but big amounts. Crush also will highlight Vendors that are paid lots of little checks and one big check. So you'll be able to see how they will Skew.
- When you sum up a bunch of items by a key field, like a vendor, you can click on a popup that displays all of the rows that sum to that key field. It's very similar to a drill down on an Excel pivot. You can now click a link that will display a Histogram of those numbers. So you can quickly see if there is something strange going on.
AI Automated Finance | Accounting | Fuzzy Matching | Reconciliation | Power Analytics | Data Deduplication | Excel Add-in | Self-Service | On-Premises Hybrid Cloud | Web API | Microsoft Access Add-in | Financial Monthly Close | De-duplication | Compare | Merge | Self-Service | Diff | Reconcile | Versioning | Mapping | Banking | CRM | Sales | Differencing | Automation | Office 365 / 2019 / 2016 / 2013 Add-in | Analytics | Artificial Intelligence | Comparison | Fraud Identification | Spreadsheet | Workbook | Statements | Banking | QuickBooks | Query | Transform | Power Query | Power BI | Bookkeeping | On-Premises | Accountant | Analyst | Management | Business Intelligence | PowerQuery | Balance Sheet | General Ledger | customer Relationship Management | Invoicing | Accounts | Fuzzy Lookup | Match | Correct | Fix | Find | Report Solutions
Copyright © 2019 PowerSheet.ai