Upload Templates & Instructions:

Template Location:

Uploads templates are located within the Accrualify Admin module under "Templates" 

Load Order:

Upon initial implementation data should be loaded in the following order:

1. Vendors
2. Contacts - Internal - May assign 1 internal contact to a vendor
3. Contacts - External - Should assign to the vendor ID you can have multiple external contacts to each vendor
4. PO’s - Should assign the internal contacts to PO - Do not assign a vendor contact to the PO unless desired. (PO’s can be loaded without a vendor associated – blanket/orphaned PO’s)
5. Accruals - Assign to either a PO or the vendor (at a minimum vendor is required)
6. Invoices - Assign to either a PO or the Vendor (Invoices can be loaded without a vendor or PO)

Template Field Requirements:

Date Format: MM/DD/YYYY – Please enter date format in this requirement:

Codification for all templates:

In order to load codifications, you should enter it as follows:

Debit Account	Debit Account 1	Debit Account 2	Debit Account 3	Credit Account
6300 (50% or 500)	6100 (30% or 200)	6100 (20% or 100)	6500 (0% or 0)	2010

You would need to enter the Account number and either a % of the total invoice or the actual amount you want in each account. Please note the templates allow you to add up to 15 different Accounts at once.

Column Headers:

Please Note that Column Headers are very important that you match the headers exactly as they appear in the templates otherwise the system will not load the data.

Bulk Operations:

Once the templates are ready to load you can either upload new data or "update" existing records as follows: 

Upload NEW Data: go to Bulk Operations ->Bulk Import - Select the file and follow the instructions. If there are any errors in the upload the system will inform you. 

Change Existing Data: go to Bulk Operations - Bulk Update - Select the file and follow the instructions. NOTE: there must be a vlookup field such as Vendor Name, Vendor ID, etc.