Prepare double column cash book from the following information for July 2017

01 02 03 05 Cash in hand $7,500 Bank overdraft $3,500 Paid wages $200 Cash sales $7,000 Cash deposited into bank S4,000 Goods purchased and paid by cheque $2,000 Paid rent $500 10 15 20 25 Drew from bank for personal use $400 30 Salary paid $1,000