Skip to main content

Accounting Package Export Reference

Field-by-field settings for each accounting package supported by Utilities → Exports → Journal. See Journal & Accounting Exports Overview for the general process and prerequisites (General Ledger code setup).


AccPac​

image

FieldDescription
PeriodThe payroll period being exported
Batch EntryThe batch number used to import into AccPac
DateDate to include in the journal export
Export TypeExcel or CSV format
Journal TypeStandard, Departmental, Cost Centre, or Multiline
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
Source CodeTransaction date applied within AccPac
Control AccountAccounting code for the Control Account
ConsolidationCombine same-account transaction lines into one
Transaction DescriptionWhether to include a description on each imported line
DescriptionThe description text to include
Group ByE/D Code, Department, or Cost Centre
DepartmentGrouping by department

Apogee​

FieldDescription
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
Entity IDIdentifier for the export, defaults to PST5
CurrencyCurrency type for the journal export

image


Baan​

FieldDescription
PeriodThe payroll period being exported
ReferenceThe reference number used for the import into Baan
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
ConsolidationCombine same-account transaction lines into one
Transaction DescriptionWhether to include a description on each imported line
DescriptionThe description text to include
DepartmentGrouping by department

image


BIQ​

image

FieldDescription
PeriodThe payroll period being exported
Destination FolderFolder for the export file
File NameDefaults to Journal.xls

Bankers Realm​

image

FieldDescription
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
ReferenceA reference to include in the journal export
MethodE/D, Department, or Cost Centre

Evolve​

image

No configurable export fields — the export runs directly with default settings.

image

FieldDescription
Local CurrencyCurrency type for the journal export
Export DirectlyEnables seamless integration with NaVision
DimensionsHow the journal is split — e.g. by Cost Centre, Department, Pay Point, or Country
ReferenceDescription of the journal batch
File TypeFixed-length text file or CSV
FolderFolder for the export file
File NameDefaults to Journal.xls
WS UrlURL for connecting to the NaVision instance, when exporting directly
UsernameUsername to connect to NaVision
PasswordPassword to connect to NaVision

Omni Accounts​

image

FieldDescription
DateDate to include in the journal export
ReferenceThe journal batch description
ConsolidationCombine same-account transaction lines into one
Group ByE/D, Department, or Cost Centre
Destination FolderFolder for the export file
File NameDefaults to Journal.xls

Oracle​

image

FieldDescription
PeriodThe payroll period being exported
Batch EntryThe batch number used to import into Oracle
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
Source CodeTransaction date applied within Oracle
Control AccountAccounting code for the Control Account
ConsolidationCombine same-account transaction lines into one
Transaction DescriptionWhether to include a description on each imported line
DescriptionThe description text to include
MethodE/D, Department, or Cost Centre
DepartmentGrouping by department

Pastel (Partner / Evolution)​

In order to export journals from Belina Payroll HR, first set up a General Ledger code for each transaction code — this only needs doing once. Every period after that, generating the export file is straightforward.

image

FieldDescription
PeriodThe payroll period being exported
DateDate to include in the journal export
Pastel VersionThe target Pastel Accounting version
Export Directly to PastelPosts the journal directly into Pastel for a seamless export. If unticked, the journal is exported as a file for manual import
Destination FolderFolder for the export file — or the Pastel folder, if exporting directly
Export TypeCSV or Excel
Departmental or Cost CentreWhether Departmental and/or Cost Centre journals are being exported
File NameDefaults to Journal.xls
ReferenceJournal batch description
Contra AccountContra account, in the same format as your Pastel Accounting software
Entry Type No.Batch number, when exporting directly to Pastel
ConsolidationCombine same-account transaction lines into one
Transaction DescriptionWhether to include a description on each imported line
DescriptionPastel Evolution batch description, when exporting directly
MethodE/D, Department, or Cost Centre

To export the file:

  1. Go to Utilities → Exports → Journal → Pastel
  2. Complete the fields above, click OK
  3. On the Range Selection screen, make your selections
  4. Click Preview to view the Pastel Export Journal, or Close
  5. Note the file destination shown — needed when importing into Pastel

To import into Pastel:

  1. Open Pastel and the general ledger the payroll batch will import into
  2. Go to Process → Journals
  3. Select Payroll Journal, or the journal used to post payroll transactions
  4. Click Batch → Import
  5. Use the Lookup feature to find and select the Belina export file
  6. Click Process to import the batch
  7. Check the import — confirm details are correct and the batch is in balance
  8. Post the journal using Update, and confirm with Update this Journal Batch

Export Directly to Pastel Partner: to have a seamless integration, purchase the SDK kit from Pastel — this allows the two programs to communicate directly. Obtain the following from your system administrator and from Pastel: Pastel Server, Pastel Database, Common Database, User Name, Password, Serial Number, and Authorization Key.


Sage​

image

FieldDescription
VersionThe Sage software version to export to
Serial NumberAn auto-incrementing number tracking exports done so far
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
Payroll TypeJournal reference
Journal DescriptionJournal description
Balance Sheet A/cJournal control account

SAP​

image

FieldDescription
PeriodThe payroll period being exported
DateDate to include in the journal export
Export TypeExcel or CSV
File TypeDestination file type
Company CodeThe processing company whose books the account posts to
Control AccountThe journal summary account
JDT NumberThe journal transaction number in the system
Document TypeDistinguishes between business transactions, classifies accounting documents, and determines the number range for documents and account types (asset, material, vendor, etc.)
Expenses Tax CodeTwo-digit code representing the expense
Revenue Tax CodeTwo-digit code representing the revenue
Customer Tax CodeThe customer tax code assigned in the customer master
GL Posting KeyTwo-digit numerical key determining the type of transaction entered in a line item
Customer A/C KeyEnables posting amounts to certain revenue account types
Vendors KeyA keyword provided by SAP or the relevant add-on vendor
ED Code Setup for SAP Staff NumberA transaction code set up for employee number, used to identify the employee uniquely in SAP
Destination FolderFolder for the export file
File NameDestination file name

Smart Stream​

In order to export journals, first set up a General Ledger code for each transaction code — this only needs doing once.

image

FieldDescription
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
Entity IDCompany identifier
Journal DescriptionJournal description
User IDThe Smart Stream user generating the export
Source DocumentJournal source

Sun Accounting​

In order to export journals, first set up a General Ledger code for each transaction code — this only needs doing once.

image

FieldDescription
DateDate to include in the journal export
VersionExcel or CSV
Journal TypeThe type of journal being exported
Journal SourceDefaults to BELINA PAYROLL
Destination FolderFolder for the export file
File NameDefaults to journal.xls
ConsolidationCombine same-account transaction lines into one
MethodE/D, Department, or Cost Centre

Syspro​

image

FieldDescription
DateDate to include in the journal export
VersionThe Syspro version to export to
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
ReferenceJournal description
ConsolidationCombine same-account transaction lines into one

T24​

image

FieldDescription
DateDate to include in the journal export
Destination FolderFolder for the export file
File NameDefaults to Journal.xls
ReferenceJournal description
Export TypeWhether the export includes full journal entries, or only net pay transactions

Was this page helpful?