How Small Business Owners Track Money In and Out
What payment processing tools and bookkeeping actually do for your business
Payment processing tools and bookkeeping software are two separate things that work together. Payment processing captures the transaction—when a customer pays you by card, ACH, or check—and moves that money into your bank account. Bookkeeping records where that money came from, where it went, and what your business owes. Most small business owners use both, often connected so data flows from one to the other without manual re-entry.
The payment tool is what your customer sees: a card reader, an invoice link, a checkout page. The bookkeeping tool is what you see: a ledger of income, expenses, and the gap between them. Together, they show you whether the business is making money, where it's going, and what you owe in taxes.
Key Takeaways
- Payment processors handle the transaction itself—collecting money from customers—while bookkeeping records where that money came from and where it went.
- Many payment processors integrate with bookkeeping software so transactions post automatically instead of requiring manual entry.
- Bookkeeping tools range from simple spreadsheets to full accounting software, and the right choice depends on how many transactions you process and whether you have employees.
- Reconciliation—matching what your payment processor says you received against what your bank account actually shows—catches errors and fraud.
- Most small businesses can start with a basic tool and upgrade as revenue and complexity grow.
How payment processors and bookkeeping connect
When a customer pays you, the payment processor records the transaction and deposits the money into your business bank account. That same transaction can automatically flow into your bookkeeping software, where it appears as income. Without this connection, you would have to manually type every transaction into your books—a source of errors and lost time.
The connection works through an API (a technical link between two pieces of software). When you set up bookkeeping software, you authorize it to pull transaction data from your payment processor. Most major processors—Square, Stripe, PayPal, Shopify Payments—integrate with popular bookkeeping tools like QuickBooks Online, Wave, and Xero. Some integrations are automatic; others require you to flip a switch in settings.
Without integration, you still get the money—the processor deposits it to your bank. But you have to record it yourself in your books, which means more work and more chance of a mistake. Integration saves time and keeps your records accurate.
Payment processors: what they do and what they cost
A payment processor takes payment from your customer and deposits it into your business bank account, minus their fee. The fee is usually a percentage of the transaction (2% to 3.5% for cards, lower for ACH) plus a flat amount per transaction (20 to 30 cents). Some processors charge a monthly minimum or a flat monthly fee instead.
Payment processors come in different forms depending on how you collect money. A point-of-sale system (POS) like Square or Toast handles in-person card payments and can also manage inventory and staff. An online payment gateway like Stripe or PayPal processes payments on your website or through invoices you email to customers. Some businesses use both—a card reader in the shop and a payment link for remote customers.
The processor holds money for a day or two before depositing it, a period called the settlement window. Most processors settle daily or next-business-day. Some hold money longer if they perceive risk—a new business, a high-risk industry, or a sudden spike in volume. This delay affects your cash flow, so it matters which processor you choose.
Bookkeeping tools: from spreadsheets to full accounting software
Bookkeeping ranges from a spreadsheet you update yourself to software that automates most of the work. The right tool depends on how many transactions you have, whether you have employees, and whether you need to track inventory or projects.
Spreadsheets (Google Sheets, Excel) cost nothing and work if you have fewer than 20 transactions a month. You enter each transaction by hand: date, amount, category, description. The downside is that you have to do all the math yourself, and there is no built-in way to catch errors. Most small businesses outgrow spreadsheets within a year.
Wave is free bookkeeping software designed for small businesses with no employees. It connects to your bank and payment processor, imports transactions automatically, and generates basic reports. You categorize transactions (rent, supplies, payroll) and Wave calculates your profit and loss. Wave does not handle payroll or inventory well, so it works best for service businesses or simple retail.
QuickBooks Online is the most common paid option. It costs $15 to $200 per month depending on the plan, handles multiple users, tracks inventory, manages payroll, and integrates with most payment processors. It is more complex than Wave but more powerful. Most accountants know QuickBooks, which makes tax time easier.
Xero is similar to QuickBooks—$15 to $80 per month—and popular with accountants outside the United States. FreshBooks ($15 to $55 per month) is built for service businesses and freelancers and emphasizes invoicing and time tracking. Zoho Books ($10 to $45 per month) is a lower-cost option with similar features to QuickBooks.
Most bookkeeping software offers a free trial. Start there, and choose based on whether the interface makes sense to you and whether it connects to your payment processor and bank.
What reconciliation means and why it matters
Reconciliation is the process of comparing what your payment processor says you received against what your bank account actually shows. It catches errors, fraud, and timing mismatches.
Here is how it works: Your payment processor says you received $5,000 in card payments this week. Your bank account shows a deposit of $4,850 (after processor fees). Your bookkeeping software shows $5,000 in income. You reconcile by checking: Did the processor deduct the correct fee? Did the bank deposit the right amount? Does your bookkeeping match both? If all three agree, you are reconciled. If not, you investigate.
Reconciliation catches real problems: a processor error, a fraudulent transaction, a duplicate charge, or a deposit that never arrived. Most bookkeeping software has a reconciliation tool that walks you through the process. You do it monthly, usually when your bank statement arrives. It takes 15 to 30 minutes if you have fewer than 100 transactions.
Integration: connecting payment processing to bookkeeping
Setting up integration is usually simple. In your bookkeeping software, you find the "connect accounts" or "integrations" section, search for your payment processor, and authorize the connection. The software asks for permission to read your transaction history, and you approve. From that point on, transactions flow automatically.
Most integrations pull data daily or weekly. A transaction that posts to your payment processor on Monday might not appear in your bookkeeping software until Tuesday or Wednesday. This lag is normal and does not affect your actual money—it is just the software catching up.
If integration is not available between your processor and your bookkeeping tool, you have options. Some processors export data as a CSV file (a spreadsheet format) that you can import into your bookkeeping software. Others require manual entry or a third-party service like Zapier to bridge the gap. Manual entry is slower but still workable for a small business.
Choosing tools that fit your business size and type
Start by asking: How many transactions do I process per month? Do I have employees? Do I need to track inventory? Do I invoice customers or do they pay at the point of sale?
A freelancer or consultant with 10 invoices a month might use Wave (free) plus Stripe (2.2% + 30 cents per transaction). A retail shop with 200 daily card sales might use Square (2.6% + 10 cents) plus QuickBooks Online ($35/month). A service business with employees might use Shopify Payments (2.7% + 30 cents) plus Xero ($30/month) plus a payroll add-on.
The tools you choose should integrate with each other and with your bank. Before you commit, check the integration list on both the payment processor and the bookkeeping software. If they do not connect, ask whether a CSV export or third-party bridge is available.
Most small businesses can start with a basic, inexpensive setup and upgrade as revenue grows. You do not need enterprise software on day one. You need something that works, that you understand, and that connects to your bank so you can see your real cash position.
Common mistakes to avoid
The biggest mistake is not reconciling. If you do not match your processor, bank, and bookkeeping records monthly, errors compound. A missing deposit, a duplicate charge, or a processor fee you did not notice can throw off your entire picture of profit. Reconciliation takes 30 minutes a month and prevents much larger problems.
The second mistake is choosing a tool because it is free or cheap without checking whether it integrates with your processor and bank. A free tool that requires manual data entry defeats the purpose. Spend a little on integration if it saves you hours of work.
The third mistake is not categorizing transactions. If every expense goes into a bucket called "Other," you cannot see where your money is actually going. Take five minutes when you reconcile to sort transactions into categories: rent, supplies, payroll, marketing, equipment. Your bookkeeping software usually has templates for this. At tax time, you will be grateful.
Frequently Asked Questions
Do I need both a payment processor and bookkeeping software?
Yes, they do different jobs. The payment processor moves money from your customer to your bank. Bookkeeping records where that money came from and where it went. You could use just a processor (and track money in a spreadsheet), but you would lose visibility into profit and expense. Most small businesses use both.
Can I use my personal bank account instead of a business account?
Legally, yes, but it is a bad idea. Mixing personal and business money makes bookkeeping harder, complicates taxes, and can hurt you if the business is sued. Open a business bank account and route all business payments through it. Most banks offer free or low-cost business checking.
What if my payment processor and bookkeeping software do not integrate?
Check whether the processor offers a CSV export. If it does, you can import that file into your bookkeeping software weekly or monthly. If not, a third-party service like Zapier can bridge the gap for a small monthly fee. Manual entry is the last resort and should only be temporary.
How often should I reconcile?
Monthly is standard and matches your bank statement cycle. If you process a high volume of transactions or handle cash, weekly reconciliation catches errors faster. Most small businesses reconcile once a month, usually within a few days of the bank statement arriving.
Do I need to hire an accountant to set this up?
No. Most payment processors and bookkeeping software have setup guides and customer support. If you get stuck, a bookkeeper or accountant can help you connect everything for a one-time fee of $200 to $500. After that, you can maintain it yourself or hire someone to reconcile monthly for $100 to $300.