SALES ANALYTICS VirtueMart Reports: Sales, Products, Orders, Customers, Locations, Manufacturers, Inventory, Taxes, Shipping Costs, ... everything under control on your online shop!! Read the Full Story
SALES ANALYTICS for MAGENTO Magento Reports: On-site reports for Sales, Products, Categories, Orders, Customers, Locations, Taxes, Shipping,... deep insight into your Magento online shop!! Read the Full Story
SOCIAL ANALYTICS JomSocial Reports: Now you can know about your user social activities in detail. Friends, groups, photos, videos, ... reports on all your user participations. Read the Full Story
WEB ANALYTICS Joomla! Reports: You can check how your website is evolving using all the relevant information at hand, and make it grow accordingly!! Read the Full Story
* * * *
image image image image
Welcome, Guest
Username Password: Remember me
SALES ANALYTICS for MAGENTO Installation & Configuration.
  • Page:
  • 1

TOPIC: Net Income greater than Gross Income!

Net Income greater than Gross Income! 4 years, 6 months ago #1

Hi, Just installed the extension, and i'm having a hard time understanding how the columns are calculated. For examples, on the "Sales > Nett_Income" report.. How can the nett sales be higher than the gross sales? How is this calculated?

See image for my header row.


Re: Net Income greater than Gross Income! 4 years, 6 months ago #2

  • latitudweb
  • Administrator
  • Posts: 182
  • Karma: 1
Hello Martin,

Sorry for the late response.

To perform its calculations and build the reports, Sales Analytics takes every data value from the DB. In this report you've sent us, the DB "Total Invoice" field value is used for the Gross Income, and the DB "Subtotal Invoice" field value is used as the Net Income.

The Net Invoice should represent the Gross Income minus Taxes and Shipping costs. That is, the income associated to the sale operation as such, without any associated indirect cost. We've checked the numbers and it seems that this Net Income that you've sent us is calculated BEFORE the discount has been applied, and thus the hihger value. And that is not correct.

On other reports (for example on those based on Products or Product Categories) the Net Income value is calculated in a different way. Please let us check these numbers, and we'll provide an updated version of these reports to calculated the Net Income in a different more suitable way.

Kind regards, and thanks a lot for your feedback.
  • Page:
  • 1
Time to create page: 0.17 seconds

About Us

Latitud WEB is a trademark from Business Excellence through Information Technologies S.L. (BEIT). BEIT is an Information Technology company based in Valencia (Spain). Our aim is to put the IT advantages at the service of companies and organizations of any size.