Accounts Payable
      Back to home
      1. Support Center
      2. PSL+
      3. Accounts Payable

      PSL+: How to Import an Excel File into PSL+

      This template can be used to import PO’s, AP’s, PC’s and JE’s into PSL+.

      You can import data from an excel spreadsheet directly into PSL+. 

      • If you need a template of the CSV file, please reach out to  psl.support@castandcrew.com. Once the data is entered, save the file as a comma-separated value file (*csv.). (If you’re using a Mac, make sure the file is saved as "macintosh.txt" or a "tab-delimited" file (*.txt). 
      • The CSV file can be loaded by accessing the “Import an Excel File" program. 
      • Note: If you encounter a problem saving your file as a CSV, try resaving the file as “tab-delimited" (*.txt).

      Preview of CSV import file 

      1. Click Select File to upload the .CSV file. 
      2. Select the “Transaction Type.” This option identifies the type of transaction being loaded: 
        1. JE=Journal Entry 
        2. PO=Purchase Order 
        3. AP=Accounts Payable Invoice 
        4. PC=Petty 
      3. Report Type: 
        1. Edit List: See how the transaction will display in PSL+ once it’s loaded. 
        2. Loading Register: Print the edit list and load the file. 
      4. The Default Distribution Code section is found towards the bottom of the screen. The fields colored in white will need values before you can print or preview the Edit List/Loading Register. 

      How to set up the import file

      The file must be in *.csv (comma-separated value) and *.txt (tab-delimited) or *.tsv format. 

      • Column A: ACCOUNT NUMBER (max 16 characters)
        Fields must be formatted exactly how the accounts are in PSL+. For example, if the PSL+ account number is A1-01, then Column A must be formatted exactly as A1-01.
        • “A101” does not contain the dash and would be considered as an invalid account by the importing program and the file will not load. 
      • Column B: SERIES CODE (max 4 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of series codes as inputted by the user) PSL+ auto-populates the default series code chosen in the XLINT “Import an Excel File” screen. 
      • Column C: LOCATION CODE (max 4 characters)
        Optional field, if left blank or invalid (value is not in PSL's list of location codes as inputted by the user) PSL+ auto-populates the default location code chosen in the XLINT “Import an Excel File” screen. 
      • Column D: SET CODE (max 4 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of set codes as inputted by the user) PSL+ auto-populates the default set code chosen in the  XLINT “Import an Excel File” screen. 
      • Column E: WORK AUTHORIZATION CODE (max 4 characters)
        Optional field, if left blank, PSL+ will leave the field blank. Used to tag line item with WA number. 
      • Column F: 1099 CODE (max 2 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of 1099 codes) PSL+ leaves the field blank. Below are the valid 1099 codes: 

                            Graphical user interface, text, application Description automatically generated

      • Column G: INSURANCE CODE (max 2 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of insurance codes as inputted by the user) PSL+ will leave the field blank. Usually used for asset-tagging and tax incentive tagging. 
      • Column H: FF1 (max 4 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of free field 1 codes as inputted by the user) PSL+ will leave the field blank. Usually used for asset tagging and tax-incentive tagging. 
      • Column I: FF2 (max 4 characters)
        Optional field, if left blank or invalid (value is not in PSL’s list of free field 2 codes as inputted by the user) PSL+ will leave the field blank. Usually used for asset tagging and tax-incentive tagging. 
      • Column J: FF3 (max 4 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of free field 1 codes as inputted by the user) PSL+ will leave the field blank. Usually used for asset tagging and tax-incentive tagging. 
      • Column K: FF4 (max 4 characters)
        Optional field, if left blank or invalid (value is not in the PSL+ list of free field 1 codes as inputted by the user) PSL+ will leave the field blank. Usually used for asset tagging and tax-incentive tagging. 
      • Column L: MERCHANT 
        Optional field, if left blank or invalid (value is not in the PSL+ vendor number as inputted by the user) PSL+ will leave the field blank. Used to tag line item paid to a merchant 
      • Column M: DESCRIPTION (max 30 characters). 
        Required field that can be used for any description purposes. If left blank, PSL+ will NOT load the file. 
      • Column N: AMOUNT (max 6 characters). Numeric value. The currency is determined in the XLINT  “Import an Excel File” screen.