Question

Beckett Co. received its bank statement for the month ending June 30, 2019, and reconciled the statement balance to the June 30, 2019, balance in the Cash account. The reconciled balance was determined to be $6,462. The reconciliation recognized the following items:

1. Deposits in transit were $3,326.
2. Outstanding checks totaled $2,634.
3. Bank service charges shown as a deduction on the bank statement were $59.
4. An NSF check from a customer for $618 was included with the bank statement. Beckett Co. had not been previously notified that the check had been returned NSF.
5. Included in the canceled checks was a check written for $790. However, it had been recorded as a disbursement of $960.

Required:
Prepare the Bank reconciliation statement for the month ending June 30, 2019.

Answer 1

3 Insert Delete Format AutoSum" AT A Fill sort & Find & 2 Clear Filter - Select Editing Cells J K L M N O P Sep-Oct (Autosaved) (Autosaved) - Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Cut Comic Sans MS - 11 - AA Dr Wrap Text Accounting 1 D La Copy Paste BI U - - - A E S Format Painter E E Merge & Center - $ - % , 8 ... Conditional Format Cell Formatting as Table Styles Clipboard Font Alignment Number Styles F4 - f =F8+F7 A B C | G H I BECKETT COMPANY Bank Reconciliation JUNE 30, 2019. 4 Balance per Bank $ 6,462.00 Balance per Books $ 8,001.00 5 Add: Add : 6 Deposit in transit $3,326.00 Cancelled Check $170.00 7 $ 3,326.00 $ 170.00 8 $ 9,788.00 $ 7,831.00 9 Deduct: Deduct: 10 outstanding checks $2,634.00 NSF Check $618.00 Service charge $ 59.00 11 $ 2,634.00 $7,154.00 Reconciled Balance 14 $ 677.00 $ 7,154.00 Reconciled Balance 16 K 22 ™ Ready Sheet133 Sheet132 Sheet690 Sheet689 Sheet827 Sheet274 Sheet115 Sheet94 Sheet840 Sheet644 Sheet92 Sheet91 Circular References u 90 100% 0 4 Desktop 4 12:50 AM P.

- a x Home Insert Page Layout Formulas Data Review View fr E a ? A e @ Sep-Oct (Autosaved) (Autosaved) - Microsoft Excel Developer A a Define Name f Use in Formula - Trace Dependents Error Checking Name Watch Manager in Create from Selection Remove Arrows Evaluate Formula Window Defined Names Formula Auditing Define Name - Trace Precedents show Formulas o Calculate Now calculate Now Insert Function Math & Trig More Functions Calculation Calculate Sheet Options Calculation AutoSum Recently Financial Logical Text Date & Lookup & - Used - Time Reference Function Library A16 - foc в с F BECKETT COMPANY Bank Reconciliation JUNE 30, 2019. Balance per Books =+A5 Cancelled Check 6462 =F8+F7 4 Balance per Bank 5 Add: 6 Deposit in transit 7 3326 1=960-790 =B6 =++C4+C7 =+E6 |=F13+F14 2634 9 Deduct: 10 outstanding checks 11 12 =+A9 NSF Check Service charge 618 59 13 =++B10++B11+B12 =+C8-C13 =+E10+E11+E12 =C14 Reconciled Balance 14 Reconciled Balance 15 16 K 22 ™ Ready Sheet133 Sheet132 Sheet690 Sheet689 Sheet827 Sheet274 Sheet115 Sheet94 Sheet840 Sheet644 Sheet92 Sheet91 Circular References DO 100% Desktop P u 12:50 AM 10-Nov-19 o .. l l