Crush BLOG

This is a very rough draft right now. But it does give a sense of the richness of Apps.

It is hard to appreciate the importance of apps until you really dig deep into the system. What is an app? It is like a computer program. It is like a macro. But it's really like a simple plain English app. So here's a real world example because it's very hard to understand otherwise. Let's say you need to reconcile a PayPal account against your QuickBooks records. First you have to get the raw data from PayPal and QuickBooks. You can retrieve PayPal data from its site. Usually you get a CSV format. You can get all of the bank transaction detail from QuickBooks in a report. And it's easy to save that as Excel. Now you need to get that into CrushErrors.com. Here's what you do. You can drag and drop the CSV. You can copy the Excel data and paste it.

July 26- Just added new feature. Now you can add a column that converts a date into a month

This process so far should definitely be less than 10 minutes. The hardest part should be getting the password for the PayPal account.

Now with everything loaded into CrushErrors.com, you can press the Compare button, but the results will be a mess. It's a mess because you probably have more data than you need. You probably have many cleared transactions. You need to focus on the uncleared ones. So on the PayPal side, you need to make sure you're only looking at the rows for the month you're trying to reconcile. Let's say May. On the QuickBooks side, you may have rows for March and April. You need to compare ONLY the month at PayPal and only the uncleared records in QuickBooks.

So to look at only those rows, you need to filter on them. You can set up those filters one step at a time in Crush. With an app, you set up the app once and then reuse it. You may want to hide some columns. Again, you can do that manually, but an app let's you redo it over and over without doing much manually. So with the proper data and the proper app, you can do a reconciliation in a few seconds. That's literally true if there are less than 1000 transactions on each side. Hundreds of thousands of rows could take 10 minutes.

The above video shows a real PayPal reconciliation with app that are already set up. From paste to finding the errors is less than 40 seconds. The video shows that and then goes into detail on each line of the app.

CHOOSE AND SET COLUMNS

If you have many columns and only want to see those with errors:HIDE ALL COLUMN WITHOUT ERRORSONLY SHOW ERRORSONLY SHOW COLUMNS WITH ERRORSONLY SHOW COLS WITH ERRORSHIDE COLUMNS WITHOUT ERRORSIf you want to show all columns again:DISPLAY ALL COLUMNSSHOW ALL COLUMNSCOLUMNS SHOW ALL

CONDITIONS

If you need to limit processing to rows, for example, a time period or all asterisked fields

CLEAR CONDITIONS

ADD CONDITION or ROW FILTER

Examples:

ADD CONDITION LEFT A = 1010ADD CONDITION RIGHT L IS BLANK (or IS EMPTY)ADD CONDITION LEFT [Amount] IS A NUMBERADD CONDITION LEFT T IS A DATEADD CONDITION LEFT [Date] IS A DATEADD CONDITION LEFT T IS NOT BLANK (or IS NOT EMPTY)ADD CONDITION RIGHT T DOES NOT EQUAL 1010 ADD CONDITION RIGHT T NOT EQUAL TO 1010 ADD CONDITION RIGHT T != 1010 ADD CONDITION RIGHT T <> 1010 ADD CONDITION RIGHT T DOES NOT CONTAIN 1010 ADD CONDITION RIGHT T CONTAINS 1010

COLUMN FORMULAS

If you need a column with a custom formula, you can add simple plus and minus formulas like debits and credits, from the control panel. Apps give more flexibility. Start off with one of these three instructions

ADD COLUMN

FORMULA

ADD FORMULA

then add this the side (LEFT or RIGHT)

then add the column or the header text inside a bracket

then if you want a simple plus or minus formula, you can add + or -

then you can add the second column

Optionally add AS [col name] so you can refer to it in other formulas

Examples:

ADD FORMULA LEFT [debit] - [credit] AS NET

add column right [DEBIT] - [CREDIT] as amount

FORMULA RIGHT D - C

Two more advanced formulas only available with apps is SPLIT and MONTH.

The split app instruction will take a value and split it based on a delimiter like a dash. Then you tell it to take the FIRST or LAST part of the dash.

Examples:

add column right [telephone] split - first as areacode

add column left [apt] split / last as subunit

The newest app instruction converts a date into a month. This is very useful. So if you have 7/26/2015, but you really need 2015-07, here are examples:

add column right [date] convert to month AS [YYYY-MM]

add column left [date] convert to month AS [month]

New features added May 2016:

add formula left [Deposit] REMOVE text Rs. AS debit​. This will add a column that does NOT have the undesirable text.

add column left IF [txn category] is Debit -1 ELSE 1 as sign ... this means that it will add a column called SIGN .. the column will be populated with -1 if the field called txn category is Debit (not case sensitive) and if it's not Debit, the values for column Sign will be equal to -1 .

New added July 2016

Add column left FILL [class] as new_class . Using FILL will create a new column that will replace blank values with the last preceding non-blank value.

SPECIAL FOR DEBITS AND CREDITS

SPLIT TWO COLUMNS INTO TWO SIDES

Must add either reg and dr and cr that represent each column. So if there are 3 columns with first being and account, second being debits, and the last one being credits, then the command should be:

split two columns into two sides val dr cror shorten it with:

SPLIT 2 TO 2 SIDES reg dr cr

SPLIT ONE COLUMN INTO TWO SIDES

you need to identify the column to to split. All positive numbers will remain on left side. Negative numbers will be moved to the right side and will be multiplied by negative one. Similar to above, you need to specify a column to be split. You do that with VAL, so it will look like this:

split 1 to 2 sides reg val

COPY LEFT TO RIGHT Instead of splitting debits and credits on the left and moving them to the right. You can just copy the entire left side to the right. Then you can compare debit values on the left with credit values on the right.

CODE WITHIN THE CODE

There are codes that let App creators make Apps more useful for a wider audience.

For example, instead of a hard coded code like LEFT KEY [Acct], you can write LEFT KEY [. Question: "What is the key field on the left" list:fieldnames default: Acct .]

So it's very readable. When the App is executed, it will prompt the user for the fieldnames. If you say fieldnames, plural, then the user can select many. If it's singular, only one will be selectable.

Notice it starts with bracket then period.. .and ends with period, then bracket. Other codes are:

Categories

Hi. I'm Doug Schiller, and I designed crusherrors.com to save time and end my own frustration reconciling accounts. I absolutely stand behind this product. I want to hear from you so let me know how it's going.