Description

Upload Fields

 

Required Fields
These fields are always required on upload
number	This number field is used to connect lines together within this excel file, and not the number that the Bill is created with (the system will create this automatically). See the Sample File for more context.
Vendor.id	The ID of the Vendor as assigned by SoftLedger (you may need to look in the UI or export Vendor table to excel to gather).
invoiceDate	Transaction date of the Bill (this will be used for any automated foreign currency translation). Entered as ISO Date Format (YYYY-MM-DD).
postingDate	The accounting date for the financial impact that this Bill carries when hitting the general ledger (often the same as Invoice Date). Entered as ISO Date Format (YYYY-MM-DD).
dueDate	When the Bill is due for payment. Entered as ISO Date Format (YYYY-MM-DD).
Location.id	The ID of the Location where this Invoice is meant to be received.
APAccount.number	The AP Account Number to be used in the Journal Entry produced from this Bill.
~Item.number~	If billing for a specific Item already set up in SoftLedger, include the Item Number here. If not Billing against an Item, use the Description field.
~description~	If not billing against a specific Item, enter a Description for the line item(s) in the Bill.
BillAccount.number	This is the Expense Account Number for the line item (e.g. Travel Expense, Operating Expense, etc.)
quantity	This is required as a multiplier against the Amount field. If entering Description line items, this is often set to 1.
amount	The amount for the line item. If entering multuple quantities, the total amount for the line item will be Quantity x Price.
Optional Fields
These fields are optional, but may become required depending on the type of entry you create. For example, if you want to create an InterCompany Journal Entry, then the IC fields will become required.
reference	This is a reference field that can often times be used to match a unique identifier from an external AP system.
ICLocation.id	If this is an InterCompany Bill, enter the ID of the Intercompany Location that should ultimately carry the expense of the Bill.
CostCenter.id	If assigning a Cost Center against the line item(s) of the Bill lines, enter the ID here.
Job.number	If this Bill line item is part of a Job, enter the Job ID here.
Product.id	If this Bill line item is to be tagged against a Product, enter the Product ID here.
TaxCode.code	Enter the Code as created under the Tax Code section under Settings. The Tax Code will drive which Ledger Account the Tax Amount is coded to.
taxAmount	Enter the Tax Amount for this line item. If no Tax Code has been selected, the Tax Amount will be coded to the default tax ledger account set under Settings>Accounts>Tax.
notes	Add rich text for any additional notes in this field.
customFields.<property>	If using custom fields on any documents to be uploaded, the format for the column header should follow this logic: "customFields.<property>" (case sensitive). For example, if a custom field created with a property title of "ExternalSource", this would look like this: customFields.ExternalSource
custom.Id	If using custom dimensions on any documents to be uploaded, the format for the column header should follow this logic: Name of Custom Dimension as it appears in UI (case sensitive), followed by ".id". For example, if a custom dimension is created named "Region", the column header would be titled: Region.id

 

File Upload Process

Bulk Import Table