# Oracle EBS AR Aging Bad Debt Reserve Calculator

> Source: https://netray.co/tools/oracle-ebs-ar-aging-bad-debt-reserve-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Apply loss rates to Oracle Receivables aging buckets to estimate the allowance for doubtful accounts and the reserve percentage.

## Category

oracle

## Erp

Oracle E-Business Suite

## Audience

- Controller
- Credit manager
- Accounts receivable manager
- EBS finance user

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Current balance

**Key:** amt_current

**Type:** number

**Default:** 1800000

**Min:** 0

**Step:** 10000

**Unit:** $

#### 1 to 30 days past due

**Key:** amt_30

**Type:** number

**Default:** 420000

**Min:** 0

**Step:** 10000

**Unit:** $

#### 31 to 60 days past due

**Key:** amt_60

**Type:** number

**Default:** 210000

**Min:** 0

**Step:** 10000

**Unit:** $

#### 61 to 90 days past due

**Key:** amt_90

**Type:** number

**Default:** 95000

**Min:** 0

**Step:** 5000

**Unit:** $

#### Over 90 days past due

**Key:** amt_over90

**Type:** number

**Default:** 140000

**Min:** 0

**Step:** 5000

**Unit:** $

#### Loss rate: current

**Key:** pct_current

**Type:** number

**Default:** 0.5

**Min:** 0

**Max:** 100

**Step:** 0.1

**Unit:** %

#### Loss rate: 1 to 30

**Key:** pct_30

**Type:** number

**Default:** 2

**Min:** 0

**Max:** 100

**Step:** 0.1

**Unit:** %

#### Loss rate: 31 to 60

**Key:** pct_60

**Type:** number

**Default:** 8

**Min:** 0

**Max:** 100

**Step:** 0.1

**Unit:** %

#### Loss rate: 61 to 90

**Key:** pct_90

**Type:** number

**Default:** 20

**Min:** 0

**Max:** 100

**Step:** 0.5

**Unit:** %

#### Loss rate: over 90

**Key:** pct_over90

**Type:** number

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

**Outputs:**

#### Total receivables

**Key:** total_ar

**Expr:** amt_current + amt_30 + amt_60 + amt_90 + amt_over90

**Format:** currency

#### Required allowance

**Key:** reserve

**Expr:** amt_current * pct_current / 100 + amt_30 * pct_30 / 100 + amt_60 * pct_60 / 100 + amt_90 * pct_90 / 100 + amt_over90 * pct_over90 / 100

**Format:** currency

**Primary:** true

#### Allowance as share of AR

**Key:** reserve_pct

**Expr:** reserve / total_ar * 100

**Format:** percent

**Primary:** true

#### Net receivables

**Key:** net_ar

**Expr:** total_ar - reserve

**Format:** currency

#### Share of AR past due

**Key:** past_due_pct

**Expr:** (total_ar - amt_current) / total_ar * 100

**Format:** percent

**Chart:**

#### Allowance vs loss rate on over 90 bucket

**Type:** line

**X:** pct_over90

**From:** 0

**To:** 100

**Steps:** 21

**Series:**

- reserve

**Disclaimer:** Loss rates are inputs you must support with your own write-off history. Under US GAAP CECL and IFRS 9 expected credit loss models, rates should also reflect forecasts. Confirm with your auditors.

## Content

**Intro:** The aging method is the simplest defensible way to size an allowance for doubtful accounts: multiply each aging bucket by a historical loss rate and add them up. This tool does that math and shows how sensitive the result is to your oldest bucket.

**Sections:**

#### How to use it

**Body:** Run the Receivables aging report (such as the Aging - 7 Buckets report or the Aging - 4 Buckets report) as of your period end, ideally by operating unit and functional currency. Enter the five bucket totals, then enter loss rates derived from your own history of write-offs by bucket. Look at the allowance and the reserve percentage, then compare to the current balance in your allowance account in the general ledger to see the adjusting entry required.

**Bullets:**

- Exclude disputed or credit memo items you intend to handle separately.
- Calculate rates by customer segment if risk differs widely.
- Document the source of every rate for the auditors.

#### The method

**Body:** Allowance equals the sum over buckets of balance times loss rate. Loss rates come from historical data: for each bucket, the share of balances that eventually became uncollectible over a look-back of 2 to 3 years. The reserve percentage is allowance divided by total receivables, and net receivables is total minus allowance. Many companies layer specific reserves for known troubled customers on top of the aging-based amount, which this tool does not include.

#### Reading it and common mistakes

**Body:** The oldest bucket usually dominates the answer, which is why the chart sweeps that rate. If a 10-point change in the over-90 rate moves the reserve by more than your materiality threshold, invest in better loss data for that bucket. Common mistakes include mixing currencies, using on-account cash and unapplied receipts incorrectly, and aging by invoice date when your policy is to age by due date.

**Bullets:**

- Make sure unapplied cash is netted consistently in the buckets.
- Review at least quarterly because loss rates drift.
- Record the entry in the period, not retroactively.

**Cta:** If you want aging and reserve analysis refreshed daily from your Receivables data with the reasoning visible, we can set up a read-only private view over your EBS database.

**Faq:**

#### What loss rates should I use?

**Answer:** Use your own write-off history by aging bucket over two to three years, adjusted for current conditions. Industry rules of thumb are only a placeholder until you have your own data, and auditors will ask for support.

#### Does this satisfy CECL or IFRS 9?

**Answer:** An aging matrix is an accepted practical approach for trade receivables under both frameworks when rates are supported by history and adjusted for forecasts. Your accountants must confirm the specifics for your entity.

#### Which Oracle report supplies the buckets?

**Answer:** Oracle Receivables provides aging reports with 4 or 7 configurable buckets. Use the one configured to match your policy, run as of the period end, and reconcile the total to the AR control account.

#### How do I handle specific reserves?

**Answer:** Add them after this calculation for named high-risk customers, and remove those balances from the buckets above to avoid double counting. Document the rationale for each specific reserve.

## Search terms

bad debt reserve calculator, allowance for doubtful accounts aging method, oracle receivables aging report reserve, ar aging reserve percentage, oracle ebs ar aging buckets, aging method bad debt estimate, accounts receivable provisioning calculator

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json