Integrating Sellercloud 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.
What data Does ConnectBooks Pull from Sellercloud?
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 Sellercloud provides. Sellercloud calculates an average cost per order, accounting for constant price fluctuations. This is the cost that ConnectBooks retrieves.
How to View the Cost of Your Items.
Once connected to Sellercloud, item costs will appear in the P&L reports in the cost column, if you want to see it per order, read below.
Resolving Orders with Missing Costs.
When ConnectBooks connects to Sellercloud, it requests a cost for every order, refund, and adjustment. Sometimes, Sellercloud 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:
Navigate to the Accounting Export page and select a store.
In the Settlement Export Status column, where it says “item missing cost,” click Resolve.
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 Sellercloud has updated information, click Sync with Sellercloud to update the data.
Viewing the Cost Per Order.
In the profit and loss reports, you can view the cost per item. To view the cost per order:
Navigate to the Accounting Export page and select a store.
Select the More button in the Settlement Export Status column.
Select Download COGS Excel.
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 Sellercloud.