Brand deals make up the majority of income for independent creators. According to ShortsIntel and Influencer Marketing Hub, brand deals account for 70% of creator earnings. When that much of your income comes from a single channel, knowing exactly how much of each deal you keep after fees is essential.
There is a gap between what you invoice and what lands in your bank account. Payment processing fees, platform commissions, and currency conversion costs reduce each payment. Over 20 deals per month, those small deductions add up to hundreds or thousands of dollars each year.
This article walks you through a simple Google Sheets system to track gross invoice amounts against net deposits. You will know exactly what each deal earned after fees. You will also see patterns in your payment data that you might currently be missing.
Where the Money Goes Between Invoice and Deposit
Every payment processor takes a fee before money reaches you. The two most common processors for UGC creators are Stripe and PayPal. Understanding their fee structures is the first step to accurate reconciliation.
Stripe charges 2.9% plus $0.30 per transaction for domestic payments, according to UGC Roster. PayPal charges the same 2.9% plus $0.30 for domestic payments. The difference between the two processors shows up with international transactions.
PayPal international fees include 4.4% plus a fixed fee plus a 2.5% currency conversion charge. Stripe international fees vary by region. If you work with brands outside your country, international fees take a significantly larger portion of each payment compared to domestic transactions.
What Payment Fees Cost You at Higher Volumes
Small per-transaction fees compound quickly over time. Data from Outseta shows that a creator processing $50,000 per month in payments would pay approximately $485 more per month using PayPal compared to Stripe. That difference adds up to $5,820 per year in processor fees alone.
Most creators do not process $50,000 per month through a single processor. But the fee ratio applies at any volume. Choosing PayPal over Stripe when most of your clients are domestic costs you roughly 1% of your total payment volume in extra fees each year.
Platform and Marketplace Fees Add Another Layer
Beyond payment processors, many creators use freelance marketplaces that charge their own fees. These platforms take a percentage of each deal before the payment processor adds its fees. The combined deductions from both layers can be substantial.
Some platforms charge a flat percentage of each transaction. Others use a sliding scale based on total earnings with a client. Either way, the platform fee comes off the top, and the payment processor fee comes off after that.
The combined deductions from both layers can reduce your gross invoice amount significantly. Tracking each deduction separately shows you where the biggest losses are in your payment pipeline.
Building Your Payout Reconciliation System in Google Sheets
A reconciliation system tracks two numbers for every deal: what you invoiced and what you received. The difference between them tells you what each deal actually earned after all deductions. This information helps you decide which clients, platforms, and payment methods are most profitable for your business.
Open a new Google Sheet and create the following columns. Each column captures one piece of information about every deal you complete. The goal is to trace the full path from invoice to deposit for every single transaction.
Column 1: Deal Information
Start with basic deal identifiers. Include the brand name, deal date, invoice number, and client email address. This makes it easy to search for specific transactions when questions come up or when you need to match a deposit to an invoice.
Add a column for the platform if you found the client through a marketplace like Upwork or Fiverr. This helps you track which platforms produce the highest net earnings after all fees are deducted.
Column 2: Gross Invoice Amount
Enter the total amount you invoiced the client. This is the number on your invoice before any deductions. Be consistent about whether this amount includes or excludes any sales tax you might need to collect.
Column 3: Payment Method and Processor Fees
Record which payment method the client used. Stripe, PayPal, wire transfer, and check each have different fee structures and different deposit timelines. Note the fee percentage and any fixed fee for each transaction.
If the payment involved currency conversion, note the exchange rate and the conversion fee. International deals often have higher total deductions than domestic ones, and this column helps you see exactly how much higher.
Column 4: Platform or Marketplace Fee
If the deal came through a marketplace that charges a fee, record that amount in its own column. The platform fee and the payment processor fee are two separate deductions. Tracking them separately shows you the full cost of acquiring and getting paid for each client.
Column 5: Net Deposit Amount
Enter the exact amount that landed in your bank account. This is your net deposit. The difference between this number and your gross invoice amount is your total cost of getting paid for that deal including all fees at every layer.
Column 6: Net Percentage and Dollar Difference
Create a formula that calculates what percentage of your invoice you actually kept. Divide the net deposit by the gross invoice amount and format the result as a percentage. This percentage helps you compare deals regardless of their absolute dollar size.
Add a column for the raw dollar difference between invoiced and received. Sum this column at the end of each month and each quarter. The annual total will likely surprise you.
Handling Batch Deposits and Partial Payments
Batch deposits are one of the most common reconciliation problems for UGC creators. Stripe and PayPal often aggregate multiple payments into a single deposit to your bank account. A single batch might contain payments from several different brands and invoices.
To handle batch deposits, pull up the transaction list inside your processor dashboard. Look for the individual payments that make up that batch. Each payment entry shows the gross amount, the processor fee, and the net amount that went into the batch total.
Enter each individual payment as a separate row in your reconciliation sheet. The net amounts in your sheet should add up to exactly the batch deposit amount. If they do not match, check for additional fees or adjustments in your processor dashboard.
Partial payments add another layer of complexity. A client might pay 50% upfront and 50% upon delivery. Treat each payment as its own row in your reconciliation sheet.
Record the gross amount of that specific payment, the fees deducted, and the net deposit. This approach gives you a complete audit trail for every transaction.
Using Formulas to Automate Your Reconciliation Sheet
Manual data entry is necessary, but formulas can handle the math. Use Google Sheets formulas to calculate net percentage, fee totals, and running balances automatically. This reduces errors and saves time.
In the net percentage column, use a formula that divides the net deposit by the gross invoice amount. Format the result as a percentage with one decimal place. This calculation shows what percentage of each invoice you keep after all fees are deducted.
In the dollar difference column, subtract the net deposit from the gross invoice amount. This gives you the total fee cost for that deal. Sum this column at the bottom of your sheet to see your total fee burden for the month.
Add a summary section at the top of your sheet that pulls key numbers from your data. Show the total gross invoiced, total fees paid, total net deposited, and average net percentage for the current month. Use SUMIF formulas to filter by platform or payment method so you can compare performance across client sources.
Quarterly Reconciliation Reviews
A weekly check keeps your data current, but a quarterly review gives you the strategic picture. Set aside one hour every three months to analyze your reconciliation data for trends that affect your business decisions.
Look for payment methods that consistently produce lower net percentages. If one payment method consistently retains less of your invoice amount than another, that difference justifies asking clients to use a different method. Even a small gap per transaction adds up across multiple deals each month.
Compare net percentages across platforms. If direct clients consistently retain a higher percentage of your invoice than marketplace clients after all fees, you know exactly how much the marketplace convenience costs you. This data helps you decide whether to raise marketplace rates or invest more in finding direct clients.
How to Use This System Week to Week
Enter each new deal when you send the invoice. Record the gross amount and the payment method immediately. This takes 30 seconds per deal and prevents you from forgetting about transactions later in the month.
When a payment arrives, check your processor dashboard for the exact deposit amount. Enter the net deposit and any fees you can identify from the processor receipt. If the payment covers multiple invoices, split the deposit across the relevant deals based on each invoice share of the total payment.
Batch payouts from Stripe and PayPal make this step harder. A single deposit from Stripe might represent payments from three different brands across five invoices. In this case, log into your processor account, look up each individual payment, and enter each net amount separately into your sheet.
What Your Reconciliation Data Tells You
After three months of consistent tracking, patterns will appear. You might see that smaller deals lose a higher percentage to fixed fees than larger deals do. You might notice that international clients consistently pay lower net amounts due to currency conversion charges.
This data helps you make better business decisions. If PayPal international fees are cutting into every cross-border deal, you can ask international clients to pay through Stripe or wire transfer instead. If marketplace platform fees are taking a large portion of your revenue, you can raise your rates on that platform or invest more time in finding direct clients.
Tax Season and Your Reconciliation Sheet
Your reconciliation sheet doubles as a tax document. Payment processing fees and platform commissions are deductible business expenses. If you do not track them in a separate column, you miss claiming legitimate deductions on your tax return.
Share your reconciliation sheet with your accountant at tax time. The gross invoice amounts go on the income side of your return. The processor fees, platform fees, and currency conversion charges go on the expense side. Your net from each deal is what you actually earned after all business expenses related to getting paid.
Connecting Reconciliation to Your Full Payment Workflow
Reconciliation works best when it connects to your broader deal tracking process. Before a payment arrives, you should already know when to expect it and what to do if it is late. Our accounts receivable playbook covers the upstream workflow for tracking what clients owe you and following up on overdue payments.
Setting clear payment terms in your contracts makes reconciliation easier. When each invoice has a specific due date and an agreed payment method, you know exactly which deposit in your bank account matches which invoice. Our guide to payment terms that actually pay covers what to include in your contracts to avoid confusion later.
Even with good tracking, some brands do not pay on time or do not pay at all. A reconciliation system helps you identify non-paying clients quickly because you can see when a deposit is missing from your sheet. Our article on what to do when brands ghost walks through the next steps for recovering unpaid invoices.
Keeping Your Reconciliation System Going
The hardest part of any tracking system is consistency. Build reconciliation into your weekly routine rather than treating it as a monthly or quarterly task. Set a recurring 15-minute block every Friday to update your sheet with the week’s payments.
Use conditional formatting in Google Sheets to flag deals where the net percentage is unusually low. Set a rule that turns a cell red when fees take more than 10% of a deal. This visual cue helps you spot problematic transactions without scanning every row manually.
Keep a separate tab in your sheet for notes. If a client paid late, if a fee seemed incorrect, or if you had to follow up multiple times, note it there. These notes provide helpful context when you review your data at the end of each quarter.
Payout reconciliation is administrative work, but it protects your income. The gap between invoiced and received amounts is real money leaving your business. A simple spreadsheet takes 15 minutes per week to maintain and shows you exactly where every dollar goes.
Start with the six columns described above. Enter your last 10 completed deals to see the current pattern. Then commit to entering every new deal as it comes in. You will know which clients, platforms, and payment methods actually deliver the most net income to your bank account.
