Payroll Import: CSV file format

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), Currency(Foreign) , Exchange Rate, Job

All fields are required.
Value fields require zero if there is no value.
Text fields require double quotes to indicate empty field.

Account Code: chart of account code. (must exist in OCi System first) 
Description: row description
Debit Amount(Transaction Currency) : Foreign currency value
Credit Amount(Transaction Currency): Foreign currency value
Debit Amount(Accounting Currency): Book currency value 
Credit Amount(Accounting Currency): Book currency value 
Currency(Foreign): currency of transaction
Exchange Rate: if Transaction currency is the same as Accounting currency put 1.
Job: if no job code put "" to denote empty.

    • Related Articles

    • Document Import XML format

      Version: 2.0.4 Date: 2023-04-12 XML format documentation 1. Invoice The follow sections describe the format of the Sales Invoice XML file. XML Mandatory Description <?xml version="1.0" encoding="UTF-8" standalone="yes"?> Y XML Declaration. <ociac10> ...

    • 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 Account code exist in the Chart of Accounts. Values are ...

    • Weird character being displayed when exporting to CSV.

      If you have non english text (eg, chinese characters) in the data when you export to excel. the unicode characters will lose their formatting when you export to excel. you'll need to tell Execl to format the CSV for you. select unicode as the ...

    • 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.

    • CSV for Invoice import

      OCi System Custom Guide Version 0.1 This custom function has been created for a specific customer and not suitable for general usa CSV Format Requirements No column headers BP code must exist in system before import Item code must exist in system ...