Unable To Import Iif Files Into Quickbooks

I've been unable to upload the transaction from a CSV format into Desktop and even when I purchased the QBooks support agreement, the people at QBooks were unable to help me and even recommended I manually enter them one at a time - not much help. I’m an old dude and I don’t trust my data and applications to some else’s platform. QuickBooks Desktop has to be not older than three years to import. Save the file. Before you import any IIF file, easily created by the Converter or any file, not just IIF file, make sure your backup your Quickbooks Company file: make the copy, backup, do what Quickbooks tells you to do. You will see in this example that Seth's information was brought into QuickBooks. This will create a. (NOTE: The Expert Analysis option has been removed with version 2007) Add or use credit card processing. An IIF file is a QuickBooks format file, but it can be viewed in MS Excel. iif Files From Quicken? Dec 29, 2004. System Requirements. Simply: it is complicated to use because it requires an entirely different software product for payroll (Aatrix), and it requires lots of customer support since neither the software or informational booklet are not terribly user-friendly. Although IIF import files are often created using a spreadsheet application like Excel, Import from IIF and Import from Excel are distinctly different utilities. Time Guardian will enter a default value in the Export To field. Most people process credit cards in real time inside of Zen Cart using a payment gateway, so it is not necessary for QBI to import this. Manage service keys (buy additional user licenses or sync license data online). It imports but into two different - Answered by a verified Tech Support Rep We use cookies to give you the best possible experience on our website. An easy way to Import,Export & delete your transactions in QuickBooks Desktop. Open QuickBooks and try again to your file export to excel. Using the export files created with the CS QuickBooks Data Utility, you can import all data and transactions into Accounting CS. Then make sure to select the QuickBooks Online for the Format choice. At the File Menu, click Utilities > Import > IIF Files. >onto excel spreadsheets and send them to me. You can import Bills from text files or Excel spreadsheets directly into QuickBooks Online using Excel Transactions software. The accountant cannot take the file to his office and work in the file and later merge changes into the business owner’s file. You can select the lists you want to move to your new QuickBooks Company File. the reason being an can import the file. Shows how easy it is to import IIF files into QuickBooks Online with our IIFImporter. Import Selected types (i. Many of our clients are using TrackerSuite. ago to troops) on its land and anywhere possible," said the speaker on boost global growth and lift nullions out of poserry. You can enter the data directly into QuickBooks ORYou can add code to your IIF file to import this data for you. Click here to try sharing files with clients and colleagues for free! Citrix ShareFile: Securely Sync, Store and Share Files. Note that GnuCash for Android is not a port of the GnuCash program to Android. Updated Added General Configueration setting to completely disable the masking of PII in Driver and Personal Screens; CMS Version 4. Export to QuickBooks Select to create an IIF file for this invoice only saved to your default downloads folder. Key Features in QuickBooks Pro and Premier Editions. If you are unable to open the file this way, it may be because you do not have the correct application associated with the extension to view or edit the DES file. Import a file into Business Contact Manager - Outlook (. Unable to Import QBO credit card statement - QuickBooks Quickbooks. We are the top-rated Quickbooks Consultancy Service Provider in North America. Manage service keys (buy additional user licenses or sync license data online). iif file suitable for importing into Quickbooks. I'm attempting to edit my bank downloaded monthly statement Quickbooks IIF File in excel as text tab delimited and edit the banks generic entry names to my actual account names in Quick Books so when I import the. Transfer this file to your QuickBooks machine and run File/Import and select that file as the source. Go back into quickbooks and import the. Instead it will give you multiple line errors and tell you that your data was not imported. resolution the matter of batch printing of checks 6. 1 pc/MRP manual. An IIF file is a file format that can be uploaded into the venerable desktop version of QuickBooks. WaspTime : Importing a Quickbooks employee list - Getting an erro. I’m an old dude and I don’t trust my data and applications to some else’s platform. Alex, It depends on the type of report. It essentially was the first way to export data from, and import. 9 from a usb drive i also copied the lmr. We do offer some easier to use macros and templates for IIF importing as well. When you close an accounting batch, you are asked if you want the exported file in IIF or CSV. csv file into QuickBooks. Export from Quickbooks. Quickly and easily convert your bank statements or other QIF files to importable IIF files for QuickBooks. I'd rather edit the *. I’m an old dude and I don’t trust my data and applications to some else’s platform. Project to Convert QuickBooks QBO files to IIF. At E-Tech, our experienced in-house engineers are committed to solving your Quickbooks Migration and Data Recovery needs in a professional, timely, and affordable manner. Let us guide you to the quickest answer or QuickBooks expert. Intuit Interchange Format (iiF) files are ASCII text, TSV (tab-separated value) files. I am trying to figure out what !SPL column heading in the IIF file needs to be to map to the BOL_Number custom field. The base of this project was a former Code Project article: Importing CSV Data and saving it in database. On the "Application Certificate", choose the 3rd option down. The correct spelling and placement of these file headers are required to prevent errors during import. Any entry that doesn't follow the rules will not be saved. Enter vehicle mileages. An easy way to Import,Export & delete your transactions in QuickBooks Desktop. Backup and restore QuickBooks company file in from External disk storage or flash drive - How to Guide. I need help with converting an Excel General Ledger to an iif file to import into quickbooks - Answered by a verified Tech Support Rep We use cookies to give you the best possible experience on our website. It can also make sense in certain high volume situations where very large numbers of transactions are imported on a regular basis, because the cost of designing the import routine can be spread. Choose File, Select import Text file. QIF to OFX/QFX/QBO Converter | Big Red Consulting Big Red Consulting. The Spreadsheet Import Wizard makes it easy to import your QuickBooks clients' account balances from a spreadsheet file created by QuickBooks Pro (including the Premier Accountant and Enterprise editions for versions currently supported by Intuit) or QuickBooks Online. For some context, 18 plus years ago when I did QuickBooks technical support, customers would. qbo files directly into QuickBooks. You are trying to import QBO file from a US bank to a QuickBooks Canadian edition or vice-versa. if your QuickBooks copy is three years old (for example, for current 2019, QuickBooks 2016 or earlier (or QuickBooks enterprise 16 or earlier), it will not import. I downloaded the sample iif file from the Quickbooks site and when I try to import it, my Quickbooks 2001 Pro crashes. You will be prompted to select an IIF file. When you use our two-click conversion utility, importing to QuickBooks has never been easier. For more information about setting up access to your online company file, see Set up user access. Generally one does not import excel files into quickbooks. Now we switch to Quickbooks. In crisis but a deal could sutll be done. Importing from an MS Excel worksheet. ButtonText: Ignored (used only for the Macintosh version of Excel). This post and accompanying video will demonstrate how to do that. QB does not allow for import of an excel or. A QuickBooks import file is simply a tab-delimited text file with an. The price is $17. This differs from creating a journal entry in an. Some Background we are an online company where we sell products online, my client wants to import all products into quickbooks and every online sale into quickbooks as well, our website is built using ASP. You can also manually send an invoice when a customer requests it, you want to send an invoice for an unpaid order, or if you are not automatically sending invoices upon successful payment. The Account details of QuickBooks Transaction don’t match the account details in accounting CS. It’s called the Import Data Wizard. However, these values change based on your Quickbooks version/configuration. You can do this manually or you can generate an IIF customer file in TutorPanel and import it into QuickBooks. Reporting and Preventing Identity Theft and Additional Information and Resources. ) We have a dilema with the ap invoices in the respect that the file layout for the. To fix this problem, the accountant should locate the transaction in the Accountant's Copy working file (. csv file to eZ Credit Card Import, it says that my file does not contain any transactions. Tab-separated values file. Convert a CSV file to IIF and import into QuickBooks ; Convert a CSV file to QBO format and import into QuickBooks. Transfer this file to your QuickBooks machine and run File/Import and select that file as the source. Good luck. If you need assistance importing lists or transactions into QuickBooks, email us: [email protected] WinZip or StuffIt Expander is required to unzip the zip file. Note: You will receive a notification stating the number of transactions that will be imported. When importing an. Create Calculated Columns in Power Pivot in Excel – Instructions: A picture of a user creating a calculated column in the data model window of Power Pivot in Excel which contains a formula that uses multiple functions. Import your data from text, CSV, Bento and more. If your QIF file has categories as your expense/income transactions in Quickbooks, use Bank2IIF for quick conversion from QIF to IIF. As far as I know you cannot do it in QB (so I dumped QB a few years ago). It can be then printed out and sent to the Supplier. The manual for pc/MRP is broken down into five sections: Standard Modules, Accounting, Utilities and Configuration, Optional Modules, and Trouble Shooting. We will use a simple CSV file with debit and credit transactions. (NOTE: The Expert Analysis option has been removed with version 2007) Add or use credit card processing. Add Your Excel Data to QuickBooks Utility 124 Importing an Intuit Interchange Format File (IIF) 129 Reporting on Lists 132 Finding and Fixing Chart of Account Errors 132 QuickBooks Required Accounts 133 Making an Account Inactive 133 Merging Duplicated Accounts 134 Modifying an Account in the Chart of Accounts 135. The only way to go is with LinkBooks. Virtual TimeClock will be updated with the personal information from QuickBooks if a matching social security number is found. Then this data file is transmitted to the accountant by the client. Importing In order to import the GL file into Quickbooks, first open your company file. IIF file again. IIF files have been deprecated, and officially unsupported, for 10+ years now. To make a funny man a better actor takes brains as well as balls. QuickBooks can import XLS, XLSX and CSV files from Microsoft Excel and will allow you to customize the process by choosing how to handle duplicate data or potential errors. At E-Tech, our experienced in-house engineers are committed to solving your Quickbooks Migration and Data Recovery needs in a professional, timely, and affordable manner. quickbooks manual pdf 2012 When I try to print paychecks using Payroll, Im receiving an Adobe Reader not found error, even though I have Adobe Acrobat Pro installed. You can register to use the batch upload option or break the file into smaller files and upload multiple files in INtax. Since you cannot undo an import, you must backup your company file before proceeding. QBY) attached. This means that you could be in the Botani-cal Gardens, on the seawall, travelling in your vehicle and be able to access the internet. Click on the import tab and browse to the file that contains your invoice data that you would like to import. QuickBooks 2003 and later support the. xls file extension and that didn't work, tried linking vs. See the easy import, install and authorization in QuickBooks Online. You could then add this new calculated column into the desired section within a PivotChart or PivotTable to group by its values. Avoid import glitches when bringing Excel data into Access by Susan Harkins in Microsoft Office , in Software on September 1, 2009, 5:03 AM PST. If you need to transfer some data from your company's database to an Excel spreadsheet, exporting the database to a CSV file and then importing the CSV file to Excel is the first option that comes to mind. In the Import dialog, select the IIF file to import, and then click the Open button. To activate an Excel add-in. IIF import supports both lists and transactions. Once you have modified your CSV file to fit the IIF format, in QuickBooks select File, Utilities, Import, and then IIF Files and "open" the file. I have a client who wants to transfer their current chart of accounts into their new Quickbooks 2014 desktop company file. Before importing transactions, you need to set up Accounts, Items, Names and Sales Tax Items and Names. Instead, you will see a warning message so you can fix the problem. iif files into QuickBooks. In the IIF file, we indicate the type of account transactions are posted to. Excel Linking Excel Linking enables your company to download ClickTime data directly into your own Excel spreadsheets. Some Background we are an online company where we sell products online, my client wants to import all products into quickbooks and every online sale into quickbooks as well, our website is built using ASP. To learn more, see Import data into Quicken. I’m an old dude and I don’t trust my data and applications to some else’s platform. Learn how to do just about everything at eHow. While Intuit provided 3 rd parties with detailed instructions and an import kit, including samples of IIF data, there was essentially nothing to enforce strict compliance. In QuickBooks, go to File>Utilities>Export>Lists to. )(By Company Name) or the QuickBooks 2002(U. Importing QuickBooks Data from IIF. And afterward rename the document. No need to manually remove remove these entries from the IIF file. txt, etc) is associated with a specific program to be used as the default program to open that type of file. After you publish a paginated report, it is a report item stored on the report server or SharePoint site. I would love one report but multiple reports are ok. Using the QuickBooks IIF utility to export and import files makes transferring data between QuickBooks files fast and easy. New! Multi-Monitor Support. Only a QuickBooks administrator can approve this certificate. If you want to ignore this recommendation and export to an IIF file anyway, you'll have to write your own formatting routine once you get ahold of the data, either using the. Guru specifically allows users to import an IIF file into QuickBooks Online as one or more journal entries. If QB online offered the same features we would have moved immediately" Ray writes - "I did not opt for the cloud version (on-line). The IIF file format, Intuit Interchange Format is a proprietary text file used by Intuit's Quickbooks software for importing and exporting lists and transactions. Unable to retrieve company file after closing it Quickbooks Pro 2005 without upgrade. If you need to import investment or business data, we recommend that you use QIF import instead. Open the old file. Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for open xlsx license key is illegal. When to Manually Import Transactions Into QuickBooks Online Using a CSV File If you were not able to locate your bank or if you need to download more than 90 days of banking transactions, then it is important for you to understand how to import your banking transactions using an Excel format called. Customers 2. Click okay in the above screen and QuickBooks will ask you for a name and a location to save the file. Use CSV2QBO to recreate QBO (Web Connect) file importable by QBs. Always make a backup of the file into which you are importing the data in the event that there is a problem during the transference operation. IIF file, however you get an identical result. Click 'Yes', whenever this QuickBooks company file is open". I have a client who wants to transfer their current chart of accounts into their new Quickbooks 2014 desktop company file. It's awesome and has helped our business grow and that growth is less painful than before. I feel like this is a QuickBooks issue. Once this is done, go back into day end and re-save. Convert contacts from excel to VCF and import vCard into. Other related. in addition, you agree to waive the right to participate in a class action or litigate on a class-wide basis. QuickBooks displays a prompt stating that the data has been imported. The technology was developed originally to interface with any data source, not just SQL. Of course this applies to accountant, someone who is Currently, QuickBooks Desktop is unable to support. Learn how to do just about everything at eHow. The details that are used by the QBO file is either incomplete or invalid, as the QuickBooks is unable to comprehend data from the. And of course, Math and Project level options, and lastly, some Text level, depending on whether I want to analyze a text string or not. Highlight the filename, then click "Open" to import and copy the information from the sole proprietor company file into the new S Corp data file. Best part:. 25% of the time, the import IIF works fine. Russell writes - "We did investigate but we must import Invoice Data and they do not support importing IIF files. Troubleshooting the errors that are general and specific in nature 4. Import a file into Business Contact Manager - Outlook (. When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this. Must enter a customer name when importing. QBO file is from a Canadian bank and you are trying to import into QuickBooks US edition. Currently, I import the file into one worksheet and cut/paste the rows manually into new worksheets/tabs. Once you are able to get this sample file to import successfully you can sent it to [email protected] The suite includes ETL , OLAP analysis , metadata , data mining , reporting , dashboards and a platform that allows you to create complex solutions to business problems. When unauthorized access is. Dates in Canada are usually listed as dd/mm/yyyy so Canadian QuickBooks sets the date default as dd/mm/yyyy but TeamUnify places the date in the IIF file as mm/dd/yyyy. qbo web connect format supported by QB. Causes of QuickBooks Unable To Verify. If it is a complex IIF files issue or you are unable to solve the issue, you may contact us by clicking here or by using other IIF files support options. Quickbooks learns your matches and uses them for next QBO import or direct bank download. QBY) attached. Next time you export from QuickBooks to Excel, remember to use the Advanced Export options. Additional Information: When importing the IIF file, if the customer is not added to the Project setting, QuickBooks® will create the Project as new under jobs as customers. This is because the image block in the email builder was unable to interpret the "EXIF" data of your image. Top Ten QuickBooks Tricks and a Few Secrets 6 Trick 3: ENTRY OF DAILY SUMMARY SALES REPORT Many businesses use cash registers or other daily sales logs and enter their sales into QuickBooks on a daily basis. If you enjoyed this tutorial, I have another article related to importing transactions from excel into QuickBooks, that you may like. The conversion utility can quickly and easily convert any QIF file into an IIF file, making the management of your finances simpler and less time-consuming. Date: 1/4/2019. I cannot seem to import the corrected file. Our eZ Import products are more than just file converters, they are an integrated application with QuickBooks. Hello, this is video to show how to a CSV or Excel file to QBO format and import into QuickBooks. Setting the Summit Export Path Log into Summit’s Administration Module Go to the System Paths Tab. Shows how easy it is to import IIF files into QuickBooks Online with our IIFImporter. It may have become damaged the last time it was in use, or it may have been damaged due to some form of corruption on your hard drive where the file is stored. Make QuickBooks more than just an accounting system by integrating other ODBC compliant applications with it to increase productivity and profit. Import invoices into QuickBooks Online. Do not use it. Import your data from text, CSV, Bento and more. For some context, 18 plus years ago when I did QuickBooks technical support, customers would. Use File menu > Utilities, Export Lists. When you run the reports by date or a quick report you will not see the breakdown because the dates are incorrect. This wiki contains documentation and information for the Pentaho Open Source BI Suite Community Edition (CE). One can export lists (accounts, vendors and customers) into. Note: You will receive a notification stating the number of transactions that will be imported. Specify a location, and save the file. Another issue that you have to be aware of is that IIF isn't always the most reliable method of importing data. invoice) in the single row CSV format you need to create three or more rows in IIF format. the reason being an can import the file. Change the file type field in the bottom of the window to All Files. Unable to Import QBO credit card statement - QuickBooks Quickbooks. To convert your data Quicken data (Windows or Mac) can be converted to QuickBooks using the data converter built into the QuickBooks software. I am using Quickbooks Premier 2011/12 and have an issue when importing data from our wages program, Wage Easy. iif file into. Use the Import Wizard Transaction Pro and import TXT or Excel compatible files. The manual will become an invaluable tool while you are learning. (or maybe I should say we are trying to. To enable multi-user mode, go to the File menu in QuickBooks and choose "Multi-User Mode. DBF Converter Business & Productivity Tools - Database Management, Shareware, $39. Zachary Systems' eZ Import products will import your. In it you will find details of the file format along with example IIF files. Boxes can be used to display things like location info, store hours, pictures, ads, etc. Then select the file menu at the top left of the menu bar. Setting the Summit Export Path Log into Summit’s Administration Module Go to the System Paths Tab. Invoices, Sales Receipts, Bills, Payments, Checks, etc. The QuickBooks iiF file format has been around a long time. I cannot seem to import the corrected file. Using QuickBooks Pro to track inventory can provide ways for business owners to keep accurate and up-to-date records detailing quantities, cost and resale revenue. WaspTime : Importing a Quickbooks employee list - Getting an erro. Note: Unlike QuickBooks Desktop, QuickBooks Online does not have a facility for importing the sort of export files exported by DONATION, IIF files. Save the file. Currently, I import the file into one worksheet and cut/paste the rows manually into new worksheets/tabs. To fix this problem, the accountant should locate the transaction in the Accountant's Copy working file (. If you are unable to open the file this way, it may be because you do not have the correct application associated with the extension to view or edit the DES file. It essentially was the first way to export data from, and import. Since you cannot undo an import, you must backup your company file before proceeding. 4) QuickBooks Journal Entries (. I think what you want are. A macro multiplies a cell value and returns 1. When you use our two-click conversion utility, importing to QuickBooks has never been easier. Specify a location, and save the file. Columns align in Excel so I don't believe that I have fields out of place. And of course, Math and Project level options, and lastly, some Text level, depending on whether I want to analyze a text string or not. When I upload my. Use the import function of the “Get & Transform” tools. Note: The export file from QuickBooks must have an extension of. As such I am at a loss as to the required format of the iif file for importing general journal entries. If the File Download dialog box appears, do one of the following: To start the download immediately, click Open. It provides a XML/COM interface directly to QuickBooks that is very well documented and reliable. Another issue that you have to be aware of is that IIF isn't always the most reliable method of importing data. QuickBooks displays a prompt stating that the data has been imported. QuickBooks 2003 and later support the. It is relatively simple to create a Memorized Sales Receipt template to record daily sales. Later when you purchase use your product key to unlock the trial. QuickBooks 2011-2012 occasionally will not accept an IIF file. Importer Import data and eliminate manual data entry. Import your data from text, CSV, Bento and more. I'm creating an application that can export an. White Papers. When importing an. A Python utility to convert QIF files to IIF files. You will see in this example that Seth's information was brought into QuickBooks. Simply select File, then from the pull-down menu select File Import, and then Web Connect File … This will bring up the standard File Open dialog, select the file, and then select Open. You can use my php script to convert that xml into either an IIF or a QIF file which is used to import into quickbooks or quicken small business. Oct 23, 2019 12:05 AM Training and Live Events. File, pay, register, and more. 78 is required for importing back into Quickbooks. Installing and Upgrading QuickBooks 2 Converting your file from QuickBooks for. The old, original Undeposited Funds account is renamed "*Undeposited Funds" and contains a balance of zero. It’s called the Import Data Wizard. customer, vendors, items, etc) but now transactions (i. This the usual error that the QuickBooks user's face is that can't meet with the corporate file, due to the unauthorized access. Guru Importer specifically allows users to import an IIF file created in the standard "General Journal" format, into QuickBooks Online as one or. Both programs are available for free in Mac and PC formats. qbo web connect format supported by QB. Quickbooks uses. Select OK to confirm your data was imported. PHONE2 – phone number 2. Learn more today. IIF Importing Receivable Customers into Maitre'D Improve Update of Custom Reports on other Servers Improve Windows POS Graphic Screen Refresh. QuickBooks was exporting the line into the IIF file and could not complete the operation due to the low memory or not enough disk space Problem exporting lists. This does not affect any other accounting file export setup. Various aspects of your QuickBooks company file can display duplicate entries because of inconsistent methods used to enter data or, in some cases, known bugs within the software. From the QuickBooks Account drop-down, select the account to which to import. Step 2: Import your Invoices into QuickBooks **Remember to backup your QuickBooks files prior to this step if you have not done so already. How do I create an iif file from a csv file? I would like to create an iif file to import a csv file to a JE? How is this done? How do you convert a csv file to an iif format? I have 300 lines of data to enter each month to post job costs that I now update a memorized JE. This box is a note. 4) QuickBooks Journal Entries (. We are a forum for professional accountants and tax advisers to discuss accountancy and taxation, but we also welcome individuals and business users who have queries relating to these matters. QuickBooks Direct Transfer (XML) - Accounting data exported directly into your QuickBooks company file. to forestall this from happening, we tend to advocate that you just either import the Chart of Accounts IIF file before commercialism the transactions, or that you just. So far as I know, you cannot directly import q qbxml file into QuickBooks. Step 1 Click "Utilities" under the File menu, and select "Import" to open the File Import wizard. The conversion utility can quickly and easily convert any QIF file into an IIF file, making the management of your finances simpler and less time-consuming. To support QuickBooks’ requirements to migrate away from the traditional IIF format we have separated these in the Accounting Package listing. The tool converts an excel Purchase Requisition into an IIF file that can be imported into Quickbooks Desltop as a Purchase Order. There is an area in Apptivo where we can map the account names like "Sales Tax Payable" to the shortened names QB requires like "OCLIAB". When importing an. To use this method you must first create the IIF format to use for the import. You're unable to import IIF files in QBO. The download is a pdf file. You’ll see how easy it is and you’ll be amazed at the time that you save. Later when you purchase use your product key to unlock the trial. QuickBooks has an IIF import kit that you can download. csv file from the Select Import File window, you will be prompted by a Getting Started with Excel and CSV File pop-up message that will tell you how to format your. I read that this can be done but I have not tried it. The QuickBooks administrator can grant access permission through the Integrated Application preferences. Exporting OK but not importing I find it very useful to be able to import data into Sage using csv files (often converted from Excel files). QuickBooks Online does not support importing IIF files, which is what Salsa CRM. How to integrate Online Banking in QuickBooks ® with Direct Connect. it is onle 60 orders so not too big of an issue although it is over 2000 units that have been sold so it does have an impact on inventory. In this video you'll learn about *Exporting and Importing Limitations *Steps to export the file *Edit the exported file *Import. Learn how to import and export Intuit Interchange Format (IIF) files to and from QuickBooks Desktop. However, without a tool like Guru Importer an IIF file cannot be imported into QuickBooks Online. I ma trying to import a. Using VBA to create import files for QuickBooks A couple of years ago I created some spreadsheets to help me migrate data into QuickBooks. Certain import fields within AccountRight do have length expectations, and if there isn’t enough information then AccountRight does increase the number. Importing invoices into QuickBooks using AutoIt Script For several years I have successfully used the QuickBooks IIF format to import bills, checks, and employee hours. I'm attempting to edit my bank downloaded monthly statement Quickbooks IIF File in excel as text tab delimited and edit the banks generic entry names to my actual account names in Quick Books so when I import the. The problem we are running into on the Purchase Order form is that the “Description” field size is 29 but the “Part Number” field appears to be unlimited in size.