The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboard is provided to assist in our reconciliation for the month of November.
Prepare the company's bank reconciliation using information from the Tableau Dashboard. Assume the following:
The company has not yet recorded the bank fees.
The company has not yet recorded cash interest received for November.
Deposits in transit on November 30 were placed in the bank's night depository after banking hours and were not recorded on the November 30 bank statement.
Check No. 1203 and Check No. 1278 are outstanding checks as of November 30.
Ending Bank Balances:
Oct. 31 = 15000
Nov. 5 = 12600
Nov. 10 = 8400
Nov. 15 = 9700
Nov. 20 = 10300
Nov. 25 = 14100
Nov. 30 = 16028
Ending Book Balances:
Oct. 31 = 15000
Nov. 5 = 11400
Nov. 10 = 12100
Nov. 15 = 9100
Nov. 20 = 10700
Nov. 25 = 15300
Nov. 30 = 16127
Cash Interest:
Aug. = 31, Sept = 24, Oct = 22, Nov = 37
Nov Bank Fee:
CPE = 35
Service Fee = 15
Wire Transfer Fee = 14
1. As per the graph provided, as of Nov 30,
Bank Balance = $16,000
Book Balance =$16,000.
2. Cash interest received =$38,000.
3. Check printing fees is the largest.
Ending Bank Balances:Oct. 31 = 15000Nov. 5 = 12600Nov. 10 = 8400Nov....
Question 3 The bank portion of the bank reconciliation for Oriole Company at October 31, 2021, was as follows: ORIOLE COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,020 Add: Deposits in transit 1,530 12,550 Less: Outstanding cheques #2451 $1,300 #2470 910 #2471 836 #2472 542 #2474 1,050 4,638 Adjusted cash balance per bank $7,912 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following:...
The bank portion of the bank reconciliation for Pharoah Company at October 31, 2021, was as follows: PHAROAH COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,769 Add: Deposits in transit 1,540 13,309 Less: Outstanding cheques #2451 $1,400 #2470 920 #2471 845 #2472 522 #2474 1,060 4,747 Adjusted cash balance per bank $8,562 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: PHAROAH COMPANY...
The bank portion of the bank reconciliation for Pharoah Company at October 31, 2021, was as follows: PHAROAH COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,769 Add: Deposits in transit 1,540 13,309 Less: Outstanding cheques #2451 $1,400 #2470 920 #2471 845 #2472 522 #2474 1,060 4,747 Adjusted cash balance per bank $8,562 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: PHAROAH COMPANY...
Complete the following table for a monthly bank reconciliation dated January 31. For each item 1-10, place an "x" in the appropriate column to indicate whether the item should be added or subtracted from the book or bank balance or not shown on the bank reconciliation 1. Night deposit made on January 31 after the bank closed. 2. A check written in February of the same year as the bank statement 3. Principal and interest on a note collected by...
TJ Company's cash ledger reports the following for the month ending October 31, 20XE. Deposits Date 3-Oct 10-Oct 17-Oct 24-Oct Cash receipts 10/26 - 10/27 Amount $30,000 47,500 44,000 39,500 8,000 $169,000 No. 1151 1152 1153 1154 1155 Checks Date Amount 4-Oct $20,000 6-Oct 18,000 15-Oct 42,000 16-Oct 10,000 20-Oct 2,500 22-Oct 1,700 29-Oct 32,000 $126,200 1156 1157 Balance on October 1 Receipts Disbursements Balance on October 31 $32,000 169,000 126,200 $74,800 Information from October's bank statement and company records...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,068 and No. 5893 for $494. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement From Chavez Company's Accounting RecordsAdditional Information Check No. 5904 is correctly drawn for $2.112 to pay for computer equipment, however, the recordkeeper misread the amount and entered it in the accounting records with a debit to...
TJ Company's cash ledger reports the following for the month ending October 31, 20XE. Deposits Date 3-Oct 10-Oct 17-Oct 24-Oct Cash receipts 10/26-10/27 No. 1151 1152 Amount $20,000 25,000 26,000 24,000 12,000 $107,000 1153 Checks Date Amount 4-Oct $15,000 6-Oct 8,000 15-Oct 24,000 16-Oct 1,200 20-Oct 3,000 22-Oct 25,000 29-Oct 8,000 $84,200 1154 1155 1156 1157 Balance on October 1 $20,000 Receipts Disbursements Balance on October 31 107,000 84,200 $42,800 Information from October's bank statement and company records reveals the...
Problem 7-4A The bank portion of the bank reconciliation for Pharoah Company at October 31, 2017, is shown below. PHAROAH COMPANY Bank Reconciliation October 31, 2017 Cash balance per bank $12,627.90 Add: Deposits in transit 1,530.20 14,158.10 Less: Outstanding checks Check Number Check Amount 2451 $1,260.40 2470 684.20 2471 844.50 2472 435.65 1,050.00 2474 4,274.75 $9,883.35 Adjusted cash balance per bank The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank....
my numbers arent adding up.. help please 2nd The internal auditor of the Wilson Corporation is preparing the November 30, 2019 bank reconciliation. The auditor uses the following procedures to reconcile the bank statement to general ledger cash balance of 55,322.69. 1. Trace outstanding items on the bank reconciliation for the previous month to the current bank statement. The October 31 reconciliation included the following: S420.00 Deposit in transit Outstanding checks Number 149 Number 154 Number 155 $125.00 56.25 135.00...
Bank Reconciliation December 31, 2018 Balance per bank 12/31 $18,375 91 Deposits in Transit 12/30 12/31 $1,471.10 b 2,840.69 Outstanding Checks 6/30 837 12/15 1941 12/20 1966 12/21 1984 12/23 1985 12/28 1985 12/30 1991 6,000.00 671 80 320.00 1.855.42 3,621 22 2.576.89 4,420.88 (19,466.21) 5000 e NS check returned 12/29 200.00 d December bank Charges Error in Check 1932, dated 11/20 148.10 Customer note collected by bank, 12/21 (3,02500) Balance per book $ 1.094 59 1 Required: Determine which...