Fill This Form To Receive Instant Help
Homework answers / question archive / following data concerning the cash records for the months of September and October: September 30 October 31 Book balance 1,900,000 Total cash receipts per book 1,400,000 Total cash disbursements per book 2,400,000 ? 2,100,000 Bank Balance Total charges in bank statement Total credits in bank statement ? 2,500,000 1,200,000 60,000 30,000 40,000 50,000 NSF Check Collections of accounts receivable not recorded by entity and corrected in subsequent month Overstatement of check in payment of salaries corrected in the subsequent month Deposit in transit Outstanding checks 90,000 120,0000 130,000 270,000 260,000 30,000 Required: a
following data concerning the cash records for the months of September and October: September 30 October 31 Book balance 1,900,000 Total cash receipts per book 1,400,000 Total cash disbursements per book 2,400,000 ? 2,100,000 Bank Balance Total charges in bank statement Total credits in bank statement ? 2,500,000 1,200,000 60,000 30,000 40,000 50,000 NSF Check Collections of accounts receivable not recorded by entity and corrected in subsequent month Overstatement of check in payment of salaries corrected in the subsequent month Deposit in transit Outstanding checks 90,000 120,0000 130,000 270,000 260,000 30,000 Required: a. Prepare a four-column reconciliation showing adjusted balances b. Prepare adjusting entries on October 31 2020.
:: Solution ::
Bank Reconciliation | ||||
Balance September 30 | Receipts | Disbursement | Balance October 31 | |
Per bank statement | $2,100,000 | 1200000 | 2500000 | $800,000 |
Add: Deposit in Transit | ||||
30-Sep | 130000 | -130000 | ||
31-Oct | 260000 | 260000 | ||
Outstanding checks | ||||
30-Sep | -270000 | 270000 | ||
31-Oct | 30000 | -30000 | ||
Adjusted Balance as per bank statement | 1960000 | 1330000 | 2800000 | 1030000 |
Balnace as per books | 1900000 | 1400000 | 2400000 | $900,000 |
Add: Collection of accounts receivable | ||||
30-Sep | 30000 | -30000 | ||
31-Oct | 50000 | $50,000 | ||
Overstatement of checks in payment of salaries | ||||
30-Sep | 90000 | -90000 | $0 | |
31-Oct | 120000 | $120,000 | ||
Less: NSF check | ||||
30-Sep | -60000 | 60000 | $0 | |
31-Oct | 40000 | ($40,000) | ||
Adjusted Balance as per books | 1960000 | 1510000 | 2440000 | 1030000 |
Adjusting Entries | ||||
31-Oct | ||||
Accounts Receivable | 40000 | |||
Cash | 40000 | |||
Cash | 50000 | |||
Accounts Receivable | 50000 | |||
Cash | 120000 | |||
Salaries & Wages expenses | 120000 |