Skip to main content

Journal & Accounting Exports Overview

Payroll journals can be exported from Belina Payroll into a variety of accounting software packages. The journal exports the payroll cost as debits (expense accounts) and credits (liability accounts), ready to be posted into your general ledger.

Prerequisites​

Before exporting journals, this only needs doing once:

  1. Set up your General Ledger codes — see Banks & General Ledger
  2. Assign a General Ledger code to every transaction code that should post to the ledger

Every period after that, it's simply a matter of generating the export file.

Exporting a Journal​

image

  1. Go to Utilities → Exports → Journal
  2. Select the accounting software package required
  3. Enter the Destination Folder and File Name
  4. An export file is produced, ready to import into that accounting software

For the field-by-field settings specific to each package — AccPac, Apogee, Baan, BIQ, Bankers Realm, Evolve, NaVision, Omni Accounts, Oracle, Pastel, Sage, SAP, Smart Stream, Sun Accounting, Syspro, and T24 — see Accounting Package Export Reference.

Common Concepts Across Packages​

Most packages share a similar set of settings:

FieldTypical Meaning
PeriodThe payroll period being exported
DateThe date to include in the journal export
Destination FolderWhere the export file is saved
File NameDefaults to Journal.xls — an Excel file you can check before importing
ConsolidationCombines transaction lines sharing the same account number into a single line
Method / Group ByGroups the journal by E/D (Earning/Deduction) code, Department, or Cost Centre
Transaction DescriptionWhether a description is included on each imported line

image

Some packages also support Export Directly, integrating seamlessly with the accounting package rather than producing a file for manual import — this typically requires an SDK or connection details obtained from the accounting package vendor, in addition to your Belina setup.

Was this page helpful?