We are a small printing company with several branches. Each branch has it's own set of accounts. We want to build then simple webpage that allows each branch to upload their accounts each month. The page will then allow us to generate graphs to compare financial performance over time within each branch, as well as between branches. The basic features are as follows
Upload page - Users can upload a CSV text file that is exported from our accounting package. It has each account on a separate line with the account number, account name and account balance. For example
1-1100, Printing Income, $1500
There are 5 branches and each text file would have approximate 50-60 accounts.
Each branch uses slightly different names for accounts so branch 1 might use "Shipping" while branch 2 uses "Shipping Paid". The account numbers are slightly different as well. Thus, we need a table that we can edit via the web panel to allow us to link the accounts. This would work by having a set of master accounts and then allowing us to link each entities account to the master account. For example, shipping might be allocated account number 1-1000 and then we link the shipping accounts for each entity to this master shipping account. We need to be able to add new master accounts and link up the accounts. Each account will start with a number designating the account type (ie, asset, liability ,income, expense, cost of goods sold) for reporting purposes.
Each month, the accountant at each branch will export a profit and loss report and a balance sheet from our accounting software into csv text file format. The webpanel will allow them to upload this file and the database will be populated with the values for each account.
We then need to be able to generate a series of reports that compare the accounts within an entity and across entitites. These should be visual (ie, graphs).
Possible reports would be
1. Debt to asset ratio (it, current liabilities / current assets)
2. Sales comparison
3. Gross profit comparison
There will be about 15 reports. For each report we need to be able to look at comparisons month-to-month, quarter to quarter and year to year within each entity, as well as between entities. We will provide the formulas for the reports we want to the winning bidder.
27 freelancers are bidding on average $1221 for this job
Hi,I have been through your initial specs and can build the [url removed, login to view] you like me to design the web pages also?Please let me [url removed, login to view],Bryce
We are a team of highly skilled, qualified, experienced and dedicated developers. We have a vast experience in the web development. We will give you the excellent quality work and desired output.
Hello. We have all necessary skills in this area. we developed some similar projects. We can make it very well. Looking forward to have a good cooperation. Best Regards, Gorasoft.
Hi We have company and we think I can do this job.I have more than 6 years experience in PHP and frameworks, joomla,wordpress,megento ,CAKEPHP [url removed, login to view] can show my [url removed, login to view] you can look my some development project Mere
Sounds like a good step forward for the business. I've created systems like this before (some of them much larger than this) always with impressive feedback on delivery. I've sent a PM with further details.