Convert a Faire payout report to QuickBooks or Xero

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

Why Faire settlements resist clean bookkeeping

A Faire payout export is an order ledger, not a settlement summary. Each row is one wholesale order: gross merchandise value, Faire's commission (which differs between a retailer's first order and their reorders), and a payment processing fee. Nothing in the file tells you which orders funded which bank deposit, and commission is expressed per order while your bank sees one lump every payout cycle. Bookkeepers typically resort to pivot tables and a calculator, which works until a payout contains a partial retailer return and the column totals stop meaning anything.

How the Faire file maps to your books

Multi-year catch-up on Faire

Faire lets you export order history going back years, so a multi-year catch-up is a per-file exercise: each month's or year's export converts independently under the same footing rules. Because no dedicated Faire conversion tool exists, most sellers coming to this have never had these books reconcile - expect the first conversion to surface commission lines that were previously booked as sales.

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.

Does this handle Faire's commission tiers?

Yes - opening-order and reorder commission rates are read per row from your export, so each order's fee equals what Faire actually charged.

What about Faire's net-terms orders?

Payout grouping follows the payout id and payout date columns in the export, so terms orders land in the settlement they were actually paid in, not the order date.

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

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