Article Details
Summary
This article explains the Revenue by Date(s) report, which breaks down the charges and payments recorded in Gingr to help with your accounting. It is not a profit and loss statement.
What this does
Use the Revenue by Date(s) report to get financial information from Gingr. The report breaks down the charges and payments recorded in Gingr and summarizes them in several ways. It is not a profit and loss statement. It shows the invoice charge and payment information recorded in Gingr.
Reporting & Location Access
Reports in Gingr use location-based reporting. Results are calculated from the locations you select in the report. A report does not show data for all locations by default. Each report shows the type of location it uses, which sets how results are calculated.
Common location types include:
Booking Location: Where the reservation or appointment takes place
Invoice Location: Where revenue and financial activity are attributed
Spend Location: Where the pet parent's purchases and charges occurred
Package Purchase Location: Where a package or subscription was purchased
Subscription Location: Where the subscription is enrolled
Transaction Location: Where the payment was processed
Pet Parent Home Location: The pet parent's assigned home location
The user's Allowed Locations set which locations are available in a report. Users can only view and report on locations they are allowed to access. If a location does not appear as an option, check the user's Allowed Locations setting before you run the report.
Video
Getting Started
Access the Report
To open the Revenue by Date(s) report, you must belong to a user group that has permission to view financial reports. To set this permission:
Go to Left-hand Navigation: Reports and More » Groups.
Turn on the Can View Financial Reports permission for the user groups that need it.
Important: Only users in a user group with the Can Manage Group Permissions permission can change this permission.
Once the permission is on for your user group, go to Left-hand Navigation: Reports and More » Reports » Financial: Revenue by Date(s) to open the report.
Report Parameters
| Parameter | Description |
| From Date | Start Date and Time |
| To Date | End Date and Time |
| Locations | Filter between location(s) to view payment and transaction history |
| Payment Methods | Filter between payment method(s) to view payment and transaction history. |
The report shows any invoice that has at least one payment with the payment method(s) you choose.
-
The list of payment methods can differ between locations. Every Gingr app comes with these payment methods:
- 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 has the Payment Type Summary and the Invoices Charge Summary. Payments are money collected. Invoice Charges are the total revenue of services rendered.
Payment Type Summary
This section breaks down money collected and refunded within the date range of the report. It is broken down by payment types and deposits.
| Type | Definition |
| Total Payments | Sum of all payments received within the date range. |
| Collected Deposits | Deposits collected within the date range. |
| Prepayments | Payments collected 10+ minutes from the time of check-out. |
| Payments | Payments collected at the time of check-out. |
| Post Payments | Payments collected on or after the next calendar date after the invoice has been opened. |
| Total Refunds | Sum of all refunds performed during the date range. |
| Refunded Payments | Total refunds of payments within the date range. |
| Deposit Refunds | Total refunded deposits performed within the date range. |
| Net Total | The net total of payments received within the date range. Calculated as Total Payments minus Refunds. |
Invoice Charges Summary
This section breaks down the total revenue of services rendered on invoices that were checked out within the date range of the report. It is broken down by Taxable and Exempt Charges, Tax, Tips, and Refunds processed on invoices.
| Type | Definition |
| Subtotal Charges | Total charges of all invoices opened within the date range. |
| Taxable Charges | Total pre-tax value of all taxable charges on invoices opened within this date range. |
| Exempt Charges | Total of all exempt (non-taxable) charges on invoices opened within this date range. |
| Tax Charged | Tax charged on invoices within this date range. Calculated by charges of taxable items and the location's tax rate. |
| Surcharge | Total surcharges collected within the date range |
| Tips | Total tips added to invoices within the date range. |
| Refunded Items | Total pre-tax line item refunds performed during the date range. |
| Refunded Tax | Total tax refunded during this date range. |
| Totals | Net total of charges on invoices opened within the date range. This is calculated as the Subtotal plus Tax and Tips charged. |
Subtotal Charges: This value does not include tax. It should equal the Charges by Account Code Total minus Tips.
Tax Charged: For more about sales tax, see the Sales Tax Report.
Tips: Tips can be added as open line items or during credit card transactions.
Charges
This section breaks Invoice Charges into more detail. It includes the pre-tax charges for line items on invoices opened in Gingr during the date range of the report. You can view charges by Account Code or by Revenue Type.
Charges by Account Code
Account codes are created and defined for each Gingr instance. Account codes let you group revenue into categories. For more about setting up account codes, see Set Up Revenue Report Account Codes.
The totals show the total revenue of services rendered within each category. Charges per account code reflect any package component credits redeemed, coupons, or pricing rules applied to the line items on the invoices.
No Account Code Set shows any line item that is not assigned to an account code. It also shows any Store Credit purchased. When store credit is redeemed, the charges show under the line item's own account code.
Coupons by Account Code
This section shows coupon use for each account code. The Charges by Account Code section already includes these amounts. You do not need to calculate them separately.
Refunds by Account Code
This section shows 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 components, open line item, and store credit from invoices opened during the date range. Each type shows a breakdown of coupons, rate modifiers, and package component credits redeemed toward those items. These are already included in the type's total revenue.
| Type | Definition | Drilldown |
| Charges by Reservation Type | Total charges by reservation type line item. Coupons and package component credits are already factored into the total revenue. |
|
| Charges by Service Type | Total charges by service type line item. Coupons and package component credits are already factored into the total revenue. |
|
| Charges by Retail Items | Total Charges by retail item. Coupons are already factored into the total revenue. |
|
| Charges by Package Type (packages sold) | Total charges by package type of packages sold during the date range. Multi-Component Packages show a total price of the package, not individual component prices. Coupons are already factored into the total revenue. Only credit redemption appears at the component level. |
|
| Charges by Membership Type (Memberships Sold or Renewed) | The total amount of memberships sold or memberships that renewed during the date range. Memberships are already factored into the total revenue. | |
| Charges by Open Line Item | Total charges by open line item type. Coupons are already factored into the total revenue. |
|
| Store Credit Purchased | The total amount of store credit purchased. This includes an overpaid pre-payment that has been converted to store credit. | |
| Cancellation Fees by Invoice | The total amount of cancellation fees add to a customer's account from the Cancellation by Date Range report. | |
| Forfeited Deposits |
The total amount of deposits forfeited by reservation type. The revenue for forfeited deposits is represented in the reservation types assigned account code. |
Refunds by Item
This section shows 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 date or date range you select. It breaks them 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 date or date range you select. It breaks them down by payment type, payment method, and deposits.
Payments by Payment Type or Payment Method
This section breaks down all payments within the date range by payment method and payment type. To view the payments by payment method, select 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
This section includes all refunds made within the date range, organized by payment type and payment method. It includes tax. These refunds are included in the Payment Type Summary above.
Deposits
This section includes collected, consumed, and forfeited deposits.
Collected Deposits
This section shows 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
These are paid deposits that were used as a payment toward an invoice in the date range. This means the reservation the deposit belongs to was checked out.
Tip: The total in this section is included in the Payment Type Summary total for Payments.
Forfeited Deposits
This section shows 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 keeps without rendering any services.
Forfeiting a deposit creates a separate closed invoice with the line item Forfeited Deposit: ID ##. This makes the payment show as consumed on financial reports.
Refunded Deposits
This section shows deposit refunds performed during the date range, broken down by reservation type.
Card Brand Breakdown
If your application uses Gingr's integrated credit card processor CardConnect, this section breaks down credit card payments by card type.
Payments and Refund Details
Payment Events by Invoice
This section breaks down all payments made during the date or date range by invoice ID.
Refund Events by Invoice
This section breaks down all processed during the date or date range by invoice ID.
Charges Full Results
This section lists all invoices that were opened during the date or date range. It includes the subtotal, sales tax, tip amount, and overall invoice total for each invoice.
Payments Full Results
This section lists all payments made during the date or date range. It is split by payment type (Payments, Pre-Payments, Post-Payments, Collected Deposits). Each section shows the invoice opened date, payment date, payment method, and total amount paid with that method.
Invoices with multiple payment types or methods are listed for each payment method and type.
Where to find it
Go to Left-hand Navigation: Reports and More » Reports » Financial: Revenue by Date(s).
Comments
0 comments
Article is closed for comments.