Trial Balance Summary API returns missing April data for zero-balance GL Account after reversal (Credit Note) when fiscal year is April–March

1

Summary
When a reversal (Credit Note) is posted against a specific GL_Account_Number to bring its balance to 0.00, the GET /accounting/trial_balance/summary endpoint returns 0.00 for all months as expected — except for the month of April, where the data row is missing entirely. This occurs in FreeAgent tenants configured with a fiscal year of April to March (i.e., April is the first month of the fiscal year).

Endpoint
GET /accounting/trial_balance/summary?to_date=2026-04-30

Steps to Reproduce

  1. In FreeAgent, configure the company fiscal year as April to March.
  2. Identify a GL_Account_Number that has existing postings.
  3. Create a reversal entry (Credit Note) against this GL account such that the resulting balance becomes 0.00.
    Call the API: GET /accounting/trial_balance/summary?to_date=2026-04-30

Inspect the monthly breakdown in the response for the affected GL account.

Expected Behavior
The response should include all months of the fiscal year (April 2025 through April 2026), each showing a balance of 0.00 for the GL account, consistent with the zero-balance state created by the reversal.

Actual Behavior
1.All months return 0.00 correctly except April.
2.The April entry is missing from the response payload for the affected GL account.
3.This happens specifically when April is the first month of the fiscal year.

Impact
1.Trial Balance reports are incomplete for the fiscal year’s opening month.
2.Downstream reconciliation, reporting, and audit workflows that depend on a complete month-by-month trial balance are broken.
3.Affects all customers using a FreeAgent fiscal year starting in April.

Environment
1.Accounting integration: FreeAgent
2.Fiscal year: April – March
3.API: accounting/trial_balance/summary
4.Scenario: GL account zeroed out via reversal / Credit Note

Additional Notes
The issue appears to be specific to the handling of the first month of the fiscal year when the net balance is zero following a reversal entry — suggesting the aggregation logic may be filtering out zero-value rows for the opening fiscal month instead of returning 0.00.