Asset Management, Financial Model, Financial Services |
Financial Model, Financial Modeling, Financial Reporting, Management |
Petty Cash Management Ledger
In addition to maintaining a primary or general cash ledger, many businesses also maintain a small cash ledger called a petty cash book to document minor day-to-day expenses. This ledger template is designed not only for petty cash management, but also to provide a daily and monthly overview of your actual cash reserve.
Cash Ledger:
On this page, you will manage your cash ledger entries, including both income and expenses. Record information such as the date, value, description, category, customer name, supplier, paid value, and any other observations.
Monthly Summary:
This tab provides a consolidated monthly summary of cash income and expenses. It is designed to help you track the opening balance, entries, and final balance by month. All data are presented in graphs of Income vs. Expenses and Final Balance Evolution. Additionally, there is a Payment Summary that allows you to visualize monthly income and expenses by payment method.
Daily Summary:
This page displays the daily summary by consolidating all income and expenses. You can monitor the opening balance, all entries, and final balance at the end of the day, based on the selected month. You can also choose a specific date to review the daily summary of payments.
Income and Expense Details:
This page shows a PivotTable report with the Sum of Income and Expenses. In this report, you can use filters such as “Customer/Supplier” to drill down and examine different categories to determine the Final Balance by month.
Database:
On this page, you can register items that will be used as a drop-down list in the Cash Ledger page. These items include the Customer/Supplier Name, Categories, Payment Methods, and the opening balance on January 1st (if you begin the worksheet in a different month, leave this balance blank and use the Cash Ledger page to include an entry in the corresponding initial month).
File type: .xlsx
Similar Products
Other customers were also interested in...
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Asset Management Business Financial Projection 3 S...
3-Statement 5 year rolling financial projection Excel model with valuation for existing/startup Asse... Read more
Alternative Investment Company Valuation Template
Alternative Investment Company Valuation: All-In-One Model for Private Equity, Asset Management, and... Read more
Asset Management Company – Closed End Fund M...
Financial Model presenting a scenario of a Closed-End Fund managed by an Asset Management Compan... Read more
Investment Fund Preferred Return Tracker: Up to 30...
Track preferred returns for investors in a fund with this template. Premium joint venture tracking t... Read more
Leasing Company Financial Model – 5 Year Forecas...
Financial leasing companies engage in financing the purchase of several types of assets. Though a le... Read more
Multi-Member Investment Fund Portfolio and Distrib...
A fund management tool to track many positions over time as well as distributions to up to 20 member... Read more
Investment Holding Company 3 Statement Financial P...
3 statement 5 or 8 year rolling financial projection Excel model for an investment holding company h... Read more
Debt Fund Excel Model
Explore the Debt Fund Excel Model, a comprehensive tool for evaluating new credit fund opportunities... Read more
Mortgage Bank Financial Model Excel Template
Mortgage Bank Budget Template Create fully-integrated financial projection for 5 years With 3 way fi... Read more
You must log in to submit a review.