Convert a Walmart settlement report to QuickBooks or Xero

Including multi-year catch-up - with the footing check that proves the conversion is right.

Why Walmart settlements resist clean bookkeeping

Walmart's settlement report runs on the marketplace's own payment cycle rather than anything resembling your calendar, and its fee structure is category-based: referral fee percentages vary by department, WFS fulfillment fees arrive as separate rows from the sale they belong to, and adjustments (shipping credits, dispute outcomes) post days after the orders they touch. Sellers doing their own books usually discover the problem at month-end, when the deposit total matches nothing they can reconstruct from order reports.

How the Walmart file maps to your books

Multi-year catch-up on Walmart

Walmart settlement reports are downloadable per payment cycle for prior periods, so catching up means converting a stack of cycle reports in order. Watch for account reserve holds in older files - they post as transfers rather than fees, and older books often expensed them by mistake.

Importing into QuickBooks Online

1. In QBO, go to Banking → Upload transactions and choose the FootingKit QuickBooks CSV.
2. Select the 3-column layout (Date, Description, Amount) - the file is already in that layout.
3. Map each summarized line to your accounts: Sales to income, Platform fees to merchant fees expense, Refunds against income.
4. Match each payout's lines against the corresponding bank deposit. Because every payout foots to the cent, the match is exact - no plug entries.

QuickBooks bank feeds want one line per money movement against a deposit, so FootingKit summarizes each payout into category lines dated to the deposit date; order-level detail stays in the reconciliation report, out of your register.

Importing into Xero

1. In Xero, open the bank account, choose Import a statement, and upload the FootingKit Xero CSV.
2. The file uses Xero's statement layout (*Date, *Amount, Payee, Description, Reference) - no column mapping needed.
3. Create bank rules once for the Payee names and Xero codes recurring lines automatically from then on.
4. Reconcile each payout group against the real deposit; the Reference column carries the payout id so groups filter cleanly.

Xero statement imports work best when each payout arrives as a small set of coded lines, so FootingKit groups by payout and carries the payout id in the Reference field - bank rules handle the recurring coding from the second month on.

Do you support WFS sellers?

Yes - WFS fulfillment fees map to their own fee line so per-settlement margin reporting stays accurate.

Why is my deposit less than my sales minus fees?

Usually a reserve hold or a late-posting adjustment; both appear as distinct categories in the converted file so the gap explains itself.

Convert your Walmart file - done-for-you from $149

FootingKit converts marketplace settlement reports into QuickBooks- and Xero-ready books, footed to the penny.