How to Manage AR and AP as One Cash-Protection System

Published by Andrew Cohen, CFA, CPA on August 14, 2026

Category	Wk 1	Wk 2	Wk 3	Wk 4	Wk 5	Wk 6	Wk 7	Wk 8	Wk 9	Wk 10	Wk 11	Wk 12	Wk 13
Opening Cash	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AR Collections (0–30 days)	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AR Collections (31–60 days)	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
Other Cash Inflows	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
Total Inflows	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AP — Vendor Payments	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AP — Payroll (Gusto)	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AP — Rent / Utilities	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
AP — Debt Service	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
Total Outflows	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—
Net Cash Position	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—	$—

Key Takeaways

51% of employer firms report uneven cash flows as a top challenge; the root cause is AR collections falling out of sync with scheduled AP obligations.
Treating AR and AP as one integrated cash-protection system prevents last-minute liquidity gaps that compress operating accounts.
Six operational steps, covering credit terms, invoicing, aging reviews, three-way match, 13-week forecasting, and month-end reconciliation, close the cash-flow gap.
Key performance indicators such as DSO, DPO, AP/AR ratio, and clean reconciliations provide an integrated, real-time read on system health.
When internal bandwidth or expertise runs out, contact Condesa Financial for nearshore, ex-Big-4 fractional CFO and outsourced accounting support.

Core Concepts and Tools Before You Start

Accounts receivable (AR) is money owed to your business by customers for goods or services already delivered. Accounts payable (AP) is money your business owes to vendors and suppliers. Without an integrated view of both, managers often discover cash-flow problems only after it is too late to take corrective action. The system described below solves that problem by connecting AR and AP data in real time, but it depends on a specific technology stack.

Prerequisites for the system described below:

Accounting platform: QuickBooks Online (default) or NetSuite for larger organizations
Spend management: Ramp spend cards (Condesa’s preferred partner)
Payroll: Gusto or Rippling
Collaboration: Google Workspace

These tools give you the data and controls needed for an integrated AR/AP view. An external fractional CFO becomes necessary when the founder is making payment-timing decisions without a forward-looking cash model, when no one is monitoring DSO or DPO, or when the business is approaching a fundraise, acquisition, or new market entry that requires FP&A-grade analysis.

Discuss your current stage and finance needs with Condesa’s nearshore team to determine whether a fractional CFO engagement is appropriate.

Step 1: Set Credit Terms and Build Vendor Lists

Purpose: Set clear rules before any invoice is issued or received. Credit terms define when customers must pay. Vendor lists define who is authorized to supply goods and services and under what conditions.

Required inputs: Customer credit applications, trade references, historical payment behavior, and a vendor master template.

Decision points: Before extending credit, verify customer identity, legal details, references, payment history, and expected purchase volume so that credit limits reflect both risk and the company’s capacity to finance outstanding balances. On the AP side, vendor onboarding must include a control step. Segregation of duties requires that the person creating a vendor in the system is not the same person who approves payments to that vendor. This separation reduces fraud risk and keeps payment approval independent.

Stakeholders: Founder or CFO (policy approval), operations lead (vendor onboarding), finance team (system entry).

Step 1 checklist:

Draft a written credit policy covering eligibility, limits, payment terms, and review frequency
Collect and file a credit application for every new customer before first shipment
Build a vendor master in QuickBooks with independent bank-detail verification
Assign approval authority by dollar threshold, such as department manager under $1,000 and CFO above $25,000
Document any exceptions to the credit policy in writing

Schedule a credit policy and vendor-onboarding review if your current structure feels ad hoc or risky.

Step 2: Invoice and Verify Immediately

Purpose: Start the cash clock the moment a contractual event is complete. Every day between delivery and invoice issuance represents free financing extended to the customer.

Required inputs: Signed delivery confirmation or service completion record, agreed price and payment terms, customer billing contact.

Decision points: Quotations and contracts should state price, tax, due date, deposit requirements, accepted payment methods, late-payment consequences, and the dispute-resolution process before any delivery occurs. In QuickBooks Online, create the invoice from the approved estimate, attach the delivery record, and email it immediately using the platform’s built-in send function so the customer receives a complete, accurate bill.

Stakeholders: Billing team (invoice creation), operations (delivery confirmation), customer success (dispute escalation).

Step 2 checklist:

Issue the invoice on the same day as delivery or service completion
Attach supporting documentation such as PO, delivery note, or signed SOW to every invoice
Offer at least two electronic payment methods to reduce friction
Set QuickBooks to auto-send a payment reminder three days before the due date
Log the invoice in the AR aging report immediately upon issuance

Book a 30-minute workflow audit to see how Condesa structures QuickBooks for faster invoice-to-cash cycles.

Step 3: Run Weekly Aging Reviews and Collections

Purpose: Keep receivables from drifting into write-offs by using a structured, documented collections cadence.

Required inputs: QuickBooks AR aging report segmented by current, 1–30, 31–60, 61–90, and 90+ days, plus a customer contact log and collections escalation policy.

Decision points: AR aging reports should be reviewed at least once a month, and businesses with high invoice volumes or frequent late payments should review weekly or biweekly. A structured collections timeline escalates contact frequency and formality as the invoice ages.

3 days before due: automated reminder via QuickBooks
Due date: confirmation notice
7 days overdue: first overdue notice
15 days overdue: personal phone call, outcome documented
30 days overdue: formal written notice and escalation to leadership

Stakeholders: AR specialist (collections execution), finance lead (aging review), founder or CFO (write-off approval).

Step 3 checklist:

Pull the QuickBooks aging report every Monday morning
Flag all invoices 15 or more days overdue for personal outreach
Document every collections call with date, contact name, and outcome
Escalate 60+ day balances to leadership for dispute resolution or write-off review
Calculate DSO weekly using the formula (Total AR ÷ Total Credit Sales) × Days in Period

Request a collections cadence design session to tailor this process for a lean SME team.

Step 4: Execute Three-Way Match and Time Payments

Purpose: Confirm that every vendor payment is authorized, accurate, and timed to preserve liquidity while protecting supplier relationships.

Required inputs: Purchase order, goods received note or service confirmation, vendor invoice, and the Ramp spend card transaction log.

Decision points: Three-way matching in accounts payable verifies that the purchase order, goods receipt note, and vendor invoice align on quantity, price, and terms before payment approval, directly reducing overpayments, duplicate payments, and fraudulent invoices. Finance teams that adopt three-way matching often see 20–30% of invoices fail to match cleanly, with quantity variances among the common causes. Use Ramp’s receipt-matching feature to automate the match on card transactions and route exceptions for manual review so staff focus on true discrepancies.

Stakeholders: AP specialist (match execution), department manager (PO origination), finance lead (exception approval).

Step 4 checklist:

Require a purchase order for every vendor engagement above your defined threshold
Route all vendor invoices to a single inbox such as invoices@yourcompany.com
Match PO, goods receipt, and invoice before posting any liability in QuickBooks
Run a weekly or bi-weekly payment batch and have finance leadership approve before execution
Evaluate early-payment discounts, since a 2/10 net 30 term delivers an annualized return of approximately 36%

Explore three-way match implementation with Condesa to strengthen controls in your Ramp and QuickBooks environment.

Step 5: Build and Maintain a 13-Week Cash Forecast

Purpose: Turn AR and AP data into a forward-looking liquidity view so you can make proactive decisions instead of reacting to surprises.

Required inputs: QuickBooks AR aging report, AP due list, Gusto payroll schedule, bank statement opening balance, and debt service calendar.

Decision points: The biggest accuracy lever in receivables forecasting is replacing due-date assumptions with each customer’s actual historical payment behavior, such as forecasting a net-30 invoice at terms plus 9 days if that customer averages 9 days late. Apply collection probabilities by aging bucket, such as 80–90% for current AR between 0 and 30 days and 50–70% for 31–60 day AR. Target 90–95% accuracy for weeks 1–4, 80–90% for weeks 5–8, and 70–85% for weeks 9–13.

Stakeholders: Fractional CFO or finance lead (model ownership), AR specialist (collections inputs), AP specialist (payment schedule), payroll administrator (Gusto data).

Step 5 checklist:

Set Monday as the weekly forecast refresh cadence
Input prior week’s actual inflows and outflows and reconcile variance against forecast
Pull Gusto payroll dates and amounts into the AP outflow rows
Apply customer-specific payment behavior to open AR invoices, not just due dates
Add one new week to maintain the rolling 13-week horizon

Engage Condesa to build and maintain a 13-week cash model if your team lacks the time or expertise to keep one current.

Step 6: Close the Month with Reconciliations and Controls

Purpose: Confirm that reported AR and AP balances match actual activity, support audit readiness, and reset the system for the next cycle.

Required inputs: QuickBooks general ledger, bank statements, AR subledger, AP subledger, Ramp transaction export, and Gusto payroll register.

Decision points: Regular reconciliations and timely month-end closes ensure reported AP and AR balances match actual activity, supporting audit readiness and more precise budgeting and forecasting. Segregation of duties at close means the person posting journal entries is not the same person approving them, which keeps review independent.

Stakeholders: Controller or finance lead (reconciliation ownership), AP/AR specialists (subledger inputs), fractional CFO (review and sign-off).

Step 6 checklist:

Reconcile bank statements to QuickBooks within five business days of month-end
Confirm AR subledger total matches the general ledger accounts receivable balance
Confirm AP subledger total matches the general ledger accounts payable balance
Review the management P&L for anomalies before distributing to stakeholders
Archive all supporting documentation in a named, dated folder in Google Drive

See how Condesa’s ex-Big-4 team can handle your month-end close across time zones and entities.

Common Mistakes That Erode Cash Protection

The six steps above only work when the team follows them consistently. The failure modes below appear most often in SME finance operations and weaken cash protection.

Skipping three-way match: Companies overpay vendors on 0.5-1.5% of invoices, with typical AP audit recoveries ranging from 0.1% to 2% of annual spend.
Stale aging buckets: An aging report that is not refreshed weekly becomes a lagging indicator rather than a control. Late payments account for a substantial portion of B2B sales, with collection times that can extend significantly, and infrequent reviews compound that risk.
Ignoring segregation of duties: The ACFE 2024 Report to the Nations found that organizations lose about 5% of annual revenue to occupational fraud, with median losses increasing 24% from the prior report and an average detection time of 12 months.
Using a single blended AR balance for forecasting: A single blended AR balance is not sufficient for a weekly cash forecast because it hides timing differences across individual invoices and customers.
Overlooking early-payment discount math: Passing on a 2/10 net 30 discount to preserve short-term cash often costs more than a line of credit would.

Request a controls review if any of these patterns sound familiar in your current finance operation.

How to Evaluate Progress

Four metrics provide an integrated read on system health and show whether your AR/AP process is protecting cash.

Days Sales Outstanding (DSO): (Total AR ÷ Total Credit Sales) × Days in Period. A declining DSO indicates faster collections. U.S. small businesses have seen improvements in average payment times in recent quarters.
Days Payable Outstanding (DPO): (Total AP ÷ COGS) × Days in Period. A DPO between 30 and 60 days is generally considered a healthy range, though the ideal depends on industry, supplier terms, and cash flow strategy.
AP/AR ratio: A healthy company typically targets an AR/AP ratio of approximately 2:1, meaning it collects roughly twice as fast as it pays. A ratio below 1:1 signals that the business is paying out faster than it is collecting.
Clean reconciliations: The percentage of months closed with zero unreconciled items, which acts as a leading indicator of control quality and audit readiness.

Benchmark your DSO, DPO, and AP/AR ratio with Condesa to see how you compare with peers.

Advanced Considerations for Growing SMEs

As the business scales, three additional dimensions require attention to keep cash protection strong.

Cross-border collections: Multinational SMEs face currency timing risk, correspondent banking delays, and local tax compliance obligations that standard QuickBooks workflows do not address natively. A fractional CFO with cross-border experience can design collection structures that minimize FX exposure and comply with local withholding requirements.

System upgrades: Manual processes can limit treasury professionals’ ability to manage risk effectively and improve operations. The migration path from QuickBooks Online to NetSuite typically becomes relevant between $5M and $20M in revenue, when reporting complexity and multi-entity consolidation exceed QuickBooks’ native capabilities.

FP&A and financial modeling: Mapping and standardizing AR processes such as invoice formats, cash application rules, dispute codes, and credit policies can improve receivables-related working capital. When the business is preparing for a capital raise, M&A transaction, or new business-line launch, the 13-week cash forecast must sit inside a longer-horizon financial model, which calls for fractional CFO-level expertise rather than bookkeeping bandwidth.

Discuss FP&A, modeling, or system migration support with Condesa’s ex-Big-4 team if you are approaching this stage.

Frequently Asked Questions

What is a good AP to AR ratio?

A healthy AP to AR ratio for most SMEs is approximately 1:2, meaning the business holds roughly twice as much in receivables as it owes in payables at any given point. This ratio indicates that cash is being collected faster than it is being paid out, which supports positive working capital. A ratio below 1:1 is a warning sign because the business is paying suppliers faster than customers are paying it, creating a structural cash gap that must be funded from reserves or credit. The ratio should always be interpreted alongside DSO and DPO, because a favorable ratio can mask a deteriorating collections cycle if both AR and AP balances are growing simultaneously.

What are the five C’s of credit?

The five C’s of credit are the standard framework lenders and credit managers use to evaluate whether to extend credit to a customer or counterparty. Character refers to the applicant’s reputation and payment history, the qualitative read on whether they honor obligations. Capacity measures the applicant’s ability to repay based on cash flow and existing debt load. Capital examines the applicant’s net worth and financial reserves as a secondary repayment source. Collateral identifies assets that could secure the obligation if the primary repayment source fails. Conditions consider the broader economic environment and the specific purpose of the credit. For SME founders managing AR, applying the five C’s before extending payment terms to a new customer is the single most effective way to prevent a receivable from becoming a write-off.

Can one person handle both accounts receivable and accounts payable in a lean team?

Operationally, one person can manage both functions in a business with low transaction volume. The risk is not competence, it is control. When the same individual issues invoices, applies cash receipts, enters vendor invoices, and executes payments, there is no independent check on any of those activities. This situation creates the conditions for both undetected error and fraud. The ACFE consistently identifies the absence of segregation of duties as the leading enabler of occupational fraud in small businesses. The practical solution for lean teams is to separate approval authority from execution, as described in Step 1, so one person prepares the payment batch or issues the invoice and a second person, typically the founder or a fractional CFO, reviews and approves before anything is posted or paid. Condesa’s nearshore model is designed for this scenario and provides an ex-Big-4 finance professional as the reviewing authority without the cost of a full-time hire.

Learn how Condesa structures AP/AR oversight for lean SME teams that need stronger controls.

Conclusion

Managing accounts receivable and accounts payable as separate functions often causes SME cash-flow squeezes. The six-step system described above, from credit terms and immediate invoicing through weekly aging reviews, three-way match, 13-week forecasting, and month-end reconciliation, treats AR and AP as one integrated cash-protection mechanism. The metrics that confirm the system is working are DSO, DPO, the AP/AR ratio, and clean monthly reconciliations.

When internal bandwidth or expertise runs out, Condesa Financial Group’s nearshore, ex-Big-4 team becomes a logical next step. Condesa delivers fractional CFO oversight and outsourced accounting at price-competitive rates made possible by a Panama and Mexico City delivery model, which provides Big-4-caliber work without the Big-4 cost structure. The engagement begins with a free consultation.

Schedule your free consultation to see how Condesa can help protect your cash flow.