Article Details
Summary
The Payments Collected Summary gives a high-level view of payments recorded in Gingr. It covers prepayments, payments, postpayments, deposits, refunds, and refunded deposits. You can run it for date ranges, days of the week, and any mix of locations across subdomains.
Gingr Business Analytics is a paid reporting tool for facilities with many subdomains. It helps them view combined booking and financial data across Gingr URLs. To sign up, see Gingr Business Analytics.
What This Does
- The Gingr Business Analytics » Financial » Payments Collected Summary section shows an overview of all payment data for the subdomains you select. This includes Prepayments, Payments, Postpayments, Deposits, and Refunds.
- The data refreshes every day at midnight to add the previous day.
- You can limit data by subdomain, location, date range, and day of week. You can export each section to Excel or CSV.
- Hover over a graph to see its tooltip. Select a section to update the graphs. Select it again to reset. Right-click any graph to show the data as a table.
Where to Find It
After you have a Gingr Business Analytics account linked to your subdomains, log in at analytics.gingrapp.com. Go to Reporting » Financial » Payments Collected Summary. Select Payments Collected Summary in the Left-hand Navigation menu, or select Go to Report in the Payments Collected Summary section.
Report Parameters
The report defaults to all subdomains you can access, all days of the week, and the last 30 days. Select the parameters in the box at the top right of the screen to change the output.
| Parameter | Description |
|---|---|
| Subdomain/Location(s) | Combine or exclude data for subdomains and for locations at each subdomain. Select the arrow next to a subdomain to select or clear its locations. |
| Day of Week | Choose the days of the week to view. For example, all Mondays in the date range. |
| Date Range | Select "Last 30 Days" to see Quick Selection options, such as "Last 7 days" and "Year to date." You can also select the displayed range to enter a custom date range. |
Report Output
The report has five sets of data: Payments, Refunds, Totals, Net Total Over Time, and Net Total Breakdown. These match the Payments Summary section at the top of the Revenue by Date Report. They give an overview of payments on invoices collected in Gingr during the date range.
In Gingr, "payments" are the sum of all money received or refunded by any payment method in the date range. If a customer did not pay on the date or range you run the report for, no payment shows. This is true even if they had an invoice checked out. Payment data includes payments and refunds for all payment methods. It does not include tax, tips, or items such as reservation types or services, because Gingr counts those as "charges." "Payments" only means money paid or refunded on an invoice.
Tip: Right-click any section of the report to see the data as a table instead of a graph.
Payments Summary
This section gives a quick overview of payment data for the date range. It includes Collected Deposits, Pre-Payments, Payments, and Post-Payments.
Refunds Summary
This section gives a quick overview of refund data for the date range. It includes Refunded Payments, which covers line-item refunds and payment-only refunds, and Refunded Deposits.
Net Total Summary
This section is the net total of the Payments Summary minus the Refunds Summary.
Net Total Over Time
This section shows a total for each day if the date range is 30 days or less. It shows a total for each month if the range is more than 30 days. It shows a total for each year if the range is more than a year and a half.
Invoices Totals Breakdown
This section gives a more detailed view of payments. It includes Collected Deposits, Pre-payments, Payments, Post-payments, Refunded Payments, and Refunded Deposits. Select the + sign next to a sub-section title to see the full breakdown of items in the totals.
Drill Down Data
Each section has options to drill down into the data in the charts and graphs.
In Net Total Over Time, hover over a data point to see a more detailed breakdown. Depending on the date range, it shows by day, month, or year.
You can also select any date in Net Total Over Time. The Payments, Refunds, Net Total, and Net Total Breakdown sections update to show data for just that date or range. Select the date again to remove the spotlight.
Each section can also show its data as a table. Select the three dots next to the section and choose Show as a Table. You can also right-click any graph and choose Show as a table.
The data shows in an easy-to-read table on a new page.
Export the Report
You can export each section to Excel or CSV.
- Generate the report with the parameters you want.
- Select the three dots next to the section you want to export.
-
Choose Export Data.
-
Choose an export type in the pop-up window:
- Data with Current Layout: Only available for table and matrix visuals. This is a Microsoft Power BI default. None of the report outputs match this option now.
- Summarized Data: Exports the data as it shows on the report, as a high-level overview of totals.
- Underlying Data: Exports the data behind the totals on the report. This export is not possible now.
You can view the data in Excel, Pages, Google Sheets, and more.
Related Articles
- Gingr Business Analytics Topic Outline
- Revenue by Date Report Reference
- What Is the Charges Report? Reference
Comments
0 comments
Article is closed for comments.