Direct Credit Schedule Options

Menu: Reports ~ Pay Period ~ Direct Credit Schedule
Button Panel: n/a

Bank File Name

When you run the direct credit schedule, you also have the option of creating a file of direct credit transactions for export to your bank client software. When you request that a direct credit file be created (by ticking the checkbox in the main direct credit form), the file will be created with the name that is specified on the direct credit options form.

The file will be created in the directory specified in the pay group edit form bank details (MTS, BACS or EFT Directory), or the same folder as your payroll database if no directory is entered in the pay group details. Do not enter the directory name in the bank file name.

Bank File Format

For New Zealand, this is a list of all the supported bank formats, where each bank can have one or more different formats depending on the software that is importing the bank file.

For Australia, you can select fixed length or carriage return delimited records - you might need to experiment to find which is the most suitable for your bank's software.

For the United Kingdom, you can also select fixed length or carriage return delimited records, plus whether or not the file includes a header and trailer record. Consult your bank's software documentation to choose the most appropriate format.

Batch Number

Only required for certain bank file formats. The number is provided by your bank.

TransactionCode

Direct credit transactions are written to the bank file with a code to indicate the type of transaction. Kwik-Pay outputs transactions with a code '99' (UK), '52' (NZ) or '53' (Aus) for net pay payments, and code '99' (UK) or '50' (Aus & NZ) for credits of deductions, including employee bank deductions. You can enter a over-riding transaction code here that will be applied to all direct credits.

Self Balanced File

If your bank software requires that the file be self balancing, that is, include a debit transaction against the company bank account that is equal to the sum of the credit transactions of all the pays, then tick the 'self balanced file' check box.

Report File Name

The layout of the Direct Credit Schedule can be customised. To customise any of the reports, click the Edit button. See Report Editing for information on how to edit reports. If you do customise a report, the customised version is saved in a text file outside of KwikPay, so you can exchange custom reports with other Kwikpay users.

If you want to run a custom version of a report created outside of your copy of KwikPay, you will need to link that report to KwikPay so that it uses the custom version of the report instead of KwikPay's built-in version. You can do that by clicking the ... button. That will open a file open window where you can select the file name of the custom report.

The Direct Credit Schedule is structured as a single main report.