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 |