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

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!