2xls Convert Pro Help File

Contents

2XLS Convert Pro
Contact Information

2XLS Convert Pro

This Help file covers 2XLS Convert Pro, 2XLS Convert Pro+, and the PDF+ AddOn for working with scanned documents.

Getting Started

2XLS Convert Pro is an integrated financial data translator to extract financial transactions from downloaded PDF bank statements, .qbo, .ofx, .qfx or .qif files and convert them into XLS format suitable for any spreadsheet. 2XLS Convert Pro+ adds PDF+, MoneyThumb's integrated text recognition module to handle scanned PDF statements. See the section on Working with Scanned Documents and PDF+ for information regarding PDF+.

Use 2XLS Convert Pro to import transaction data into a spreadsheet program such as Microsoft Excel® or Google Sheets™.

To get started first set your account type, language information and date formats with the Settings button. Then either drag and drop your PDF file into the converter drop zone or select the Convert button to choose a file to convert. This will bring up a standard file chooser, and allow the selection of .csv, .pdf, .qif, .xls, and .xlsx files. There are three action buttons, plus the cancel button, at the bottom of the file chooser. One of more of them may be grayed out depending on which type of file is selected. Use the Preview button to preview how .csv and .pdf files will convert, and to assign and verify which column is which before doing the import. Then select Create xls to create the output file. Once you have converted a file with Preview mode, use the Convert to xls button to do one-step conversion of similar .pdf files directly to XLS format, a native Excel file with a .xlsx extension. You can also use the Convert to csv button to convert .pdf, .qbo, .ofx, .qfx, or .qif files into CSV format for intermediate editing.

Whenever opening a file from a different bank or that has a different style, first use Preview Mode to verify the column setup. When in Preview Mode, use the pull-down list at the bottom of each column to select the correct type of information in that column. Be sure to select one Date column, one Payee column, and either one Amount column or both Credits and Debits columns. If you have a balance column, the column selection should be blank (to ignore it). You can also choose which transactions to convert. See more about Preview Mode below.

If the 2XLS Convert Pro log has an entry that the conversion did not find separate credit/debit sections, then check the plus/minus sign of the entries in the Preview window. If they need to be flipped, then select the checkbox for Switch signs of amounts on output and the amounts will be correctly output to your XLS format file.

Select Create xls at the bottom of the Preview Screen to finish the conversion and create your .xls file. Run subsequent conversions of PDF statements from the same bank with Convert, select a file and then Convert to xls.

Installation

- Microsoft Windows® full install
  - Download 2XLSPro.exe for Windows, save the file to your computer, and run the installation program by double clicking the file.
  - If you do not have have Java installed it will be automatically downloaded during the installation.

Mac OS X® full install
- Download 2XLSPro.dmg for Mac OS X, save the file to your computer. Locate the file in the download area, open it by double clicking, then and run the installer.app by double clicking it.
- If you do not have have Java installed it will be automatically downloaded during the installation.

Entering License Information

Enter the license by copying the license string (CTRL-C) from the confirmation e-mail and pasting it (CTRL-V) into the converter license dialog. To enter the license string manually from within the program select the License button, and paste (or type) the full license code into the dialog.

After you enter your license, your license email will be shown in the program title bar, and in About.

Running 2XLS Convert Pro

On Windows or Mac OS X, double click the 2XLS Convert Pro icon on your desktop.

You may also run 2XLS Convert Pro from the Windows Start Menu, or run 2XLSPro.exe on Windows or 2XLS Convert Pro.app on Mac OS X.

Settings

Use the Settings button to bring up the Settings Wizard or the full Settings dialog. The Wizard will ask questions that cover the vast majority of conversions. The Settings Dialog contains additional advanced options. You can switch back and forth between the Wizard and the full dialog.

PDF Settings

PDF Password

If your PDF statements have a password that you need to enter in order to view them, then use the setting for Set PDF Password. The password is not saved for security reasons, so you need to enter a password each time you start 2XLS Convert Pro. However, if you are converting multiple statements that require the same password, the password will be applied to multiple conversions in the same session.

PDF Page Range

If your PDF statement has multiple accounts (such as a checking and a saving account) you can restrict the pages converted so that only a single account is processed. Enter values into the dialog for Only Convert Pages from ... to to specify a page range. The first value is the page number of the first page to convert, the second value is the page number of the last page to convert. All other pages will be ignored.

Year

Many banks simply use the month and date for individual transactions, with the year being elsewhere on the statement. 2XLS Convert Pro
determines the calendar year from other dates in the statement. If for some reason the year is not found correctly, this setting allows you to override the year which is used. For statements that appear to cross a year-end boundary, this value is the earlier year.

The Spacing Factor is for PDF Statements that have extremely wide or narrow text. 2XLS Convert Pro will automatically determine a good value, but if your initial conversion has extra spaces where they shouldn't be, or no spaces where they should be, this is a way to override the calculated value.

Combine multiple description lines into the payee name tells the converter to combine multi line transaction descriptions into a single (long) payee name, rather than taking the payee name from the first line, and the subsequent lines as the memo. This is useful if the first line has so much extraneous information (i.e. "check card payment made on Jan 1") that the useful payee name is continued to the second line. The resulting long payee names can be shortened with Payee Cleanup.

Allow transaction descriptions with only a number is used if there are transactions that have a 'description' that consists of only a number, such as an account transfer number.

Allow dates without any separator can be used for banks that use a month-day format of 'mmdd', without any space, dash, or slash between the month and day. Setting this option may cause non-date values such as check numbers to be interpreted as dates, so use with caution.

Select which account to process

This option is for bank statements that contain multiple accounts such as a checking account and a savings account. Select this option, and then which account in the statement to process, the first account, second account, etc.

Select which statement to process

This option is for PDF files that contain multiple statements, such as individual monthly statements. Select the checkbox for this option, and then which statement in the PDF file to process, the first statement, second statement, etc., or All statements.

When running All statements in a file, such as to process a years worth of statements in a single operation, when the columns found in a statement do not match the current column , then the converter will stop and enter Preview mode. If it is the statement, Preview mode will show an additional option Resume All. In this situation, select the appropriate columns then Resume will reprocess the entire file with the new columns. In general, it is recommended to test the first month in Preview mode to make sure that the column setup is correct. Please also see notes about multiple statements under Working with Scanned Documents and PDF+

Always run PDF+ text recognition (OCR)

(Only visible when PDF+ is loaded). Use this option when your statement may already have text from a previous OCR process. See the section on PDF+ for additional information.

Advanced PDF Options

These options provide a great deal of control over the PDF conversion, but must be used with care. They are designed to guide the PDF conversion, and improve accuracy.

These options use text strings to specify types of transactions or sections in the PDF Statement. These text strings all use a concept called 'regular expressions', which is extremely powerful, but admittedly hard to understand if you have never done them before. If one is trying to match a line like "Checking Account Transactions", then the regular expression is straightforward - it would just be "Checking Account Transactions". To match the remaining characters in a string use ".*" so that another way to match the previous line would be "Checking Account.*". A web site that has a reference, and enables you to enter the text from your PDF Statement and test regular expressions to ensure they do what you expect is at http://regexpal.com/.

The Advanced PDF Options dialog has many tool-tips and hints for the type of entry for each field. 2XLS Convert Pro has a large vocabulary of keywords used by banks to identify credits, debits, accounts, etc. but if the statement you are converting has something different, this is the way to provide that information to the converter.

PDF Section Identification Strings are used to identify sections in the statements and thereby decide whether a transaction is a credit or debit, whether a section contains a list of checks, or whether a section has balances and should be ignored. Multi-account Identification Strings are used if your PDF Statement has multiple accounts in a single statement, and you wish to limit the conversion to the transactions for one account. Page numbers are one way to limit which data is converted, but sometimes the accounts are not on page boundaries. Entries that should be Skipped strings are for entries that could be taken for a transaction, but should be skipped - things such as totals and balances. Once again, 2QBO Connect already has a large vocabulary of terms, but if your bank uses with something different, this is a way to quickly handle that.

The Text to remove from transaction Payees section has been supplanted by Payee Cleanup, but the description is included for backwards compatibility. This option enables you to remove extra text at the beginning of a Payee name and turn transaction payees like "Check paid to John Smith" into "John Smith" and turn "Check Card 0125 Staples" into "Staples". This greatly improves the ease of importing transactions into QuickBooks. Some examples:

To remove 'Check number" or "check #' use the text "Check number" or "check#' respectively.

To remove "Paid on " followed by a 4 digit number use "Paid on \d\d\d\d"

To remove "Paid on" followed by a 3-4 digit number use "Paid on \d\d\d\d?"

Some banks have lots of this text as a prefix, some have none. This option provides ten different strings that you can use to improve usability of Payee Names.

Language

Select the language of the PDF statement. This changes how 2XLS Convert Pro recognizes month names and keywords that help determine whether an amount is a credit, debit, or something else.

Date Formats

2XLS Convert Pro can read dates either in US format (month-day-year) or European format (day-month-year). Use the Settings dialog to select the date format that is used in your .pdf or .csv file.

In addition, when creating QIF or CSV format files, you can select whether the output file should have dates in US format (month-day-year) or European format (day-month-year).

Note that the date options are not applicable to .xls or .xls files as dates in those file formats are unambiguous.

Positive and Negative Charges

Normally bank statements will have charges as negative numbers and payments as positive numbers. That is what accounting packages expect. Many credit card companies switch things so that charges are positive - showing an increase in your balance - and payments are negative. Use the Settings dialog to select Charges are positive, Payments are negative (Switch signs) if this is how your CSV or PDF statement is formatted.

Assigned Column Names

Column names can be preassigned to your conversions. Whenever you use Preview Mode when running a PDF or CSV conversion, the column names are saved and automatically assigned to subsequent conversions. See the description of Preview Mode, in the following section. The current column names are displayed in the text box in this section.

You can also read predefined column setting from a CSV format file. 2XLS Convert Pro is shipped with a number of presets that facilitate conversion from popular CSV download sites, such as PayPal. To read presets select the Load Preset button, and use the open file dialog to open a csv file with the column names. A preset CSV file is just a single line of text with the column names separated by commas. You can also save the current displayed column names to your own preset file with Save Preset.

Saving and Restoring Settings

2XLS Convert Pro will always save all the settings from one session to the next. To save the settings for converting files for a particular account use the Save Settings button, and then Load Settings to restore all settings. This includes the account information, column information, and PDF settings. Settings are saved in a file with a .mthumb extension and may be saved in any folder.

Converting a File

There are two ways to select PDF, CSV, QIF, or XLS files to convert:

1. Select the file in your operating system file browser (Windows Explorer, Mac Finder), and then drag it into the converter "Drop Zone"

Select the Convert button in 2XLS Convert Pro to bring up the file chooser and select the file to convert.

2XLS Convert Pro can be run in two modes - Preview Mode and Express Mode. If you are just getting started, then use Preview Mode for reading .csv or .pdf files. If you have run 2XLS Convert Pro previously on a similar file and are sure that the columns are correct, then it's faster to use Express Mode.

Preview Mode

Preview mode is applicable when creating XLS format files from either PDF Statements or CSV files. Run Preview mode by either dragging and dropping a file from the file explorer or select the Convert button, select the file from the file chooser dialog, then select Preview at the bottom of the dialog.

This will extract the transactions from your input file and bring up a Preview window that displays the transactions which were found. At the bottom of each column is a selector that contains the name of the data in that column. It may have already been set correctly by 2XLS Convert Pro based on column headings in the input file. If it's not correct, use the pull-down to select the correct type of data. Each type can only be used in one column, so types that have already been used will be grayed out. If you have many columns, you can increase the width of the columns of interest by going to the header row and dragging the column separator to increase the width of the column, and of course drag a corner of the window to enlarge it as well. Use the Clear button to empty the column selectors and start over.

At the top of the Preview screen the account type is shown. If the account type is incorrect, then use the Set Account Info open up a subset of the Settings dialog where the account information may be modified.

Most credit card statements have the the signs of amounts reversed so that credits are a minus amount, and charges are positive. If separate credits and debits sections were not found, then the preview screen may show credits as negative. In this case the checkbox for Switch signs of amounts should be selected. This will ensure that debits and credits are correctly labeled in the XLS file, and imported correctly. If you have more than ten columns, the checkbox for Hide unmapped columns will hide all the columns that do not currently have a name assigned. This is very useful for files that come from PayPal or Stripe that have too many columns for them all to be readable.

Use the icon to bring up an image of the original PDF page with the selected transaction highlighted. This is especially helpful when touching up OCR typos.

The only required columns are the Date, and depending on whether the transaction amounts are in one column or two, either Amount or both Credits and Debits. If your statement has an Amount column that has positive amounts for both credits and debits then you also need to select a Type column that has the type - typically Credit/Debit or CR/DB. If your input file has a column for 'Balance', it should not be used - the entry in the pull down list should be blank since your accounting software will calculate that.

The Payee column is the downloaded payee name for import. You can also have the payee name duplicated at the start of the memo field by using the Payee & Memo selection. This is useful if you need to see more than the XLS limitation of 32 characters for the payee name.

The Number column is used for Check Numbers, if those are present in your input file. The Transaction ID column should only be used for credit card statements that have a unique reference number for each transaction.

When the Separate Splits option is set under Settings, you can specify which columns contain amounts that are to be split. Additional column names will be displayed for Gross Amount, Transaction Fee, and Refund Amount. For these columns, if there is an amount present, it will generate its own transaction, with a payee of the column name. You can also define your own split names by using the Split<> column name. This will prompt you for the name to used for amounts in this column. Additionally, you can force the amounts in a column to be either positive or negative amounts by specifying a plus or minus sign before the split name.

To create a Memo that combines two different columns choose Memo for the the first part of the memo, and Memo Add-on for the second part. The text from the two columns will be combined into a single Memo, with a space between the two text strings.

The column called Use determines whether the transaction will be processed into the XLS file. If you have some transactions that you wish to ignore, deselect the checkbox in the Use column. Use the checkbox at the bottom to deselect or select all transactions.

When the column names are correct, select Create xls at the bottom of the Preview window. The conversion will proceed, giving some statistics on how many lines were processed and create a .xls file with the same name as the input file. If a .xls file with that name already exists you will be prompted to overwrite it.

Preview Mode column settings will be automatically remembered, and will apply to subsequent Express Mode conversions. To clear Preview Mode, run a different file in Preview Mode.

Payee Cleanup

When downloading bank transactions, very often payee names will have extra information such as dates, phone numbers, chain store numbers, transaction type descriptions, and so forth. Use Payee Cleanup Settings to automatically remove that extraneous information. Payee Cleanup Options are normally accessed from the Preview dialog. The Cleanup dialog is side by side with the Preview dialog so that you can specify changes and instantly see the cleaned-up payee names. The cleanup filters will only affect the column selected as Payee or Payee & Memo at the bottom of the dialog.

Payee Cleanup Settings

Most of the filter options remove a specific type of text and should be self explanatory. You can also specify up to 100 phrases to be removed. Phrases can include wild cards. Use a question mark (?) to match a single character or an asterisk (*) to match multiple characters at the beginning or end of a word. Some frequently used phrases are in the hints for the first few entries. The best way to specify phrases is to start typing and see how each character that you type affects the payee names in the Preview transactions. If you have many payees you might want to expand the size of the Preview dialog and you can also scroll through the list of transactions while the Cleanup dialog is visible.
To remove phrases such as 'PayPal *' or 'SQ *' that prefix thea actual payee you can either specify a string such as "Paypal ?" or "SQ ?", or you can remove all special characters and specify a single word removal string such as Paypal or SQ. All phrase removal is case insensitive - for example PayPal, paypal, or Paypal will all remove the word paypal, regardless of how it is capitalized.

If you are familiar with regular expressions, you can also use regular expressions as a removal option. Start and end the removal string with a slash (/) to have it recognized as a regular expression.

Note that filters are applied in the same top to bottom order displayed in the dialog, so that for example a store number such as '#2032' would be removed before special characters, which includes the #.

Express Mode

Express mode can be used for all conversions, although it is highly recommended that whenever converting a .pdf file from a new source, you should first use Preview mode. Run Express mode by either dragging and dropping a file from the file explorer with the Ctrl key pressed (Command key on a Mac) or select the Convert button to bring up the file chooser dialog, select a file, and then Convert to xls.

You can also convert PDF, QIF, or XLS files to csv format by dragging and dropping with both the Alt and Ctrl keys pressed (Option-Command on a Mac), or by using the Save as csv button from the file chooser. Note that this conversion to csv is of the 'raw' csv representation of the input file, and does not include modifications such as sign change and payee cleanup. To save a csv with those modifications use Save as csv from the Preview menu.

2XLS Convert Pro will run, giving some statistics on how many lines were processed and create a the output file with the same name. If a file with that name already exists you will be prompted to overwrite it. When creating a XLS file, if the converter detects the the current Preview settings will not work with the file being converted, it will automatically enter Preview mode so that the column can be configured correctly.

You can also convert multiple files in a single step. This should only be used when all the input files are similar, for example a years worth of statements for the same account. Hold down the Ctrl key (Command key on a Mac) while clicking on file names to select multiple files one by one. Hold down the Shift key while clicking on file names to select all files between the first click and the next click. When you convert multiple file, 2XLS Convert Pro will also create a concatenated output file (either CSV or XLS) that contains all the transactions from all the conversions. This file will have the word "Concatenated" appended to the file name of the first file converted.

If you converted a PDF Statement to .csv format, the .csv file can now be read directly into Excel or other spreadsheet program to view or edit the data. If you created a .xls or .qif file, it is now ready to be read into your accounting application.

If you are reading a .xls or .xlsx file that contains more than one worksheet you will be prompted to select the worksheet to import.

Working with Scanned Documents and PDF+

This section is only applicable if you purchased 2XLS Convert Pro+ or the PDF+ AddOn. Running with PDF+ is virtually identical to running the normal version. In most cases the converter will recognize that the PDF statement does not contain readable text, and will automatically invoke the text recognition module. The main noticeable difference is that the text recognition takes much longer than files that don't need text recognition.

When scanning documents to be processed by 2XLS Convert Pro+ it is best to scan at a resolution of 300 dpi (dots per inch). Most scanners should have this as an optional setting. And obviously the cleaner and crisper the document scans, the better the recognition will be. A speck of dirt in the wrong place, such as making a keyword like 'Debits' unintelligible can throw off the entire conversion.

After text recognition and conversion, the converter will also automatically refine any transaction date or amount values that appear to be incorrect with Pin Point recognition, and redo the conversion. The number of values refined will be shown in the converter log. If there are still values that appear to be incorrect, the converter log will list the number of lines that should be manually corrected. If you are creating a CSV file, they will be identified in the CSV file with an extra column containing a double question mark - "??". Otherwise the converter will identify those lines in Preview mode. Those transactions will be highlighted in yellow, and will have the Use box unchecked.

You can then review the text in those lines, and edit them to make any necessary corrections. Edit like you would a spreadsheet - select the cell and then edit the text in that cell. Sometimes the highlighted lines may be extraneous text that is not a transaction, simply ignore those. If you do edit the lines to create valid values, check the Use box so that they will in included in the output. You can also edit any other text, and if something is missing, even insert a new transaction using the Add Transaction button. If you don't want to include a line, uncheck the Use box.

In the example above, there were a few transactions where the 'g' in 'Aug' was fuzzy and was recognized as 'a'. In this instance one should change those dates to 8/25/2012 and 8/27/2012, and then the statement will be completely correct.

If you are converting scanned documents that had text recognition done by other Optical Character Recognition (OCR) software then you can choose to either use the text from the previous OCR software or use the MoneyThumb's integrated PDF+ with Pin Point text recognition. The Settings option for Always run PDF+ text recognition (OCR) tells the converter to always use PDF+ text recognition. If that box is unchecked 2XLS Convert Pro+ will process those files using the searchable text created by your previous OCR. Always running with text recognition will take substantially longer, but will also generally get more accurate results than using the results from other OCR software. That is especially true when compared to free OCR software that may have come with your scanner.

If you are processing multiple statements in a single file with PDF+, it is recommended to use the Convert to csv option from the File Open dialog, rather than Convert to xls. This will create a csv file with the 'raw' csv data, and therefore avoid re-running the PDF+ conversion because of mismatched columns, or a large number of OCR typos that may need to be corrected. The columns can be aligned if necessary and typos corrected in Excel or another spreadsheet program. If you need to run Payee Cleanup on the transactions, you can do that when reading the edited csv file for conversion to .xls format. Processing in this way will ensure that the time consuming step of PDF+ OCR only needs to be run once on the entire file.

Lastly, there are also a few banks that create PDF statements from images and a very few who create PDF statements with an internal encryption. Bank statements created from images should automatically be processed by PDF+, since no readable text will be found. Statements with an internal encryption will generate unusable text, so , they can only be correctly processed by using the Settings option above. You can recognize these statements by copying and pasting text from your PDF reader to any editing program, and seeing random text characters rather than the text you copied.

Importing XLS files into your accounting software

The easiest way to import the .xls file is often to double-click it from Windows Explorer or Max OS X Finder. That assumes that your accounting software has installed itself to be the application which opens XLS file. Otherwise you should use the menu system in your accounting system to import the XLS file. That will be somewhat different for every accounting package, and you should refer to the documentation for your software.

Troubleshooting

Error Message: "No text found in the PDF file"

This error generally means that the PDF file is a image file, not a text based (or searchable) PDF file. Image PDF's are created when scanning, or a small minority of banks create a PDF statement with a few images rather than text. You can verify this by trying to select a line of text while viewing the PDF file in Adobe Acrobat. Depending on the type of PDF file, the selection are will either snap to a line of text, or just be a rectangle following the cursor.

It is also possible that the PDF is encrypted; try to copy/past text from Acrobat to any editor and if the text does not paste correctly, then the PDF is encrypted. In either case you will need 2XLS Convert Pro+ with text recognition in order to process this file. You could also use other OCR software, although MoneyThumb's PDF+ is unique in being optimized for recognizing financial transactions.

Error Message: "No transactions found in the PDF file"

This error can be caused by anything from the converter not working correctly on your bank's PDF file to a PDF file that has internal encryption or images that makes it impossible to convert.

A quick test is to verify whether the text in the statement is extractable. Open the statement with Adobe Acrobat, select the text for a transaction, and use Edit, Copy to copy the text to the clipboard. Open any kind of text or document editor (i.e. Notepad, Word, TextEdit, Pages) and paste the text into the program.
If the text does not paste correctly, then it's an image, or somehow encrypted, and the statement can only be processed with 2XLS Convert Pro+. You may need to turn on the Settings option for Always run text recognition (OCR).

If text was processed, there should be a line in the log like "Found 100 lines with a date, 90 lines with a currency value, 80 lines with both." If this line is missing or the number of lines found is much lower than expected, then the statement has spacing, date, or currency formats that are not being recognized. You would need to send the file to MoneyThumb for further investigation.

If date and currency values were found, then the formatting of the statement is likely causing a problem. If your statement has multiple sections for different accounts, that can sometimes cause confusion. It can often be corrected by only processing pages for one section of the file at a time. Enter values for Only convert PDF pages from .. to .. in the lower right of the Settings menu. You can also use the Advanced PDF Options under Settings to enter the header line for each section and specify start and end of the conversion process more exactly.

If transactions are still not being found, you would need to send a test file to MoneyThumb for further investigation. We can send you a procedure to remove you personal information from the PDF statement.

Warning Message: "No separate credit/debit sections found. Verify plus/minus sign of amounts"

If the 2XLS Convert Pro log ends with this message, then 2XLS Convert Pro was unable to find distinct sections for credits and debits in the PDF statement. If your PDF statement has plus and minus signs, then you should check that they are correct and if not, use the Switch sign of amounts setting in the top right of the Preview dialog to switch all credits and debits. If you are running multiple statements from the same bank, use Settings to set the switch signs option for all conversions. If all your transactions are positive numbers, then 2XLS Convert Pro was unable to recognize the sections correctly. If your statement does have distinct credit/debit sections, then you should use use Advanced PDF options to specific the text which identifies the start of the different statement sections.

Another workaround is to run 2XLS Convert Pro twice; select all the credits the first time, and then the debits, switching the Switch sign of amounts checkbox so that the transactions are positive on the first run and negative on the second. Select the checkbox under the Use column to choose which transactions will be processed. The checkbox at the bottom of that column will select/deselect all transactions.

Lastly, PNC customers should check the option under Settings for Process statement as a single currency column.

Warning Message: "Credit/debit columns not identified. Verify plus/minus sign of amounts"

This warning is similar to the warning above regarding credit/debit sections, but 2XLS Convert Pro did find separate columns for credits and debits, just could not determine which is which. Therefore, you should simply ensure that the debits and credits columns are identified correctly in Preview mode. If the columns in your statement do not distinguish credits and debits, then you should use Advanced PDF Options to specify the credit/debit sections as above.

Transactions have an incorrect year

Most bank statements don't have the year on individual transactions but have the year in the statement date. This is normally picked up by 2XLS Convert Pro. However if the statement date is not present or there are other dates found in the statement, sometimes all the transactions will have an incorrect year. To override the year value found in the statement, specify a year in the Settings menu, using the Year value on the lower right. If you specified a year and are getting incorrect results, note that for a statement that appears to cross the year boundary in any way (even an old balance) specify the year in the month of December. Generally the converter works best if you leave the year override blank.

Multiple Accounts in a singe file

Because a .xls file can only contain transactions from a single financial institution, 2XLS Convert Pro will only process the first account found in a PDF Statement when creating a .xls file. To process other accounts in the PDF Statement, use the Setting option for Select which account to process and select the appropriate account - first, second, third. etc. Or select Only convert PDF pages from .. to .. to restrict the portion of the statement which is processed. The advanced PDF options for Start Account and End Account can also be used to restrict what part of a statement is processed.

Saving the 2XLS Convert Pro Log

After 2XLS Convert Pro has run, you may wish to save the log information to a file. Select the Save Log button. This will bring up a File Save dialog. Simply specify a file name and select Save.

To clear the log information select the Clear Log button.

Contact Information

please reach out to us at www.moneythumb.com/support.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

# of Licenses	Discount
2	20% (That’s 40% off the second seat!)
5	25%
10	30%
50	35%
100+	Contact Us