Reports guides and videos show you how to use XSite’s reporting tools to track sales, fuel performance, inventory, and more. You’ll learn how to open and read different report types, filter data, and find the information you need to make smart business decisions. These simple tutorials help you understand your numbers and stay on top of your store’s performance.
In the world of business, staying informed with timely, accurate data is key to making strategic decisions. XSite offers a suite of analytical reports designed to provide you with insights necessary for informed decision-making. This guide will walk you through the process of creating a report in XSite, enabling you to harness the power of data to drive your business forward.
Creating a Report in XSiteIO
- Select the ‘Reports’ option located within the side menu. This will take you to the main reporting area of XSite.
- Within the ‘Reports’ page, you will find reports organized into several key categories:
- Favorites: Quick access to the reports you use frequently.
- Price Book: Detailed information on pricing, sales, and inventory.
- Fuel: Comprehensive data on fuel sales and transactions.
- Inventory Control: Insights into stock levels and inventory movement.
- Charge Accounts: Information on customer charge accounts and related activity.
- Advanced Reporting: In-depth analytical tools for sophisticated data analysis.
- Note: The Advanced Reporting category offers expanded capabilities and requires an additional purchase. For a demonstration or to activate this feature, contact XSite support.
- If you find a report particularly useful and wish to have quicker access to it, you can add it to your ‘Favorites’:
- Locate the report you want to favorite.
- Click on the star icon situated to the far right of the report name. This will add the report to your ‘Favorites’ category for easy access in the future.
Creating a Report in XSite Classic
- Select the ‘Analytics’ option located within the side menu. This will take you to the main reporting area of XSite.
- Within the ‘Reports’ page, you will find reports organized into several key categories:
- Favorites: Quick access to the reports you use frequently.
- Price Book: Detailed information on pricing, sales, and inventory.
- Fuel: Comprehensive data on fuel sales and transactions.
- Inventory Control: Insights into stock levels and inventory movement.
- Charge Accounts: Information on customer charge accounts and related activity.
- Advanced Reporting: In-depth analytical tools for sophisticated data analysis.
- Note: The Advanced Reporting category offers expanded capabilities and requires an additional purchase. For a demonstration or to activate this feature, contact XSite support.
- If you find a report particularly useful and wish to have quicker access to it, you can add it to your ‘Favorites’:
- Locate the report you want to favourite.
- Click on the star icon situated to the far right of the report name. This will add the report to your ‘Favorites’ category for easy access in the future.
Advanced Reporting is an extra tool in XSite. It gives you three powerful reports to help you better understand your business:
Bank Transactions Report
- See all bank activity during a time period.
- Useful for checking:
- Bank response codes
- MonerisID
- CRIND status (card reader outside at the pump)
- Helps track payment issues or declines.
Transaction List Report
- Shows every single sale in detail.
- Great for:
- Looking up receipt numbers
- Viewing item IDs
- Seeing what payment types were used
- Helps if you need to track down a specific sale.
Customer Stats Report
- See what your customers are buying.
- Breakdown includes:
- How often customers shop (TRS count)
- Fuel and merchandise quantities
- Trends in customer behavior
- Use it to target promotions and boost loyalty.
Want to Try It?
- This is an add-on feature, so it might not be turned on yet.
- To learn more or see a demo, contact XSite support.
- We’ll show you how it works and how it can help your store.
What This Report Is
This report shows how well your items are selling. You can group the sales by Shift, Department, Subdepartment, or Supplier, and review the results over a custom or preset date range (like “Last 30 Days”).
Why It Matters
- Shows which products and suppliers make you the most money
- Helps you spot slow-selling items or problem categories
- Helps avoid over-ordering or running out of popular products
- Great for planning promotions, pricing, or supplier deals
What to Do
- Check Profits: Look for top departments or suppliers bringing in the most profit. Promote those items.
- Fix Inventory Issues: If you see negative QOH, it may mean scanning or stocking mistakes—check immediately.
- Drop Dead Items: If something sold 0 or very little, consider removing or discounting it.
- Review Margins: Sort by lowest margin and see if pricing or supplier cost needs adjusting.
- Plan Smarter Orders: Use sales + QOH to decide what to reorder and what to skip.
What This Report Is
This report shows your daily sales for each department (like Candy, Alcohol, Health, etc.). It includes total sales, promotions, refunds, and net sales for a selected period.
Why It Matters
- Helps you track daily performance for each department
- Let’s you spot trends or sudden changes in sales
- Identifies refund issues or missed sales
- Useful for reviewing the success of promotions or discounts
What to Do
- Investigate Drops: If a department’s sales suddenly fall, check POS, stock levels, or product issues
- Compare Days: Use daily data to find slow vs. busy days and adjust staffing or hours accordingly
- Watch Refunds: Frequent or high-dollar refunds should be reviewed—may be errors, fraud, or bad products
- Track Promotions: If you’re running deals, use “Promotion Amt” to see how much discount was given and whether it led to more sales
What This Report Is
This report shows items in your store that have not sold during a specific time period. You can filter it by department and by how many days you want to check. You can also deactivate (make inactive) any items directly from this report.
Why It Matters
- Helps you spot products that aren’t selling
- Prevents you from wasting money on dead inventory
- Keeps your store’s item list clean and up to date
- Makes restocking decisions easier by showing which items don’t move
What to Do
- Clean Up Inventory: Mark items as inactive if they haven’t sold and you don’t plan to restock them.
- Avoid Reordering: Stop ordering items that aren’t selling to free up cash and shelf space.
- Investigate High QOH: If you have many units in stock but no sales, check for stocking issues, placement problems, or wrong pricing.
- Export and Review: Download the report to Excel for easy review with your team or supplier meetings.
What This Report Is
This report shows how well your promotions are doing. It compares the regular price of items to the discounted deal price, and shows how many you sold. You can look at the data in two ways:
- Summary View – see total sales and savings by deal or item.
- Detail View – see every transaction during the promotion.
Why It Matters
- Helps you track the success of deals and special pricing.
- Shows how much money customers saved (and how much you discounted).
- Tells you which items are selling best during promotions.
- Helps avoid mistakes like wrong prices or missed discounts.
What to Do
- Check top sellers: See which promo items sold most and consider repeating them.
- Spot missing discounts: If Deal Difference is $0 or very low, check the promo was applied correctly.
- Review profit impact: Compare your discounts to see which promos were worth it.
- Keep an eye on margins: Large discounts may increase sales, but reduce profit—balance both!
What This Report Is
This report shows you the different prices you have set for each item, depending on how many a customer buys. It lists the regular price and any quantity-based pricing (for example: Buy 2, pay a lower price).
Why It Matters
- Lets you quickly check if quantity discounts are set up correctly
- Helps catch pricing mistakes before they cost you money
- Useful for planning sales and promotions
- Helps make sure bulk pricing is profitable
What to Do
- Review Prices Regularly: Make sure every item has the right price, especially after price changes from suppliers.
- Check Quantity Discounts: If you offer “buy more, save more” deals, confirm they’re set up correctly.
- Fix Errors Fast: Delete or correct any pricing that doesn’t make sense to avoid accidental discounts or lost revenue.
- Plan Promotions: Use this report to find items that might benefit from adding quantity discounts to encourage bigger purchases.
What This Report Is
This report shows every sale made under a promotion or price group. It breaks down how much was sold, what the regular price was, and how much of a discount (if any) was applied. You can filter by date, department, or specific promo/price group to focus on the info you need.
Why It Matters
- Shows how promotions affect your sales and what’s being discounted.
- Helps catch pricing mistakes or missed discounts.
- Lets you track how many items were sold under each deal.
- Great for checking how much you gave away in discounts.
What to Do
- Look for $0.00 in “Discount Given”: If it’s a promo and there’s no discount, that may be a setup error.
- Review sales by item: Spot best-selling promo items to repeat in future deals.
- Compare promo vs. regular pricing: Are you giving too much off or not enough to move stock?
- Check dates and departments: Make sure the right promos ran in the right places and times.
What This Report Is
This report shows all the transactions made using private label cards — these are special payment cards issued by specific programs or companies (kind of like a store credit card). You can filter by card type (e.g., ARI, ELEMENT, or ELEMEN) and choose a date range to see which private card transactions happened in your store.
Why It Matters
- Helps you track payments made with private cards
- Ensures all private card sales are recorded properly
- Useful for checking if private card batches match your deposits
- Helps catch unusual or suspicious transactions
What to Do
- Reconcile Payments: Compare the Payment Amount totals to your private card deposit reports to ensure they match.
- Review Unusual Activity: If a card is used many times in a short period, or large amounts appear, investigate further.
- Check Card Types: Filter by ARI, ELEMENT, or ELEMEN to review each private card provider’s activity.
- Keep Records: Export the report regularly for your accountant or corporate office to assist with end-of-month reconciliation.
What This Report Is
This report shows your total sales for every department, month-by-month, for the entire year. You can also run a Sales Comparison to view two years side-by-side, making it easy to compare this year’s sales with last year.
Why It Matters
- Helps you see big-picture sales trends across the whole year
- Makes it easy to compare this year’s sales to last year’s
- Identifies slow months or growing departments
- Helps you plan inventory, staffing, and promotions based on trends
What to Do
- Spot Growth Areas: If certain departments keep growing, consider expanding those product lines.
- Investigate Declines: If sales drop month over month, check for pricing, stock issues, or lost customers.
- Use for Planning: Use slow months to schedule store maintenance or fewer staff; ramp up for busy months.
- Compare Years: In Sales Comparison mode, quickly see if your business is improving or slipping year-over-year.
What This Report Is
- This report shows a list of all your inventory items, broken into two groups:
- Active Items: Items currently for sale in the store.
- Inactive Items: Items no longer being sold or available.
- You can filter the report by department and by how many days back you want to review.
Why It Matters
- Helps you keep your inventory list clean and up-to-date
- Identifies items that should be discontinued or reactivated
- Helps you spot old or dead inventory taking up shelf or storage space
- Prevents ordering mistakes on items you no longer carry
What to Do
- Switch inactive items back to active if you plan to restock them.
- Remove old inactive items from your ordering system to keep inventory clean.
- Review active items with low or zero sales — consider running promotions or discounts.
- Fix negative QOH values — may need an inventory adjustment or recount.
What This Report Is
This report compares sales between two or more store locations. You can pick a department (or multiple departments) and a date range. The report shows both a simple total sales comparison and a detailed breakdown of each item sold at each location.
Why It Matters
- Helps you see which locations are selling more or less of certain products.
- Identifies slow-selling items at specific stores.
- Useful for making better inventory decisions for each store.
- Helps you adjust orders to reduce waste and out-of-stocks.
What to Do
- If one store is selling much less of certain items, check inventory levels or promotions at that location.
- If one store sells much more, consider adjusting stock or ordering more for that site.
- If certain items sell poorly at all locations, consider discontinuing or promoting them.
- Use the detailed view regularly to catch problems early, like stock issues or pricing mistakes.
What This Report Is
This report shows all lottery payouts made at your store. It includes which cashier handled the payout, how much was paid, and when the transaction happened.
Why It Matters
- Helps track lottery cash flow and reduce loss
- Catches suspicious or repeated payouts
- Confirms cashier activity during specific shifts
- Supports audit reviews if a mistake or theft is suspected
What to Do
- Review Daily Totals: Check if any one cashier is doing a high number or value of payouts
- Flag Large Payouts: Investigate any high payout amounts (e.g., over $100) to make sure they were legitimate
- Spot Patterns: Look for payouts happening repeatedly at the same time or by the same person—could be a red flag
- Print for Records: Keep a weekly or daily copy for your accountant or franchise auditor if needed
What This Report Is
This report tracks the daily fuel inventory in your underground storage tanks. It records how much fuel is delivered, sold, and how much remains in the tank each day. The report helps you catch leaks, avoid fuel losses, and stay compliant with regulations.
Why It Matters
- Helps detect leaks early to avoid costly repairs and fines.
- Ensures fuel deliveries and sales match actual tank levels.
- Provides records to meet government regulations.
- Prevents fuel loss from theft, spills, or equipment problems.
What to Do
- If Litres (+/-) difference is large or keeps happening, investigate for possible leaks or equipment issues.
- If deliveries or sales don’t match expected fuel levels, check delivery slips and dispenser meters for errors.
- Regularly check Daily Variation (%) to spot trends.
- Keep this report on file for at least 2 years for compliance.
- Use consistent measuring practices (same time each day, accurate dip readings).
What This Report Is
This report shows your daily sales for both C-Store items (inside sales) and gasoline (outside sales) side-by-side. It breaks down total sales, profit, units sold, and fuel margins for each day within the date range you select. This gives you a quick daily performance snapshot across your entire operation.
Why It Matters
- See how your gas and store sales perform together every day.
- Spot patterns like busy or slow days to adjust staffing and inventory.
- Identify days with strong or weak profit margins.
- Quickly review total daily sales to stay on top of store health.
What to Do
- If C-Store sales drop, review store promotions, product displays, or staffing.
- If fuel margins (Daily or Avg) are unusually low, check for pricing errors or competitive pricing issues.
- Use the Total column to see your best and worst performing days — plan promotions or staff schedules around these patterns.
- If fuel units sold seem low on busy days, check pump uptime or fuel availability.
What This Report Is
This report tracks your fuel inventory for a full month. It shows how much fuel you started with each day, how much was delivered, how much was sold (pumped), and calculates whether your numbers balance. This helps you check if fuel is missing or if your tank readings match your sales.
Why It Matters
- Catch fuel losses early — Spot leaks, theft, or delivery issues before they become costly.
- Stay compliant — Helps meet government regulations for fuel storage and leak checks.
- Keep accurate records — Ensures your fuel sales match what you physically have in your tanks.
- Protect profits — Quickly identify problems that could affect your bottom line.
What to Do
- Review the Daily Over or Short column. If you see big negative numbers, check for possible leaks, delivery issues, or theft.
- Check the Leak Check box at the bottom each month. If it says “Yes” for 2 months in a row, notify your fuel supplier or regulatory agency.
- Keep this report on file for at least 1 year to meet regulatory rules.
- Use the report to compare stick readings and dispenser sales. If they don’t match often, recalibrate your pumps or check your tank sensors.
What This Report Is
This report gives you a simple monthly summary of all your store’s financial sections. You can pick a section (like Sales, Deposits, Debit, Taxes, Payouts, and more) and see the total dollar amounts and transaction counts for that section during the selected month.
Why It Matters
- Helps you check if your sales and bank deposits match up.
- Easy way to verify that all payments and transactions are being recorded properly.
- Helps you spot missing deposits, unusual charges, or unpaid local charges.
- Supports accurate reporting for accounting, taxes, and audits.
What to Do
- Compare amounts across sections: Make sure your sales totals match your deposits and payouts.
- Look for missing or zero amounts: A zero may mean something was not processed correctly.
- Review local charges regularly: Ensure customers with local charge accounts are paying.
- Check high transaction counts: If one section shows a lot more transactions than usual, investigate why.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.