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
Get step-by-step solutions from verified subject matter experts
