Before entering your adjusting entries, complete the bank reconciliation form (page 16) for December 31, the statement date, and the last workday of the month. Enter the cash balance from the trial balance as the book balance and $49,559.93 as the bank statement balance. Additional information needed to complete the reconciliation is listed below:
1. A late deposit of $1,477.00 was not listed on the bank statement.
2. Checks 10064 and 10065 were not returned with the bank statement.
3. Credit memo from the bank for interest earned on the checking account totals $45.60.
4. A debit memo for $103.95 for bank credit card sales (Credit Card Expense) was included on the bank statement.
5. The bank service charges for the period totaled $20.00.
Using the Journalize Daily Entries (Daily JE) option, record the required transactions resulting from the bank reconciliation. Since the entries are updating the balance of the cash account and no check is being issued, when the system asks for a check number, enter BKS12. When an invoice number is requested for the interest earned, or bank service charge, also enter BKS12 (Bank Statement for December).
*******************************************************************************
Print a copy of the Trial Balance After the Bank Reconciliation! THIS IS THE TRIAL BALANCE THAT WILL BE USED WHEN RECORDING THE ADJUSTING ENTRIES FOR THE BUSINESS! The totals should match the check figures listed below.
The December 31, Trial Balance After the Bank Reconciliation balance is $444,043.72. The new balance of the Cash account is $46,996.93. Bank Service Charges total $78.00, Interest Earned totals $45.60, and Credit Card Expense totals $237.95. If your balances match these figures, you are ready to record and post the adjusting entries for the quarter ended, December 31.
Be sure to back up your data files before beginning the adjusting entries.
You May Also Find These Documents Helpful
-
4. $9500 in services was preformed, with $4100 paid for in cash, and $5400 billed through Accounts Receivable…
- 683 Words
- 3 Pages
Satisfactory Essays -
(b) Enter the January 1, 2014 balances in Accounts Receivable and Allowance for Doubtful Accounts. Post the transactions to the ledger T Accounts…
- 448 Words
- 9 Pages
Satisfactory Essays -
If Allowance for Doubtful Accounts has a debit balance of $200 in the trial balance, journalize the adjusting entry at December 31, assuming bad debts are expected to be (1) 0.75% of net sales and (2) 6% of accounts receivable.…
- 414 Words
- 2 Pages
Satisfactory Essays -
Equipment…………………... 15,000 Accumulated Depreciation- Equipment……………… 15,000 30 Interest Expense……………………11,000 Interest Payable……………….. 11,000 (b) Bellemy Fashion Center Adjust Trial Balance November 30, 2012 | Debit | Credit | Cash | 28,700 | | Accounts Receivable | 33,700 | | Merchandise Inventory | 45,000 | | Store supplies | 5,500 | | equipment | 133,000 | |…
- 717 Words
- 3 Pages
Satisfactory Essays -
Leaving a remaining balance of $521.51. Please advise me if you wish to pay the remanding balance via check or credit card.…
- 68 Words
- 1 Page
Satisfactory Essays -
Adjusted trail balance shows balances that derive from a ledger account that is created after adjusting entries. Adjusted trial balance will show balances of revenue and expenses along with assets, liabilities and stockholder equity. The adjusted trial balance is prepared directly from changes which occur in stockholders equity, income statement, and the balance sheet.…
- 286 Words
- 2 Pages
Satisfactory Essays -
Bank reconciliation is a process of comparing the balance figures from the bank statement to the general ledger accounts to find the true cash balance. Initially, the balance on the statement is likely to be different from the balance in the ledger due to outstanding checks or deposits that are being processed by the bank. During reconciliation, accountants find any errors and note the outstanding transactions. Once the process is complete, the bank…
- 517 Words
- 3 Pages
Satisfactory Essays -
Trial balance: Is a tool that is used to list any and all credit and debit balances. It provides one with knowing if there are any errors in the ledger.…
- 474 Words
- 2 Pages
Satisfactory Essays -
The importance of knowing how to adjust entries is to ensure that the revenue and matching principles are followed (Kimmel, Weygandt, & Kieso, 2009). It is necessary because when a trial balance is prepared, the information may not be current. The adjustments need to be made when financial statements are prepared because it is counter-productive to record some events on a daily basis. The entries affected by adjusting entries are prepaid expenses, insurance, depreciation, and supplies (Kimmel, Weygandt, & Kieso, 2009).…
- 439 Words
- 2 Pages
Good Essays -
September standings are as follows; Checking balance $21,904.28, accounts payable balance $24,782.60, cash on hand -$2,878.32, time certificates in the amount of $25,475.67 which leaves a balance able to disburse of $22,597.35. Dawn motioned to accept the treasurers report as written, Nikki 2nd, motion carried.…
- 629 Words
- 3 Pages
Satisfactory Essays -
If the bookkeeper mistakenly recorded the deposit in error so an adjustment of $180 must be made on reconciliation sheet showing a debit to the bank ledger account with a debit of $180 and a credit to the cash account reconciliation as a credit of $180 to balance the books. Although the bank statement is correct and the ledger is wrong there still must be two entries so the books balance.…
- 563 Words
- 3 Pages
Satisfactory Essays -
4. Click on Print and print the December 3 Trial Balance. Return to the General Ledger screen by clicking on the close icon. 5. Click on Journals/Ledgers/Statements, select Subsidiary Ledgers, and select Accounts Receivable. 6. Print the Schedule of Accounts Receivable. 7. Click on Journals/Ledgers/Statements, select…
- 4385 Words
- 18 Pages
Powerful Essays -
Date Jun 1 Description Opening balance Withdrawals ($) 3.90 3.90 Closing balance Deposits ($) Balance ($) $5,096.80 5,092.90 5,096.80 $5,096.80…
- 410 Words
- 2 Pages
Satisfactory Essays -
P4-2A The adjusted trial balance columns of the worksheet for Porter Company are as follows.…
- 495 Words
- 2 Pages
Satisfactory Essays -
此外, 又有些資料是我們現金簿有紀錄, 而銀行月結單並無紀錄的, 包括: (a) 月底的存款, 由於時間差的原因, 月結單下月初才有紀錄 bank lodgment not yet entered / uncredited deposit / receipt not yet credited (b) 我們簽發的支票, 對方尚未往銀行提取 unpresented cheques (c) 銀行的職員入錯資料 errors 公司習慣, 我們須代銀行更新月結單的紀錄, 這紀錄表稱為銀行對數表 bank reconciliation statement, 通常先從月結單顯示的結餘 unadjusted balance as per bank statement 開始, 加上應收的存款 (a 項), 再減去應扣的提款 (b 項), 便會等同我們現金簿的更新結餘了 adjusted balance as per cash book。 5. 會考時, 題目可能會給予 (1) 現金簿 (2) 月結單, 讓我們自行核對。 題目也可 能用文字方式指出雙方須調整的事項 (transactions to be adjusted or corrected) 題目可能沒有提供月結單的結餘, 要我們自行找出來; 而因此題目也可能要求對數 表須以現金簿的結餘開始, 但答題時可不予理會。 銀行對數表 (bank reconciliation statement) 標準答題 樣 本 Cash Book (Bank column) 公司帳簿內的現金簿 – 銀行存款 Balance b/d xxx Overdraft b/d xxx (如戶口有錢剩 – 結餘在左方) (如戶口有透支 – 結餘在右方) Credit transfer xxx Autopay (standing order) xxx (客戶直接存款入銀行 – 未通知我們) Autopay (direct debit)…
- 312 Words
- 2 Pages
Satisfactory Essays