Integrating Finale Inventory with ConnectBooks ensures seamless and accurate tracking of your costs of goods sold (COGS). Here’s a detailed guide on how this integration works and how to maximize its benefits.
​

Since ConnectBooks connects directly with your marketplace, it pulls all transaction data from the marketplace. The only missing piece is the cost of goods, which Finale Inventory provides. Finale Inventory calculates an average cost per order, accounting for constant price fluctuations. This is the cost that ConnectBooks retrieves.
​

Once connected to Finale Inventory, item costs will appear in the P&L reports in the cost column, if you want to see it per order, read below.

When ConnectBooks connects to Finale Inventory, it requests a cost for every order, refund, and adjustment. Sometimes, Finale Inventory might not have the cost for a transaction due to various reasons, such as a bill not being entered or received after the order has shipped, which will show the cost as 0.
​

As an accounting software, ConnectBooks reconciles every transaction to determine its cost. If a cost is missing for a transaction, ConnectBooks will display the SKU and order ID to highlight this issue. Additionally, an indicator will appear next to the cost field in reports for transactions with missing costs.
​

To resolve missing costs:

Here, you'll see all orders missing a cost. Sometimes, a prefilled cost representing the current average cost for the product will be shown. If this cost is acceptable, click Save. Otherwise, input the correct cost.

If you know that Finale Inventory has updated information, click Sync with Finale Inventory to update the data.

In the profit and loss reports, you can view the cost per item. To view the cost per order:

This report can be downloaded per settlement.
​

By following these steps, you can ensure accurate and seamless tracking of your costs of goods with ConnectBooks and Finale Inventory.