Import bank transactions into QuickBooks Desktop from PDF statements
Desktop won't open a PDF, and Web Connect only reaches back as far as your bank allows. DocsToBooks reads the statement, checks it against the bank's printed totals, and gives you an IIF or QBO file.
IIF or QBO, your choice.
IIF for a direct import into a Desktop company file; QBO for Web Connect. Both come from the same checked rows.
Dates written MM/DD/YYYY.
IIF dates are written MM/DD/YYYY by default. An IIF import follows the computer's date setting, so check that your Windows regional format matches before you import.
Ready for Desktop.
Import the IIF or QBO file into the company file yourself, the same way as a bank download. Back up the company file first.
Bank-feed files stay locked until you say so.
A statement that doesn't reconcile can still go to Excel or CSV for review, marked. QBO, IIF and QuickBooks CSV files go straight into QuickBooks, so for those the export stays locked until you tick a box saying you've seen the difference.
Questions
Can I import a PDF into QuickBooks Desktop?
Not directly. Desktop imports bank transactions from .qbo (Web Connect) or .iif files. You need to turn the PDF into one of those first.
IIF or QBO: which should I use?
QBO goes through Web Connect and the bank-feed matching screen, like a download from the bank. IIF imports straight into the register. If your firm has a habit, keep it; both carry the same rows.
My client's Desktop file is on another computer.
Export the IIF or QBO and import it there.
Does it work with QuickBooks Online too?
Yes: export QBO or the QuickBooks CSV and upload it in QuickBooks Online.
Download · Catch-up and year-end · Pricing · Layouts · IIF or QBO