Construction Accounting Webware [Archive] - Home Construction Forums

PDA

View Full Version : Construction Accounting Webware


Rich
12-20-2003, 05:34 AM
As some of you may know I've been working on an accounting script for construction companies based on job cost controls. This is a little different than say Quickbooks which uses a master chart of accounts.
Anyway I got to coding it up (this will be an online script) the day before yesterday. It looks like it's going to be pretty functional so far. Following is a list of features as far as today (what I'm working on)....
1. Create Jobs
2. Create Accounts within jobs
3. Create Subcontractor / Supplier accounts within jobs
4. Create change order for a job (Prime & Non-Prime)
5. Create information for invoices
6. Pay subcontractors (you still need to write the check)
7. Enter production and labor recap for use in the estimating module
8. Company reporting for all jobs
9. Full installation tool
10. Of course you can edit and list all of the options above.
11. Track retainage for each subcontractor

Future plans...
1. Estimating module that updates itself through the production / labor reporting
2. Auto setup of standard accounts
3. Password protection / authorization - this could turn into a viewable portion by owner
4. Possibly a schedule reporting tool - have to see what programs people use to see about portability
5. Tracking of RFI's
6. Tracking of discrepancies
7. Printing of invoices and checks
8. You tell me - post ideas below that you think would be beneficial

What I have done so far
1. Enter Subcontractor
2. Enter Job Numbers
3. Enter Job Accounts
4. List Job Numbers
5. List Account Numbers for specific job
6. Overall budget features of account listing

I'm currently not releasing anything for anyone to see until I have a few more checks and balances in the code. As soon as I get that I'll give you a link.

Thanks

Rich
12-20-2003, 05:35 AM
Oh.. and as far as cost goes.. tell me what you would pay for this. I have a number in mind but not sure if it sounds greedy or cheap yet. Throw some numbers out there.

grumpydasmurf
12-20-2003, 08:23 AM
Before I can think of a cost... Monthly subscription remotely hosted on your server or single shot they download it and install it?

Rich
12-20-2003, 09:10 AM
Huh.. I never even thought of setting it up on my server. I think that's a very viable solution. That would be a pretty good selling point for some smaller contractors that may not have webspace to host it.. USP maybe?
Excellent recommendation.. I think I'll go that way.
I was thinking about having a local install.. but they would need to setup something like Foxserv to have a local server with php, apache, and mysql. But after your suggestion I think that's the way to go.

Rich
12-24-2003, 08:56 PM
Update..
I've got the following items complete as far as being able to enter the data into the database and list a few of the fields in each. Also for each of the input screens there is a verification of fields entered.
1. Create new job
2. Create new account
3. Create subcontractor
4. Create Prime change order
5. Job List
6. Subcontractor List
7. Change Order List
Next up is editing each of the creation items which will be on the list page or by way of searching for an account. After that I will add in the production estimating modules and give it all a nice wrapper for authorization and adding users.

Rich
01-01-2004, 10:05 PM
I've decided to provide this webware program in coldfusion. I think it's the easiest to program for web applications. It also allows me to interface directly with Excel and Word programs. So far the link below is what I've come up with for a program architecture. Will probably still add a few more modules but it's the basics.

http://www.construction-resource.com/images/projects/CRaccount.jpg

grumpydasmurf
08-08-2004, 08:04 AM
You've really got alot of stuff on your plate. accounting software, bidding spreadsheet, multiple forums, and then your day job... Do you sleep ever?

Rich
08-08-2004, 08:06 AM
Not much on the weekends :)