Description

Petty Cash Management Template with Employees Reimbursement Tracking Ledger, Expenses Accounts Allocation, Summary Report and a Lot more.

This Petty Cash Management Template is way more than simply tracking your cash in and cash out, developed with love and devotion by Acute Consultants’ team. Input your daily cash debits and credits, allocate to employees who submitting bills, Assign expenses accounts. To enhance usability and accuracy, the template features dropdown lists for common expense categories, employees name, and other relevant data. Users can select from predefined options, reducing the chances of input errors.

Get your employees Reimbursement Ledger with complete details and running balance. Get the Summary Report of all expenses, this Summary Report can be filtered by reporting basis, whether bills submitted or payout amount only and you can also filter report for any date.

This Petty Cash Management template has different sheets inside to let you keep control over tracking. it has following sheets each with a unique purpose.

1: Summary Report.

This provides you the complete summary of all transaction. You can filter by date or by reporting method as Bill submitted only or Cash paid.

 

 

2: Main Data Entry Sheet to enter your transactions, Bills received, cash paid, or cash received.

Each and every cell in this sheet is formatted and restricted to correct data entry. Searchable drop-down list for correct and easy data entry. List can be changed or edited from Lists sheet. Cell will automatically be highlighted if the value in cell is wrong or does not match with database of employees or expenses accounts. Rest of things of this petty cash manager are self-explanatory as in this below screenshot.

 

 

3: Employee Reimbursement Ledger:

The template includes a dedicated section to track employee reimbursements.

1. • Select the employee’s name from searchable dropdown list and report will be updated automatically for that employee, simple is not it?
   • Each entry captures the date, description, and the account to which the reimbursement should be allocated.

 

 

 

4: Cash Counter.

For your ease and time saving, this petty cash management template has a simple cash counter to keep track of daily closing cash in hand with complete denomination.

 

5: Lists.

This sheet has base of all the dropdown lists. All the dropdown list e.g. employee name, Expenses accounts etc, are fetched from this sheet. You can edit or change the values as per your needs.

Don’t worry for errors, because this template will automatically red highlight the cell where assigned value is different from value in list database.

 

 

We hope you will love this template just like our PDC Received and PDC Issued trackers, as it is updated version based on many users reviews and feedback. We tried our best to cover all the basic needs.