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

prepare a bank reconciliation report.
journalize any necessary entries for photo op based on bank recon
Hi please use the excel template
Prepare adjusting journal entries to reconcile the book and bank balances
IMPORTANT Record the entries in the order the items are listed on the bank reconciliation report. When entering numbers, please do not use commas or dollar signs. Journal Date 2023 Accounts and Explanations 0 น PR Debit Page 52 Credit
Bank reconcjliation Instructions Chart of Accounts First Question Journal Instructions The following data were gathered to use in reconciling the bank account of Reddan Company: Balance per bank $17,350 Balance pir company records 10,035 Bank service charges 35 Deposit in transit 3,350 Note collected by bank with $190 interest 4,600 Outstanding checks 6,100 Instructions a. What is the adjusted balance on the bank reconciliation? b. Journalize any necessary entries for Reddan Company based on the bank reconciliation. Refer to the Chart of Accounts for exact wordina of Check My Work
ss
Need help on figuring out what to put for account/explanation for the journal entry
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…