![import transactions into quickbooks pro from excel import transactions into quickbooks pro from excel](https://i.ytimg.com/vi/tts6jFrWlIc/maxresdefault.jpg)
The import data should include either the Account Name or Account Number but not both. It must match QBO exactly (spelling, punctuation, capitalization, spacing, etc).
![import transactions into quickbooks pro from excel import transactions into quickbooks pro from excel](https://i.ytimg.com/vi/W75EqEiIt9o/maxresdefault.jpg)
At minimum, data should be mapped or given a static value for the following fields:ĮXPENSEACCOUNT: This is the Expense Account in QBO. If posting to an Expense Account, data will be mapped to the Expenses fields. A Bill can contain both of these detail types on the same Bill but not on the same data row. There are two detail options for Bills in QBO: posting to General Ledger Expense Account or posting to an Item. If nothing is imported for either of these fields, QBO will use the default Term assigned the Vendor to calculate the Bill’s Due Date.
![import transactions into quickbooks pro from excel import transactions into quickbooks pro from excel](https://lithium-response-prod.s3.us-west-2.amazonaws.com/intuit.response.lithium.com/RESPONSEIMAGE/fb883ecc-5643-48bb-8a6f-818942badfc3.default.jpg)
This is not a required field however, if no Date is provided in the import file or as a static value, then the Date will default to the Date that the import is performed.ĭUEDATE and SALESTERMS fields are not required. TXNDATE: This is the Date that will be assigned to the Bill. VENDOR: This is a required field and will be the Vendor to whom the Bill is being paid. It is also the field that allows Importer to know where a transaction begins and ends, which allows Importer to group detail lines together that belong on the same transaction. It is the number (can be alphanumeric) that is assigned to the imported Bill in QBO. The suggested fields to map at minimum to import the expense information from Certify are:
![import transactions into quickbooks pro from excel import transactions into quickbooks pro from excel](https://i.ytimg.com/vi/WCNCl1g416U/maxresdefault.jpg)
IMPORT TRANSACTIONS INTO QUICKBOOKS PRO FROM EXCEL DOWNLOAD
Save the map download to your desired location and then when on the mapping window of Transaction Pro, click UPLOAD MAPPING OPTIONS to select the predefined map and add to your available saved maps). ( NOTE: A predefined map that matches the mapping demonstrated below is available as an attachment to this article to download and use in Transaction Pro. Your import file column headers will be available on the dropdown menu for each field under the IMPORT COLUMN column.Īny data that is not in your import file, needs to be included in the import, and has the same value for all imported transactions can be entered as a default value under the DEFAULT VALUE column.įor the mapping shown below, the following sample data file is being used: The first column is to map the info that is in the import file. You can enter information in either column but never both. MATCH COLUMNS: On this window, you will tell Importer what columns in your import file contains what data for available QBO fields.Īny field that has a blue asterick (*) is a required field that must either be included in your import file or have a default value assigned to the field.Įach field has two options for mapping. Therefore, select the workbook and worksheet combination that contains the data that you wish to import by clicking the SELECT SHEET button next to the correct one. You can only work with one worksheet in one workbook at a time. SELECT FILE AND SHEET: If your workbook has multiple worksheets (tabs) and/or if you have attached multiple files, you will see a list of the all available options to import. NOTE: If any changes are made to the import file after it has been attached to Importer, the file will need to be re-attached for Importer to recognize the changes.Ĭlick SELECT FILE AND SHEET in the lower right-hand corner to proceed to the next window. Importer can import any flat file format into QBO such as. UPLOAD FILES: On this window, either DRAG AND DROP into the gray box your file to import or click in the gray box to BROWSE AND ATTACH your import file. The following are instructions for importing the Certify Bill Report into QuickBooks Online (QBO) using Transaction Pro Importer.Īfter downloading a Bill Report from Certify, log into Transaction Pro and select to IMPORT.ĬHOOSE IMPORT TYPE: Select BILLS as your import type by clicking on the box, which take you to the next window.