Suljettu

Billing And accounting for disbursing and tracking expenses

.

The functions for controlling entries and inputs to the system are needed with the SQL schema (including SQL Views and Stored-Procedures where applicable)

Overview

• Track multiple categories,

• Generate reports and graphs that display usage and cost statistics for time period of choice: monthly, quarterly, year-to-date, or annual

• Access data at any level of organization: account, site, site group (e.g., 'Division' or 'Region'), or company

• Identify, Audit, potential billing irregularities and usage anomalies

• Compare usage for historic time periods and graph

• Export and download reports to Excel spreadsheet

System design requirements :

Create user accounts, passwords, permissions, sessions etc

All input fields should be validated (if possible - at browser) to have legal values

Code should be well documented

Code will be written to run on a server with SQL database

Upload the project to our server and test

Assist in testing and running the project on our local server

Users GUI

User Admin module

Password protected

Add/Edit/Remove user accounts

Each user account has the following properties: creation date, account holder, contact person, phone 1, phone 2, Username, password (hidden)

Notes or text fields.

Reset password

System parameters

Supplier –

Customer – end user

Bank Account – end users account for SECURE transactions

Suppliers:

List of suppliers and their details (name, phone number, address, email,

*Select a supplier to edit its details –

*Note that once user adds/edits removes an entry to/from the table the table is updated with the new entry details using Ajax (or similar) no full page reloading!

Table of suppliers is ordered by supplier name ,pressing any of the table headers the table will be sorted by that column. Pressing the header again will change the sorting order (ASC <-> DESC). filter the table by each field (enter a partial name and get all supplier with this part in their names etc).

the table to have paging options

Print the suppliers table (choose to print current page only or all pages). At the top of the printed page the filter fields will be printed with the table title.

A possibility to export all pages (according to filter fields) to Excel format

Note that the combination of floating blocking DIV and Sort able Table with Paging can cause situations such as edit a row and the new row values mean the row location has changed (due to sorting)

Bank Accounts

List (table) of bank accounts and their details (name, branch number, account number, credit) – list is a Searchable, Sort able Table with Paging.

Add/remove/edit bank accounts

Printing and export to Excel options.

Administration Server Side

Customers

Admin module for opening user accounts.

Get Customer List (page, sort column, sort order, name, phone,) that returns a SQL result set with list of customers (returns specified page sorted in specified way and filtered by specified fields)

List (table) of customers and their details (similar to suppliers) – list is a Searchable, Sort able Table with Paging.

Customers class with functions:

Add(name, phone, address…) to add a customer

Delete(id)

Update(…)

Info array that holds all current customer properties

Option to block user (block access, but keep data in database),

Block date, block reason

Add, remove, edit customers (using floating blocking DIV)

Printing and export to Excel options.

Managing (add/edit/remove) various types of payments (income/expense):

Customer Invoices –invoices to customers.

Customer Payments – this is the part we actually get the money

Utility Invoices -

Utility Payments

Monthly Regular Incomes –

Monthly Regular Expenses –

All pages show lists (tables) of the relevant data ( invoice date, payment amount, customer name, payment method etc). List is a Searchable, Sort able Table with Paging. There should be possibility to add/remove/edit records and customer/supplier/bank account using floating blocking DIV and printing and export to Excel options.

Reports. (Also available to client)

Reports have filter fields (4-5 fields per report, such as customer name or invoice/payment date etc). Depending on the type of report, the result may be displayed in a sort able table with paging or as several tables grouped by a report property (such as customer name). Reports can be printed or exported to Excel.

1) Detailed payments report – shows all payment (income/expenses of any type). In this page it is possible to change the payment date for any record (the change will take affect only after pressing the update button on the page) Get Detailed Payment Report ( page, sort column, sort order, start date, end date…) returns a SQL result set with list of all payment (income/expenses of any type).

2) Grouped payments report – shows all payments (expenses of any type)

3) Historical Annual Comparison by t imeperiod report

GRAPHS

1) Grouped payments report

2) Historical Annual Comparison by month report

Taidot: .NET, AJAX, tietojärjestelmäarkkitehtuuri, SQL, Visual Basic

Näytä lisää: ajax access filter, tracking expenses, visual basic net array, visual basic cost, utility gui, types of income in accounting, types of graphs and their names, types of expenses in accounting, types of data graphs, types of data entry fields, types of audit, types of ajax, types of accounts in accounting, types of account in accounting, type of graphs, type of accounting system, type of account in accounting, type name for design, top statistics, top graph, top 10 data entry company, test data creation, test bank for accounting, t accounts in accounting, t accounts accounting

Tietoa työnantajasta:
( 14 arvostelua ) Toronto, Canada

Projektin tunnus: #519423

34 freelanceria on tarjonnut keskimäärin 933 $ tähän työhön

krishdts

please check PMB for details.

600 $ USD 30 päivässä
(37 arvostelua)
8.1
yousefla

Hi, Would be glad to help. Please contact me by PM to discuss your project further. Best Regards, Yousef

1000 $ USD 10 päivässä
(65 arvostelua)
7.2
expertMan

revised bid.

1500 $ USD 30 päivässä
(24 arvostelua)
6.1
agstech123

Hi, please check PMB to know more about our technical expertise and capabilities. Regards

3500 $ USD 45 päivässä
(3 arvostelua)
5.3
Mitj

Hi, Please check your PM.

750 $ USD 14 päivässä
(2 arvostelua)
4.9
khawaja83

I have more than 3+ years experience in web development in dotnet technologies including aspdotnet, ajax framework, dotnetnuke and mvc dotnet in both C# and Vb dotnet by using 2.0 and 3.5 framwork. I have worked in alm Lisää

750 $ USD 15 päivässä
(5 arvostelua)
4.6
ddInfotech

Dear Sir, Our Company, D-Sys Data Solutions is a leading consulting and IT services company. The company is registered under Indian Company Law and established well. We have an excellent team of young, energetic, qual Lisää

750 $ USD 30 päivässä
(2 arvostelua)
4.1
refractocd

Please refer to PM

750 $ USD 15 päivässä
(13 arvostelua)
4.0
johnsupakin

Hi, I've experience in similar projects. Thanks, John

950 $ USD 30 päivässä
(3 arvostelua)
3.6
padang

please read my pmb

750 $ USD 20 päivässä
(6 arvostelua)
3.7
oespik

Please check PM.

1100 $ USD 60 päivässä
(1 arvostelu)
3.2
poojapatel22

Please check PMB for technical details.

750 $ USD 25 päivässä
(2 arvostelua)
1.8
pranag

Hi, I have professional experience doing the same. We have a list of clarifications to be made on the requirements that you have given. Please PM if you are interested in assigning us this project About Us: We a Lisää

500 $ USD 45 päivässä
(1 arvostelu)
1.4
aanshisolution

Sir, Thanks for really a good [url removed, login to view] project seems to be a inventory system with order and billing tracking and transaction management system with extended security. We are already experienced in such things and Lisää

700 $ USD 25 päivässä
(0 arvostelua)
0.0
sushantmanchanda

I have a vast experience in working in billing and accounting softwares .So please give me a try.

500 $ USD 20 päivässä
(0 arvostelua)
0.0
bhuvantrivedi

Hello, It would be a pleasure to work on your project. Regards, John

2500 $ USD 45 päivässä
(0 arvostelua)
0.0
greentree

About Us: At GREENTREE we bring together collaborative energies across organizations to conceive, build and manage innovative business solutions that add value to our clients. We do this with unbounded energy, enthu Lisää

475 $ USD 30 päivässä
(0 arvostelua)
0.0
goralpujara19

I have developed software which can handle all type of purchase ,sale , sale return, purchase return , General Voucher, Bank entry, Cash entry types of transactions. It has module for production unit in which entry can Lisää

250 $ USD 120 päivässä
(0 arvostelua)
0.0
sailu52cw

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

250 $ USD 2 päivässä
(0 arvostelua)
0.0
yousufkhan85

Please Check PM

300 $ USD 15 päivässä
(0 arvostelua)
0.0