Credit Card Reconciliation Algo/Formula.

We require a simple (i) credit card formula that will quickly check and (ii) reconcile any monthly credit card statement/s from (iii) the data of that statement/s input into the formula - confirming the following;

1. The statement reconciles.

2. The reconciliation includes any fees or added charges, as well as the overall rate charged within the statement.

3. The reconciliation shows any errors within the statement.

4. From the opening balance to the closing balance on each monthly statement the formula must reconcile.

As an example, just use your own credit card statement to assess.

CA.