The SyncTools Journal
Reconciliation, month-end close, and automation playbooks from the team building SyncTools. Written for accountants, controllers, and the merchants they serve, no fluff, no throat-clearing.
Latest
Dynamics 365 Business Central has a built-in Power BI connector, but it uses OData feeds that query live data at refresh time, Microsoft API throttling at 5–7 requests/second, and requires AL extensions for custom data. This guide covers the reliable alternative: syncing Business Central data to a SQL database with SyncTools.
Read the full article →11 more articles
MYOB has no native Power BI connector. The closest option — OdataLink — is expensive, queries live data at every refresh, and requires an on-premises gateway for Power BI Service. This guide covers the reliable alternative: syncing MYOB data to a SQL database with SyncTools.
Microsoft retired the native Power Query QuickBooks Online connector in August 2025 — scheduled refreshes stopped and authentication broke. This guide covers the reliable replacement: syncing QuickBooks data to a SQL database with SyncTools and connecting Power BI via its native SQL connector.
There is no native Sage Power BI connector. The available paths — ODBC for Sage 50/200 or the Sage Business Cloud REST API — require significant setup, hit rate limits, and don't work well with Power BI Service scheduled refresh. This guide covers the reliable alternative: syncing Sage data to a SQL database with SyncTools.
TikTok Shop deposits one net payout that bundles gross sales, referral fees, affiliate commissions, TikTok Ads charges, and refunds — none of which appear correctly in Sage unless you map them from the settlement report. This guide covers the correct Sage nominal structure, step-by-step SyncTools connection, MTD VAT handling for UK sellers, and how to reconcile TikTok Shop payouts in Sage without manual data entry.
Xero has a native Power BI connector, but it rate-limits refreshes, omits line-item detail, and breaks on large accounts. This guide covers the reliable alternative: syncing Xero data to a SQL database with SyncTools and connecting Power BI via its native SQL connector.
There is no native Zoho Books Power BI connector. The closest alternative — Zoho Analytics — is a separate paid product that siloes your accounting data from non-Zoho sources. This guide covers the reliable alternative: syncing Zoho Books data to a SQL database with SyncTools and connecting Power BI via its native SQL connector.
NetSuite's native Power BI path — SuiteAnalytics Connect — requires a separate paid license, still queries live data at refresh time, and needs an on-premises gateway for Power BI Service. This guide covers the reliable alternative: syncing NetSuite to a SQL database with SyncTools and connecting Power BI via its native SQL connector.
Linnworks aggregates orders from Amazon, eBay, Shopify, and every other channel — but each channel settles on a different schedule with a different fee structure, and none of them reconcile cleanly in Xero without the right account structure. This guide covers the correct Xero setup for Linnworks sellers, step-by-step SyncTools connection, and how to reconcile every channel payout automatically in Xero.
Walmart Marketplace pays sellers a net biweekly payout that bundles gross sales, referral fees, WFS fulfillment charges, and refunds into one ACH deposit. Recording that deposit as income in Xero gives you wrong books. This guide covers the correct Xero account structure, step-by-step SyncTools connection, and how to reconcile every Walmart payout automatically in Xero.
Walmart Marketplace pays sellers biweekly — one net deposit that bundles gross sales, referral fees, WFS fulfillment charges, and refunds. Recording that number as income gives you wrong books. This guide covers the correct QuickBooks chart of accounts, the step-by-step SyncTools connection, and how to reconcile every Walmart payout automatically.
Etsy is not accounting software. This guide explains what Etsy Payments actually covers, where the bookkeeping gap is, and how to connect Etsy to QuickBooks or Xero so your books stay accurate without manual exports.
