A Monthly Indicator of Turnover using Business Activity Statement Data

This paper describes the key findings of recent work to develop a monthly indicator of turnover based on Business Activity Statement data

Released
10/06/2021

Oksana Honchar, Kayla McIntosh and Sabrina Zheng¹

Introduction

The Australian Bureau of Statistics (ABS) is focused on maximising the value of existing ABS data and utilising alternative data sources including Single Touch Payroll (STP), Business Activity Statement (BAS) data, and aggregated de-identified banks transactions data to provide insights to inform decision making.

The ABS has been exploring potential uses of these datasets, including their suitability as data sources for more frequent and timely economic indicators.

This information paper summarises the key findings of recent work to develop a monthly indicator of turnover (‘the indicator’) by industry using BAS data. It describes the concepts, data sources, methodologies, and quality assessment of the indicator estimates.

This program of work also includes the development of monthly indicators of:

  • household spending using payments data from banks. The ABS has recently published a progress update on this project.
  • employee earnings using STP data.

Periodically the ABS will provide updates on the development of these indicators.

Feedback on the methodologies and the experimental estimates published in this paper is welcomed by email to national.accounts@abs.gov.au.

Footnotes

Approach

The development of the indicators focuses on testing: the suitability of BAS as the primary data source; the alignment with the national accounts concept of output; and the quality of the estimates produced. Data users were consulted in relation to their requirements, and to assess user satisfaction.

This information paper presents:

  • how the proposed measure of turnover fits within the existing measures of economic activity
  • the methodologies applied to transform raw BAS data into the indicator
  • a quality assessment of the indicator using the ABS Data Quality Framework
  • conclusions reached and intended next steps
  • a timeseries of the indicator for selected industries (in the associated datacubes).

Gross Domestic Product and Turnover

Gross Domestic Product (GDP) estimates are used as the key measure of economic activity in Australia. Data on businesses’ sales, or turnover, are a critical building block in the calculation of GDP, and hence there is a desire to ensure the indicator aligns with, and can support, the national accounts. This section explains the relationship between national accounts estimates and business turnover data.

The System of National Accounts (SNA) 2008 defines output as the value of total sales (or other uses of goods and services produced as outputs) plus the value of changes in the inventories of goods produced². There are three types of output in an economy³:

  • Market output is goods and services sold at economically significant prices or otherwise disposed of on the market, or output that is intended for sale or disposal on the market
  • Non-market output is goods and services supplied for free, or at prices that are not economically significant⁴
  • Output produced for own final use is goods and services retained for their own final use by the owners of the enterprises in which they are produced.  

Sales data from the Quarterly Business Indicator Survey (QBIS) and other data sources are used as an indicator of output for most industries in the quarterly national accounts. A more extensive approach, and a more complete set of data, are used for the annual national accounts⁵.

Conceptually, BAS turnover has reasonably good alignment with QBIS sales. They both measure the goods or services sold and supplied by businesses, the sale or lease of land and building, as well as the income from providing goods or services for sponsorship. Dividend income is excluded from both QBIS and BAS. Despite the similarities, there are scope differences. For example, QBIS sales exclude interest income and sale of business assets, whereas these are included in BAS turnover.

There are differences in the basis of QBIS and BAS reporting. QBIS is typically reported on a Profit and Loss (P&L) statement basis. In contrast BAS is reported on a Goods and Services Tax (GST) liabilities and credits basis. This means that BAS turnover relates to cash flows where the business is acting as an 'agent', with related income and expenses not appearing on the P&L statement. This difference between BAS turnover and QBIS sales can lead to significant discrepancies for industries that include a high proportion of commission-based activity. Examples include financial services, travel agents, advertising, and real estate services.

BAS turnover is better suited to capturing market output of private and public corporations. Therefore, industries with a large share of non-market output, namely, Public Administration and Safety, Education and Training, and Health Care and Social Assistance, are excluded from the indicator.

The similarities in characteristics of QBIS and BAS, and the use of QBIS in the quarterly national accounts provide opportunities for more timely insights into economic activity through the monthly indicator. However, output is only one aspect of a broader approach to measuring economic activity by industry as shown in figure 1, and there are known differences in scope between BAS and QBIS.

Figure 1. Industry output and gross value added at basic prices

This diagram shows output is one of the components in measuring gross value added, and more broadly gross domestic product. Other components include intermediate consumption and taxes on products less subsidies on products.
This diagram shows output is one of the components in measuring gross value added, and more broadly gross domestic product. The output includes market output, non-market output and output for own final use. Gross domestic product is derived by output less intermediate consumption plus taxes on products less subsidies on products.

Footnotes

Business Activity Statement Data

The Australian Taxation Office (ATO) collects BAS turnover data for the purposes of administering the GST, and provides it to the ABS for statistical purposes. Monthly BAS reporting covers businesses with GST annual turnover of $20 million or more and a proportion of smaller businesses that report BAS monthly on a voluntary basis.

The monthly BAS submission is due on the 21st day of the month following the end of the taxable period⁶. For example, a July monthly BAS is due on 21 August. If businesses want to fix a mistake in the BAS form or make adjustments, they can either fix the error(s) in the next BAS submission or revise the original via a revision lodgement.

Footnotes

Methodology

Defining scope

The indicator includes all ‘alive’ employing and non-employing businesses in all types of economic activity with a few exceptions⁷. Both public corporations and private businesses that produce market output are in scope of the indicator.

ABS Business Register and frames

The ABS Business Register is a list of organisations which undertake economic activity in Australia⁸. The data on the ABS Business Register is primarily sourced from the Australian Business Register (ABR), the ATO and via ABS profiling of large, and/or complex businesses⁹. The ABS uses an Economic Units Model on the ABS Business Register to describe the characteristics of businesses, and the structural relationships between related businesses.

To ensure coherence across the various ABS collections, an extract from the ABS Business Register is taken each quarter. This extract, used as the sampling frame for ABS business surveys, is called the ‘Common Frame’¹⁰.

To produce the indicator a population of monthly BAS remitters is linked to the last available Common Frame. For example, the indicator estimates for April, May and June 2020 use the June 2020 Common Frame that is extracted from the ABS Business Register at the end of May. The July 2020 estimates use the September 2020 Common Frame, as the data is extracted around the same time the September frame is available in the ABS Business Register. The BAS data must be linked to the Common Frame in order to:

  • Limit the BAS population to the indicator scope
  • Enable the production of the indicator by industry
  • Assess and adjust for population under-coverage.

Statistical unit model

Statistical units are used to represent the individual businesses within the covered population. Statistical units on the ABS Business Register are based on the ABS Economic Units Model (EUM), which is used to describe the structure of Australian businesses and other organisations¹¹.

The EUM consists of the following:

  • Enterprise group (EG): an institutional unit that covers all operations within Australia's economic territory of legal entities under common control. Control is defined in Corporations legislation, and majority ownership is not required for control to be exercised.
  • Legal entity (LE): a unit that covers all operations in Australia of an entity which possesses some or all of the rights and obligations of individual persons or corporations, or which behaves as such in respect of those matters of concern for economic statistics. Examples of legal entities include companies, partnerships, trusts, sole (business) proprietorships, government departments and statutory authorities.
  • Type of activity unit (TAU): a producing unit comprising one or more legal entities, sub-entities or branches of a legal entity that can report productive and employment activities via a minimum set of data items. If accounts that are sufficient to approximate industry value added are available at the Australian and New Zealand Standard Industry Classification (ANZSIC) subdivision level, a TAU will be formed.
  • Location: a single, unbroken physical area, occupied by an organisation, at which or from which, the organisation is engaged in productive activity on a relatively permanent basis, or at which the organisation is undertaking capital expenditure with the intention of commencing productive activity on a relatively permanent basis at some time in the future.

Figure 2. ABS Economic Units Model

This diagram shows the ABS Economic Units Model, which is used by the ABS to describe the structure of Australian businesses and other organisations.
This diagram shows the ABS Economic Units Model, which is used by the ABS to describe the structure of Australian businesses and other organisations. The model outlines the logical hierarchical relationships between enterprise group, legal entity, type of activity unit and their respective location.

Derivation of TAU level estimates

When the BAS dataset is linked to the Common Frame, BAS turnover for Australian Business Numbers (ABNs) in the profiled population is proportioned to create TAU level turnover data¹². The ABN level data is aggregated to enterprise group (EG) level and subsequently prorated across TAUs using modelled wages or turnover factors.

Monthly growth rates of the indicator are produced for a period of 10 years. Data are presented at the national level and the published industries are classified according to the Australian and New Zealand Standard Industrial Classification (ANZSIC), 2006.

Time of data extraction

As previously mentioned, the monthly BAS submission is due on the 21st day of the month following the end of the taxable period. In practice, businesses do not always report by the due date. Analysis of how the time of data extractions affects the response rate of the monthly remitters suggests the optimal day to commence analysis and compilation of the indicator is the 28th day of the month following the reference month. By this day, at least 75% of the monthly BAS reports have been submitted and response rates have stabilised.

Analysis also shows that while the accuracy of the data improves after the 28th day following the reference period, there isn’t a considerable change in total turnover.

Data editing

The ABS applies a number of micro-editing techniques to the raw BAS data to adjust for identified errors in the data. Macro-editing is also applied, which involves detecting anomalies through analysis of aggregated data and treating these anomalies. Both micro-editing and macro-editing are incorporated to improve the accuracy of the indicator.

Imputation

Imputation is applied where there are gaps in BAS data due to delays in BAS submissions by monthly remitters. The missing turnover values are imputed using the last historical turnover value adjusted for turnover growth rate and the probability of the unit being alive:

\(\Large y_{t,i}^* = {y_{t - n}} \times \frac{{{{\bar y}_{t,d}}}}{{{{\bar y}_{t - n,d}}}} \times {f_c} \)

where yₜ₋ₙ is the last reported value for variable y for unit i. A growth factor is a ratio of average values of turnover in the current and previous months calculated at sub-industry level using common units across the two months. The factor has not been implemented in the current version of the indicator; however, it is intended to be implemented in a future version of the indicator estimates. The unit’s probability of being alive is calculated at ANZSIC sub-division level using historical data and depends on the individual business and the time lag since the last response. After 12 months since last reported response the probability of a business being alive is set to zero.

Coverage adjustments

The coverage of the indicator consists of the BAS monthly remitters. Under-coverage, such as the exclusion of quarterly and annual remitters, does not allow production of meaningful level estimates without an appropriate coverage adjustment. In terms of movements, under-coverage leads to distorted results if:

  • The movements in the population of quarterly and annual remitters are different to movements in the population of the monthly remitters. In this case the population of the monthly remitters does not represent movements in the whole population; or
  • The coverage of the population of monthly remitters changes over time. In this case movements in the indicator are partly explained by movements in the numbers of units rather than real economic processes.

Analysis shows that the population of monthly remitters adequately represents the turnover movement of the whole population. However, under-coverage adjustment should still be considered given that the population of monthly remitters does not grow at the same rate as the whole population and to also address any sudden changes in the coverage that distort movements in the indicator series.

Footnotes

Timeseries Analysis

Standard ABS seasonal adjustment procedures were applied to eliminate the impact of seasonal patterns on the series. All industries were found to be seasonal, with some having prominent seasonal patterns. Relevant adjustments for extreme values, trend breaks, and calendar effects have been applied as part of the seasonal adjustment process.

For more information on ABS seasonal adjustment methodology, refer to the Time Series Analysis: The Basics.

Quality Assessment

The indicator has been assessed against the different dimensions of quality as defined by the ABS Data Quality Framework. This ensures the fitness for purpose of the indicator, but also describes limitations of the indicator to ensure users are well informed when using this data for their specific purposes. 

Institutional Environment

Relevance

Timeliness

Accuracy

Coherence

Interpretability

Footnotes

Comparison with Quarterly Business Indicator Survey

The indicator is aggregated into a quarterly series to compare with QBIS sales for alignment assessment. To ensure consistency, industries used for comparison have been limited to industries with small (less than 10%) public corporation contribution (figure 3) and are similar in scope to QBIS. This means that for the purposes of comparing to QBIS Agriculture, Forestry and Fishing, Electricity, Gas, Water and Waste Services, Transport, Postal and Warehousing, Financial and Insurance Services, Public Administration and Safety, Education and Training, and Health Care and Social Assistance industries have been excluded.

To determine alignment between the indicator and QBIS sales, a simple observation test was developed with alignment based on the relative frequency that growth is either positive for both the indicator and QBIS sales, or both negative, in the same reference period. The higher the percentage, the more aligned the two series. Industries are classified into one of four categories:

  • Good alignment – alignment equal to, or greater than, 90%
  • Reasonably good alignment – alignment equal to, and between, 80% and 89.9%
  • Poor alignment – alignment equal to, and between, 70% and 79.9%
  • No alignment – alignment less than, or equal to, 69.9%.

Overall, the indicator and QBIS sales align well, though it varies by industry. Ten industries – Mining, Manufacturing, Construction, Wholesale Trade, Retail Trade, Accommodation and Food Services, Information Media and Telecommunications, Professional, Scientific and Technical Services, Administrative and Support Services, and Other Services – have good or reasonably good alignment with QBIS sales. Rental, Hiring and Real Estate Services, and Arts and Recreation Services have poor alignment. This alignment could improve with refinement of the methodologies used to produce the indicator.

When a series has a strong seasonal pattern, alignment between the two series in original terms can be misleading. Excluding the seasonal pattern from the indicator series has resulted in poorer alignment with QBIS.

The following graphs demonstrate the different results of alignment between the indicator, aggregated to a quarterly frequency, and QBIS sales, current price, in original and seasonally adjusted terms¹⁴.

Mining

Manufacturing

Construction

Wholesale Trade

Retail Trade

Accommodation and Food Services

Information Media and Telecommunications

Rental, Hiring and Real Estate Services

Professional, Scientific and Technical Services

Administrative and Support Services

Arts and Recreation Services

Other Services

Contribution of gross value added by industry

The table below shows industry shares of gross value added for the 2018-19 financial year¹⁵. Mining contributes 10.6% to total value added, whereas Construction contributes 7.9%. The table outlines the contribution by industry for the 2018-19 financial year. While this gives an indication of the economic significance of each industry for this point in time, the table doesn’t capture the dynamics of the industries on a monthly basis, nor is it representative of the compositional change in industry share over time.

Table 5. Industry shares of gross value added at basic prices, 2018-19 financial year¹⁶
ANZSIC DivisionPercentage points of industry share of gross value added*
Agriculture, Forestry and Fishing2.3
Mining10.6
Manufacturing6.0
Electricity, Gas, Water and Waste Services2.6
Construction7.9
Wholesale Trade3.9
Retail Trade4.4
Accommodation and Food Services2.4
Transport, Postal and Warehousing4.9
Information Media and Telecommunications2.4
Financial and Insurance Services9.0
Rental, Hiring and Real Estate Services3.1
Professional, Scientific and Technical Services7.3
Administrative and Support Services3.7
Public Administration and Safety5.6
Education and Training5.0
Health Care and Social Assistance7.6
Arts and Recreation Services0.9
Other Services1.9
Ownership of Dwellings8.7

* The percentages are calculated based on the total of all ANZSIC industries. Percentages may not add to 100% due to rounding.

Footnotes

Comparison with Retail Trade Survey

The Retail Trade industry results for the indicator is compared with the monthly Retail Trade Survey (RTS) turnover¹⁷. Cafes, restaurants and takeaway food services has been excluded in RTS to better align the scope to Retail Trade industry in the indicator. There is still some residual misalignment in scope as RTS only includes some of the Retail Trade sub-industries, while the indicator includes all retail trade sub-industries.

The RTS does not include all classes in the ANZSIC Retail Trade division but includes Cafes, restaurants and takeaway food services from the Accommodation and Food Services division. The inclusion of GST and retail businesses that are classified to a non-retail industry also contribute to the differences.

Monthly RTS used excludes cafes, restaurants, and takeaway services, so that the same industry scope is used for this comparison.

Monthly RTS used excludes cafes, restaurants, and takeaway services, so that the same industry scope is used for this comparison.

Footnotes

Conclusion and Where to From Here

The monthly indicator based on BAS turnover has been demonstrated to be a high quality, high frequency economic indicator for selected industries. Following the application of statistical methods to transform the BAS data to an indicator of turnover, the ABS conducted a quality assessment in line with the ABS Data Quality Framework. This assessment focused on the robustness of the estimates in respect to the dimensions of quality, with a particular emphasis on coherence with current lower frequency estimates. This indicator can provide insights to changes in economic conditions in the Australian economy, noting there are some trade-offs in terms of accuracy. Table 6 summarises the results of the assessment of the indicator in respect to various quality dimensions and provides insights into the economic significance of each industry. 

Table 6. Summary of indicator quality and alignment by industry
ANZSIC DivisionAppropriateness of turnover for measuring output (a)Proportion of total turnover reported by monthly remitters, 2019-20 financial year (%) (b)Percentage of imputed turnover, March 2021 (%) (c)Non-response bias as percentage of reported monthly turnover, February 2021 (%) (d)Percentage points of industry share of gross value added, 2018-19 (%) (e)Coherence with QBIS sales, (current price, original) (f)
Agriculture, Forestry and FishingNo34.04.30.02.3N/A (g)
MiningYes96.92.10.010.6Reasonably good
ManufacturingPartial (excludes inventories)84.70.60.06.0Reasonably good
Electricity, Gas, Water and Waste ServicesYes94.54.00.32.6N/A (g)
ConstructionYes47.03.60.07.9Good
Wholesale TradePartial (measures total turnover rather than margin)83.41.10.03.9Reasonably good
Retail TradePartial (measures total turnover rather than margin)73.61.40.04.4Good
Accommodation and Food ServicesYes33.82.20.02.4Reasonably good
Transport, Postal and WarehousingYes77.93.40.64.9N/A (g)
Information Media and TelecommunicationsYes86.90.90.12.4Reasonably good
Financial and Insurance ServicesNo76.00.40.09.0N/A (g)
Rental, Hiring and Real Estate ServicesYes53.53.20.03.1Poor
Professional, Scientific and Technical ServicesYes63.53.20.07.3Reasonably good
Administrative and Support ServicesYes59.61.4-0.53.7Reasonably good
Public Administration and SafetyNo92.52.22.15.6N/A (g)
Education and TrainingNo77.411.0-0.15.0N/A (g)
Health Care and Social AssistanceNo54.91.70.07.6N/A (g)
Arts and Recreation ServicesYes65.15.10.60.9Poor
Other ServicesYes48.31.70.21.9Reasonably good

(a) Refer to section “Gross Domestic Product and Turnover”
(b) Refer to table 1
(c) Refer to table 4
(d) Refer to table 3
(e) The percentages are calculated based on the total of all ANZSIC industries. Ownership of dwellings is separated from Rental Hiring and Real Estate Services and presented separately in the National Accounts. Ownership of dwellings contributes 8.7% to industry share of gross value added.
(f) Refer to section “Comparison with Quarterly Business Indicator Survey”
(g) Industry not included in the QBIS alignment test due to proportion of public sector greater than 10%, and/or appropriateness of QBIS as a data source

This paper has outlined the methodological approach taken by the ABS in developing the indicator, and the key findings from this exploratory work. This provides a firm basis for future work, including updated methods and the experimental indicator of turnover estimates.

Refinement of methodology

The ABS will put this indicator into production and review the methodological approaches. Alternative imputation and coverage adjustment techniques will be tested before publishing the indicator estimates later this year.

Seeking feedback

The ABS will be seeking the feedback from a range of external stakeholders as work proceeds. The feedback will be considered when producing future versions of the indicator. Feedback on this paper is welcome. To provide feedback, or for further enquiries, please email national.accounts@abs.gov.au.

Data Download

Table 1. Monthly indicator of turnover by industry, current price, percentage change from previous month

Disclaimer

The results of this analysis are based, in part, on ABR data supplied by the Registrar to the ABS under A New Tax System (Australian Business Number) Act 1999 and on tax data supplied by the ATO to the ABS under the Taxation Administration Act 1953, which requires that such data is only used for the purpose of administering the Census and Statistics Act 1905. No individual information collected under the Census and Statistics Act 1905 is provided back to the Registrar or ATO for administrative or regulatory purposes. Any discussion of data limitations or weaknesses described in this paper is in the context of using the data for statistical purposes and is not related to the ability of the data to support the ATO's core operational requirements.

Legislative requirements to ensure privacy and secrecy of this data have been adhered to. Only those authorised under the Australian Bureau of Statistics 1975 have been allowed to view data about any particular firm in conducting these analyses. In accordance with the Census and Statistics Act 1905, results have been confidentialised so no person or organisation can be identified.

Acknowledgement

The ABS would like to acknowledge the support from the Australian Taxation Office (ATO) in enabling the ABS to produce these statistics.
The ABS would also like to thank the Reserve Bank of Australia (RBA) for their contribution in the development of the indicator.

Back to top of the page