Quarterly report · Q2

Period2023-03-01 → 2023-08-31
Filed2023-10-13
StandardJapan GAAP
ConsolidatedYes
Data checks19 of 19 passed
Key figures · 58
MetricValuePeriodScopeSource row
Revenue¥26.5bn2023-03-01 → 2023-08-31Cons.Net sales
Revenue¥16.3bn2023-06-01 → 2023-08-31dCons.Net sales
Revenue¥68.1bn2022-03-01 → 2023-02-28Cons.Net sales (5-year summary)
Revenue¥25.5bn2022-03-01 → 2022-08-31Cons.Net sales
Revenue¥8.8bn2022-06-01 → 2022-08-31dCons.Net sales
Operating income¥5.5bn2023-03-01 → 2023-08-31Cons.Operating income
Operating income¥3.0bn2023-06-01 → 2023-08-31dCons.Operating income
Operating income¥5.1bn2022-03-01 → 2022-08-31Cons.Operating income
Operating income¥2.4bn2022-06-01 → 2022-08-31dCons.Operating income
Ordinary income¥4.1bn2023-03-01 → 2023-08-31Cons.Ordinary income
Ordinary income¥2.6bn2023-06-01 → 2023-08-31dCons.Ordinary income
Ordinary income¥10.8bn2022-03-01 → 2023-02-28Cons.Ordinary income loss (5-year summary)
Ordinary income¥4.2bn2022-03-01 → 2022-08-31Cons.Ordinary income
Ordinary income¥1.8bn2022-06-01 → 2022-08-31dCons.Ordinary income
Profit before tax¥12.5bn2023-03-01 → 2023-08-31Cons.Income before income taxes
Profit before tax¥10.3bn2023-06-01 → 2023-08-31dCons.Income before income taxes
Profit before tax¥5.3bn2022-03-01 → 2022-08-31Cons.Income before income taxes
Profit before tax¥2.9bn2022-06-01 → 2022-08-31dCons.Income before income taxes
Net income (owners)¥8.5bn2023-03-01 → 2023-08-31Cons.Profit loss attributable to owners of parent
Net income (owners)¥7.0bn2023-06-01 → 2023-08-31dCons.Profit loss attributable to owners of parent
Net income (owners)¥9.4bn2022-03-01 → 2023-02-28Cons.Profit loss attributable to owners of parent (5-year summary)
Net income (owners)¥3.4bn2022-03-01 → 2022-08-31Cons.Profit loss attributable to owners of parent
Net income (owners)¥1.9bn2022-06-01 → 2022-08-31dCons.Profit loss attributable to owners of parent
Net income¥8.6bn2023-03-01 → 2023-08-31Cons.Profit loss
Net income¥7.1bn2023-06-01 → 2023-08-31dCons.Profit loss
Net income¥3.5bn2022-03-01 → 2022-08-31Cons.Profit loss
Net income¥1.9bn2022-06-01 → 2022-08-31dCons.Profit loss
Total assets¥356.4bnat 2023-08-31Cons.Assets
Total assets¥338.6bnat 2023-02-28Cons.Assets
Total assets¥341.4bnat 2022-08-31Cons.Assets
Total liabilities¥237.0bnat 2023-08-31Cons.Liabilities
Total liabilities¥224.2bnat 2023-02-28Cons.Liabilities
Net assets / equity¥119.4bnat 2023-08-31Cons.Net assets
Net assets / equity¥114.4bnat 2023-02-28Cons.Net assets
Net assets / equity¥111.1bnat 2022-08-31Cons.Net assets (5-year summary)
Cash and deposits¥47.8bnat 2023-08-31Cons.Cash and deposits
Cash and deposits¥40.5bnat 2023-02-28Cons.Cash and deposits
Cash & equivalents¥47.6bnat 2023-08-31Cons.Cash and cash equivalents
Cash & equivalents¥40.3bnat 2023-02-28Cons.Cash and cash equivalents
Cash & equivalents¥41.6bnat 2022-08-31Cons.Cash and cash equivalents
Cash & equivalents¥46.2bnat 2022-02-28dCons.Cash and cash equivalents
Operating cash flow−¥10.4bn2023-03-01 → 2023-08-31Cons.Net cash provided by used in operating activities
Operating cash flow¥254m2022-03-01 → 2023-02-28Cons.Net cash provided by used in operating activities (5-year summary)
Operating cash flow−¥3.2bn2022-03-01 → 2022-08-31Cons.Net cash provided by used in operating activities
Investing cash flow¥8.5bn2023-03-01 → 2023-08-31Cons.Net cash provided by used in investment activities
Investing cash flow¥2.6bn2022-03-01 → 2023-02-28Cons.Net cash provided by used in investing activities (5-year summary)
Investing cash flow−¥3.0bn2022-03-01 → 2022-08-31Cons.Net cash provided by used in investment activities
Financing cash flow¥10.4bn2023-03-01 → 2023-08-31Cons.Net cash provided by used in financing activities
Financing cash flow−¥6.6bn2022-03-01 → 2023-02-28Cons.Net cash provided by used in financing activities (5-year summary)
Financing cash flow¥3.4bn2022-03-01 → 2022-08-31Cons.Net cash provided by used in financing activities
EPS (basic)¥18.762023-03-01 → 2023-08-31Cons.Basic earnings loss per share (5-year summary)
EPS (basic)¥15.552023-06-01 → 2023-08-31dCons.Basic earnings loss per share (5-year summary)
EPS (basic)¥20.452022-03-01 → 2023-02-28Cons.Basic earnings loss per share (5-year summary)
EPS (basic)¥7.382022-03-01 → 2022-08-31Cons.Basic earnings loss per share (5-year summary)
EPS (basic)¥4.092022-06-01 → 2022-08-31dCons.Basic earnings loss per share (5-year summary)
Equity ratio30.3%at 2023-08-31Cons.Equity to asset ratio (5-year summary)
Equity ratio30.4%at 2023-02-28Cons.Equity to asset ratio (5-year summary)
Equity ratio29.2%at 2022-08-31Cons.Equity to asset ratio (5-year summary)

Periods use the dates stated in the filing. d = earlier-year period dated by calendar; v = that date confirmed by the company's own earlier filing.

Segments · 124
SegmentItemPeriodValue
Reconciling Itemsreconcilingcapex2023-03-01 → 2023-08-31¥3m
Reconciling Itemsreconcilingcapex2023-06-01 → 2023-08-31¥3m
Reconciling Itemsreconcilingdepreciation2023-03-01 → 2023-08-31¥27m
Reconciling Itemsreconcilingdepreciation2023-06-01 → 2023-08-31¥12m
Reconciling Itemsreconcilingrevenue2023-03-01 → 2023-08-31−¥225m
Reconciling Itemsreconcilingrevenue2023-06-01 → 2023-08-31−¥121m
Reconciling Itemsreconcilingrevenue intersegment2023-03-01 → 2023-08-31−¥225m
Reconciling Itemsreconcilingrevenue intersegment2023-06-01 → 2023-08-31−¥121m
Reconciling Itemsreconcilingsegment assetsat 2023-08-31¥42.6bn
Reconciling Itemsreconcilingsegment assetsat 2023-08-31¥42.6bn
Reconciling Itemsreconcilingsegment profit2023-03-01 → 2023-08-31¥4m
Reconciling Itemsreconcilingsegment profit2023-06-01 → 2023-08-31¥2m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue2023-03-01 → 2023-08-31¥1.5bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue2023-06-01 → 2023-08-31¥782m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue external2023-03-01 → 2023-08-31¥1.3bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue external2023-06-01 → 2023-08-31¥660m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue intersegment2023-03-01 → 2023-08-31¥225m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue intersegment2023-06-01 → 2023-08-31¥121m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment assetsat 2023-08-31¥1.5bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment assetsat 2023-08-31¥1.5bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment profit2023-03-01 → 2023-08-31¥814m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment profit2023-06-01 → 2023-08-31¥428m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentcapex2023-03-01 → 2023-08-31¥1.8bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentcapex2023-06-01 → 2023-08-31¥283m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentdepreciation2023-03-01 → 2023-08-31¥879m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentdepreciation2023-06-01 → 2023-08-31¥439m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue2023-03-01 → 2023-08-31¥3.1bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue2023-06-01 → 2023-08-31¥1.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue external2023-03-01 → 2023-08-31¥3.1bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue external2023-06-01 → 2023-08-31¥1.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment assetsat 2023-08-31¥36.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment assetsat 2023-08-31¥36.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment profit2023-03-01 → 2023-08-31¥1.2bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment profit2023-06-01 → 2023-08-31¥613m
jpcrp040300-q2r_E05314-000Value Addreportable segmentcapex2023-03-01 → 2023-08-31¥733m
jpcrp040300-q2r_E05314-000Value Addreportable segmentcapex2023-06-01 → 2023-08-31¥456m
jpcrp040300-q2r_E05314-000Value Addreportable segmentdepreciation2023-03-01 → 2023-08-31¥1.6bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentdepreciation2023-06-01 → 2023-08-31¥823m
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue2023-03-01 → 2023-08-31¥22.1bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue2023-06-01 → 2023-08-31¥14.1bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue external2023-03-01 → 2023-08-31¥22.1bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue external2023-06-01 → 2023-08-31¥14.1bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue intersegment2023-03-01 → 2023-08-31¥0
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue intersegment2023-06-01 → 2023-08-31¥0
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment assetsat 2023-08-31¥275.7bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment assetsat 2023-08-31¥275.7bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment profit2023-03-01 → 2023-08-31¥3.5bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment profit2023-06-01 → 2023-08-31¥2.0bn
—segment totalcapex2023-03-01 → 2023-08-31¥2.6bn
—segment totalcapex2023-06-01 → 2023-08-31¥739m
—segment totaldepreciation2023-03-01 → 2023-08-31¥2.5bn
—segment totaldepreciation2023-06-01 → 2023-08-31¥1.3bn
—segment totalrevenue2023-03-01 → 2023-08-31¥26.7bn
—segment totalrevenue2023-06-01 → 2023-08-31¥16.5bn
—segment totalrevenue external2023-03-01 → 2023-08-31¥26.5bn
—segment totalrevenue external2023-06-01 → 2023-08-31¥16.3bn
—segment totalrevenue intersegment2023-03-01 → 2023-08-31¥225m
—segment totalrevenue intersegment2023-06-01 → 2023-08-31¥121m
—segment totalsegment assetsat 2023-08-31¥313.8bn
—segment totalsegment assetsat 2023-08-31¥313.8bn
—segment totalsegment profit2023-03-01 → 2023-08-31¥5.5bn
—segment totalsegment profit2023-06-01 → 2023-08-31¥3.0bn
Reconciling Itemsreconcilingcapex2022-03-01 → 2022-08-31¥53m
Reconciling Itemsreconcilingcapex2022-06-01 → 2022-08-31¥49m
Reconciling Itemsreconcilingdepreciation2022-03-01 → 2022-08-31¥29m
Reconciling Itemsreconcilingdepreciation2022-06-01 → 2022-08-31¥15m
Reconciling Itemsreconcilingrevenue2022-03-01 → 2022-08-31−¥231m
Reconciling Itemsreconcilingrevenue2022-06-01 → 2022-08-31−¥124m
Reconciling Itemsreconcilingrevenue intersegment2022-03-01 → 2022-08-31−¥231m
Reconciling Itemsreconcilingrevenue intersegment2022-06-01 → 2022-08-31−¥124m
Reconciling Itemsreconcilingsegment assetsat 2022-08-31¥25.8bn
Reconciling Itemsreconcilingsegment assetsat 2022-08-31¥25.8bn
Reconciling Itemsreconcilingsegment profit2022-03-01 → 2022-08-31−¥19m
Reconciling Itemsreconcilingsegment profit2022-06-01 → 2022-08-31−¥10m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue2022-03-01 → 2022-08-31¥1.2bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue2022-06-01 → 2022-08-31¥651m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue external2022-03-01 → 2022-08-31¥998m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue external2022-06-01 → 2022-08-31¥527m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue intersegment2022-03-01 → 2022-08-31¥230m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentrevenue intersegment2022-06-01 → 2022-08-31¥124m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment assetsat 2022-08-31¥1.4bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment assetsat 2022-08-31¥1.4bn
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment profit2022-03-01 → 2022-08-31¥681m
jpcrp040300-q2r_E05314-000Asset Managementreportable segmentsegment profit2022-06-01 → 2022-08-31¥358m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentcapex2022-03-01 → 2022-08-31¥485m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentcapex2022-06-01 → 2022-08-31¥123m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentdepreciation2022-03-01 → 2022-08-31¥876m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentdepreciation2022-06-01 → 2022-08-31¥438m
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue2022-03-01 → 2022-08-31¥3.2bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue2022-06-01 → 2022-08-31¥1.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue external2022-03-01 → 2022-08-31¥3.2bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentrevenue external2022-06-01 → 2022-08-31¥1.6bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment assetsat 2022-08-31¥36.8bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment assetsat 2022-08-31¥36.8bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment profit2022-03-01 → 2022-08-31¥1.4bn
jpcrp040300-q2r_E05314-000Clean Energyreportable segmentsegment profit2022-06-01 → 2022-08-31¥720m
jpcrp040300-q2r_E05314-000Value Addreportable segmentcapex2022-03-01 → 2022-08-31¥4.0bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentcapex2022-06-01 → 2022-08-31¥260m
jpcrp040300-q2r_E05314-000Value Addreportable segmentdepreciation2022-03-01 → 2022-08-31¥1.7bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentdepreciation2022-06-01 → 2022-08-31¥862m
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue2022-03-01 → 2022-08-31¥21.3bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue2022-06-01 → 2022-08-31¥6.7bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue external2022-03-01 → 2022-08-31¥21.3bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue external2022-06-01 → 2022-08-31¥6.7bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue intersegment2022-03-01 → 2022-08-31¥0
jpcrp040300-q2r_E05314-000Value Addreportable segmentrevenue intersegment2022-06-01 → 2022-08-31¥0
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment assetsat 2022-08-31¥277.4bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment assetsat 2022-08-31¥277.4bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment profit2022-03-01 → 2022-08-31¥3.0bn
jpcrp040300-q2r_E05314-000Value Addreportable segmentsegment profit2022-06-01 → 2022-08-31¥1.3bn
—segment totalcapex2022-03-01 → 2022-08-31¥4.5bn
—segment totalcapex2022-06-01 → 2022-08-31¥384m
—segment totaldepreciation2022-03-01 → 2022-08-31¥2.6bn
—segment totaldepreciation2022-06-01 → 2022-08-31¥1.3bn
—segment totalrevenue2022-03-01 → 2022-08-31¥25.7bn
—segment totalrevenue2022-06-01 → 2022-08-31¥9.0bn
—segment totalrevenue external2022-03-01 → 2022-08-31¥25.5bn
—segment totalrevenue external2022-06-01 → 2022-08-31¥8.8bn
—segment totalrevenue intersegment2022-03-01 → 2022-08-31¥231m
—segment totalrevenue intersegment2022-06-01 → 2022-08-31¥124m
—segment totalsegment assetsat 2022-08-31¥315.6bn
—segment totalsegment assetsat 2022-08-31¥315.6bn
—segment totalsegment profit2022-03-01 → 2022-08-31¥5.1bn
—segment totalsegment profit2022-06-01 → 2022-08-31¥2.4bn

Segment names come from EDINET member IDs; not yet mapped to a common taxonomy.

All source rows · 790
ItemContextValueUnit
Foreign exchange gains noiCurrentQuarterDuration0JPY
Gain on valuation of derivatives noiPrior1QuarterDuration67000000JPY
Gain on valuation of derivatives noiCurrentQuarterDuration180000000JPY
Other noiPrior1QuarterDuration25000000JPY
Other noiCurrentQuarterDuration118000000JPY
Non operating incomePrior1QuarterDuration112000000JPY
Non operating incomeCurrentQuarterDuration385000000JPY
Interest expenses noePrior1QuarterDuration549000000JPY
Interest expenses noeCurrentQuarterDuration592000000JPY
Finance costs noePrior1QuarterDuration74000000JPY
Finance costs noeCurrentQuarterDuration93000000JPY
Other noePrior1QuarterDuration48000000JPY
Other noeCurrentQuarterDuration119000000JPY
Non operating expensesPrior1QuarterDuration672000000JPY
Non operating expensesCurrentQuarterDuration805000000JPY
Ordinary incomePrior1QuarterDuration1799000000JPY
Ordinary incomeCurrentQuarterDuration2618000000JPY
Gain on sales of noncurrent assets eiPrior1QuarterDuration1094000000JPY
Gain on sales of noncurrent assets eiCurrentQuarterDuration4132000000JPY
Gain on sales of investment securities eiPrior1QuarterDuration-JPY
Gain on sales of investment securities eiCurrentQuarterDuration4000000JPY
Gain on sales of subsidiaries and affiliates stocks eiPrior1QuarterDuration-JPY
Gain on sales of subsidiaries and affiliates stocks eiCurrentQuarterDuration3952000000JPY
Other eiPrior1QuarterDuration-JPY
Other eiCurrentQuarterDuration5000000JPY
Extraordinary incomePrior1QuarterDuration1094000000JPY
Extraordinary incomeCurrentQuarterDuration8095000000JPY
Provision of allowance for doubtful accounts elPrior1QuarterDuration-JPY
Provision of allowance for doubtful accounts elCurrentQuarterDuration409000000JPY
Extraordinary lossPrior1QuarterDuration-JPY
Extraordinary lossCurrentQuarterDuration409000000JPY
Income before income taxesPrior1QuarterDuration2894000000JPY
Income before income taxesCurrentQuarterDuration10304000000JPY
Income taxesPrior1QuarterDuration947000000JPY
Income taxesCurrentQuarterDuration3198000000JPY
Profit lossPrior1QuarterDuration1946000000JPY
Profit lossCurrentQuarterDuration7106000000JPY
Profit loss attributable to non controlling interestsPrior1QuarterDuration51000000JPY
Profit loss attributable to non controlling interestsCurrentQuarterDuration57000000JPY
Profit loss attributable to owners of parentPrior1QuarterDuration1895000000JPY
Profit loss attributable to owners of parentCurrentQuarterDuration7048000000JPY
Profit lossPrior1YTDDuration3537000000JPY
Profit lossCurrentYTDDuration8618000000JPY
Valuation difference on available for sale securities net of tax ociPrior1YTDDuration253000000JPY
Valuation difference on available for sale securities net of tax ociCurrentYTDDuration55000000JPY
Deferred gains or losses on hedges net of tax ociPrior1YTDDuration57000000JPY
Deferred gains or losses on hedges net of tax ociCurrentYTDDuration-63000000JPY
Other comprehensive incomePrior1YTDDuration310000000JPY
Other comprehensive incomeCurrentYTDDuration-8000000JPY
Comprehensive incomePrior1YTDDuration3847000000JPY

Every row of the EDINET CSV. Item names are the XBRL element names; filed text is kept in its original Japanese. Filed text is available on Plus and Pro.

Data checks · 19 of 19 passed
balance sheet identityconsolidated 2023-02-28pass
balance sheet identityconsolidated 2023-08-31pass rounding
dei present pass
period resolution pass
statement vs summary · net assetsconsolidated 2023-02-28pass
statement vs summary · net assetsconsolidated 2023-08-31pass
statement vs summary · net income attributable to parentconsolidated 2022-03-01/2022-08-31pass
statement vs summary · net income attributable to parentconsolidated 2022-06-01/2022-08-31pass
statement vs summary · net income attributable to parentconsolidated 2023-03-01/2023-08-31pass
statement vs summary · net income attributable to parentconsolidated 2023-06-01/2023-08-31pass
statement vs summary · operating cash flowconsolidated 2022-03-01/2022-08-31pass
statement vs summary · operating cash flowconsolidated 2023-03-01/2023-08-31pass
statement vs summary · revenueconsolidated 2022-03-01/2022-08-31pass
statement vs summary · revenueconsolidated 2022-06-01/2022-08-31pass
statement vs summary · revenueconsolidated 2023-03-01/2023-08-31pass
statement vs summary · revenueconsolidated 2023-06-01/2023-08-31pass
statement vs summary · total assetsconsolidated 2022-08-31pass
statement vs summary · total assetsconsolidated 2023-02-28pass
statement vs summary · total assetsconsolidated 2023-08-31pass