Question

Below transactions are the extracts from the books of Coffee Tea & Company Ltd. for the month of Jan 2020: 1. Sold 12 packages of Thermal Coffee Mugs to Kava Java for £610 each, Invoice No. 339. 2. Made cash sale of 3 boxes of wrapped Chocolate Mints for £830 each. 3. Purchased 16 boxes of wrapped Chocolate Mints from Dominga Wholesalers for £500 each, terms net 30. 4. Sold 8 boxes of insulated Coffee Cup Lids to Central Coffee for £590 each, Invoice No. 340. 5. Made cash sale of 27 bags of Medium Roast Arabica Coffee Beans for a list price of £600 each. A trade discount of 20% applies 6. Kava Java returned 7 packages of Thermal Coffee Mugs that were originally sold for £610 each on 11 June. These items cost £370 each and were not faulty or damaged. Issued a Credit Note for £4,270 7. Made cash sale of 29 boxes of wrapped Chocolate Mints for £830 each. 8. Purchased 13 bags of Medium Roast Arabica Coffee Beans with cash for a list price of £360 each. A trade discount of 20% applies. 9. Paid Dominga Wholesalers full outstanding amount.

Required: Using the above information, you are required to process: • Sales Invoices to the customers • Sales Receipts • Payment Vouchers for Cash Purchases • Remittance Payments • Credit Notes- Just need in an excel format

Answer 1

Sales Invoice to the Customer
Sl No.	Description of Goods/ services	Invoice No	Invoice Date	No of Items	Gross Value	Discount	Taxable Value	Tax (if any)	Invoice value
1
2
3
4

Sales Receipts
Sl No.	Description of Goods/ services	Type (Sales/Credit Note/Debit Note)	Invoice No	Invoice Date	No of Items	Gross Value	Discount	Taxable Value	Tax (if any)	Invoice value
1
2
3
4

Payment Voucher for Cash Purchase
Sl No.	Voucher Number	Type (Purchase/Credit Note/Debit Note)	Invoice No	Invoice Date	Invoice value	Payment	Difference (if any)	Remarks
1
2
3
4

Remittance Purchase
Sl No.	Date	Reference Number	Due Date	Balance O/S	Paid	Difference (if any)	Remarks
1
2
3
4

Credit Note
Sl No.	Description of Goods/ services	Credit Note Number	Credit Note Date	Original Invoice No	Original Invoice Date	No of Items	Gross Value	Discount	Taxable Value	Tax (if any)	Invoice value
1
2
3
4

Hi Student , i wish i have satisfied your problem , still reach me in the comment section for any doubt.