Skip to main content

Performance Metrics of Trial Balance Run

Zuora

Performance Metrics of Trial Balance Run

This article contains details of the performance metrics of a journal run.

Performance metrics calculation

Performance metrics is calculated using the following method:

Zuora Trial Balance Run Duration(in minutes)  ≈ Max of (Number of transactions being processed / Average Transaction Processing Throughput)

Type

Transactions in the report

Throughput

AR Aging Report

Based on the Billing Account/Invoice/Debit Memo which has non zero balance as of accounting period end date

120,000 / min

AR Detail Report

The billing transactions whose transaction date is in the accounting period

400,000 / min

Revenue Detail Report

Based on revenue schedule which has recognized amount in and after the accounting period

400,000 / min

Realized FX Gain Loss Report

  1. Home currency is set;
  2. The payment, refund, credit memo whose transaction date is in the accounting period

20,000 / min

Unrealized FX Gain Loss Report

  1. Home currency is set;
  2. The invoice/debit memo/credit memo/unapplied payment which has none zero balance as of accounting period end date

14,000 / min

For example,

Type

Total Transactions Data Volume

Throughput

Duration

AR Aging Report

1,000,000

120,000 / min

8.33 min

AR Detail Report

5,000,000

400,000 / min

12.5 min

Revenue Detail Report

10,000,000

400,000 / min

25 min

Realized FX Gain Loss Report

3,000,000

20,000 / min

150 min

Unrealized FX Gain Loss Report

200,000

14,000 / min

14.28 min

The trial balance job duration depends on the longest subtask, which is the “Realized FX Gain Loss Report” in the example, and it is 150 minutes.

Notes

  • The trial balance formula are reference speeds when Performance Booster enabled.
  • The average throughput is based on the assumption that the customer uses 3~4 segments on common objects and has currency conversion enabled. For customers using more complex segmentation, trial balance may take longer than stated in the example above. 
  • The performance metrics are based on basic AWS hardware configure. Better hardware can further improve performance.