This is a module for the administration that provides a full and detailed overview of your website operations.
Provides the following reports:
- Summary (overview as at the current date)
- General Information (geo zones, shipping methods, tax rates, currencies)
- Sales Report (including breakdowns of sales by currency, shipping costs by method, taxes collected by tax rate)
- Profit and Loss Report (how much did you make or lose?)
- Stock Report (displays stock levels)
- Sales by Store (product sales by store)
- Sales by Category (product sales by category)
- Sales by Manufacturer (product sales by manufacturer)
- Customer Demographics (where on earth do they come from?)
- Charts
Print out a professional report at the click of a button. Give your report a title, write an introduction (optional), select the pages you want in the report (sales, profit & loss, etc.), then click either the "Print to PDF" or "Print to HTML", to be provided with a printable report that you can present to your boss/auditor/taxman.
Installation instructions included. No files overwritten. Includes vQmod file to automatically add an entry under "Reports" in the admin menu.
Compatible with OpenCart versions 1.4.8, 1.4.8b, 1.4.9, 1.4.9.1, 1.4.9.2, 1.4.9.3.
Demo can be found at http://demo.fido-x.net/. You can log in to the admin with username/password pair of "demo/demo", then go to "Reports->Financial Report".
Available from OpenCart Extensions or from Fido-X.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Yeeehaaaa! Finaly you did it!
*counting his money, damn, "mam!, I need my week allowance"
*counting his money, damn, "mam!, I need my week allowance"
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Does it use the Cost price table?
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I would think it would have to I don't know how else you would get a profit report.i2Paq wrote:Does it use the Cost price table?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Thanks for the comments.
A couple of "bugs" have been reported. I have updated the package with a fix, so those who have made purchases should be able to get a fresh copy. Alternatively, you can fix it yourself with the following:
Change lines 625 and 1769 in "admin/controller/module/statements.php" from:
to:
Thanks to Brook for finding this.
Yes, it does.Xsecrets wrote:I would think it would have to I don't know how else you would get a profit report.i2Paq wrote:Does it use the Cost price table?
A couple of "bugs" have been reported. I have updated the package with a fix, so those who have made purchases should be able to get a fresh copy. Alternatively, you can fix it yourself with the following:
Change lines 625 and 1769 in "admin/controller/module/statements.php" from:
Code: Select all
$stock_status = $this->model_fido_statements-getStockStatus($product['stock_status_id']); Code: Select all
$stock_status = $this->model_fido_statements->getStockStatus($product['stock_status_id']);
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Super nice!
1. Might be an issue with the Sales By Category calculating percentage
Laptops & Notebooks shows $500.00 sales, 33.33%
but MP3 Players shows sales of just $100.00 but also a percentage of 33.33%
2. Sales breakdown by payment type would be good too (cc, paypal, etc)
HTH
1. Might be an issue with the Sales By Category calculating percentage
Laptops & Notebooks shows $500.00 sales, 33.33%
but MP3 Players shows sales of just $100.00 but also a percentage of 33.33%
2. Sales breakdown by payment type would be good too (cc, paypal, etc)
HTH
The figures are correct. The "Sales by Category" page displays a list of your categories/sub-categories, how many products are in each category/sub-category and percentage of product sales (not sales value).scanreg wrote:Super nice!
1. Might be an issue with the Sales By Category calculating percentage
Laptops & Notebooks shows $500.00 sales, 33.33%
but MP3 Players shows sales of just $100.00 but also a percentage of 33.33%
You'll note, that on the demo site, only 3 products have been "sold", one from "Desktops > Mac", one from "Laptops & Notebooks" and one from "MP3 Players". These 3 products,together, represent 100% of your sales. Each product, individually, represents one third or 33.33% of your sales.
Good idea. Hadn't thought about that. I'll look into it.2. Sales breakdown by payment type would be good too (cc, paypal, etc)
HTH
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Thank you for a great extension.
Is it possible to get sales by products as well based on monthly, weekly and days, with price and qty sold and total gained based on products specifically?
Also, if I enter the cost of the product on each individual products, will it recalculate the whole profit/loss? or only for going forward sales that I will have?
* Found some bugs in calculations... Shipping cost doesnt add up properly.
Is it possible to get sales by products as well based on monthly, weekly and days, with price and qty sold and total gained based on products specifically?
Also, if I enter the cost of the product on each individual products, will it recalculate the whole profit/loss? or only for going forward sales that I will have?
* Found some bugs in calculations... Shipping cost doesnt add up properly.
I'll look into this for a future update.cashman9 wrote:Is it possible to get sales by products as well based on monthly, weekly and days, with price and qty sold and total gained based on products specifically?
Yes, since the "cost" is only stored in the database table anyway. The profit/loss report uses the order, order_product and product tables. Value of sales is taken from the orders table, while the query to determine the cost uses the order_product and product tables.Also, if I enter the cost of the product on each individual products, will it recalculate the whole profit/loss? or only for going forward sales that I will have?
That's a possibility. Could you provide some more information on this please. For example, have you changed the sort order under "Extensions->Order Totals"?* Found some bugs in calculations... Shipping cost doesnt add up properly.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Sort order is:
Sub total 1
Coupon 2
Insurance 3
Shipping 4
Rush Order 5
Taxes: 6
Store Credit 7
Total 8
----------------------------------------------
The shipping only calculates the first one, which is the first class mail, but skips priority mail, media mail and etc.
And now since I changed the order since both insurance and shipping was on 3, and I switched to shipping 4, it only shows insurance. as expenditure for shipping.
How can I resolve it?
Thanks.
Sub total 1
Coupon 2
Insurance 3
Shipping 4
Rush Order 5
Taxes: 6
Store Credit 7
Total 8
----------------------------------------------
The shipping only calculates the first one, which is the first class mail, but skips priority mail, media mail and etc.
And now since I changed the order since both insurance and shipping was on 3, and I switched to shipping 4, it only shows insurance. as expenditure for shipping.
How can I resolve it?
Thanks.
Shipping costs and taxes collected are taken from the "order_totals" table. Changing the sort order of your order totals will render historical data inaccurate. By that, I mean, that any orders placed before the change would have the order totals in the previous sort order, while orders placed after the change will have the order totals in the new sort order.
Other reasons for reporting wrong figures could be the result of price changes during the reporting period. For example: if the cost price of a product changes during the reporting period, the changed price will be used in calculating profit and loss.
There are quite a few "variables" like this that will have an effect on the accuracy of the report. It is up to you, as the store owner, to make note of the date when things change (prices, taxes, costs) and adjust your reporting period(s) accordingly. You would, as par for the course, have to keep records of these sorts of changes anyway.
While the "order_product" table contains the price the product sold for and the tax rate that was applied to the sale (and this table does get used in calculations), it does not tell you what type of tax it was (VAT, Sales Tax, GST). This information is in the "order_totals" table. So, as stated at the begining, changing the sort order of the "order_totals" table will throw up inaccuracies in reporting.
Other reasons for reporting wrong figures could be the result of price changes during the reporting period. For example: if the cost price of a product changes during the reporting period, the changed price will be used in calculating profit and loss.
There are quite a few "variables" like this that will have an effect on the accuracy of the report. It is up to you, as the store owner, to make note of the date when things change (prices, taxes, costs) and adjust your reporting period(s) accordingly. You would, as par for the course, have to keep records of these sorts of changes anyway.
While the "order_product" table contains the price the product sold for and the tax rate that was applied to the sale (and this table does get used in calculations), it does not tell you what type of tax it was (VAT, Sales Tax, GST). This information is in the "order_totals" table. So, as stated at the begining, changing the sort order of the "order_totals" table will throw up inaccuracies in reporting.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
I understand that clearly, since I have now changed the "sort order" all has changed and will be calculated differently going forward. However, this didn't address the issue with shipping. Prior to the change of "sort order," the shipping calculation TOTAL was incorrect.
Meaning that I use shipping module USPS that calculates each price like First Class mail, priority mail and etc. In the Profit/Loss in the Financial Reporting module, it did show the tables for each cost, however, upon calculating the total and subtracting it, it only showed First Class mail neglecting Priority mail and Medial mail, in the total cost, hence the calculations were wrong.
Meaning that I use shipping module USPS that calculates each price like First Class mail, priority mail and etc. In the Profit/Loss in the Financial Reporting module, it did show the tables for each cost, however, upon calculating the total and subtracting it, it only showed First Class mail neglecting Priority mail and Medial mail, in the total cost, hence the calculations were wrong.
Your right, there is a "bug" in the calculations for the shipping. Hadn't noticed it before. Should have seen in the "popup" window on the "Sales" page, that there was no total for the shipping method. Oh well, back to the drawing board 
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
fido-x wrote:Your right, there is a "bug" in the calculations for the shipping. Hadn't noticed it before. Should have seen in the "popup" window on the "Sales" page, that there was no total for the shipping method. Oh well, back to the drawing board
Good that I pointed you to the right direction.
Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?
Yes. Well, it should. Let me know if it doesn't (I'm sure you willcashman9 wrote:Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?
).
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
fido-x wrote:Yes. Well, it should. Let me know if it doesn't (I'm sure you willcashman9 wrote:Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?
Ok great, you working on the shipping calculation bug right?
Who is online
Users browsing this forum: No registered users and 7 guests
