Payroll Import: Importing CSV.

Payroll Import: Importing CSV.

To import the CSV file you'll need to ensure that it is properly formatted and the values are balance.



if you encounter errors.


Check that Job code is using "" for empty or has a value



Check
  1. Account code exist in the Chart of Accounts.
  2. Values are balance ( accounting Debit = Accounting Credit).

    • Related Articles

    • Payroll Import: CSV file format

      The file format for import is using a Comma Separated Values format (CSV). the file format has no headers. Format: Account Code, Description, Debit Amount(transaction), Credit Amount(transaction), Debit Amount (Accounting), Credit Amount(Accounting), ...

    • BP import: Import CSV

      Steps to import CSV 1. Setup -> Customer/Vendor -> Business Partner 2. click on import button 3. select the file to import. 4. click open button.

    • Payroll Import: Setup

      The system has a feature to import payroll entries into a Journal Entry. Required Setup Setup -> Company Details -> Default Setting. Currency: the default currency of the transaction Subject: the JE subject that will be created. Running No. : the ...

    • PayDay! Import to AC10 User Guide

      Training PDF can be downloaded from 'Attachment' section below.

    • Document Format BP CSV Import

      Column Mandatory to has value DataType/Length Description BPCode Yes 20 Code of Business Partner. Must be unique. If Code exist, line will be rejected BPName Yes 200 Name of Business Partner BPUEN No 20 UEN of Business Partner CountryCode No 2 ...