Category: financial statements

Preparing for a Business Loan: A Guide to Spreading the Numbers

When you apply for a business loan, your lender has a responsibility to the financial institution she represents to evaluate the risk of your loan request and make an informed decision. To do this, the lender will request your business tax returns, financial statements, and a personal financial statement. Then, she’ll likely tell you she needs time to “spread the numbers.”

So, what does that mean?

Spreading the numbers involves organizing the financial data you’ve provided into a standardized format, allowing the lender to assess your business’s financial health and loan eligibility. During this process, your lender will be looking at several key factors:

  • Trends in your business’s sales and profits
  • The risk involved in approving the loan
  • The overall health of your business
  • How your business compares to others in your industry

Your lender will also evaluate your application using what’s known as the Five C’s of Credit:

1. Capacity
Capacity refers to your business’s ability to generate enough earnings to cover all obligations and make the required loan payment. Lenders use the cash flow statement to determine this. Many financial institutions look for operating profits to be at least twice the debt service required for the loan.

2. Capital
Capital represents the assets your business owns, as shown on your balance sheet. A higher level of capital indicates a more stable and secure business. It can also serve as additional collateral for the loan, offering reassurance to the lender.

3. Collateral
Collateral consists of assets the business owns that could be sold, if necessary, to generate cash and cover loan payments in the event of declining revenues. This might include equipment, real estate, inventory, or other tangible assets.

4. Conditions
Conditions refer to the current state of the economy and trends within your specific industry. Lenders consider how these external factors might impact your business’s ability to repay the loan.

5. Character
Character is a measure of your personal reputation, creditworthiness, and reliability. Lenders evaluate character by reviewing your credit score, background, and history of financial responsibility. Issues like past bankruptcies or criminal convictions can be red flags and may affect your loan approval.

How to Make It Easier for Your Lender

As a borrower, you can help streamline the loan evaluation process by preparing a complete, organized, and accurate loan proposal package. Here’s how:

  • Provide a full set of financial statements, including: (1) three years of business tax returns, (2) the most recent balance sheet and income statement, (3) a year-to-date profit and loss statement, (4) a cash flow forecast, and (5) your personal financial statement
  • Ensure your financial statements are prepared using standard accounting formats. Many businesses rely on accounting software to generate standardized, professional reports.
  • Include written explanations for any significant events that have affected your business’s financial health or your personal financial position over the past year or two.
  • Carefully review your entire document package to confirm accuracy and completeness before submitting it to the lender.
  • Proactively disclose any potential red flags, such as prior bankruptcies or other character-related issues, to the lender upfront. Transparency builds trust and allows you to provide context before questions arise.

Final Thoughts

Most business owners want their loan applications to be processed quickly and smoothly. You can help make that happen by preparing your documents in advance and providing your lender with everything she needs to “spread the numbers” and make an informed decision. Thoughtful preparation not only speeds up the process but also positions you as a responsible, credible borrower.

If you’d like more guidance on understanding your financial reports, making informed business decisions, and evaluating your profitability, be sure to check out my other blogs for small business owners. Many of them are designed to help you gain confidence in reading your financial statements, spotting potential issues, and setting your business up for long-term success. You’ll find practical, straightforward tips you can start using today!

Is Your Business Healthy? Let the Numbers Tell the Story

Over the past few weeks, we’ve discussed how to create and understand your financial statements. Now it’s time to turn our attention to reviewing and assessing those statements.

Regularly analyzing your financial data is essential to:

  • Determine if your business plans are working
  • Identify problems such as theft or fraud
  • Evaluate how your business compares to others in your industry
  • Spot trends that may positively or negatively affect your revenue

Are Your Plans Working?

Your cash flow worksheet was based on projected monthly sales over two years. You made critical business decisions—such as hiring staff, leasing space, and applying for financing—based on those projections.

If your actual revenue is falling short of projections, you may be burning through cash faster than expected. Identifying that early allows you to make adjustments, cut expenses, or secure additional funding.

On the flip side, if your revenue is exceeding expectations, you might be struggling to meet demand or maintain excellent customer service. In that case, you may need to hire more staff or set clearer expectations with customers regarding delivery times.

Identifying Problems

When I owned a restaurant, we were required to complete a weekly profit and loss statement and submit it to headquarters along with our royalty payment. Two numbers I always paid close attention to were payroll and cost of goods sold (COGS).

Our goal was to keep payroll under 22% of revenue and COGS under 35%. If either number was too high, it triggered an investigation. Here are some examples:

Payroll Red Flags

  • Overstaffing during slow periods: I reviewed scheduling during off-peak hours and made necessary adjustments.
  • Employees clocking in early or out late: I compared timecards to the schedule. One student used to come in early to do homework, but I didn’t realize he was on the clock!
  • Overtime pay: This often happened when a nearly full-time employee picked up extra shifts. We learned to ask part-time staff to cover instead.

Inventory Red Flags

  • Improper food preparation: Mistakes led to waste. We retrained employees or reminded them to follow special instructions more carefully.
  • Excess food on the buffet: Supervisors learned to reduce what was put out in the last 30 minutes of service.
  • Ordering errors: Overstocked perishables spoiled; running out meant buying from local stores at higher prices.
  • Theft: This included employees eating food without paying, giving away food, or failing to ring up sales and pocketing the cash.

Even if you’re not in the food service business, these examples illustrate how to track down the causes of higher-than-expected costs.

Comparing to Industry Standards

Analyzing your financial statements also helps you understand how your business stacks up against others in your industry. Industry benchmarks are available through association data, IBISWorld reports, and other sources.

For more on this, check out my blog: Comparing Your Financial Ratios to Industry Standards – Susan’s Reflections

Spotting Financial Trends That Spell Trouble

Declining sales volume is a major red flag. A brief dip might be seasonal or due to temporary competition. But if the trend continues, take a closer look:

  • Customer service issues: Even one rude or careless employee can cost you business. Many customers won’t complain—they’ll just leave.
  • Product quality issues: Poor-quality goods can lead to returns and dissatisfied customers.
  • Missed deadlines: Late deliveries frustrate clients. Evaluate every step in your supply chain to find and fix delays.

Rising accounts receivable can signal that your customers are struggling to pay. This slows your collections, reduces cash flow, and makes it harder to pay your own suppliers. If your receivables are growing:

  • Identify which customers are paying late and ask why.
  • Consider adjusting their credit limits or payment terms.
  • Project your cash flow for the next few months.
  • Talk to your banker about a line of credit, and ask suppliers for more favorable terms if needed.

Declining profit margins are another warning sign. Investigate the root cause. It could be:

  • Rising supply costs: Due to inflation, fuel prices, or shortages. Consider discontinuing low-margin items or sourcing more affordable alternatives.
  • Increased wages: If labor costs have risen, look for ways to improve productivity or automate processes.
  • Higher operating expenses: These might include utilities, insurance, or telecom services. Shop around for better rates, reduce waste (like leaking pipes or lights left on), and review whether you’re paying for services you don’t need.

Final Thoughts

Every business is different, but all must control costs and protect profit margins. Assessing your financial ratios regularly helps you identify problems early—before they impact your bottom line. Use the examples above as a guide to evaluate your own financials, make informed decisions, and position your business for long-term success.

If you’d like help reviewing your financial statements or identifying potential issues, don’t hesitate to reach out. I’m here to support you! You can email me at susan.ball5@aol.com.

Comparing Your Financial Ratios to Industry Standards

Business woman studying her business's financial ratios

Knowing your financial ratios is critical to managing your small business successfully. If you are applying for a business loan, the lender will want to see that your net operating income is more than sufficient to cover your loan payments. In fact, most lenders expect net operating income to be approximately three times the required loan payment. This standard holds true across the industry.

However, other ratios can vary greatly depending on the type of business you have. For example, inventory turnover should be much faster in a restaurant or grocery store compared to a retail clothing or appliance store. Grocery stores often have low profit margins per item but sell a large volume of products, while appliance stores sell fewer items but need a higher margin per sale to stay profitable.

Fortunately, there are several sources of standard industry data that can help you assess how your business compares to industry averages. These resources include:

  • IBISWorld: Offers comprehensive industry analysis, financial statistics, and industry trends. It’s a fee-based service, but you may be able to access it for free through a university or public library. Many Small Business Development Centers (SBDCs) use these reports in client consultations.
  • ReadyRatios: This financial software allows business owners to input their financial statements and automatically calculate key financial ratios. It also compares your business’s performance to industry benchmarks. ReadyRatios offers both free and fee-based versions depending on your needs.
  • Statista: A platform providing a wide range of data, including industry-standard ratios, market trends, and consumer behavior. It also has both free and premium options.

Other sources include:

  • Trade Associations
  • U.S. Census Bureau
  • Bureau of Labor Statistics
  • Market Research Firms

Key Ratios to Compare

There are several important financial ratios you can use to assess your business’s performance. Here are a few to consider:

Revenue Growth

If your industry is experiencing strong revenue growth but your business is lagging behind, it’s important to investigate why. Ask yourself:

  • Are new competitors eating into your market share?
  • Have you cut back on marketing and advertising?
  • Are you failing to provide an exceptional customer experience?

Profit Margin

Before starting your business, you should research the industry’s standard profit margin and compare it to your projected margins. If you’re projecting a profit margin much higher than industry standards, you’ll want to carefully review your assumptions about costs and operating expenses. If your business is already running and your profit margin is too low, consider:

  • Are your costs rising faster than you’re able to increase prices?
  • Are you failing to collect receivables in a timely manner?
  • Have revenues fallen below the point where they can cover fixed costs?
  • Has the quality of your product declined, leading to returns and waste?

Cost of Goods Sold (COGS)

The COGS ratio varies widely by industry, and yours should align with the industry’s average. If it’s not, investigate the following:

  • Are your prices too high, leading to reduced sales?
  • Is your markup too low, cutting into profits unnecessarily?
  • Are you offering deep discounts to move inventory, suggesting a misalignment with customer demand?
  • Are you over-ordering perishable items, resulting in waste?

Inventory Turnover Ratio

Your inventory turnover ratio indicates how quickly you’re selling and replacing inventory. If your ratio is higher than the industry average, it may indicate that you’re turning over inventory too quickly, which could lead to lost sales on high-demand items. On the other hand, a lower turnover ratio could mean that you’re ordering too much or the wrong items. Striking the right balance between inventory levels and demand is key to boosting sales and minimizing excess investment.

Interpreting Industry Benchmarks

These are just a few of the key financial ratios you can compare. It’s important to remember that deviating from the industry standard doesn’t necessarily indicate a problem, but it should prompt further investigation. You may find that your business is more efficient than average, or you may uncover areas for improvement that could help you optimize operations and boost profitability.

Conclusion: Understanding Your Ratios in Context

By comparing your financial ratios to industry standards, you can gain valuable insights into how your business is performing. Regularly reviewing these ratios will help you stay on track, identify potential issues early, and make informed decisions about the future of your business. Industry benchmarks serve as a useful tool, but remember that each business is unique, and your financial strategy should reflect your individual goals and circumstances.

If you need help analyzing your business’s financial ratios or understanding how they compare to industry standards, feel free to reach out. I’m here to help you navigate your financial strategy and grow your business confidently! You can email me @ susan.ball5@aol.com

Know Your Financial Ratios: The Key to Understanding Your Business’s Profitability

Understanding your financial statements is crucial to managing your small business effectively. However, it’s just as important to analyze these statements to assess how your business is performing. One powerful tool to do this is financial ratios. These ratios can help you measure your business’s financial health and compare it to others in your industry.

Here’s an overview of key financial ratios every business owner should understand and know how to calculate.

What Are Financial Ratios?

Financial ratios are calculations that help business owners evaluate their financial performance. They allow you to measure things like liquidity, profitability, and leverage—giving you a clearer picture of your business’s financial health.

Measures of Liquidity:

Liquidity refers to how easily assets can be converted into cash to cover short-term obligations. To maintain financial stability, it’s essential for a business to have sufficient liquidity.

Current Ratio: The current ratio measures a company’s ability to meet short-term liabilities using short-term assets.

Formula: Current Ratio = Current Assets / Current Liabilities

A ratio greater than 1 indicates that the company can pay its short-term obligations using its assets. A higher ratio means more liquidity.

Quick Ratio: The quick ratio is another liquidity measure, but it excludes inventory from current assets, recognizing that inventory may take longer to sell and convert into cash.

Formula: Quick Ratio = (Current Assets – Inventory) / Current Liabilities

Inventory Turnover Ratio: This ratio measures how often a company sells and replaces its inventory during a period. A higher turnover suggests that inventory is being sold quickly. Inventory turnover ratios vary greatly from one industry to another. Businesses whose inventory is perishable must turn over their inventory in a few days, whereas businesses whose products have long lives turn over their inventory just a few times a year.

Formula: Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

Measures of Profitability:

Gross Profit: Gross profit represents the revenue that remains after subtracting the cost of goods sold (COGS). It’s essential for understanding how much revenue is available to cover operating expenses.

Formula: Gross Profit = Revenues – Cost of Goods Sold

Gross Profit Margin: The gross profit margin shows the percentage of revenue available to cover operating expenses.

Formula: Gross Profit Margin = (Revenues – COGS) / Revenues

A higher gross profit margin indicates a more efficient business model.

Net Profit: Net profit is the remaining revenue after subtracting all expenses, taxes, and interest. It represents the business’s overall profitability.

Formula: Net Profit = Revenues – COGS – All Business Expenses

Net Profit Margin: The net profit margin calculates what percentage of revenue remains as profit after all expenses are paid.

Formula: Net Profit Margin = Net Profit / Revenues

Operating Profit (EBITDA): After taking out the cost of goods sold and paying all operating expenses you are left with the Operating Profit. It measures the funds available to meet obligations, such as loan payments and taxes. It’s also known as EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization).

Formula: Operating Profit = EBITDA = Gross Profit – Operating Expenses

Return on Assets (ROA): The return on assets ratio measures how efficiently a business is using its assets to generate profit.

Formula: Return on Assets = Net Profit / Total Assets

Return on Equity (ROE): The return on equity ratio shows how much profit a company generates with the money invested by its shareholders.

Formula: Return on Equity (ROE) = Net Profit / Shareholder’s Equity

Leverage Ratios:

Leverage ratios indicate the degree to which a company is financing its operations through debt, which is vital for evaluating financial risk.

Debt-to-Equity Ratio: The debt-to-equity ratio compares a company’s total debt to its total equity.

Formula: Debt-to-Equity Ratio = Total Debt / Total Equity

Interest Coverage Ratio: The interest coverage ratio measures a company’s ability to meet interest payments.

Formula: Interest Coverage Ratio = EBIT / Interest Expense

Debt Service Coverage Ratio: This ratio measures a business’s ability to cover its debt obligations (principal and interest payments).

Formula: Debt Service Coverage Ratio = Net Operating Income / (Principal + Interest Due)

A ratio of 2.5 to 3.0 or higher is often seen as a healthy benchmark by lenders.

How to Interpret Financial Ratios

Now that you understand the basic financial ratios, it’s essential to interpret what they mean. Some ratios, such as the debt service coverage ratio, are fairly standard across industries. Other ratios, such as inventory turnover or profit margins, can vary significantly between different industries.

In our next blog post, we’ll dive deeper into how to access industry data to benchmark your ratios and what variances in your ratios mean for your business’s performance.

Conclusion: Why Financial Ratios Matter

Understanding and calculating financial ratios is crucial for small business owners who want to assess their financial health. These ratios provide valuable insights into liquidity, profitability, and financial risk. By regularly tracking these ratios, you can make informed decisions about your business’s financial strategy and growth.

If you have any questions about how to calculate or interpret your business’s financial ratios, feel free to reach out in the comments below or email me at susan.ball5@aol.com. I’m here to help you manage your business finances with confidence!

Know Your Financial Statements—The Personal Financial Statement

The Personal Financial Statement (PFS) is an important document that every business owner should understand. Unlike other financial statements, the PFS reflects the financial health of the business owner rather than the business itself. Many business owners mistakenly believe their personal financial situation is separate from their business’s financial health. However, that is not the case.

A business owner’s personal finances play a crucial role in determining whether a lender will approve a small business loan. Lenders review the PFS to assess if the borrower:

  1. Is managing their personal finances well
  2. Has cash to inject into the business
  3. Has collateral to support the loan

Moreover, landlords and franchisors often require business owners to demonstrate financial responsibility before entering into lease or franchise agreements. Additionally, a PFS is necessary for certain SBA certifications and for securing SBA-backed loans.

Many business owners struggle with understanding how to complete the PFS. To help, I’ll guide you through the process, using the SBA’s Form 413 as the reference. While each bank may have its own version, most will accept the SBA version.

Guidelines for Completing the Personal Financial Statement

Assets:

  • Cash on Hand and in Banks: Total cash on hand and in your bank checking accounts.
  • Savings Accounts: Total of savings accounts, including CDs and money market accounts.
  • Retirement Accounts (IRAs, etc.): Total all retirement accounts. Though this money cannot be used as collateral, it’s still an important asset.
  • Accounts and Notes Receivable: Money owed to you, such as tax refunds, security deposits, or maturing CDs.
  • Life Insurance: Include only the cash surrender value of life insurance policies (the amount you’d receive if you cancel the policy, after administrative costs).
  • Stocks, Bonds, Real Estate, Automobiles, and Other Personal Property: List at current market values.
  • Other Property and Assets: Includes boats, trailers, collectibles, and jewelry.
  • Business Ownership: If you own a business, include its value, calculated by summing cash, equipment, and inventory. Enter this as “Other Assets.”

Liabilities:

  • Accounts Payable and Notes Payable: Includes unpaid bills, outstanding credit card balances, and bank loans (excluding mortgages, student loans, and auto loans).
  • Auto and Installment Loans: Include the total debt and the monthly payment for auto loans, student loans, or other installment loans.
  • Life Insurance Loans: If applicable, list any loans against life insurance policies.
  • Mortgage Liabilities: Include the total debt secured by any real estate, including first and second mortgages and home equity loans.
  • Unpaid Taxes: List any unpaid income tax, property taxes, and personal property taxes.
  • Other Liabilities: Include private loans from friends or family, legal judgments, and unpaid child support or alimony.

Net Worth: Net Worth = Total Assets – Total Liabilities

Additional Sections to Complete

Once you’ve filled in the basic table, additional details about your assets and liabilities are required in the sections below.

Section 1: Income

  • Salary: Include wages or salaries you regularly pay yourself from the business and any other employment.
  • Investment and Real Estate Income: Provide details of income from investments or properties.
  • Other Income: This might include disability income, foster care payments, and retirement income (but not alimony or child support).
  • Contingent Liabilities: Include any loans for which you co-signed, or set-aside funds for contingencies like lawsuits or IRS audits.

Section 2: Loans and Credit Cards

Provide details on all outstanding bank loans, credit card balances, student loans, auto loans, and personal loans.

Section 3: Stocks and Bonds

Provide details on stocks and bonds owned, including the number of shares and their current values.

Section 4: Real Estate

Include all properties owned—both free and clear, and those with mortgages. Use online sources like Zillow to estimate current property values.

Section 5: Other Assets

Describe the assets listed in Accounts Receivable, Other Personal Property, and Other Assets. Include the asset and its value, e.g., “2024 tax refund expected: $1,450” or “2018 fishing boat: $9,000.”

Section 6: Taxes Owed

Provide details on any unpaid taxes owed to the federal, state, or local government. If you’re on a payment plan, include the balance and payment terms.

Section 7: Other Liabilities

Provide details on any other liabilities not already covered in the previous sections.

Section 8: Life Insurance Policies

List the face value of your life insurance policies and the cash value you would receive if you cashed them out. If you’ve borrowed against any policies, include those details here as well.

Be sure to sign and date the form, and include your Social Security Number. If you are married, your spouse must also sign and date the form.

When lenders, landlords, or franchisors review your PFS, they’re evaluating whether you manage your personal finances responsibly, if you’ve taken on too much debt, and whether you can meet your financial obligations. Managing your personal finances well is critical, not only for your own peace of mind but also to demonstrate your ability to manage your business effectively.

Conclusion

The Personal Financial Statement is a key tool in securing financing for your business and demonstrating your financial responsibility to potential partners. By completing it accurately, you’ll be better prepared for any financial assessments that come your way. If you have any questions about how to complete your PFS or need further assistance, feel free to drop a comment below or email me at susan.ball5@aol.com! I’m happy to help you navigate this important aspect of your business finances.

Know Your Financial Statements—Accounts Payable

Most small businesses have a number of unpaid bills at any given time. Inventory has been delivered, but the invoice isn’t due yet. Utility bills arrive two to three weeks before the due date. Retail sales tax has been collected but not remitted to the tax department. Payroll withholding taxes are being held in escrow until it’s time to file quarterly reports. These unpaid bills are known as accounts payable.

It’s crucial to keep track of your accounts payable so you know how much is owed, to whom, and when the bills are due. Managing your accounts payable effectively offers several benefits. A statement of accounts payable will help you achieve this.

Benefits of a Statement of Accounts Payable

  1. Effective Cash Flow Management
    Accounts payable should be included in your cash flow statement for the month they are due. This ensures that you’ll have enough cash on hand to cover those bills. It also helps highlight months where a shortage might occur, allowing you to arrange a line of credit to meet forecasted shortfalls.
  2. Avoidance of Late Fees and Interest
    Tax authorities impose penalties for late filing of quarterly tax payments and monthly sales tax reports. Banks, utility companies, and suppliers may also charge late fees or interest for bills that aren’t paid on time.
  3. Take Advantage of Discounts
    Many suppliers offer discounts for early payment. A statement of accounts payable lets you easily spot vendors offering discounts, so you can ensure bills are paid on time to take advantage of these savings.
  4. Maintain Good Credit and Vendor Relationships
    Timely payments are key to maintaining a strong credit score and healthy relationships with lenders and suppliers.
  5. Preparation for Loan Requests
    If you need to borrow money or establish a line of credit, lenders will often request a statement of accounts payable. This statement helps them evaluate your level of debt in relation to industry norms and your ability to cover outstanding debts if your revenue declines.

Creating a Statement of Accounts Payable

A statement of accounts payable is essentially a table that includes:

  • Name of creditor
  • Account number or invoice number
  • Invoice date
  • Due date
  • Amount owed
CreditorAcct/Invoice NumberInvoice DateDue DateAmount
Bill 1    
Bill 2    
Bill 3    
Bill 4    

Tips for Managing Accounts Payable

Managing accounts payable effectively is crucial for maintaining healthy cash flow and good vendor relationships. Here are some best practices to consider:

  • Separate Regular and Occasional Bills
    Keep distinct charts for bills that occur regularly and those that are occasional. This makes it easier to track and manage.
  • Record Monthly Bills on Your Cash Flow Statement
    Include occasional bills in the months they are due, not just the regular ones. This will help you get a clear picture of your upcoming cash flow needs.
  • Set Up Automatic Payments for Fixed Monthly Bills
    Set up automatic payments for bills like rent, loan payments, cell phone bills, and subscriptions that are predictable and have a fixed amount.
  • Estimate and Adjust for Variable Bills
    For bills that vary, like utilities or discretionary expenses (marketing, for example), use an estimated amount in your cash flow statement and adjust for seasonal variations.
  • Automate Bill Payments When Possible
    If possible, have bills go directly to your bank. This simplifies the payment process, especially if you’re using a bill-paying app.
  • Track Infrequent Bills
    For less frequent bills, like insurance payments, set up automatic payments to ensure you don’t overlook them.
  • Balance Your Checkbook Regularly
    Schedule weekly or bi-monthly checkups to balance your checkbook and confirm that all bills have been paid or are scheduled for timely payment.
  • Forecast Cash Flow in Advance
    Predict your monthly cash balances several months in advance to determine if sufficient funds will be available during slower months. If you forecast a shortage, take steps to ensure enough cash is available, like establishing a line of credit or injecting more capital into the business.

Conclusion

A statement of accounts payable is a simple but powerful tool for tracking your bills and maintaining healthy cash flow. By following the tips above, you’ll be able to manage your accounts payable effectively, avoid late fees, and maintain good credit and vendor relationships.

If you have any questions about managing your accounts payable or tips for creating your own statement, feel free to drop them in the comments below. I’d love to help you better understand this important aspect of your business finances!

Know Your Financial Statements—Accounts Receivable

If your business extends credit to customers, understanding and managing accounts receivable is essential. Accounts Receivable (AR) refers to the money customers owe for services rendered or goods delivered, and it’s a critical part of your cash flow. Many businesses—like professional services, utility companies, and wholesalers—work with accounts receivable.

What Are Accounts Receivable?

When you extend credit, you’re essentially allowing your customers to pay later, often within a specified number of days. For example, if you deliver goods or services to a customer, you may allow them 30 days to pay the bill. In this case, you would have an account receivable until that payment is made.

To effectively track AR, businesses use an aging schedule, which categorizes accounts based on how long the payment is overdue. At the end of this blog, I’ve provided a helpful Accounts Receivable Aging Schedule Template. This template outlines what to include in your report, but if you prefer to create your own, it offers a great starting point to ensure you’re tracking the necessary information. Typical categories are:

  • Current (not yet due)
  • 1-30 days past due
  • 31-60 days past due
  • 61-90 days past due
  • Over 90 days past due

Why Does This Matter?

An Accounts Receivable Aging Report plays a significant role when you apply for a business loan. Lenders will review this report to assess how much of your business’s sales are made on credit, how it compares to industry norms, and whether there’s a risk of non-collection. Specifically, lenders are concerned about the percentage of receivables that are more than 60 days overdue. If the report shows high delinquency, it could signal poor cash flow management, which might lead to a loan denial.

Why Managing Accounts Receivable is Crucial

Effective AR management is key to your business’s cash flow health. Here are a few strategies to keep in mind:

  • Measure the Effectiveness of Discounts
    Many businesses offer early payment discounts, like “2/10 Net 30,” meaning a customer gets a 2% discount if they pay within 10 days, but the full amount is due in 30 days. If a lot of customers are taking advantage of the discount, cash comes in quicker—but your profit margin takes a hit. Understanding how well your discount terms are working can help balance cash flow with profitability.
  • Monitor Customer Behavior
    Let’s say you’ve had a loyal customer who consistently pays early for the discount, but now they’re paying late or just on time. This could be a sign that they’re experiencing cash flow problems. If so, it’s worth reaching out to see how you can help. Perhaps they need smaller orders, or you can work out a payment plan to keep the relationship strong and reduce your risk of uncollected debt.
  • Improve Cash Flow Management
    By closely tracking overdue invoices, you can promptly follow up with reminders. If certain customers consistently pay late, it might be necessary to put a hold on further orders until they clear their outstanding balance. Proactively managing receivables ensures that cash keeps flowing into your business and reduces the risk of uncollected debt.
  • Assess and Adjust Credit Terms
    If few customers are taking advantage of your early payment discount, it could be time to reassess your credit policy. Maybe your discount isn’t big enough to incentivize early payment. Or perhaps customers need more time to pay based on how quickly they can sell your product. Adjusting your credit terms might help accelerate cash flow without compromising customer relationships.

The Risk and Reward of Extending Credit

Offering credit is an excellent way to attract new customers and keep current ones loyal. A discount for early payment can boost cash flow and reduce the risk of bad debt. But, as with all things in business, extending credit comes with its risks—delayed payments can affect cash flow, and offering discounts reduces profit margins. It’s important to stay informed about industry standards, track your AR regularly, and adjust your policies as needed. Most accounting software has monitoring features that can make this process easier.

Here’s a template for an Accounts Receivable Aging Schedule:

Final Thoughts

Tracking accounts receivable is more than just a financial task—it’s a critical element in your business’s cash flow management. By understanding how to monitor, manage, and adjust credit policies, you can strengthen your business’s financial health and make sure cash continues to flow in the right direction.

Know Your Financial Statements—The Cash Flow Statement

The cash flow statement is an essential tool for business owners and anyone considering business ownership. Unlike the balance sheet or income statement, which show what’s already happened, the cash flow statement is a forecasting tool. It projects future income and expenses over a specific period, helping you see what’s coming down the line.

A typical cash flow forecast is broken down by month and often extends for one or more years. For example, if you’re applying for a commercial loan, the lender will typically request a 24-month forecast.

A solid cash flow statement does three important things:

  1. Demonstrates the profit potential of your business
  2. Highlights the seasonal nature of your revenue
  3. Shows when you might face cash shortages

When Should You Develop a Cash Flow Forecast?

As a business owner, it’s critical to create a cash flow forecast before making major decisions like:

  • Starting a new business
  • Applying for a business loan
  • Changing locations (whether moving from a home office to a rental or expanding to a larger space)
  • Hiring additional employees
  • Opening a second location
  • Introducing new products or services

How to Develop Your Cash Flow Forecast

To create your cash flow forecast, follow these steps:

  1. Identify Your Revenue Streams:
    List out all the ways your business makes money. This could include retail sales, consulting services, wholesale accounts, etc.
  2. Estimate Monthly Revenue for Each Stream:
    • What does the “average” customer spend?
    • How often will purchases be made? Retail sales might happen daily, but consulting services could be more occasional and of a higher value.
      • How will customers pay? Retail transactions are typically paid upfront, but wholesale or service-based businesses may bill customers and expect payment within a set number of days. Make sure to include the revenue in the month you expect to receive payment.
  3. Account for Seasonality:
    Some industries see fluctuating revenue throughout the year. For example, retail tends to be slower in the first quarter and peaks in the last quarter. Be sure to include this in your forecast.
  4. Estimate Your Costs:
    • Cost of Goods Sold (COGS): How much does it cost to produce or acquire the goods/services you sell?
    • Operating Expenses: Fixed expenses (rent, salaries, insurance), Variable expenses (utilities, marketing, supplies), and Occasional expenses (licenses, subscriptions, property taxes)
    • Non-Operating Costs: These include investments in new equipment, furniture, building improvements, utility deposits, and loan payments.
  5. Include Your Owner’s Draw:
    Your own payment, called the Owner’s Draw, should be listed at the bottom of your cash flow statement to show that you’re paid after all bills are covered.

Cash Flow vs. Income Statement

The cash flow statement and income statement are different in a few key ways:

  • Loan Payments: The cash flow statement includes the entire loan payment (both principal and interest). The income statement, however, only includes the interest portion of the loan, as that’s the amount that’s tax-deductible.
  • Depreciation: While depreciation affects your income statement by reducing taxable income, it doesn’t appear on the cash flow statement because it doesn’t involve an actual cash outflow.

Why Accurate Estimates Matter

It’s essential to estimate revenues and expenses as accurately as possible. Your cash flow forecast will help you decide whether to start or expand your business, assist lenders in evaluating your loan application, and highlight any months where your revenues might fall short of covering expenses. By recognizing potential cash shortfalls ahead of time, you can make a plan to cover those gaps—whether by borrowing, saving during busier months, or investing your own funds.

Get Started with Your Own Cash Flow Statement

I’ve included a cash flow statement template to help you create your own forecast. If you’d like an editable version of the worksheet, just email me at susan.ball5@aol.com, and I’ll send you a copy.