Channel Income Daily Summary

The Channel Income Daily Summary report totals channelling income for a date range, by appointment date and by payment method. Use it to check how much was collected in cash, by card, through agents and by every other payment method.

Navigation

Menu → Channelling → Reports → Income Reports → Channel Income Daily Summery

Requires the ChannelReports privilege.

---

Filters

Filter	What it does
From / To	The date and time range of the bookings.
Institution	One institution, or all.
Report Status	Summary View or Details View.
User	One user, or All Users.
Category	The service categories to include (required).
Payment Method	Only bills paid by the selected methods. Leave empty for all methods.

Click Process. If nothing matches, the page says No bills match the selected filters.

Agent bookings

Which agent bookings appear depends on the User and Payment Method filters:

• All Users: agent bookings entered at the counter and bookings made by agents through the online booking service. Online bookings show Online in the Billed By column.
• One user: only the agent bookings that user entered at the counter. Online bookings have no user, so they do not appear.
• Payment Method = Agent: only agent bookings. Leave Agent out of the selection to exclude them.

Split payments

A bill paid with Multiple Payment Methods counts each part under its own method. For example, a bill paid partly in cash and partly by card adds its cash part to the Cash total and its card part to the Card total.

When a Payment Method filter is set, a split bill is included if any part matches, and only the matching part is counted. With Card selected, only the card part of a cash-and-card bill counts towards the card total.

---

What the report shows

Detailed bill list

Every bill in the range: Bill ID, Appointment Date, Created Date, Billed By, Patient Name, Payment Method, Hospital Fee, Doctor Fee and Total Fee. Reversing bills (cancellations and refunds) are shown with negative amounts. The totals at the foot cover every bill, not only the page on screen.

Summary by Appointment Date

One row per appointment date, with one column for each payment method collected in the range. (Illustrative figures.)

Each row shows the appointments, total amount, doctor fee and hospital fee. It also has one column for each payment method collected in the range, for example Cash, Card (Credit/Debit), Agent Payment, Online Settlement or Cheque. The payment method columns add up to the Total Amount.

Collection summary

One line per payment method collected, then the Grand Total Collection and the appointment counts. (Illustrative figures.)

• One line per payment method collected, for example Total Cash Collection and Total Card (Credit/Debit) Collection.
• Grand Total Collection: the sum of those lines.
• Total valid appointments, the cancel and refund collection, and the cancel and refund counts.

---

Print, PDF and Excel

• Print Table opens a print view with the same tables and totals.
• Export as PDF and Export to Excel contain the detailed bill list. In Summary View they also contain the summary by appointment date and the collection summary, with the same payment method columns and lines.

---

Related Articles

• Channel Summary Collection Report: one cashier's shift-end collection
• Channel Reports Overview