
Closed
Posted
Paid on delivery
Project Overview We require a custom-built financial management platform, similar in flexibility to Microsoft Excel, but structured, automated, secure, and purpose-built for our business operations. The system must handle: Sales income Non-sales income Expenses VAT calculations Running balances Monthly summaries Client invoicing This is a bespoke internal accounting system, not linked to Xero, QuickBooks, or Sage. Key Objective To replace complex spreadsheets with a controlled, formula-driven financial system that: Automatically calculates totals, VAT, balances Prevents accidental formula changes Allows structured data entry Generates reports and invoices Provides month-by-month financial visibility Core Modules & Features 1. -Sales / Income Entry Module Excel-style table with formulas, containing the following fields: Date Inflow Type (Sale / Non-Sale) Client Name Invoice Number Security Box Number Box Size Duration of Box Rental Payment Method Gross Amount VAT (auto-calculated if applicable) Net Amount Key Deposit Sale Amount (excluding key deposit) Non-Income Amount (if applicable) Automatic Calculations Running balance Total sales Total non-income VAT per transaction Total VAT Total key deposits 3- Expenses Module Separate structured table for expenses: Date Financial Month Invoice Number Payee Payee Category (dropdown) Payment Method Receipt (Yes / No) Receipt Number (if Yes) VAT Applicable (Yes / No) Gross Amount VAT Amount (auto) Net Amount Automatic Calculations Running balance by category Total expenses VAT totals on expenses Monthly expense totals 4-Running Balances & Controls Continuous running balance across: Sales Expenses Key deposits Locked formulas (users cannot overwrite calculations) Editable entries only in permitted columns Optional role-based permissions (Admin vs Staff) 5- Summary & Reporting Dashboard A Summary Page showing: Month-by-Month Breakdown Total Sales Total Expenses Gross Income Net Income VAT Collected VAT Paid Total VAT Liability Total Key Deposits Held Filters By month By client By payment method By category 5- Invoice Generation for Clients Generate printable client invoices from sales entries Auto-populate: Client name Invoice number Box number & size Rental duration Sale amount VAT Total payable PDF export Invoice numbering logic required Technical Expectations Spreadsheet-like interface with formulas Cloud-based Secure data storage Export to PDF / Excel Print-friendly reports Backup & restore facility Audit trail preferred Important Notes This is not standard accounting software Must be custom-built around our workflow Accuracy and reliability are critical VAT logic must be correct and adjustable System must be scalable What to Include in Your Proposal Experience building financial or accounting systems Example dashboards or spreadsheet-style systems Suggested tech stack Timeline and milestones Fixed cost or phased pricing Support & maintenance options Budget Open to discussion based on experience and solution quality. Next Steps Shortlisted developers will be invited to discuss: Exact formulas VAT rules Invoice layout Permissions and controls PLEASE NOTE : Submit your one time best quote only- Do not submit a lower quote to attract attention and then increase it later. Your enquiry will be ignored completely .
Project ID: 40249923
102 proposals
Remote project
Active 3 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
102 freelancers are bidding on average £206 GBP for this job

Hello, Drawing on our extensive experience as a leading web service provider, we would be the perfect fit for your custom Excel-style finance system project. Having developed countless complex yet user-friendly systems, we have sharpened our skills and knowledge in PHP to create purpose-built solutions that cater specifically to our client's unique needs. Transforming your data-heavy spreadsheets into a structured, automated, and highly secure financial management platform is right within our expertise. Our quintessential skills in building tailored accounting systems perfectly align with this project's core objectives - automating calculation processes, preventing accidental formula changes, structured data entry, generating reports & invoices, and providing month-by-month financial visibility - all of which are key requirements you seek. Our proficiency will walk hand-in-hand with your strategy to replace those error-prone spreadsheets with a controlled and formula-driven financial management system that offers more than just standard accounting software but a solution intertwined intricately with your workflow. We are technically equipped to provide you with a spreadsheet-like interface that mimics familiar Excel functions and assure you of our ability to handle cloud-based infrastructure that store your critical data securely. We also have backup & restore mechanisms in place to avoid loss of any information. Following best-pra Thanks!
£150 GBP in 1 day
8.6
8.6

As a highly experienced Full stack developer with over 7 years in the field, a significant part of my expertise lies in tailoring systems like yours to suit specific business operations. I understand how critical accuracy and reliability are, especially for a financial management platform, and you can count on me to build one that eliminates the use of complex spreadsheets while ensuring automated accuracy. Notably, my extensive proficiency in Excel Formulas, VBA, Macros, and database analysis aligns perfectly with your project requirements. I am adept at working with structured data entry, formula-driven calculations, generating invoices and reports that provide clear financial visibility. I can utilize these skills to create an interface like Excel but with fortified formulas and space for only permissible entries according to role-based permissions. Sincerely, Sandeep (Digital Screencast) CEO & Founder
£220 GBP in 4 days
8.7
8.7

Hey there, Your need for a robust, Excel-style finance system that streamlines your internal accounting while locking down accuracy and security perfectly aligns with the solutions I've crafted before. I've built custom financial management platforms featuring complex VAT calculations, controlled formula fields, detailed reporting dashboards, and scalable cloud architectures tailored to business workflows. I’d approach your project by developing a secure, cloud-based, spreadsheet-like interface with locked formulas, dynamic running balances, and printable client invoice generation, all fine-tuned around your specified modules. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Looking forward to your reply so we can finalize the exact plan. Could you please share more details on your preferred tech stack or any existing infrastructure you'd like integrated with this finance system? Thanks, Asad
£150 GBP in 1 day
8.2
8.2

As an experienced data analyst and an expert in Excel, I feel uniquely qualified to tackle your custom Excel-style finance system project. Having successfully delivered similar projects in the past, I understand the intricacies and demands of a bespoke accounting system. My proficiency in PHP enhances my ability to create complex, automated calculations while ensuring data security. My track record for building organized, formula-driven systems that minimize the risk of accidental modifications could prove invaluable for your organization's needs. You need not worry about leaving your previous spreadsheet environment; I will incorporate it into a more structured and user-friendly system. Finally, my skills extend to generating customized analytic reports, which aligns perfectly with your need for month-by-month financial visibility. Furthermore, I can provide you with on-going support and maintenance upon completion. Choose me as your freelancer and get ready for a seamless transition from spreadsheet chaos to an efficient, controlled financial management platform tailored precisely around your company’s unique workflow.
£135 GBP in 1 day
7.7
7.7

Warm greetings! I specialize in building custom financial management platforms with 9+ years of experience in PHP, Excel-style automation, and secure cloud solutions. I understand you need a structured, automated system to replace complex spreadsheets while ensuring accuracy, VAT compliance, and scalable reporting. Here’s how I can help: * Develop spreadsheet-like tables for sales, non-sales income, and expenses with locked formulas * Automate running balances, VAT calculations, and monthly summaries * Build summary dashboards with month-by-month breakdowns and filters * Generate client invoices with auto-populated fields and PDF export * Implement role-based permissions, audit trails, and secure cloud storage Can you clarify your preferred tech stack for the cloud deployment and whether mobile access is required?
£135 GBP in 7 days
7.5
7.5

With my extensive experience in finance, accounting, and data analytics, I am confident in developing the tailored financial system your business requires. I have a profound understanding of Excel and Google Sheets, enabling me to create flexible and automated financial solutions that mimic their functionality while elevating it to a whole new level. I will ensure your bespoke system accurately handles sales income, non-sales income, expenses, VAT calculations, running balances, monthly summaries, and client invoicing. My proficiency in financial planning and analysis will be invaluable in eliminating formula errors while ensuring accurate calculation of VAT and running balances throughout the system. Besides meeting your technical expectations - from the spreadsheet-like interface to cloud-based storage with a backup and restore facility - I offer to build you a secured system with export features to both PDF and Excel. As an added value, we can incorporate an audit trail for enhanced reliability. To further reassure you in choosing me: I offer free consultations and demonstrations to give you a glimpse of what I can do for your finance department. Rest assured that by selecting me as your developer, you are not only getting my expertise but also my unwavering commitment to exceed your expectations in achieving the desired results.
£200 GBP in 4 days
7.9
7.9

Hello, I’m reaching out from Smart Sols, where we specialize in custom software development with over 9 years of experience in full-stack solutions. We understand you're seeking a highly flexible, Excel-style financial management platform. Our expertise in Laravel and Vue.js, complemented by UI/UX design via Figma, uniquely positions us to deliver a robust and user-friendly system tailored to your specific financial management needs. We emphasize clean architecture and scalability, ensuring your platform grows alongside your business. We are confident in delivering a polished, custom-built solution that matches the flexibility and intuitiveness of Excel, adapted specifically for financial workflows. Looking forward to discussing your exact requirements and starting a successful collaboration!
£500 GBP in 20 days
6.9
6.9

Hi, As per my understanding: you need a cloud-based, Excel-style financial system with locked formulas, automated VAT, running balances, invoice generation, role controls, and reporting dashboards—fully custom to your workflow, not tied to third-party accounting tools. I’m a full stack developer focused on structured financial systems. I will share my portfolio on your first message. Implementation approach: • Design secure cloud architecture with role-based access • Build spreadsheet-like UI with protected calculation engine • Implement VAT logic, balances, and reporting dashboard • Develop invoice PDF module with audit trail and backups Queries: • Preferred cloud provider or open to suggestion? I will be looking forward to hearing from you. Kindest regards
£750 GBP in 20 days
6.9
6.9

This is a well-defined spec and the modules map cleanly to a database-backed web app. I have built similar internal finance systems for UK businesses. For the tech stack I would use Laravel (PHP) on the backend with Vue.js on the front-end, rendered as a spreadsheet-style interface using AG Grid (which gives you Excel-like editing, locked cells, formula display, row/column freezing). MySQL for storage with proper audit trail (every change logged with user + timestamp). For your specific modules: - Sales/income table: all fields you listed, with VAT auto-calc (20% or exempt toggle per row), running balance updated in real time - Expenses: category dropdown from admin-managed list, receipt tracking, VAT split - Locked formulas: calculated columns are read-only at the DB level, not just UI-level - Summary dashboard: monthly P&L, VAT liability (collected vs paid), key deposits held - all driven by DB aggregation not client-side formulas - Invoice PDF: generated via a template with your branding, auto-numbered, exportable Role permissions: Admin (full edit + settings) vs Staff (data entry only in permitted columns). Ready to discuss exact VAT logic and invoice layout. Can provide examples of similar builds. - Usama
£220 GBP in 21 days
6.6
6.6

This project is exactly the kind of custom financial system we build. Clearly understood the project. We can create a secure, cloud-based platform with a spreadsheet-style interface that automates calculations, enforces data integrity, and streamlines your workflow. Key capabilities: Sales & Income: structured entries, auto VAT, running balances, locked formulas Expenses: categorized tracking, automatic calculations, monthly and VAT summaries Dashboard & Reports: month-by-month financials, filters, gross/net income, key deposits Invoice Generation: auto-populated, PDF-ready, print-friendly, correct VAT and numbering Controls & Security: role-based permissions, editable fields only, backups, audit trail The system will replace complex spreadsheets with an accurate, automated, and scalable solution tailored to your needs. Could you share your expected volume of monthly transactions and number of users so we can design the system to scale perfectly and provide a precise fixed quote?
£250 GBP in 7 days
7.1
7.1

Hi there, I appreciate the opportunity to assist with developing your custom financial management platform. With over 5 years of experience in building tailored accounting systems and a proven track record of successfully automating financial processes, I am confident in delivering a solution that meets your needs. My approach will follow these key steps: 1. **Requirements Gathering**: Deep-dive sessions to finalize your specific needs, especially on VAT rules and formula accuracy. 2. **Design & Development**: I'll create an intuitive interface resembling Excel, with robust back-end automation for totals, VAT calculations, and secure entries. 3. **Quality Assurance**: Rigorous testing to ensure reliability and accuracy, with locked formulas to prevent errors. 4. **Implementation**: A phased rollout, monitoring performance and gathering your feedback. 5. **Training & Support**: Comprehensive user training plus ongoing support to adapt the system as your business evolves. By utilizing PHP for back-end development and cloud computing for secure data storage, I'm committed to creating a scalable, user-friendly system. I look forward to discussing the project further and how we can tailor this solution to your workflows. Thanks, Luis
£150 GBP in 1 day
6.3
6.3

Hello, I have over 7 years of experience in Excel, Accounting, and Data Entry. I have carefully read the requirements for the custom-built financial management platform you need. To fulfill the project, I propose to create a structured and automated financial system that will handle sales income, expenses, VAT calculations, running balances, monthly summaries, and client invoicing. The system will feature Excel-style tables with formulas for data entry, automatic calculations for running balances and totals, secure data storage, and a summary and reporting dashboard for month-by-month financial visibility. Additionally, I will ensure that the system prevents accidental formula changes, provides structured data entry, and generates reports and invoices accurately. I believe that my experience and expertise make me well-suited for this project. I would like to discuss the project further in chat to understand your requirements in more detail. You can visit my Profile at https://www.freelancer.com/u/HiraMahmood4072 Thank you.
£100 GBP in 2 days
6.4
6.4

Hi, there, as an experienced freelance engineer with expertise in developing custom financial management systems, I am eager to collaborate with you on the creation of a bespoke internal accounting solution tailored to your unique business operations. With a robust background in software architecture, Excel, accounting, and automation, I am well-equipped to address your project requirements efficiently and effectively. ✅ Leveraging my experience in building financial systems, I will develop a user-friendly Excel-style platform that automates calculations, enhances data entry accuracy, generates reports, and provides comprehensive financial visibility. ✅ Implementing a secure cloud-based interface with spreadsheet-like formulas, I will ensure accurate VAT calculations, running balances, and seamless invoice generation for clients. ✅ Utilizing my expertise in PHP and database management, I will create structured modules for sales income, expenses, running balances, summary dashboard, and invoice generation, optimizing your financial management processes. ✅ By adhering to best practices in software development, I will prioritize accuracy, reliability, and scalability in the system, offering secure data storage, export capabilities to PDF/Excel, backup & restore functionalities, and a printable reporting dashboard. ✅ My proposed timeline includes milestone deliveries for each core module and feature, with a fixed cost pricing model to ensure transparency and accountability throug
£150 GBP in 1 day
5.4
5.4

Warm Greetings! I understand you need a custom-built, Excel-style financial system that automates VAT logic, secures formulas, structures all income/expense entries, and generates clear month-by-month financial visibility with invoices. My approach is to design a controlled spreadsheet-like interface with locked formulas, clean entry modules for sales and expenses, automated VAT and running balances, a full reporting dashboard, and PDF-ready invoice generation—all backed by a stable cloud database. One key tip I always follow: build formulas and business rules at the system level, not the UI, ensuring accuracy and preventing accidental overwrites. I look forward to delivering a reliable, scalable finance platform for your workflow, and I wish to get this job. Best regards, Muamer Kaukovic
£100 GBP in 7 days
5.3
5.3

Professional Excel VBA developer ready to do the required. Check samples of previous works and clients' reviews in links, copied below. https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/excel/Excel-Macro-Magic/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
£250 GBP in 7 days
5.3
5.3

Hi, As per my understanding: You need a secure, cloud-based financial management platform that replaces complex spreadsheets with a controlled, formula-driven system tailored to your workflow. It must manage sales, non-sales income, expenses, VAT, running balances, invoicing, and month-wise summaries, while locking formulas, enforcing structured entry, and supporting role-based access. Accuracy, scalability, audit trail, PDF/Excel export, and backup are critical. Implementation approach: I will build a custom web application with a spreadsheet-style UI but logic handled server-side to prevent formula tampering. Core modules will include Income, Expenses, Running Balances, Dashboard, and Invoice Engine with structured data validation and VAT rules configurable. Role-based permissions (Admin/Staff) will restrict editable fields. Automated calculations (VAT, totals, balances, liabilities) will run via tested financial logic. Reports will support filters and PDF/Excel export. Audit logs, backups, and secure cloud hosting will be implemented. Suggested stack: React + Node.js or .NET with secure cloud database. Delivery in milestones: architecture, core modules, reporting, invoicing, testing, deployment. A few quick questions: Do you have fixed VAT percentages or variable rules? Approximate monthly transaction volume? Multi-user simultaneous access required? Preferred hosting provider?
£98 GBP in 5 days
5.5
5.5

With over 50 successful projects under my belt, I am confident in my ability to build the custom Excel-Style finance system you need. My expertise in accounting and automation combined with my capability in data entry, cloud computing and advanced Excel usage makes me an ideal fit for this job. I understand that your goal is not just to create another accounting software, but to have a solution that tailors specifically to your business needs. Building from scratch and creating bespoke systems is a specialty of mine and I can ensure that every element of your workflow is accounted for and automated appropriately. Using spreadsheet style designs along with secure cloud based technology, I will provide you an interface that's highly familiar yet secure from inadvertent formula changes. Data entry will be structured and designed around the fields you’ve provided, while also ensuring robust calculations are in place for running balances, VAT calculations, invoicing etc. Additionally, my PHP skills will greatly help in generating the printable client invoices as per your specific logic requirements.. Lastly, as required by this project I’m ready to discuss the most intricate aspects of VAT logic, exact formulas etc., throughout our timeline. I believe that working together closely on those elements would be vital in getting accurate res
£60 GBP in 1 day
5.0
5.0

I can build this secure financial platform using React and Node.js. To get that "Excel-style" feel, I will use a specialized web grid component that allows fast data entry but keeps your formulas locked and safe from accidental changes. I have built similar internal tools that handle VAT logic and generate PDF invoices automatically. Do you have a specific hosting provider (like AWS or a VPS) in mind for this?
£250 GBP in 7 days
4.8
4.8

Hi, I’ve read your brief closely and can build a secure, cloud-hosted, spreadsheet-style financial system tailored to your box-rental workflow. I have experience designing formula-driven ledgers, locked-calculation sheets, role-based controls and PDF invoice generation. I’ll implement structured Sales and Expenses modules with auto VAT, running balances, monthly summaries, filters, printable invoices with numbering, export/backup, and an audit trail. Technically I propose a web app (React front end for Excel-like tables, PHP/Laravel or Node for backend, MySQL/Postgres, PDF library for invoices). I’ll enforce locked formula columns, editable inputs only, configurable VAT rules, and role permissions. Delivery in phases: core data entry & calculations, reporting/dashboard, invoice generation, then testing and handover. Planned next step: a 1-week discovery to lock formulas and invoice layout, then development. Which VAT rules and invoice numbering convention do you currently use (e.g., VAT rates, inclusive/exclusive pricing, sequential numbers), and are there any clients with special billing exceptions? Thanks, Daniel
£150 GBP in 1 day
4.8
4.8

Hi, I understand you're looking to replace complex spreadsheets with a custom-built financial management platform. This is a significant challenge that requires precision and expertise, particularly for handling sales income, expenses, VAT calculations, and automated reporting. With over 6 years of experience developing tailored financial systems, I specialize in creating secure, scalable platforms that ensure accurate formula-driven calculations while preventing accidental changes. My approach will involve designing a detailed Excel-style interface with locked formulas, allowing for easy data entry while maintaining the integrity of your financial data. I'll incorporate modules for income and expenses, continuous running balances, and a comprehensive dashboard for month-to-month visibility, all cloud-based for secure access. This must meet your need for accuracy, reliability, and automated functionalities. Thanks, Zeeshan
£20 GBP in 1 day
4.4
4.4

BATLEY, United Kingdom
Payment method verified
Member since Jul 12, 2017
£20-250 GBP
£20-250 GBP
£250-750 GBP
£20-250 GBP
£20-250 GBP
$10-30 USD
₹750-1250 INR / hour
$25-50 CAD / hour
$10-30 USD
$250-750 CAD
₹750-1250 INR / hour
₹400-750 INR / hour
₹750-1250 INR / hour
$30-250 USD
₹12500-37500 INR
£250-750 GBP
$250-750 USD
₹5000 INR
₹1000000-2500000 INR
₹750-1250 INR / hour
$30-250 USD
₹12500-37500 INR
₹600-1500 INR
$2-8 USD / hour
$78 USD / hour