Introduction

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.

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 see Gingr Business Analytics.

Key Features

• 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.

Getting Started

Once you have a Gingr Business Analytics account associated with your subdomain(s), you can log in credentials here: analytics.gingrapp.com.

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

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

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.

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.

Tip:  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.

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.

Net Total Summary

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

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.

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. 

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. 

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.

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 a Table". Alternatively, right clicking on any graph will also make the "Show as a table" option available.

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

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".

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.

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

Related Resources

• Gingr Business Analytics Topic Outline
• Revenue by Date Report Reference