So the result should look as follows in an excel file:   Reconciled Outgoing Tab - Tab 1   Date                   Customer  Name           Customer ID                Amount                 Direction  1/09/2018          Customer 1                    1234567                      1000                      Outgoing 1/12/2018           Customer 2                    7654321                      1250                     Outgoing   Reconciled Incoming Tab - Tab 2   Date                     Customer Name           Customer ID               Amount               Direction 1/10/2018             Customer 1                   1234567                     1250                   Incoming 1/11/2018             Customer 2                    7654321                     1000                  Incoming   Un-reconciled Outgoing Tab - Tab 3   Same columns as first two tabs, and no data if reconciled and data if any transactions don't match.   Un-reconciled Incoming Tab - Tab 4   Same columns as first two tabs, no data if reconciled and data if any transactions don't match.   Yes, if reconciled, that will mean the sums match, if non-reconciled, that would mean the sums do not match.   Thanks.                    ... View more