XAmountOwing

Introduction

XAmountOwing classifies a supplied amount by its date relative to an as-of date. It returns the amount when the date is inside the selected aging interval, or 0 otherwise. It does not retrieve an outstanding balance or determine whether an invoice has been paid. The function was tested in Excel with Sage 50 Canada and US connections using XLGL version 1.0.9691.27981.

Syntax

=XAmountOwing(asOfDate, amountDate, amount, [startDays], [endDays])

Parameters

asOfDate [Required] — Reference date for aging. Use an Excel date or a date-cell reference.

amountDate [Required] — Date of the amount being classified. You choose whether to age from a due date or another transaction date.

amount [Required] — Numeric amount returned unchanged when the date qualifies, including its sign.

startDays [Optional] — Lower day limit; defaults to 0.

endDays [Optional] — Upper day limit; defaults to 99999.

The limits are inclusive. If the lower limit exceeds the upper limit, XLGL swaps them. With ordinary whole dates, the amount qualifies when the number of days between asOfDate and amountDate falls between the limits. The default interval excludes future dates.

Examples

Ten days old, within 0–30 days: =XAmountOwing(DATE(2026,9,15),DATE(2026,9,5),125,0,30) returns 125.

Thirty-one days old, outside 0–30 days: =XAmountOwing(DATE(2026,9,15),DATE(2026,8,15),125,0,30) returns 0.

Credit in range: =XAmountOwing(DATE(2026,9,15),DATE(2026,9,5),-125,0,30) returns -125.

These examples passed live Excel checks with Canada and US connected in turn. For several buckets, use non-overlapping ranges such as 0–30, 31–60, and 61–90 to avoid counting a boundary date twice. Use whole-number limits and dates without time components for normal aging Reports.

Considerations

XLGL must be loaded in Excel for this function to be recognized. The calculation does not query a company database. The pre-1900 as-of-date fallback, fractional-day offsets, and 99,999-day default ceiling were inspected in the installed implementation but were not separately boundary-tested in Excel.

References

Logicim XLGL worksheet functions

Microsoft Excel DATE function