Lukket

opencart module for micro accounting

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.

Evner: Regnskab, MySQL, Åben Kurv, PHP

Se mere: plimus opencart module, opencart module credit card, sub categories opencart module, opencart module iframe, opencart module deal, filter opencart module, simple opencart module, opencart module stock, show case gwt smart, opencart module header, create opencart module, opencart module canada post, smart gwt show case, multi shop opencart module, opencart module products, opencart module development, opencart module proramming, show case xml php flash

Om arbejdsgiveren:
( 5 bedømmelser ) Gizah, Egypt

Projekt ID: #15983955

5 freelancere byder i gennemsnit $107 på dette job

trinkaljuneja

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 open Flere

$300 USD in 8 dage
(201 bedømmelser)
6.6
protovosolutions

We're Opencart experts - [login to view URL] & would like to help you with Opencart module development. Relevant Skills and Experience Opencart Portfolio => # [login to view URL] # [login to view URL] Flere

$166 USD in 3 dage
(39 bedømmelser)
5.2
KoushikBanerjee

Hello! I am a professional OpenCart developer. I have 20+ experiences in web development. I have understood your requirement. I have few questions. Please come on chat for discussion. Relevant Skills and Experience Ke Flere

$30 USD på 1 dag
(3 bedømmelser)
2.1
$13 USD på 1 dag
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
0.0