The most popular reports tend to be common across various markets. This article outlines reports that are likely to be of interest to your business, regardless of what you sell. We have also included some reports that will be useful for specific industries and markets.
The Accounts Receivable Reports give a summary or a detailed outline of the owing Invoices for a given time period for all your Customers, or just one. The Balance Summary report in particular gives you a simple, across-the-board overview of who owes you money, and who has outstanding credit.
LightSpeed allows you to track commissions based on either the Selling Price or the Gross Profit in the Commission or Commission by Profit categories, respectively. Set your date range, and set the rate of your Commission calculation.
There are two categories for Commissions - Commissions (based on Price) and Commissions By Profit. The Commission By Profit category is a straightforward configuration - simply enter the commission rate, and it will be calculated on the profit margin of your sales, per User. The Commission report, based on price, requires a range set for discounts.
If, for example, you pay 5% commission for non-discounted Products, and 3% commission on Products discounted between 10% and 20%, you would run the report twice. First, you would enter a rate of 5% for Products discounted between 0 and 10%. Then, you would enter a rate of 3% for Products discounted between 10 and 20%. If you make no distinction, set the range to be 0% and 100%.
Commission reports list Users separately. In cases where there was a split, that particular combination is shown as a separate User. For example, a LightSpeed Administrator/Karen Scarpelli combination will show up on the report as its own User, as would a Karen Scarpelli/LightSpeed Administrator split. All Invoices assigned to Karen Scarpelli alone would appear under the User Karen Scarpelli, separate from the two combinations mentioned.
There are several Inventory categories possible, including Inventory Valuation, which will allow you to check the value of your stock, and any stock you have in your warehouses. The Inventory (In Stock) category allows you to check your inventory by Supplier. The Inventory History category allows you to track any changes in inventory levels according to the User who processed it, including Invoices, inventory adjustments, and Purchase Orders.
The Payment category shows you a summary of Payment Methods used over a given date range, and can be filtered based on Payment Method, Station, Customer, or User.
To create a Price List from your Products, select the Product category, and choose the Price List Report.
There are more than 60 reports available in the Sales category, allowing you to run reports based on Class or Family, User, Customer, or combinations. Choosing a different report may result in new filters becoming available.
To create a report based on your company’s sales over a date range, choose the General Report in the category Sales. Set your date range using the two calendars. The pop-up menu below allows you to indicate if you want this date range to reflect the creation date of all Invoices, the creation date of non-Posted Invoices, or the Posted date of Posted Invoice. If you wish to filter your results based on Customer or User, you can set the Report Filters at the bottom of the window.
Choosing the Taxes category gives you access to many options in the reporting of taxes charged on Invoices, including a breakdown of paid or owing Invoices, or by each particular tax charged.
Timesheets will provide an overview of the time clocked by the Users and can also be seen in terms of the time spent on Jobs created in LightSpeed.
Accounting Exports cannot happen properly if you have Products that are missing any of their GL accounts – the Troubleshooting reports allow you to pinpoint if you are missing any GL accounts for Products, as well as if you’ve received any inventory at zero cost.
