Unapplied cash payment income shows up in QuickBooks when an Amazon deposit was recorded as a payment but never matched to an invoice or sales form — which is exactly what happens when a raw settlement deposit gets entered straight from the bank feed.
Convert your amazon file - done-for-you from $149
QuickBooks creates the Unapplied Cash Payment Income account automatically whenever a payment is entered without a connected invoice, or when the payment is dated before the invoice it belongs to. Amazon settlement deposits are batched, unlabeled bank transfers — nothing about them looks like a customer invoice to QuickBooks, so a bank-feed match alone leaves the amount unapplied.
Unapplied cash payment income sits on your P&L as if it were real revenue, but it's disconnected from any sales form. Left unresolved across multiple settlement periods, it overstates income and makes month-over-month P&L comparisons unreliable.
The account clears when the deposit is matched to a proper sales form — not just categorized as income, but recorded as gross revenue against a corresponding Amazon fees and refunds breakdown, entered as of the settlement period it belongs to.
FootingKit converts your Amazon settlement report into a QuickBooks-ready journal entry that's already structured as a proper sales entry — gross revenue, referral fees, FBA fees, and refunds each on their own line, dated to the settlement period — so nothing lands in Unapplied Cash Payment Income in the first place. Every payout is verified to net exactly to its bank deposit, or the conversion is flagged and re-run — free.
Yes. FootingKit's catch-up service re-processes historical Amazon settlements — up to 36 months back — and replaces raw bank-feed entries with properly structured journal entries, clearing the unapplied balance from your P&L.
Convert your amazon file - done-for-you from $149
Get your settlement reconciled - done-for-you from $149
FootingKit converts marketplace settlement reports into QuickBooks- and Xero-ready books, footed to the penny.