How can we help?

Lightspeed’s Help Centre is here to provide support, tips and troubleshooting

Back Office Reports

 

Whether you need to see a general temp check of your business or wanting a more granular perspective, Kounta enables you to effortlessly get the information you need from anywhere in the world.

 

Reports allow you to view your basic data from your business in real-time with easy to read charts and tables. If you are looking for advanced analytics, then you should talk to us about Kounta Insights.

Kounta Insights allows you to access a library of pre-built reports to quickly identify opportunities to control costs and grow revenue. Your data is displayed in beautiful, interactive visualisations that help tell the complete story, and can be broadcasted to your team to keep them in the know, motivated, and on track. See something that catches your eye? Kounta Insights lets you dig deep beneath the surface to drill into areas like sales trends, product & category comparisons, layout optimisation, and staff performance, in a few clicks.

With the numbers on your side, you will never miss out on profit opportunities again.

This guide will walk you through the basic Back Office Reports, however, we also have a guide to help you explore Kounta Insights

 

working_12.PNG

 


What's in this guide?

 

Access Reports

 

Dashboard

Sales Summary

Sales Feed

Sales By

Hourly Sales

Reconciliation

Comparison

Taxes

Audit

Stock

Attendance

Wastage

Payments

Adjustments

Refunds

Guests

Purchases

Insights

Frequently Asked Questions

 


Access Reports

 

The Back Office is accessible from any device and does not require a register profile. Anyone on your team who has been given Reports access can log in to view reports.

 

Note - Some reports will require the corresponding add-on to be enabled first.

 

1. From the Kounta Back Office, select Reports

update_1_navigate_to_reports.jpg

Pro Tip - Filter your reports for better detail by site, register, time, products, or tags - all depending on the report.

q_filters.PNG

 


Dashboard

 

The dashboard is your home page - it will give you an overview of your business for today. This updates every 10 minutes. The summary version is found under Reports - but the detailed dashboard can be found by selecting My site. Here you will find:

  • Sales total
  • Best Customer, Best Staff, and Best Hour
  • Sales Summary Chart
  • Top Selling Products
  • Sales by Category
  • Top Selling Staff

a_dashboard_1.PNG

a_dashboard_2.PNG

  


Sales Summary

 

The Sales Summary gives you a comprehensive view of sales including Number of Sales, Net Amount, Tax Amount, Total, and Sales Average which can be broken down by the day.   

This updates every 10 minutes.

 

Note - This report *only* counts your sales in the form of gross output - it will not include refunds or returns.

 

b_sales_summary.PNG

 


Sales Feed

 

This report updates live and is the reporting equivalent of your Sales History from the POS. You will also be able to quickly view and email customer receipts from here (simply select the magnifying glass icon).

The Sales Feed report is a raw export of your sales data - it shows the details of every sale ever made within a timeframe - including Sale #, Date/Time, Site, Customer, Tip Amount, and Total Amount. This report updates live - just select refresh.

c_sales_feed.PNG

 


Sales By

 

Filter your sales numbers by the user, product, category, or even filtered by unique reporting tags… the list goes on. The Sales By report will not only give you a unique breakdown of your revenue, but will also show you your cost prices, and Gross Profit %. It updates every 10 minutes.

 

Snapshots for the top three filters used most regularly by our customers are shown below;

 

(Sales By) Product - Identify the best selling product and how products rank by quantity, sales amounts, cost, and gross profit %

d_sales__by_product.PNG

 

(Sales By) Category - Identify the best selling category and how categories rank by quantity, sales amounts, cost, and gross profit %.

Products in more than one category are merged into a “Products in Multiple Categories” field, and products in no categories are shown as “Products in No Category”

d_sales_by_category.PNG

 

(Sales By) User - Identify your top staff and how your team rank in terms of sales contribution.

d_sales_by_user.PNG

 


Hourly Sales

 

Was 3 pm really your busiest hour? Or did it just feel busier with everyone on break?

This report gives a perspective on how busy your business actually is so you can plan staffing and other resources to suit. This report updates every 10 minutes.

 

The top-level filters here are Sale Amount, Sale Count, Average Sale. You can view this as...  

  • Summary Chart - hourly Sale Amount, Sale Count, or Sale Average

OR

  • Weekly Comparison - If you chose the week-on-week filter, you will see a comparison of sales performance per week

 

r_hourly_sales.PNG

 


Reconciliation

 

The Reconciliation Report is a granular look into your takings. It consists of subreports which are as follows: Payment Breakdown, Sales, Payments, Tips, Money In/Out, and Adjustments.  

Unlike the other reports that update regularly. This report only gets updated once the staff finalises takings and is, therefore, point-to-point. So if the staff forget to do takings for one day, the next end-of-day takings done would encompass the skipped day and the day itself.

 

Pro Tip - Integrate your accounting with Kounta to have this data sync’d seamlessly with your accounting package.

 

Here are the key subreports under Reconciliation:

A. Reports

Here, you will see an overview of all takings under your chosen filter.

  • Counted -  The counted amount automatically counted with your integrated payment terminal (for card payments) or manually entered by your staff (for non-card payments)
  • Recorded - Total expected from all sales for the period, and inclusive of money ins and outs, and refunds.
  • Variance - The difference between Counted and Recorded

 

Pro Tip - Cash variances are common, however, we highly recommend familiarising your team with the correct takings process to ensure that this information is accurate each day so that you can quickly identify variances.

 

reco_a.PNG

 

B. Payment Breakdown

As the name implies, this focuses on the payments methods within the chosen report. Under each payment method, you will see the payments, refunds, money in/out, and tips - all contributing to the recorded, counted, and variance amounts.

 

reco_b.PNG

 

 

C. Sales

Similar to the Sales Feed, except this report will only show sales within the selected takings period. You can also view and email receipts by selecting the magnifying glass icon beside the sale record.

 

reco_c.PNG

 

D. Payments

This is raw data on all payments made within a takings period including the gratuities.

 

reco_d.PNG


E. Tips

This is a summary of gratuities, to whom it’s going, and if it has been withdrawn as cash.

 

reco_e.PNG

 

F. Money In/Out

This is a summary of float in/out as well as tips withdrawn from the cash drawer.

 

reco_f.PNG

G. Adjustments

Here, you will find a summary of price adjustments, the reason behind the adjustment, and the products they were applied to.

 

reco_g.PNG
 


Comparison

 

This report allows you to build a comparison report between two chosen time periods. You can compare the number of sales, the sales amount, as well as how many items are sold.

 

s_comparison.PNG

 


Taxes

 

The Taxes report will provide a simple breakdown of your taxable amounts based on your sales. The figures are rounded off to the nearest 2 decimal places.

 

u_taxes.PNG

 

 


Audit

 

Quick, yet detailed reporting for auditing on all refunds and discounts entered by your team.  

Track number of sales/products and also the lost revenue from each discount or refund to easily identify any excessive breaches of permissions.

h_audit.png

 


Stock

 

If you have the Inventory add-on enabled, the Stock report will give you a live count of all stock currently on hand and their cost.

t_stock.PNG

 


Attendance

 

If you have the Time & Attendance add-on enabled, this report will provide simple data based on when a user logs in or off from Kounta on a day to day basis.

You can also integrate your Time & Attendance data to Deputy, KeyPay, Tanda, or any of our other integration partners.

j_attendance.PNG

 


Wastage

 

Once you enable the Wastage add-on enabled, this report will provide a complete detail of all products or ingredients that were entered as wastage so you can track by wastage reasons, product type or lost revenue.

k_wastage.PNG

 


Payments

 

This report is only accessible if you have integrated payments. This is a summary of payments (similar to the Payments subreport under reconciliation). This report shows the total amount processed for each payment type and the percent this represents against your total revenue.

l_payments.PNG

 


Adjustments

 

A detailed breakdown of all price adjustments, and promotions. View in either Summary or Detailed to see the reasons behind them, the products involved and the lost revenue.

A great report for seeing how well your promotions are performing.

m_adjustments.PNG

 


Refunds

 

A summary of refund amounts and the reason behind the refund where you can filter by time, user, and reason.

n_refunds.PNG

 


Guests

 

Enable the Guest Tracking Add-on and start reporting on average spend per head, or pair with the Tables add-on and track your dine in vs take away orders (Sales with Guests vs Sales without Guests).

o_guests.PNG

 


Purchases

 

For this report to be accessible, you would first need to subscribe to Kounta Purchase. With Kounta Purchase, getting stock into your business is simple, traceable, and connected to your inventory, reporting, and accounting systems for dreamlike efficiency. 

The purchases report will show you your total received or drafted purchase orders for any given period, and filter based on specific products, categories or supplier.

p_purchases.PNG

 

 


Insights

 

Our newest product, Kounta Insights lets you quickly see your data from all of your companies and sites in one spot so you can make decisions faster and more confidently than ever.

 With a library of pre-built dashboards, powerful filters & drilldowns, and automated report scheduling you have the power to find hidden profit opportunities.

Explore Kounta Insights

 


Frequently Asked Questions

 

How do I download data from Reports?

Use the cloud icon with the downward arrow to download your data as a CSV file - and then open using Excel, Numbers, Sheets, or similar apps. You can export reports from any device logged into the Kounta Back Office with the Google Chrome browser.  

 

When does data on live reports refresh?

The reports are updated live or every 10 minutes (report specific). Naturally, the Reconciliation report is updated once a takings has been finalised.

 

 


What's my next step?

 

In need of more advanced data analytics? It’s time to do more with your data and take business intelligence to the next level. Talk to one of our Experts today.

Browse more topics

Was this article helpful?
3 out of 14 found this helpful