Question
Accounting Cycle assignment: - May1 , Check #79 in the amount of 45$ was issued to pay the phone bill for April - May 3
Accounting Cycle assignment:
- May1, Check #79 in the amount of 45$ was issued to pay the phone bill for April
-May 3, Check #80 in the amount of 342$ was issued to Electrifying Bulb Co. For payment of April invoice. (The bulbs were purchased in April for resale).
-May 4, Julie Adams bought 230$ worth of lamps, which were charged to account. Invoice #123 was issued.
-May 5, Alice (The store owner) decided to write off Ed Miller's long overdue account for the amount of 34$. She sends you a memo, dated May 4, requesting you to so. (Hint: This is a "Bad Debts Expense").
-May 6, Check #81 is issued in the amount of 31$ to "Paper Works." For office supplies, bought while at the store.
-May 7, Weekly cash register summary Received showing:
Total sales for the week: 4853$
Sales tax: 147$
Cash recieved: 5000$
-May 9, Check #82 in the amount of 55$ was issued to pay utility bill for April
-May 10, Check #83 in the amount of 85$ was issued "Paper Works" for payment of April Invoice. (In April, the office supplies were bought on account).
-May 12, Alice Purchased 420$ worth of bulbs from the "Electrifying Bulb Co." On account. The bulbs will be resold. Invoice #142 was issued to Alice by "Electrifying Bulb Co."
-May 14, Weekly cash register summary:
-Total sales for the wk.: 3642$
-Sales Tax: 98$
-Cash recieved: 3740$
-May 15, check #84 in the amount of 2000$ was issued to the payroll account to cover the bimonthly salaries.
-May 17, check # 85 in the amount of 125$ was issued to Alice Peterson as a personal draw on the Drawing account.
-May 19, Alice purchased 1,000$ worth of lamps for resale from "Light House Supply" and put the amount on her account. Invoice #384 was issued to Alice.
-May 20, Check #86 in the amount of 1200$ was issued to make the mortgage payment
-May 21, Weekly cash register summary received:
Total sales for the week: 1423$
Sales tax: 27$
Cash received: 1450$
-May 22, A check is received from customer Julie Adams in the amount of 150$ for last month's purchases. Credit Invoice (receipt) #42 was issued.
-May 25, Check # 87 in the amount of 200$ was issued to make the payment on a note for the month of May.
-May 27 , Alice returned some of the bulbs she had purchased earlier from "Electrifying Bulb Co." Electrifying Bulb Co. credited Alice's account for the amount of 200$ and gave her credit invoice #18 (hint: this is a purchase Returns and allowances)
-May 31, Weekly cash register summary:
Total sales for week: 2546$
Sales tax: 134$
Cash received: 2680$
-May 31, Check #88 in the amount of 3000$ was issued to the payroll account to cover the second half of the bimonthly payroll.
-May 31, Check # 89 was issued to a customer who returned a defective lamp for the amount of 56$. The sales tax on the lamp was 3$. (Hint: Sales Returns +Allowances is 53$). Sales Tax payable = 3$ , Cash=56$, Sales return slip #21 was issued
These transactions are meant to loaded into a General Journal, and a ledger. Which I have actually done already. I'm stuck at the 10-column worksheet. Columns 5+6 Adjusted balance.
I've recorded all my numbers to the " The Unadjusted balance column", then to the "Adjustments. columns".... The Assignment specifically states the "Adjusted balnce" is supposed to equal up to 135,374$, which i can't seem to hit. I'm either above or below it. obviously i've got my numbers wrong somewhere. But I can't seem to figure out where, so i can't figure out where i went wrong. Is there a way to upload my work so you might be able to look at it?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started