Article Details
Summary
The Sales Receipt report shows sales and payment information for a day or short date range at a glance. An industry accounting professional helped build it, so the data is concise, easy to reconcile, and accountant-friendly.
The report summarizes sales, payments received, deposits collected, accounts receivable, and more. Give it to your accountant, or use it when you enter daily, weekly, or monthly sales data into your accounting platform.
Important: When you reconcile the Sales Receipt report against other reports, it shows the pre-discount total under the Credit column for the Revenue category.
Reporting and Location Access
Reports in Gingr use location-based reporting. Gingr calculates results from the locations you select, not all locations by default. Each report shows the type of location it uses, which decides 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.
Available locations are limited to the user's Allowed Locations. If a location does not show as an option, check the user's Allowed Locations before you run the report.
Where to Find It
Go to Left-hand Navigation: Reports & More » Reports » Sales Receipt.
Only users in a user group with the Can View Financial Reports permission can use this report.
Video Tutorial
Report Parameters
| Parameter | Description |
| Location | Select the location to pull data for. |
| From Date | Choose a start date for sales and payment data. |
| To Date | Choose an end date to complete the date range. You can run this report for up to 31 days (1 month) at a time. |
| View Data By | Choose to see the Sales Receipt day by day or as one total for the date range. |
Accounting Terms
| Term | Definition |
| Debit | An accounting entry that increases assets or decreases liabilities on a company's balance sheet. |
| Credit | An accounting entry that can decrease assets or increase liabilities and equity on the balance sheet, depending on the transaction. This report uses double-entry accounting, so every transaction has two entries: a credit and a debit. |
| Accounts Receivable (A/R) | The money customers owe a business after goods or services were delivered or used. |
| Asset | Anything, tangible or not, that can produce positive economic value for a business or person. |
| Liability | A company's duty to deliver goods or services later after it was paid in advance. This amount goes down (debited) when the product or service is delivered. |
What This Does
Revenue
Revenue is the gross amount of all invoiced sales of reservations, services, retail, and open line items. It is before discounts (coupons, package component discounts), package component credits consumed, sales tax, and tips. Gingr records revenue when the reservation or item is checked out through the shopping cart, even if the customer pays later.
Use Account Codes to split revenue into categories. You can assign codes to reservation types, services, packages, POS items, and open line items to see revenue by category or code. Account Code totals are already in the Gross Revenue total.
Reference: Account codes cannot be imported to QuickBooks Online through Gingr's integration.
Packages
Package Component Credits Purchased is the liability created when you sell a package. A package is bought as one bundled item, but Gingr records the liability per component, based on the component's price and quantity.
Package Component Credits Purchased are listed apart from Revenue. They are not in Gross Revenue or Account Code totals. This avoids double-counting the value of prepaid credits that are not yet redeemed.
The package purchase invoice shows in the Revenue and Account Code Invoices Detail section. Its dollar amount is only in the Package Component Credits Purchased line.
Package Component Credits Consumed are redeemed component credits. Using a component credit debits the prepaid packages liability account for that component. The pre-tax, pre-discount price of the invoiced line item counts toward Revenue and goes to the Account Code, if assigned.
Discounts
Discounts are coupons applied at checkout and package component credit discounts. Coupons count in the Discounts section on the day you apply the coupon at checkout.
Package Discounts are the difference between the Package Component Credits Consumed (package component price divided by the number of credits) and the price of the line item the credit was used for. For example, a $450 package component with 10 credits is worth $45 per credit. If a customer uses one credit on a $50 daycare reservation, the package discount is $5. Gingr shows this $5 in Discounts on the day the credit is redeemed.
To see a breakdown of coupons and package discounts:
- Select the Export to CSV option. Do not use the QBO Export option.
- Open the .zip file.
- Open the Discounts CSV file.
- Add up the dollar amounts to find total coupon discounts and package discounts. Coupons show by coupon title. Package discounts show as separate "Package Credits" lines for each type of package component redeemed.
Deposits
- Deposits Collected is a credit in the deposits liability account. The payment method used shows as a debit in the matching payment received line. Gingr pays out deposits made with Integrated Credit Card processing in the regular daily batch cycle. Gingr does not hold deposit payments until the reservation happens.
- Refunded Deposits is a debit to the deposits liability account. It shows in the "Refunded Deposits" line on the day you refund the deposit.
- Forfeited Deposits is a credit to the Revenue account. The invoice links to Invoices Opened with Payment Remaining as a debit to balance.
- Consumed Deposits balances with the revenue for checkouts where a deposit was applied. It debits the deposits liability account.
Store Credit
- Store Credit Purchased is added to owner profiles on the day an invoice with a Store Credit line item is checked out and paid in full. It credits the Store Credit liability account.
- Store Credit Consumed is a payment method applied to invoice balances. It balances with revenue for checkouts where store credit was used. It debits the Store Credit liability account.
Prepayments
- Prepayments Collected is a credit to the prepayment liability account on the date of the prepayment. A prepayment is any payment applied to an invoice before checkout through the shopping cart.
- Prepayments Consumed balances with the revenue for checkouts where prepayments were applied. It debits the prepayment liability account. Gingr consumes prepayments when the invoice is checked out through the shopping cart.
Payments
Customers pay at checkout in the shopping cart. Each payment method you set up under Left-hand Navigation: Admin » Payment Methods has a line for the amount received in the time period.
Each Payment Method Received line shows net payments. Gingr subtracts refunds from the net payment method totals. You cannot remove or hide payment methods when you run the report.
Payments Made to Open Invoices
This is the same as "Post Payments" on the Revenue by Dates report. It shows payments made toward invoices with an open balance after checkout. It offsets the money received for open invoices and credits the accounts receivable account.
The Payment Method Received line debits the accounts receivable account and balances Payments Made to Open Invoices on the day Gingr receives the payment.
The revenue for the first checkout of these invoices credits the accounts receivable Revenue account. It debits the Invoices Opened with Payment Remaining accounts receivable account on the day the invoice was checked out.
Invoices Opened with Payment Remaining
This shows checkouts where the customer did not pay in full at checkout. It debits the accounts receivable account.
Refunds
The "Refunds" line shows the total refunds issued in the report date range. It includes line item refunds and payment-only refunds. Gingr calculates it as the gross amount, before refunded tax. Gingr subtracts refunded tax from the Sales Tax net total. The report also shows refunds by Account Code. Refunds that involve package credits restore credits to the right component and reverse revenue.
Gingr subtracts refund amounts from the matching Payment Method Received.
Example: An invoice is checked out with a $100 credit card payment. The report shows $100 in the Revenue credit line and $100 in the Credit Card Received debit line. You refund $25 to the customer. The report then shows $25 in the Refunds debit line and $75 in the Credit Card Received debit line.
Related Articles
- Revenue by Date Report Reference
- How to Set Up Revenue Report Account Codes How-To
Comments
0 comments
Article is closed for comments.