F30A4567891011121314151612345678910111213141516171819202122IBAx ✓Check number1 Instructions:2Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement3801802803с01-Oct H&H Jewelers06-Oct Deposit08-Oct L.L. Bean10-Oct Cashe13-Oct Deposit804 13-Oct Four Seasons HotelBfxDate Description fo transaction805 15-Oct American Express20-Oct ATM Withdrawal24-Oct Deposit27-Oct Deposit28-Oct Home-Depot - Debit CardStatement Date:Checking Account Summary:Account Number:Date03-Oct06-Oct10-Oct13-Oct15-Oct17-Oct22-Oct24-Oct28-Oct30-Oct234567891011121314151617DPrevious Balance Deposits Numbe879.363.00сAmount236.77450.75324.70880.3475.89507.82120.00623.5048.2534.40Check book balanceDNovember 3, 2021October 1-31, 2021449-56-7792Amount of payment or withdrawa!Total CreditsChecking Account TransactionsDescriptionCheck #801Adjusted checkbook balance1,954.59DepositReturned itemEFT payroll depositCheck #803Check #805ATM WithdrawalDepositDebit card purchaseCheck printing charge$EECheck Numbe7.00236.7747.275.89109507.8212048.25Total Debits1,347.83BalanceBank statement balanceAmount of deposit or interestAdjusted statement balanceF642.591,093.34768.641,648.981,573.091,065.27945.271,568.771,520.521,486.12$2FPLEASE USE EXCEL AND SHOW THEFORMULAS IN EXCELG450.75880.34623.5208.4Current Balanc1,486.12GBalance Forward879.36

Answered: Image /qna-images/answer/7e5ec7be-a49b-4703-a3d2-6a8d4201e2bd.jpg

Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement Check number A 801 802 803 804 805 B Date Description fo transaction 01-Oct H&H Jewelers 06-Oct Deposit 08-Oct L.L. Bean Date 03-Oct 06-Oct 10-Oct 13-Oct 15-Oct 17-Oct 22-Oct 10-Oct Cashe 13-Oct Deposit 13-Oct Four Seasons Hotel 15-Oct American Express 20-Oct ATM Withdrawal Statement Date: Checking Account Summary: Account Number: 24-Oct 28-Oct 30-Oct 24-Oct Deposit 27-Oct Deposit 28-Oct Home-Depot - Debit Card с Previous Balance Deposits Numbe 879.36 3.00 Amount Amount of payment or withdrawal Amount of deposit or interest 236.77 450.75 324.70 880.34 75.89 507.82 120.00 623.50 D November 3, 2021 October 1-31, 2021 449-56-7792 Total Credits 1,954.59 Checking Account Transactions Description Check #801 Deposit Returned item EFT payroll deposit Check #803 Check #805 ATM Withdrawal Deposit 48.25 Debit card purchase 34.40 Check printing charge Check Numbe 7.00 236.77 47.2 75.89 109 507.82 120 48.25 F Balance G 642.59 1,093.34 768.64 1,648.98 1,573.09 1,065.27 945.27 1,568.77 1,520.52 1,486.12 450.75 880.34 Total Debits Current Balanc 1,347.83 1,486.12 623.5 208.4 Balance Forwar 879.36

Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement Check number A 801 802 803 804 805 B Date Description fo transaction 01-Oct H&H Jewelers 06-Oct Deposit 08-Oct L.L. Bean Date 03-Oct 06-Oct 10-Oct 13-Oct 15-Oct 17-Oct 22-Oct 10-Oct Cashe 13-Oct Deposit 13-Oct Four Seasons Hotel 15-Oct American Express 20-Oct ATM Withdrawal Statement Date: Checking Account Summary: Account Number: 24-Oct 28-Oct 30-Oct 24-Oct Deposit 27-Oct Deposit 28-Oct Home-Depot - Debit Card с Previous Balance Deposits Numbe 879.36 3.00 Amount Amount of payment or withdrawal Amount of deposit or interest 236.77 450.75 324.70 880.34 75.89 507.82 120.00 623.50 D November 3, 2021 October 1-31, 2021 449-56-7792 Total Credits 1,954.59 Checking Account Transactions Description Check #801 Deposit Returned item EFT payroll deposit Check #803 Check #805 ATM Withdrawal Deposit 48.25 Debit card purchase 34.40 Check printing charge Check Numbe 7.00 236.77 47.2 75.89 109 507.82 120 48.25 F Balance G 642.59 1,093.34 768.64 1,648.98 1,573.09 1,065.27 945.27 1,568.77 1,520.52 1,486.12 450.75 880.34 Total Debits Current Balanc 1,347.83 1,486.12 623.5 208.4 Balance Forwar 879.36

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Control Features of a Bank Account: Reconciling the Bank Account (Entries from Bank Reco Knowledge Check A bank reconciliation from Ware, Inc. is provided here. Cash balance per bank statement Add: Deposits in transit $18,200 2,100 20,300 Less: Outstanding checks 1,050 Adjusted cash balance per bank 19,250 Cash balance per books 17,000 Add: Electronic funds transfer received $2,650 Interest earned 30 2,680 19,680 Less: NSF check-J. King 400 Bank charges 30 430 Adjusted cash balance per books $19,250 Prepare all necessary journal entries as a result of the bank reconciliation. (List all debit entries before credit entries. Credi titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Nov 30 Cash Debit Credit
prepare a bank reconciliation report.
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea Company: Balance per bank $ 23,360 Balance per company records 19,490 Bank service charges 110 Deposit in transit 3,440 NSF check 1,270 Outstanding checks 8,690 a. What is the adjusted balance on the bank reconciliation? b. Journalize any necessary entries for Azalea Company based on the bank reconciliation. If an amount box does not require an entry, leave it blank.
Bank reconciliation The following data were gathered to use in reconciling the bank account of Reddan Company: Balance per bank $ 18,250 Balance per company records 8,500 Bank service charges Deposit in transit Note collected by bank with $190 interest Outstanding checks a. What is the adjusted balance on the bank reconciliation? 50 2,650 5,150 7,300
lemic Calendar My MCBS Library English (en) - ndamentals of Financial Accounting Summer Session 12021/ACT 140/D2 / Final Examination/ AC In a bank reconciliation statement, explain. A. Non-sufficient-funds (NSF) check B. What is a deposit in transit? A BI - mcbs.proctoring.online is sharing your screen. Stop 11
Hi please use the excel template
Based on the following bank reconciliation, prepare the journal entries: Ruggero Celini Associates Bank Reconciliation July 31, 20 -- 1 Bank statement balance, July 31 $1,784.00 2 Add deposits in transit $418.50 3 100.50 519.00 4 $2,303.00 5 Deduct outstanding checks: 6 No. 185 $206.50 7 No. 203 317.40 8 No. 210 56.10 580.00 9 Adjusted bank balance $1,723.00 10 11 Book balance, July 31 $1,792.00 12 Add: 13 Error on Check No. 191* $10.00 14 Interest earned 2.00 12.00 15 $1,804.00 16 Deduct: 17 NSF check $66.00 18 Bank service charge 15.00 81.00 19 Adjusted book balance $1,723.00 *Accounts Payable was debited in original entry. Required: Prepare the journal entries.
Prepare adjusting journal entries to reconcile the book and bank balances
The folowing Information was gathered by Superior Landscaping in order to prepare its Bank Reconciliation at the end of October: Balance in Cash Ledger account at end of Oct 31 $4,450 Balance of Cash in Bank Statement at end of Oct 31 3,900 Electornic Funds Transfer deposited into your Bank account late Oct 31 600 Outstanding Cheques at end of Oct 31 1,200 Deposits in Transit 2,000 NSF cheque received from a customer 350 Prepare the October 31st Bank Reconciliation
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Bradford Company: Balance per bank $ 17,400 Balance per company records 8,195 Bank service charges Deposit in transit Note collected by bank with $130 interest Outstanding checks a. What is the adjusted balance on the bank reconciliation? 45 3,100 4,900 7,450 b. Journalize any necessary entries for Bradford Company based on the bank reconciliation. If an amount box does not require an entry, leave it blank.
Using the following information: Bank balance: $3,678 Book balance: $2,547 Deposits in transit: $321 Outstanding checks: $108 and $334 Bank charges: $25 Notes receivable: $1,000; interest: $35 and using the following accounts/items: Bank Errors Bank Service Charges Cash Deposits in Transit Interest Expense Interest Income Notes Receivable Outstanding Checks you are to prepare a bank reconciliation: Bank Balance [ Select ] Book Balance [ Select] Add items: Add items: [ Select ] [ Select ] [ Select] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] Less items: Less items: [ Select ] [ Select ] [ Select] [ Select ] [ Select ] [ Select ] [ Select] [ Select ] Adjusted Bank Bal. [ Select ] Adjusted Book Bal. [ Select ] PLEASE NOTE: For the above reconciliation, if no dollar amount is needed, please use "$0" or if no item is needed, please use "None" - no quotation marks. You must enter the account and item names exactly as written above and all dollar amounts will be with "$" and commas…
Instructions: Prepare a bank reconciliation for Kali Loli from the following checkbook records and bank statement CHECKBOOK Check number 801 802 803 804 805 Date Description fo transaction 44835 H&H Jewelers 44840 Deposit 44842 L.L. Bean 44844 Cashe 44847 Deposit 44847 Four Seasons Hotel 44849 American Express 44854 ATM Withdrawal 44858 Deposit 44861 Deposit 44862 Home-Depot - Debit Card BANK STATEMENT Statement Date: Checking Account Summary: Account Number: Checking Account Transactions Date Amount 44837 44840 44844 44847 44849 44851 44856 44858 44862 44864 BANK RECONCILIATION Check book balance. Amount of payment or withdrawal Amount of deposit or interest Balance Forward 879.36 November 3, 2021 October 1- 31, 2021 449-56-7792 Previous Balance Deposits Number Total Credits ✓ Check Number Total Debits Current Balance → 879.36 3 1954.59 7 1347.83 1486.12 Description 236.77 Check # 801 450.75 Deposit 324.7 Returned item 880.34 EFT payroll deposit 75.89 Check #803 507.82 Check #805…