If there is one column with both credits and debits and all the amounts are positive then there should be another column that contains the transaction Type i.e. Amounts can either be in one column, or two columns with one for Credits and one for Debits.
Most of the columns will automatically be correctly identified, but sometimes the names need to be modified. This is the most important aspect of preview mode.
Preview mode will bring up a spreadsheet-like dialog for confirming the transaction information extracted from the PDF Statement.The converter will display a log with setting information, a summary of each transaction that was extracted, and a reconciliation report. The converter will extract financial transactions from the statement, automatically discarding extra headers, footers, summaries, ads, and other extraneous information in the statement. Use Shift-Click or Ctrl-Click to do that.
In 2qbo Convert Pro you can also select multiple files for conversion.
If you are running 2qbo Convert Pro you can also use the Convert to csv button to create a CSV file, editable in Excel® or other spreadsheet software, in order to make manual adjustments and tweaks to your data.Subsequent conversions with statements from the same bank can be converted in a single step by selecting the Convert to qbo button. The first time you run the converter you should select the Preview button to make sure the data is correctly identified. Select the PDF statement to be converted. Run the conversion by selecting the big Convert button, which will bring a file chooser.Step II - Extract Transactions and Create the QBO file The checkbox to use the assigned column names should be unchecked the first time you run a conversion with a new bank, and then will automatically be checked on subsequent conversions. The option to switch signs is generally set correctly based on your account type (bank vs credit card), you can review that later. On the right column you should select the correct date type (month-day vs.The other options can generally be left as defaults. In that case you need to specify that PDF+ should run regardless of whether there is text in the PDF. The converter will automatically run PDF+ when the file only has scanned images, but some scanners will automatically run a built-in OCR, and the scanned file will then have both text and images (a searchable PDF). In the middle column, if you have a scanned image, it is good idea to select the option for Always run PDF+ text recognition (OCR).For our example we will just use the name 'National Bank' which is the name of a bank in Texas. But you can still name the account anything you want. If your bank is not listed, then QuickBooks will not import transactions using that bank name, and you have to select a different bank. In the left column you should specify the QuickBooks account type, lookup the FID of the bank to import into, and specify the account number.
If you’re not sure which type of PDF you need to convert, see. For scanned, image-based, or encrypted documents, you will need PDF+, which comes bundled with 2qbo Convert Pro+ and pdf2qbo Convert+. 2qbo Convert Pro and pdf2qbo Convert will convert most downloaded statements, as downloaded statements are generally text-based PDF. MoneyThumb converters work with both scanned and downloaded statements. Not only can this save many hours of drudgery, but also reduce the chance of error associated with manual-entry bookkeeping. Both 2qbo Convert Pro and pdf2qbo Convert allow you to take a PDF bank statement and import the transactions automatically into a QuickBooks®-ready QBO file.