{"id":1011,"date":"2026-09-23T09:17:24","date_gmt":"2026-09-23T09:17:24","guid":{"rendered":"https:\/\/smppcenter.com\/kb\/?p=1011"},"modified":"2026-09-23T09:17:26","modified_gmt":"2026-09-23T09:17:26","slug":"connect-billing-summary-vendor-margin","status":"publish","type":"post","link":"https:\/\/smppcenter.com\/kb\/connect-billing-summary-vendor-margin\/","title":{"rendered":"How to Check Profit and Loss per Connect with the Message Billing Summary"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Route quality debates end quickly when you can see profit and loss per connect. The <strong>Message Billing Summary<\/strong> shows, for every connect and date, what you billed clients and what the vendor cost you, with the difference as profit or loss.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Message Billing Summary (per connect)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Filters:<\/strong> Connect, <strong>Is Final?<\/strong> (Yes\/No), From Date, To Date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Columns:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Meaning<\/th><\/tr><\/thead><tbody><tr><td>Date, Vendor, Account<\/td><td>The row&#8217;s connect, vendor and user<\/td><\/tr><tr><td>Total<\/td><td>Total message count<\/td><\/tr><tr><td>Delivered \/ Delivered %<\/td><td>Delivered volume and rate<\/td><\/tr><tr><td>Failed \/ Not Sent<\/td><td>Failure breakdown<\/td><\/tr><tr><td>Total Cost<\/td><td>What you billed for the row<\/td><\/tr><tr><td>Delivered Cost<\/td><td>Billed amount for delivered messages only<\/td><\/tr><tr><td>Vendor Cost<\/td><td>What the vendor cost you<\/td><\/tr><tr><td>Profit\/Loss<\/td><td>Total Cost minus Vendor Cost<\/td><\/tr><tr><td>Profit\/Loss %<\/td><td>Margin as a percentage of total cost<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use <strong>Export<\/strong> to pull the data into your own margin sheet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How to read it<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Negative Profit\/Loss on a connect:<\/strong> either the client&#8217;s rate is below the route&#8217;s cost, or the connect&#8217;s Cost\/Rate and Price Map are wrong. Check the connect&#8217;s settings before you renegotiate with anyone.<\/li>\n\n\n\n<li><strong>Total Cost far above Delivered Cost with a low Delivered %:<\/strong> you are billing on submit while delivery is poor. That&#8217;s a client complaint waiting to happen, even when the margin looks good.<\/li>\n\n\n\n<li><strong>Is Final? = No:<\/strong> figures may still change. Use final rows for commercial decisions.<\/li>\n\n\n\n<li><strong>Same client, two connects, different margins:<\/strong> move traffic toward the better connect by adjusting route percentages, not by changing the client&#8217;s rate.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Vendor&#8217;s Provisional Billable Statement<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before a vendor&#8217;s invoice arrives, generate your own expected payable:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open <strong>Vendor&#8217;s Message Provisional Billable Statement<\/strong>.<\/li>\n\n\n\n<li>Enter <strong>Month\/Year<\/strong>, select the <strong>Vendor<\/strong>.<\/li>\n\n\n\n<li>Enter <strong>Submission Rate per Message<\/strong> and <strong>Delivered Rate per Message<\/strong> from the contract.<\/li>\n\n\n\n<li>Enter the <strong>Tax Rate<\/strong> as a decimal.<\/li>\n\n\n\n<li>Click <strong>Generate<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">The statement shows submission count, submission base amount and tax, delivered count, delivered amount and tax, plus the total base and tax amounts, with a grand total across statements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use it as the check against the vendor&#8217;s invoice.<\/strong> If their invoice exceeds your statement, you have the counts and rates to dispute it line by line, in the same month the traffic ran.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">A simple monthly routine<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Generate the provisional billable statement for each vendor on the 1st.<\/li>\n\n\n\n<li>Compare it to the vendor invoice when it arrives; query differences immediately.<\/li>\n\n\n\n<li>Run the Message Billing Summary per connect for the month and export it.<\/li>\n\n\n\n<li>Look for any connect with negative or thin margin, and fix the rate, the route mix or the client&#8217;s price.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Related articles<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/smppcenter.com\/kb\/vendor-pricing-mcc-mnc-cost-rates\/\">How to Set Up Vendor Pricing and MCC\/MNC Cost Rates<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/smppcenter.com\/kb\/add-new-smpp-connect-operator-vendor\/\">How to Add a New SMPP Connect<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/smppcenter.com\/kb\/reconcile-user-billing-discrepancies\/\">How to Reconcile User Billing and Spot Discrepancies<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/smppcenter.com\/kb\/create-sms-route-distribution-strategy\/\">How to Create a Route and Choose a Distribution Strategy<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Compare what you charged clients against what each vendor cost you, per connect and per day, and produce a provisional payable statement before the vendor invoice arrives.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[379],"tags":[382,381,380,384,383],"class_list":["post-1011","post","type-post","status-publish","format-standard","hentry","category-reports-reconciliation","tag-billing-summary","tag-margin-per-connect","tag-profit-loss","tag-provisional-billable-statement","tag-vendor-cost"],"_links":{"self":[{"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/posts\/1011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/comments?post=1011"}],"version-history":[{"count":0,"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/posts\/1011\/revisions"}],"wp:attachment":[{"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/media?parent=1011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/categories?post=1011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smppcenter.com\/kb\/wp-json\/wp\/v2\/tags?post=1011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}