If you ship items directly to customers, tracking shipping expenses per item is crucial for calculating accurate profit margins. With ConnectBooks' integration with Sellercloud, you can easily monitor and manage shipping costs for seller-fulfilled orders through detailed reports.
Viewing Shipping Fees Per Item
Once you integrate Sellercloud with ConnectBooks, the system will automatically check for shipping fees on each merchant-fulfilled order. These fees will be displayed in the Profit & Loss reports for accurate financial tracking. To view shipping fees:
Navigate to the Profit & Loss Report: Go to the report section and expand an item.
Check the "Other Fees" Column: Here, you will find the shipping fees associated with the item.
To view shipping fees as a separate column, use the "column chooser" in the reports to search for "Sellercloud Shipping" and add it as a column.
Viewing Shipping Fees Per Order
To see shipping fees for each order:
Go to the Accounting Export Page: Select a store.
Access the More Options: Click on the "More" button in the Settlement Export Status column.
Download Shipping Cost Excel: Select this option to get a detailed breakdown.
Select Download Shipping Cost Excel.
Avoiding Duplicate Shipping Fees
When purchasing Amazon shipping via Sellercloud, there's a possibility of fees being recorded twice – once from Amazon and once from Sellercloud. To prevent this, ConnectBooks ensures that each order only logs one shipping cost.
For example, if you use Amazon funds for Sellercloud shipping, both sources might report the fee. ConnectBooks will record it only once, prioritizing the Amazon source by default.
Note: Sellercloud shipping fees will not be imported into QuickBooks automatically. You will need to record these fees manually when reconciling your credit card charges.