Transactions for the month of January follow:

GJ 1	January 3	Received a check in the amount of $44,900 from Bilder Construction Company for full payment of their December 4 invoice.
2	4	Issued check No. 1600 for $16,306 to Edward's Plumbing Supplies, Inc, in payment of November 5 purchases.
3	5	Received a check in the amount of $10,300 from Coconino Contractors for full payment of their December 5 invoice.
4	5	Received a check in the amount of $41,199 from Boecker Builders in full payment of invoice dated December 27.
5	5	Sold fixtures and materials to Rankin Plumbing. on account for $36,050 invoice dated January 5.
6	6	Issued check No. 1601 for $48,330 to Phoenix Plastics. in full settlement of December 21 invoice (terms 1/10, n/30).
7	6	Issued check No. 1602 for Oxenford Copperworks in full settlement of December 28 invoice (terms 1/10, n/30)
8	6	Received a check in the amount of $22,197 from Swanson Brothers Construction in full payment of the remainder of the December 28 invoice.
9	7	Received a check for $3,700 from Iwanaga Plumbing and Heating representing payment in full for the account balance written off on December 4 of the previous year. It seems that while the initial assessment of collectability was bleak, Iwanaga was able to pay their creditors and will not cease operations.
10	7	The payroll summary for the biweekly pay period ended Friday, January 7 contained the following information (for simplification purposes, payroll tax expenses have been included in the amounts):
	Office and Administrative Salaries - $ 37,333
	Sales Salaries and Commissions - 7,621
	Delivery and Warehouse Wages - 5,021
	Total Wages Paid $ 49,975
	Payroll funding was made on January 7 from the Cash (101) Account
11	10	Issued check No. 1603 for $14,850 to Ron & Rod's Plumbing Products, in payment of November inventory purchases.
12	10	Purchased drain pipe from Smith Pipe Company on account, for $32,200 terms 1/15, n/60 FOB Shipping Point.
13	11	Check 1604 for $652 was issued and paid to S. White Trucking Company for freight on December 17 purchase from Smith Pipe Company
14	11	Received a check in the amount of $26,770 from The Potts Company in full payment of the remainder of the December 12 invoice.
15	13	Accepted return of unused materials from Beverly's Building Products, billed to customer at $3,000 as part of December 3 invoice; materials were returned to Blue Ridge's inventory.
16	14	Received a check in the amount of $10,150 from Beverly's Building Products as payment of the remaining portion of the December 3 invoice.
17	17	Received a check in the amount of $7,920 from A&B Hardware in full payment of the remainder of the December 18 invoice.
18	18	Coconino Contractors, Inc agrees to convert their $42,780 overdue accounts receivable balance to a new 15% 6-month note (in addition to their 11/1/22 note)..
19	21	The payroll summary for the biweekly pay period ended Friday, January 21 contained the following information (for simplification purposes, payroll tax expenses have been included in the amounts):
	Office and Administrative Salaries - $ 35,444
	Sales Salaries and Commissions - 7,321
	Delivery and Warehouse Wages - 4,489
	Total Wages Paid $ 47,254
	Payroll funding was made on January 21 from the Cash (101) Account
20	21	Issued check # 1605 for $2,300 to DeKalb Transport for December 24 freight invoice.
21	24	Issued check No. 1606 to Smith Pipe Company in settlement of the January 10 invoice.
22	25	Sold pipe and plumbing materials to Boecker Builders on account for $8,100
23	25	Purchased PVC storm drain piping from Phoenix Plastics. on account, for $75,420 terms n/60.
24	26	Purchased steel beams from Khatan Steel Corp. on account, for $75,420 terms n/60.
25	26	Received payment from Trudy's Plumbing in the amount of $55,770 for full payment of December 31 invoice
26	28	Received payment from Coconino Contactors in the amount of $46,350 for full payment of 11/1/22 Note Receivable
27	31	Issued check # 1607 for $3,000 to Business Basics, Inc for December 31 purchase of office supplies.
28	31	$35,000 Dividend paid to shareholders.
29	31	Issued check # 1608 for $32,400 to Bain Insurance Co for the annual insurance premium for the period March 1 - February 28, 2024.
30	31	Received payment of $36,111 (by check) for completed January installation services provided to Boecker Builders not previously billed during the month.
31	31	Completed installation for Bilder Construction Company and billed $42,721 for work performed in January.
32	31	Sold plumbing materials to Coconino Contractors, Inc on account for $42,330.
33	31	Received and paid January Utility bill by issuing check #1609 for $2,137.
34	31	Reimbursed Donna Pell, office manager for miscellaneous January office expenses with check #1610 in the amount of $136.
35	31	Issued check #1611 for $2,300 for January advertising expenses.
36	31	Issued check #1612for $600 to Scooter Gordon for January gas and repairs on delivery truck.
37	31	Completed negotiations and shipped (FOB Shipping Point) largest sale in company history to Swanson Brothers Construction for $132,000 for pipes, fixtures, and other plumbing supplies for Swanson's new office complex.
GJ 38	31	Planning for the expansion of operations this year, Blue Ridge Corporation closed on the following Real Estate transaction on January 31: Blue Ridge paid $200,000 for real estate with land, a building, and furniture and equipment. The land is appraised at $92,250; building is appraised at $102,500; and the furniture and equipment are appraised at $10,250.

Please perform the following tasks:

1 Very Important!!!! To ensure that we are all on the same starting point for this new year, you will work with a fresh Excel workbook. Open the file Manual Practice Set GJ GL TB (Fresh Start-Practice Set 3).xlsx and save it as YourName_ACCT305_PS3.xlsx.

Very, Very Important!!! If you submit your previous practice set workbook and your balances do not begin with the correct 1/1/23 balances, your submission will be rejected and you will receive a zero for this practice set.

2 Prepare the journal entries recording the transactions for the month of January. You can begin this new year with GJ1 (no need to resume the numbering from the previous practice sets as you are beginning a new year).

3 Post all Journal Entries to the General Ledger, updating the Balance column as part of the posting

4 - Prepare the unadjusted trial balance in the 1-31-2023 Trial Balance Excel worksheet based on the January 31 General Ledger Balances.