TR
Advanced Systems

Ferhat Büfe

About The Project

Ferhat Büfe Accounting System: Comprehensive Financial Management and Analysis Platform

Project: Web-Based Accounting and Financial Analysis System
Client: Ferhat Büfe (Adaptable for similar SMEs)
Technologies: PHP (PDO, mysqli), MySQL, JavaScript (jQuery, CanvasJS, ApexCharts, Chart.js, Select2, IMask), Bootstrap 5, HTML5, CSS3, PHPMailer, Dompdf, pChart, Atlantic ID (OAuth 2.0 / OIDC)

At CodeAtlantis, we develop custom software solutions that empower businesses to navigate financial complexities and make informed decisions. Designed for Ferhat Büfe, this web-based accounting system caters to a wide range of SME needs, from daily operations to strategic analysis.

Problem & Solution: Traditional accounting methods or inadequate digital tools often complicate tracking income and expenses, make invoice management cumbersome, and hinder the extraction of meaningful insights from financial data. The Ferhat Büfe Accounting System addresses these challenges with a modern, user-friendly, and powerful web platform. The system consolidates all processes under one roof, from data entry to detailed reporting, inflation analysis, and revenue forecasting.

Key Features:

  1. Comprehensive Financial Data Management:

    • Income & Expense Tracking: Easily record all financial transactions, including revenue (turnover), other income, purchases (cost of goods), invoice payments, and other expenditures.

    • Dynamic Data Entry: Form fields adapt based on the transaction type (e.g., supplier selection for purchases).

    • Credit Card Tracking: Special handling for purchases made with credit cards, including automatic generation of related balance adjustment entries.

    • Currency & Gold Equivalents: Automatically calculate and store the USD and Gram Gold equivalents for revenue entries based on the transaction date's exchange rates (via external API integration).

    • Detailed Search & Filtering: Quick access to records based on description, type, and date range.

  2. Advanced Invoice Management:

    • Easy Invoice Entry: Record complete invoice details including date, number, supplier selection, and detailed product lines (quantity, unit price, VAT rate).

    • Automatic Calculations: Automatic calculation of line totals, VAT amounts, and invoice grand totals.

    • Financial Data Linking: Easily link saved invoices to corresponding expense records (purchases, invoice payments, etc.) enhancing financial tracking accuracy.

    • Invoice Archive & Details: List, filter, and view details (including product items) of all recorded invoices.

  3. Supplier and Product Catalog:

    • Supplier Management: Record, list, sort (drag-and-drop), and manage supplier details (name, title, logo).

    • Product Management: Classify products by supplier, manage product names, images (URL or upload), and active/inactive status.

    • Product Code Matching (Beta): An intelligent system to link various raw codes from invoices (e.g., "KS PM", "Parliament Ks") to a single master product ("Parliament Short"). Includes bulk code addition and individual code deletion.

    • Automatic Product Completion (Beta): Identifies product names found on invoices but not yet registered in the system, offering a quick product addition interface.

  4. In-Depth Reporting and Analysis:

    • Professional PDF Reports: Generate monthly summaries, annual summaries, and custom date range reports (using Dompdf). Reports include visualizations like comparative revenue charts and supplier spending distribution generated with pChart. Embedded QR codes allow for report verification.

    • Email Integration: Send generated PDF reports directly to specified email addresses from within the system (using PHPMailer).

    • Interactive Charts: Data visualization using CanvasJS, ApexCharts, and Chart.js:

      • Cumulative tracking of income, expenses, profit, and net balance.

      • Daily, monthly, annual revenue trends.

      • Monthly minimum and maximum revenue ranges.

      • Supplier spending shares (pie chart).

      • Daily revenue heat map (ApexCharts).

      • Financial Calendar showing monthly summaries.

    • Real Revenue Analysis: One of the system's most powerful features! Calculates and compares the inflation-adjusted (real) value of nominal (recorded) revenue using CPI data from TÜİK (TurkStat) and ENAG. Offers comparisons with previous years, detailed monthly tables, average daily real revenue, USD/XAU benchmark tracking, and custom period analysis. Includes options for PDF reporting and email distribution.

    • Strategic Invoice Analysis:

      • Supplier Insights: Supplier dependency, supplier scorecard (spending, invoice count, frequency, product variety), single-sourced products (supply risk).

      • Product Insights: ABC analysis (Pareto - 80% spending), price volatility, products with the highest price increases/decreases.

      • Price Opportunities: Compares prices for the same product from different suppliers to identify potential savings.

      • Basket Analysis: Shows which products are frequently purchased together.

  5. Forecasting Capabilities:

    • Product-Based Forecasting: Predicts the next estimated purchase date and amount based on historical purchase frequency and quantity.

    • Supplier-Based Forecasting: Predicts the next estimated invoice date and amount based on the frequency and average value of invoices from a supplier. (These analyses are fed by JSON files generated by external Python scripts).

  6. Macroeconomic Data Integration:

    • Interface for managing monthly CPI data from TÜİK and ENAG.

    • Tracking of Central Bank policy interest rates.

    • Automatic calculation of annual inflation using this data and its use in real revenue analyses.

  7. Secure and Modern Authentication:

    • Standard login with phone number and password.

    • Atlantic ID Integration: Allows users to log in securely with a single click using their existing Atlantic ID accounts (SSO - Single Sign-On) via OAuth 2.0 and OpenID Connect standards (enhanced with PKCE).

    • End-to-end encrypted (E2EE) cookie management for the "Remember Me" feature using CryptoJsAes.

    • Additional security layers based on IP address and browser information for session integrity.

    • Mandatory temporary password change upon first login.

  8. Administration and Settings:

    • Multi-user support and basic user management (add/delete).

    • Comprehensive configuration panel (Site name, URL, starting year, SMTP settings, mobile app info, E2EE security key).

  9. Additional Features:

    • Weather integration (daily forecasts and historical data), displayed in the interface and reports.

    • Mobile app support (custom User Agent detection, adaptations like emailing PDFs).

    • Automated, encrypted database backup and transfer to an external server.

    • Option to export specific data to Excel.

Outcome: The Ferhat Büfe Accounting System transcends being merely a data recording tool; it is an integrated platform offering powerful analytical capabilities for businesses to understand their financial health, track trends, anticipate risks, and make strategic decisions. At CodeAtlantis, we take pride in leveraging modern technologies to create solutions that enhance operational efficiency and profitability for businesses.