Bank Statement PDFs to QuickBooks for Freelancers

Steps for freelancer and Schedule C records

1. Download each monthly statement for the tax year as a PDF (scanned PDFs aren't supported).
2. Put the PDF in the converter at the top of the page.
3. Look out for client payments split across lines and transfers between your own accounts.
4. Set Export layout to Quickbooks layout (free), choose Download CSV, then add your own Category column.

What the file looks like

Sample rows, Quickbooks layout setting.

QuickBooks notes

• QuickBooks Online accepts a bank CSV in a 3-column format (Date, Description, Amount) or a 4-column format (Date, Description, Credit, Debit). The Quickbooks layout uses the 3-column format, with money in positive and money out negative, and dates as MM/DD/YYYY.
• QuickBooks may add details to uploaded rows when it recognizes a description, or based on your bank rules, so review them in the For review tab.

Why it fits freelancer and Schedule C records

If you started using QuickBooks partway through the year, the earlier months only exist as statement PDFs. Converting them lets you bring the whole year into one place before you sort out business and personal items.

Once the earlier months are in QuickBooks, you can mark each row as business or personal and assign accounts. Personal rows in a mixed account can be excluded during review, so your reports only show business activity.

Tip: Upload into a separate account in QuickBooks if the statements are from a personal account you also use for business, then exclude personal rows during review.