Daily Credit Card Collection Report
On this page
The Daily Credit Card Collection Report lists the card payments of one day with the card type, the masked card number and the authorization code, grouped by card type with a summary, so the accountant can match the day to the card machine or gateway settlement.
Purpose
Reconcile card receipts of a day with the card batch or the payment gateway statement.
Who uses it
- Accountant or night auditor: card settlement.
About this report on screen
Every report page has an About this report bar under its header (button Explain / Hide). It explains the report in plain words:
- Summary: Card payments received on a date.
- What this report shows: Every card payment (and deleted card payment) on the chosen date with card type, masked card number, authorisation code, guest and amount.
- How to read it:
- Match the totals per card type with the card terminal's settlement report.
Columns explained (the same text shows on the help icon next to a column title):
| Column | Meaning |
|---|---|
| Auth Code | Approval code given by the card company. |
Before you start
- Only payments whose payment type has the category Card appear. If your hotel takes cards through a gateway, the gateway payment types must use that category.
Step by step
- Click Reports in the left menu (or press Ctrl+K and type the report name). The report library opens at
#/reports. - Choose the category Daily Reports (or type in the search box) and click the card Daily Credit Card Collection ("Credit card revenue"). You can also open
#/report/daily-credit-card-collectiondirectly. - The report opens and runs once with its default criteria, so you already see data. Under Report criteria set From Date as you need (in a date calendar, Working Date jumps to the current business date).
- Click Show to run it again with the new criteria. The line under Results tells how many rows are shown.
- Read the result as a Table or as Cards (switch at the top right). Columns shows or hides columns and lets you drag them into another order; click a column title to sort. Hide criteria / Show criteria folds the criteria away; on a tablet or phone it folds by itself after Show and leaves a one-line summary.
- Click Export and choose PDF, Excel or Email (PDF). The button is always in the header but stays disabled until the report has rows.
Filters
| Filter | Meaning | Default / rules |
|---|---|---|
| From Date | The business day. | The PMS date. (The screen always asks for all card types, sorted by card type.) |
Columns
| Column | Meaning and how it is calculated |
|---|---|
| Room/Room Type | The room, or the room type for reservations. |
| Payment/Deletion Date | Date and time of the payment, or of its deletion for a deleted payment. |
| Guest Name | The payer's folio. |
| Card Type | Visa, Master Card, Amex... (the payment type name). |
| Card No | Masked card number. |
| Auth Code | Authorization code from the card network or gateway. |
| Payment Amount | The amount; refunds and deletions are negative. |
Totals and grouping
Lines are grouped by card type, followed by Total and Credit Card Summary. A symbol marks special lines: ! deposit payment, * reservation payment, ^ Sales & Channel payment, ~ group payment, & miscellaneous income payment, @ deleted payment, @@ refund payment, # authorized payment, #* reservation authorized payment, #~ group authorized payment. The legend is printed at the end of the report.
How to read an example
The demo hotel has taken no card payments (all payments are cash or UPI), so on 17-Oct-2026 and on 16-Oct-2026 the table shows no card lines: only the Total and the Credit Card Summary at 0.00, and the legend of the symbols. When cards are used, each line shows the card type, the masked number and the authorization code, and the Total equals the card amounts of the Daily Collection report.
The numbers come from the SunTatva Demo Hotel on the day this page was written; your own figures will of course differ.
Common questions it answers
- How much was paid by card today?
- Does the card total agree with the machine batch?
- Which payments were refunded or deleted?
Troubleshooting
| What you see | Why and what to do |
|---|---|
| The report is empty although cards were used | Check the date and check that the payment type has the category Card (Settings > Payment Type). Payments entered through a gateway can appear in Credit Card Activity. |
| UPI or wallet payments are missing | They are not of category Card. |
| Export is greyed out | The report has no rows (No record found!), so there is nothing to export. Change the criteria and click Show. |
| You are signed out when the report opens | Your role does not have the privilege of this report. The screen checks the privilege when the address is opened and logs you out if it is missing. |
Messages you may see
| Message | Why it appears | What to do |
|---|---|---|
| No record found! | The report found nothing for the date or filters you chose. | Check the date (the first PMS date of the hotel is the earliest you can pick), the desk user and the other filters, then click Show. |
| Email sent successfully. | You chose Export > Email (PDF). The server built the PDF and handed it to the mail service. | Nothing. If the mail does not arrive, check the e-mail address of the property and the e-mail settings. |
Related reports
- Credit Card Activity: every card transaction of a range with gateway data and declines.
- Daily Collection Payment Type.
Screenshots
