Get Started
API Reference
- Api keys
- Items
- Inventory Adjustments
- Branches
- Warehouses
- Accounts
- Inventory Cost
- Sale Invoices
- Pdf Templates
- Tax Rates
- Payments Received
- Import
- resources
- Payment Links
- stripe
- Item Categories
- Expenses
- Warehouse Transfers
- Customers
- Vendors
- Sale Estimates
- Sale Receipts
- Bills
- Landed Cost
- Manual Journals
- Credit Notes
- Credit Note Refunds
- Credit Notes Apply Invoice
- Vendor Credits
- Vendor Credits Apply Bills
- Bill Payments
- Vendor Credits Refunds
- Bank Accounts
- Banking Plaid
- banking-plaid
- Banking Categorization
- Banking Transactions
- Banking Uncategorized Transactions
- Banking Pending Transactions
- Bank Rules
- Banking Recognized Transactions
- Banking Transactions Matching
- Transactions Locking
- Settings
- Reports
- GETGet balance sheet statement
- GETGet purchases by items report
- GETGet customer balance summary report
- GETGet vendor balance summary
- GETSales by items report
- GETGet general ledger report
- GETGet trial balance sheet
- GETGet transactions by vendor
- GETGet transactions by customer
- GETGet transactions by reference
- GETGet receivable aging summary
- GETGet payable aging summary
- GETGet inventory item details
- GETRetrieves the inventory valuation sheet
- GETGet sales tax liability summary report
- GETJournal report
- GETGet profit/loss statement report
- GETGet cashflow statement report
- GET
- Dashboard
- Roles
- Subscriptions
- Organization
- Payment Services
- Attachments
- Export
- Views
- Currencies
- misc
- Users
- Contacts
Reports
Get receivable aging summary
GET
/
api
/
reports
/
receivable-aging-summary
Copy
{
"query": {
"as_date": "2025-06-30",
"aging_days_before": 30,
"aging_periods": 3,
"number_format": {
"divide_on1000": false,
"negative_format": "mines",
"show_zero": false,
"format_money": "total",
"precision": 2
},
"customers_ids": [],
"branches_ids": [],
"none_zero": false
},
"columns": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null
}
],
"data": {
"customers": [
{
"customer_name": "business",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 5000,
"formatted_amount": "5,000.00"
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 5000,
"formatted_amount": "$5,000.00"
}
},
{
"customer_name": "business",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"customer_name": "asdsadasd, asd",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"customer_name": "Ahmed Bouhuolia",
"current": {
"amount": 300000,
"formatted_amount": "300,000.00"
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 300000,
"formatted_amount": "$300,000.00"
}
}
],
"total": {
"current": {
"amount": 300000,
"formatted_amount": "$300,000.00"
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 5000,
"formatted_amount": "$5,000.00"
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
}
],
"total": {
"amount": 305000,
"formatted_amount": "$305,000.00"
}
}
},
"meta": {
"organization_name": "BIGCAPITAL, INC",
"base_currency": "USD",
"date_format": "DD MMM yyyy",
"is_cost_compute_running": false,
"sheet_name": "A/R Aging Summary",
"formatted_as_date": "2025/06/30",
"formatted_date_range": "As 2025/06/30"
}
}
Headers
Value must be 'Bearer <token>' where <token> is an API key prefixed with 'bc_' or a JWT token.
Example:
"Bearer bc_1234567890abcdef"
Required if Authorization is a JWT token. The organization ID to operate within.
Query Parameters
Number of days before the aging period starts
Example:
30
Number of aging periods to calculate
Example:
4
Number of decimal places to display
Example:
2
Whether to divide the number by 1000
Example:
false
Whether to show zero values
Example:
true
How to format money values
Available options:
total
, always
, none
Example:
"total"
How to format negative numbers
Available options:
parentheses
, mines
Example:
"parentheses"
Whether to exclude zero values
Example:
false
Array of customer IDs to include
Response
200
application/json
Receivable aging summary response
The response is of type any
.
Copy
{
"query": {
"as_date": "2025-06-30",
"aging_days_before": 30,
"aging_periods": 3,
"number_format": {
"divide_on1000": false,
"negative_format": "mines",
"show_zero": false,
"format_money": "total",
"precision": 2
},
"customers_ids": [],
"branches_ids": [],
"none_zero": false
},
"columns": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null
}
],
"data": {
"customers": [
{
"customer_name": "business",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 5000,
"formatted_amount": "5,000.00"
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 5000,
"formatted_amount": "$5,000.00"
}
},
{
"customer_name": "business",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"customer_name": "asdsadasd, asd",
"current": {
"amount": 0,
"formatted_amount": ""
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"customer_name": "Ahmed Bouhuolia",
"current": {
"amount": 300000,
"formatted_amount": "300,000.00"
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": ""
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": ""
}
}
],
"total": {
"amount": 300000,
"formatted_amount": "$300,000.00"
}
}
],
"total": {
"current": {
"amount": 300000,
"formatted_amount": "$300,000.00"
},
"aging": [
{
"from_period": "2025-06-30",
"to_period": "2025-05-31",
"before_days": 0,
"to_days": 30,
"total": {
"amount": 5000,
"formatted_amount": "$5,000.00"
}
},
{
"from_period": "2025-05-31",
"to_period": "2025-05-01",
"before_days": 31,
"to_days": 60,
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
},
{
"from_period": "2025-05-01",
"to_period": null,
"before_days": 61,
"to_days": null,
"total": {
"amount": 0,
"formatted_amount": "$0.00"
}
}
],
"total": {
"amount": 305000,
"formatted_amount": "$305,000.00"
}
}
},
"meta": {
"organization_name": "BIGCAPITAL, INC",
"base_currency": "USD",
"date_format": "DD MMM yyyy",
"is_cost_compute_running": false,
"sheet_name": "A/R Aging Summary",
"formatted_as_date": "2025/06/30",
"formatted_date_range": "As 2025/06/30"
}
}
Assistant
Responses are generated using AI and may contain mistakes.