QuickBooks
How to import DanScan transactions into QuickBooks Online
This page is provided in English.
Updated October 30, 2026
DanScan can turn a client's uploaded receipts and sales reports into a file QuickBooks Online imports as bank transactions. This saves typing each amount by hand.
Before you start
- Only documents with an amount are included, so ask clients to enter the amount when they upload.
- Expenses are exported as negative amounts and sales reports as positive amounts.
Step 1. Export from DanScan
- Sign in to DanScan and open the client's folder.
- Filter by category or month if you only want part of the folder.
- Select Export for QuickBooks. A CSV file with three columns (Date, Description, Amount) downloads to your computer.
Step 2. Upload to QuickBooks Online
- In QuickBooks Online, go to the bank transactions area.
- Choose the option to upload transactions from a file, then select the DanScan CSV.
- Choose the QuickBooks account the transactions belong to.
- When asked to match columns, choose Date, Description and a single Amount column. The dates are in MM/DD/YYYY format.
- Review the transactions, then confirm the import.
The imported lines appear in the review list, where you categorize and match them as usual. QuickBooks menus change from time to time, so if your screen looks different, search the QuickBooks help center for "upload bank transactions from a file."
QuickBooks is a trademark of Intuit Inc. DanScan is not affiliated with Intuit.
Try DanScan free for 14 days
A private, secure folder for every client. No credit card needed.
Start your free trial