Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need Bank reconciliation statement with excel formatting On July 31, 2019, Pure Diamond company had a cash balance per books of $22,477. The bank
i need Bank reconciliation statement with excel formatting On July 31, 2019, Pure Diamond company had a cash balance per books of $22,477. The bank statement from New York State Bank on that date showed a balance of $24,642. A comparison of the statement with the cash account revealed the following: 1. On July 31, the bank statement showed an NSF charge of $743 for a check issued by Amanda Adam, a customer, to Pure Diamond company on account. 2. On July 12, the company issued check no. 342 for $568 to David Scott on account. The check which cleared the bank in July, was incorrectly journalized and posted by Pure Diamond company for $586 3. July 31 deposits of $672 (Received by bank on August 1). 4. Pure Diamond company wrote check no. 322 for $369 and the bank correctly paid that amount. However, Pure Diamond recorded the check as $396. 5. The statement included a debit memo of $19 for the printing of additional company checks. 6. A $2,400 note receivable was collected by the bank for Pure Diamond Company on July 31 plus $60 interest. The bank charged a collection fee of $26. No interest has been accrued on the note. 7. Outstanding checks on July 31 totalled $361. 8. Included with the cancelled checks was a check (totalled $759) issued by Samantha William (a customer) to XYZ company for services provided. The bank deposited the money to Pure Diamond company account
i need Bank reconciliation statement with excel formatting
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started