Summary

PayGlobal supports several GL export formats, using standard text files as the exchange medium. If your organisation does not require a specific GL export format, then you can use PayGlobal's standard format, which meets most GL interface needs.

The standard format supports the following common parameters required of GL systems:

• Batch number (up to 6 chars)
• Journal number (up to 6 chars)
• Source field (up to 1 character)
• Financial Year indicator (up to 4 characters)
• Financial batch number (up to 4 characters)
• Specific date.

The text file format is standard comma-delimited, consisting of a header, body lines, and a reconciliation body line for the wages clearing account.

General Ledger settings

To enter general ledger settings, navigate to the Reports | Report Groups | PGPRGENE | PGPRGENE002 - GL Journal | GL Journal Setup form.

See PGPRGENE002 - GL Journal for an explanation of these fields.

Format - Header

Comma-delimited with:

• Header indicator (fixed as ‘1’)
• Batch character variable
• Source character variable
• Financial year character variable
• Financial batch character variable
• Entered date variable formatted as yyyymmdd.

In code: sHeading := '1,' + sSetAcBatch + ',' + sSetAcSource + ',' + sSetFinYear + ',' + sSetFinBatch + ',' + dTos(dSetAcDate);

Format - Body

Comma-delimited with:

• Body indicator (fixed as ‘2’)
• Batch character variable
• Journal character variable
• Transaction line number in this extract
• GL Code
• Total Amount
• GL Description
• Narration.

In code: Inc(iAcTrans);

sBodyLine := '2,' + sSetAcBatch + ',' + sSetAcJournal + ',' + AllTrim(IntToStr(iAcTrans)) + ',' + AllTrim(p^.Code) + ',' + AllTrim(Transform([p^.Total], '99999999.99')) + ',' + AllTrim(p^.Desc) + ',' + AllTrim('Payroll to ' + dToc(dSetDateTo));

Format - Wages Clearing Body

Comma-delimited with:

• Body indicator (fixed as ‘2’)
• Batch character variable
• Journal character variable
• Transaction line number in this extract
• GL code (of wages clearing)
• Total amount (residual amount)
• GL description (hard coded as 'Wages Clearing Account')
• Narration.

In code: Inc(iAcTrans);

WriteLn(F, '2,' + sSetAcBatch + ',' + sSetAcJournal + ',' + IntToStr(iAcTrans) + ',' + sSetWCCode + ',' + Transform([(-dTotal)], '99999999.99') + ',' + 'Wages Clearing Account' + ',' + 'Payroll to ' + dToc(dSetDateTo);

Example

(This example does not contain GL descriptions)

1,123456,1,2009,12,20090531

2,123456,234567,1,60002,8970.88,,Payroll to 31/05/2009

2,123456,234567,2,60002431130,70.08,,Payroll to 31/05/2009

2,123456,234567,3,6301,29480.52,,Payroll to 31/05/2009

2,123456,234567,4,6302,31083.16,,Payroll to 31/05/2009

2,123456,234567,5,6701,11000.49,,Payroll to 31/05/2009

2,123456,234567,6,6702,4247.89,,Payroll to 31/05/2009

2,123456,234567,7,7002,24248.94,,Payroll to 31/05/2009

2,123456,234567,8,7992,4715.67,,Payroll to 31/05/2009

2,123456,234567,9,8052,3584.12,,Payroll to 31/05/2009

2,123456,234567,10,8101,3140.97,,Payroll to 31/05/2009

2,123456,234567,11,8102,3440.75,,Payroll to 31/05/2009

2,123456,234567,12,8251,2588.57,,Payroll to 31/05/2009

2,123456,234567,13,8252,3339.53,,Payroll to 31/05/2009

2,123456,234567,14,830,2947.29,,Payroll to 31/05/2009

2,123456,234567,15,8341,36217.71,,Payroll to 31/05/2009

2,123456,234567,16,8501,18222.14,,Payroll to 31/05/2009

2,123456,234567,17,8502,4954.77,,Payroll to 31/05/2009

2,123456,234567,18,9001,5696.69,,Payroll to 31/05/2009

2,123456,234567,19,9101,18014.64,,Payroll to 31/05/2009

2,123456,234567,20,9111,4336.73,,Payroll to 31/05/2009

2,123456,234567,21,9201,4631.45,,Payroll to 31/05/2009

2,123456,234567,22,9221 431450,5000.00,,Payroll to 31/05/2009

2,123456,234567,23,9231,14826.96,,Payroll to 31/05/2009

2,123456,234567,24,9251,3620.95,,Payroll to 31/05/2009

2,123456,234567,25,9262,3368.33,,Payroll to 31/05/2009

2,123456,234567,26,9301,48071.31,,Payroll to 31/05/2009

2,123456,234567,27,9411,9633.27,,Payroll to 31/05/2009

2,123456,234567,28,9421,5021.49,,Payroll to 31/05/2009

2,123456,234567,29,9431,13748.12,,Payroll to 31/05/2009

2,123456,234567,30,162345,- 79153.98,PAYE,Payroll to 31/05/2009

2,123456,234567,31,162350,- 225717.26,PRIMARYPAYMENTS,Payroll to 31/05/2009

2,123456,234567,32,176120,- 17779.03,SUPER,Payroll to 31/05/2009

2,123456,234567,33,176130,- 2080.69,MEDICAL,Payroll to 31/05/2009

2,123456,234567,34,176150,-3154.46,ACC Levy Waged,Payroll to 31/05/2009

2,123456,234567,35,176160,- 338.00,DEDUCTIONS,Payroll to 31/05/2009

2,123456,234567,36,123456,.00,Wages Clearing Account,Payroll to 31/05/2009