Accounting Software Setup and Automation

What this lesson covers

Small Business Bookkeeping taught the principles — chart of accounts, double-entry, accrual vs. cash basis, bank reconciliation. This lesson translates those principles into a working system using accounting software. The goal: reduce daily bookkeeping to near-zero manual effort and produce accurate financial information with a 30-minute weekly review.

Prerequisites

Small Business Bookkeeping. You need to understand what a chart of accounts is, how transactions are categorized, and why reconciliation matters before setting up software.

---

Choosing software

The options

Software	Monthly cost	Best for	Limitations
Wave	Free (paid add-ons for payroll, payments)	Solo operators, very small businesses, tight budgets	Limited inventory tracking, fewer integrations
QuickBooks Online	$30–$200/month	Most small businesses, especially with employees or inventory	Cost increases with features; interface can be overwhelming
Xero	$15–$78/month	Businesses wanting clean interface and strong bank reconciliation	Fewer US-specific payroll integrations than QuickBooks
FreshBooks	$19–$60/month	Service businesses, freelancers	Not designed for inventory-heavy or product businesses

Decision framework

1. Do you have employees? If yes, you need payroll integration. QuickBooks and Gusto (paired with any software) are the most common.
2. Do you sell physical products? If yes, you need inventory tracking. QuickBooks and Xero handle this; Wave and FreshBooks are weak here.
3. Does your POS integrate with it? Check before choosing. Square integrates natively with QuickBooks and Xero. Toast has its own reporting but exports to QuickBooks. Verify that daily sales data flows automatically.
4. Will your accountant use it? Ask your accountant what they prefer. Most work with QuickBooks; many also support Xero. Using the same platform lets your accountant access your books directly for tax prep and advisory work.

For most small businesses with employees and a POS system: QuickBooks Online (Essentials or Plus tier). It’s not the cheapest, but it has the broadest integration ecosystem and your accountant almost certainly knows it.

---

Initial setup

Step 1: Create the company

Register with your legal business name, EIN, address, fiscal year start, and accounting method (cash or accrual — match what you’ve chosen with your accountant).

Step 2: Import or build the chart of accounts

Most software provides a default chart of accounts. Customize it to match the structure from Small Business Bookkeeping:

Revenue accounts:

• Food sales
• Beverage sales
• Catering revenue
• Other revenue (merchandise, gift cards)

COGS accounts:

• Food cost
• Beverage cost
• Paper goods / disposables

Operating expense accounts:

• Rent
• Utilities
• Payroll — wages
• Payroll — taxes and benefits
• Insurance
• Marketing
• Supplies
• Repairs and maintenance
• Professional fees (accountant, attorney)
• Software and subscriptions
• Depreciation
• Miscellaneous

Asset accounts:

• Checking account
• Savings account (cash reserve)
• Accounts receivable
• Inventory
• Equipment (fixed asset)
• Accumulated depreciation

Liability accounts:

• Accounts payable
• Credit card
• Loan — [term loan name]
• Sales tax payable
• Payroll taxes payable

Equity accounts:

• Owner’s equity / capital
• Owner’s draws
• Retained earnings

Delete accounts you’ll never use (manufacturing accounts for a restaurant, for example). Add accounts specific to your business. Fewer accounts is better — you can always add more, but too many creates confusion and miscategorization.

Step 3: Connect bank and credit card feeds

Link your business bank accounts and credit cards. The software pulls transactions automatically (usually with a 1-day delay). This eliminates manual entry for most transactions.

Important: Only connect business accounts. Never connect personal accounts to business accounting software.

Step 4: Set up integrations

Integration	Purpose	How
POS → Accounting	Daily sales summary (revenue by category, taxes collected, tips) flows automatically	Square: native integration. Toast: export or third-party connector. Clover: Zapier or native.
Payroll → Accounting	Payroll runs automatically record wages, taxes, and employer costs	Gusto, QuickBooks Payroll, Square Payroll: direct integration
Bank feed → Accounting	Transactions import daily for categorization and reconciliation	Built into all major platforms
Bill pay → Accounting	Supplier invoices scanned, recorded, and scheduled for payment	QuickBooks: Bill.com integration or built-in. Xero: built-in

Step 5: Set opening balances

If the business is already operating, enter the opening balances for every account as of a specific date (ideally the first day of a month). This gives the software a starting point. If you’re pre-revenue, opening balances are the owner’s initial investment.

---

Daily workflow (5 minutes)

Once set up, the daily workflow is minimal:

1. Review imported transactions. The software shows new transactions from the bank feed. For each one:

   • If the software auto-categorized correctly: Approve it.
   • If the category is wrong: Change it to the correct account.
   • If it’s a new type of transaction: Categorize it and create a rule (“All transactions from ‘US Foods’ go to ‘Food cost’”). Future transactions from the same vendor will auto-categorize.

2. Check POS sync. Verify that yesterday’s sales summary imported correctly. The daily total in the accounting software should match the POS daily report.

That’s it for daily work. Most transactions auto-categorize after the first month of training the rules.

---

Weekly workflow (30 minutes)

1. Approve remaining transactions. Catch anything that wasn’t reviewed daily.
2. Record any manual transactions. Cash payments, petty cash purchases, or transactions that don’t flow through the bank (owner contributions, inter-account transfers).
3. Review accounts receivable. Check the AR aging report — are any invoices overdue? Follow up.
4. Review accounts payable. Check upcoming bills — what’s due this week? Schedule payments.
5. Glance at the dashboard. Most software shows a summary: income vs. expenses, cash balance, profit/loss. Does anything look wrong?

---

Invoicing workflow

For businesses that invoice (catering, wholesale, B2B services):

Creating invoices

Use the software’s built-in invoicing — not a separate template. This ensures the invoice automatically:

• Records the revenue in the correct account
• Creates an accounts receivable entry
• Tracks the invoice status (sent, viewed, paid, overdue)

Automating reminders

Set up automatic payment reminders:

• 3 days before due: “Friendly reminder — Invoice #1042 for $2,800 is due on March 15.”
• 1 day after due: “Invoice #1042 is now past due. Please remit payment at your earliest convenience.”
• 7 days after due: “Second notice — Invoice #1042 is 7 days past due.”

After 14 days past due, follow up personally by phone. Automated reminders handle the routine; personal contact handles the urgent.

Recording payments

When payment arrives, match it to the invoice in the software. This closes the AR entry and records the cash receipt. If payment came electronically, the bank feed may auto-match — approve it.

---

Bill management workflow

For recurring bills (rent, utilities, insurance) and supplier invoices:

1. Enter the bill when received (or scan it — QuickBooks and Xero have mobile apps that photograph and extract invoice data).
2. The software creates an AP entry and schedules the due date.
3. On the due date, approve payment through the software’s bill pay feature or pay manually and record the payment.

This ensures accounts payable is always current and no bills are missed or double-paid.

---

Monthly reconciliation (1 hour)

At the end of each month:

1. Reconcile each bank account. The software compares the bank statement ending balance to the book balance. If they match, the account is reconciled. If not, find the discrepancy — usually an unrecorded transaction, a duplicate entry, or a timing difference (a check written but not yet cashed).

2. Reconcile credit cards. Same process — match the statement balance to the book balance.

3. Review the P&L (income statement). Does it make sense? Is food cost at the expected percentage? Are there any unusual expenses? Large amounts in “Miscellaneous” suggest transactions that need better categorization.

4. Review the balance sheet. Do the cash balances match reality? Is AR aging reasonable? Do liabilities look correct?

5. Back up the data. Cloud software auto-saves, but export a copy of your key reports (P&L, balance sheet, transaction list) monthly as a local backup.

---

Useful reports

Report	What it tells you	How often
Profit & Loss (Income Statement)	Revenue, costs, and profit for any period	Monthly
Balance Sheet	Assets, liabilities, and equity at a point in time	Monthly
Cash Flow Statement	Where cash came from and where it went	Monthly
AR Aging	Which invoices are outstanding and how old they are	Weekly
AP Aging	Which bills are due and when	Weekly
Expense by Vendor	How much you’re spending with each supplier	Monthly (for negotiation leverage)
P&L by Month (comparison)	Side-by-side monthly results to spot trends	Monthly
Budget vs. Actual	How actual results compare to financial projections	Monthly

Setting up budget vs. actual

Enter your financial projections as a budget in the software. Then run a “Budget vs. Actual” report each month. This is the most powerful report for a new business — it shows exactly where reality diverges from the plan and forces you to ask why.

---

Common mistakes

• Not categorizing transactions regularly. A backlog of 200 uncategorized transactions at month-end is demoralizing and error-prone. Review daily (5 minutes) to prevent this.
• Too many accounts. If you have separate expense accounts for “Cleaning Supplies,” “Kitchen Supplies,” “Bathroom Supplies,” and “Office Supplies,” you probably just need “Supplies.” Granularity is useful only if you’ll make decisions based on it.
• Mixing personal and business. Never run personal expenses through the business account. It creates tax complications, muddies the financial picture, and may undermine the liability protection of your corporate structure.
• Ignoring reconciliation. Unreconciled accounts accumulate errors. Reconcile monthly — no exceptions.
• Not involving the accountant. Give your accountant read access to the software. Let them review the chart of accounts during setup. Their 30 minutes of review now saves hours of cleanup at tax time.

---

Guidance

• If you’re currently using spreadsheets or paper for bookkeeping, set up accounting software this week. Choose based on the decision framework above, connect your bank accounts, and import the last 30 days of transactions.
• If you’re already using software, check your categorization rules. How many transactions auto-categorize correctly? If less than 80%, spend 30 minutes adding vendor-based rules.
• Run a Budget vs. Actual report for last month. Where are the largest variances between your plan and your results?