TheAccountingDr
Accounting education, bookkeeping clarity, and practical financial insight
Navigation
TheAccountingDr Blog

Practical Accounting Knowledge for Better Financial Decisions

Explore accounting education, bookkeeping guidance, financial reporting concepts, Xero insights, and practical information for business owners, students, professionals, ministries, and nonprofit organizations.

๐Ÿ“˜ 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:

AssetAmount
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:

LiabilityAmount
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 SheetAmount
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.

๐Ÿ“Š Accounts Receivable: What the Aging Report Reveals About Your Business

A business can have a large accounts-receivable balance and still have a collection problem.

Why?

Because knowing how much customers owe tells only part of the story. Business owners should also understand how long those amounts have been outstanding.

That is where the accounts-receivable aging report becomes useful.

An aging report organizes unpaid customer invoices according to age. Instead of seeing one total receivable balance, the business can see which amounts are current and which have remained unpaid for 30, 60, 90, or more days.

The total accounts-receivable balance tells you how much customers owe. The aging report tells you how old that balance is.

For a business owner, that additional information can provide important insight into expected cash collections, customer-payment patterns, and the accuracy of the bookkeeping records.


๐Ÿงพ What Is an Accounts-Receivable Aging Report?

An accounts-receivable aging report lists outstanding customer invoices and groups them according to how long they have remained unpaid.

A typical report might use categories such as:

  • Current
  • 1–30 days overdue
  • 31–60 days overdue
  • 61–90 days overdue
  • More than 90 days overdue

The exact categories can vary by accounting system and the business's payment terms.

For example, a business with $20,000 in total accounts receivable might initially appear to have $20,000 of expected future cash collections.

But consider these two situations.

Business A

  • Current: $17,000
  • 1–30 days overdue: $2,000
  • 31–60 days overdue: $1,000
  • 61+ days overdue: $0

Business B

  • Current: $3,000
  • 1–30 days overdue: $2,000
  • 31–60 days overdue: $3,000
  • 61–90 days overdue: $4,000
  • More than 90 days overdue: $8,000

Both businesses report $20,000 in accounts receivable.

But those balances tell very different stories.

Business A has most of its receivables in relatively recent invoices.

Business B has a significant amount concentrated in much older balances that deserve closer review.

That is why looking only at the total can be misleading.



๐ŸŸข What Does the “Current” Column Mean?

The Current category generally contains invoices that have not yet passed their payment due dates.

For example, suppose a business issues a $2,500 invoice with payment due in 30 days.

Before the due date, that receivable would generally appear as current.

A healthy current balance may simply mean the business regularly extends payment terms to customers.

However, even current receivables should be reviewed.

Ask:

  • Does each invoice represent a valid sale?
  • Was the invoice sent to the customer?
  • Is the due date correct?
  • Has the customer already paid through another system?
  • Is the customer balance supported by appropriate documentation?

A current invoice is not necessarily a problem—but it should still be accurate.


๐ŸŸก What Does 1–30 Days Overdue Reveal?

Once an invoice passes its due date, it typically moves into an overdue aging category.

A balance in the 1–30 day range might indicate:

  • A normal short payment delay
  • A customer who pays slightly beyond terms
  • An invoice that requires follow-up
  • A payment that has been received but not applied
  • A billing issue
  • A dispute that has not been resolved

One overdue invoice may not signal a major problem.

A growing pattern of overdue invoices, however, may deserve attention.

For example, suppose last month's aging report showed:

1–30 days overdue: $4,000

This month it shows:

1–30 days overdue: $11,000

The business owner should ask why that category increased.

The answer could involve customer-payment behavior, increased sales, billing timing, or a bookkeeping issue.

The important point is to investigate rather than simply accept the number.


๐ŸŸ  What About 31–60 and 61–90 Days?

As invoices continue aging, the business has waited longer to receive the related cash.

That matters because revenue may already have been recorded while the money needed to operate the business remains uncollected.

Older receivables may warrant questions such as:

  • Has the customer acknowledged the invoice?
  • Is the balance disputed?
  • Was the invoice sent to the correct person?
  • Has a payment been received but not applied?
  • Was a credit supposed to be issued?
  • Is the invoice duplicated?
  • Is the customer experiencing payment difficulties?
  • Does the balance still represent a valid amount owed?

The aging report does not answer those questions automatically.

It identifies where questions should be asked.


๐Ÿ”ด Why 90+ Day Balances Deserve Particular Attention

An invoice that remains unpaid for more than 90 days may require closer review.

That does not automatically mean the amount will never be collected.

But the longer a balance remains outstanding, the more important it becomes to understand why.

A 90+ day balance could represent:

  • A genuinely slow-paying customer
  • An unresolved dispute
  • An invoice that was entered incorrectly
  • A customer credit that was never applied
  • A duplicate invoice
  • A payment recorded to the wrong customer
  • A balance requiring further evaluation

The key is not to assume.

Old does not automatically mean uncollectible—but old should rarely mean ignored.


๐Ÿ’ต Accounts Receivable Is Not the Same as Cash

The aging report is especially important because accounts receivable represents expected collections—not money already sitting in the bank.

Suppose a business reports:

  • Accounts receivable: $50,000
  • Cash: $8,000

That $50,000 may eventually become cash, but the business cannot currently use it to pay:

  • Rent
  • Vendors
  • Loan payments
  • Insurance
  • Other operating obligations

If $30,000 of that receivable is already more than 90 days old, the business owner's cash position may deserve considerably more attention than the total receivable balance initially suggests.

Revenue can be earned before cash is collected.

This is one reason a profitable business can still experience cash-flow pressure.


๐Ÿ“ˆ What Changes in the Aging Report Can Reveal

Aging reports become even more useful when they are compared from month to month.

Suppose the business reviews the report at the end of each month.

Month 1

  • Current: $25,000
  • 1–30 days: $5,000
  • 31–60 days: $2,000
  • 61+ days: $1,000

Month 2

  • Current: $22,000
  • 1–30 days: $8,000
  • 31–60 days: $5,000
  • 61+ days: $3,000

The total receivable balance increased from $33,000 to $38,000.

But something else happened:

More of the balance moved into older aging categories.

That should prompt additional questions.

Has customer-payment timing changed?

Have invoices been entered incorrectly?

Are payments waiting to be applied?

Are certain customers responsible for most of the increase?

Looking at the trend provides more information than looking at one month's total.


๐Ÿ” The Aging Report Can Reveal Bookkeeping Problems Too

An aging report does not reveal only customer-payment issues.

Sometimes an old balance is actually a bookkeeping issue.

Payment received but not applied

A customer may have paid the invoice, but the payment was categorized directly from the bank feed rather than matched to the invoice.

The result?

  • Cash may be correct.
  • The invoice still appears outstanding.
  • Accounts receivable may be overstated.

Customer credit not applied

A valid credit may exist but remain separate from the invoice.

The report continues to show a balance the customer does not truly owe.

Duplicate invoice

The same sale may have been entered twice.

One invoice is paid while the duplicate continues aging.

Payment applied to the wrong customer

The total cash may be correct, but individual customer balances become inaccurate.

Old unresolved invoice

An invoice may have remained on the books for months without anyone determining whether the balance is still valid.

These are reasons the aging report should be part of the bookkeeping-review process—not merely a collection report.


๐Ÿงฎ A Simple Case Example

Suppose your business has total accounts receivable of $24,000.

The aging report shows:

Aging CategoryAmount
Current$11,000
1–30 Days$5,000
31–60 Days$3,000
61–90 Days$2,000
90+ Days$3,000
Total$24,000

At first, you might focus only on the $24,000 total.

But the aging report reveals that:

$8,000 is already more than 30 days overdue.

And:

$3,000 has been outstanding for more than 90 days.

Now you have better questions to ask.

  • Which customers make up the $3,000?
  • Are those invoices valid?
  • Have any payments been received?
  • Are there unresolved credits?
  • Are the balances disputed?
  • Has anyone reviewed the underlying documentation?

The aging report turns one number into actionable financial information.


⚠️ Common Mistake: Assuming an Aging Report Is Automatically Correct

Accounting software can produce an impressive-looking aging report.

That does not guarantee the underlying information is accurate.

The report depends on:

  • Correct customer invoices
  • Correct invoice dates
  • Correct due dates
  • Properly applied payments
  • Properly recorded credits
  • Accurate customer records
  • Resolved duplicate transactions

If the underlying bookkeeping is wrong, the aging report can also be wrong.

This is why reports should be reviewed, not simply generated.


๐Ÿ’ป Using Xero to Review Accounts Receivable

Cloud accounting software such as Xero can help organize:

  • Customer invoices
  • Outstanding balances
  • Due dates
  • Accounts-receivable aging
  • Customer payments
  • Credits
  • Supporting documents
  • Financial reports

Those tools can make the review process much more efficient.

However, software still depends on accurate bookkeeping.

A customer payment applied incorrectly can leave an invoice appearing overdue even though the customer has already paid.

An aging report is therefore most useful when the underlying accounts are current and properly maintained.


๐Ÿ“Š Aging Reports and Cash-Flow Planning

Accounts-receivable aging also provides useful context for cash-flow discussions.

Suppose a business expects to collect $25,000 of its outstanding receivables next month.

If most of those receivables are current and customers historically pay according to terms, that expectation may be more reasonable.

But if much of the $25,000 has already been outstanding for 90 or more days, the owner may want to be more cautious when planning around those expected collections.

This does not require assuming that old balances will never be paid.

It simply means:

The timing and age of receivables should be considered when evaluating expected cash collections.


๐Ÿ“… A Practical Monthly Aging-Report Review

Business owners can make the aging report part of their monthly financial review.

1️⃣ Review the total

How much do customers currently owe?

2️⃣ Review the distribution

How much is current versus overdue?

3️⃣ Look for movement

Are balances moving into older categories?

4️⃣ Identify large items

Is one customer responsible for a significant portion of the balance?

5️⃣ Investigate unusual balances

Look for:

  • Duplicate invoices
  • Unapplied payments
  • Old credits
  • Disputes
  • Incorrect customer assignments
  • Unexpected aging

6️⃣ Compare with previous months

Is receivable aging improving, remaining stable, or getting older?

7️⃣ Consider cash-flow implications

How much of the outstanding balance is reasonably expected to become cash in the near term?

This process turns the aging report into a management tool rather than simply another report produced by the accounting software.


๐Ÿ“‰ One Metric Does Not Tell the Entire Story

A business owner may be tempted to decide that:

“Our accounts receivable decreased, so everything must be improving.”

Not necessarily.

The decrease could result from:

  • Customer payments
  • Credits
  • Write-offs or adjustments
  • Lower sales
  • Corrections to prior errors

Likewise, an increase in accounts receivable does not automatically mean there is a problem.

It could result from higher sales.

The aging report provides context.

The question is not only:

Did accounts receivable increase or decrease?

It is also:

What changed inside the balance?


✅ Practical Business-Owner Takeaway

Your accounts-receivable balance tells you how much customers owe.

Your aging report tells you how long they have owed it.

Review both.

Pay particular attention to:

✅ Balances moving into older categories
✅ Unusually large overdue invoices
✅ Payments that may not have been applied
✅ Customer credits
✅ Duplicate invoices
✅ Unresolved disputes
✅ Month-to-month aging trends

$20,000 of current receivables tells a very different story from $20,000 concentrated in invoices more than 90 days old.

The more clearly you understand the composition of accounts receivable, the better you can understand expected collections and your overall financial position.


๐Ÿงญ Complimentary Financial Health Check

Are you looking at financial reports but still unsure whether the underlying bookkeeping is giving you a clear picture?

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

The review considers areas such as:

  • Reconciliation status
  • Account structure
  • Reporting clarity
  • Potential red flags
  • Xero suitability
  • Overall bookkeeping condition

The Financial Health Check is designed as a brief review and does not require handing over your accounting system or financial documents during the initial conversation.

Visit TheAccountingDr.com to request your complimentary Financial Health Check.


๐Ÿ‘จ‍๐Ÿซ 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.

TheAccountingDr provides core monthly bookkeeping, cleanup and catch-up bookkeeping, account reconciliations, monthly financial reporting, inventory and product-sales bookkeeping, Xero migration and support, and complimentary Financial Health Checks.

Clarity Comes Before Decisions.