{"id":27132,"date":"2026-04-16T13:11:43","date_gmt":"2026-04-16T13:11:43","guid":{"rendered":"https:\/\/synder.com\/help\/?p=27132"},"modified":"2026-04-16T13:22:47","modified_gmt":"2026-04-16T13:22:47","slug":"per-transaction-tiktok-clearing-account-reconciliation-guide","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/","title":{"rendered":"Per Transaction: TikTok Clearing Account Reconciliation Guide"},"content":{"rendered":"\n<p>Synder syncs sales, refunds, payouts, and fees from TikTok. Depending on your configuration, transactions are recorded in your accounting platform as individual entries or summarized journal entries.<\/p>\n\n\n\n<p>This guide explains how to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify the ending balance of your TikTok account<\/li>\n\n\n\n<li>Reconcile your clearing account<\/li>\n\n\n\n<li>Compare TikTok and accounting data to identify discrepancies<\/li>\n<\/ul>\n\n\n\n<p>QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Use this guide if:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You use TikTok with Synder<\/li>\n\n\n\n<li>Your clearing account does not reconcile or zero out automatically<\/li>\n\n\n\n<li>You want to verify that TikTok and accounting records match<\/li>\n<\/ul>\n\n\n\n<p>After completing the steps, your <strong>TikTok clearing account will reconcile with sales, <\/strong>payouts, and fees reflected accurately in your books.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>TikTok clearing account reconciliation flow<\/strong><\/h2>\n\n\n\n<p>To reconcile your TikTok clearing account, compare its ending balance with TikTok\u2019s ending balance for the same period.<br>Here\u2019s how you can find<strong> the TikTok balance<\/strong> by downloading the <strong>Settlement<\/strong> report:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to TikTok \u2192 Finances\u2192Overview<\/li>\n\n\n\n<li>Click on Statements.<\/li>\n\n\n\n<li>Click on Export.<\/li>\n\n\n\n<li>Select the required time period and click Export.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1024x471.png\" alt=\"\" class=\"wp-image-27144\" style=\"width:685px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1024x471.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-300x138.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-768x353.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1536x707.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1080x497.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-60x28.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-150x69.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34.png 1712w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Open the Excel file and calculate the sum of the <strong>Total settlement amount<\/strong> column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"587\" height=\"865\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-24.png\" alt=\"\" class=\"wp-image-27134\" style=\"width:399px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-24.png 587w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-24-204x300.png 204w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-24-41x60.png 41w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-24-102x150.png 102w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/figure>\n\n\n\n<p>The result is the <strong>TikTok ending balance<\/strong> for the reconciliation period.<br><br>Next, compare this amount with the ending balance from your clearing account report in QuickBooks Online for the same date:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to <strong>Reports \u2192 Standard Reports<\/strong>.<\/li>\n\n\n\n<li>Select <strong>Balance Sheet<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"771\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33.png\" alt=\"\" class=\"wp-image-27143\" style=\"width:503px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33-300x226.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33-768x578.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33-60x45.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-33-150x113.png 150w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Select column display to <strong>Months.<\/strong><\/li>\n\n\n\n<li>Locate the TikTok clearing account for the reconciled month.<\/li>\n\n\n\n<li>Subtract the previous month\u2019s balance.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"587\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32.png\" alt=\"\" class=\"wp-image-27141\" style=\"width:577px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32-300x172.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32-768x440.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32-60x34.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-32-150x86.png 150w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The result is the clearing account balance for the selected period.<\/p>\n\n\n\n<p>The amounts you will see in the QuickBooks Online clearing report will match your TikTok Settlement report transactions report amount, meaning the reconciliation was successful. Congratulations!<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>If your clearing account does not reconcile<\/strong><\/h2>\n\n\n\n<p>If the balances between your TikTok and Quickbooks report don\u2019t match, it\u2019s often caused by unsynchronized transactions. Follow the steps below to make sure that Synder has successfully synced your TikTok data.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to Synder and filter transactions by status. Make sure that all the transactions within your reconciliation period are in statuses: <strong>Synced<\/strong> or <strong>Skipped <\/strong>on the Platform transactions page.<br>All the other statuses indicate that the transaction is not in your books or needs additional checking. As long as such transactions are present, your books won\u2019t reconcile.<\/li>\n\n\n\n<li>Make sure you are comparing the right numbers (sales might not equal cash, for example). It\u2019s important to use the right numbers for reconciliation and comparison.<\/li>\n\n\n\n<li>If your platform was disconnected within the reconciliation period, make sure you run a <strong>Historical Import<\/strong> on the Platform transactions page to retrieve any missing transactions.<\/li>\n<\/ol>\n\n\n\n<p>If after that your balances still don\u2019t match, follow the steps below to identify discrepancies by comparing TikTok and QuickBooks Online data in Excel.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Download required reports<\/strong><\/h3>\n\n\n\n<p>You should already have a report from TikTok if you\u2019ve followed the main reconciliation flow. If not, please download it by following the steps above.<\/p>\n\n\n\n<p>We will also need a report of the TikTok clearing account from your accounting software.<\/p>\n\n\n\n<p><a href=\"https:\/\/synder.com\/help\/how-to-download-the-clearing-account-report-from-quickbooks-online\/\"><em>Follow this link<\/em><\/a><em> to find the exact steps on how to generate a clearing account report in QuickBooks Online<\/em><\/p>\n\n\n\n<p><strong><em>Note<\/em><\/strong><strong>:<\/strong> If your QuickBooks clearing account has tens of thousands of transactions, it might not download the full dataset. After downloading one of the reports above, check for data completeness. If the report is missing data, try the alternative download method.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Prepare your Excel data for comparison<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How to prepare your TikTok report<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"492\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-1024x492.png\" alt=\"\" class=\"wp-image-27137\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-1024x492.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-300x144.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-768x369.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-1536x737.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-1080x519.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-60x29.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29-150x72.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-29.png 1660w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>TikTok report includes a lot of transaction details that you don\u2019t need for comparison.<br>Copy values of <strong>Order\/Adjusment ID <\/strong>and <strong>Total settlement amount <\/strong>columns into a new sheet. This will be our TikTok <strong>clean <\/strong>report.<\/p>\n\n\n\n<p>Here\u2019s an example of how it should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"1024\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-800x1024.png\" alt=\"\" class=\"wp-image-27139\" style=\"width:548px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-800x1024.png 800w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-234x300.png 234w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-768x983.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-47x60.png 47w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28-117x150.png 117w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-28.png 875w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How to prepare your QuickBooks Online report<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"731\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-1024x731.png\" alt=\"\" class=\"wp-image-27142\" style=\"width:653px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-1024x731.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-300x214.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-768x548.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-1080x771.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-60x43.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31-150x107.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-31.png 1096w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>QuickBooks reports include unnecessary details. To create a clean comparison sheet, filter the <strong>Transaction Type<\/strong> column for &#8220;<strong>Transfer<\/strong>,&#8221; then copy the values from the <strong>Num <\/strong>and <strong>Amount <\/strong>columns into a new sheet.<\/p>\n\n\n\n<p>Here\u2019s an example of how it should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"758\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-23.png\" alt=\"\" class=\"wp-image-27133\" style=\"width:253px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-23.png 317w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-23-125x300.png 125w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-23-25x60.png 25w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-23-63x150.png 63w\" sizes=\"(max-width: 317px) 100vw, 317px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Consolidate multiple lines into one entry per transaction<\/strong><\/h3>\n\n\n\n<p>TikTok transactions may appear as multiple line items in QuickBooks Online (e.g., one per product or fee). For accurate reconciliation, you need to consolidate these into a single row per transaction, showing the total amount. Use Excel\u2019s Consolidate function:&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on an empty cell in an empty row.<\/li>\n\n\n\n<li>Go to <strong>Data<\/strong> \u2192 <strong>Consolidate.<\/strong><\/li>\n\n\n\n<li>In the reference box, select <strong>both<\/strong> columns<strong> A<\/strong> and <strong>B<\/strong> (your ID and amount columns).<\/li>\n\n\n\n<li>Click the<strong> + (plus sign)<\/strong> to add this reference.<\/li>\n\n\n\n<li>In the <strong>Use<\/strong> labels in the section, check <strong>BOTH<\/strong> boxes:\n<ol class=\"wp-block-list\">\n<li>\u2611\ufe0f Top row (uses column headers);<\/li>\n\n\n\n<li>\u2611\ufe0f Left column (uses IDs as grouping criteria)<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Click <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"695\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-1024x695.png\" alt=\"\" class=\"wp-image-27138\" style=\"width:644px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-1024x695.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-300x204.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-768x521.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-1080x733.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-60x41.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27-150x102.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-27.png 1256w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As a result, Excel will group multiple transactions with the same ID into one and sum their amounts.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Organize your data<\/strong><\/h3>\n\n\n\n<p><strong>1. Create separate worksheets for:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TikTok original report data<\/li>\n\n\n\n<li>QuickBooks Online report data\u00a0<\/li>\n\n\n\n<li>Comparison Analysis (your working sheet)<\/li>\n<\/ul>\n\n\n\n<p><strong>2. In your Comparison Analysis sheet, create columns for:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TikTok Order ID<\/li>\n\n\n\n<li>TikTok Total Settlement Amount<\/li>\n\n\n\n<li>QuickBooks Num<\/li>\n\n\n\n<li>QuickBooks Amount\u00a0<\/li>\n\n\n\n<li>Lookup<\/li>\n\n\n\n<li>Difference<\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how the end result should look:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"628\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26.png\" alt=\"\" class=\"wp-image-27136\" style=\"width:669px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26.png 946w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26-300x199.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26-768x510.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26-60x40.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-26-150x100.png 150w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Compare data using VLOOKUP<\/strong><\/h3>\n\n\n\n<p>Our objective is to match transaction amounts from TikTok and QuickBooks Online that have shared IDs. This process helps us identify any discrepancies in amounts or missing transactions within QuickBooks Online.<\/p>\n\n\n\n<p><strong>1. Set up your comparison formula<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Copy your cleaned TikTok IDs and amounts to columns A and B.<\/li>\n\n\n\n<li>In the <strong>Lookup<\/strong> column, use <strong>VLOOKUP<\/strong> to find matching QuickBooks Online amounts:<\/li>\n<\/ol>\n\n\n\n<p>=VLOOKUP(A2,C:D,2,FALSE)<\/p>\n\n\n\n<p><em>Where:<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A2 = TikTok ID you\u2019re looking up<\/li>\n\n\n\n<li>C:D = Your QuickBooks Online data range (ID in column C, amount in column D)<\/li>\n\n\n\n<li>2 = Returns the amount from the 2nd column (QuickBooks Online amount)<\/li>\n\n\n\n<li>FALSE = Exact match only<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-1024x535.png\" alt=\"\" class=\"wp-image-27140\" style=\"width:725px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-1024x535.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-300x157.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-768x401.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-1080x564.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-60x31.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30-150x78.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-30.png 1222w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the <strong>Difference<\/strong> column, calculate the difference by subtracting the looked-up amount from the TikTok amount.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"559\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25.png\" alt=\"\" class=\"wp-image-27135\" style=\"width:738px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25.png 936w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25-300x179.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25-768x459.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25-60x36.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-25-150x90.png 150w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<p><strong>2.<\/strong> <strong>Identify discrepancies<\/strong><\/p>\n\n\n\n<p>Perfect matches should show 0 in the difference column.<\/p>\n\n\n\n<p>Common discrepancy indicators include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Negative number<\/strong> = QuickBooks Online amount is higher than the TikTok amount.<\/li>\n\n\n\n<li><strong>Positive number<\/strong> = TikTok amount is higher than the QuickBooks Online amount.\u00a0<\/li>\n\n\n\n<li><strong>N\/A<\/strong> = Transaction ID exists in TikTok but not in QuickBooks Online.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Address common discrepancies<\/strong><\/h3>\n\n\n\n<p><strong>1. Missing transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transaction failed to sync due to network issues<\/li>\n\n\n\n<li>Transaction filtered out by Synder settings<\/li>\n\n\n\n<li><a href=\"https:\/\/synder.com\/help\/transaction-types-supported-from-synder\/\">Unsupported transaction type<\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check Synder\u2019s sync logs for failed transactions.<\/li>\n\n\n\n<li>Force a manual sync in Synder for the missing period.<\/li>\n\n\n\n<li>Confirm timezone settings match between TikTok reports (PST\/UTC) and Synder.<\/li>\n<\/ol>\n\n\n\n<p><strong>2. Amount differences<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Currency conversion differences between marketplaces<\/li>\n\n\n\n<li>Partial refunds not properly matched to original orders<\/li>\n\n\n\n<li>Difference in fee calculations between TikTok reports and Synder processing<\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check for currency conversions if selling in multiple countries.<\/li>\n\n\n\n<li>Look for reserve balance movements in the same period.<\/li>\n\n\n\n<li>Check for related adjustment entries in subsequent periods.<\/li>\n<\/ol>\n\n\n\n<p><strong>3. Extra transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manual entries created by your accounting team<\/li>\n\n\n\n<li>Duplicate syncing from multiple sync attempts<\/li>\n\n\n\n<li>Journal entries or adjustments made outside of Synder<\/li>\n\n\n\n<li>Starting balance entries when first setting up clearing accounts<\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check if descriptions indicate manual entry.<\/li>\n\n\n\n<li>Verify transaction source in QuickBooks Online (look for \u201cSynder\u201d in descriptions).<\/li>\n\n\n\n<li>Check for duplicate TikTok connections in Synder.<\/li>\n\n\n\n<li>Review any manual clearing of account adjustments.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>When to reach out&nbsp; to support<\/strong><\/h2>\n\n\n\n<p>Get in touch with support when you\u2019ve identified specific transactions causing issues but can\u2019t resolve them.<\/p>\n\n\n\n<p><strong>What to include in your support request:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reconciliation period (start and end dates)<\/li>\n\n\n\n<li>Specific transaction IDs<\/li>\n\n\n\n<li>Screenshots of problematic transactions in both TikTok and QuickBooks Online<\/li>\n\n\n\n<li>Summary of your findings (e.g., \u201cFound 5 missing fulfillment fees totaling $47.50\u201d)<\/li>\n\n\n\n<li>Currency\/marketplace information if applicable<\/li>\n\n\n\n<li>Steps already taken to resolve the issue<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Best practices for ongoing reconciliation<\/strong><\/h2>\n\n\n\n<p>Staying on top of your clearing accounts requires consistency. Here are key practices to help you keep your books accurate and your reconciliation process smooth over time:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Reconcile monthly rather than waiting for quarter-end.<\/li>\n\n\n\n<li>Monitor multiple currency clearing accounts if selling internationally.<\/li>\n\n\n\n<li>Keep an eye on alerts in Synder for failed sync transactions.<\/li>\n\n\n\n<li>Maintain timezone consistency across TikTok, Synder, and reconciliation periods.<\/li>\n\n\n\n<li>Document any manual entries made to clearing accounts.<\/li>\n\n\n\n<li>Review unsupported transaction types periodically as Synder adds support.<\/li>\n<\/ol>\n\n\n\n<p>A consistent reconciliation routine saves time, reduces errors, and keeps your financials audit-ready. By following these best practices, you\u2019ll avoid surprises down the line and ensure your clearing accounts stay clean and reliable month after month.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Synder syncs sales, refunds, payouts, and fees from TikTok. Depending on your configuration, transactions are recorded in your accounting platform as individual entries or summarized journal entries. This guide explains how to: QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations. Use this guide if: After completing [&hellip;]<\/p>\n","protected":false},"author":2316,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"categories":[383,1,56,404,398],"tags":[],"ppma_author":[349],"class_list":["post-27132","post","type-post","status-publish","format-standard","hentry","category-reconcile-in-per-transaction-mode","category-video-tutorials","category-reconciliation","category-tiktok-shop-ecommerce-integration","category-ecommerce-integrations-main"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Per Transaction: TikTok Clearing Account Reconciliation Guide - Synder<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Per Transaction: TikTok Clearing Account Reconciliation Guide - Synder\" \/>\n<meta property=\"og:description\" content=\"Synder syncs sales, refunds, payouts, and fees from TikTok. Depending on your configuration, transactions are recorded in your accounting platform as individual entries or summarized journal entries. This guide explains how to: QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations. Use this guide if: After completing [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-16T13:11:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-16T13:22:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1024x471.png\" \/>\n<meta name=\"author\" content=\"vili.varazi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"vili.varazi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Per Transaction: TikTok Clearing Account Reconciliation Guide - Synder","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/","og_locale":"en_US","og_type":"article","og_title":"Per Transaction: TikTok Clearing Account Reconciliation Guide - Synder","og_description":"Synder syncs sales, refunds, payouts, and fees from TikTok. Depending on your configuration, transactions are recorded in your accounting platform as individual entries or summarized journal entries. This guide explains how to: QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations. Use this guide if: After completing [&hellip;]","og_url":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/","og_site_name":"Synder","article_published_time":"2026-04-16T13:11:43+00:00","article_modified_time":"2026-04-16T13:22:47+00:00","og_image":[{"url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1024x471.png"}],"author":"vili.varazi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"vili.varazi","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/","url":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/","name":"Per Transaction: TikTok Clearing Account Reconciliation Guide - Synder","isPartOf":{"@id":"https:\/\/synder.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34-1024x471.png","datePublished":"2026-04-16T13:11:43+00:00","dateModified":"2026-04-16T13:22:47+00:00","author":{"@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad"},"breadcrumb":{"@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/#primaryimage","url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34.png","contentUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/04\/image-34.png","width":1712,"height":788},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/help\/per-transaction-tiktok-clearing-account-reconciliation-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/synder.com\/help\/"},{"@type":"ListItem","position":2,"name":"Per Transaction: TikTok Clearing Account Reconciliation Guide"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/help\/#website","url":"https:\/\/synder.com\/help\/","name":"Synder","description":"Articles &amp; FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad","name":"Vili Varazi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/image\/cae83c3feb798615e936e036a7c725e0","url":"https:\/\/secure.gravatar.com\/avatar\/9af36cc631e0d1da5c7105bf5ef14141?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9af36cc631e0d1da5c7105bf5ef14141?s=96&d=mm&r=g","caption":"Vili Varazi"},"url":"https:\/\/synder.com\/help\/author\/vili-varazi\/"}]}},"author_meta":{"display_name":"vili.varazi","author_link":"https:\/\/synder.com\/help\/author\/vili-varazi\/"},"featured_img":null,"coauthors":[{"link":"https:\/\/synder.com\/help\/author\/vili-varazi\/","display_name":"vili.varazi"}],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/synder.com\/help\/category\/reconciliation\/reconcile-in-per-transaction-mode\/\" class=\"advgb-post-tax-term\">Reconcile in Per Transaction Mode<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/video-tutorials\/\" class=\"advgb-post-tax-term\">Video Tutorials<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/reconciliation\/\" class=\"advgb-post-tax-term\">Reconciliation<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/ecommerce-integrations-main\/tiktok-shop-ecommerce-integration\/\" class=\"advgb-post-tax-term\">TikTok Shop<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/ecommerce-integrations-main\/\" class=\"advgb-post-tax-term\">E-Commerce Integrations<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Reconcile in Per Transaction Mode<\/span>","<span class=\"advgb-post-tax-term\">Video Tutorials<\/span>","<span class=\"advgb-post-tax-term\">Reconciliation<\/span>","<span class=\"advgb-post-tax-term\">TikTok Shop<\/span>","<span class=\"advgb-post-tax-term\">E-Commerce Integrations<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 21 hours ago","modified":"Updated 21 hours ago"},"absolute_dates":{"created":"Posted on April 16, 2026","modified":"Updated on April 16, 2026"},"absolute_dates_time":{"created":"Posted on April 16, 2026 1:11 pm","modified":"Updated on April 16, 2026 1:22 pm"},"featured_img_caption":"","series_order":"","authors":[{"term_id":349,"user_id":2316,"is_guest":0,"slug":"vili-varazi","display_name":"vili.varazi","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/9af36cc631e0d1da5c7105bf5ef14141?s=96&d=mm&r=g","author_category":"","first_name":"Vili","last_name":"Varazi","user_url":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/27132"}],"collection":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/users\/2316"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/comments?post=27132"}],"version-history":[{"count":2,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/27132\/revisions"}],"predecessor-version":[{"id":27146,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/27132\/revisions\/27146"}],"wp:attachment":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/media?parent=27132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/categories?post=27132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/tags?post=27132"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/ppma_author?post=27132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}