calculate-loan

01 Loan payments

A/R Balance: Meaning, Formula, and Calculator

Calculator No. 01-13062 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An A/R balance is the amount customers owe a business for goods or services already provided on credit. Enter the opening accounts receivable balance, credit sales, and customer payments or credits for a period to calculate the ending balance. The calculator uses the basic accounts-receivable roll-forward; it does not estimate whether the balance will be collected.

Formula

The ending accounts receivable balance equals the beginning balance plus credit sales, minus customer payments and credits recorded during the period:

Ending A/R = Beginning A/R + Credit sales − Payments and credits

  • Beginning A/R is the unpaid customer balance at the start of the period, in dollars.
  • Credit sales are sales made on account during the period, in dollars. Cash sales are excluded because they do not create a receivable.
  • Payments and credits are amounts that reduce customers’ balances, in dollars. They can include cash received, credit notes, returns, or other adjustments that reduce receivables.
  • Ending A/R is the amount still recorded as owed at period end, in dollars.

The calculator requires payments and credits to be no greater than the beginning balance plus credit sales. If the entered reduction exceeds the available receivable, it reports that the calculation cannot be made. That check prevents a negative result from being presented as an ordinary A/R balance; investigate the period, account scope, or adjustments instead.

Worked Example

Using the calculator’s default values:

  1. Beginning A/R balance: $10,000.
  2. Add credit sales: $10,000 + $25,000 = $35,000.
  3. Subtract customer payments and credits: $35,000 − $18,000 = $17,000 ending A/R.

The $17,000 is a point-in-time total of unpaid receivables at the period’s end. It does not mean every dollar is overdue or that every invoice is likely to be collected.

Assumptions

  • The opening amount and period activity refer to the same business, currency, and A/R accounts.
  • Credit sales are added when they are recorded as receivables; payments and credits are subtracted when they are recorded against those receivables.
  • The calculation treats all receivables as a single total and assumes the inputs are complete and correctly classified.
  • No interest, financing schedule, compounding, tax, or collection forecast is modelled.
  • Bad-debt write-offs and other adjustments must be included among reductions if they decrease the recorded receivable; use the accounting records’ actual treatment.

What A/R Balance Means in Accounting

“A/R” is a standard abbreviation for accounts receivable, not slang or a separate accounting term. “A/R balance” is also standard business and bookkeeping shorthand for the balance of the accounts receivable account or accounts. The abbreviation comes from the initials of “accounts receivable”; the phrase describes a balance-sheet asset arising when a business has a right to receive payment from a customer.

In everyday use, it appears in sentences such as, “The A/R balance at month-end was $17,000,” or, “Please reconcile the customer’s A/R balance to the open invoices.” The exact scope can vary: a speaker might mean the company-wide ledger balance, one customer’s balance, or balances for a particular division. Reports should make that scope and the “as of” date clear.

A/R usually concerns amounts billed or otherwise recognized as due from customers in the ordinary course of business. It is different from cash: a customer’s promise to pay is not money already received. It is also different from accounts payable, which records amounts the business owes its suppliers.

How the Balance Changes

Each transaction that creates or reduces a receivable changes the running balance. A simplified example is a business that starts with $10,000 owed, invoices customers $25,000 on credit, and receives $18,000 in payments and credits. Its ending balance is $17,000. If it also makes a $1,000 credit for a returned item, and that credit is not already included in the $18,000, the balance becomes $16,000.

In actual bookkeeping, the A/R control account is supported by customer-level records. An invoice generally increases the customer’s receivable; a payment applied to that invoice decreases it. A credit memo, refund, write-off, or reclassification may also affect the ledger, depending on how it is recorded. The basic formula is a useful reconciliation, but it does not replace the detailed entries or a review of the general ledger.

One important distinction is cash sales versus credit sales. A cash sale normally increases cash rather than A/R, so it should not be added as credit sales in this calculation. If a customer pays immediately after receiving an invoice, the sale may create a receivable and the payment then reduce it, but the period-end balance reflects what remains unpaid after both entries.

Reading and Checking an A/R Balance

An ending balance is a snapshot, not a measure of collection speed or credit quality. Two businesses with the same A/R total can have very different invoice ages, customer concentrations, or payment histories. To understand what makes up the amount, compare the ledger balance with the open-invoice detail and review an A/R aging report, which groups outstanding invoices by how long they have been outstanding.

  • Confirm the report’s date and whether it includes all relevant customers and entities.
  • Reconcile the total of customer balances to the A/R control account in the general ledger.
  • Check that cash receipts are applied to the correct customer and invoice, and that credits or returns are not counted twice.
  • Review unusual debit or credit balances, unapplied cash, disputed invoices, and stale items.
  • Compare the balance with prior periods only when the period lengths and accounting scope are comparable.

Accounts receivable is commonly shown as a current asset when expected to be realized within the business’s operating cycle or the applicable reporting classification. The gross receivable and any allowance for expected credit losses may be presented or analyzed separately according to the entity’s accounting framework. Therefore, a reported net receivables figure may differ from a gross open-invoice total. This calculator computes the simple activity-based ending balance; it does not calculate an allowance or determine financial-statement presentation.

Common Misunderstandings

A common mistake is treating the A/R balance as revenue. Revenue describes sales recognized during a period; A/R is the unpaid portion of customer amounts recorded as receivable at a particular date. A business can record revenue and later collect cash, while the receivable decreases. The two figures are related but are not interchangeable.

Another misconception is that a positive balance means all customers are late. Some invoices may not yet be due. Conversely, a modest total does not establish that the accounts are collectible. Aging, contract terms, disputes, subsequent receipts, and customer-specific information are relevant to collection analysis, but none can be inferred from the total alone.

Finally, “A/R balance” does not necessarily mean one invoice’s amount. It can refer to an individual customer account or the full receivables ledger. Ask what entity, customers, and date are included before comparing two figures.

Frequently Asked Questions

What does A/R stand for?
A/R stands for accounts receivable: amounts customers owe a business for goods or services supplied on credit. It is a standard abbreviation used in accounting and business records.

How do you calculate an ending A/R balance?
Add credit sales to the beginning A/R balance, then subtract payments and other credits that reduce receivables. The result is the ending balance, provided the activity and account scope are consistent.

Is an A/R balance an asset?
Generally, yes. It represents a claim for payment from customers and is recorded as an asset, subject to applicable accounting treatment and any allowance or adjustment for amounts not expected to be collected.

Is A/R the same as revenue?
No. Revenue is a measure of sales recognized over a period; A/R is the amount recorded as owed at a point in time. Credit sales can increase both revenue and receivables, while later customer payments reduce receivables without creating new revenue.

What is the difference between A/R and A/P?
Accounts receivable is money customers owe the business. Accounts payable is money the business owes suppliers or other creditors. They represent opposite sides of business transactions.

Does a high A/R balance mean customers are not paying?
Not by itself. The total does not show invoice due dates or age. Review an aging report, payment applications, and customer details to understand whether amounts are current, overdue, disputed, or at risk.

Related

Formula used
in beg | Beginning A/R balance | $ | 10000 | 0 | 1000000000000
in sales | Credit sales during period | $ | 25000 | 0 | 1000000000000
in paid | Customer payments and credits | $ | 18000 | 0 | 1000000000000
out end | Ending A/R balance | $ | beg + sales - paid + 0 * sqrt(paid - beg - sales) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →