Adding Payroll Details to the Journal Upload Format Payroll File

The following details must be entered on the Journal Upload Format Payroll file:

  • Document Type — The location's document code for Journal (XXGJ) or Payroll Journal (XXPJ)
  • Row — Starting at 1, enter the line number to display the transaction on

    If adding more than one document, each new document must start at 1.

  • Date — Must be entered in DD/MM/YYYY format
  • Year — Must be entered in the Code format for the Years key list
  • Period — Must be in the same format as period numbers, such as 01

    To make sure the leading zeros are not removed when saving the file, cells must be formatted to Custom, and enter 00 in Type.

  • Nominal — Enter the code the document must be posted to
  • Account — Enter the Ledger code the document must be posted to
  • Value — Enter the amount as a debit or credit
  • Description — Enter a meaningful description to identify what is recorded in the document if enquired