AsFiled formula reference: FILING and FILING_SOURCE
Everything the two AsFiled formulas accept.
FILING
=FILING(company, line, period, [show], [mode])
- company: a ticker such as
"AAPL", or the company's SEC CIK number. - line: one of the line names below, or any XBRL tag the company uses, such as
"InventoryNet"(Pro). - period: a fiscal year such as
2025, or a quarter such as"2025 Q1"(Pro). Leave it blank for the latest year. - show (optional):
value(default),url,filed,period start,period end,form,concept,companyornote. - mode (optional):
reported(default, the number as first filed) orlatest(picks up later restatements, Pro).
In the templates, FILING takes a sixth argument: the cell holding your Pro key.
FILING_SOURCE
=FILING_SOURCE(company, line, period)
The link to the filing on sec.gov that the number came from.
Line names
| Line name | XBRL tags tried, in order |
|---|---|
revenue | Revenues, RevenueFromContractWithCustomerExcludingAssessedTax, RevenueFromContractWithCustomerIncludingAssessedTax, SalesRevenueNet, RevenuesNetOfInterestExpense, SalesRevenueGoodsNet |
costofrevenue | CostOfRevenue, CostOfGoodsAndServicesSold, CostOfGoodsSold |
grossprofit | GrossProfit |
researchanddevelopment | ResearchAndDevelopmentExpense, ResearchAndDevelopmentExpenseExcludingAcquiredInProcessCost |
operatingincome | OperatingIncomeLoss |
pretaxincome | IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest, IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments |
incometax | IncomeTaxExpenseBenefit |
netincome | NetIncomeLoss, ProfitLoss |
epsbasic | EarningsPerShareBasic |
epsdiluted | EarningsPerShareDiluted, EarningsPerShareBasicAndDiluted |
dilutedshares | WeightedAverageNumberOfDilutedSharesOutstanding |
assets | Assets |
currentassets | AssetsCurrent |
cash | CashAndCashEquivalentsAtCarryingValue, CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents |
liabilities | Liabilities |
currentliabilities | LiabilitiesCurrent |
longtermdebt | LongTermDebtNoncurrent, LongTermDebt |
equity | StockholdersEquity, StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest |
operatingcashflow | NetCashProvidedByUsedInOperatingActivities |
capex | PaymentsToAcquirePropertyPlantAndEquipment, PaymentsToAcquireProductiveAssets, PaymentsToExploreAndDevelopOilAndGasProperties |
dividendspaid | PaymentsOfDividends, PaymentsOfDividendsCommonStock |
buybacks | PaymentsForRepurchaseOfCommonStock |
Spaces and capitals don't matter: "net income", "NetIncome" and "netincome" are the same. Common alternatives also work, for example sales, cogs, ebit, eps and capital expenditures. When a company doesn't report total liabilities, AsFiled calculates it as total liabilities and equity minus equity, and says so in the note.
Free and Pro
Free: yearly 10-K numbers for the named lines, and filing links. Pro adds quarters, any XBRL tag, and the latest mode.
Try it without writing anything
Our free Google Sheets templates already contain these formulas. Make a copy, type a ticker, and the numbers fill in.
Free templates · Guides · AsFiled Pro · Terms · Privacy · Refunds · Support
AsFiled is made by Eagle Eye Insights LLC. Numbers come from companies' own filings with the U.S. Securities and Exchange Commission; AsFiled is not affiliated with the SEC.