Reconciling Faire Sales with Accounting Software Using Synder

• Step 1: Export reports for comparison
• Step 2: Prepare the data for comparison
• Step 3: Understand the dates provided by Faire
• Step 4: Reconciling Faire with Synder
• Step 5: Comparison & verification
• Important considerations

Efficiently managing and reconciling sales transactions from Faire is an important step to ensure your books stay accurate. Unlike most platforms, Faire pays out each order individually, which means you’ll see many small payouts instead of consolidated transfers. Since Faire’s API does not currently provide payout data, these payouts can’t be synced directly. This guide explains how to reconcile Faire transactions in your accounting software (QuickBooks Online, Xero, Oracle NetSuite, etc.) using Synder and Faire reports.

Step 1: Export reports for comparison

You’ll need reports from both Faire and your accounting software.

1. From Faire:
   • Go to Faire → Orders → Payouts → Export.
   • Select your desired time range.
   • Download the report (including order numbers and payout amounts).
     
2. From your accounting software:
   • Open the Faire Clearing Account, located in the chart of accounts and the balance sheet (this is where Synder posts sales/fees).
   • Filter for the same period as your Faire report.
   • Export the detailed account register.
     

Step 2: Prepare the data for comparison

When Synder syncs Faire sales and fee transactions, it adds a “bo_” prefix to the order ID in the payment/expense records. To align these IDs with the Faire report:

1. Open the accounting export in Excel.
2. Use Find & Replace to remove the “bo_” prefix.
3. Group any duplicate order IDs into a single line by total amount (Excel → Data → Consolidate).
   

Now you can compare totals by order ID between the Faire report and the accounting report.

• Faire report column: Payout Amount
• Accounting report column: Synced payment/expense totals after consolidation
  
  

Step 3: Understand the dates provided by Faire

Faire provides three dates per order:

1. Order date – When the order was placed (used by Synder to create invoices).
2. Payment date – When Faire receives payment from the customer.
3. Payout date – When Faire transfers funds to your bank account.
   

⚠️ The Faire Payout report only includes the order date and payout date. It does not include the payment date.

👉 In Synder, you can choose whether to record sales, payment, and fee transactions on the payment date or the payout date, depending on which works best for your reconciliation process. This flexibility makes it easier to align reports.

Step 4: Reconciling Faire with Synder

To keep your clearing account accurate and make reconciliation straightforward, here’s how syncing and reconciliation work in Synder:

1. Syncing in Synder
   • Invoices are created on the order date.
   • Payments and fees are posted to the Faire clearing account on either the payment date or payout date based on your chosen settings. We recommend using the payout date in Synder to simplify the reconciliation process.

⚠️ Important note on fees vs. payments
Before September 18, 2025, Synder synced fees on the order date while payments were synced on the payment date. As a result, older transactions may not reconcile properly due to mismatched dates.

• If you notice discrepancies for older data, we recommend rolling back and re-syncing the affected transactions so that both payments and fees align under the payment date.
  

2. Bank feed rules
   
   • Since payouts are not available via Faire’s API, you’ll need to handle them through your bank feed.
   • Set up a rule in your accounting software so that bank deposits from Faire clear against the Faire clearing account.
   • See our separate guide on creating bank feed rules for step-by-step instructions.
     
3. Result
   • Orders flow into the clearing account via Synder.
   • Payouts reduce the clearing account through your bank feed.
   • The clearing account balance stays close to zero, confirming that transactions and payouts are fully reconciled.
     

Step 5: Comparison & verification

• Use your prepared Excel comparison (Step 2) to ensure each Faire payout matches the corresponding accounting entry.
• Discrepancies typically arise from timing issues (e.g., partially processed transactions) or manual adjustments in Faire.
  

Important considerations

We’ve touched on these points before, but they’re critical for accurate reconciliation:

• Invoices are always synced on the order date.
• Payments & fees can be posted on either the payment date or payout date (selectable in Synder).
• Reports from Faire only contain the payout date, therefore comparing data between your books and Faire can be challenging. You will need reports from multiple date ranges from Faire to account for all transactions for the given month. We strongly recommend using the payout date in your Synder organization to make the comparison easier.
• No ending balance from Faire – reconciliation relies on comparing order IDs and payout totals, not on a running balance.
  

By following this workflow, you can reconcile Faire sales in your accounting software with confidence, even though Faire’s payout structure differs from other platforms.

For more information about Faire integrations or other Synder features, visit our Help Center or reach out to Synder Team via online support chat or email.