My non profit uses salesforce and netsuite.  I run a revenue report out of each to reconcile them.

right now I have them in tables side by side.  In between them I have columns for matching just using the = formula.  I am matching date, account name, document number, amount, main rev GL acct, and sub rev GL acct.  conditional formatting highlights false responses when item don’t match.  Typically a Salesforce transaction.  I had to insert rows and manually add transactions not in either report.

I am wondering if there’s a more efficient way to do the reconciliation, identify missing transactions in either report, and identify transactions with non matching amounts, doc numbers, and gl codes.  

any input is helpful. Templates, layouts, functions, formulas.  I am open to anything that would make the process more effective and efficient.  

thank you all in advance

jordan