Reineke Companys chart of accounts includes the following selected accounts 101 Cash 201 Accounts Payable 120 Inventory 306 Owners Drawings 130 Prepaid Insurance 505 Cost of Goods Sold 157 Equipment On October 1, the accounts payable ledger of Reineke Company showed the following balances Uggla Company $4,000, Orr Co $3,800, Rosenthal Co $2,200, and Clevenger Company $5,000 The October transactions involving the payment of cash were as follows Oct 1 Purchased merchandise, check no 63, $400 3 Purchased equipment, check no 64, $820 5 Paid Uggla Company balance due of $4,000, less 2 discount, check no 65, $3,920 10 Purchased merchandise, check no 66, $2,350 15 Paid Rosenthal Co balance due of $2,200, check no 67 16 C Reineke, the owner, pays his personal insurance premium of $500, check no 68 19 Paid Orr Co in full for invoice no 610, $2,100 less 2 cash discount, check no 69, $2,058 29 Paid Clevenger Company in full for invoice no 264, $2,700, check no 70 Journalize the transactions above in a four column cash payments journal with columns for Other Accounts Dr , Accounts Payable Dr , Inventory Cr , and Cash Cr Foot and cross foot the journal (Record entries in the order displayed in the problem statement Round answers to 0 decimal places, e g 5,275 ) Cash Payments Journal CP1 Date Ck No Account Debited Ref Other Accounts Dr Accounts Payable Dr Inventory Cr Cash Cr Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 63 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company 120 Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 64 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company 157 Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 65 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 66 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company 120 Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 67 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 68 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company 306 Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 69 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company Oct 1Oct 3Oct 5Oct 10Oct 15Oct 16Oct 19Oct 29 70 InventoryEquipmentUggla CompanyRosenthal Co Owners DrawingOrr Co Clevenger Company (X) (201) (120) (101) LINK TO TEXT LINK TO TEXT Insert the beginning balances in the Accounts Payable control and subsidiary accounts, and post the October transactions to these accounts (Post entries in the order of entries presented in the previous part ) General Ledger Accounts Payable Date Explanation Ref Debit Credit Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 CP1 Accounts Payable Subsidiary Ledger Uggla Company Date Explanation Ref Debit Credit Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 CP1 Orr Co Date Explanation Ref Debit Credit Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 CP1 Rosenthal Co Date Explanation Ref Debit Credit Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 CP1 Clevenger Company Date Explanation Ref Debit Credit Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 Balance Oct 1Oct 5Oct 15Oct 19Oct 29Oct 31 CP1 LINK TO TEXT LINK TO TEXT Prove the agreement of the control account and the subsidiary account balances (Do not list those accounts that have zero ending balance ) Accounts payable balance $ Subsidiary account balances Clevenger CompanyOrr Co Rosenthal Co Uggla Company $ Clevenger CompanyUggla CompanyOrr Co Rosenthal Co Can I please get the in Excel form, it would be very much appreciated )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 14, 2024

Reineke Companys chart of accounts includes the following selected accounts. 101 Cash 201 Accounts Payable 120 Inventory 306 Owners Drawings 130 Prepaid Insurance 505 Cost

Reineke Companys chart of accounts includes the following selected accounts.

101	Cash	201	Accounts Payable
120	Inventory	306	Owners Drawings
130	Prepaid Insurance	505	Cost of Goods Sold
157	Equipment

On October 1, the accounts payable ledger of Reineke Company showed the following balances: Uggla Company $4,000, Orr Co. $3,800, Rosenthal Co. $2,200, and Clevenger Company $5,000. The October transactions involving the payment of cash were as follows.

Oct. 1	Purchased merchandise, check no. 63, $400.
3	Purchased equipment, check no. 64, $820.
5	Paid Uggla Company balance due of $4,000, less 2% discount, check no. 65, $3,920.
10	Purchased merchandise, check no. 66, $2,350.
15	Paid Rosenthal Co. balance due of $2,200, check no. 67.
16	C. Reineke, the owner, pays his personal insurance premium of $500, check no. 68.
19	Paid Orr Co. in full for invoice no. 610, $2,100 less 2% cash discount, check no. 69, $2,058.
29	Paid Clevenger Company in full for invoice no. 264, $2,700, check no. 70.

Journalize the transactions above in a four-column cash payments journal with columns for Other Accounts Dr., Accounts Payable Dr., Inventory Cr., and Cash Cr. Foot and cross-foot the journal.(Record entries in the order displayed in the problem statement. Round answers to 0 decimal places, e.g. 5,275.)

Cash Payments Journal
CP1
Date	Ck. No.	Account Debited	Ref.	Other Accounts Dr.	Accounts Payable Dr.	Inventory Cr.	Cash Cr.
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	63	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company	120
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	64	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company	157
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	65	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	66	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company	120
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	67	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	68	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company	306
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	69	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company
Oct. 1Oct. 3Oct. 5Oct. 10Oct. 15Oct. 16Oct. 19Oct. 29	70	InventoryEquipmentUggla CompanyRosenthal Co.Owners DrawingOrr Co.Clevenger Company

(X)	(201)	(120)	(101)

LINK TO TEXT LINK TO TEXT

Insert the beginning balances in the Accounts Payable control and subsidiary accounts, and post the October transactions to these accounts.(Post entries in the order of entries presented in the previous part.)

General Ledger
Accounts Payable
Date	Explanation	Ref.	Debit	Credit	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31		CP1
Accounts Payable Subsidiary Ledger
Uggla Company
Date	Explanation	Ref.	Debit	Credit	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31		CP1
Orr Co.
Date	Explanation	Ref.	Debit	Credit	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31		CP1
Rosenthal Co.
Date	Explanation	Ref.	Debit	Credit	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31		CP1
Clevenger Company
Date	Explanation	Ref.	Debit	Credit	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31	Balance
Oct. 1Oct. 5Oct. 15Oct. 19Oct. 29Oct. 31		CP1

LINK TO TEXT LINK TO TEXT

Prove the agreement of the control account and the subsidiary account balances.(Do not list those accounts that have zero ending balance.)

Accounts payable balance:	$

Subsidiary account balances:
Clevenger CompanyOrr Co.Rosenthal Co.Uggla Company	$
Clevenger CompanyUggla CompanyOrr Co.Rosenthal Co.
Can I please get the in Excel form, it would be very much appreciated :)