Account2

AccountControllerV25

AccountingTransaction1

AccountingTransactionControllerV21

Aging2

AgingControllerV22

Attachment2

AttachmentControllerV22

Bank6

BankControllerV213

Bill7

BillControllerV213

Budget1

Businesses12

BusinessValuation1

BusinessValuationControllerV21

Connection2

ConnectionControllerV22

ContactControllerV21

Credit2

CreditControllerV22

Customer3

CustomerControllerV27

Data3

DataControllerV26

Deposit2

DepositControllerV22

Dispute1

DisputeControllerV21

Estimate2

EstimateControllerV22

ExpenseControllerV22

File1

FinancialBenchmarking1

FinancialBenchmarkingControllerV21

FinancialForecast1

FinancialForecastControllerV21

FinancialFraudRisk1

FinancialFraudRiskControllerV21

FinancialRatio1

FinancialRatioControllerV21

FinancialStatement3

FinancialStatementControllerV26

Inventory3

InventoryControllerV23

Invoice6

InvoiceControllerV210

Journal3

JournalControllerV28

Order1

OrderControllerV21

PaymentMethodControllerV21

PayrollTransaction1

PortfolioMetrics1

PortfolioMetricsControllerV21

ProbabilityOfDefault1

ProbabilityOfDefaultControllerV21

Product1

ProductControllerV21

PurchaseOrder2

PurchaseOrderControllerV22

Refunds4

Reports10

Sandbox2

TaxBenchmarking1

TaxBenchmarkingControllerV21

TaxRate1

TaxRateControllerV23

TrackingCategory2

TrackingCategoryControllerV22

Transaction1

TransactionControllerV21

TrialBalance1

TrialBalanceControllerV21

Vendor3

VendorControllerV28

Visualizations16

Aging

Aging Reports

GET /arAging

Changed on Sep 3, 2026

Gets a range of AR aging reports for a business.

Request

Base URL
https://api.railz.ai
Auth
HTTP bearer

Query parameters

businessNamestring required

serviceName'freshbooks' | 'quickbooks' | 'quickbooksDesktop' | 'sageIntacct' | 'dynamicsBusinessCentral' required

startDatestring

Transaction date greater than or equal to parameter in the format: YYYY-MM-DD.

endDatestring

Transaction date less than or equal to parameter in the format: YYYY-MM-DD.

offsetnumber

The offset is the position in the dataset of a particular record.

limitnumber

Example:100

This is the size of the results set you would like (default: 100).

orderBystring

reportFrequency'month' | 'quarter' | 'year' required

Response

countinteger required

Example response

{
  "count": 1,
  "reports": [
    {
      "meta": {
        "reportId": [
          "5fad8a342a88364234392fb5"
        ],
        "serviceName": "xero",
        "businessName": "Railz",
        "startDate": "2020-11-25T01:02:03Z",
        "endDate": "2020-11-30T01:02:03Z",
        "createdAt": "2020-11-25T01:02:03Z",
        "updatedAt": "2020-11-30T01:02:03Z",
        "reportFrequency": "month"
      },
      "data": [
        {
          "customerRef": {
            "id": "240",
            "name": "Railz"
          },
          "current": 50000,
          "dpd30": 25000,
          "dpd60": 25000,
          "dpd90": 60000,
          "dpd90+": 90000,
          "total": 200000,
          "currencyRef": {
            "id": "CAD",
            "name": "Canadian Dollar",
            "symbol": "USD,CAD"
          }
        }
      ]
    }
  ]
}

Changes

Sep 3, 20261383b9a47ac9 Revision changes
- info
  api tag Aging added
Aug 10, 20265cdfae3fa1fa Revision changes
- warning
  added the new dynamics365Finance enum value to the /// response property for the response status
- warning
  added the new dynamics365Finance enum value to the /// response property for the response status
- warning
  added the new dynamicsBusinessCentral enum value to the /// response property for the response status
- warning
  added the new dynamicsBusinessCentral enum value to the /// response property for the response status
- warning
  added the new freshbooks enum value to the /// response property for the response status
- warning
  added the new freshbooks enum value to the /// response property for the response status
- warning
  added the new myob enum value to the /// response property for the response status
- warning
  added the new myob enum value to the /// response property for the response status
- warning
  added the new oracleNetsuite enum value to the /// response property for the response status
- warning
  added the new oracleNetsuite enum value to the /// response property for the response status
- warning
  added the new quickbooks enum value to the /// response property for the response status
- warning
  added the new quickbooks enum value to the /// response property for the response status
- warning
  added the new quickbooksDesktop enum value to the /// response property for the response status
- warning
  added the new quickbooksDesktop enum value to the /// response property for the response status
- warning
  added the new sageBusinessCloud enum value to the /// response property for the response status
- warning
  added the new sageBusinessCloud enum value to the /// response property for the response status
- warning
  added the new sageIntacct enum value to the /// response property for the response status
- warning
  added the new sageIntacct enum value to the /// response property for the response status
- warning
  added the new wave enum value to the /// response property for the response status
- warning
  added the new wave enum value to the /// response property for the response status
- warning
  added the new xero enum value to the /// response property for the response status
- warning
  added the new xero enum value to the /// response property for the response status
- warning
  added the new zohoBooks enum value to the /// response property for the response status
- warning
  added the new zohoBooks enum value to the /// response property for the response status
- info
  added the new enum value dynamicsBusinessCentral to the query request parameter serviceName
- info
  added the new enum value sageIntacct to the query request parameter serviceName
- info
  added the optional property ///// to the response with the status
- info
  added the optional property ///// to the response with the status

Operation history