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.
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