Profitable on Paper, Short on Cash? How AP and AR in Sage X3 Shape Your Cash Flow

What is the difference between accounts payable and accounts receivable?

The short answer: accounts payable is what you owe, and accounts receivable is what you are owed.

Both are timing differences between when an invoice is recorded and when cash actually moves. For a manufacturer or distributor, those timing differences can be measured in months and in millions of dollars.

Why can a profitable company run short of cash?

Because profit and cash run on different clocks. The cash conversion cycle measures how many days pass between paying for materials and collecting from customers:

That is why AR and AP are not back-office functions. They are two of the three levers that decide how much cash your growth requires.

Why can inventory consume cash even when sales are strong?

Inventory is the third lever, and for manufacturers and distributors it is often the largest. Every case on the shelf and every batch in production is cash that has already left the business and has not yet come back.

The most common causes we see are:

• Slow-moving and obsolete stock that is still carried at full value and still counted as available.
• Purchasing ahead of demand, driven by minimum order quantities, volume discounts, or reorder points that were set years ago.
• Long production cycles, where materials are issued early and finished goods take weeks to reach a customer.
• Inaccurate demand planning, so safety stock is set by habit rather than by actual consumption and lead times.

A company can improve its collections and still struggle with cash if it keeps buying more inventory than it sells. In that case, better AR simply funds a larger warehouse.

In Sage X3, the controls that matter here sit outside accounting: reorder policies and safety stock on each product-site, MRP and production planning, purchase suggestions, and stock aging analysis. This is where finance, purchasing, and operations need to work from the same numbers.

How does Sage X3 manage accounts payable?

In Sage X3, accounts payable is the end of a procure-to-pay process that starts with the purchase order. The controls you configure at each step decide whether you pay the right amount, at the right time, to the right supplier:

1. Purchase order. The order sets the agreed price, quantity, and payment terms for the supplier.
2. Receipt. Goods are received into stock and valued. Until the supplier invoice arrives, the business has a liability for goods received but not yet invoiced.
3. Invoice matching. The purchase invoice is matched against the order and the receipt. Invoices that exceed configured price or quantity tolerances, such as an invoice at $10.75 against an order at $10.00, can generate a warning or a blocking error.
4. Approval. Depending on the company's approval workflow and security configuration, exceptions can require authorized review before they are processed or paid.
5. Payment proposal. Sage X3 selects open items that are due, based on payment terms and due dates, and proposes a payment run for review.
6. Payment and bank reconciliation. Payments are issued, posted, and matched against the bank statement.

When these steps are configured well, AP becomes a cash management tool. You can pay on the due date rather than early, take early payment discounts when they are worth more than the cash, and see exactly what is due next week and next month.

When they are not, the common results are invoices paid before goods arrive, price differences that pass unnoticed into inventory cost, and payment runs built in a spreadsheet rather than in the system.

How does Sage X3 manage accounts receivable?

Accounts receivable is the end of the order-to-cash process. In Sage X3, collections start well before the invoice is issued:

• Credit control on the order. Sage X3 supports customer credit limits and configurable credit checks during sales processing. Depending on company policy and configuration, orders that exceed authorized limits, or that come from a customer on hold, can generate warnings or be blocked pending review.
• Accurate and timely invoicing. Invoices generated from shipments carry the correct prices, terms, and tax. Every day an invoice waits to be issued is a day added to DSO.
• Payment terms. Terms defined on the customer and the invoice drive due dates, and any early payment discounts you choose to offer.
• Reminders and dunning. Sage X3 can generate customer reminders by level, based on how far past due each invoice is, so follow-up does not depend on someone remembering.
• Cash application. Customer payments are entered and matched against open invoices. Unapplied cash and unmatched deductions make the aging report less reliable.
• Aging and analysis. The customer aging shows who owes what and how late it is, by customer, by site, and by company.

The most expensive AR problem is rarely one large bad debt. It is the steady build-up of disputed invoices, unapplied payments, and customers who are allowed to keep ordering after they have stopped paying on time.

Why don't AP and AR reconcile to the general ledger?

In Sage X3, customer and supplier transactions are associated with business partners and with collective control accounts in the general ledger. When they are compared using consistent dates, currencies, and reporting criteria, the ledger balances should reconcile to the customer and supplier detail.

Differences usually come from:

• Manual journal entries posted directly to control accounts without business partner detail.
• Incorrect accounting codes or collective account assignments, so a supplier or customer posts to the wrong control account.
• Differences in accounting dates, report cutoff dates, or currency selection between the aging report and the ledger.
• Unmatched payments and unapplied credits. These do not necessarily make the control account wrong, but they make outstanding invoice reporting and collections follow-up misleading.
• Foreign currency revaluation entries that are missing, posted inconsistently, or reported on a different basis.
• Intercompany postings that have not been recorded or reconciled consistently on both sides.

Goods received not invoiced should be reviewed separately. It is an accrued liability for goods received without a supplier invoice, not part of trade accounts payable. These balances can stay open because of missing invoices, returns, incorrect receipt matching, or incomplete purchasing processes.

Together, these issues slow down month-end close, undermine cash forecasting, and make financial reporting less reliable. For groups operating across the US and the Caribbean, multi-currency and intercompany differences are usually the largest contributors.

Is your AP and AR process costing you cash?

These are the signs we see most often in Sage X3 environments:

1. DSO is rising while sales are flat. Collections are slowing, invoices are going out late, or disputes are not being resolved.
2. Customers on credit hold are still receiving shipments. Credit limits are not set, are not enforced on the order, or are released routinely without review.
3. The customer aging is full of small unapplied payments and credits. Cash application is incomplete, so nobody fully trusts the aging.
4. Suppliers are paid early, or paid twice. Payment proposals are not driven by due dates, or invoices can be entered without a matching order and receipt.
5. Invoice price differences are approved without review. Matching tolerances are too wide, so supplier price increases flow into inventory cost and margins without anyone noticing.
6. The aging reports do not match the balance sheet. Control accounts carry manual entries or incorrect accounting codes, and received-not-invoiced balances are not reviewed separately.
7. The cash forecast lives in a spreadsheet. Finance rebuilds expected inflows and outflows by hand because the system's due dates and open items cannot be relied upon.

If two or more of these sound familiar, the problem is usually configuration and process, not a lack of software.

Frequently asked questions