How to Switch from QuickBooks to Prosper

Migration overview

Prosper uses a clean cut-off migration approach. You export your historical transactions from QuickBooks up to a chosen date, import them into Prosper, and lock the opening balance. This creates a trusted ledger boundary.

Historical data stays in QuickBooks for reference. New activity flows through Prosper. This approach is safer than trying to migrate everything and reduces the risk of data errors.

Choose cut-off date

The cut-off date separates your historical QuickBooks data from your new Prosper ledger. Common choices:

• Start of calendar year: January 1 is clean and easy to reference
• Start of fiscal year: If your fiscal year differs from calendar year
• Start of quarter: Good if you're mid-year and want a shorter migration window

Once you choose a date, export all transactions up to (but not including) that date from QuickBooks.

Export CSV

In QuickBooks Online:

1. Go to Reports → Transactions
2. Set date range from your earliest transaction to your cut-off date (exclusive)
3. Include all accounts
4. Export as CSV
5. Verify the CSV includes: date, description, amount, account name

If QuickBooks doesn't export in the exact format Prosper expects, you may need to adjust column headers or use a mapping step during import.

Map accounts

When you upload the CSV in Prosper, you'll see a mapping interface. For each QuickBooks account label, choose the corresponding Prosper account.

Prosper will suggest mappings based on account names. Review each mapping to ensure accuracy. Common mappings:

• Checking/Savings → Bank accounts
• Income accounts → Revenue accounts
• Expense accounts → Expense categories
• Credit cards → Credit card accounts

If Prosper doesn't recognize an account, you can create a new account during mapping.

Lock opening balance

After importing transactions, Prosper will show an opening balance report. Verify that each account's opening balance matches your QuickBooks closing balance as of the cut-off date.

Want the reasoning behind the lock? Read the opening balance guide.

Once verified, lock the opening balance. This action:

• Creates a trusted ledger boundary
• Prevents changes to historical imported data
• Enables undo protection (you can't undo migration after locking)

Important: Review the opening balance carefully before locking. After locking, historical data cannot be modified in Prosper (though you can still reference QuickBooks).

Verify

After locking the opening balance, check Prosper's calm status. If anything affects correctness, it will surface in your exceptions inbox. Common items to verify:

• All accounts have correct opening balances
• No duplicate transactions
• All transactions are properly categorized
• Reconciliation status matches QuickBooks

If something looks wrong, you can undo the migration within 48 hours (before locking). After locking, you'll need to work with Prosper support to correct any issues.

Export accountant pack

When you're ready to hand off to your CPA, use Prosper's Accountant Pack export. This creates a ZIP file containing:

• Profit & Loss (P&L) statement
• Balance Sheet
• Trial Balance
• General Ledger
• Transaction export (CSV)
• Reconciliation summary

Your CPA can use these reports to review your books, prepare tax returns, and provide advisory services. All reports are accountant-friendly and follow standard accounting formats.

Safety net

If something looks wrong after import, you can undo the migration within 48 hours. Undo is disabled once the opening balance is locked to protect the ledger integrity. After locking, keep QuickBooks active for reference until you're confident in the migration.