Question: 1. Using the spreadsheet file named anna.xls, complete the October accounting tasks for Antonelli's Accounting Services. A. Enter the remaining ten transactions. Make sure you

 1. Using the spreadsheet file named anna.xls, complete the October accounting

1. Using the spreadsheet file named anna.xls, complete the October accounting tasks for Antonelli's Accounting Services. A. Enter the remaining ten transactions. Make sure you have done the first two transactions that are described above. (These are the bank loan for $2000 and the cash purchase of equipment for $1300.) TRANSACTIONS October 3. Collected $200 from Jones Travel in partial payment of their debt. 4. Sold the old computer, originally valued at $900, for $150 cash. 5. Sold accounting services to F. Leonel for $500. He has 30 days to pay. 6. Purchased printer paper and toner from Best Offices for $225. The bill is to be paid in 30 days. 7. Returned $50 of damaged supplies to Best Offices. Best Offices agreed to reduce the amount owed to them by $50. 8. Anna Antonelli withdrew $600 from the business for personal use. 9. Paid $225 to reduce the bank loan. 10. Sold $700 more of accounting services to Jones Travel. Jones Travel paid $200 now with the balance to be received in 30 days. 11. Paid $125 of the amount owed to Best Offices. 12. Placed an advertisement in a local newspaper called the Eastside News. The total bill amounted to $360 and is to be paid in 30 days. B. Check the Zero Proof column and equation verification area to ensure your work is in balance. 1. Using the spreadsheet file named anna.xls, complete the October accounting tasks for Antonelli's Accounting Services. A. Enter the remaining ten transactions. Make sure you have done the first two transactions that are described above. (These are the bank loan for $2000 and the cash purchase of equipment for $1300.) TRANSACTIONS October 3. Collected $200 from Jones Travel in partial payment of their debt. 4. Sold the old computer, originally valued at $900, for $150 cash. 5. Sold accounting services to F. Leonel for $500. He has 30 days to pay. 6. Purchased printer paper and toner from Best Offices for $225. The bill is to be paid in 30 days. 7. Returned $50 of damaged supplies to Best Offices. Best Offices agreed to reduce the amount owed to them by $50. 8. Anna Antonelli withdrew $600 from the business for personal use. 9. Paid $225 to reduce the bank loan. 10. Sold $700 more of accounting services to Jones Travel. Jones Travel paid $200 now with the balance to be received in 30 days. 11. Paid $125 of the amount owed to Best Offices. 12. Placed an advertisement in a local newspaper called the Eastside News. The total bill amounted to $360 and is to be paid in 30 days. B. Check the Zero Proof column and equation verification area to ensure your work is in balance

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!