Find Jobs
Hire Freelancers

opencart module for micro accounting

$10-30 USD

Closed
Posted about 6 years ago

$10-30 USD

Paid on delivery
Please read well before bidding We need to develop a micro model for basic accounting for opencart with the caring of external expenses of the compny and another incomes beside sales as investment or prizes. Module should be developed to match open cart 2.3.0.2 and without touching opencart core but as module that is installed from extension installer and get access to admin users and ability to use vqmod/ocmod. plz work on clean version of oc 2.3.0.2 and you submit module as zipped file to test on any opencart to check it independently. you can use many components of opencart reports , filtering,... to simplify the job alo u will send me the needed mysql changes The task: Admin menu called acounting has sub menus : 1-expenses it has 2 tables expense (id,description,ammount,category_id,date,user_id,active) & expense_category (id,name) ADD/EDIT/Delete for cost "Soft delete by letting active=0 in database 2-income ADD/EDIT/Delete "Soft delete by letting active=0 in database" it has 2 tables income (id,description,ammount,category_id,date,user_id,active) & income category (id,name) ADD/EDIT/Delete for income "Soft delete by letting active=0 in database" 3-expenses categories view with buttons to ADD/EDIT/Delete for expense_category 4-income categories view with buttons to ADD/EDIT/Delete for income_category 5-reports ability to enter start & end date fields to filter data according to order date (and by default show data for all the time) show these data: Total number of orders Total Sales Collected Sales (we will add money_collected field in order table with true/false option and it appear also at admin edit order & admin columns in view order and we will calculate oders whose money_collected=1) Non-Collected Sales (money_collected=0) Cost of Goods Sold (i will tell you in #6 how to determine) Gross profit = Total Sales- Cost of Goods Sold Operating expenses (i will tell you in #6 how to determine) Net Profit = Gross profit - Operating expenses CashFlow = Net profit-Not collected sales +Income (Show this only in case of there is no start and end date entered as they are globla for whole period) 6-settings -user can choose components of Cost of Goods Sold "we talked about in reports" where all categories of expenses appears in checkboxes with ability of multiple select -user can choose components of operating expenses"we talked about in reports" where all categories of expenses appears in checkboxes with ability of multiple select so the system knows which are components for each when they do calculation of costs & incomes of the selected categoires to give the right result in the reports. We will have additional column in order table called "order_expenses" and it is by default = 0 we will add that value to the cost of good sold "calculated above" , only show the order_cost filed with money_collected filed during order create/edit to be able to add any excess cost from here.
Project ID: 15983955

About the project

4 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $130 USD for this job
User Avatar
I've been designing small to mid size Opencart websites for 8 years. I specialize in Opencart Template, Integrating kinds of api like payment processing, Shipping api, Crm API etc. Relevant Skills and Experience opencart / custom development / api integration Proposed Milestones $300 USD - custom requirment
$300 USD in 8 days
4.9 (223 reviews)
6.9
6.9

About the client

Flag of EGYPT
Gizah, Egypt
4.9
5
Member since Jul 16, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.