Question
Use the ledger template you created during the tutorial and enter the following information into the correct tab on your ledger. Be sure to include
Use the ledger template you created during the tutorial and enter the following information into the correct tab on your ledger. Be sure to include a balance column that automatically calculates and checks the entries for consistency.
Background:
You work for a painting company that is contracted to work on a new housing development in the area. You are responsible for recording the accounts payable and receivable into ledgers. Your boss is not that organized and does not keep his own records, so once a month sends you an email where he describes what needs to be entered.
Tips:
Assume the date this email was sent was January 30th of the current year
Invoices for accounts receivable are chronological are numbered as followed DCday/month/year/1. For example, the first invoice sent in the month of January on January 3rd, 2022 would be DC030120221. The second sent on January 10th would be DC100120222.
You can make up your own invoice numbers for accounts payable
Payments for accounts receivable and payable are always due one month from the date of the invoice
Email with information to be entered into your ledger:
Hi amal
Hope you had a nice weekend. Please see below for info on what needs to be entered.
I went to Home Depot on the 5th ($750), 10th ($890), and 19th ($7.50). I paid the $750 and $890 from Home Depot today. I got paint from Windsor Painting on the 6th ($11,400) and paid $6000 on the 15th, I also ordered you some office supplies from Staples on the 20th ($350) Did you get them, by the way?
Home Builders Inc sent us the net $8900 for our last job last job today. I also contracted some guys out to help with a different job on the 2nd, so Paint with Pete owes us $5700. I brought some paint back to Windsor on the 16th, so they gave us a credit of $600.00
I think thats it thanks! Felice
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