What is the P&L Report?
This report is designed to transparently show how your Point of Sale (POS) sales are converted into deposits in your bank account. It breaks down the financial journey from the initial sale to the final deposit, detailing the additions and deductions that affect the final amount deposited by the Ordering Platform. This report has two parts:
-
Graphical Version: This visual representation displays your financials as bar graphs showing increases, decreases, and subtotals for different categories over your selected date range. It helps you quickly identify trends and financial changes.
-
Tabular Version: This detailed list format accompanies the graphical display. It provides specific data entries such as brand, location, and POS transaction figures, broken down by ordering platform. This version is essential for a detailed review and reconciliation of each recorded transaction against bank deposits.
Using graphical and tabular reports, you can understand your financials comprehensively, helping you make informed decisions about your business operations.
Note: This custom Reconciled Plus report may not be visible to all users.
How to Generate the Report
To learn how to create Reconcile Reports that offer relevant data for your needs, please refer to the guide on how to use Reconcile reports here. This page will guide you through generating the report and filtering for additional details.
P&L Report - Terminology
| Column Name | Column Definition |
|---|---|
| BRAND | The brand name that owns the restaurant. |
| LOCATION | Name of the store or restaurant. |
| STORE_ID | Store ID of the restaurant. |
| ORDERING_PLATFORM | Third-party online ordering platform. |
| POS_GROSS_SALES | The sum of the Subtotal and Tax of all the transactions sent to the POS. |
| THIRD_PARTY_ UNPAID_POS_ GROSS_SALES |
The sum of the Subtotal and Tax for all the transactions sent to the POS but not yet paid by the Third Party. |
| THIRD_PARTY_ PAID_POS_GROSS _SALES |
The sum of Subtotal and Tax for all the transactions sent to the POS and paid by the Third Party. |
| POS_TO_STATEMENT _PRICE_DISCREPANCY |
Any discrepancy in the Subtotal or Tax between the Statement and POS prices is recorded here. |
| ORDERS_IN_POS _NOT_IN_3P |
These are the Subtotals and Taxes from transactions that were sent to the POS but have not yet been added/updated by the third parties in their transaction statements. |
| POS_VARIANCE | The POS Variance is the amount that has not been accounted for in the transaction statements from the third parties. POS Variance = Third-Party Unpaid POS Gross Sales + POS to Statement Price Discrepancy + Orders in POS (not from Third-party ordering platforms) |
| ALLOWABLE_ DEDUCTIONS_FROM _POS_SALES |
These are deductions that can be taken out from the POS Sales. It considers the refunds and canceled transactions that do not add to the revenue and the refunds that were won back after disputes. Allowable deductions from POS sales = Disputes Won - Refunds - Subtotal Cancelled not paid - Tax Cancelled not paid |
| THIRD_PARTY _GROSS_SALES |
The sum of all the Subtotal and taxes from the sales in the third-party transactions statement. |
| ORDERS_IN_3P _NOT_IN_POS |
These transactions are present in the third-party statements but not in the POS. Typically, they include Ad Fees or any new transaction type we have not accounted for earlier. |
| THIRD_PARTY_GROSS _SALES_IN_POS |
The sum of all Sales from the third-party statements was successfully sent to the POS. |
| ADJUSTMENTS_TO_TAX | This column accounts for any changes in the tax amount related to transactions mentioned in the third-party statements. |
| REFUNDS | Total amount lost in refunds. |
| ADJUSTMENTS | Any adjustments the third parties make against orders and error charges are accounted under this column. |
| CANCELLATIONS | This column accounts for canceled (paid) and canceled (not paid) orders. Cancellations = Subtotal Cancelled Paid + Tax Cancelled Paid + Subtotal Cancelled Not Paid + Tax Cancelled Not Paid |
| SALES_NET_OF_ REFUNDS_ADJUSTMENTS _CANCELLATIONS |
This amount is the sales without refunds, adjustments, and cancellations. Net Sales = Third-Party Gross Sales + Adjustments to tax + Refunds + Adjustments + Cancellations |
| TAX_WITHHELD | Sales tax an ordering platform withheld to pay in jurisdictions with marketplace facilitator laws of the state. |
| OTHER_INCOME_ TO_RESTAURANT |
Any other income the restaurant makes from the transaction. For example, bag fees. |
| COMMISSIONS_AND_FEES | The sum of all fees and commissions. This includes delivery fees, processing fees, and ordering platform commissions. |
| PROMOTIONS | The total marketing credit spent on discounts and promotions. |
| PAYOUT_CALCULATED | The money expected to be deposited into the account of a restaurant post the commissions, taxes, and other deductions. Payout Calculated = Sales net of Refunds, Adjustments and Cancellations + Tax Withheld + Other Income to Restaurant + Commissions and Fees + Promotions |
| PAYOUT_FROM_3P | The amount the third party listed in its statements as payout made to the restaurant for a given date range. |
| DRIVE_CHARGES | The amount charged by Doordash for its Drive service. |
| FINAL_PAYOUT | The expected payout to be received after subtracting Drive Charges from the Payout from 3P (Third Party). Final Payout = Payout from third-party ordering platforms - Drive Charges |
| DISPUTES_WON | The amount won back by disputing refunded orders. |
Check out Types of Reconcile Reports to see other reports you can generate.
Comments
0 comments
Please sign in to leave a comment.