Summary

A Direct Credit Schedule verifies:

• That employee funds are being allocated to a bank account.
• Bank account details.
• The amount being allocated per bank account.
• The total number of transactions per bank account (at the bottom of the report).
• The total number of employees being paid. If an employee has more than one bank account for funds to be transferred to, they are still counted as one employee paid.
• The total amount of funds required to be debited from your organisation's bank account.

Direct Credit Account Details

When you run the Direct Credit Schedule, PayGlobal uses the following hierarchy to identify which 'Account Name' to use.

For Direct Credit Non-Paying Allowances:

1. Transaction View
2. Allowance entity record
3. Employee Account name field
4. Employee Last name and First name fields.

For Direct Credit Deductions:

1. Transaction View
2. Deduction entity record
3. Employee Account name field
4. Employee Last name and First name fields.

For general employee salary and wages:

1. Employee Account name field
2. Employee Last name and First name fields.

Direct Credit Schedule setup

Banks require different formats for the Direct Credit Schedule. To set the required format, use the Edit Report Settings | Details tab. Australian banks usually use "U. Australian Format (NAB)".

Bank Account in Header

This Yes/No field is displayed in Australian databases only and it is enabled when Format = "U. Australia Bank (NAB)".

• No - Default value. In the export file header record, Positions 2-18 remain blank.
• Yes - In the export file header record, the company bank account is printed in Positions 2-18.

If you run the report with internal company filtering, the report uses the Bank account number in the relevant Internal Companies record.

If you run the report without internal company filtering, the report uses the Direct credit account in Company Settings.

Electronic Funds Transfer file

The Direct Credit Schedule report can also generate an Electronic Funds Transfer (EFT) file. This can be saved in a suitable format for transfer using software provided by your bank.

When you run a Direct Credit Schedule, PayGlobal will always attempt to produce an EFT file, regardless of report settings. An error results if an incorrect path has been specified in the setup utility. The same message might also result by specifying the A: Drive and failing to insert a floppy disk in the drive prior to generating this report.

In order for PayGlobal to successfully generate an EFT file, a filename and file path must be specified in either of the following fields:

• Administration | Modify Company Settings | Payroll | Banking | Banking Details tab | Direct credit file name
• Organisation | General Periods | Periods | Details tab | Alternate Direct Credit Export Filename.

You can direct credit employee PAYG income tax amounts to the ATO through the Direct Credit Schedule or the Superannuation Direct Credit Schedule. You need to set up the direct credit fields in Company Settings - Tax Details (Aus) and Internal Companies - Details (Aus).

Format

Whilst there are 29 format options to choose from. Not all are valid for your country or for your bank.

IMPORTANT: If you are planning to change your business bank please check that PayGlobal supports your new bank before you need to send your first DC file to your new bank.

The following list shows the options available in the Format field, in the order they are displayed in report settings.

New Zealand

• ANZ (Direct Online MTS) = E. ANZ Cash (ccyymmdd)
• ANZ (Transactive) = 6. ANZ Transactive
• ASB (FastNet MT9 format) = S. ASB
• BNZ (PC Banking) = Z. BNZ Gifts (Cms)
• Citibank = I. Citibank
• HSBC (Hexagon users) = O. Hong Kong Bank
• HSBC (HSBCNet userS. ASBs) = 1. Hong Kong Bank
• JP Morgan (JPMAccess GMT Format) = 3. JPMorgan
• Kiwibank = 5. Kiwibank GIFTS
• Westpac (Deskbank) = V. Westpac Deskbank (AUD/NZ)
• W. Westpac Deskbank

Australia

Most banks in Australia adhere to a standard format outlined by the Australian Bankers Association (ABA) this means that most of you should be able to use one format - U. Australia format (NAB).

Some exceptions are:

• Westpac = W. Westpac Deskbank or U. Australia format (NAB)
• JP Morgan (JPMAccess GMT Format) = 3. JPMorgan

Fiji

• ANZ (Direct Online) = J. Fiji ANZ v2
• Fiji Colonial Bank = 4. Fiji Colonial National Bank
• JP Morgan (JPMAccess GMT Format) = 3. JPMorgan
• Westpac = 2. Fiji Westpac

Other formats

The following list relates to bank formats that have either been superceded or the bank no longer exists or were used by UK customers.

• A. ANZCash MTS superceded, use E. ANZ Cash
• B. National Bank Diskette NZ bank closed
• C. BNZ Gifts (Cms) - 1999 superceded, use Z. BNZ Gifts (Cms)
• D. Databank magnetic tape format bank closed
• F. Fiji ANZ superceded
• G. ASB Bank Gateway superceded - use S. ASB
• H. BNZ Diskette Services v2 superceded - use Z. BNZ Gifts (Cms)
• K. BNZ Diskette Services superceded, Z. BNZ Gifts (Cms)
• L. Lloydslink CSV format UK bank
• M. Barclays BusinessMaster (SIF) UK bank
• N. National Bank DirectLink NZ bank closed
• P. Westpac Diskette Capture superceded
• R. NatWest Bankline Autopay UK bank
• T. Trust Bank NZ bank closed
• Y. EPW

W. Westpac Deskbank Format

When you use the W. Westpac Deskbank format, you should save the EFT file to disk rather than email it. Emailing the extract can add a carriage return at the end of the file, and WestPac Online will reject it.

With using this format in a New Zealand database, the Payer in Detail field is activated on the report settings:

• Select YES to display the company name as the payer name in the detail rows of the Direct Credit file.
• Select NO to leave the payer name empty for all detail rows.

U. Australian Format

(NAB)

When U. Australian Format (NAB) is used, the field Processing Indicator will become active. The Processing Indicator field has three options:

• S - Standard
• P - Preprocessed
• Blank

These indicators include either an S, P or blank character in the heading of the Direct Credit Schedule report text file. Your banking software uses this information to verify how to process your EFT file.

Printing a DC Schedule

This report may be generated for any processed pay sequence, or a closed pay sequence that has not been purged.

Reconciling this report

Compare the Total Amount on the last page of the Direct Credit Schedule to the total of the PGPRPRIM001 Pay Period Calculation Listing report for the transactions shown under the heading 'Direct Credits'. The two totals should balance.

Bank File Audit section

The PGPRPRIM002 report has a Bank File Audit section that includes the following report settings values:

• Batch due date
• File creation date
• Subscriber
• Batch
• User Bank Abbreviation
• Payment Set
• Processing Indicator
• Debit Account Number

The Bank File Audit section also includes the Hash Total value. If the report is run for a bank format that does not calculate a Hash Total, then the Bank File Audit section will display "N/A" for this value.

You can use the Bank File Audit section to reconcile and confirm values in the readable report before sending the text file to the bank for payment processing.