Skip to main content

Why don't my payouts reconcile with my orders?

Find out why a PayPal, Stripe, Afterpay, TikTok Shop or Amazon payout doesn't match your orders, and what to do so your sales and bank deposits tie out.

Written by Emily Burrows

About

Applies to: Finaloop Accounting

When a PayPal, Stripe, Afterpay, TikTok Shop or Amazon payout doesn't match your orders, it's usually a timing difference that clears by itself, a payout that's net of fees, refunds or reserves, or a payment Finaloop can't tie to an order or a bank account. Find your situation below and follow the matching fix.

Finaloop reconciles every sale three ways: the order, the payment processor's payment, and the payout in your bank. Money a processor has collected for you but hasn't paid out yet sits in an Undeposited funds account for that processor on your Balance Sheet. To see how the matching works, check out Sales Reconciliations in Finaloop.


Symptoms

  • My payout is smaller than my orders for the same days

  • I have a Reconciliation in process balance on my Balance Sheet

  • I see Sales - PayPal, Sales - Stripe or Sales - Afterpay in my P&L

  • I see a Reconciliation discrepancies expense

  • A payout in my bank needs my input

  • My Amazon or TikTok Shop payouts don't match my orders


1. My payout is smaller than my orders for the same days

Why it happens: a payout is the processor's net amount: your sales minus its fees, refunds, chargebacks and any amount it's holding back. It also covers the processor's own payout window, which rarely lines up with the days your orders were placed.

How to fix it: there's nothing to fix. Finaloop records the fees and refunds separately on your Profit & Loss (P&L), and the order, payment and payout still tie together through Undeposited funds. Compare a full month rather than single days, and the totals line up.


2. I have a Reconciliation in process balance on my Balance Sheet

Why it happens: order data and payment data don't always arrive at the same time. Until both sides arrive, the unmatched amount waits in Reconciliation in process, a temporary holding account on your Balance Sheet.

How to fix it: usually nothing. The balance clears automatically as more data syncs, and our accounting team reconciles this account on an ongoing basis. We'll ask you if we need your input.


3. I see Sales - PayPal, Sales - Stripe or Sales - Afterpay in my P&L

Why it happens: Finaloop received a payment with no matching order. That's often temporary, but it also happens when you charge a card directly in the processor, or when the sale came from a store that isn't connected to Finaloop.

How to fix it:

  1. Click the line, for example Sales - PayPal, in your P&L to open the payments behind it.

  2. If they come from a store that isn't connected, connect it in Settings → Integrations.

Once the matching order data arrives, Finaloop moves the sale under its sales channel, such as Sales - Shopify.


4. I see a Reconciliation discrepancies expense

Why it happens: an order shows as paid through a payment processor, but no matching payment was received. Finaloop records a Reconciliation discrepancies expense so your sales aren't overstated.

How to fix it: check that the processor used for that order is connected to Finaloop and that Finaloop has its role. See How to provide Finaloop a role in your payment gateways. Once the payment data syncs and matches, the expense is reversed.


5. A payout in my bank needs my input

Why it happens: Finaloop sees a payout leave the processor but can't find where it landed, or sees a deposit it can't link to a processor. This usually means the payout went to a bank account that isn't connected, a personal account, a lender or a related business.

How to fix it: open the Anomaly Detector, a list of deposits and transfers Finaloop couldn't link to a sale, payout or account. Under Payouts from apps, click Your input needed and tell us where the money went. For the full steps, see Unmatched payouts and transfers.


6. My Amazon or TikTok Shop payouts don't match my orders

Why it happens: both marketplaces hold part of your money before paying it out. Amazon reserves funds until about 7 days after delivery (its Delivery Date Reserve policy, DD+7). TikTok Shop holds a reserve from each statement, so its payable amount is the settlement amount plus the reserve amount.

How to fix it: open the marketplace's reconciliation report in Report center, under Reconciliation reports: the Amazon Reconciliation Report or the TikTok Shop Reconciliation Report. Each one shows how the marketplace's numbers break down in your books, line by line.


Related articles


Need help?

If a payout still doesn't add up, send us the processor, the payout date and amount, and the bank account it went to, and reach out to our Support team through chat or at [email protected].

Did this answer your question?