Introduction

This article will cover how to use the Revenue by Date(s) report to extract financial information from Gingr. The Revenue by Date(s) report breaks down the charges and payments recorded in Gingr and summarizes it in a number of different ways to aid you in your accounting. This report is not a profit and loss statement, but instead a display of the invoice charge and payment information recorded in Gingr.

Video Tour

Getting Started

Access the Report

In order to access the Revenue by Date(s) Report in Gingr, you must belong to a user group that has the permission to view financial reports. To configure this permission, follow these steps:

1. Navigate to Left-hand Navigation: Reports and More » Groups.
   
   
2. Enable the Can View Financial Reports permission for applicable user groups.

Important:  Only users that belong to a user group that possesses the Can Manage Group Permissions permission are able to adjust this permission.

Once the permission has been enabled for your user group, the Revenue by Date(s) Report can be accessed from Left-hand Navigation: Reports and More » Reports » Financial: Revenue by Date(s).

Report Parameters

• The report will report any invoice that has at least associated payment with the chosen payment method(s).
  
  

• The list of payment method(s) may vary between locations. The following payment methods are delivered with every Gingr app

  • Credit Card

  • Cash

  • Check

  • No Payment (places balance on owner’s accounts)

  • Admin-Credit Comped (used for waiving fees)

  • Store Credit

Revenue Summary

The Revenue Summary contains the Payment Type Summary and Invoices Charge Summary. Payments represent money collected and Invoice Charges represent total revenue of services rendered.

Payment Type Summary

This section includes a breakdown of money collected and refunded within the date range of the report, broken down by Payment types and Deposits.

Invoice Charges Summary

This section includes a breakdown of total revenue services rendered on invoices that were checked out within the date range of the report, broken down by Taxable and Exempt Charges, Tax, Tips, and Refunds processed on invoices.

• Subtotal Charges - This value does not include Tax. This value should equal the Charges by Account Code Total - Tips.
  
  
• Tax Charged - For more information on sales tax, please see our article on the Sales Tax Report.
  
  
• Tips - Tips can be added as open line items or during credit card transactions.

Charges

This section breaks out Invoice Charges into further detail, including the pre-tax charges for line items on invoices opened in Gingr during the date range of the report. Charges can either be viewed by Account Code or by Revenue Type.

Charges by Account Code

Account codes are created and defined for each Gingr instance. Account codes allow you to group revenue into categories. For more information on setting up account codes, please see our article on Set Up Revenue Report Account Codes.

The totals represent the total revenue of services rendered within each category. Charges per account code reflect any package credits redeemed, coupons, or pricing rules applied to the line items on the invoices.

No Account Code Set represents any line item that is not assigned to an account code or any Store Credit purchased. When store credit is redeemed the charges will be reflected under the line items respective account code.

Coupons by Account Code

This section provides detail of coupon usage per account code. The amounts in this section are already factored into the Charges by Account Code section and do not need to be calculated separately.

Refunds by Account Code

This section provides information on refunded items by Account Code

Tip:  The total in this section should match the Invoice Charges Summary total for Refunded Items.

Charges by Type

This section breaks down the pre-tax charges by reservation type, service, retail, package, open line item, and store credit from invoices opened during the date range. Each type displays a breakdown of coupons, rate modifiers, and package credits redeemed towards those items that have already been factored into the Type's total revenue.

Refunds by Item

This section provides total pre-tax refunds to line items that were performed during the date range.

Tip:  The total in this section should match the Invoice Charges Summary total for Refunded Items.

Payments and Refunds

The Payments and Refunds by Type section breaks down all payments and refunds processed during the selected date/date range. Payments and refunds are broken down by payment type, payment method, and deposits. The Payment and Refund Details section breaks down payment events by invoice.

Payments and Refunds by Type

This section breaks down all payments and refunds processed during the selected date/date range. Payments and refunds are broken down by payment type, payment method, and deposits.

Payments by Payment Type or Payment Method

This section is intended to provide a breakdown of all payments within the date range organized by the payment method and payment type. To view the payments by payment method click the View by Payment Method button.

Tip:  The total in this section should match the Payment Type Summary total for Total Payments.

Refunds by Payment Method/Payment Type

Includes all refunds made within the date range, organized by payment type/payment method. Includes tax. Included in the Payment Type Summary above.

Deposits

Includes collected, consumed, and forfeited deposits.

Collected Deposits

This section provides information for deposits that were paid during the date range, broken down by reservation type.

Tip:  The total in this section should match the Payment Type Summary total for Collected Deposits.

Consumed Deposits

Paid deposits that have been consumed as a payment towards an invoice in the date range. This indicates that the reservation the deposit is associated with was checked out.

Tip:  The total in this section is included in the Payment Type Summary total for Payments.

Forfeited Deposits

This section provides information for deposits that were forfeited during the date range, broken down by reservation type. A forfeited deposit is a paid deposit that will not be refunded to the customer or consumed with the pet's reservation. This is revenue the facility is keeping without rendering any services.

Forfeiting a deposit creates a separate closed invoice with the line item Forfeited Deposit: ID ##. This is so the payment shows as consumed on financial reports.

Refunded Deposits

This section provides information about deposit refunds performed during the date range, broken down by reservation type.

Card Brand Breakdown

If your application utilizes Gingr's integrated credit card processing, this section provides a breakdown down of credit card payments by card type!

Payments and Refund Details

Payment Events by Invoice

This section breaks down all payments made during the date/date range by the invoice ID.

Refund Events by Invoice

This section breaks down all processed during the date/date range by the invoice ID.

Charges Full Results

This section provides a full list of invoices that were opened during the date/date range. This includes the subtotal, sales tax, tip amount, and overall invoice total for each invoice.

Payments Full Results

This section provides the full list of payments made during the date/date range. It is segmented by payment type (Payments, Pre-Payments, Post-Payments, Collected Deposits). Each section reports on the invoice opened date, payment date, payment method, and total amount paid with that method.

Invoices with multiple payment types/methods will be listed for each payment method/type.

Related Resources

• Sales Tax Report Reference
• Set Up Revenue Report Account Codes How-To