The following data were accumulated for use in reconciling the bank account of Wolfpack Bread Inc. for August $20$Y$9$:

a$.$ Cash balance according to the company's records at August $31,$$$6,580.$

b$.$ Cash balance according to the bank statement at August $31,$$$8,810.$

c$.$ Checks outstanding, $$2,740.$

d$.$ Deposit in transit, not recorded by bank, $$1,030.$

e$.$ A check for $$280$ issued in payment of an account to a supplier was erroneously recorded by Wolfpack Bread Inc. as $$820.$

f$.$ Bank debit memo for service charges, $$20.$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below,

Open spreadsheet

Prepare a bank reconciliation, using the format shown in Exhibit $10.$

WOLFPACK BREAD INC.

Bank Reconciliation

August $31,20Y9$

Cash balance according to bank statement

Adjusted balance

Cash balance according to Wolfpack Bread Inc.