Guides

AsFiled formula reference: FILING and FILING_SOURCE

Everything the two AsFiled formulas accept.

FILING

=FILING(company, line, period, [show], [mode])

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 nameXBRL tags tried, in order
revenueRevenues, RevenueFromContractWithCustomerExcludingAssessedTax, RevenueFromContractWithCustomerIncludingAssessedTax, SalesRevenueNet, RevenuesNetOfInterestExpense, SalesRevenueGoodsNet
costofrevenueCostOfRevenue, CostOfGoodsAndServicesSold, CostOfGoodsSold
grossprofitGrossProfit
researchanddevelopmentResearchAndDevelopmentExpense, ResearchAndDevelopmentExpenseExcludingAcquiredInProcessCost
operatingincomeOperatingIncomeLoss
pretaxincomeIncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest, IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments
incometaxIncomeTaxExpenseBenefit
netincomeNetIncomeLoss, ProfitLoss
epsbasicEarningsPerShareBasic
epsdilutedEarningsPerShareDiluted, EarningsPerShareBasicAndDiluted
dilutedsharesWeightedAverageNumberOfDilutedSharesOutstanding
assetsAssets
currentassetsAssetsCurrent
cashCashAndCashEquivalentsAtCarryingValue, CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents
liabilitiesLiabilities
currentliabilitiesLiabilitiesCurrent
longtermdebtLongTermDebtNoncurrent, LongTermDebt
equityStockholdersEquity, StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest
operatingcashflowNetCashProvidedByUsedInOperatingActivities
capexPaymentsToAcquirePropertyPlantAndEquipment, PaymentsToAcquireProductiveAssets, PaymentsToExploreAndDevelopOilAndGasProperties
dividendspaidPaymentsOfDividends, PaymentsOfDividendsCommonStock
buybacksPaymentsForRepurchaseOfCommonStock

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.

See the templates

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.