
Closed
Posted
Paid on delivery
The finance team needs a polished suite of SSRS reports built directly on our SQL Server environment so management can review real-time numbers without wrestling with spreadsheets. The scope centres on financial reporting; three core statements must be delivered: • Profit and Loss Statement • Balance Sheet • Cash Flow Statement Each report should pull from existing SQL tables and views, use parameter-driven filtering (date ranges, entities, departments), and render cleanly in both the SSRS web portal and exported PDF/Excel formats. Solid T-SQL is required for efficient datasets, and the .rdl files have to be structured for easy maintenance in Visual Studio / Report Builder. Deliverables • Optimised queries or stored procedures powering the reports • Three production-ready .rdl files with branding, drill-down where relevant, and subtotal / grand-total logic • Deployment script or step-by-step notes so the DBA can move everything from dev to production without guesswork Acceptance criteria 1. All totals reconcile with source data to the cent. 2. Report execution time stays under five seconds for the last five fiscal years. 3. No hard-coded paths, credentials, or filters—everything must be configurable through parameters or shared data sources. If this sounds straightforward, let’s get the reports into stakeholders’ hands.
Project ID: 40330743
9 proposals
Remote project
Active 28 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹54,491 INR for this job

Hi, I'm excited to propose my services for building a polished suite of SSRS reports tailored to your finance team's needs. My decade of experience ensures that these reports will meet and exceed expectations. The scope includes creating three core financial statements: Profit and Loss Statement, Balance Sheet, and Cash Flow Statement. Each report will pull data from existing SQL tables and views, allowing for parameter-driven filtering such as date ranges, entities, and departments. The .rdl files will be structured for easy maintenance in Visual Studio/Report Builder and will render cleanly both on the SSRS web portal and when exported to PDF or Excel formats. My deliverables include: - Optimized queries or stored procedures that power these reports - Three production-ready .rdl files with branding, drill-down where relevant, and subtotal/grand-total logic - A deployment script or step-by-step notes for the DBA to move everything from dev to production smoothly Acceptance criteria will be met by ensuring: 1. All totals reconcile with source data to the cent. 2. Report execution time remains under five seconds for the last five fiscal years. 3. No hard-coded paths, credentials, or filters—everything must be configurable through parameters or shared data sources. I've developed a robust portfolio that you can review at [https://www.freelancer.com/u/reedsystems]. Let's get these reports into your stakeholders' hands and streamline financial management. Looking forward to collaborating with you.
₹56,300 INR in 40 days
6.4
6.4

Hi, My name is Ali and I am a software engineer and computer scientist with extensive experience in the Microsoft technology stack, specializing in SQL Server 2019, T-SQL optimization, and SSRS report development. I have a proven track record of building complex financial reporting suites that transition manual spreadsheet processes into automated, server-side analytical tools. To deliver a high-performance, production-ready SSRS suite for your finance team, I will focus on the following points: I will develop optimized Stored Procedures with indexed temp tables to ensure your P&L and Balance Sheet datasets execute in under five seconds. I will architect the .rdl files using a "Main Report and Sub-report" logic to allow management to drill down from high-level totals into departmental transaction details. I will design custom Tablix layouts specifically optimized for PDF and Excel rendering, ensuring that page breaks and column headers remain clean during export. I will utilize Shared Data Sources and Expressions to ensure the reports are environment-agnostic and ready for a seamless move from Dev to Production. I have successfully delivered similar financial reporting projects involving consolidated statements and am ready to start on your core datasets immediately. Let me know when we can discuss. Regards, Muhammad Ali Safder
₹56,250 INR in 7 days
5.3
5.3

I am an expert statistician, Research Writer, and data analyst with more than eight years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time series prediction models, working with survey data, conducting marketing analysis, building estimators, and medical analysis. I am a perfect match for your project share other details of the work so I can start working on your project. Will complete task on time.
₹37,500 INR in 3 days
4.2
4.2

Your finance team will face reconciliation nightmares if those SSRS reports pull data without proper transaction locking or if the stored procedures don't handle multi-currency conversions consistently. I've debugged three projects where P&L statements showed different numbers in PDF versus Excel exports because of rounding logic buried in the dataset queries. Before I map the architecture, two questions: Does your SQL Server environment use indexed views for the financial aggregations, or are we querying raw transaction tables that could time out under five years of data? And do your Balance Sheet accounts require inter-company eliminations, or is this single-entity reporting? Here's the execution plan: - T-SQL STORED PROCEDURES: Build parameterized procs with table variables and CTEs to pre-aggregate journal entries, ensuring sub-second execution even across 60 months of transactions while maintaining ACID compliance for real-time accuracy. - SSRS DRILL-DOWN LOGIC: Implement matrix components with visibility toggles so executives can expand from department-level P&L down to GL account detail without generating separate reports, cutting your report count by 70%. - PARAMETER VALIDATION: Configure cascading parameters with default value expressions that prevent users from selecting invalid date ranges or inactive cost centers, eliminating the "blank report" support tickets. - SHARED DATA SOURCES: Structure connection strings in .rds files with Windows Authentication so your DBA can deploy across dev/staging/prod without touching credentials inside 47 .rdl files. - EXCEL EXPORT FORMATTING: Use Tablix properties and page breaks to ensure exported spreadsheets land in separate tabs with preserved formulas, not the usual SSRS mess where everything dumps into one sheet. I've built financial reporting suites for two mid-market manufacturers where audit teams required penny-perfect reconciliation against their ERP systems. Let's schedule a 20-minute call to review your chart of accounts structure and confirm the deployment pipeline before I generate the stored procedures.
₹50,630 INR in 21 days
4.5
4.5

Hello, I have read your job description and I am interested in your job post.I am ready to start now. Please send me a message to discuss more about your project, Can you please give me a chance I am a Senior Software Developer with over 8+ years of experience in designing and developing scalable web and desktop applications. I specialize in Microsoft technologies and delivering high-quality, secure, and performance-driven applications. My Expertise: Backend Development:ASP.NET, ASP.NET Core, MVC, Web API, WebForms, WCF Services Programming Languages:C#, Frontend Development:JavaScript, jQuery, AJAX, HTML, CSS Database Technologies:SQL Server, MySQL Reporting Tools:Crystal Reports, RDLC, SSIS, SSRS
₹37,500 INR in 7 days
3.4
3.4

Hi, I’m Karthik with 15+ years of experience in SQL Server, SSRS, and financial data reporting, and I can deliver accurate, high-performance reports for your finance team. I’ve built enterprise-grade SSRS dashboards and financial statements with strict reconciliation and performance requirements. **Approach:** ✔ Optimized T-SQL (views/stored procedures) for efficient datasets ✔ Clean, maintainable .rdl design in Visual Studio/Report Builder ✔ Parameter-driven reports (date, entity, department) ✔ Shared data sources—no hardcoding **Reports Delivered:** ✔ Profit & Loss Statement ✔ Balance Sheet ✔ Cash Flow Statement **Features:** • Drill-downs, subtotals, grand totals • Branded, clean layouts for SSRS portal + PDF/Excel export • Execution optimized (<5s for multi-year data) **Deliverables:** • Optimized queries/SPs • 3 production-ready .rdl files • Deployment guide/scripts for smooth promotion (dev → prod) I ensure financial accuracy (to the cent), performance tuning, and easy maintainability for future changes. I can start immediately and deliver quickly. Warm Regards, Karthik Resonite Technologies
₹98,740 INR in 7 days
4.1
4.1

Hi, I am looking for a golden opportunity to work with you, Your job is relevant to my skill as I have strong experience in SSRS reporting, SQL Server, and T-SQL optimization, and I understand you need clean, real-time financial reports (P&L, Balance Sheet, Cash Flow). I can fulfil your requirement by creating fully parameterized SSRS reports with efficient queries and proper structure for long-term maintenance. I focus on performance + accuracy, so reports will load under 5 seconds and reconcile perfectly. I will also provide clear deployment steps so your DBA can move it easily to production. Please reply me and lets discuss and start the work. Best regards, Nainsi
₹52,250 INR in 5 days
0.0
0.0

What I would deliver: - SSRS reports matching your specifications, with proper parameterization so end users can filter by date range, department, account, etc. - Clean SQL underneath — optimized queries, not just SELECT * with filters bolted on - Consistent formatting across all reports — headers, footers, page breaks, print-ready - Export working correctly to Excel and PDF (SSRS has quirks here, I know them) - Data visualizations where they add clarity — charts, KPIs, conditional formatting on variances I have built dozens of financial reports in SSRS — P&L, balance sheets, cash flow, budget vs actual, aging reports, you name it. Send me your requirements and sample data structure and I can get started immediately.
₹45,000 INR in 7 days
0.0
0.0

Palakkad, India
Member since Mar 27, 2026
₹750-1250 INR / hour
$750-1500 USD
₹1500-12500 INR
$25-50 USD / hour
$10-30 USD
$25-50 USD / hour
₹1500-12500 INR
$750-1500 USD
₹1500-12500 INR
$30-250 USD
$250-750 USD
₹400-750 INR / hour
₹37500-75000 INR
$250-750 USD
$750-1500 SGD
₹750-1250 INR / hour
$30-250 USD
₹1500-12500 INR
₹600-1500 INR
£20-250 GBP