Skip to main content

Syncing Faire Sales with Finaloop

Track your Faire sales and cost of goods sold (COGS) in Finaloop, whether Faire is connected to Shopify or not, so your P&L stays up-to-date with no double counting of sales.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, InventoryIQ

Finaloop tracks your Faire sales through your Shopify connection or your bank payouts, along with your inventory and cost of goods sold (COGS).

We'll explain how Finaloop syncs your Faire data in two common scenarios: 1. When Faire is connected to Shopify 2. When Faire is not connected to Shopify

Each setup works a bit differently, so we'll walk through how your sales and COGS are handled in both cases.

In Margins, Finaloop's performance analytics product, you can connect Faire as a store. If Faire orders come through Shopify, set how they're counted under Orders → Sales channels.

Your data is secure. Finaloop connects through each app's official integration and protects your data with bank-level encryption. It only uses the connection to sync the data your books and reports need.


1. Scenario 1: When Faire is connected to Shopify

Many brands connect Faire to Shopify using an app or direct integration. In this case, Finaloop syncs data from Shopify, and we offer granular control over which parts of Faire's data to include in your books.

How Faire syncs through Shopify

In your Finaloop settings, you choose whether we include sales, COGS, both, or neither for Faire orders synced through Shopify, with a status such as Included, Excluded, COGS only, Sales only or Giveaway. You'll find Faire's Applied status under Customers → Orders → Settings → Sales channels. For what each status does in general, see Choosing which Shopify sales count as revenue. Below is what each status means for Faire.


Changing the status of Faire

On the Sales channels tab, click the Faire row, click Add period, and choose the start date and the new Status. For the full steps, including closed periods, see Choosing which Shopify sales count as revenue.


Sales if set to "Included" or "Sales only"

  • You can view your orders on the Orders page.

  • Finaloop will sync Faire orders from Shopify on an order-by-order basis.

  • Sales will appear in your P&L as: "Sales - Faire (via Shopify)"

  • Shipping income and discounts will also be included.


Sales if set to "Excluded" or "COGS only"

  • We'll skip syncing Faire orders from Shopify.

  • Instead, we'll use bank payouts to recognize sales by categorizing the net Faire payouts into sales.

  • This ensures there is no overinflation or double counting of sales.


COGS if set to "Included" or "COGS only"

  • Finaloop syncs the sales quantity from Shopify to calculate the COGS.

  • We'll automatically calculate real-time COGS per order.

  • You can view your orders on the Orders page.

Works for both sales-based and InventoryIQ (Finaloop's inventory management product) COGS methods.


COGS if set to "Sales only" or "Excluded"

  • With sales-based COGS or InventoryIQ, you'll need to manually enter COGS. With purchase-based COGS, no action is needed.

  • You can manually enter COGS by sales channel (sales-based COGS only) or by SKU/product (both sales-based COGS and InventoryIQ (unit-based COGS)). See the steps under "Manually entering COGS for Faire".


2. Scenario 2: When Faire is not connected to Shopify

How Finaloop tracks Faire without Shopify

If you don't connect Faire to Shopify, Finaloop still tracks your Faire sales using your bank transactions.


Sales

If Faire is not connected to Shopify, we'll recognize your Faire sales based on the bank transactions on the Transactions page by categorizing the net Faire payouts into sales without the breakdown of the expenses, i.e. on a net basis.

The net impact on the P&L report is the same as recording the sales and expenses separately, so it is up-to-date and ready for taxes.


COGS

How your COGS are handled depends on your COGS setup. See How to choose your COGS tracking method in Finaloop.


3. Manually entering COGS for Faire

You can manually enter COGS by sales channel (sales-based COGS only) or by SKU/product (both sales-based COGS and InventoryIQ (unit-based COGS)).

To enter COGS by sales channel (sales-based only)

  1. Go to Inventory

  2. Click COGS

  3. Click Report per channel

  4. Enter the COGS for the Faire sales


To enter COGS by SKU/product (Sales-based or InventoryIQ)

Enter the COGS by SKU/product and Finaloop will calculate COGS automatically by multiplying the number of units sold x cost per unit. 1. Go to Inventory 2. Go to your Products page 3. Click the product sold on Faire 4. Inside the product page, click the COGS tab, then Add to COGS 5. Select Sales channel 6. Choose "Faire" from the dropdown 7. Click the edit icon to enter Units fulfilled and Units restocked

Alternatively, you can also bulk upload units sold on Faire: on the Products page, click Actions → Bulk unit edit.


Related articles


Need help?

Contact our team at [email protected].

Did this answer your question?