Answered step by step
Verified Expert Solution
Question
1 Approved Answer
123 1 Kari's Heating and Air Name 8/18/18 Janae Austin 8/18/18 Al Einstein 8/18/18 Pacman Kong Service Desc Amount Card Type Tankless water heater insti$
123 1 Kari's Heating and Air Name 8/18/18 Janae Austin 8/18/18 Al Einstein 8/18/18 Pacman Kong Service Desc Amount Card Type Tankless water heater insti$ 7,800.00 Visa Furnace repalir $400 Master card A/C unit replacement $8,000 Visa Card Number Security Code 8785-4325-5550-1230 123 555-5444-3333-2222 789 99998888-7777-6660-0000 123 Credit card payments Kari's Heating and Air is a small local company. It provides heating and A/C services, as well as some plumbing services related to water heaters. The company is excited because it is now able to allow customers to pay for services via credit card over the phone. Carl, the billing manager has created a new spreadsheet to keep track of customer credit card payments. The spreadsheet is attached. Carl created the spreadsheet to assist with the monthly bank statement reconciliation. He tried to include sufficient information should he have to conduct further research into any of the transactions. Carl formatted the credit card number to automatically insert dashes. He hopes that this will make it easier to read and to enter. You can see the custom format by accessing the number format expanded options. Before Carl was able to prepare the spreadsheet, he had already accepted three payments. He recorded them separately but is now transferring them to the new spreadsheet. After recording the first one, he receives a phone call and has asked you to quickly add the remaining two. The information follows: 08/18/2018, Al Einstein, Furnace repair, $400, Mastercard, 5555444433332222,789 08/18/2018, Pacman Kong, A/C unit replacement, $8,000, Visa, 99998888777766665555, 123 Quickly input the above information and review your entries for errors. Briefly explain your observations and why it is happening
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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