Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
I cannot figure out why it wont balance sp e Vinyl Revival Bank Reconciliation Statement June 30, 2020 102964 Balance per bank: Add: deposit in
I cannot figure out why it wont balance
sp e Vinyl Revival Bank Reconciliation Statement June 30, 2020 102964 Balance per bank: Add: deposit in transit deposit in transit 2136 9469 11605 114569 Deduct: outstanding check outstanding check No. 909 2191 No. 911 5400 No. Adjusted balance per bank 7591 106978 Balance per book Add: 106616 interest earned 231 231 106847 Deduct: bank service charge NSF check 8 400 Adjusted balance per book 408 Tyne horn bitibank Chicago branch Account No Rosaline Curse 120 Hogarth Avenue Chicago, IL 60604 Page No Vinyl Revival Debit Credit $830 $5,600 554,000 $3.083 $1,700 $2,500 5700 $2,035 Dato Particulars JUN 1 BALANCE BROUGHT FORWARD JUN 1 DEPOSIT - The Wiki Woh Hut JUN 4 901 JUNS LOAN JUNS DEPOSIT - Carrie Okey JUN 6 902 JUNS 903 JUNS 904 JUN 10 905 JUN 10 DEPOSIT -Cash sales JUN 13 DEPOSIT - Cash sales JUN 14 DEPOSIT - The Wikie Wah Hut JUN 17 006 JUN 19 907 JUN 21 DEPOSIT - Cash sales JUN 23 DEPOSIT - Dan Soul JUN 25 909 JUN 25 NSF CHECK-Dan Sout" JUN 29 DEPOSIT - Cash sales JUN 30 DEPOSIT - Carrie O'Key JUN 30 910 JUN 30 INTEREST JUN 30 SERVICE CHARGE $4,495 $9,009 $2,515 Balance $31.500 CR $32,520 CR 526,920 CR $80.920 CR $84.003 CR 582,303 CR $79,743 CR 579,043 CR $77,008 CR $81,504 CR $90,513 CR $93.028 CR $89.238 CR $83,662 CR 595,140 CR $95,540 CR $93,349 CR $92,949 CR $104,084 CR $107,761 CR $102,741 CR $102.972 CR $102,964 CR $3,790 $5,576 $11.478 $400 $2,191 $400 $11,135 $3,677 $5,020 $231 East statement to this statement to 05/31/20 08/30/20 Total debits Total credits Final balance 529.580 $100,854 $102.964 CR Proceeds of checks will not be avalable until cleared Al entries for the last business day are subject to verification and authorization Any items not paid or withdrawn, will be adjusted by reversal entry on a watement NSF moans Not-Sucent Funds CASH RECEIPTS JOURNAL Date De account Most Het Sale Accounts Other Rev Receivable Account 54,000 250 X 4496 0.009 X 540000V 4.400V 9.000 2.51014 11.4787 400 270 2.794 110-1 X 11.478 Bank Loan Payable Jun 3 Sales Revenge Jun 10 Sacs Revenue Jun 13 ARC - TheWiki Wah Hut Jun 17 Sales Revenue Jun 19 ARC - Dan Soul Juan 19 ARC-Brass world records 24 Sales Revenue Jun 30 ARC - Carrie Key Jun 30 Sales Revenue Total Post reference 400 110-6 110-3 2.136 Jun 11.136 11.135 38 3,677 110-4 X 279 9.469 45,587 (400) 9,007 108.315 (100) 54,000 (X) (110) (402) CASH PAYMENTS JOURNAL Debit Date Account Check No. Post Ref Purchases Accounts Payable 2,612 Other Accounts 903 210-4 X 700 904 905 Credit Cash Purchase Discounts 2,560 52 700 2,035 2 3.790 5,576 2,730 210-2 210-5 516 2,056 3.790 906 907 Jun 2 APC - Toadstool records Jun 4 Purchases Jun 5 APC - Shack records Jun 11 APC-Shadow records Jun 15 Wages Expense Fun 22 APC - UML records un 24 APC - Promiscuous records un 29 Wages Expense 30 Salary Expense tal 5,576 908 909 210-1 210-3 516 2,730 2,191 910 911 5,020 5.400 2.191 5,020 5,400 545 700 13,379 (210) 15,996 (X) 30,002 (100) st reference (500) GENERAL LEDGER Account: Cash Account No. 100 Ref. Debit Credit Balance Date May Jun Description 31 Balance 30 Total from cash receipts journal 30 Total from cash payments journal 30 CRJ 108,315 Jun 28,303 DR 136,618 DR 106,616 DR CPJ Jun 30,002 Jun 30 Jun 30 Jun 30 Jun 30 Balance Account: ARC - Accounts Receivable Control Account No. 110 (Q=825-110-O.ARControl_bankRec) Date May Ref. Debit Credit Balance Jun Jun Jun Description 31 Balance 13 Sales return from Brashs world records 30 Total from sales journal 30Total from cash receipts journal 30 GJ SJ 1,054 5,410 Jun CRJ 8,984 DR 7,930 DR 13,340 DR 4,333 DR Jun 9,007 30 Jun 30 Jun 30 Type here to search o Bank reconciliation statement May Vinyl Revival Bank Reconciliation Statement May 31, 2020 Balance per bank: Add: deposit in transit from Carrie O'Key deposit in transit from The Wikle Wah Hut $31,690 $3,083 830 3,913 35,603 Deduct: outstanding check outstanding check Adjusted balance per bank No. 901 $5,600 No. 902 1,700 7,300 $28,303 $28.179 Balance per book: Add: interest earned 132 28,311 Deduct: bank service charge Adjusted balance per book 8 $28,303 sp e Vinyl Revival Bank Reconciliation Statement June 30, 2020 102964 Balance per bank: Add: deposit in transit deposit in transit 2136 9469 11605 114569 Deduct: outstanding check outstanding check No. 909 2191 No. 911 5400 No. Adjusted balance per bank 7591 106978 Balance per book Add: 106616 interest earned 231 231 106847 Deduct: bank service charge NSF check 8 400 Adjusted balance per book 408 Tyne horn bitibank Chicago branch Account No Rosaline Curse 120 Hogarth Avenue Chicago, IL 60604 Page No Vinyl Revival Debit Credit $830 $5,600 554,000 $3.083 $1,700 $2,500 5700 $2,035 Dato Particulars JUN 1 BALANCE BROUGHT FORWARD JUN 1 DEPOSIT - The Wiki Woh Hut JUN 4 901 JUNS LOAN JUNS DEPOSIT - Carrie Okey JUN 6 902 JUNS 903 JUNS 904 JUN 10 905 JUN 10 DEPOSIT -Cash sales JUN 13 DEPOSIT - Cash sales JUN 14 DEPOSIT - The Wikie Wah Hut JUN 17 006 JUN 19 907 JUN 21 DEPOSIT - Cash sales JUN 23 DEPOSIT - Dan Soul JUN 25 909 JUN 25 NSF CHECK-Dan Sout" JUN 29 DEPOSIT - Cash sales JUN 30 DEPOSIT - Carrie O'Key JUN 30 910 JUN 30 INTEREST JUN 30 SERVICE CHARGE $4,495 $9,009 $2,515 Balance $31.500 CR $32,520 CR 526,920 CR $80.920 CR $84.003 CR 582,303 CR $79,743 CR 579,043 CR $77,008 CR $81,504 CR $90,513 CR $93.028 CR $89.238 CR $83,662 CR 595,140 CR $95,540 CR $93,349 CR $92,949 CR $104,084 CR $107,761 CR $102,741 CR $102.972 CR $102,964 CR $3,790 $5,576 $11.478 $400 $2,191 $400 $11,135 $3,677 $5,020 $231 East statement to this statement to 05/31/20 08/30/20 Total debits Total credits Final balance 529.580 $100,854 $102.964 CR Proceeds of checks will not be avalable until cleared Al entries for the last business day are subject to verification and authorization Any items not paid or withdrawn, will be adjusted by reversal entry on a watement NSF moans Not-Sucent Funds CASH RECEIPTS JOURNAL Date De account Most Het Sale Accounts Other Rev Receivable Account 54,000 250 X 4496 0.009 X 540000V 4.400V 9.000 2.51014 11.4787 400 270 2.794 110-1 X 11.478 Bank Loan Payable Jun 3 Sales Revenge Jun 10 Sacs Revenue Jun 13 ARC - TheWiki Wah Hut Jun 17 Sales Revenue Jun 19 ARC - Dan Soul Juan 19 ARC-Brass world records 24 Sales Revenue Jun 30 ARC - Carrie Key Jun 30 Sales Revenue Total Post reference 400 110-6 110-3 2.136 Jun 11.136 11.135 38 3,677 110-4 X 279 9.469 45,587 (400) 9,007 108.315 (100) 54,000 (X) (110) (402) CASH PAYMENTS JOURNAL Debit Date Account Check No. Post Ref Purchases Accounts Payable 2,612 Other Accounts 903 210-4 X 700 904 905 Credit Cash Purchase Discounts 2,560 52 700 2,035 2 3.790 5,576 2,730 210-2 210-5 516 2,056 3.790 906 907 Jun 2 APC - Toadstool records Jun 4 Purchases Jun 5 APC - Shack records Jun 11 APC-Shadow records Jun 15 Wages Expense Fun 22 APC - UML records un 24 APC - Promiscuous records un 29 Wages Expense 30 Salary Expense tal 5,576 908 909 210-1 210-3 516 2,730 2,191 910 911 5,020 5.400 2.191 5,020 5,400 545 700 13,379 (210) 15,996 (X) 30,002 (100) st reference (500) GENERAL LEDGER Account: Cash Account No. 100 Ref. Debit Credit Balance Date May Jun Description 31 Balance 30 Total from cash receipts journal 30 Total from cash payments journal 30 CRJ 108,315 Jun 28,303 DR 136,618 DR 106,616 DR CPJ Jun 30,002 Jun 30 Jun 30 Jun 30 Jun 30 Balance Account: ARC - Accounts Receivable Control Account No. 110 (Q=825-110-O.ARControl_bankRec) Date May Ref. Debit Credit Balance Jun Jun Jun Description 31 Balance 13 Sales return from Brashs world records 30 Total from sales journal 30Total from cash receipts journal 30 GJ SJ 1,054 5,410 Jun CRJ 8,984 DR 7,930 DR 13,340 DR 4,333 DR Jun 9,007 30 Jun 30 Jun 30 Type here to search o Bank reconciliation statement May Vinyl Revival Bank Reconciliation Statement May 31, 2020 Balance per bank: Add: deposit in transit from Carrie O'Key deposit in transit from The Wikle Wah Hut $31,690 $3,083 830 3,913 35,603 Deduct: outstanding check outstanding check Adjusted balance per bank No. 901 $5,600 No. 902 1,700 7,300 $28,303 $28.179 Balance per book: Add: interest earned 132 28,311 Deduct: bank service charge Adjusted balance per book 8 $28,303
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669de892ae735_722669de8923fa67.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669de893703e5_723669de8930810d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669de8941d362_723669de893b095a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669de894c9e4b_724669de8944e317.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669de895654a9_725669de895088ba.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started