What should finance check after Shopify orders sync to Odoo?

Finance should check Shopify order references, payment status, tax mappings, discounts, refunds, shipping and duty service lines, payment journal mapping, failed jobs, and a payout sample against Odoo records.

Should all Shopify orders become posted invoices in Odoo?

Not always. Some teams want draft sale orders, confirmed sale orders, sale receipts, draft invoices, or posted accounting entries. The correct record type depends on the accounting close process.

How should Shopify refunds be checked in Odoo?

Check that partial and full refunds remain tied to the original Shopify order, reverse the correct line quantities and taxes, and do not create duplicate credit records after retries.

What is the most useful reconciliation key?

The Shopify order reference is the most useful daily reconciliation key because finance can search the same order number in Shopify payout reports and Odoo records.

Shopify Odoo Month-End Close Checklist

Month-end is where connector quality becomes visible

A Shopify order can appear in Odoo and still fail finance. The record might be in the wrong Odoo company. The tax might be mapped to the wrong record. A refund might not reverse the original line. Shipping, duties, tips, or import fees might be missing. Payment status might not match the Shopify payout. A failed job might be waiting in the queue while the team closes the books.

That is why month-end close needs its own Shopify Odoo checklist. Daily operations care that orders, inventory, and fulfillment move. Finance cares that the Odoo records can explain Shopify sales, payments, taxes, refunds, and service lines without a spreadsheet.

This guide assumes a Shopify store is using Odoo Accounting or Odoo sales records as part of its finance workflow. It supports the Shopify Odoo accounting sync, Shopify Odoo order reconciliation, and Shopify accounting software with Odoo pages.

Start with the Odoo record type

Before checking totals, finance should confirm what type of Odoo record Shopify orders create. If this decision is unclear, reconciliation becomes confusing because different teams may expect different accounting states.

Common record-type patterns:

Draft sale order for operational review before confirmation.
Confirmed sale order when the warehouse should act immediately.
Sale receipt for paid ecommerce orders.
Draft invoice for finance approval.
Posted invoice or accounting entry for flows that close directly in Odoo.

There is no universal best record type. A low-risk DTC store with paid orders may prefer sale receipts or confirmed sale orders. A B2B store with payment terms may prefer draft sale orders or draft invoices. A finance team that wants review before posting should not allow every Shopify order to become a posted invoice automatically.

The close checklist should record the chosen type. Then every order sample should be judged against that choice. If the Odoo record type is wrong, fix that before investigating smaller mismatches.

Check Shopify order references first

The Shopify order reference is the reconciliation anchor. Finance should be able to take a Shopify order number from a payout report and find the Odoo record without guessing.

At close, sample a group of Shopify orders and verify:

Shopify order number is present on the Odoo record.
Odoo record links back to the correct Shopify order, not only the customer.
Refund records reference the original Shopify order.
Retried jobs did not create duplicate Odoo records with the same Shopify reference.
Historical imports and live sync did not overlap into duplicates.

If this basic reference is missing, reconciliation slows down immediately. Finance may have to search by customer, amount, date, product, or payment method. Those fields can all be ambiguous. The Shopify order reference should not be ambiguous.

Use Shopify Odoo order reference mapping and historical order import guide for the related setup details.

Compare a payout sample, not every order first

Do not begin close by trying to audit every order. Start with a controlled payout sample that includes normal and difficult cases. A good sample catches the connector behavior that usually creates cleanup.

Include these orders:

One normal paid order.
One discounted order.
One order with sales tax, VAT, or GST.
One order with shipping charges.
One order with tips, duties, import fees, or additional fees if the store uses them.
One partial refund.
One full refund.
One pending or unpaid order if the store allows them.
One order edited after purchase.

For each order, compare Shopify to Odoo:

Gross amount.
Discounts.
Tax amount and mapped tax record.
Shipping or service lines.
Payment status.
Refund amount.
Shopify order reference.
Odoo company.

This sample tells finance whether the connector is aligned. If the sample is clean, move to broader totals. If the sample is not clean, fix the underlying mapping before spending hours reconciling symptoms.

Validate tax mapping by Odoo company and version

Tax mapping is one of the highest-risk close items. Shopify calculates tax at checkout. Odoo needs to record tax against configured tax records. The connector has to map the Shopify tax line to the Odoo tax record for the correct company and Odoo version.

Check these tax items:

Every Shopify tax line in the sample maps to a real Odoo tax record.
The tax record belongs to the selected Odoo company.
Tax-inclusive and tax-exclusive pricing behave as expected.
Discounts do not change the tax base incorrectly.
Refunds reverse the same tax records as the original order.
Odoo v16, v17, v18, or v19 write behavior matches the running Odoo version.

If the connector falls back to a default tax silently, finance may not see the issue until filing. A failed tax job is better than an invisible wrong tax. The close checklist should therefore include a review of failed tax jobs before totals are trusted.

Helpful pages: Shopify Odoo tax mapping, Shopify tax sync with Odoo, tax ID vs tax IDs guide, and fiscal positions guide.

Check discounts, shipping, duties, tips, and additional fees

Non-product amounts are common sources of small mismatches. They may look minor per order, but they compound across a month.

Finance should check:

Line-level discounts.
Order-level discounts.
Shipping charges.
Duties and import fees.
Tips.
Other additional fees.
Whether service products are configured with the right accounts.

The connector should not hide these values inside a note if finance needs them in totals. Depending on the Odoo workflow, they may become service lines, discount percentages, mapped products, or accounting-specific lines.

Check one order with each non-product amount. Confirm the Odoo record explains the Shopify total. If a service line exists, verify the account configuration in Odoo. A connector can create the line correctly while Odoo accounting still needs the right account on the service product.

Verify refund behavior before closing

Refunds should stay tied to the original order. A refund that becomes an isolated record may be hard to reconcile later. A retry that creates a duplicate refund can make totals wrong.

Check these refund cases:

Partial line refund.
Full order refund.
Refund with tax.
Refund after fulfillment.
Refund retried from a failed job.

For each case, verify:

The original Shopify order reference remains visible.
The refunded quantity or amount matches Shopify.
The tax reversal matches the original tax mapping.
The refund does not duplicate after retry.
Stock behavior matches the return or refund policy.

For implementation details, use Shopify Odoo refund sync, partial refund sync guide, and return restock to Odoo inventory.

Review payment status and journal mapping

Payment status affects close because not every Shopify order should necessarily be treated the same way in Odoo. Some stores sync only paid orders. Others sync all orders and let finance handle payment state later.

Check these payment items:

Paid, pending, partially paid, and refunded states are represented as expected.
Payment method is visible if finance uses it for reconciliation.
Payment methods map to the intended Odoo journals or accounts.
Manual payment methods and third-party gateways are not collapsed into one unclear value.
Shopify payout timing is understood separately from order creation timing.

The payment method does not have to solve payout reconciliation by itself, but it should give finance enough context to explain why an order sits in a given state.

Check failed jobs before trusting totals

A month-end close should include a queue review. If several order, refund, tax, or payment jobs are failed, the Odoo totals may be incomplete.

Review failed jobs by workflow:

Order sync.
Refund sync.
Product matching.
Inventory or stock.
Fulfillment.
Customer sync.
Tax or accounting mapping.

For finance, the key question is whether any failed job affects financial totals. An image sync failure may not affect close. A failed refund, tax mapping, payment mapping, or order job does.

The failed job should include the Shopify reference and Odoo error context. If the team cannot determine whether a failed job affects close, the connector is not giving enough operational visibility.

Use Shopify Odoo sync errors, retry failed jobs, and queue dashboard guide.

Inventory valuation and stock movement checks

If Odoo inventory valuation is part of close, finance should coordinate with operations. Shopify order sync can create sales records, but warehouse stock movement and valuation depend on how Odoo is configured.

Check:

Shopify orders reduce Odoo stock through the intended workflow.
Fulfilled orders have corresponding delivery or stock movement context.
Returns and restocks are represented correctly.
Multi-warehouse stock moves belong to the right Odoo warehouse.
Product cost and valuation rules are configured in Odoo, not assumed by the connector.

The connector moves the ecommerce event into Odoo. Odoo's accounting and inventory setup still decides how valuation behaves. Do not treat the connector as a replacement for Odoo accounting configuration.

Useful operational pages: Shopify Odoo inventory sync, warehouse management with Odoo, and return restock guide.

The close checklist

Use this list each month until the team is confident:

Confirm the selected Odoo record type still matches the finance process.
Compare a Shopify payout sample to Odoo records.
Search Odoo by Shopify order reference.
Review tax mapping by company and region.
Verify discounts, shipping, duties, tips, and import fees.
Check partial and full refunds.
Review payment status and method mapping.
Check failed financial jobs before totals are trusted.
Confirm historical import did not overlap with live sync.
Review inventory valuation impact if Odoo inventory valuation is used.
Document any manual corrections and decide whether a mapping should change.

The last item matters most. A close checklist should shrink over time. If the same manual correction appears every month, it should become a connector setting, Odoo configuration change, or process rule.

Where Synco fits

Synco Connector is built so finance has visible Shopify references, configurable Odoo record types, version-aware tax handling, refund behavior, payment context, and failed-job visibility. The value is not only that Shopify orders reach Odoo. The value is that finance can explain those records later.

For a new implementation, pair this close checklist with the Shopify Odoo go-live checklist. Go-live proves operational flow. Month-end proves trust.