Can you help me create Trial Balance, Balance sheet and Income statement using double entry accounting

After working for a decade in a leading software company, Vinay and Sheela Kapoor decided to set up their own software firm, Kapoor Software (P) Limited on June 1. Each of them deposited Rs 20,000 in the company's bank account in exchange of 2,000 shares of Rs 10 each. Amit Lal, an old friend of the Kapoor's joined the company as office manager on a monthly salary of Rs 3,500, no matter how many days he showed up at work. Amit paid into the bank all customers receipts and made all payments by cheque. Although Amit had no knowledge of accounting, he carefully filed the company's letters, invoices and other papers. Also, he noted down details of cheques received and issued in his diary. The following information is available from Amit's diary.

June 1

Borrowed Rs 12,000 from Canara Bank. Sheela ordered a computer costing Rs 25,000. I paid an advance of Rs 10,000. The balance amount is payable in three equal installments on the fifth of every month beginning july.

June 2

Hired an office room on a monthly rental of Rs 1,300 payable on the first day of the month and paid the rent for june.

June 3

Vinay appointed two programmers on a salary of Rs 140 per day each for the number of days they worked.

June 6

Received the computer. Ordered on Gupta & Co office and computer supplies for Rs 4,100.

June 8

Received supplies costing Rs 2,170.

June 10

Raised invoices on customers Rs 13,800 for providing services.

June 16

One box of CDs costing Rs 490 differed slightly from the purchase specification and Gupta & Co was informed of the rejection. All other items were as ordered and were paid for.

June 19

Received cheques for Rs 12,400 from customers in payment of bills

June 20

Raised invoices on customers Rs 12,600 for providing services

June 23

Received a cheque for Rs 1,600 from customer as payment for services to be provided in july

June 27

Gupta & Co requested me to accept the rejected supplies and said that they would be willing to give a discount of Rs 40 on the CDs to make up for the deviation. I checked with Vinay and he told me to accept the supplies. I accepted the supplies and paid Gupta & Co.

June 28

Received cheques for Rs 5,200 in payment of bills.

June 29

Since the company has a lot of cash Vinay asked me to repay the bank loan. I repaid the loan with interest of Rs 120.

June 30

During the month the company had 21 working days. One of the programmers reported to work on all days while the other worked for only 17 days. I paid june salaries. The inventory of supplies is worth about Rs 1,600. Received june electricity bill for Rs 380 but I could not pay it.

July 1

Paid office rent for july and electricity bill for june

July 3

Received the remaining supplies costing Rs 1,930

July 4

Paid for the supplies.

July 5

Paid the first installment for the computer.

Prepare Trial balance, Income Statement and Balance sheet for the month of June. All workings should be shown separately.