Sheets AcademySheets Academy
Premium
Task #55

Reconciling with the bank statement

An accountant reconciles payments from the books with the bank statement F2:G9. For each payment, show in C2:C10:

  • “OK” if the payment is in the statement and the amount matches;
  • “Amount mismatch” if the payment is there but the amount is different;
  • “Not in bank” if the payment isn't in the statement.
Task #55
Reconciling with the bank statement

An accountant reconciles payments from the books with the bank statement F2:G9. For each payment, show in C2:C10:

  • “OK” if the payment is in the statement and the amount matches;
  • “Amount mismatch” if the payment is there but the amount is different;
  • “Not in bank” if the payment isn't in the statement.