How do I split Stripe processing fees in QuickBooks Online?

In QuickBooks Online, Stripe deposits the net amount into your bank, but your invoices reflect the gross amount. To reconcile without errors, create a Split Deposit with Line 1 as Gross Sales (Sales Revenue), Line 2 as Stripe Processing Fees (negative Expense), resulting in a net total matching the bank feed cleared deposit to the exact penny.

What is the Stripe Clearing Account method and why do bookkeepers recommend it?

The Stripe Clearing Account method is the industry-standard workflow recommended on r/Bookkeeping. Instead of matching hundreds of individual transactions in the bank feed, bookkeepers post gross sales, fees, and refunds to a Stripe Clearing bank account, and record payouts as simple transfers from the clearing account to the operating checking account.

How does the Beginning & Ending Balance Checksum prevent reconciliation errors?

QuickFinSync extracts Beginning Balance and Ending Balance from your bank statement header. It applies the mathematical formula (Beginning Balance + Inflows - Outflows = Calculated Ending Balance). If a bank line item or service charge is missing, QuickFinSync flags the exact variance before you import into QuickBooks.

What is a .QBO file and why is it better than CSV for QuickBooks?

A .QBO (QuickBooks Web Connect / OFX) file is an Intuit-standard financial exchange format. When imported into QuickBooks Online or Desktop, it automatically populates the Bank Feed without asking the user to manually map date, description, and amount columns.

Are my clients financial records and bank statements stored on your servers?

Solo conversions operate on 100% in-browser memory with zero server storage. For Bookkeeper Hub client links, the extracted transactions are sent over HTTPS, visible only to the bookkeeper, and automatically deleted after 7 days.

Does QuickFinSync work with Shopify Payments and PayPal Activity CSVs?

Yes. QuickFinSync features dedicated reconciliation engines for Shopify Payments and PayPal Activity downloads, automatically splitting processing fees, refunds, and generating balanced General Ledger journal entries.

Free Public Financial Tool

Bank Statement Charge Lookup Tool

Paste any cryptic bank or credit card transaction descriptor. Uncover the real merchant name, typical QuickBooks GL account code, and recurring subscription status.

Paste Cryptic Bank or Credit Card Descriptor

Quick Examples:

Verified Merchant Match

Amazon

Accounting Category

General Business Expense

QuickBooks GL Code

6900 - Miscellaneous Business Expense

Legitimacy Status

Verified Business Vendor

Processor Context: Amazon.com / Marketplace: Amazon digital service, Prime subscription, or marketplace 3rd-party order.

Have a whole PDF statement full of messy descriptors?

QuickFinSync automatically cleans and categorizes hundreds of transaction lines and exports balanced .QBO feeds.

Convert Statement Free

Common Bank Statement Prefixes Decoded

Modern merchant payment aggregators often mask the actual business name with standard terminal abbreviations:

Prefix / Pattern	Processor / Merchant	Typical Businesses	Accounting GL Mapping
SQ * [Merchant]	Square Inc. (Block)	Cafes, bakeries, boutique retail, food trucks	6600 - Meals & Dining
TST* [Merchant]	Toast POS	Sit-down restaurants, bistros, bars	6600 - Business Meals
DRI*[Software]	Digital River	Software subscriptions, antivirus, Adobe, Avast	6100 - Software & SaaS
AMZN MKTP US*	Amazon Marketplace	Third-party Amazon seller purchases	6700 - Office Supplies
SP * or STRIPE *	Stripe Payments	SaaS web tools, digital courses, e-commerce	6100 - Software Subscriptions
PY* or PAYPAL *	PayPal Checkout	Online merchant orders or recurring billing	6500 - Merchant & Bank Fees

Frequently Asked Questions

How do I identify an unrecognized charge on my bank statement?

Copy the transaction description text from your online banking portal or PDF statement into our free Charge Lookup Tool. The engine strips POS terminal noise, store numbers, and state suffixes, matching the descriptor against our dictionary of verified business entities.

Why do credit card charges have strange prefixes like SQ, TST, or DRI*?

These prefixes represent third-party payment gateways and POS systems. SQ* indicates Square (local coffee shops and retail), TST* indicates Toast POS (restaurants), DRI* indicates Digital River (software and digital licenses), and SP* or STRIPE indicates Stripe internet checkouts.

What should I do if a charge on my bank statement is fraudulent?

If you do not recognize a transaction after decoding its descriptor, contact your card-issuing bank to dispute the charge and freeze your card. Many charges appear fraudulent simply due to parent company billing names (such as AMZN or DRI).

How do I map clean transaction payees into QuickBooks Online or Xero?

Rather than manually typing hundreds of payee names, QuickFinSync parses your entire multi-page bank statement PDF, cleans every cryptic descriptor automatically, and exports a balanced .QBO Web Connect feed with standardized vendor payees.

Zero-Storage Client-Side Engine

Convert Entire Bank Statement PDFs into Clean QuickBooks Feeds

Don't look up charges one by one. Drop your PDF bank statement into QuickFinSync to auto-clean payees and export balanced .QBO files in seconds.

Try Statement Reconciler Free