PUQ Mautic Skip to main content

Changelog

PUQ Account Statement module WHMCS

Order now | Download | Community

v4.0.0 — 2026-09-18

Major Architecture & Compatibility Upgrade

  • Universal ionCube Loader v15 Support: Fully encoded with the latest ionCube 15 compiler, guaranteeing seamless execution across PHP 7.4, 8.1, 8.2, 8.3, and 8.4 environments.
  • Unencoded Hooks Architecture (v4.0.0 Standard): Refactored hooks.php into an open, unencoded entrypoint delegating to lib/puqAccountStatementHooks.php with robust \Throwable error isolation and module logging.
  • WHMCS 8.x & WHMCS 9+ Compatibility: Modernized database queries and hook registrations for complete compatibility with current and upcoming WHMCS releases.
  • Performance & Reliability Improvements: Streamlined cron scheduling, automated statement cleanup, and client summary tab rendering.

New Features & Enhancements

  • "All Unpaid Invoices" Period Selection in Schedules: Added automated "All Unpaid Invoices" (all_unpaid) period option in Schedules. The module automatically scans all unpaid and overdue invoices across all years (from 1970-01-01 to current date), ensuring outstanding balances from prior or future years (2025, 2026, 2027+) are never missed.
  • Automated Empty Statement Suppression: When generating or scheduling statements targeting unpaid invoices, the module automatically skips clients with zero unpaid balances, preventing blank emails from being sent.
  • Interactive Database Verification Tool: Added a "Check and Update Database Schema" maintenance tool in Module Settings to non-destructively inspect tables and automatically add missing columns during upgrades.
  • "All Time" Quick Period Preset: Added "All Time" period button in Manual Generation and Bulk Generation to instantly select the full history from account inception to current date.
  • In-Memory Email Attachment Delivery: Enhanced bulk statement email delivery by handing PDF attachments directly in-memory to the WHMCS mail pipeline via EmailPreSend, preventing dropped attachments on shared filesystems.
  • Localized WHMCS System Descriptions: Automated localization for native WHMCS transaction and credit descriptions (e.g. Invoice Payment, Credit Applied to Invoice, Credit Removed, Reason: Order status changed to Cancelled, Overpayment, Mass Invoice Payment Credit for Invoice).
  • Complete 26-Language Localization: Added translations for all new schedule and database maintenance strings across all 26 supported language files.
  • Template Scanner Refinement: PDF template discovery now ignores draft and hidden files starting with _ or . (e.g. _classic.tpl), avoiding duplicate or confusing template selections.
  • Documentation Fixes & Updated Screenshots: Corrected BookStack canonical documentation links and updated administrative screenshots for Schedule Editor and Settings.

v1.2 — 2026-06-05

The clarity update. Your customers now see, at a glance, exactly how much they owe — in their own language and in your date format.

New Features

  • Real outstanding balance. The Closing Balance now reflects what the customer actually owes (negative = owed), and it ties out perfectly with the Debit and Credit columns of the statement. No more confusing $0.00 closing balances when there are unpaid invoices.
  • Account Credit shown separately. Statements now display both the client's Account Credit and the amount owed, so the two are never mixed up.
  • Carry-forward opening balance. The Open Balance now includes outstanding invoices from before the statement period — perfect for statements that start mid-history.
  • Multilingual statements. PDF, on-screen preview, and CSV exports are now generated in the client's own language, with automatic fallback to your system language and then English. Fully translated across 25 languages.
  • "Show Open Balance" setting. Hide the Open Balance line entirely if you only want to show the amount owed.

Improvements

  • Dates follow your WHMCS Global Date Format. Statement dates now respect the format configured in WHMCS (e.g. DD/MM/YYYY) instead of a fixed format.
  • Smarter client search. The admin client search now matches first name + last name together (in any order), as well as company, email, or client ID.
  • Client area language. The client area now displays in the logged-in customer's own language.
  • CSV summary fixed & expanded. The CSV summary section now shows correct values (including Account Credit and amount owed) and is included with emailed/attached exports.

Bug Fixes

  • Fixed the running-balance column in the Detailed PDF template (it previously never updated and used the wrong sign).
  • Fixed mixed-language output where the statement preview and PDF stayed in English regardless of the selected language.

v1.1 — 2026-02-25

Bug Fixes

  • Fixed "Call to undefined function puq_account_statement_LoadLang()" error on customer profile page

Improvements

  • All monetary values now consistently display with 2 decimal places (e.g., 0.00, 5.10 instead of 0 or 5.1)
  • Removed currency symbol from the Total column in statements for uniform formatting with Debit and Credit columns

New Features

  • Added "Show Payment Method" setting to control visibility of the Payment Method column in statements
  • When disabled, the Payment Method column is hidden across all views: admin preview, PDF exports, and CSV exports

v1.0 — 2026-02-18

First release.

New Features

  • Statement generation for individual clients with customizable date ranges
  • Invoice filtering by status: Paid, Unpaid, Refunded
  • Transaction and credit entry inclusion in statements
  • Payment method and product group filtering
  • Quick period presets: This Month, Last Month, This Year, Last Year
  • PDF export with multiple templates: Classic, Modern, Detailed (Portrait & Landscape)
  • CSV export for data analysis
  • PDF Style editor: typography, colors, display options, header/footer text, custom CSS
  • Saved statements archive with search, filter, and pagination
  • Bulk generation for multiple clients with progress tracking
  • Client filters for bulk: All Clients, By Client Group, By Country, With Unpaid Invoices
  • Scheduled automatic statement generation (Daily, Weekly, Monthly, Quarterly, Yearly)
  • Schedule management: create, edit, toggle, run now, delete
  • Client area self-service: view, generate, and download statements
  • Client area configurable permissions: PDF download, CSV download
  • Email delivery with PDF attachment using WHMCS email templates
  • Public shareable links with configurable expiry
  • Aging report for overdue invoice analysis
  • Dashboard with key metrics, quick generate, recent statements, upcoming schedules
  • Auto-cleanup of old saved statements
  • Configurable per-page pagination
  • Add to Billing Menu option for client area
  • AJAX-based interface with loading spinners on all actions
  • License verification system with online/offline modes
  • Dashboard accessible without active license, other pages restricted
  • Error logging via WHMCS logModuleCall
  • English language interface
Back to top