# Daily Collection Invoice Wise Report The **Daily Collection Invoice Wise Report** displays the collection amounts generated by doctors in the facility, organized **Item Type-wise** (Services, Procedures, etc.) and **Invoice-wise**. It provides a clear view of each doctor’s daily collections, breaking down amounts per invoice and by item type, enabling efficient tracking of revenue, monitoring of doctor performance, and analysis of high-performing services. *** ### Steps to Generate the Daily Collection Invoice Wise Report * Open the **Daily Collection Invoice Wise Report** by navigating to **Home > Reports > Daily Reports > Daily Collection Invoice Wise Report.** * Set the **From** and **To** date range. * Optionally, use the **Clinic**, **Users,** and **Doctor** filters to refine results. * Optionally, search for a patient using **Patient PIN, Name, Mobile Number,** or **EID Number.** * Click **Search** to generate the report. *** ### Report Structure The generated reports consist of 2 sheets * The first sheet of the Excel file contains the **Clinic Summary**, which provides a doctor‑wise, service‑wise, and payment‑mode‑wise summary for the selected date. It includes details such as number of visits, number of invoices, billing amounts (Gross, Discount, VAT, Net), and collections through Cash, Card, Bank Transfer, Payment Gateway, Patient Share, and Insurance. It also presents consolidated sections like Invoice Total, Sick Leave, Advance & Refund, and the Grand Total for the day, summarizing operational and financial activity across the clinic. * The second sheet of the Excel file contains **Cash Receipt Details**, listing individual entries containing fields such as Date, PAM PIN, Patient Name, Transaction Type, Advance Amount, Refund Amount, Collection Type, Transfer details, and Remarks. *** --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://unitecare.gitbook.io/uniteemr/reports/daily-reports/daily-collection-invoice-wise-report.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.