You can use FinJinni to add Customers and Vendors to QuickBooks. Sub-Customers can also be added as Jobs for QuickBooks Desktop or Projects for QuickBooks Online. These entity definitions can be created using an Excel spreadsheet or other program to create a data file that FinJinni will load. FinJinni will then add these entities to QuickBooks.
This feature is only available if you have purchased the license for the FinJinni Importer advanced data loading feature. It is enabled in the trial versions so that you can preview it.
FinJinni’s will load these entities from CSV-format files that you can create with Excel. There are separate files for each QuickBooks company and you may have multiple files for one company. All files should be saved in the folder “documents”\My Templates\FinJinni, where “documents” is your normal documents folder.
The data files that FinJinni will load are named “companyid_Entity_[suffix].csv”, where “companyid” is the company identifier (aka nick-name) that you assigned when you added the company to FinJinni and “suffix” is a value to uniquely identify the file if needed – you can pick anything you want for this, such as a date.
The FinJinni Excel Add-In can assist in saving these CSV-format data files from Excel worksheets. Once you create a worksheet with the columns described below, use the Upload button on the FinJinni ribbon bar in Excel to save the worksheet as a CSV file. You can also save it using the normal Excel menu – the FinJinni Upload button is a convenient shortcut.
There are a large number of supported data fields for entities. Generally, the QuickBooks name assigned to a field is used. For a complete list of all the fields, refer to one of these sample transaction spreadsheets supplied with FinJinni:
Sample_ImportData_QBD.xlsx -or- Sample_ ImportData _QBO.xlsx
These files have at minimum the following columns and require a header with the column name in the first row:
- EntityType
The type of the entity: Customer or Vendor.
- EntityName
The entity name. For sub-customers, this must be the full name in the format “parent:child” as used by QuickBooks. This is the full entity name, also called the Display Name in QuickBooks.
A few other commonly used fields are these:
- Memo
The Notes value for the entity.
- JobDesc
The Description for a Job.
- Revised
Y to revise an existing QuickBooks entity. N or blank otherwise.
Change values will not be automatically written back to QuickBooks after an entity is initially added. If you set this field to Y, FinJinni will update the entity in QuickBooks on the next refresh regardless.
- Voided
D to delete an existing entity.