Module for accounting income and expensses using JQWIDGETS preferable

I need a module for keeping track of expensses and income and to generate

reports of them.

The incomes and expensses are grouped in account num, sub account num and sub sub account num

the tables are like this (one table for income account other for expensses account)

id usuarioID descripcion cuentaNum parentID subParentID

where ID is auto increment

usuarioID is the userID of the persons that is making the registration $_SESSION['usuarioID']

cuentaNum (main group)

parentID (sub account)

subParentID(sub sub account)

Once we have the account we have to develop the expenses Module

the main expensses table looks like this

egresoID (auto increment)

usuarioID (same as above) int 8

fechaReg (timestamp)

fecha(date of the expensse)

fechaMil(date of the expensse in milsecconds)

monto(amount decimal 10,2)

comprobado(amount Settled 10,2) this will accumulate all the settle amounts made.

concepto(concept varchar 200)

company(varchar 200)

estatus('comprobado','pendiente','eliminado') ENUM (settled, pending, deleted)

movID int 8 (identifies the bank account payment)

registering editing deleting reading the itemIzed expensses

the purpose of the itemized expensses is to register every individual

expense into the itemized table.

will use them latter to settled the main expenses

the table look like this

itemID autoIncrement



fechaMil(date milliseconds)

monto(amount decimal 10,2)


proveedorID(vendorID) we need to add vendors on the fly in the case they are not registered

facturaFecha(invoice date Date)


fechaVence(date that has to be paid)

cuentaNum (this will be in a combo to choose in the reg edit processes as they come from expensses acount table)



movID (from main expensses table) default 0 when settled will change while this is cero means hasnt been paid

egresoID (from main expensses table) default 0 when settled will change while this is cero means hasnt been paid

The process to settle each main expensse

the main expensses are registered when the regitration of the bank account movements

therefore we dont touch that. it may be a check for x amount to buy several things

from diferent vendors.

we show the main expensses that are pending of settling in a table

we choose the one we are going to use

then we get the itemIZed Expensses we can do that from a table and

we proceed to include as many items we need in order to settled that main expense

each time we include one item it should show the sum of the items included

and the balance left to settled

we may only partially settle the expense in which the estatus of the expense will remain as pending (pendiente)

we may set in full then the estatus will change to settled (comprobado)

in the event we have excess we will apply it into another expensse.

the vendor table

proveedorID autoincrement

nombre varchar 200

direccion1 varchar 200

direccion 2 varchar 200

ciudad varchar 50

estadoID int 2 (from combo estados table estados has 2 fields id and estado)

paisID int 2 default 1 (there is only one country in this table Mexico)

if need more explaining please ask

i would like jqwidgets as all the development is using them

and i want to keep same look

Skills: AJAX, HTML5, MySQL, PHP, Software Architecture

See more: using jqwidgets, use case module, purpose of use case, one accounting, income in accounting, get paid for editing, fields auto group, expense items, expense in accounting, concept registration, c for int, balance in accounting, accounting one, accounting it, accounting for bank, accounting bank, accounting as, all accounting, it accounting, income, expense reports, develop php group, deleting account, concepto, accounting set

About the Employer:
( 6 reviews ) ***************, Mexico

Project ID: #2580741

6 freelancers are bidding on average $558 for this job


ready to start Thanks

$600 USD in 30 days
(138 Reviews)

Hi, I'm web-developer having a lot of experience on PHP,MySql,Javascript,Ajax,jQuery,HTML,CSS etc.I can do your job with 100% satisfaction.I have created first table for [url removed, login to view] check PMB Thanks

$300 USD in 3 days
(13 Reviews)

Dear Hiring Manager, We understand your requirements fully & are confident of a 100% delivery from our end. Please check your mailbox here, for our detailed bid. Thanks and regards BasuTechnoHub team

$750 USD in 30 days
(10 Reviews)

Our services are destined for complete perfection and Company believes in solidarity and commitments. We complete our targets well within time. We provide services in latest Web 2.0 technologies also. We provide offsho More

$650 USD in 15 days
(0 Reviews)

I have went through the project's description and I do want to place my bid. Kindly contact me if you need further references

$300 USD in 15 days
(1 Review)

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$750 USD in 1 day
(0 Reviews)