# Akaunting Free Accounting

> Free and open-source accounting software for small businesses.

- Category: Full Web Stacks
- Difficulty: beginner
- Components: akaunting, mariadb
- Tags: accounting, invoicing, akaunting, finance, bookkeeping
- Source: https://docker.recipes/full-stacks/akaunting-accounting

## Overview

Akaunting is a comprehensive, open-source accounting platform designed specifically for small businesses, freelancers, and startups who need professional-grade financial management without the enterprise price tag. Built with PHP and Laravel framework, Akaunting offers double-entry bookkeeping, invoicing, expense tracking, and financial reporting capabilities that rival commercial solutions like QuickBooks or FreshBooks. The software supports multi-currency operations, tax management, and comes with a marketplace of extensions for specialized business needs. This Docker stack combines Akaunting with MariaDB to create a self-hosted financial management system that maintains complete data ownership while providing enterprise-level accounting features. MariaDB serves as the robust database backend, leveraging its enhanced performance characteristics and Aria storage engine to handle complex financial transactions and reporting queries efficiently. The combination eliminates dependency on cloud-based accounting services while providing better performance than traditional MySQL setups. This stack is particularly valuable for businesses requiring GDPR compliance, custom financial workflows, or integration with existing enterprise systems. Small business owners, accounting firms managing multiple clients, and organizations needing customizable financial reporting will find this deployment offers the flexibility and control that cloud-based solutions cannot match.

## Features

- Double-entry bookkeeping system with automated journal entries and account reconciliation
- Multi-currency support with real-time exchange rate updates and currency conversion tracking
- Professional invoice generation with customizable templates, recurring billing, and payment gateway integration
- Expense management with receipt scanning, vendor tracking, and automated categorization
- Financial reporting dashboard with P&L statements, balance sheets, and cash flow analysis
- MariaDB Aria storage engine providing crash-safe tables and improved performance for financial data
- Apps marketplace integration allowing installation of banking connectors, payment processors, and industry-specific modules
- Multi-company support enabling accounting firms to manage multiple client books from single installation

## Use cases

- Small business owners replacing QuickBooks or similar commercial accounting software with self-hosted solution
- Freelancers and consultants needing professional invoicing with integrated expense tracking and tax reporting
- Accounting firms managing multiple client accounts with separated company books and custom branding
- International businesses requiring multi-currency support with automated exchange rate management
- Organizations needing GDPR-compliant financial data storage with complete control over sensitive information
- Startups requiring scalable accounting infrastructure that grows from basic invoicing to complex financial management
- Non-profit organizations tracking donations, grants, and program expenses with detailed reporting requirements

## Prerequisites

- Minimum 1GB RAM for MariaDB performance with financial data processing and concurrent user access
- Port 8080 available for Akaunting web interface access and administrative functions
- Basic understanding of accounting principles including double-entry bookkeeping and chart of accounts structure
- SSL certificate and reverse proxy setup recommended for production deployment with sensitive financial data
- Regular backup strategy for both MariaDB data volumes and Akaunting file storage containing invoices and receipts
- Valid SMTP configuration for automated invoice delivery and system notifications

## docker-compose.yml

```yaml
services:
  akaunting:
    image: akaunting/akaunting:latest
    container_name: akaunting
    environment:
      - APP_URL=${APP_URL}
      - LOCALE=en-US
      - DB_HOST=db
      - DB_PORT=3306
      - DB_NAME=akaunting
      - DB_USERNAME=akaunting
      - DB_PASSWORD=${DB_PASSWORD}
      - DB_PREFIX=akaunt_
      - COMPANY_NAME=${COMPANY_NAME}
      - COMPANY_EMAIL=${COMPANY_EMAIL}
      - ADMIN_EMAIL=${ADMIN_EMAIL}
      - ADMIN_PASSWORD=${ADMIN_PASSWORD}
    volumes:
      - akaunting-data:/var/www/html/storage
    ports:
      - "8080:80"
    depends_on:
      - db
    networks:
      - akaunting-network
    restart: unless-stopped

  db:
    image: mariadb:10.11
    container_name: akaunting-db
    environment:
      - MYSQL_ROOT_PASSWORD=${DB_ROOT_PASSWORD}
      - MYSQL_DATABASE=akaunting
      - MYSQL_USER=akaunting
      - MYSQL_PASSWORD=${DB_PASSWORD}
    volumes:
      - mariadb-data:/var/lib/mysql
    networks:
      - akaunting-network
    restart: unless-stopped

volumes:
  akaunting-data:
  mariadb-data:

networks:
  akaunting-network:
    driver: bridge
```

## .env

```bash
# Akaunting
APP_URL=http://localhost:8080
COMPANY_NAME=My Company
COMPANY_EMAIL=company@example.com
ADMIN_EMAIL=admin@example.com
ADMIN_PASSWORD=secure_admin_password

# Database
DB_PASSWORD=secure_akaunting_password
DB_ROOT_PASSWORD=secure_root_password
```

## Usage notes

- Web UI at http://localhost:8080
- Setup wizard on first visit
- Double-entry accounting
- Multi-currency support
- Apps marketplace available

## Troubleshooting

- Akaunting installation wizard shows database connection error: Verify DB_PASSWORD matches between akaunting and db services in environment variables
- Currency conversion rates not updating automatically: Check internet connectivity from akaunting container and verify API rate limits haven't been exceeded
- Invoice PDF generation fails with memory errors: Increase PHP memory limit by adding PHP_MEMORY_LIMIT environment variable to akaunting service
- MariaDB container fails to start with 'Table corrupt' errors: Stop containers and run docker exec akaunting-db mysql_upgrade to repair Aria storage engine tables
- Apps marketplace shows connection timeout: Ensure akaunting container has outbound internet access for marketplace API and verify firewall rules
- Multi-company setup shows permission denied errors: Check akaunting-data volume permissions and ensure web server user has write access to storage directory

