Gingr Business Analytics: Financial » Payments Collected Summary

Madeleine L.
Madeleine L.
  • Updated

Overview: What are we talking about?

Gingr Business Analytics is a paid reporting tool that offers combined financial and reservation data for multiple Gingr subdomains.

The Payments Collected Summary gives a high-level overview of payments (prepayments, payments, postpayments, deposits, refunds, and refunded deposits) recorded in Gingr. This report can be run for given date ranges, specific days of the week, and for any combination of locations in various subdomains.

This article includes:

Helpful Hints: Before you begin

  • Gingr Business Analytics is a paid reporting tool best designed for facilities with multiple subdomains that need to view combined booking and financial data across Gingr URLs. For more information about how to sign up for Gingr Business Analytics, please read our article here Gingr Business Analytics Overview.
  • Gingr Business Analytics » Financial » Payments Collected Summary displays an overview of all payment data for the user's selected subdomains. This includes Prepayments, Payments, Postpayments, Deposits, and Refunds. 
  • The data refreshes every day at midnight to add the previous day's information.
  • The data can be limited by subdomain(s), location(s), date range, and/or day of week, and each section of the report can be exported to Excel or .CSV.
  • You can hover over to see the tooltip for each graph, or click on each section to update the graphs. Clicking on it again will reset it. You can right-click on any graph to show the data as a table.

How to: Access Gingr Business Analytics » Payments Collected Summary

For more information about how to sign up for Gingr Business Analytics, please read our article {{link}}. Once you have an account associated with your subdomain(s), you can log into Gingr Business Analytics using your login credentials here: analytics.gingrapp.com.

To access the Payments Collected Summary, navigate to Reporting » Financial » Payments Collected Summary. You can either click "Payments Collected Summary" in the Left-hand Navigation menu or under the "Payments" section » "Go to Report".

Screenshot 2024-05-30 at 10.29.30 AM.png

From this page, you can adjust the reporting parameters to tailor the report to your needs.

How to: Set Report Parameters

The Payments Collected Summary will automatically default to all subdomains you have access to, all days of the week, and last 30 days. The report output can be adjusted by clicking the parameters in the box on the top right corner of the screen.

Screenshot 2024-05-30 at 12.55.32 PM.png

Report Parameters

Setting Description
Subdomain/Location(s) Combine or exclude data for subdomains and/or specific locations at each subdomain. Optionally click the arrow next to each subdomain to select/unselect specific locations at that subdomain.
Day of Week Choose day(s) of week to view data for (i.e. all Mondays in given date range).
Date Range Click "Last 30 Days" to view all options for Quick Selection (i.e. "Last 7 days", "Year to date", etc), or click the date range displayed to enter a custom date range.

Screenshot 2024-05-30 at 12.57.58 PM.png

How to: Report Output

The Payments Collected Summary report contains five sets of data: Payments, Refunds, Totals, Net Total Over Time, and Net Total Breakdown. These correspond to the Payments Summary section at the top of the Revenue by Date Report, and give an overview of payments on invoices collected in Gingr during the given date range.

In Gingr, "payments" are considered the sum of all money received and/or refunded via any payment method during the given date range. If a customer did not pay on that specific day or date range you run the report for, even if they had an invoice checked out, then no data will show on the report as a payment. This data includes payments and refunds made for all payment methods. Payment data does not account for tax, tips, or individual items such as reservation types or services, because these are considered "charges" in Gingr. Instead, "payments" simply refer to money paid or refunded on an invoice.

Important note: You can right click on any section of the report to view the data as a table, rather than a graph. 

Payments Summary

This section gives a quick overview of payment data for the given date range. It specifically includes Collected Deposits, Pre-Payments, Payments, and Post-Payments.

This section corresponds to the Payments Summary section at the top of the Revenue by Date Report.

Screenshot 2024-04-10 at 5.31.12 PM2.png

Refunds Summary

This section gives a quick overview of Refund data for the given date range. It specifically includes Refunded Payments (including line-item refunds and payment-only refunds) and Refunded Deposits.

This section corresponds to the Payments Summary section at the top of the Revenue by Date Report.

Screenshot 2024-05-30 at 12.55.32 PM 2.png

Net Total Summary

This section is the net total of the Payments Summary minus the Refunds Summary.

This section corresponds to the Payments Summary section at the top of the Revenue by Date Report.

Screenshot 2024-05-30 at 12.55.32 PM 3.png

Net Total Over Time

This section displays a total per each day if the selected date range is 30 days or less. It displays the total per each month if the selected date range is greater than 30 days. It displays the total per each year if the selected date range if the range is greater than a year and a half.

This section corresponds to the Payments Summary section at the top of the Revenue by Date Report.

Screenshot 2024-05-30 at 12.55.32 PM 4.png

Invoices Totals Breakdown

This section gives a more detailed overview of Payments. It specifically includes Collected Deposits, Pre-payments, Payments, Post-payments, Refunded Payments, and Refunded Deposits. Each sub-section can be expanded to view the full breakdown of items contributing to the totals by clicking the "+" sign next to the title of the sub-section. 

This section corresponds to the Payments Summary section at the top of the Revenue by Date Report.

Screenshot 2024-05-30 at 12.55.32 PM 5.png

How to: Drill Down Data

Each section of the report contains options to further drill-down the data displayed via charts and graphs. 

In the "Net Total Over Time" section, you can hover over each data point to view a more detailed breakdown. Depending on the length of the selected date range, this may display by day, month, or year. 

Screenshot 2024-05-30 at 12.59.13 PM.png

You can also click any date in the "Net Total Over Time" section and it will update the "Payments", "Refunds", "Net Total", and "Net Total Breakdown" sections accordingly to display data breakdowns just for that date or date range. You can click the date again to remove the spotlight.

Screenshot 2024-05-30 at 1.04.30 PM.png

Additionally, each section also has an option to view the data in table format. To access this, click the three dots showing next to the section and choose "Show as Table". Alternatively, right clicking on any graph will also make the "Show as a table" option available.

Screenshot 2024-05-30 at 12.59.48 PM.png

This will display the data in an easy-to-read table on a new page.

Screenshot 2024-05-30 at 1.06.12 PM 2.png

How to: Export the Report

Each section of the report can be exported to Excel or .CSV. To export the data, first, generate the report using your desired parameters. Then click the three dots showing next to the section you would like to export and choose "Export Data". 

Screenshot 2024-05-30 at 1.07.15 PM.png

You will then see a popup asking which type of export you would like:

  • Data with Current Layout: This option is only available for table and matrix visuals, and is a default option shown by Microsoft BI. At this time, none of the report outputs match this parameter.
  • Summarized Data: This option exports the data as it is shown on the report, as a high-level overview of totals. 
  • Underlying Data: This option exports the underlying data that contribute to the totals displayed on the report. At this time, this export is not possible.

Screenshot 2024-04-10 at 5.27.13 PM.png

Data can then be viewed in Excel, Pages, Google Sheets, etc.

Screenshot 2024-04-10 at 5.27.25 PM.png

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.