Import QBO/Xero CSV
Upload a CSV export and map accounts before locking your clean cut-off date.
Read the switching guide →How to export from QuickBooks Online
Bank and card transactions (required)
Do this once for each bank account and credit card.
- Go to Transactions > Bank transactions and click the account's tile at the top.
- Open the Posted tab. Rows still under For review are not in QuickBooks' books yet.
- Click the table's settings gear and turn on Show full bank description. Without it QuickBooks exports a cleaned payee name and drops the reference numbers Prosper uses to trace transfers and card payments.
- In the same settings, set rows per page to 300. QuickBooks exports only the page you are looking at (50 rows by default). If the account has more than 300 posted rows, narrow the date filter and export each range.
- Click the Export icon above the table. The file downloads named after the bank (for example Bank_of America.csv), not after the account, so rename it or note which account it came from before you upload it below.
Chart of accounts & customers (optional)
- Accounting > Chart of accounts > the export icon > Export to Excel, then save as CSV.
- Sales > Customers (or the Customer Contact List report) > export > save as CSV.
Optional: chart of accounts, customers & invoices
Bring these over too, so your books and invoices line up. Export each as CSV from QuickBooks, then upload here.
Chart of accounts
Customers
Invoices