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.
Purchase-based COGS: No action needed. We calculate your COGS from your inventory bills and payments. See How purchase-based cost of goods sold works in Finaloop.
Sales-based COGS: You'll need to manually enter the COGS either by sales channel or by SKU. See How sales-based COGS records product costs when you sell.
InventoryIQ: You'll need to manually enter the COGS by SKU. See InventoryIQ: Everything you need to know.
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)
Go to Inventory
Click COGS
Click Report per channel
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].
