📘 How Merchant Deposits Should Be Recorded: What That Deposit Really Means

A business owner opens the bank account and sees a merchant-processing deposit of $970.

It is tempting to categorize that deposit as:

Sales Revenue — $970

After all, that is the amount that arrived in the bank.

But there is an important problem.

The bank deposit may represent the net amount paid to you by the merchant processor, not the amount your customers actually purchased from your business.

Suppose a customer paid $1,000 by credit card and the processor withheld a $30 processing fee.

The bank receives:

$970

But the business actually generated:

$1,000 of sales

and incurred:

$30 of merchant-processing fees

Those are three related—but different—pieces of information.

Understanding that distinction can make a significant difference in the accuracy of your revenue, expenses, profit margins, and financial reports.

---

💳 The Common Merchant-Deposit Misconception

The misconception sounds reasonable:

“If $970 showed up in my bank account, I must have had $970 of sales.”

Not necessarily.

A merchant processor such as a credit-card processor, online payment service, or point-of-sale provider may collect money from customers on your behalf.

Before transferring that money to your bank account, the processor may deduct items such as:

• Processing fees
• Refunds
• Chargebacks
• Adjustments
• Other processor-specific charges

That means the amount deposited into your bank account can be different from the amount your customers actually paid.

The bank deposit is a cash movement.

It is not automatically your sales number.

---

📊 A Simple Step-by-Step Example

Suppose your business makes one card sale.

The customer pays:

$1,000

The merchant processor charges:

$30

The amount deposited into your bank is:

$970

The economic story is therefore:

Activity	Amount
Customer Sale	$1,000
Merchant Processing Fee	$30
Net Bank Deposit	$970

The equation is simple:

$1,000 sale − $30 fee = $970 deposit

The bookkeeping should preserve all three parts of that story.

---

1️⃣ Record the Sale

The first thing that happened was not the bank deposit.

The first thing that happened was the sale.

The customer purchased $1,000 of goods or services.

So the bookkeeping should recognize the appropriate amount of sales revenue based on the underlying transaction.

In our simplified example:

Sales Revenue = $1,000

This is important because the business did not generate only $970 of sales.

It generated $1,000 and then incurred a cost to process the customer's payment.

---

2️⃣ Record the Merchant-Processing Fee

The processor kept $30.

That $30 did not disappear.

It represents a cost associated with accepting the customer's payment.

For bookkeeping purposes, that amount might be recorded in an account such as:

Merchant Processing Fees

or

Credit Card Processing Fees

depending on the chart of accounts.

Now the financial records show:

Sales Revenue: $1,000

and

Merchant Processing Expense: $30

That provides much clearer information than simply recording $970 of revenue.

---

3️⃣ Record the Cash That Actually Reached the Bank

The bank received:

$970

That amount should ultimately be reflected in the bank account.

So we now have all three pieces:

💳 Sale: $1,000
💸 Processing fee: $30
🏦 Bank deposit: $970

The books tell the complete story rather than relying on the net amount visible in the bank feed.

---

🧾 What Might the Accounting Entry Look Like?

The exact mechanics can vary depending on your accounting software, accounting method, point-of-sale integration, and how the merchant processor settles transactions.

One common approach uses a merchant or payment-clearing account.

For our simplified example, when the $1,000 sale occurs, the books might reflect:

Debit: Merchant Clearing — $1,000
Credit: Sales Revenue — $1,000

Then, when the merchant processor pays the business:

Debit: Bank — $970
Debit: Merchant Processing Fees — $30
Credit: Merchant Clearing — $1,000

The clearing account returns to zero after the related activity has been completely recorded.

The result is:

• $1,000 of sales
• $30 of processing expense
• $970 added to cash

That is exactly what happened economically.

The specific entry can differ based on the accounting system and facts, but the fundamental principle remains:

Do not automatically use the net merchant payout as the business's sales amount.

---

⚠️ Why Recording Only the Net Deposit Creates Problems

Suppose instead you record the $970 bank deposit directly as revenue.

Your income statement now reports:

Revenue: $970

But the business actually generated $1,000 of sales.

Your revenue is understated by $30.

At the same time, the $30 merchant-processing expense has disappeared from the report.

That creates several problems.

---

📉 Your Revenue Is Understated

If customers purchased $100,000 during the month but merchant fees reduced the deposits to $97,000, recording only bank deposits could make the books show $97,000 of sales.

The business actually generated $100,000.

That difference matters when evaluating:

• Sales trends
• Pricing
• Growth
• Average transaction values
• Product performance
• Gross margins
• Operating results

---

💸 Your Processing Costs Disappear

Merchant fees are a real business cost.

If those fees are simply netted against sales, the business owner cannot easily see how much is being spent to accept electronic payments.

Suppose one processor charges the business $700 per month and another alternative would cost $450.

That information is difficult to evaluate if processing costs are buried inside reduced revenue.

Separate recording gives the business owner better information.

---

🔍 One Deposit May Represent More Than One Day of Sales

Merchant-processing deposits can become even more confusing because the payout timing may not match the sales date.

Imagine customers make purchases Friday, Saturday, and Sunday.

The processor may combine those transactions and make one deposit on Monday.

The Monday bank deposit does not necessarily represent Monday's sales.

It may represent several days of earlier activity.

If bookkeeping is based solely on the bank feed, revenue can end up being recorded in the wrong period.

That can distort monthly comparisons and financial reporting.

---

🏦 The Bank Feed Tells You Cash Moved

A bank feed is extremely useful.

But the bank feed primarily tells you that money entered or left the bank account.

It does not necessarily tell you the full economic story behind that money.

A bank-feed transaction showing:

Merchant Processor — $8,742.13

does not automatically tell you:

• Gross customer sales
• Processing fees
• Refunds
• Chargebacks
• Sales tax collected
• Tips collected
• Timing differences
• Other settlement adjustments

For those details, the merchant-processing or point-of-sale records may need to be reviewed.

---

🧮 What About Sales Tax?

There is another reason not to automatically treat the full customer payment as revenue.

Suppose a customer's $1,000 payment includes an amount collected for sales tax.

The entire $1,000 may have passed through the payment processor, but that does not necessarily mean the entire amount represents sales revenue.

Amounts collected on behalf of a taxing authority may instead create a liability.

For bookkeeping purposes, those amounts should be separated appropriately based on the facts.

The same principle can apply to other amounts that may be included in a merchant transaction but do not belong in sales revenue.

The key point is:

The total customer charge, the business's revenue, and the eventual bank deposit can all be different numbers.

---

🍽️ What About Tips?

For businesses that collect customer tips, the merchant transaction may include amounts belonging to employees or other recipients.

Again, the amount charged to the customer's card may not equal business revenue.

That is another reason the bookkeeping should be tied back to the underlying merchant or point-of-sale activity instead of assuming the bank deposit represents sales.

---

🔄 What About Refunds and Chargebacks?

Merchant processors may also reduce a payout because of:

• Customer refunds
• Chargebacks
• Disputed transactions
• Reversals
• Processor adjustments

For example:

Gross sales might be $5,000.

Processing fees might be $150.

A customer refund might be $200.

The resulting deposit might be:

$4,650

If someone records $4,650 directly as sales revenue, three separate events have been collapsed into a single number.

The books lose important information.

A better system preserves the individual components.

---

📋 Why Merchant Statements Matter

When merchant deposits do not match daily sales totals, the merchant processor's settlement or activity report can help explain the difference.

Those reports may show:

• Gross sales
• Fees
• Refunds
• Chargebacks
• Adjustments
• Payout amounts
• Settlement dates

That information can be compared with the amounts appearing in the bank account.

This is especially useful when several transactions are combined into one deposit.

---

🔗 Reconcile the Merchant Activity to the Bank

The goal is not merely to get the bank account reconciled.

You should also be able to understand how the merchant-processing activity connects to the deposit.

Using our original example:

Merchant activity: $1,000 customer sale

Less processor fee: $30

Expected deposit: $970

Actual bank deposit: $970

Now the trail makes sense.

If the expected payout and actual deposit do not agree, investigate the difference rather than forcing the numbers together.

---

📈 Why This Matters for Financial Reporting

Accurate merchant bookkeeping improves several parts of the financial statements.

Revenue

The income statement reflects the appropriate sales activity instead of simply reporting net bank deposits.

Expenses

Merchant-processing fees remain visible as an operating cost.

Cash

The bank account reflects the actual amount deposited.

Profitability

Business owners can better evaluate revenue, operating costs, and margins.

Comparability

Month-to-month sales trends are less likely to be distorted by changes in payment-processing fees or settlement timing.

---

💡 A Practical Monthly Review

If your business accepts credit cards or online payments, ask:

Do the sales recorded in the books agree with the underlying sales system?

Are merchant-processing fees recorded separately?

Can merchant settlements be connected to actual bank deposits?

Are refunds and chargebacks accounted for?

Are timing differences between sales and deposits understood?

Are amounts such as sales tax or tips separated when applicable?

If those questions cannot be answered, the merchant-account workflow may need review.

---

⚠️ The Bigger Bookkeeping Lesson

Merchant deposits illustrate a broader bookkeeping principle:

Cash movement and accounting activity are not always the same thing.

A bank transaction tells you that cash moved.

Good bookkeeping asks why the cash moved and what underlying transaction created it.

That distinction matters with:

• Merchant deposits
• Loan payments
• Transfers
• Customer deposits
• Owner contributions
• Credit-card payments
• Refunds
• Other financial activity

The bank feed is a starting point.

It should not always be the final accounting conclusion.

---

🎯 What This Means for Your Business

Return to our simple example:

Customer pays: $1,000

Merchant fee: $30

Bank receives: $970

If you record only the $970 deposit as revenue, your books miss part of the story.

The better approach is to preserve the components:

📊 Record the appropriate sale amount
💸 Record the processing fee separately
🏦 Record the actual cash deposited
🔍 Reconcile the merchant activity to the bank

And when additional items such as refunds, chargebacks, sales tax, or tips are involved, make sure those amounts receive the appropriate treatment as well.

The goal is not simply to make the deposit disappear from the bank feed.

The goal is to produce books that reflect what actually happened.

Clarity Comes Before Decisions.

---

✅ Complimentary Financial Health Check

If merchant deposits, bank-feed transactions, processor fees, or other balances in your books are difficult to explain, it may be worth taking a closer look at the underlying bookkeeping.

TheAccountingDr offers a Complimentary Financial Health Check designed to help identify areas of your bookkeeping that may deserve additional attention.

TheAccountingDr also provides professional bookkeeping services including:

• Core monthly bookkeeping
• Cleanup and catch-up bookkeeping
• Account reconciliations
• Financial reporting
• Inventory and product-sales bookkeeping
• Xero migration and support

🌐 Visit TheAccountingDr.com to learn about bookkeeping support or request your Complimentary Financial Health Check.

---

👨‍🏫 About the Author

Dr. Brian Routh is an accounting professor and professional bookkeeper and the founder of TheAccountingDr, a Raleigh-based virtual bookkeeping practice serving North Carolina and clients nationwide.

He has taught accounting for more than 20 years, formerly served as an Assistant State Auditor for North Carolina, and is a Xero Certified Professional.

Through TheAccountingDr, he combines accounting education with professional bookkeeping to help business owners maintain accurate records, better understand their financial reports, and gain greater financial clarity.

TheAccountingDr.com
Clarity Comes Before Decisions.

📘 Balance Sheet: A Step-by-Step Example

A business owner can receive a perfectly formatted balance sheet and still have no idea what the numbers are actually saying.

That is a problem.

Financial reports are most useful when you can do more than simply look at them. You should be able to understand where the numbers came from, what the major balances represent, and what those numbers may be telling you about your business.

The balance sheet is one of the best places to start.

At first glance, it can look like a collection of accounts and numbers. But the basic structure is remarkably logical.

A balance sheet answers three fundamental questions:

📦 What does the business own?
📄 What does the business owe?
📊 What remains as equity?

Let’s walk through a simple example step by step.

---

📊 What Is a Balance Sheet?

A balance sheet reports the financial position of a business at a particular point in time.

That distinction matters.

An income statement generally reports activity over a period of time—for example, revenue and expenses for the month of July.

A balance sheet is more like a financial snapshot.

It shows balances as of a particular date.

Its basic accounting equation is:

Assets = Liabilities + Equity

Everything on the balance sheet ultimately fits into one of those three broad categories.

For a simple business-owner explanation:

Assets = what the business owns or controls.

Liabilities = what the business owes.

Equity = the residual interest after liabilities are subtracted from assets.

Let's put actual numbers behind those terms.

---

🟦 Step 1: Identify What the Business Owns

Assume our example business has the following assets:

Asset	Amount
Cash in Bank	$15,000
Inventory	$10,000
Equipment	$25,000
Total Assets	$50,000

The business therefore reports $50,000 of assets.

Each asset represents something different.

💰 Cash — $15,000

This is money held in the business's bank account.

Cash is usually one of the easiest assets for a business owner to recognize.

But even cash should be supported by accurate bookkeeping and account reconciliation.

The number appearing in accounting software should not simply be assumed to be correct because a bank feed is connected.

📦 Inventory — $10,000

Inventory represents products held for sale, assuming inventory accounting applies to the business.

This is an important distinction because inventory sitting on a shelf is not automatically an expense simply because the business paid for it.

The accounting treatment depends on the facts and the accounting method being used.

🖥️ Equipment — $25,000

Equipment is another type of asset.

A business may have computers, machinery, furniture, tools, vehicles, or other property being used in operations.

For this simplified example, we will assume the balance-sheet amount for equipment is $25,000.

So:

$15,000 + $10,000 + $25,000 = $50,000 of total assets.

That answers our first question:

What does the business have?

In this example, the answer is $50,000 in assets.

---

🟨 Step 2: Identify What the Business Owes

Now let's look at the other side.

Assume the business has these liabilities:

Liability	Amount
Accounts Payable	$8,000
Loan Payable	$12,000
Total Liabilities	$20,000

The business therefore owes $20,000.

🧾 Accounts Payable — $8,000

Accounts payable generally represents valid bills or obligations the business has recorded but has not yet paid.

For example, perhaps vendors have supplied products or services and given the business time to pay.

That amount is not merely an expense waiting to happen.

If it has been recorded appropriately under accrual accounting, the obligation already exists in the books.

When the business later pays the bill, the payment normally reduces both cash and accounts payable. It should not create a second expense.

🏦 Loan Payable — $12,000

Our business also has $12,000 of outstanding loan principal.

This is another liability because the business has an obligation to repay that amount.

The outstanding principal belongs on the balance sheet.

Interest is different.

Interest generally represents the cost of borrowing and is typically reported as an expense rather than as part of the loan liability itself.

That distinction is one reason blindly categorizing an entire loan payment from the bank feed can create problems.

Now we know:

Total liabilities = $20,000.

---

🟩 Step 3: Determine Equity

We now have two pieces of the equation:

Assets = $50,000

and

Liabilities = $20,000

The accounting equation tells us:

Assets = Liabilities + Equity

So:

$50,000 = $20,000 + Equity

That means:

Equity = $30,000

Our simplified balance sheet therefore looks like this:

Balance Sheet	Amount
Assets	$50,000
Liabilities	$20,000
Equity	$30,000

And the accounting equation works:

$50,000 = $20,000 + $30,000

That is why it is called a balance sheet.

---

💡 What Does $30,000 of Equity Actually Mean?

This is where business owners sometimes misunderstand the report.

The $30,000 of equity does not mean there is another $30,000 sitting in the bank.

Remember, the business only has $15,000 of cash in our example.

Equity is the residual interest represented within the accounting equation.

In simplified terms:

Assets − Liabilities = Equity

So:

$50,000 − $20,000 = $30,000

That equity is reflected across the business's assets—not necessarily in cash.

This is an important reason that:

Equity is not the same thing as cash.

And it is also why looking at only the bank balance does not give a business owner a complete picture of financial position.

---

🔍 Step 4: Ask Whether the Numbers Make Sense

Getting the balance sheet to mathematically balance is only the beginning.

Accounting software is designed around the accounting equation. A balance sheet can technically balance while still containing incorrect bookkeeping.

For example, imagine that:

• A loan payment was recorded entirely as an expense.
• A customer payment was never applied to the customer's invoice.
• An old vendor bill remains in accounts payable even though it was already paid.
• A bank transaction was duplicated.
• Inventory purchases were classified inconsistently.
• A transfer between two bank accounts was accidentally recorded as income.
• An asset purchase was recorded as an ordinary operating expense.

The report may still balance.

But the balances may not accurately represent what happened.

That is why I encourage business owners to go beyond:

“Does the balance sheet balance?”

and also ask:

“Can I explain the important balances?”

---

🏦 Step 5: Reconcile the Accounts Behind the Balance Sheet

The balance sheet contains several accounts that can often be compared with external information.

Bank accounts can be reconciled with bank statements.

Credit-card liabilities can be reconciled with credit-card statements.

Loan balances can be compared with lender information.

Accounts receivable can be reviewed against outstanding customer invoices.

Accounts payable can be reviewed against valid unpaid vendor obligations.

Reconciliation provides an important checkpoint.

Suppose your bookkeeping reports:

Bank account: $18,425

but the underlying bank information does not support that amount.

That difference deserves investigation.

The goal is not simply to make the reconciliation screen turn green.

The goal is to understand why the accounting records agree with the underlying information.

---

📄 Step 6: Understand the Story Behind the Accounts

A good balance sheet should lead to questions.

For example:

Is cash increasing or decreasing?

A business can be profitable and still experience cash-flow pressure.

Is accounts receivable growing?

If receivables are increasing, customers may be taking longer to pay—or there may be old or inaccurate balances that need review.

Is accounts payable increasing?

The business may be intentionally using vendor terms, or it may be struggling to keep up with obligations.

Is debt increasing or decreasing?

Understanding the outstanding principal can help a business owner see how borrowing is affecting financial position.

Is inventory growing faster than sales?

That can tie up cash in products that have not yet been sold.

Is equity changing?

Profit, losses, owner contributions, distributions, and other transactions can affect equity depending on the business structure and accounting setup.

The balance sheet becomes much more useful when the business owner begins asking questions like these.

---

⚠️ A Balanced Balance Sheet Can Still Contain Bad Bookkeeping

This point deserves emphasis.

The accounting software will normally maintain the mathematical relationship:

Assets = Liabilities + Equity

That does not guarantee that every individual account is correct.

Imagine this transaction:

The business purchases a $10,000 piece of equipment.

If someone mistakenly records it as a miscellaneous operating expense instead of an asset, the accounting system can still produce reports.

The books may still technically balance.

But the financial information may tell a very different story.

That is why good bookkeeping involves more than getting transactions into the software.

It involves understanding:

📄 what happened
🔍 how it should be recorded
🏦 whether the accounts reconcile
📊 whether the resulting reports make sense

---

🔄 How the Balance Sheet Connects to the Income Statement

The income statement and balance sheet should not be viewed as unrelated reports.

They tell different parts of the same financial story.

The income statement generally reports:

• Revenue
• Expenses
• Profit or loss

The balance sheet reports:

• Assets
• Liabilities
• Equity

Business activity occurring on the income statement can ultimately affect equity on the balance sheet.

For example, profit generally increases equity, while losses generally decrease it, although owner transactions and the business's legal/account structure can also affect equity balances.

This is one reason I encourage business owners not to review the income statement alone.

The income statement may tell you whether the business earned a profit.

The balance sheet helps you understand what the business has accumulated, what it owes, and how that financial position is structured.

---

📋 Questions to Ask When Reviewing Your Balance Sheet

When reviewing your own balance sheet, consider asking:

✅ Do my cash balances agree with reconciled bank accounts?

If not, determine why.

✅ Do my credit-card balances agree with the underlying statements?

Old differences should not simply remain indefinitely.

✅ Is accounts receivable made up of valid amounts customers still owe?

Look for old invoices, unapplied payments, credits, duplicates, or disputed balances.

✅ Is accounts payable made up of legitimate unpaid obligations?

Make sure paid or duplicate bills are not inflating the balance.

✅ Do loan balances agree reasonably with lender information?

Remember that principal and interest are different.

✅ Are inventory and fixed-asset balances reasonable?

These accounts may require more than simply accepting what a bank feed suggests.

✅ Can I explain significant changes from last month?

An unusual movement does not automatically mean something is wrong—but it deserves understanding.

---

🎯 What This Means for Your Business

A balance sheet should not be a report you receive once a month and immediately file away.

It should help you answer some very practical questions:

What does my business own?

What does my business owe?

What is the business's equity position?

Which balances have changed significantly?

Are the important accounts reconciled and supported?

When those questions are difficult to answer, the problem may not be the balance sheet itself.

The underlying bookkeeping may need attention.

---

🧭 The Main Takeaway

Return to our simple example:

Assets: $50,000
Liabilities: $20,000
Equity: $30,000

The equation is:

$50,000 = $20,000 + $30,000

But the real lesson is larger than the arithmetic.

Your balance sheet should help you understand:

📦 what the business owns
📄 what the business owes
📊 what remains as equity

And the more clearly you can explain the balances behind those numbers, the more useful the report becomes.

Clarity Comes Before Decisions.

---

✅ Complimentary Financial Health Check

If you are looking at your balance sheet and thinking, “I’m not really sure whether these numbers are right—or what they mean,” that is worth addressing.

TheAccountingDr offers a Complimentary Financial Health Check designed to help identify areas of your bookkeeping that may deserve additional attention.

If you need ongoing support, TheAccountingDr also provides professional bookkeeping services including monthly bookkeeping, cleanup and catch-up work, account reconciliations, financial reporting, inventory and product-sales bookkeeping, and Xero migration and support.

🌐 Visit TheAccountingDr.com to learn more about bookkeeping support or request a Complimentary Financial Health Check.

---

👨‍🏫 About the Author

Dr. Brian Routh is an accounting professor and professional bookkeeper and the founder of TheAccountingDr, a Raleigh-based virtual bookkeeping practice serving North Carolina and clients nationwide.

He has taught accounting for more than 20 years, formerly served as an Assistant State Auditor for North Carolina, and is a Xero Certified Professional.

Through TheAccountingDr, he combines accounting education with professional bookkeeping to help business owners maintain accurate records, better understand their financial reports, and gain greater financial clarity.

TheAccountingDr.com
Clarity Comes Before Decisions.

📊 Reading an Accounts Receivable Aging Report: What Overdue Balances Reveal

A business can report a substantial accounts receivable balance and still have a receivables problem.

The reason is simple: the total tells you how much customers owe, but it does not tell you how old those balances are.

A $90,000 accounts receivable balance could consist almost entirely of invoices that are current and not yet due. Or that same $90,000 could include thousands of dollars that have remained unpaid for 60, 90, or more than 90 days.

Those are very different financial situations.

An Accounts Receivable Aging Report helps business owners move beyond the total balance and understand the age and composition of the amounts customers owe. It can reveal collection patterns, customer concentration, credit-risk indicators, disputed invoices, and balances that may require additional collectibility review.

🎥 Watch the Complete Lesson

https://youtu.be/iq08vVC68do

📘 What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a detailed listing of unpaid customer balances as of a specific date.

The report generally identifies the customer, the unpaid invoice or balance, and how long that balance has remained outstanding. Common categories include Current, 1–30 days past due, 31–60 days past due, 61–90 days past due, and more than 90 days past due.

The exact labels may vary depending on the accounting system and report settings.

It is also important to understand how the aging is being calculated. Depending on the system and configuration, the report may age balances from the invoice date, the due date, or another defined setting.

That distinction matters. If the report settings do not reflect the company's actual payment terms, the aging categories may create a misleading impression of which invoices are truly overdue.

An aging report is also a snapshot at a specific date. A July 31 report tells you what the receivables looked like on July 31. Payments, credits, adjustments, or corrections entered afterward may change what appears on a later report.

💰 Why the Total Balance Is Not Enough

Consider the fictional business used in the lesson, Harbor Office Solutions.

As of July 31, the company reports $90,000 in accounts receivable: $48,000 current; $18,000 1–30 days past due; $9,000 31–60 days past due; $5,000 61–90 days past due; and $10,000 more than 90 days past due.

At first glance, an owner may focus on the $90,000 total.

But the aging report tells us much more.

📌 $42,000 is already past due. Of that amount, $24,000 is more than 30 days past due, $15,000 is more than 60 days past due, and $10,000 has remained unpaid for more than 90 days.

That does not automatically mean those older balances will not be collected.

It means they deserve additional attention.

As a balance becomes older, the need to understand why it remains unpaid generally becomes more important.

🔎 Read the Total and the Composition Together

The total accounts receivable balance answers one question:

How much do customers owe?

The aging report answers another:

How is that balance distributed according to age?

Those two pieces of information should be considered together.

If nearly all of a $90,000 receivable balance were current, the report would tell a very different story from one in which a substantial portion had been outstanding for more than 60 or 90 days.

💡 The goal is to move from a number to an explanation.

Which customers make up the oldest balances? Are any invoices disputed? Are payments being applied correctly? Are certain customers regularly paying late? Are the same balances appearing month after month?

A useful aging report should lead to those kinds of questions.

📈 Look for Collection Patterns Over Time

One aging report provides a snapshot.

Several aging reports can reveal a trend.

Suppose balances more than 60 days past due were $6,000 in May, $10,000 in June, and $15,000 in July.

The total accounts receivable balance may not have changed dramatically, but something important is happening underneath the total:

More receivables are moving into older categories.

That should lead the owner to ask why.

Perhaps sales increased. Perhaps customers are taking longer to pay. Perhaps invoices are being issued later than expected. There may be unresolved disputes, or payments may not be getting applied correctly.

📊 A stable total can hide a deteriorating collection pattern.

Comparing aging reports over time helps reveal that movement.

👥 Customer Concentration Matters

The age of the balance is important, but so is who owes the money.

In the Harbor Office Solutions example, one customer owes $22,000 of the company's $90,000 total receivable balance.

That represents nearly one-fourth of all outstanding receivables.

Customer concentration is not automatically a problem. Some businesses naturally have several large customer relationships.

But the owner should understand that exposure.

A $22,000 balance owed by one customer creates a different situation from $22,000 spread among many customers.

⚠️ If that one customer delays payment, disputes an invoice, or experiences difficulty paying, the impact on the business may be much greater.

🧾 An Old Invoice May Have a Story Behind It

An aging report can show that an invoice is old.

It usually cannot explain why.

Suppose a $6,000 invoice appears in the more-than-90-days category. The first reaction might be to assume the customer simply has not paid.

Further review, however, might reveal that the invoice is under dispute.

The customer may disagree with the amount billed, the goods delivered, the work performed, or another aspect of the transaction.

That context matters.

A disputed invoice may require a different type of review than an invoice that is old because of a payment problem. An old balance could also involve a billing error, an unapplied payment, an unresolved credit, or another bookkeeping issue.

📌 The aging report identifies the balance that deserves attention. The supporting information helps explain why it remains outstanding.

⚠️ Recognizing Credit-Risk Indicators

An aging report can also help identify potential credit-risk indicators.

Balances moving into older categories, repeated late payment, significant customer concentration, disputed invoices, broken payment arrangements, or little recent payment activity may all deserve attention.

None of those factors automatically proves that a balance is uncollectible.

They indicate where additional review may be appropriate.

A large balance, an old balance, and a balance with little recent payment activity each tell us something different.

💡 A thoughtful review considers size, age, and recent payment activity together rather than relying on any one factor in isolation.

🧠 Aging Does Not Explain Everything

This is one of the most important limitations of an aging report.

An old balance may still be collectible.

A current balance may contain an error.

A past-due invoice may be disputed.

A payment may have been received shortly after the reporting date.

A customer may even have paid, but the payment may not have been applied correctly in the accounting records.

The report must therefore be interpreted in context.

📄 Payment history, subsequent collections, customer communications, invoice documentation, dispute information, credit terms, and established accounting policies may all provide information that the aging category itself cannot provide.

The aging report points us toward the questions. The evidence helps answer them.

📉 How Aging Relates to the Allowance for Doubtful Accounts

The allowance for doubtful accounts is a financial-reporting concept used to estimate the portion of receivables that may not ultimately be collected.

An aging report may provide useful information for that analysis because older balances generally deserve closer collectibility review.

However, age should not automatically be treated as the only consideration.

Historical collection experience, customer-specific circumstances, disputes, subsequent collections, historical loss experience, current conditions, and the organization's established accounting methodology may also matter.

🚫 The lesson does not prescribe a universal percentage or allowance methodology.

The purpose is not to assume that an old balance must automatically be written off.

The purpose is to determine whether the recorded receivable remains supportable based on the information available.

🧮 An Illustrative Allowance Analysis

In the lesson, I demonstrate how aging categories can provide structure for an allowance analysis.

A company might evaluate current balances differently from balances more than 90 days past due based on its own history and supporting evidence.

But the analysis should not stop with a spreadsheet.

For example, suppose one customer pays $4,000 shortly after July 31, while another $6,000 invoice is under dispute.

Those facts provide information that the aging category alone cannot provide.

📌 The aging schedule organizes the analysis. Judgment and supporting evidence are still necessary.

📅 Subsequent Collections Can Provide Important Evidence

Suppose a customer balance appears past due on July 31 but the customer pays the amount on August 3.

The July 31 aging report was still correct in showing the balance as outstanding on July 31.

But the subsequent payment provides additional information about collectibility.

Other useful evidence may include customer communications, payment arrangements, invoice support, dispute resolution, and historical payment patterns.

Several customers may routinely pay 35 to 45 days after invoicing even though the company's stated payment terms are 30 days.

That may indicate a slower collection pattern, but it does not automatically establish that those balances are uncollectible.

🔎 Subsequent collections provide context, not an automatic conclusion.

💬 Questions Business Owners Should Ask Each Month

A business owner does not need to become an accountant to make better use of an aging report.

The key is to begin asking better questions: What is the total accounts receivable balance? How much is current? How much is more than 60 or 90 days past due? Which customers have the largest balances? Are any invoices disputed? Are overdue balances increasing or decreasing? Have payments been received since the report date? Are payments, credits, and adjustments being applied correctly?

📘 Those questions transform the aging report from a static accounting report into useful financial information.

The purpose is not simply to read the report.

The purpose is to understand what the report means.

🔁 A Practical Monthly Review Process

A consistent monthly review makes the accounts receivable aging report much more useful.

Start by confirming the report date and understanding the aging settings. Then review the total accounts receivable balance and compare it with prior months.

Next, examine how the balance is distributed among the aging categories and pay particular attention to significant balances more than 60 and 90 days past due.

Review the largest customer balances and significant disputed invoices. Consider payments received after the report date and document balances that require clarification or additional review.

Finally, compare the aging report with the balance sheet and determine whether the accounts receivable balance appears consistent with the accounting records.

📅 Aging reports are most useful when reviewed consistently—not only after a payment problem becomes obvious.

🧭 Final Takeaway

An accounts receivable aging report does much more than list unpaid invoices.

It helps business owners understand whether receivables are current, aging, concentrated, disputed, showing changing collection patterns, or requiring additional collectibility review.

The total accounts receivable balance matters.

But the age and composition of that balance matter too.

A useful aging report helps move an owner from simply seeing a number to understanding the financial story behind that number.

Clarity should come before decisions.

🩺 Request a Complimentary Financial Health Check

If your accounts receivable reports do not make sense, or you are unsure whether your bookkeeping records are current, reconciled, organized, and producing meaningful financial information, you can request a complimentary Financial Health Check from TheAccountingDr.

The review is designed to identify apparent bookkeeping concerns, clarify priorities, and help you understand where your records may need attention.

🔗 Learn more at TheAccountingDr.com

👤 About the Author

Dr. Brian Routh is the founder of TheAccountingDr, a former North Carolina Assistant State Auditor, a Xero Certified Professional, and an accounting professor with more than 20 years of teaching experience.

His educational content focuses on helping business owners and accounting learners better understand the financial information behind informed business decisions.

📘 How a Former State Auditor Approaches Bookkeeping

Bookkeeping and auditing are not the same thing.

A bookkeeper maintains and organizes financial records. An auditor performs a separate type of professional examination designed for a different purpose.

But experience in auditing can shape the way someone thinks about bookkeeping.

As a former Assistant State Auditor for North Carolina, one lesson has stayed with me throughout my accounting career:

Do not ask only, “Does the number look right?” Ask, “Can we support it?”

That mindset influences how I approach bookkeeping today.

Good bookkeeping should not simply produce numbers on an income statement or balance sheet. The transactions behind those numbers should be understandable, accounts should be reconciled, unusual activity should be investigated, and important balances should have reasonable supporting documentation.

For a business owner, that creates something extremely valuable:

greater financial clarity.

---

🔍 Bookkeeping Is Not an Audit

This distinction is important.

TheAccountingDr provides professional bookkeeping services. I do not provide audits, reviews, compilations, or other assurance services.

Applying habits learned through auditing does not transform bookkeeping into an audit.

Instead, it means bringing certain disciplines into everyday financial recordkeeping, including:

📄 Documentation
🏦 Reconciliation
🔎 Investigation
🔄 Consistency
🧾 Traceability

Those principles can help produce bookkeeping records that are easier to understand, review, and use.

---

📄 1. Ask: What Supports This Transaction?

Imagine seeing a $4,850 payment in the bank account.

The bank feed may tell us:

• The date
• The amount
• The payee
• That cash left the account

But that does not necessarily tell us what the transaction represents.

Was it:

• Inventory?
• Equipment?
• Repairs?
• Professional services?
• A loan payment?
• An owner transaction?
• Several different purchases combined?

The bank transaction tells us that money moved.

The supporting documentation helps explain why.

Depending on the transaction, support might include:

• Vendor invoices
• Receipts
• Customer invoices
• Contracts
• Loan statements
• Merchant-processing reports
• Purchase documentation
• Other business records

That leads to one of the most important bookkeeping habits:

Do not classify a transaction merely because you recognize the vendor name. Understand what actually occurred.

A familiar vendor can sell many different things.

---

🏦 2. Reconcile the Accounts

One of the strongest controls in bookkeeping is also one of the most fundamental:

reconciliation.

A reconciliation compares the accounting records with independent information, such as a bank or credit-card statement.

The objective is to determine whether the records agree and to identify differences requiring investigation.

For example, reconciliation might uncover:

• Missing transactions
• Duplicate entries
• Incorrect amounts
• Bank charges not yet recorded
• Payments posted to the wrong account
• Transfers treated incorrectly
• Outstanding items
• Transactions recorded more than once

A bank feed by itself is not the same as a reconciliation.

The bank feed helps bring information into the accounting system.

The reconciliation helps determine whether the records actually agree with the underlying account.

Imported does not automatically mean reconciled.

---

🔎 3. Investigate the Unusual

Another habit I carried from auditing is paying attention when something does not make sense.

Suppose a business normally spends approximately $800 per month on a particular expense, but this month the report shows $7,500.

That does not automatically mean something is wrong.

There may be a perfectly reasonable explanation.

But it deserves a question:

What changed?

Perhaps:

• An annual payment occurred
• Equipment was incorrectly recorded as an expense
• Several months were paid at once
• A duplicate transaction was entered
• A personal transaction was included
• The account classification changed
• The business genuinely incurred an unusual cost

The purpose is not to assume that every unusual number represents an error.

The purpose is to avoid ignoring something simply because the accounting software accepted the transaction.

---

🔄 4. Look for Consistency

Consistency is another important feature of dependable bookkeeping.

Similar transactions should generally be handled using a consistent approach unless the facts require something different.

Suppose monthly software subscriptions are categorized one way in January, another way in February, and somewhere completely different in March.

Even if the individual entries are not technically disastrous, inconsistent classification can make financial reports harder to compare.

A business owner trying to understand trends may see movement that reflects bookkeeping inconsistency rather than an actual change in business activity.

Consistency helps create reports that are easier to:

• Compare
• Interpret
• Review
• Explain
• Use for decisions

This does not mean every transaction must be forced into the same treatment.

It means there should be a reasonable and repeatable process.

---

🧾 5. Maintain a Clear Trail

One of my favorite questions is:

Can I trace this number backward?

Suppose the income statement shows $36,400 of advertising expense.

Can we move backward from that financial-statement number to:

1. The general-ledger activity
2. The individual transactions
3. The bank or credit-card activity
4. The invoices or receipts supporting those transactions?

That is the idea of a clear trail.

A financial statement should not feel like a collection of mysterious numbers that appeared because the software generated a report.

The numbers should come from understandable bookkeeping activity.

This becomes especially important when the business owner asks:

“Why did this expense increase?”

or:

“What makes up this balance?”

Good records make those questions easier to answer.

---

📊 6. Financial Reports Should Be Supported by the Books

An attractive income statement is not enough.

A polished balance sheet is not enough.

Accounting software can produce professional-looking reports even when the underlying bookkeeping contains problems.

For example:

• A bank account may not be reconciled.
• Accounts receivable may contain invoices already paid.
• Accounts payable may include duplicate bills.
• A loan payment may be entirely classified as an expense.
• Inventory purchases may be recorded inconsistently.
• A transfer may accidentally appear as revenue.
• Old transactions may remain uncategorized.

The report is only as useful as the information behind it.

Good reporting begins with good bookkeeping.

---

💰 A Simple Business Example

Suppose a business owner reviews the monthly income statement and sees:

Repairs & Maintenance: $9,800

Last month, the same category was only $1,200.

A quick approach might be:

“Well, the software says $9,800, so that must be the expense.”

A more disciplined approach asks:

🔎 Step 1: What makes up the $9,800?

Review the transactions assigned to the account.

📄 Step 2: What supports those transactions?

Examine invoices, receipts, and descriptions.

🧭 Step 3: Do they actually belong there?

Perhaps one $6,500 transaction was the purchase of equipment rather than a repair.

🏦 Step 4: Did the transactions clear the appropriate accounts?

Confirm through reconciliation.

📊 Step 5: Does the revised financial report now make sense?

Once the transactions are properly recorded, the owner has clearer information.

The important point is not that every unusual number is wrong.

It is that significant or unexpected information deserves understanding.

---

⚠️ What This Approach Does NOT Mean

An auditor-influenced bookkeeping mindset should not be misunderstood.

It does not mean:

❌ Every bookkeeping engagement is an audit
❌ Every transaction is independently verified
❌ The financial statements receive assurance
❌ Fraud detection is guaranteed
❌ Bookkeeping replaces an external CPA or auditor
❌ Every client needs an audit-level process

TheAccountingDr does not provide audit or assurance services.

Instead, the objective is disciplined bookkeeping that emphasizes:

✅ Current records
✅ Reconciled accounts
✅ Appropriate documentation
✅ Reasonable consistency
✅ Investigation of unusual items
✅ Meaningful financial reporting

That is a bookkeeping objective—not an audit opinion.

---

💻 How Xero Supports This Approach

Cloud accounting software such as Xero can provide tools that support disciplined bookkeeping.

Depending on the client's setup, those tools may help organize:

• Bank transactions
• Account reconciliations
• Customer invoices
• Vendor bills
• Supporting documents
• Financial reports
• Account activity
• Transaction histories

Technology can improve efficiency tremendously.

But technology does not replace professional judgment.

A software system may suggest a category based on what happened previously.

That does not automatically mean the suggestion is correct this time.

The question remains:

What actually happened, and how should it be reflected in the books?

---

🧩 Why Documentation Matters Even When the Amount Is Correct

Suppose a business has a $2,700 payment recorded to the correct account.

The amount is correct.

The vendor is correct.

The date is correct.

Does that automatically make the bookkeeping complete?

Not necessarily.

If someone later asks:

“What was this purchase?”

there should ideally be enough information to understand the transaction.

Documentation helps preserve the story behind the number.

That can be useful for:

• Business owners
• Bookkeepers
• Tax professionals
• Financial advisors
• Other authorized professionals who rely on the records

Well-supported bookkeeping makes collaboration easier.

---

🔄 Why Reconciliation Is More Than Checking a Box

Reconciliation is sometimes viewed as a routine month-end task.

But it provides an important checkpoint.

Suppose the bookkeeping system reports a bank balance of $24,500, while the underlying bank information indicates something different.

That difference requires explanation.

Perhaps:

• A transaction is missing
• A transaction was duplicated
• A transfer was recorded incorrectly
• An outstanding item exists
• The reconciliation was completed incorrectly
• A transaction was posted to another account

The goal is not merely to make the reconciliation screen say “complete.”

The goal is to understand why the accounting records agree—or why they do not.

---

📈 What This Means for Business Owners

Business owners typically do not need more numbers.

They need better information.

That means being able to look at financial reports and have greater confidence that:

• Bank and credit-card accounts have been reconciled
• Major balances have been reviewed
• Transactions are categorized reasonably
• Obvious unusual items have been investigated
• Financial reports are connected to the underlying books
• Documentation exists where appropriate

The goal is not perfection.

The goal is a financial recordkeeping process that is current, organized, and useful.

---

🪜 A Practical Monthly Bookkeeping Review

Here are several questions business owners can ask each month.

1️⃣ Have the major accounts been reconciled?

Bank and credit-card balances should be compared with their underlying statements or account information.

2️⃣ Are there unusual transactions?

Large, unexpected, duplicate, or unfamiliar transactions should be reviewed.

3️⃣ Are there unsupported transactions?

Determine whether additional documentation or explanation is needed.

4️⃣ Are account classifications consistent?

Look for transactions that may have been handled differently without a clear reason.

5️⃣ Do receivables and payables make sense?

Review old, duplicate, paid, disputed, or unusual balances.

6️⃣ Do loan balances agree with lender information?

Separate principal, interest, and other components appropriately.

7️⃣ Can important financial-statement numbers be explained?

A business owner should be able to understand the major components behind the reports.

These questions help turn bookkeeping from a data-entry exercise into a source of financial clarity.

---

✅ Practical Business-Owner Takeaway

My experience as a former North Carolina Assistant State Auditor influences the questions I bring to bookkeeping.

Not:

“Can we make the numbers work?”

But:

“What happened?”
“Can we support it?”
“Does it reconcile?”
“Is it consistent?”
“Can we trace it into the reports?”

Bookkeeping is not an audit.

But the disciplines of documentation, reconciliation, investigation, consistency, and traceability can help create clearer and better-supported financial records.

And clearer records help business owners better understand what their financial information is telling them.

Clarity Comes Before Decisions.

---

🧭 Professional Bookkeeping Support

If your bookkeeping contains unreconciled accounts, unclear transactions, inconsistent classifications, or financial reports you do not fully understand, it may be worth taking a closer look at the records behind the numbers.

TheAccountingDr provides:

✅ Core monthly bookkeeping
✅ Cleanup and catch-up bookkeeping
✅ Account reconciliations
✅ Monthly financial reporting
✅ Inventory and product-sales bookkeeping
✅ Xero migration and support
✅ Complimentary Financial Health Checks

Visit TheAccountingDr.com to learn about professional bookkeeping support.

---

👨‍🏫 About the Author

Dr. Brian Routh is an accounting professor and professional bookkeeper who helps business owners gain financial clarity through professional bookkeeping.

He is the founder of TheAccountingDr, a Raleigh, North Carolina-based virtual bookkeeping practice serving North Carolina and clients nationwide.

Dr. Routh has taught accounting for more than 20 years, formerly served as an Assistant State Auditor for North Carolina, and is a Xero Certified Professional.

His approach combines accounting education with disciplined bookkeeping practices designed to help business owners better understand the financial information behind their decisions.

Clarity Comes Before Decisions.