Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Use Toast POS Product Mix reports for item-level sales data and the Items Database for full menu hierarchies with prices and costs.
- Set up automated nightly SFTP exports to remove manual downloads, with files ready within one hour after closeout.
- Confirm permissions (4.1 Sales Reports, 4.2 Menu Reports, 8.3 Data Export Config) and use Chrome to avoid missing export buttons or blank pages.
- Combine sales and menu exports for real-time profitability analysis so you can spot margin erosion, low-margin volume items, and pricing opportunities.
- Transform raw CSV exports into live GP dashboards with Jelly. Book a demo today to achieve measurable margin improvements.
Why Toast POS Exports Matter for UK Restaurant Profit
Delayed data damages UK restaurant profitability. Without timely item-level sales and menu information, you miss price alerts, lose supplier leverage, and watch GP margins slip week after week. Each day without reliable exports increases the risk of unnoticed price rises, weak menu performers, and missed chances to refine your offer.
Correct permissions form the starting point for every export workflow. Toast’s Permissions Reference Guide sets specific access levels for each export function: 4.1 Sales Reports for sales data, 4.2 Menu Reports for product mix analysis, 4.5 Edit Full Menu for bulk menu exports, and 8.3 Data Export Config for automated SFTP setup. You also need Toast Web credentials and the Chrome browser for reliable performance.
Strong export habits unlock far more than simple reports. Accurate sales and menu data supports real-time margin tracking, evidence-based supplier negotiations, and menu decisions based on profit instead of instinct. This foundation supports advanced analysis and automation that can reshape your restaurant’s financial results.
Exporting Item-Level Sales from Toast POS Product Mix
Sales exports start with the right report and a clear view of which fields support margin analysis. The Product Mix (PMIX) report gives UK restaurants the most complete item-level sales breakdown.
1. Log into Toast Web and go to Reports > Menus > Product mix.
2. Select “Try the new version” at the top to access updated features.
3. Set your date range using the dropdown. Custom ranges up to one year are supported.
4. Configure filters such as item tags, sales categories, employee, and order source.
5. Choose your menu hierarchy level from the dropdown. Select items, menus, or modifiers.
6. Click the Columns button and include Qty sold, Net sales, COGS, and Gross profit if available.
7. Click the Export button, the download icon at the top, to download as CSV or Excel.
Toast’s PMIX report provides detailed sales breakdowns by menu hierarchy and supports deep customisation for UK restaurant analysis. The exported CSV includes critical profitability fields such as Item name, Quantity sold, Gross sales, Discount amount, Net sales, and, when configured correctly, COGS and gross margin data. The table below shows which fields come from sales exports versus menu exports and how each supports profitability analysis.
| CSV Field | Sales Export | Menu Export | Use in Profitability |
|---|---|---|---|
| Item Name | ✓ | ✓ | Menu item identification |
| Quantity Sold | ✓ | – | Volume analysis |
| Net Sales | ✓ | – | Revenue calculation |
| Item Price | – | ✓ | Pricing strategy |
Exporting a Full Toast Menu with the Items Database
Bulk menu exports give you the structure needed for cost analysis and menu engineering. Toast’s Items Database supports bulk export of complete menu hierarchies including menus, groups, items, modifiers, and pricing structures.
1. In Toast Web, go to Menus > Bulk management > Items database.
2. Use the Show/hide columns button to choose which data fields appear.
3. For multi-location venues, click Edit and select the locations you want to include.
4. Apply search filters if you want to target specific menu elements.
5. Click the download icon, the down arrow in the top right corner.
6. Toast generates a comprehensive spreadsheet with your menu data.
The exported menu database includes key cost fields such as Item name, Current price, Cost if entered, Category, Reporting tags, and modifier relationships. This hierarchical structure supports detailed menu analysis and forms the backbone for Jelly’s automated dish costing system.
Multi-location restaurant groups gain a clear view of consolidated menu data across sites. This view highlights pricing inconsistencies and standardisation opportunities. The bulk export also supports versioning for multi-location management, which allows centralised menu control while keeping site-specific customisations.
Automating Nightly Toast SFTP Sales and Menu Exports
Manual exports work for occasional checks but break down as your restaurant group grows or needs daily margin tracking. Toast’s automated nightly SFTP exports create comprehensive data files within one hour after your configured closeout time, usually 4:00 AM local time.
1. Contact Toast Customer Care and request data export access for your group.
2. Generate SSH keys using the ssh-keygen command on Mac or Linux, or PuTTY on Windows.
3. In Toast Web, go to Reports > Settings > SSH Keys.
4. Add your public SSH key using “Add New Key”.
5. Configure export types under Reports > Settings > Data Exports. This step requires 8.3 permission.
6. Select data types such as Order Details, Product Mix, and Menu configuration.
7. Connect via SFTP using Cyberduck, Terminal, or another client.
8. Access nightly files stored in numbered folders for each location.
Automated exports include Sales and Finance data such as Order Details and Product Mix, plus Configuration data such as Menu. You can customise column selection and ordering. Files stay available for seven days before cycling, and multi-location groups receive consolidated access with folders per site. This setup removes manual export work and keeps data consistently available for analysis tools.
Turning Toast Exports into Profit with Jelly
Raw CSV exports only become valuable when you convert them into clear margin insights. UK restaurants using Jelly turn POS data into actionable profitability views within minutes instead of hours of spreadsheet work. When you connect Jelly to your POS, you unlock automated invoice scanning, live GP tracking, and instant price alerts that protect your margins.
Jelly’s process stays simple from the user’s perspective. You scan your invoices via photo or email, and the platform automatically matches them with POS sales data to provide real-time dish costing. This automation removes the manual cross-referencing of invoices and sales, which is why work that previously required 28 minutes of calculation per menu item now takes about 3 minutes with automated unit conversions and cost updates.
Amber, a Mediterranean restaurant in East London, saves £3,000 to £4,000 each month using Jelly’s automated insights from POS integration. The blend of POS data and Jelly’s invoice automation delivers live margin visibility. This visibility supports faster reactions to supplier price changes and more confident menu decisions. Features include Flash Reports for daily GP tracking, Price Alerts for supplier negotiations, and Menu Engineering analysis that combines POS sales data with live cost information.
Time savings also add up quickly. UK restaurants often spend 10 to 20 hours each week on manual data entry and margin analysis. Jelly’s automation cuts this work to minutes while improving accuracy and supporting proactive margin management. Schedule a chat to see how your POS exports can drive 2 to 3 percent margin improvements within the first quarter.
Fixing Common Toast Export Problems
UK Toast users often face recurring export issues that slow down data access. Knowing these problems and their fixes saves hours and keeps your reporting consistent.
Missing export buttons usually point to permission issues. Toast requires specific permissions for different export functions, and users without the necessary access will not see export options. Check your permissions with restaurant administrators and confirm you are logged into the correct account.
Blank pages during export attempts usually come from browser compatibility problems. Toast recommends Google Chrome for reliable export performance, as Safari and some other browsers can cause display issues. Clear your browser cache and cookies if exports fail to load.
Data retention rules limit how far back you can export. Toast keeps sales data for 15 months in standard reports, and older data requires a request to Customer Care. SFTP exports store files for seven days before cycling, so you need a regular download routine to keep continuous history.
Closeout timing also affects what appears in your files. Automated exports generate within one hour after your configured closeout time. Manual exports run too soon may miss late transactions. Allow enough time after closeout before expecting complete daily data.
Advanced Export Strategies for Menu, Sites, and Analysis
Advanced Toast export setups reveal deeper profitability patterns for growing UK restaurant groups. Menu hierarchy exports support sales mix analysis by category so you can spot high-volume, low-margin items that need attention. Use PMIX reports with different hierarchy levels to see performance from menu groups down to individual modifiers.
Multi-site operations gain clarity from consolidated export strategies. Configure SFTP exports to capture data across all locations at once, then run location-level analysis to compare performance. This method highlights opportunities for menu standardisation, pricing changes, and operational improvements across your group.
Post-export analysis converts raw data into clear actions. Combine Toast sales exports with supplier invoice data to calculate real-time dish costs and highlight margin erosion. Tools like Jelly automate this work, providing live dish costing that updates with every new invoice and delivering the dramatic time savings described earlier.
Restaurants often see around 2 percent GP margin improvement when they pair accurate Toast exports with automated cost analysis. Consistent data extraction, regular review, and fast responses to margin threats form the core of this improvement.
Frequently Asked Questions
How do I export data from Toast without manager access?
You cannot export data from Toast POS without the correct permissions. Toast requires specific access levels: 4.1 Sales Reports for sales data, 4.2 Menu Reports for product mix information, 4.5 Edit Full Menu for bulk menu exports, and 8.3 Data Export Config for automated SFTP setup. Contact your restaurant manager or owner and request the permissions that match your role. If you are an operations manager or chef who needs regular cost and sales data, explain how these exports support margin control and smoother operations.
How can I see sales by item on Toast POS?
You can see item-level sales data through the Product Mix (PMIX) report in Toast Web. Go to Reports > Menus > Product mix, select “Try the new version” for enhanced features, then set your date range and filters. Choose “Items” from the menu hierarchy dropdown to see individual item performance including quantity sold, gross sales, net sales, and, if configured, cost and margin data. Export this data as CSV or Excel for deeper analysis. The PMIX report remains the most complete item-level sales view in Toast POS.
What is included in Toast sales by item exports?
Toast PMIX exports include detailed item-level data such as item names, quantities sold, gross sales, discount amounts, refund amounts, net sales, void amounts, waste counts, item prices, tax amounts, and sales categories. When menu item costs are configured correctly through the menu builder or synced from systems like xtraCHEF, exports also include COGS, gross profit, and gross margin calculations. This dataset supports detailed profitability analysis, menu engineering, and quick identification of high-volume, low-margin items.
How do I export my menu from Toast?
You can export your full menu database through Toast Web’s Items Database. Go to Menus > Bulk management > Items database, then customise visible columns using the Show/hide columns button and click the download icon in the top right corner. This action exports your entire menu hierarchy including menus, groups, items, modifiers, prices, costs, categories, and reporting tags. For multi-location restaurants, select specific locations via the Edit button before exporting. The resulting spreadsheet supports cost analysis, pricing reviews, and menu engineering projects.
Can I automate Toast POS data exports?
Toast supports automated nightly SFTP exports for sales, menu, and configuration data. Contact Toast Customer Care to enable data export access, then configure automated exports through Reports > Settings > Data Exports, which requires 8.3 Data Export Config permission. Set up SSH keys for secure access, select data types such as Order Details, Product Mix, and Menu configuration, then connect via SFTP clients like Cyberduck or Terminal. Exports generate nightly within one hour after your configured closeout time and provide consistent data for analysis tools and third-party integrations.
Conclusion: Turning Toast Data into Reliable Profit
Mastering Toast POS exports gives you a direct route to data-driven profitability in 2026. From manual CSV downloads to automated SFTP feeds, you now have a clear process for extracting sales and menu data efficiently. The real shift happens when you connect these exports to automated tools that convert raw numbers into clear margin insights.
Clean Toast exports combined with platforms like Jelly deliver measurable results such as 2 to 3 percent margin improvements, significant weekly time savings, and proactive cost management that protects your bottom line. UK restaurants using this integrated approach report strong cost savings and tighter operational control within the first quarter.
Manual processes no longer need to erode your margins. Book a demo today to see how your Toast exports can deliver instant profitability insights and strengthen your restaurant’s financial performance.