
Complété
Publié
Payé lors de la livraison
Quiero contar con un archivo de Excel que me permita llevar el estado financiero de un proyecto de construcción de forma clara y 100 % automatizada. Necesito detallar todas las transacciones (no un simple resumen) tanto para el Contrato Principal como para cada Cambio de Orden, e ir viendo en tiempo real cuánto se ha pagado y cuál es el saldo pendiente. Estructura solicitada • Contrato Principal: columnas fijas para “Invoice”, “Monto”, “Fecha”, “Tipo de pago”, “Ref. de cheque” y “Balance”. • Cambios de Orden: misma lógica de columnas, separadas por hoja o por tabla dinámica, pero manteniendo la vista por contrato, tal como marqué en las respuestas. Requisitos clave – El balance debe actualizarse automáticamente con fórmulas; no quiero tener que calcularlo a mano. – Los totales de cada sección y el balance global del proyecto deben quedar visibles en todo momento (puede ser con tablas dinámicas, Power Query o simples SUMIF/SUMPRODUCT, siempre que funcionen). – Filtros y segmentadores para ver pagos por tipo (cheque, efectivo, tarjeta) y para ubicar rápidamente cualquier invoice. – Formato limpio y profesional, listo para imprimir o enviar en PDF si hace falta. Entregable final Un archivo .xlsx funcional y libre de macros bloqueadas, con celdas protegidas únicamente donde sea necesario y con instrucciones mínimas para agregar futuras facturas sin romper las fórmulas.
N° de projet : 40214919
24 propositions
Projet à distance
Actif à il y a 1 mois
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux

Tu archivo de Excel va a funcionar como un sistema financiero completo donde cada factura, cada cheque y cada cambio de orden se actualiza solo, sin tocar una fórmula. → Hoja de Contrato Principal con columnas de Invoice, Monto, Fecha, Tipo de pago, Ref. de cheque y Balance auto-calculado → Hojas separadas por cada Cambio de Orden con la misma estructura, vinculadas al balance global → Dashboard con totales en tiempo real, segmentadores por tipo de pago y filtros por invoice → Protección de celdas en fórmulas, campos de entrada libres, listo para imprimir y exportar a PDF 1000+ proyectos de Excel. 4.7 rating. 100+ reseñas cinco estrellas. Construyo este tipo de herramientas financieras para proyectos de construcción regularmente. ¿Cuántos Cambios de Orden necesitas como punto de partida, y cuántos tipos de pago manejas (cheque, efectivo, tarjeta, transferencia)? Puedo entregar en 5 horas.
$30 USD en 1 jour
5,7
5,7
24 freelances proposent en moyenne $102 USD pour ce travail

Cuento con más de 10 años de experiencia en Excel avanzado, soy VBA Certified, Certified in Business Analytics y tengo un MBA, con amplia experiencia en modelos financieros y control de proyectos. Puedo crear un archivo de Excel totalmente automatizado que registre cada transacción del contrato principal y los cambios de orden, calcule balances en tiempo real, incluya filtros claros y mantenga un formato profesional listo para imprimir o exportar a PDF. Será un gusto ayudarte a tener un control financiero claro y confiable para tu proyecto; quedo atento para empezar cuando quieras.
$70 USD en 1 jour
6,5
6,5

Hi, I have strong experience building automated Excel financial trackers for construction projects, including main contracts and change orders with full transaction-level detail. I’ll design a clean, formula-driven workbook where balances update automatically, totals are always visible, and data can be filtered by invoice or payment type using filters/slicers. No locked macros, no manual calculations—just a reliable, professional file that’s easy to maintain and print or export to PDF. I can deliver quickly and tailor the layout to how you actually work on-site.
$220 USD en 2 jours
6,7
6,7

Hi, there, With over 5 years of experience in Excel, VBA, and financial project management, I am confident in providing you with a customized and fully automated Excel financial statement for your construction project. I will ensure a clear and detailed representation of all transactions, including the main contract and change orders, with real-time payment tracking. ✅ Leveraging my expertise, I will structure the main contract with fixed columns for invoices, amounts, dates, payment types, check references, and balances. The change orders will follow a similar structure, separated by sheets or pivot tables, maintaining a contract-focused view. ✅ Utilizing advanced formulas and functions, I will automate the balance updates to eliminate manual calculations. Totals for each section and the overall project balance will be readily visible using dynamic tables or SUMIF/SUMPRODUCT functions for clarity and efficiency. ✅ Providing filters and slicers, I will enable easy payment tracking by payment type and quick invoice location. The final deliverable will be a functional .xlsx file, unprotected macros, with clear instructions to add future invoices without disrupting formulas. ✅ The format will be professional, clean, and suitable for printing or PDF sharing, meeting your requirements for a visually appealing and user-friendly financial statement. ✅ Proficient in Tableau, Excel VBA, data analysis, and project management, I will ensure a high-quality deliverable that exceeds
$200 USD en 3 jours
5,2
5,2

Hi, I am excited to propose my services for creating an automated Excel file to track the financial status of your construction project with precision and depth. With over seven years of experience in data management and Excel automation, I will ensure that all transactions are meticulously detailed, both for the principal contract and each change order. I will implement dynamic formulas to keep the balance updated and visible in real-time, allowing you to have instant access to essential data without manual calculations. My approach will incorporate clean formatting, intuitive design, and user-friendly instructions for adding future invoices seamlessly. I understand the importance of clear communication and adherence to processes. I will maintain consistent updates throughout the development phase and ensure that any feedback is integrated promptly to meet your expectations. I will organize the financial data in a way that it is easily navigable, utilizing filters and pivot tables as requested. Ensuring the project is delivered on time is my priority, and I am committed to meeting the agreed deadline while providing you with a fully functional and professional Excel file ready for immediate use.
$140 USD en 7 jours
4,9
4,9

Hello There. ⇛My Philosophy is “Quality is never an accident it is always the result of an intelligent effort! Professional Multilingual Service Provider. Given the chance to be in long-term Cooperation! My certifications in QuickBooks, Xero and Advanced Excel ?️, I have acquired the necessary skills to deliver accurate financial reports and reconcile them for you. However, what truly sets me apart is my growth-focused mindset ?, that helps drive strategic decisions by turning data into actionable insights. ▶Expertise and Specialties is? & What Services I Provide? ✔️Excel ✔️DAX ✔️Python ✔️SQL ✔️Tableau ✔️Scraping ✔️PPT ✔️Google-Sheets ✔️Typing ✔️ Web Scraping ✔️Data Extraction ✔️Data collection ✔️Leads ✔️Spreadsheet - Formulas ✔️PDF-MS Expert ✔️power-BI specialist ✔️Functions ✔️Macros ✔️VBA ✔️Dashboards ✔️Graphs ✔️Charts ✔️Pivot tables ✔️Flow charts ✔️ODOO ✔️Data Analysis ✸ Google-sheets ✔️Data Processing ✔️ Please leave a message here in via chat box. Thank You!
$30 USD en 1 jour
4,7
4,7

Hi there, I am A.R.M. MASUD, with a strong data science background. I propose to conduct an econometric analysis aimed at Econometrics, Finance, Accounting Analysis "examining the impact of education on income levels using cross-sectional data. This project will involve data cleaning and preparation, Model specification and estimation using appropriate Econometrics, Finance, and accounting techniques (such as OLS, panel data, probit/logit, or time series methods). Provide visualizations (regression plots, residual plots) and interpret results with diagnostic testing to ensure robustness. The analysis will be performed using statistical software such a SPSS, STATA, R, or Python, and findings will be summarized in a clear, concise report with actionable insights or policy recommendations. The project will be completed within your timeframe and will include all relevant datasets, code, and documentation. https://www.freelancer.com.bd/projects/excel/Finance-Excel-Sheet-Population/reviews https://www.freelancer.com.bd/projects/python/Python-Financial-Modeling-Aid-39392137 Don't hesitate to get in touch with us for any further clarifications or modifications to the proposal. Thanks A.R.M MASUD
$50 USD en 5 jours
4,5
4,5

As a seasoned and versatile full-stack software engineer, I have amassed a wealth of skills and expertise that translate directly into this project. Not only do I possess deep proficiency with Excel for data analysis but I am highly conversant with every aspect of your requested structure. Balancing automation and accuracy, my work will ensure your "Estado Financiero" is crystal clear while entirely thorough, capturing both the "Contrato Principal" as well as individual "Cambio de Orden" transactions. Equipped with advanced knowledge in Excel Macros and VBA, my solutions are always focused on creating maximum efficiency, automation, and a clean UI experience. This aligns perfectly with your requirement for automatic updating of balances, easy viewing of totals and scores by various filters such as payment type, invoice locator, etc. With an eye for detail and a knack for delivering clean professional formats, you can rely on me to provide an executable ultimately ready-to-use .xcd file that maintains functionality while incorporating necessary guidelines to add future invoices without breaking formulas. Pitching myself as the best candidate comes not only from my unparalleled technical skills but also from the strategic deduction that exceptional technology should be concealed behind a seamless user interface.
$100 USD en 7 jours
3,4
3,4

Hello there, As an experienced researcher and data scientist, data analyst, my qualitative analysis skills perfectly align with your job requirements. My profound knowledge of Python and R Studio guarantees fast learning and adaptation to new tools. Moreover, my advanced skills in Excel make me highly competent in handling large datasets efficiently—making me proficient in extracting the best insights from your transcripts. I fully comprehend the importance of working papers and meticulously preparing financial statements, especially within strict timelines. my sharp analytical skills and extensive knowledge of excel ensure that I leave no stone unturned in making sure every detail is covered under evaluation. My passion for quality, originality and meeting deadlines makes me an excellent choice for this project. I cannot wait to prove my extensive skills to you through providing actionable insights that will help guide your decision making regarding domestic charter flights. Best Regards
$30 USD en 1 jour
3,5
3,5

Hey! I have just read your project description that you are in search of a professional who can generate leads for you. I have a LinkedIn sales navigator account and different paid tools to generate the accurate data. I have a lot of experience in this field with over more than 8 years. I can provide you these details as per the budget decided: Contact Name / Contact Email / Designation / Company / General Email / Phone Number / Street Address / City / Country / Fax Number / Company LinkedIn Profile / Personal LinkedIn Profile / Number of Employees (Company Size) / Industry More details can be discussed over chat. Regards.
$100 USD en 2 jours
2,8
2,8

Greetings, It looks like you're looking for a detailed and automated Excel file to manage the financial status of your construction project. I can help you create a clear structure that captures all transactions for the main contract and any change orders, ensuring you can easily track payments and outstanding balances in real-time. My approach would involve setting up fixed columns for invoices, amounts, dates, and payment types that update automatically, so you won't have to do manual calculations. I can implement filters to help you view payments by type quickly and ensure that the overall balance is always visible. Plus, I’ll make sure the design is clean and professional, ready for any presentations or reports. Just to clarify, how do you envision accessing the data for each change order? Would you prefer separate sheets or a consolidated view? Best regards,
$100 USD en 3 jours
0,0
0,0

As a Full Stack Web & Mobile App Developer with 10+ years of experience and knack for delivering high-performing, user-oriented solutions, I'm well-equipped to meet your unique Excel needs. Though my specialization predominantly lies in web and mobile app development, my expertise also encompasses creating bespoke data visualizations in Excel, precisely what your project requires. Having completed over 2000 projects successfully, I'm well-versed with helping clients streamline and automate their processes using advanced formulas, tables, filters, and more in MS Excel. Moreover, as I understand the importance of transparency and accountability in financial matters, I can ensure that every transaction diverse as per contract type be it Principal Contract or Change Orders gets their separate section while maintaining a macro-free, easy-to-use structure.
$60 USD en 7 jours
3,0
3,0

Hey , I just finished reading the job description and I see you are looking for someone experienced in Excel, Excel VBA, Accounting, Payment Processing, Data Analysis, Excel Macros, Project Management, Power BI, Data Visualization and Tableau. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further.
$30 USD en 1 jour
0,0
0,0

Hola, He revisado detenidamente la descripción de tu proyecto y considero que encajo perfectamente con lo que necesitas. Tengo experiencia realizando ingreso manual de datos con alto nivel de precisión, especialmente cuando se trata de valores alfanuméricos sensibles como códigos de producto, IDs y cadenas de referencia, donde cada carácter importa. Estoy totalmente de acuerdo con el enfoque del trabajo: Proceso 100 % manual, sin uso de macros, OCR ni automatizaciones. Respeto absoluto al formato original y a las validaciones existentes en la plantilla de Excel. Atención cuidadosa a los encabezados bloqueados y a las notas de campo proporcionadas. Mi metodología de trabajo incluye: Revisión individual de cada archivo fuente. Copiado y pegado preciso en la celda correspondiente. Verificación visual para minimizar errores. Elaboración de un registro de finalización, donde documentaré cualquier carácter ilegible, duda o discrepancia para que puedas validarlo fácilmente. Soy una persona meticulosa, constante y paciente, cualidades clave para este tipo de tareas repetitivas donde la tasa de error debe ser extremadamente baja. Puedo cumplir con los plazos establecidos y mantener una comunicación clara durante todo el proceso. Quedo atento para comenzar de inmediato y responder cualquier pregunta adicional que tengas. Saludos cordiales, Miguel
$120 USD en 7 jours
0,0
0,0

Puedo crear un archivo Excel totalmente automatizado para llevar el estado financiero de tu proyecto, con seguimiento detallado de todas las transacciones, balances calculados automáticamente, filtros por tipo de pago y totales visibles por contrato y cambios de orden.” Si quieres, puedo hacer 2–3 versiones aún más breves y directas para usar en Upwork o chats rápidos. ¿Quieres que lo haga?
$155 USD en 1 jour
0,0
0,0

Hola, Puedo crear el archivo Excel para el seguimiento financiero de tu proyecto de construcción tal como lo describes, con detalle completo de todas las transacciones, tanto para el Contrato Principal como para cada Cambio de Orden, y con balances que se actualizan automáticamente. Lo que entregaré: Hoja para el Contrato Principal con columnas: Invoice, Monto, Fecha, Tipo de pago, Ref. de cheque y Balance. Hoja(s) separadas para Cambios de Orden, manteniendo la lógica por contrato y balance actualizado en tiempo real. Fórmulas automáticas para calcular balances y totales, visibles en todo momento. Tablas dinámicas y segmentadores/filtros para consultar rápidamente por tipo de pago o invoice. Formato limpio y profesional, listo para impresión o exportación a PDF. Archivo libre de macros, con celdas protegidas solo donde sea necesario, e instrucciones claras para agregar nuevas facturas sin afectar los cálculos. Con este archivo tendrás un control financiero completo y actualizado del proyecto, evitando cálculos manuales y facilitando la toma de decisiones en tiempo real. Quedo a disposición para comenzar y entregar un Excel totalmente funcional según tus necesidades. Saludos, Zary haider
$80 USD en 4 jours
0,0
0,0

Hai, saya seorang freelancer Admin, Data Entry, dan Customer Service yang berfokus pada efisiensi kerja dan kualitas layanan. Saya berpengalaman dalam mengelola data secara akurat, menyusun laporan, serta menangani komunikasi pelanggan dengan sikap yang ramah dan profesional. Baik untuk pekerjaan rutin, proyek jangka pendek, maupun dukungan operasional jangka panjang, saya berkomitmen untuk bekerja secara konsisten, rapi, dan tepat waktu. Tujuan saya adalah menjadi partner kerja yang dapat diandalkan dalam mendukung operasional bisnis Anda. Keterampilan: • Input & validasi data • Pengelolaan dokumen & laporan • Customer service via chat & email • Penggunaan tools administrasi online • Kerja remote & target-oriented
$140 USD en 7 jours
0,0
0,0

Hola, soy Avinash Sinha y puedo entregarte un Excel profesional, claro y totalmente automatizado para el control financiero de tu proyecto de construcción. Diseñaré un archivo detallado por transacción (Contrato Principal y Cambios de Orden), con balances que se actualizan solos, totales siempre visibles y filtros/segmentadores para encontrar cualquier invoice o analizar pagos por tipo. Sin macros bloqueadas, con fórmulas sólidas y un formato limpio, listo para imprimir o enviar en PDF. Recibirás un .xlsx fácil de usar, con celdas protegidas solo donde hace falta y instrucciones mínimas para agregar nuevas facturas sin romper nada. Mi enfoque es práctico, ordenado y pensado para uso real. Listo para empezar cuando quieras.
$150 USD en 2 jours
0,0
0,0

Los Angeles, United States
Méthode de paiement vérifiée
Membre depuis févr. 8, 2026
$10-30 USD
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD
₹15000-25000 INR
£5000-10000 GBP
£20-250 GBP
₹1500-12500 INR
₹1500-12500 INR
₹750-1250 INR / heure
$750-1500 USD
$15-25 USD / heure
$30-250 USD
£250-750 GBP
₹750-1250 INR / heure
₹1500 INR
€8-10 EUR
$10-80 USD
€30-250 EUR
₹1500-12500 INR