Spaces:
Running
Running
| <html lang="pt-BR"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Relatório de Conciliação Bancária Park Poente / Ápice - Q2/2025</title> | |
| <script src="https://cdn.tailwindcss.com"></script> | |
| <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css"> | |
| <style> | |
| .fade-in { | |
| animation: fadeIn 0.5s ease-in-out; | |
| } | |
| @keyframes fadeIn { | |
| from { opacity: 0; transform: translateY(10px); } | |
| to { opacity: 1; transform: translateY(0); } | |
| } | |
| .chart-container { | |
| height: 300px; | |
| } | |
| @media (max-width: 768px) { | |
| .chart-container { | |
| height: 200px; | |
| } | |
| } | |
| </style> | |
| </head> | |
| <body class="bg-gray-50 font-sans"> | |
| <div class="container mx-auto px-4 py-8 max-w-6xl"> | |
| <!-- Header --> | |
| <header class="bg-blue-700 text-white rounded-xl shadow-lg p-6 mb-8 fade-in"> | |
| <div class="flex flex-col md:flex-row justify-between items-center"> | |
| <div class="mb-4 md:mb-0"> | |
| <h1 class="text-2xl md:text-3xl font-bold">Relatório de Conciliação Bancária - Park Poente </h1> | |
| <p class="text-blue-100">Trimestre: Abril - Junho 2025</p> | |
| </div> | |
| <div class="bg-white text-blue-700 rounded-lg p-3 shadow-md"> | |
| <div class="flex items-center"> | |
| <i class="fas fa-calendar-alt mr-2 text-xl"></i> | |
| <div> | |
| <p class="font-semibold">Período Analisado</p> | |
| <p>01/04/2025 - 30/06/2025</p> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </header> | |
| <!-- Summary Cards --> | |
| <div class="grid grid-cols-1 md:grid-cols-3 gap-6 mb-8"> | |
| <!-- April Card --> | |
| <div class="bg-white rounded-xl shadow-md overflow-hidden fade-in hover:shadow-lg transition-shadow duration-300"> | |
| <div class="bg-green-600 text-white px-6 py-3"> | |
| <h2 class="font-bold text-lg flex items-center"> | |
| <i class="fas fa-chart-line mr-2"></i> Abril 2025 | |
| </h2> | |
| </div> | |
| <div class="p-6"> | |
| <div class="flex justify-between items-center mb-4"> | |
| <div class="text-gray-600">Total Gastos</div> | |
| <div class="text-2xl font-bold text-green-600">R$ 1.917.692</div> | |
| </div> | |
| <div class="mb-4"> | |
| <h3 class="font-semibold text-gray-700 mb-2">Maiores Gastos:</h3> | |
| <ul class="space-y-1"> | |
| <li class="flex justify-between"> | |
| <span>Mão de Obra Terceiros</span> | |
| <span class="font-medium">R$ 468.362</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Diversos</span> | |
| <span class="font-medium">R$ 298.584</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Imóveis</span> | |
| <span class="font-medium">R$ 148.495</span> | |
| </li> | |
| </ul> | |
| </div> | |
| <div class="text-sm text-gray-500"> | |
| <i class="fas fa-info-circle mr-1"></i> Representa 24.4% do total trimestral | |
| </div> | |
| </div> | |
| </div> | |
| <!-- May Card --> | |
| <div class="bg-white rounded-xl shadow-md overflow-hidden fade-in hover:shadow-lg transition-shadow duration-300"> | |
| <div class="bg-blue-600 text-white px-6 py-3"> | |
| <h2 class="font-bold text-lg flex items-center"> | |
| <i class="fas fa-chart-bar mr-2"></i> Maio 2025 | |
| </h2> | |
| </div> | |
| <div class="p-6"> | |
| <div class="flex justify-between items-center mb-4"> | |
| <div class="text-gray-600">Total Gastos</div> | |
| <div class="text-2xl font-bold text-blue-600">R$ 1.299.008</div> | |
| </div> | |
| <div class="mb-4"> | |
| <h3 class="font-semibold text-gray-700 mb-2">Maiores Gastos:</h3> | |
| <ul class="space-y-1"> | |
| <li class="flex justify-between"> | |
| <span>Mão de Obra Terceiros</span> | |
| <span class="font-medium">R$ 341.597</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Imóveis</span> | |
| <span class="font-medium">R$ 145.976</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Revestimento</span> | |
| <span class="font-medium">R$ 108.545</span> | |
| </li> | |
| </ul> | |
| </div> | |
| <div class="text-sm text-gray-500"> | |
| <i class="fas fa-info-circle mr-1"></i> Representa 16.5% do total trimestral | |
| </div> | |
| </div> | |
| </div> | |
| <!-- June Card --> | |
| <div class="bg-white rounded-xl shadow-md overflow-hidden fade-in hover:shadow-lg transition-shadow duration-300"> | |
| <div class="bg-purple-600 text-white px-6 py-3"> | |
| <h2 class="font-bold text-lg flex items-center"> | |
| <i class="fas fa-chart-pie mr-2"></i> Junho 2025 | |
| </h2> | |
| </div> | |
| <div class="p-6"> | |
| <div class="flex justify-between items-center mb-4"> | |
| <div class="text-gray-600">Total Gastos</div> | |
| <div class="text-2xl font-bold text-purple-600">R$ 1.393.147</div> | |
| </div> | |
| <div class="mb-4"> | |
| <h3 class="font-semibold text-gray-700 mb-2">Maiores Gastos:</h3> | |
| <ul class="space-y-1"> | |
| <li class="flex justify-between"> | |
| <span>Mão de Obra Terceiros</span> | |
| <span class="font-medium">R$ 364.719</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Empréstimos</span> | |
| <span class="font-medium">R$ 297.739</span> | |
| </li> | |
| <li class="flex justify-between"> | |
| <span>Esquadrias Alumínio</span> | |
| <span class="font-medium">R$ 95.617</span> | |
| </li> | |
| </ul> | |
| </div> | |
| <div class="text-sm text-gray-500"> | |
| <i class="fas fa-info-circle mr-1"></i> Representa 17.7% do total trimestral | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!-- Charts Section --> | |
| <div class="grid grid-cols-1 lg:grid-cols-2 gap-6 mb-8"> | |
| <!-- Monthly Totals Chart --> | |
| <div class="bg-white rounded-xl shadow-md p-6 fade-in"> | |
| <h2 class="text-xl font-bold text-gray-800 mb-4 flex items-center"> | |
| <i class="fas fa-money-bill-wave mr-2 text-green-500"></i> Totais Mensais | |
| </h2> | |
| <div class="chart-container"> | |
| <canvas id="monthlyTotalsChart"></canvas> | |
| </div> | |
| <div class="mt-4 text-sm text-gray-600"> | |
| <p>O mês de abril apresentou o maior volume de gastos, com uma redução significativa em maio (-32.3%) e uma leve recuperação em junho (+7.2% em relação a maio).</p> | |
| </div> | |
| </div> | |
| <!-- Expense Distribution Chart --> | |
| <div class="bg-white rounded-xl shadow-md p-6 fade-in"> | |
| <h2 class="text-xl font-bold text-gray-800 mb-4 flex items-center"> | |
| <i class="fas fa-chart-pie mr-2 text-blue-500"></i> Distribuição por Categoria | |
| </h2> | |
| <div class="chart-container"> | |
| <canvas id="expenseDistributionChart"></canvas> | |
| </div> | |
| <div class="mt-4 text-sm text-gray-600"> | |
| <p>A categoria "Mão de Obra de Terceiros" foi a que mais consumiu recursos, representando 25.5% do total trimestral.</p> | |
| </div> | |
| </div> | |
| </div> | |
| <!-- Top Expenses Table --> | |
| <div class="bg-white rounded-xl shadow-md overflow-hidden mb-8 fade-in"> | |
| <div class="bg-gray-800 text-white px-6 py-3"> | |
| <h2 class="font-bold text-lg flex items-center"> | |
| <i class="fas fa-list-ol mr-2"></i> Top 5 Gastos por Mês | |
| </h2> | |
| </div> | |
| <div class="overflow-x-auto"> | |
| <table class="min-w-full divide-y divide-gray-200"> | |
| <thead class="bg-gray-50"> | |
| <tr> | |
| <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Mês</th> | |
| <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Categoria</th> | |
| <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Valor</th> | |
| <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">% do Mês</th> | |
| </tr> | |
| </thead> | |
| <tbody class="bg-white divide-y divide-gray-200"> | |
| <!-- April --> | |
| <tr class="hover:bg-green-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Abril</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Mão de Obra de Terceiros</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 468.362</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">24.4%</td> | |
| </tr> | |
| <tr class="hover:bg-green-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Abril</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Diversos</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 298.584</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">15.6%</td> | |
| </tr> | |
| <tr class="hover:bg-green-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Abril</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Imóveis</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 148.495</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">7.7%</td> | |
| </tr> | |
| <!-- May --> | |
| <tr class="hover:bg-blue-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Maio</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Mão de Obra de Terceiros</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 341.597</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">26.3%</td> | |
| </tr> | |
| <tr class="hover:bg-blue-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Maio</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Imóveis</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 145.976</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">11.2%</td> | |
| </tr> | |
| <!-- June --> | |
| <tr class="hover:bg-purple-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Junho</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Mão de Obra de Terceiros</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 364.719</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">26.2%</td> | |
| </tr> | |
| <tr class="hover:bg-purple-50"> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">Junho</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">Empréstimos</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">R$ 297.739</td> | |
| <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">21.4%</td> | |
| </tr> | |
| </tbody> | |
| </table> | |
| </div> | |
| </div> | |
| <!-- Final Summary --> | |
| <div class="bg-white rounded-xl shadow-md overflow-hidden mb-8 fade-in"> | |
| <div class="bg-indigo-700 text-white px-6 py-3"> | |
| <h2 class="font-bold text-lg flex items-center"> | |
| <i class="fas fa-file-alt mr-2"></i> Resumo Final Trimestral | |
| </h2> | |
| </div> | |
| <div class="p-6"> | |
| <div class="grid grid-cols-1 md:grid-cols-3 gap-6 mb-6"> | |
| <div class="bg-indigo-50 rounded-lg p-4"> | |
| <h3 class="font-semibold text-indigo-800 mb-2 flex items-center"> | |
| <i class="fas fa-coins mr-2"></i> Total Trimestral | |
| </h3> | |
| <p class="text-2xl font-bold text-indigo-700">R$ 4.609.847</p> | |
| <p class="text-sm text-gray-600 mt-1">Soma de todos os gastos nos 3 meses</p> | |
| </div> | |
| <div class="bg-green-50 rounded-lg p-4"> | |
| <h3 class="font-semibold text-green-800 mb-2 flex items-center"> | |
| <i class="fas fa-arrow-up mr-2"></i> Mês com Maior Gasto | |
| </h3> | |
| <p class="text-xl font-bold text-green-700">Abril 2025</p> | |
| <p class="text-sm text-gray-600 mt-1">R$ 1.917.692 (41.6% do trimestre)</p> | |
| </div> | |
| <div class="bg-blue-50 rounded-lg p-4"> | |
| <h3 class="font-semibold text-blue-800 mb-2 flex items-center"> | |
| <i class="fas fa-arrow-down mr-2"></i> Mês com Menor Gasto | |
| </h3> | |
| <p class="text-xl font-bold text-blue-700">Maio 2025</p> | |
| <p class="text-sm text-gray-600 mt-1">R$ 1.299.008 (28.2% do trimestre)</p> | |
| </div> | |
| </div> | |
| <div class="mb-6"> | |
| <h3 class="font-semibold text-gray-800 mb-2 flex items-center"> | |
| <i class="fas fa-chart-line mr-2 text-orange-500"></i> Tendência de Gastos | |
| </h3> | |
| <div class="bg-gray-100 rounded-lg p-4"> | |
| <div class="flex items-center"> | |
| <div class="w-10 h-10 bg-orange-100 rounded-full flex items-center justify-center mr-3"> | |
| <i class="fas fa-arrow-down text-orange-500"></i> | |
| </div> | |
| <div> | |
| <p class="font-medium">Redução de 32.3% de abril para maio</p> | |
| <p class="text-sm text-gray-600">Seguido por aumento de 7.2% de maio para junho</p> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div> | |
| <h3 class="font-semibold text-gray-800 mb-2 flex items-center"> | |
| <i class="fas fa-lightbulb mr-2 text-yellow-500"></i> Principais Observações | |
| </h3> | |
| <ul class="space-y-2"> | |
| <li class="flex items-start"> | |
| <i class="fas fa-check-circle text-green-500 mt-1 mr-2"></i> | |
| <span>A categoria "Mão de Obra de Terceiros" foi a mais significativa em todos os meses, representando em média 25.6% dos gastos mensais.</span> | |
| </li> | |
| <li class="flex items-start"> | |
| <i class="fas fa-check-circle text-green-500 mt-1 mr-2"></i> | |
| <span>Os gastos com "Imóveis" foram relevantes em abril (R$ 148.495) e maio (R$ 145.976), mas não aparecem no top 5 em junho.</span> | |
| </li> | |
| <li class="flex items-start"> | |
| <i class="fas fa-check-circle text-green-500 mt-1 mr-2"></i> | |
| <span>Junho apresentou um aumento significativo em "Empréstimos" (R$ 297.739), que não estava entre os principais gastos nos meses anteriores.</span> | |
| </li> | |
| <li class="flex items-start"> | |
| <i class="fas fa-check-circle text-green-500 mt-1 mr-2"></i> | |
| <span>Os gastos com "Diversos" foram muito expressivos em abril (R$ 298.584), mas caíram drasticamente nos meses seguintes.</span> | |
| </li> | |
| </ul> | |
| </div> | |
| </div> | |
| </div> | |
| <!-- Footer --> | |
| <footer class="text-center text-gray-600 text-sm mt-8"> | |
| <p>Relatório gerado em <span id="currentDate"></span> por Era Digital Gestão Financeira</p> | |
| <p class="mt-1">Para Ápice Incorporadora</p> | |
| </footer> | |
| </div> | |
| <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> | |
| <script> | |
| // Set current date | |
| document.getElementById('currentDate').textContent = new Date().toLocaleDateString('pt-BR'); | |
| // Monthly Totals Chart | |
| const monthlyTotalsCtx = document.getElementById('monthlyTotalsChart').getContext('2d'); | |
| const monthlyTotalsChart = new Chart(monthlyTotalsCtx, { | |
| type: 'bar', | |
| data: { | |
| labels: ['Abril 2025', 'Maio 2025', 'Junho 2025'], | |
| datasets: [{ | |
| label: 'Total de Gastos (R$)', | |
| data: [1917692, 1299008, 1393147], | |
| backgroundColor: [ | |
| 'rgba(22, 163, 74, 0.7)', | |
| 'rgba(37, 99, 235, 0.7)', | |
| 'rgba(124, 58, 237, 0.7)' | |
| ], | |
| borderColor: [ | |
| 'rgba(22, 163, 74, 1)', | |
| 'rgba(37, 99, 235, 1)', | |
| 'rgba(124, 58, 237, 1)' | |
| ], | |
| borderWidth: 1 | |
| }] | |
| }, | |
| options: { | |
| responsive: true, | |
| maintainAspectRatio: false, | |
| scales: { | |
| y: { | |
| beginAtZero: true, | |
| ticks: { | |
| callback: function(value) { | |
| return 'R$ ' + (value / 1000000).toFixed(1) + 'M'; | |
| } | |
| } | |
| } | |
| }, | |
| plugins: { | |
| tooltip: { | |
| callbacks: { | |
| label: function(context) { | |
| return 'Total: R$ ' + context.raw.toLocaleString('pt-BR'); | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }); | |
| // Expense Distribution Chart | |
| const expenseDistributionCtx = document.getElementById('expenseDistributionChart').getContext('2d'); | |
| const expenseDistributionChart = new Chart(expenseDistributionCtx, { | |
| type: 'doughnut', | |
| data: { | |
| labels: ['Mão de Obra Terceiros', 'Diversos', 'Imóveis', 'Empréstimos', 'Outros'], | |
| datasets: [{ | |
| data: [1174678, 298584, 294471, 308257, 2434857], | |
| backgroundColor: [ | |
| 'rgba(220, 38, 38, 0.7)', | |
| 'rgba(234, 88, 12, 0.7)', | |
| 'rgba(234, 179, 8, 0.7)', | |
| 'rgba(22, 163, 74, 0.7)', | |
| 'rgba(20, 184, 166, 0.7)' | |
| ], | |
| borderWidth: 1 | |
| }] | |
| }, | |
| options: { | |
| responsive: true, | |
| maintainAspectRatio: false, | |
| plugins: { | |
| legend: { | |
| position: 'right', | |
| }, | |
| tooltip: { | |
| callbacks: { | |
| label: function(context) { | |
| const label = context.label || ''; | |
| const value = context.raw || 0; | |
| const total = context.dataset.data.reduce((a, b) => a + b, 0); | |
| const percentage = Math.round((value / total) * 100); | |
| return `${label}: R$ ${value.toLocaleString('pt-BR')} (${percentage}%)`; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }); | |
| // Add fade-in effect to elements as they come into view | |
| const fadeElements = document.querySelectorAll('.fade-in'); | |
| const fadeInObserver = new IntersectionObserver((entries) => { | |
| entries.forEach(entry => { | |
| if (entry.isIntersecting) { | |
| entry.target.classList.add('opacity-100'); | |
| fadeInObserver.unobserve(entry.target); | |
| } | |
| }); | |
| }, { threshold: 0.1 }); | |
| fadeElements.forEach(element => { | |
| element.classList.add('opacity-0', 'transition-opacity', 'duration-500'); | |
| fadeInObserver.observe(element); | |
| }); | |
| </script> | |
| <p style="border-radius: 8px; text-align: center; font-size: 12px; color: #fff; margin-top: 16px;position: fixed; left: 8px; bottom: 8px; z-index: 10; background: rgba(0, 0, 0, 0.8); padding: 4px 8px;" |