How to Generate Test Data for Your QuickBooks Online Sandbox

The empty sandbox problem

Every QuickBooks Online sandbox starts the same way: completely empty. No customers, no vendors, no chart of accounts activity, no transaction history. If you are building or testing a QBO integration, that blank slate is a serious obstacle. Your app needs realistic data to exercise its features, but Intuit does not provide any out of the box.

Most teams resort to hand-entering fake invoices, a handful of customers, and maybe a bill or two. That approach breaks down fast. Manual data entry is slow, error-prone, and produces data that looks nothing like a real company's books. Three invoices to "Test Customer" do not reveal the bugs that surface when your app processes hundreds of transactions across dozens of accounts.

A better approach: connect, configure, run

EasyTestData eliminates the manual work entirely. The workflow is three steps:

1. Connect your sandbox -- Link your QBO sandbox via OAuth. EasyTestData only connects to sandbox environments, never production.
2. Pick a template and preset -- Choose an industry template (such as SaaS, professional services, or restaurant) and a scenario preset (healthy small business, rapid growth, cash crisis, and more).
3. Run the load -- EasyTestData generates a complete financial dataset and loads it directly into your sandbox via the QBO API.

What gets created

A single load populates your sandbox with a full set of interconnected entities and transactions:

• Master data -- Customers, vendors, employees, and service items with realistic names and addresses
• Invoices and sales receipts -- With line items, payment terms, and due dates that match the selected industry
• Bills and expenses -- Vendor bills across realistic expense categories like rent, software, and professional fees
• Payments -- Customer payments, bill payments, and partial payments that create open balances
• Journal entries -- Adjusting entries, accruals, and reclassifications
• Payroll -- Payroll journal entries with salary, tax, and benefit breakdowns
• Deposits and transfers -- Bank deposits grouping multiple payments, and inter-account transfers

All transactions are financially coherent. Revenue matches invoices, expenses align with COGS ratios, and the P&L tells a believable story for the chosen industry.

Industry templates

EasyTestData ships with 8 industry templates. Each one configures the service items, expense categories, COGS ratios, and payment terms that are typical for that industry. A SaaS company gets monthly recurring subscriptions and low COGS. A restaurant gets daily cash sales and high food costs. A construction firm gets progress billing and equipment expenses. The data does not just fill space -- it reflects how real businesses in each sector actually operate.

Scenario presets

The 7 scenario presets bundle realistic parameter combinations for common testing situations. "Healthy small business" gives you steady revenue and positive margins. "Rapid growth" produces accelerating sales with expanding headcount. "Cash crisis" creates a company with high receivables, overdue bills, and shrinking cash. Each preset sets revenue targets, customer counts, EBITDA ratios, and growth rates so you get a coherent financial narrative without tuning dozens of parameters yourself.

Clean up when you are done

Every entity EasyTestData creates is tagged with an EZTD prefix in its metadata. When you need to reset your sandbox, the purge command removes only the generated data, leaving any manually created records untouched. You can also purge everything for a complete reset. Either way, your sandbox is ready for the next test run in seconds.

# Remove only EasyTestData-generated entities
easytestdata purge --mode generated

# Remove all data for a full reset
easytestdata purge --mode all

Get started by creating a free account at easytestdata.com and connecting your first QBO sandbox.