I need someone to create a sales and tax report from exported Magento data
- or -
Post a project like this2431
£250(approx. $311)
- Posted:
- Proposals: 5
- Remote
- #1653487
- Awarded
Description
Experience Level: Expert
Estimated project duration: 1 - 2 weeks
Analysis tool: Excel
Description of analysis: Please only apply for this job if you understand the issue at hand and are able to deliver within 7 days within budget.
We have a Magento 1.9 store which has not had tax correctly configured by the owner for the past Year.
The accounting requirements mean that there is a need to get a report showing the amount of tax paid per month since October 2016.
To do this we're going to be able to export a file using this extension: https://www.xtento.com/magento-extensions/magento-order-export-module.html#
This will give the Order data and a list of the products that were associated with the order.
Another export will then need to be done to show which products have a taxable rate and which are non taxable. That will have to be matched to the first file and the products with a taxable rate will need to have the tax calculated (selling price is £1 GBP, tax at 20% so tax for that product is £0.20)
This needs to be done on a per product basis as, like I mentioned, the tax is only appropriate on some products. The Tax MUST NOT be added on to the product price, it simply needs to be calculated what portion of that price was tax as it's already included.
These files then need to be used to give us a total for each month on what the total income was, then what amount of that income was tax.
Each Month should be in a separate CSV broken down by order number, total order value and tax amount.
Extra notes:
Description of analysis: Please only apply for this job if you understand the issue at hand and are able to deliver within 7 days within budget.
We have a Magento 1.9 store which has not had tax correctly configured by the owner for the past Year.
The accounting requirements mean that there is a need to get a report showing the amount of tax paid per month since October 2016.
To do this we're going to be able to export a file using this extension: https://www.xtento.com/magento-extensions/magento-order-export-module.html#
This will give the Order data and a list of the products that were associated with the order.
Another export will then need to be done to show which products have a taxable rate and which are non taxable. That will have to be matched to the first file and the products with a taxable rate will need to have the tax calculated (selling price is £1 GBP, tax at 20% so tax for that product is £0.20)
This needs to be done on a per product basis as, like I mentioned, the tax is only appropriate on some products. The Tax MUST NOT be added on to the product price, it simply needs to be calculated what portion of that price was tax as it's already included.
These files then need to be used to give us a total for each month on what the total income was, then what amount of that income was tax.
Each Month should be in a separate CSV broken down by order number, total order value and tax amount.
Extra notes:
Alex B.
100% (21)Projects Completed
20
Freelancers worked with
15
Projects awarded
15%
Last project
30 Aug 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi, how many files/records are involved?
467867
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies