Category: Bookkeeping

Summary: A profitable business can still struggle to pay bills on time. A rolling 13-week cash forecast turns upcoming deposits and payments into a weekly view of available cash, giving owners time to act before a shortage develops.

Your income statement may show a strong month while your bank balance tells a different story. Perhaps a major customer has 45-day payment terms, payroll is due Friday, and an annual insurance premium hits next week. The challenge is not necessarily poor sales. It is the timing of cash.

A 13-week cash flow forecast is a simple way to see that timing. It is a management planning tool—not a replacement for your bookkeeping records, bank reconciliation, or formal financial statements.

What belongs in the forecast?

Set up a spreadsheet with one column for each of the next 13 weeks and rows for five essential items:

1. Beginning available cash: the amount you can actually spend at the start of the week, excluding restricted funds or balances reserved for obligations you cannot use for operations.
2. Expected cash receipts: customer payments, deposits, and other funds expected to clear that week. Use realistic collection dates, not invoice dates.
3. Expected cash payments: payroll, rent, supplier invoices, taxes, loan payments, subscriptions, insurance, and planned equipment purchases.
4. Net cash change: receipts minus payments.
5. Ending available cash: beginning cash plus net cash change. This becomes the next week’s opening balance.

A simple example

Suppose you start Monday with $12,000 available. You expect $5,000 in customer collections and $9,000 in payments during the week. Your forecast ending cash is $8,000 ($12,000 + $5,000 − $9,000).

Now assume next week’s payroll and other bills total $11,000 but collections are not expected until the following week. The forecast reveals the potential gap early enough to follow up on overdue invoices, adjust discretionary purchases, or discuss a financing option with your lender. It does not guarantee those actions will solve the gap, but it makes the risk visible.

Build it in five practical steps

1. Start with your actual bank position. Reconcile the bank balance and account for outstanding checks, pending card settlements, and any cash that is not available for spending.
2. List customer receipts by likely arrival date. Review open invoices and customers’ payment histories. Separate confirmed payments from optimistic estimates.
3. List every significant payment. Include irregular items such as quarterly estimated taxes, annual renewals, bonuses, and equipment deposits. Do not treat sales tax collected on behalf of a government as free operating cash.
4. Set a minimum cash cushion. Choose a working threshold based on payroll, essential bills, and your risk tolerance. If a projected ending balance falls below it, flag the week.
5. Refresh the forecast every week. Replace estimates with actual transactions, explain material differences, and add a new thirteenth week.

Three mistakes to avoid

Confusing profit with cash. Revenue recognized today may not arrive in the bank until weeks later. Assuming every invoice will be paid on time. Build collection assumptions from evidence and consider a slower-payment scenario. Ignoring one-time payments. Tax deposits, renewals, and equipment purchases often create the sharpest dips.

What to review each Friday

Ask: What changed since last week? Which customer payments slipped? What is our lowest projected cash balance in the next 13 weeks? Which commitments can we make safely? A 15-minute review with an updated forecast can be more useful than a beautifully formatted spreadsheet no one maintains.

Bottom line: Bookkeeping records what happened. A rolling cash forecast helps you decide what to do next. For businesses with uneven collections or seasonal expenses, that forward view can be especially valuable.

Sources and further reading

• FDIC and SBA — Money Smart for Small Business, including the Managing Cash Flow module.
• SBA/SCORE — Develop Your Cash Flow Projection (October 14, 2026 workshop description).
• SBA/SCORE — Creating Realistic Financial Projections for Your Small Business (October 21, 2026 workshop description).

3A Bookkeeping Services | A service of 3A IT Consulting, LLC. Educational information; consult your accountant or tax adviser for decisions specific to your business.

The Missing Money Mystery

Imagine reviewing your business records at the end of the month.

Your point-of-sale system reports $20,000 in customer payments, but your bank account shows only $18,400 in deposits.

Where did the other $1,600 go?

For many small businesses, the difference is not missing money. It is the result of payment processing fees, refunds, chargebacks, settlement timing, and other adjustments.

Understanding these differences is essential to maintaining accurate financial records.

Gross Sales Are Not the Same as Bank Deposits

When customers pay with credit or debit cards, payment processors generally collect the payments before transferring funds into your business bank account.

The amount deposited may be reduced by processing fees, refunds, and other deductions.

Consider this simplified example:

Transaction	Amount
Customer payments processed	$20,000
Customer refunds	($800)
Processing fees	($400)
Chargebacks	($400)
Net bank deposits	$18,400

Although $18,400 reached the bank, that amount alone does not explain the business’s sales activity.

The $20,000 in customer payments and the various adjustments need to be accounted for appropriately.

For example, refundable sales, processing expenses, and chargebacks may require different accounting treatments. Sales taxes collected on behalf of a taxing authority also need to be distinguished from business revenue.

Why This Matters at Tax Time

The IRS explains that Form 1099-K generally reports gross payment transactions without reducing the reported amount for processing fees, refunds, and similar adjustments.

Consequently, a business’s Form 1099-K may not match its bank deposits.

The IRS recommends reviewing merchant statements and other supporting records to determine the correct income and expenses to report.

Simply treating every bank deposit as sales revenue can produce inaccurate financial statements.

A Better Monthly Reconciliation Process

A reliable reconciliation starts with three sources: the payment processor’s transaction report, its payout or settlement report, and the business bank statement.

First, identify the gross customer payments processed during the period.

Next, identify refunds, processing fees, chargebacks, and other adjustments. Confirm whether sales taxes and tips are included in the reported amounts.

Then compare the resulting settlements with deposits appearing on the bank statement.

Timing differences deserve particular attention. Transactions processed at the end of one month may not reach the bank until the following month.

Finally, investigate unexplained differences rather than automatically creating adjusting entries to force the numbers to agree.

The Business Benefit

Accurate payment reconciliation helps business owners understand what they actually earned, what they paid in processing expenses, and whether their financial records are complete.

It also makes year-end reporting more manageable.

The IRS emphasizes maintaining supporting documents for business receipts and regularly reconciling bank records.

The takeaway: A bank deposit tells you how much money arrived. A properly reconciled payment report helps explain where that money came from and what happened along the way.

Supporting References

• IRS — Understanding Form 1099-K
• IRS Publication 583 — Starting a Business and Keeping Records

A chart of accounts is the organized list of categories your bookkeeping system uses to classify financial activity. Think of it as the filing cabinet behind your financial statements.

The basic categories

Assets include resources such as cash and receivables. Liabilities include amounts owed. Equity reflects the owner’s interest. Revenue tracks income earned, while expenses capture costs of operating the business.

A thoughtful chart of accounts helps create consistent reports and makes trends easier to compare over time.

Keep it useful, not complicated

Choose account names that match your operations. Avoid creating a separate account for every minor purchase. Review classifications regularly, and work with your accountant when changing the structure.

Further reading: SBA: Manage your finances.

Mixing personal and business transactions makes bookkeeping harder than it needs to be. Separate business bank and credit-card accounts create a clearer trail for income, expenses, reimbursements, and owner contributions.

Why separation matters

It reduces time spent sorting transactions, makes monthly reconciliations easier, and helps you assemble more accurate information for your tax professional. It can also help clarify which purchases belong to the business.

A practical starting checklist

• Use dedicated accounts for business receipts and payments.
• Record owner contributions and withdrawals consistently.
• Keep invoices and receipts for business purchases.
• Reconcile each account every month.

Account separation alone does not determine legal liability protection or deductibility; consult qualified legal and tax advisers for those questions.

Further reading: SBA: Open a business bank account.

Your financial records are more than a requirement for tax season. They help tell the story of your business: where revenue comes from, where money goes, and whether your operations are producing sustainable results.

Decisions start with reliable numbers

Well-maintained books can help owners identify rising costs, spot late customer payments, track cash flow, and prepare meaningful reports for lenders or advisers.

Review your profit-and-loss statement, balance sheet, and cash activity each month. Investigate unexpected changes instead of waiting until year-end.

Good bookkeeping does not guarantee profit, but it gives you a stronger foundation for making informed decisions.

Further reading: SBA financial management guidance and IRS recordkeeping.

Bookkeeping and accounting work together, but they serve different purposes. Bookkeeping is the day-to-day process of recording transactions, categorizing income and expenses, reconciling accounts, and keeping supporting documentation organized.

Accounting uses those records to prepare and interpret financial reports, evaluate performance, and support tax planning and decisions. Accurate bookkeeping makes accounting more useful.

What this means for your business

Consistent records help you understand what you earned, what you spent, what customers owe, and which bills are coming due. If records are incomplete, even sophisticated financial analysis may be misleading.

Start with a repeatable monthly process: record transactions, reconcile bank and credit-card accounts, review outstanding items, and preserve receipts.

Further reading: IRS recordkeeping guidance and SBA: Manage your finances.