MarketXLS

Accounts Receivable (Historical)

Returns the accounts receivable balance from historical balance sheets, representing money owed to the company by customers.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Calendar quarter 1-4
TTM No Set to "TTM" for trailing twelve months

Notes

  • Accounts receivable is a current asset on the balance sheet
  • Represents credit sales not yet collected
  • Important for working capital and liquidity analysis

Syntax

=hf_Accounts_receivable(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Accounts receivable amount

Examples

=hf_Accounts_receivable("AAPL", 2023, 4)
Q4 2023 accounts receivable
=hf_Accounts_receivable("MSFT", "ly", 2)
Last year Q2
=hf_Accounts_receivable("GOOGL", 2022)
Annual 2022
=hf_Accounts_receivable(A1, B1, C1)
Cell references

When to Use

  • Working capital analysis
  • Liquidity assessment
  • Cash conversion cycle calculation
  • Credit policy analysis
  • Historical trend analysis

When NOT to Use

Scenario Use Instead
Need receivables turnover hf_Receivables_turnover()
Need current AR AccountsReceivable()
Need total current assets hf_Total_current_assets()

Common Issues & FAQ

Why does AR vary significantly by quarter?

Seasonal businesses may have varying AR levels. Also, collection timing affects quarter-end balances.

How do I calculate Days Sales Outstanding?

DSO = (Accounts Receivable / Revenue) * 365

Excel Templates Using Accounts Receivable (Historical)

These ready-made MarketXLS templates call hf_Accounts_receivable() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Accounts Receivable (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions