Ascendant Ledger v1.2.0

What's Changed

• Ascendant Ledger v1.2.0 — Desktop app by @ItsJustMouse in #1

New Contributors

• @ItsJustMouse made their first contribution in #1

Full Changelog: v1.1.0...v1.2.0

Ascendant Ledger v1.1.0

Ascendant Ledger v1.1.0

Initial public release of Ascendant Ledger — a self-hosted financial dashboard and accounting tool built for Sim Companies.

Ascendant Ledger is designed to give players a clear, professional view of their company finances using the CSV exports provided by Sim Companies.

Highlights

• Separate support for both Sim Companies Realms:
  • Magnates
  • Entrepreneurs
• Realm-specific financial data and imports
• Automatic CSV type detection
• Duplicate-safe imports
• Import preview before committing data
• Import history and rollback support
• Persistent SQLite database
• Docker and Docker Compose deployment
• Responsive interface with light and dark themes

Financial Dashboard

The dashboard provides a clear overview of company health and performance, including:

• Cash
• Sales
• Gross Profit
• Gross Margin
• Net Income
• Core Business Result
• Net Margin
• Inventory value
• Assets
• Liabilities
• Equity
• Exchange fees
• Market purchases
• Production spending
• Net cash flow

Interactive charts help visualize financial trends over time.

Financial Statements

Ascendant Ledger supports Sim Companies exports for:

• Income Statement
• Balance Sheet
• Cash Flow Statement
• Account History

The application keeps official accounting totals separate from transaction-level analytics to avoid double-counting.

CSV Import System

Upload Sim Companies CSV files directly through the web interface.

The importer includes:

• Drag-and-drop uploads
• Multiple files at once
• Automatic report-type detection
• Import previews
• New-row detection
• Duplicate detection
• Validation errors
• Date-range detection
• Statement upserts
• Transaction deduplication
• Raw source-data preservation

Before committing data, the application clearly displays which Realm the CSV files will be imported into.

Dual-Realm Support

Sim Companies allows businesses in two separate Realms:

Magnates

Financial data, transactions, imports, reports, and analytics are stored independently for the Magnates Realm.

Entrepreneurs

The Entrepreneurs Realm maintains its own completely separate financial ledger.

You can switch between Realms from the application header.

Each Realm maintains its own:

• Dashboard
• Transactions
• Income Statement
• Balance Sheet
• Cash Flow
• Products
• Buildings
• Market activity
• Fees
• Import history
• Data-quality results
• Company name

Transaction Analytics

The Account History importer parses transaction metadata from Sim Companies and provides detailed views for:

• Sales
• Production
• Market activity
• Fees
• Construction
• Game transactions
• Products
• Buildings
• Buyers
• Sellers
• Quantities
• Quality
• Prices
• Unit COGS
• Known transaction profit

Original transaction JSON is preserved for auditing and troubleshooting.

Product Analytics

Track performance by product, including available metrics such as:

• Revenue
• Purchases
• Production activity
• Quantity
• Average prices
• Unit COGS
• Transaction count
• Known or derived profit
• Margin

Derived or estimated values are clearly distinguished from official accounting values.

Building Analytics

Analyze activity associated with individual Sim Companies buildings, including:

• Building type
• Level
• Production activity
• Sales activity
• Associated products
• Production costs
• Revenue where available
• Recent activity

Market & Exchange Analytics

Track market activity separately from official financial statements.

Includes analysis for:

• Market purchases
• Market sales
• Exchange purchases
• Exchange sales
• Exchange fees
• Suppliers
• Buyers
• Products
• Quantities
• Prices
• Known profit

Fee Tracking

Ascendant Ledger provides dedicated fee analysis while keeping overlapping accounting sources separate.

This includes:

• Exchange fees
• Cash-flow fee expenses
• Account History fee transactions
• Fee trends
• Fee percentage of sales

Data Quality & Reconciliation

Built-in checks help identify problems with imported data.

Examples include:

• Balance Sheet reconciliation
• Duplicate transactions
• Malformed JSON
• Missing statement dates
• Unknown transaction categories
• Unknown CSV columns
• Import errors
• Unusually large transactions
• Overlapping statement data

Raw Data

Advanced users can inspect imported source records directly.

Features include:

• Pagination
• Sorting
• Filtering
• Column selection
• Raw transaction JSON
• CSV export

Import History & Rollback

Each import batch records details such as:

• Filename
• Import date
• Report type
• Rows processed
• Rows inserted
• Rows updated
• Duplicates skipped
• Errors
• File hash
• Date range

Imports can be rolled back using revision-aware logic designed to preserve data referenced by later imports.

Resource & Building Mappings

Ascendant Ledger automatically learns observed Sim Companies resource IDs and building codes.

Manual overrides are also supported.

Features include:

• Automatic mappings
• Persistent mappings
• Manual overrides
• First-seen and last-seen tracking
• Unknown-ID fallback labels
• Shared game-resource mappings across Realms

Backup & Restore

Ascendant Ledger uses SQLite for persistent storage.

The application includes support for:

• Database backups
• Persistent Docker volumes
• Backup documentation
• Safe SQLite backup operations

Security

The application includes protections for:

• Unsafe file uploads
• SQL injection
• XSS
• Path traversal
• CSV formula injection
• Malformed CSV input

Optional single-user authentication is supported for deployments that require it.

For internet-facing installations, a secure reverse proxy and HTTPS are strongly recommended.

Deployment

Ascendant Ledger is designed for self-hosting.

Typical deployment:

cp .env.example .env
docker compose up -d --build