Purchase & Sales Return Example-3

 

Exp-3 from the following transactions of Ajanta Furniture Mart Prepare an inventory book. 

    Cash Balance: - 40, 00,000                                        Bank Balance: - 50, 00,000

Date	Purchase Item	Party Name	Bill No.	QTY	RATE
01-04-20	Stigen Solid Wood Armchair	Karaka Store	02504	50	5999
01-04-20	Esvelt Solid Wood Armchair	APM Store	02525	100	7499
01-04-20	Elegant Solid Wood Armchair	Mood of Wood Furniture	02545	40	8999
01-04-20	Avian Solid Wood Armchair	Jishan Furniture	02560	70	7999
01-04-20	Peshtigo Solid Wood Armchair	Gharwakhri Furniture	02570	80	6999
01-04-20	William Solid Wood Armchair	Godrej Interior Stores	01001	44	12499
02-04-20	Zenith Solid Wood Armchair	Meghani Furniture	01011	76	9499
02-04-20	Aura Solid Wood Armchair	Maruti Steel Furniture	01025	85	8999
02-04-20	Clint Solid Wood Armchair	Anjanisut Furniture	01100	65	5999
02-04-20	Agatha Solid Wood Arm Chair	New Golden Furniture	01130	70	13999
02-04-20	Arata Coffee Table	Karaka Store	011	15	2499
02-04-20	Alarico Coffee Table	APM Store	025	20	20499
01-05-20	Alazne Coffee Table	Mood of Wood Furniture	040	35	17999
01-05-20	Kanon Coffee Table	Jishan Furniture	065	47	2950
01-05-20	Hikaru Coffee Table	Gharwakhri Furniture	075	35	5448
01-05-20	Melania Study Table	Godrej Interior Stores	080	55	5499
01-05-20	Nakamura Study Table	Meghani Furniture	025	46	5750
01-05-20	Hayao Study Table	Maruti Steel Furniture	0333	50	2499
02-05-20	Kosmo Study Table	Aditya Furniture	0471	100	4899
02-05-20	Segur Solid Wood Study Table	Karaka Store	0542	80	15499
02-05-20	Nanna Storage Cabinet	APM Store	0744	60	3999
02-05-20	Naia Storage Cabinet	Mood of Wood Furniture	1452	35	2450
02-05-20	Kiriko Cabinet with Two Drawers	Jishan Furniture	1445	40	4555
02-05-20	Rosalie Solid Wood Cabinet	Gharwakhri Furniture	6574	75	18999
01-06-20	Kikuchi Bookcase	Godrej Interior Stores	1025	86	16999
01-06-20	Stafford Solid Wood Book Case	Karaka Store	6574	90	18499
01-06-20	4 Seater Dining Set	APM Store	7789	32	14999
01-06-20	6 Seater Dining Set	APM Store	8685	44	20999
01-06-20	Momoko 6 Seater Dining Set	Mood of Wood Furniture	7041	71	20750
01-06-20	Ramen 6 Seater Dining Set	Jishan Furniture	6522	65	21999

Date	Sales Item	Party Name	Bill No.	QTY	RATE
02-05-20	Stigen Solid Wood Armchair	Vijay Furniture Mart	02504	50	6999
02-05-20	Esvelt Solid Wood Armchair	Comforto Furniture	02525	100	8499
02-05-20	Elegant Solid Wood Armchair	Gurukrupa Furniture	02545	40	9999
02-05-20	Avian Solid Wood Armchair	Happy Home Furniture	02560	70	8999
02-05-20	Peshtigo Solid Wood Armchair	Gajjar Furniture	02570	80	7999
02-05-20	William Solid Wood Armchair	New Lucky Furniture	01001	44	14499
01-06-20	Zenith Solid Wood Armchair	India Furniture	01011	76	10499
01-06-20	Aura Solid Wood Armchair	Vijay Furniture Mart	01025	85	10999
01-06-20	Clint Solid Wood Armchair	Comforto Furniture	01100	65	7999
01-06-20	Agatha Solid Wood Arm Chair	Gurukrupa Furniture	01130	70	17999
01-06-20	Arata Coffee Table	Happy Home Furniture	011	15	4499
01-06-20	Alarico Coffee Table	Gajjar Furniture	025	20	22499
02-07-20	Alazne Coffee Table	New Lucky Furniture	040	35	19999
02-07-20	Kanon Coffee Table	India Furniture	065	47	4950
02-07-20	Hikaru Coffee Table	Vijay Furniture Mart	075	35	6448
02-07-20	Melania Study Table	Comforto Furniture	080	55	7499
02-07-20	Nakamura Study Table	Gurukrupa Furniture	025	46	6750
02-07-20	Hayao Study Table	Happy Home Furniture	0333	50	3499
01-08-20	Kosmo Study Table	Gajjar Furniture	0471	100	6899
01-08-20	Segur Solid Wood Study Table	New Lucky Furniture	0542	80	13499
01-08-20	Nanna Storage Cabinet	India Furniture	0744	60	5999
01-08-20	Naia Storage Cabinet	Choice Furniture Mall	1452	35	3450
01-08-20	Kiriko Cabinet with Two Drawers	Kinjal Furniture	1445	40	6555
01-08-20	Rosalie Solid Wood Cabinet	Antech Furniture	6574	75	20999
02-08-20	Kikuchi Bookcase	India Sofa House	1025	86	18999
02-08-20	Stafford Solid Wood Book Case	Vijay Furniture Mart	6574	90	21499
02-08-20	4 Seater Dining Set	Comforts Furniture	7789	32	17999
02-08-20	6 Seater Dining Set	Gurukrupa Furniture	8685	44	23999
02-08-20	Momoko 6 Seater Dining Set	Happy Home Furniture	7041	71	23750
01-09-20	Ramen 6 Seater Dining Set	Gajjar Furniture	6522	65	24999

Date	Sales Return Item	Party Name	Bill No.	QTY
02-05-20	Stigen Solid Wood Armchair	Vijay Furniture Mart	02504	5
02-05-20	Esvelt Solid Wood Armchair	Comforto Furniture	02525	10
02-05-20	Elegant Solid Wood Armchair	Gurukrupa Furniture	02545	4
02-05-20	Avian Solid Wood Armchair	Happy Home Furniture	02560	7
02-05-20	Peshtigo Solid Wood Armchair	Gajjar Furniture	02570	8
02-05-20	William Solid Wood Armchair	New Lucky Furniture	01001	4
01-06-20	Zenith Solid Wood Armchair	India Furniture	01011	7
01-06-20	Aura Solid Wood Armchair	Vijay Furniture Mart	01025	8
01-06-20	Clint Solid Wood Armchair	Comforto Furniture	01100	6
01-06-20	Agatha Solid Wood Arm Chair	Gurukrupa Furniture	01130	7
01-06-20	Arata Coffee Table	Happy Home Furniture	011	1
01-06-20	Alarico Coffee Table	Gajjar Furniture	025	2
02-07-20	Alazne Coffee Table	New Lucky Furniture	040	3
02-07-20	Kanon Coffee Table	India Furniture	065	4

Date	Purchase Return Item	Party Name	Bill No.	QTY
01-06-20	Stigen Solid Wood Armchair	Karaka Store	02504	5
01-06-20	Esvelt Solid Wood Armchair	APM Store	02525	10
01-06-20	Elegant Solid Wood Armchair	Mood of Wood Furniture	02545	4
01-06-20	Avian Solid Wood Armchair	Jishan Furniture	02560	7
01-06-20	Peshtigo Solid Wood Armchair	Gharwakhri Furniture	02570	8
01-06-20	William Solid Wood Armchair	Godrej Interior Stores	01001	4
02-07-20	Zenith Solid Wood Armchair	Meghani Furniture	01011	7
02-07-20	Aura Solid Wood Armchair	Maruti Steel Furniture	01025	8
02-07-20	Clint Solid Wood Armchair	Anjanisut Furniture	01100	6
02-07-20	Agatha Solid Wood Arm Chair	New Golden Furniture	01130	7
02-07-20	Arata Coffee Table	Karaka Store	011	1
02-07-20	Alarico Coffee Table	APM Store	025	2
01-08-20	Alazne Coffee Table	Mood of Wood Furniture	040	3
01-08-20	Kanon Coffee Table	Jishan Furniture	065	47
01-08-20	Hikaru Coffee Table	Gharwakhri Furniture	075	35

Ø Before buying all goods, check very carefully because if you return any purchased goods, then 1% returns charge will be applicable.

Ø If the goods sold are returned then 1% sales return charges will be applied on it.

 Full Amount receives form Debtors & Full Amount pay to Creditors by cheque.