Question
Financial Documents Instructions You have been provided with a requisition for a petty cash account for your department. Please recreate the following table to reconcile
Financial Documents Instructions You have been provided with a requisition for a petty cash account for your department. Please recreate the following table to reconcile the petty cash. You will add the following items and calculate the balance of the petty cash at months end. (Remember money that goes out is a debit) Please note: Open Excel to a new page and you will create your own table and when complete, submit your finished excel document to the Dropbox in called Part B Your Name. You can also add more features to the table to make it look more professional. Date Item Debit/ Credit Balance Opening Balance as of October 1 $100
1. Pens - $5.44 Oct. 2 2. Garbage Bags $6.77 Oct. 4 3. Parking Fare $15.00 Oct. 7 4. Coffee for Meeting $3.65 Oct. 10 5. Pastries for Staff Meeting $17.89 Oct. 15 6. Tape $2.99 Oct. 18 7. Parking $4.00 Oct. 28 8. Staff Birthday Cake $20.78 Oct. 19 9. Phone charger $8.96 10. Packet of Stamps $ 5.00
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