Integrations

Platform Integrations Explained

Platform integrations are used to connect ecommerce and payment platforms with your BudgetBadger account, providing you with enhanced data to dramatically improve your financial reporting and analysis to help you make better business decisions.

Platform integrations allow you to:

  • Match each platform payout to the corresponding bank deposit
  • Auto-split that deposit into revenue, refunds, and fee categories
  • Improve P&L precision and accuracy, enabling granular metrics and trends analysis
  • Provide data for the Platform Analytics section on the Dashboard page
  • Import product data and populate the Product Profitability page to analyze your product performance
  • Import listings inventory to view consolidated inventory all in one place across all channels

See Platform Integration Limits for validated paths and known limitations.

Platform Analytics on Dashboard

Once platforms are authenticated, synced and matches exist, you can view and customize the Platform Analytics section on the Dashboard page. These widgets provide insights into your business performance on each platform, helping you identify opportunities for growth and improvement.

See Dashboard Overview and Customization for how Dashboard sections and Edit work.

Automatic Matching and Sync Now

Platform integration matching runs on a daily schedule, so your platform transaction data is automatically synced and split into the appropriate categories.

Upon connecting your platform integration and syncing history, BudgetBadger typically pulls up to three years of platform activity (orders, payouts, etc.) from Etsy, Shopify, Amazon, and Stripe, subject to each platform’s API and your shop history. To be clear, this is separate from bank history, as Plaid-linked financial accounts usually provide about two years of transactions.

You can also use the Sync Now button on a connected platform card on the Integrations page to manually pull the latest platform activity and retry matching. While Sync Now runs, the card may show progress details until the sync finishes.

Sync details on each card show how many deposits are matched versus how many need attention in the Review queue. While high-confidence matches confirm automatically, ambiguous cases may land in Review. Open Review to confirm or reject candidates. You can reach out to support on the Contact page if you need help.

Understanding Platform Transaction Splits

A matched payout deposit is automatically split into multiple transaction lines based on the underlying detail, which typically include:

  • Gross Sales — gross sales in the payout
  • Payment Processing — card, payment processor, and per-sale marketplace transaction fees on sales
  • Refunds — refunds or chargebacks embedded in the payout
  • Other — platform-specific transaction types (e.g. Marketing & Advertising for Etsy Ads, Shipping & Fulfillment for Etsy labels, Sales Tax Collected for remitted buyer tax on Etsy or Stripe, etc.)

For Etsy, split lines come from your shop Payment account ledger, grouped to each disbursement that matched your bank deposit. A rare minor adjustment may be folded into an existing split line so the deposit still balances.

For Shopify, split lines come from the Shopify Payments payout (charges, refunds, and fees on that payout). Charges Shopify bills to your card, such as your plan, apps, and some shipping labels, are not part of these splits.

For Amazon, split lines come from that deposit's US settlement (Amazon.com), the same activity as the US settlement statement in Seller Central, including fees, ads, and shipping charges in the period. Payouts from other Amazon marketplaces (e.g. Canada or Mexico) that land in your US bank are not synced or auto-split today.

For Stripe, split lines come from the balance activity on that payout (charges, refunds, and Stripe fees). Tips and sales tax are split out when Stripe reports them on the charge.

On Shopify, Amazon, and Stripe, a leftover difference between platform activity and the bank deposit can appear as its own balancing line. See Review Queue and Forced Adjustments.

The original payout deposit is excluded from your P&L report and analyses, so they are not double-counted with the split transactions that drive the P&L and Platform Analytics.

Managing Split Category Preferences

To remap which BudgetBadger categories receive each allocation line type (revenue, refunds, processing fees, etc.), press the Manage button on the Split Categories line on the Integrations page and update the mappings to your preferences.

Split categories control how matched payout deposits are broken into P&L lines (for example Gross Sales vs Payment Processing). To be clear, these categorizations are integration settings for how your platform deposits are split and are different from category rules, which determine how your synced bank data is categorized.

It is important to change your preferred split category mappings on the Integrations page, not via category rules. Rules do not override platform integration split transactions. After changing your preferred mappings, run Sync Now if you want historical transaction splits updated immediately.

Review Queue and Forced Adjustments

The Review queue on the Integrations page lists bank deposits on your linked payout account that need attention: unmatched platform payouts, rare minor balancing adjustments on matched deposits, or unbalanced splits.

Click Review on the Integrations page to see details. You can research a deposit on your own or contact support. When resolved, run Sync Now or mark the item resolved in Review.

For Shopify, Amazon, and Stripe, a separate balancing line may appear when platform activity and the bank deposit do not match exactly (for example foreign exchange). Those cases also appear in Review when flagged.

Platform Integration Limits

The benefit of integrating your platform account with BudgetBadger is that the system can then automatically match your bank deposits with the platform API data to split your bank deposits, provide product analytics, and import listings inventory to manage all in one consolidated view.

The matching process varies by platform (Etsy, Shopify, Amazon, and Stripe), though typically involves using recognizable descriptors in the bank deposits (e.g. reference numbers, merchant name, amount, date) that match with the platform API data for each transaction.

While auto-matching is designed to be accurate, some bank deposits may still need confirmation in Review (see Review Queue and Forced Adjustments).

Known Limitations

  • Etsy edge cases — non-standard payout types (e.g. Payoneer), foreign-exchange differences, or multiple shops with same-amount deposits on the same day may not auto-match and could require manual confirmation in the Review queue.
  • Custom payout descriptors — bank deposits without standard platform keywords (e.g. missing STRIPE, ETSY, Shopify, or Amazon settlement descriptors) may not auto-match and appear in the Review queue.
  • Shopify checkout gateways — The Shopify integration targets Shopify Payments payouts (the default gateway). Sales through other checkout gateways on the same store (e.g. Stripe or PayPal) are not matched or split here and do not appear on Product Profit for Shopify. Use the Stripe integration or bank categorization for those deposits.
  • Negative balances — for some platforms, settlement periods that end with a net negative amount (i.e. expenses > revenue) instead of a positive payout balance are instead charged to a credit card. Those card charges then appear on your charge card and need to be categorized separately, not via the platform integration syncing process.
  • Amazon Seller plan — third-party app connect requires an Amazon Professional selling account (Individual plan cannot complete authorization).
  • Amazon marketplace scope (US) — the Amazon integration syncs US Seller Central settlement and Finances data (Amazon.com) for payout matching and COA splits. Bank deposits from Amazon Canada, Amazon Mexico, or other international marketplace wires (IAT / DES:INTL PYMNT) are not matched to US settlements and are not auto-split; they stay a single Gross Sales line on the deposit. That is expected — they do not appear in the Review queue. Product Profitability may still include international marketplace sales when those orders appear in US Finances shipment/refund data.
  • Unsupported platforms — other common payment processing platforms (e.g. Square) are not yet supported on the Integrations page, though payout transactions from these platforms can still be synced through the Plaid account syncing process.

For platform bank deposits that are unable to be auto-matched, these deposits will appear in the Review queue on the Integrations page. Click the Review button to see a list of deposits that need attention, which you can research on your own or contact support to help you resolve.

Integrations · Knowledge Base - Business