Build Accounting & Project Costing Platform

$250-750 USD

Posted 1 minute ago

•

Ends in 6 days

$250-750 USD

Paid on delivery

SOFTWARE DEVELOPMENT BRIEF Integrated Accounting and Project Costing System CLIENT AND PURPOSE Develop a secure cloud-based accounting and project costing system for one South African electrical engineering company. The company manufactures, installs, replaces, repairs and maintains switchgear and related electrical equipment. The platform must replace disconnected spreadsheets and provide one reliable record of company finances, project budgets, purchasing, stock, labour, invoicing and payments. Default currency is South African rand (ZAR), with Africa/Johannesburg as the timezone. PROJECT OBJECTIVES Provide complete double-entry accounting; monitor project cost and profitability; control procurement and stock; allocate labour accurately; issue quotations and invoices; reconcile bank transactions; produce South African VAT and payroll reports; and deliver timely financial information to management. Build a working application with real data persistence, not static demonstration screens. 1. TECHNICAL DESIGN Build a responsive web application for desktop, tablet and mobile. Developers must recommend a documented frontend, backend, relational database, hosting platform and deployment approach. Separate financial posting logic from the user interface. Enforce calculations, permissions and validation on the server. Provide APIs, secure document storage, database migrations, automated tests, monitoring and backups. The first release supports one legal company with multiple users and bank accounts. 2. MANAGEMENT DASHBOARD Display current bank balances, revenue, gross profit, net profit, expenses, receivables, payables, overdue invoices, VAT position, payroll cost, active projects, projects exceeding budget and forecast cash flow. Provide filters by date, customer, project and status. Every figure must link to supporting records. Display project margins and cost overrun alerts without treating unpaid invoices as cash received. 3. GENERAL ACCOUNTING Provide a configurable chart of accounts, general ledger, journals, trial balance, accounts receivable, accounts payable, opening balances, accruals, prepayments, bank and cash accounts, financial period closing and year-end adjustments. Use double-entry accounting and decimal arithmetic for money. Every posted journal must balance. Lock posted records against direct editing or deletion. Correct errors with authorized reversing or adjusting journals. Preserve document references and complete audit histories. 4. CUSTOMERS, QUOTATIONS AND SALES Store customer profiles, contact details, credit terms and account balances. Prepare quotations with item descriptions, quantities, material costs, labour, subcontractors, overheads, markup, discounts and VAT. Support quote revisions, approvals and conversion to projects. Issue branded PDF pro forma invoices, tax invoices, progress invoices, milestone invoices and credit notes. Support partial receipts, allocations, statements, debtor aging, payment reminders and sequential document numbering. Separate invoice issuance, revenue recognition and cash receipt in accounting records. 5. PROJECT SETUP AND TRACKING Assign every job a unique project number. Store project name, customer, site, manager, category, contract value, start and planned completion dates, actual completion date, status, progress percentage, documents and approved budget. Support quotation, approval, procurement, production, installation, testing, commissioning, invoicing and closure stages. Permit approved variations and revised budgets while preserving original baselines. Provide a project register and project-specific dashboards. 6. PROJECT COSTING Track material and electrical component costs, direct labour, overtime, subcontractors, equipment, transport, accommodation, site costs, testing, commissioning, overhead allocations and contingency. Distinguish original budget, revised budget, actual incurred cost, outstanding committed cost, forecast additional cost, estimated final cost and cash paid. Avoid double-counting commitments already invoiced or received. Calculate budget variance, forecast gross profit, gross margin, billed revenue, recognized revenue, collected cash and remaining amounts. Show both project-level and portfolio-level profitability. Allow project managers to update cost-to-complete forecasts subject to approval. 7. ELECTRICAL JOB COSTING Support switchgear panels, circuit breakers, relays, contactors, busbars, enclosures, cabling, testing materials and related components. Create bills of materials for each panel or job. Compare estimated quantities and costs against issued materials and actual labour hours. Record manufacturing, installation, engineering, testing and commissioning hours. Calculate unit cost per panel or assembly and total job cost. Record rework and warranty costs against the relevant project when applicable. 8. PROCUREMENT AND SUPPLIERS Maintain supplier profiles, requisitions, purchase orders, approval thresholds, goods received notes, supplier invoices, credit notes and payments. Link every project-related line to a project and cost category. Support partial deliveries and partial invoices. Match purchase order, receipt and supplier invoice before payment where required. Report outstanding orders, committed costs, supplier balances and overdue accounts. Prevent duplicate supplier invoice posting and record changes to supplier bank details for review. 9. INVENTORY AND MATERIALS Maintain item codes, descriptions, categories, units, locations, quantities, reorder levels, suppliers, purchase costs and documented valuation methods. Support stock receipts, issues, transfers, returns, counts and adjustments. Reserve materials for projects and record actual issue-to-project costs. Reconcile stock balances and inventory ledger values. Do not charge a project twice when an item is purchased into stock and later consumed. Provide inventory valuation and project material consumption reports. 10. EMPLOYEE TIMESHEETS AND LABOUR Maintain employee numbers, roles, departments, employment types, salary or hourly rates and project assignments. Capture dates, start and end times, ordinary hours, overtime, tasks, approvals and project numbers. Allocate time across multiple projects. Distinguish take-home pay, gross payroll cost and fully burdened labour costing rates. Report labour utilization, overtime and actual hours against estimated project hours. Prevent unapproved timesheets from posting to project costs. 11. PAYROLL Support weekly and monthly payroll, basic pay, overtime, allowances, deductions, PAYE, UIF, SDL, leave accruals, payslips and payroll journals. Use versioned statutory tables with effective dates. Produce supporting EMP201, EMP501 and IRP5 information. Restrict payroll access to authorized staff. Require approval and locking before payroll posting. Direct SARS filing is outside initial scope unless a separately approved integration is delivered. 12. BANKING AND RECONCILIATION Support multiple company bank accounts, CSV and OFX imports, duplicate detection, suggested transaction matching, payment allocation, bank fees, transfers and reconciliation statements. Flag unmatched items for review. Require human confirmation where a match is uncertain. Do not present simulated bank connections as live feeds. Design optional bank integration interfaces for later implementation. 13. VAT AND TAX Support standard-rated, zero-rated, exempt, out-of-scope and non-claimable input VAT codes. Provide VAT-inclusive and VAT-exclusive calculations, input and output VAT registers, VAT reconciliations and VAT201 working papers. Configure the company's valid VAT accounting basis and effective-dated tax rates. Retain transaction-level evidence. Export reports for accountant review; do not claim direct SARS submission without an approved connection. 14. FIXED ASSETS AND BUDGETING Provide an asset register with acquisition date, cost, category, useful life, depreciation method, accumulated depreciation and disposal entries. Distinguish fixed assets from consumables. Support annual and monthly budgets, project budgets, forecast revisions and budget-versus-actual comparisons. Record approvals for budget changes and maintain version history. 15. FINANCIAL AND MANAGEMENT REPORTS Produce income statements, balance sheets, cash-flow statements, trial balances, general ledgers, customer aging, supplier aging, VAT reports, inventory valuations, project profitability, project budget variances, labour cost analyses, expense breakdowns and monthly management accounts. Support date comparisons, drill-down and PDF, Excel and CSV exports. All accounting statements must reconcile with the general ledger and relevant subledgers. 16. USER ACCESS AND APPROVALS Provide roles for administrator, managing director, finance manager, accountant, project manager, procurement officer, payroll officer, store controller and read-only auditor. Apply permissions on the server and in the interface. Protect payroll, payment approvals, banking details, journals and period closing. Support configurable approval limits for quotations, purchases, variations and payments. Record approver, time, action and comments. Apply separation of duties to high-risk transactions. 24. IMPLEMENTATION GOVERNANCE Before coding, developers must confirm accounting policies, VAT registration details, financial year-end, chart of accounts, document templates, project categories, inventory valuation policy, labour costing method, approval limits and report formats with management. Supply a sample database and run a walkthrough using one switchgear project from quotation through material purchasing, labour allocation, invoicing, receipt and project closure. Reconcile each step with the general ledger. Document any functionality deferred to later phases. Record sign-off decisions and changes in a shared requirements register. Review scope, costs and timelines before approving development.

Project ID: 40805704

About the project

29 proposals

Open for bidding

Remote project

Active 6 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

29 freelancers are bidding on average $359 USD for this job

User Avatar
Flag of PAKISTAN

Hi, I understand you need a secure cloud-based accounting and project costing system for your electrical engineering company. Your goal is to consolidate multiple processes into one reliable platform, enhancing financial management and project tracking. How I would approach it: - Design a responsive web application tailored for desktop, tablet, and mobile. - Implement double-entry accounting with complete audit trails and document locking mechanisms. - Build a management dashboard with real-time financial insights and project status updates. - Ensure compliance with South African VAT regulations and payroll reporting requirements. I've developed similar applications that integrated multiple functions and improved operational efficiency. Given the complexity, are there specific integrations or existing systems you need this platform to connect with? AnumFatima210

User Avatar
Flag of PAKISTAN

The key to replacing your spreadsheets is making every project cost traceable to a stock movement, approved timesheet, supplier document or ledger entry—without counting the same cost twice. I recommend React for the responsive interface, ASP.NET Core for server-side posting and approvals, PostgreSQL for financial records, and Azure for deployment, document storage, monitoring and backups. I would build the accounting ledger first, then connect procurement, inventory, labour, invoicing and reporting through tested posting rules. Posted entries would be locked; corrections would use authorized reversals, with audit history and role-based access throughout. Before development, I would confirm your accounting policies, VAT basis, inventory valuation, labour costing and approval limits with management and your accountant. I would maintain a requirements and sign-off register, identify any deferred features, and present a phased scope and commercial plan for approval. Acceptance should include a walkthrough of one switchgear job from quotation and bill of materials through purchasing, stock issue, labour, invoicing and receipt, with project margins and every accounting step reconciled to the general ledger. Who will approve the accounting policies and sign off the walkthrough?

User Avatar
Flag of SERBIA

Hi, The real complexity here is not the accounting tables themselves—it's keeping project costs separate from cash flow, so a $100k invoice doesn't look like profit until it's actually paid, and materials bought into stock don't get charged twice when issued to a job. Most accounting builds miss this distinction and end up with numbers that don't reconcile. I'd build this as a Node/React application with PostgreSQL, separating financial posting logic into a backend service layer that enforces double-entry rules, project cost tracking and VAT calculations server-side. The frontend would be responsive across desktop and mobile. I'd start with the chart of accounts, general ledger and bank import, then add project costing, quotations and invoicing in sequence. Each module would be tested against a real switchgear project: quotation through material purchase, labour allocation, invoice issuance, receipt and project closure, with reconciliation back to the trial balance at every step. Before any code, I'd confirm accounting policies, VAT treatment, financial year-end, labour costing method and approval limits with management in a requirements register, then deliver a sample database so the walkthrough is real, not theoretical. Send the current spreadsheets, chart of accounts template and one complete project example and I'll start with the database schema and the general ledger module. Denis

User Avatar
Flag of TURKEY

Hi there, to effectively develop your integrated accounting and project costing system, I would start by selecting a robust framework to support the extensive functionalities described. Given your requirement for a responsive web application and APIs, I recommend using Laravel for the backend, alongside a relational database like MySQL. This approach will ensure solid data integrity, especially with double-entry accounting and detailed project tracking. For the front-end, React would be well-suited to build a dynamic user interface that can handle complex data visualization—like the management dashboard displaying project margins and financial figures. I’m prepared to begin the implementation of your requirements immediately and ensure all calculations and permissions are securely handled on the server side. Regards, Ali

User Avatar
Flag of MALAYSIA

Payroll and project costing in one system is the hard part, most devs just bolt a costing module onto QuickBooks and it breaks the moment job hours need to split across cost centers. I would build this on Node and MySQL with a proper reporting layer for financial analysis, API hooks for data integration. Can start today, working module in 6 to 7 days. Budget and timeline here are rough, based on the brief alone. Once we go through the full scope together these may shift. Want me to send a quick plan?

User Avatar
Flag of PAKISTAN

I understand you're seeking a robust, integrated platform to consolidate your accounting and project costing, moving beyond disparate spreadsheets. My recent work on a similar cloud-based ERP module for a manufacturing firm, which unified inventory, procurement, and financial reporting, directly addresses the need for a single source of truth for complex operational data. I'm confident I can deliver a comparable level of streamlined efficiency for your electrical engineering business. My technical approach will center on a modern, scalable architecture. I propose utilizing a Python/Django backend for rapid development and robust security, coupled with a PostgreSQL database for reliable data integrity. For the frontend, a responsive framework like React will ensure a user-friendly and intuitive interface. Key modules will include integrated project tracking with budget vs. actuals, real-time inventory management, automated invoicing based on project milestones, and comprehensive financial reporting. We'll prioritize API integrations for potential future expansion, ensuring the system grows with your business. To ensure we align perfectly, could you elaborate on any specific reporting requirements for your South African tax regulations? Also, what are your primary concerns regarding data security and access control within the new platform? I'm eager to discuss how my expertise can translate into a powerful, efficient solution for your company. Let's schedule a brief call to explore this further.

User Avatar
Flag of INDONESIA

Hi there, Thank you for sharing such a detailed brief for your integrated accounting and project costing platform. I understand the need to move from siloed spreadsheets to a secure, unified cloud system that delivers reliable, audit-friendly financial and project data. Your requirements for double-entry accounting, robust project costing, procurement, payroll, inventory management, and South African VAT compliance align closely with my experience delivering end-to-end financial platforms for engineering and manufacturing clients. I propose a modular, responsive web application built with a modern front-end (such as React or Angular), a secure backend (Node.js or Django), and a relational database (PostgreSQL) hosted on a scalable cloud platform. All calculations, permissions, and validations will be enforced server-side, ensuring data integrity and auditability. I will separate financial logic from the UI, provide RESTful APIs for integration, and implement comprehensive user roles and approval workflows. My approach includes confirming all company policies and chart of accounts with your management before development, supplying a sample database, and conducting a full walkthrough from quotation to project close—ensuring each step reconciles to the general ledger. I have successfully delivered similar systems with project-specific dashboards, granular cost tracking, payroll, inventory, and statutory reporting, and am committed to clear communication and thorough documentation throughout the process. I look forward to discussing your requirements further and building a reliable solution tailored to your business. Best Regards

User Avatar
Flag of INDIA

For your cloud-based accounting and project costing system, I'll develop a responsive web application with a solid frontend, backend, relational database, hosting, and deployment strategy. The system will separate financial logic from the user interface, enforce calculations and validations on the server, and offer APIs, secure storage, migrations, tests, monitoring, and backups. It'll support one legal entity with multiple users and bank accounts. I'll start by confirming accounting policies, VAT details, year-end, chart of accounts, templates, project categories, inventory policy, labour method, approval limits, and report formats with management. I'll also supply a sample database and run a walkthrough using a switchgear project from quotation through material purchasing, labour allocation, invoicing, receipt, and project closure, reconciling each step with the general ledger. I can start right away.

User Avatar
Flag of PHILIPPINES

Hi there, The hard part is not just creating the accounting system, but ensuring it integrates smoothly with existing processes while maintaining data integrity. The focus should be on building a robust backend that separates financial posting logic from the user interface, ensuring all calculations and validations occur server-side. Using a relational database will facilitate real data persistence and allow for efficient tracking of project costs and profitability. To clarify, how do you envision managing user access and approval workflows for various roles within the system? Looking forward to discussing the details in chat.

User Avatar
Flag of MOLDOVA, REPUBLIC OF

Hello. I understand the need for a cohesive cloud-based accounting and project costing system to streamline operations and replace disparate spreadsheets. A well-integrated platform can significantly enhance financial visibility and project management. One key aspect to focus on is ensuring that the financial posting logic is separate from the user interface, which will enhance security and accuracy. This approach will facilitate real-time data management and reporting. I have previously developed similar systems that not only improved financial tracking but also provided detailed insights into project profitability and resource allocation. My experience with responsive web applications ensures that your platform will be accessible across devices. How do you envision the integration of user roles and permissions to ensure secure access to sensitive financial data? Addressing this will help us align on the best approach for your team. Thanks, Artiom.

User Avatar
Flag of PHILIPPINES

Hello, In my opinion, the problem of this project is that integrating diverse accounting functionalities into a cohesive, secure cloud application is complex and requires meticulous design. I will architect a microservices-based solution, separating the frontend and backend for scalability. The backend will employ a robust relational database to manage data integrity, ensuring double-entry accounting principles are enforced. APIs will be utilized for data flow between modules, and extensive validation will occur server-side to manage edge cases. I will leverage existing frameworks for user authentication while customizing necessary components for financial logic. The deliverable will be a fully functional web application that includes a working prototype demonstrating core functionalities such as project costing, invoicing, and real-time dashboards, all linked to a sample database. I have successfully delivered similar accounting systems with stringent compliance and comprehensive reporting. I can start immediately. Regards.

User Avatar
Flag of UNITED STATES

Hi, I’d recommend starting by documenting the company’s accounting policies, VAT rules and project costing workflows alongside the existing spreadsheets. This ensures the platform aligns with your current processes and avoids misaligned assumptions in double entry logic or tax calculations. We’d then design a modular backend for core functions, general ledger, project costing and procurement, while keeping the UI responsive and role specific, so approvals and reports match your actual approval chains and financial statements. With the foundation set, I’d implement the general ledger, project costing and procurement modules first, using your sample switchgear project to validate journal entries, budget tracking and supplier invoices against the general ledger. Each feature would be tested against the documented policies and reconciled with the trial balance before handover. You’d receive a working application with real data persistence, audit trails and role based access, ready for your team to review and extend with additional modules like payroll or bank reconciliation.

User Avatar
Flag of BAHRAIN

Hello, INTEGRATED ACCOUNTING WITH ACCURATE SWITCHGEAR PROJECT COSTING: I understand you need one reliable platform connecting financial records, project budgets, purchasing, inventory, labour, invoicing and payments, replacing disconnected spreadsheets. Every project cost must be traceable, and financial reports must reconcile with the underlying accounting records. I would propose a modular web architecture with a relational database, secure APIs and server-side financial validation. The foundation would include double-entry accounting, customer and supplier records, quotations, project budgets, cost categories and audit history, using ZAR and the Africa/Johannesburg timezone. I would then connect procurement, stock movements, timesheets, invoicing and bank reconciliation to project costs without double-counting transactions. Permissions, approval workflows, automated tests and reporting would be built into the relevant modules. South African VAT and payroll rules would be confirmed with your accountant before implementation. I would be glad to review your accounting policies and prioritize a practical first release with a complete switchgear-project walkthrough. We can agree on phased deliverables and a realistic programme before development begins. Best regards!

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅