Crush BLOG

First export the key information from QuickBooks. Use Ctrl-F to find transactions for the bank account you're looking to reconcile. Make sure you only export the uncleared transactions. No reason to look at already cleared transactions.

Then you need to get the actual bank information in to Excel Every bank has some kind of export.

Then you need to make sure that the signs (the positive and negative) are correct so you may need to add a little calculation. I suggest that positive numbers increase the bank balance and negative numbers decrease the balance.

Then select the range of uncleared items from QuickBooks. Then press Select Range # 1. Then Press OK. Then do the same thing for the bank transactions. Press Range #2. Then Press OK.

Reconciliation on Fire’s most obvious user is someone who reconciles a bank, credit card, or other financial statement. If you never find a discrepancy in your reconciliations, then you don’t need Reconciliation on Fire. But you’d be pretty rare. Most people often find discrepancies, even if they import the financial data from a website. If you only have a handful of transactions, then there’s probably no reason to use Reconciliation on Fire because you could eyeball the numbers to find the errors.If you are someone who regularly spends time hunting for small discrepancies then you can take full advantage of Reconciliation on Fire.Try Reconciliation on Fire if you regularly spend time hunting for those errors and have the following conditions:

You can export a list of actual financial data to Excel. This is typically done by exporting it from a website and saving it or pasting it into Excel.*

You can export your unreconciled transactions to Excel.

If you don’t actually do the reconciliations but hand it off to a boss to finalize the process, then you’d earn brownie points if you could make sure the numbers are accurate before the hand off.

Good luck.* I have even started from a scan of an AMEX statement. I then ran OCR on it and pasted it to Excel. Reconciliation on Fire worked great. I didn’t even have to line up the columns. After the paste into Excel, I noticed many 10 digit phone numbers. That would have messed up Reconciliation on fire, so I added a checkbox to ignore them. It worked great.

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.