Client Statement PDFs to QuickBooks Online Uploads

Steps for accountants and bookkeepers

1. Download the client's statement PDFs, one account at a time as a PDF (scanned PDFs aren't supported).
2. Put the PDF in the converter at the top of the page.
3. Tie out the totals above the table to the statement summary and note it in your workpapers.
4. Set Export layout to Quickbooks layout (free), choose Download CSV, then save it in the client folder.

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.
• Start the file at least one day before the oldest transaction already in that QuickBooks account, and check the Chart of accounts first, so you don't create duplicates. RowSmith is not affiliated with Intuit.

Why it fits accountants and bookkeepers

Cleanup engagements in QuickBooks Online often start with months the feed never captured. Converting the client's PDFs to the Quickbooks layout turns them into upload files you can review first.

On cleanup jobs, upload one month at a time and reconcile it before moving on. If something is off, you know which file caused it. Keep the converted CSVs in the client folder as a record of what was uploaded and when.

Tip: Upload into the correct account (bank or credit card). Intuit notes that credit card CSVs can show signs reversed, so check a payment and a charge after uploading.