Financial Management

The Financial Management report is a Sales report that gives many of the same values as the Daily Sales report, but it can be run for a full week to provide weekly totals

The Financial Management has no filtering options. This report can only be generated for one site at a time, and for a maximum of one week

This report can be exported to CSV, Excel and PDF

HQ Reports

On TRAY HQ, select the REPORTS tab across the top menu. From there select the Reporting Category Selector and from the Sales reports select the Financial Management report

The Financial Management report has no filtering options

The Financial management report is broken into the following sections:

Financials - Broken into 2 subsections: gross receipts & gross sales. This section will show a summary of specific financial points for the week

Cash Deposits - Shows cash deposits on a given day, with total cash deposits. This section also displays the expected cash (Equivalent to the Cash Due on the Daily Sales report). Considering the total cash deposits with the expected cash, the report calculates the Cash Over/Short amount

Craft Labor - Shows a summary of labor hours & wages for each active POS role

Categories - Main category net sales are calculated in this section. Any category that does not have a main category will be grouped in the NA row

Discounts - Main discounts are calculated in this section. Any discount that does not have a main discount will be grouped in the NA row

Tenders - Totals for each tender type broken out 

Guest Experience - Average expenditures for guests, checks, and destinations/tables

FINANCIALS

FIELD	DESCRIPTION
GROSS RECEIPTS	This value correlates to the Gross Receipts value in the Daily Sales report (Net sales + tax + any voids, discount, comps and service charges)
DISCOUNTS	The total discounted amount for all sales
COMPS	The total amount of sales comped
VOIDS	The total amount of sales voided
SERVICE CHARGES	This service charges line takes into account charged tips, gift card issuances, and any products flagged as a "service charge"
DONATIONS	Any product flagged as a "donation"
CREDIT TOTALS	Total amount of taxes that applied to voids/comps/refunds
SUB TOTAL	Discounts + comps + voids + service charges + donations + credit totals
GROSS SALES	Gross receipts - the above subtotal (this is equivalent to the net sales + tax collected)
TAX	Total tax collected
NET SALES	Total sales minus any discounts, comps, refunds, donations, fees, etc.
CARRIED OVER	The number of checks that were still open, as well as the sum of the unpaid balance that was carried over from the prior trading day. This number will match the "Outstanding" amount for the prior trading day.  This number is the sum of Start of Day System Tenders applied to checks with a non-zero balance.
OUTSTANDING	The number of checks that were still open, as well as the unpaid balance that was outstanding at the end of the current trading day. This number will match the "Carried Over" amount for the following trading day. This number is the sum of End of Day System Tenders applied to checks with a non-zero balance.
SERVICE CHARGES	This service charges line takes into account charged tips, gift cards issuances,and any products flagged as a "service charge" or "donation"
ADJUSTED GROSS SALES	Net sales + tax + carried over - outstanding + service charges. This number is used to compare to the Total Tenders value in order to calculate an out of balance
TIPS PAID	The total amount of charged tips that were paid to staff
PAIDINS - PAYOUTS	The total value of any paid ins/paid out "no sales"
GIFT CARD CASH OUT	The total value of any gift cards that were redeemed to cash
TOTAL RECEIPTS	The actual revenue taken in at the end of the day after paying out tips. (Adjusted gross sales - tips paid - paid ins/outs - gift cards cashed out)

CASH DEPOSITS

FIELD	DESCRIPTION
CASH DEPOSITS	This section lists each cash deposit and its amount
TOTAL CASH DEPOSITS	The total of all listed cash deposits
EXPECTED CASH	This is representative of the "Cash Due" value in the Daily Sales report
CASH OVER/SHORT	This number compares the total cash deposits to the expected cash number

CRAFT LABOR

FIELD	DESCRIPTION
ROLE HRS	Total hours worked for each active POS role
ROLE $	Total wages earned for each active POS role
TOTAL CRAFT HRS	Total hours worked for all active POS roles
TOTAL CRAFT $	Total wages earned for each active POS role
TRAINING TOTAL	Training mode totals
GIFT CARD SOLD	Gift Cards Issued
TIPS DUE	This field is not used

CATEGORIES

FIELD	DESCRIPTION
MAIN CATEGORY	Each main categories net sales. For information on how to configure a main category, see the article for adding categories
NA	Net sales for any category not assigned to a main category w
SUB TOTAL	The total net sales for all categories

DISCOUNTS

FIELD	DESCRIPTION
MAIN DISCOUNTS	Each main discounts total discounted amount would display here. For information on how to configure a main discount, see the article for discounts
NA	Total discounted amount for any discounts not in a main category

TENDERS

FIELD	DESCRIPTION
CASH	Total cash payments
PAID IN	Total for all paid ins
PAID OUT	Total for all paid outs
TOTAL CASH DEPOSITS	Cash payments + paid in - paid out
CREDIT CARD BRAND	Total payments for each CC brand, as well as any CC payments taken through the OLO website
TOTAL CREDIT CARD TENDERS	Total payments for all CC tenders
CUSTOM TENDERS	Total payments for each custom tender type as well as any tenders from delivery service providers
TOTAL CUSTOM TENDERS	Total payments for all custom tender type
GIFT CARD REDEEMED	Total in store gift card redemptions
OLO GIFT CARDS REDEEMED	Total OLO gift card redemptions
TOTAL TENDERS	Total payments received (should match adjusted gross sales)
GC VALUE ADD	Total gift card amount that was added to existing cards
GC VALUE CASH OUT	Total gift cards redeemed to cash
DONATIONS	Total sales of any products flagged as a "discount"
OTHER SERVICE CHARGE	Total sales of any products flagged as a "service charge"
CREDIT CARD TIPS	Credit card tips
OTHER TIPS	Tips accepted for any custom tenders
CASH TIPS	Cash tips are typically not tracked through the POS on a transactional basis. This field will typically be 0
GIFT CARD TIPS	Gift card tips
TOTAL TIPS	Total tips received

GUEST EXPERIENCE

FIELD	DESCRIPTION
GUEST COUNT	Total number of guests for the day
AVG. GUEST EXP	Average amount spent per guest
CHCKS COUNT	Total number of checks for the day
AVG. CHECKS EXP	Average amount spent per check
TABLES COUNT	Total number of checks at a table
AVG. TABLES EXP	Average amount spent per table