Daily Payments Report

Modified on Thu, 16 Jan at 12:43 PM

The Daily Payments report shows payments received by payment method from open & closed tickets, including prepaid deposits collected, tips, taxes, and total cash deposited to the bank.

Things to know:

Tickets with open authorizations but no charges are not shown in this report
Transactions are displayed on the date the payment was processed, regardless of whether a register was open when the payment was made.
Revenue from deposits is displayed on the date the deposit was processed. For example, if an appointment is scheduled for March 9th with a value of $200 and a deposit of $50 was taken on March 4th, revenue of $50 will appear when filtering by March 4. However, when filtering by March 9 (the date the appointment took place and the ticket was closed), the remaining revenue of $150 for the service, excluding the deposit, will be displayed.
Refunds will be reflected on the date the refund was processed, rather than the original ticket date. For example, if an item was purchased on November 13th for $100 but refunded on November 23rd, the report will display the original payment on November 13th and the refund on November 23rd.
Any additional payments made on tickets closed in the past will be reflected on the date the payment was processed. Example: If a ticket was closed in October for $20 and later edited in November with an additional payment of $10:
- The revenue for October will remain at $20
- The revenue for November will reflect the additional $10 payment
The "Deposit Date" column, which indicates when each payment was deposited into your bank account, will align with the date shown in the "Deposit Date" column of the Payment Dashboard report.
The "Date" column (representing when the payment was processed) will correspond with the "Transaction Date" column in the Payment Dashboard report.
This report can be used to reconcile the credit/debit card deposits seen in the Payment Dashboard.

To access this report:

Navigate to Dashboard
Select the Reports tab
Under the Company section, select the Daily Payments report

When the report opens, you can filter by a specific location, staff, and date. You can also choose to view the report by date or location. If the By Location button is used at the top of the report, you will be able to easily compare metrics across locations and location groupings to see which locations are doing better or worse on that dimension.

Once you have selected your filters, click on the UPDATE button to generate the data you are looking for.

Report Filters

Filter	Description
Location	Filter by the location associated with the ticket. This option will only be visible if the account has multiple locations.
Staff	Filter by a specific staff member or by all staff
Date	Select the desired date range. This range will determine which tickets are displayed, with tickets shown according to the date payment was received.

Report Columns

Column	Description
Location	The location where the transaction took place
Date	Tickets and payments are organized by the date payment was received. Clicking the arrow for a specific day will expand the column to reveal the ticket and payment details.
Deposit Date	The date the payment was deposited into your bank account.
Ticket #	Ticket number associated with the payment. Clicking this link will open the ticket in POS.
Client	Client associated with payment. Clicking this link opens the client's profile.
Payment Types (cash/credit card/check//gift card/referral credit/loyalty points/other)	Displays all payments received, categorized by payment method, regardless of whether a register was open when the payment was made. The Referral Credits and Loyalty Points columns will only be visible if the business is configured to offer these incentives to clients.
Total Payments	Total payments collected for the day or for each ticket (if the date column is expanded)
Total Deposit to Bank	Displays cash deposits from the register. This column is visible only when filtering by the Daily view; it is hidden in Weekly or Monthly views.

For more information, contact us at support@mytime.com.