Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Standard Bank Export Interface Layout

The Standard Bank Export Interface layout is comma-delimited text file that is available in two formats, detailed and summary.

The Detailed file has the following layout and parameters

Parameters

              Batch Date – The positing date to Bank services

Layout

Check Number

The check/Voucher Number

Employee Number

The Employees Assigned ID/Number (alphanumeric)

Check Date

The Check or Pay Date

Batch Date

The posting date to Bank Services

Check Amount

$ amount of the check

Employee Name

First and Last name of the employee.

Check_Number

 

Employee_identification

See above

 

The Summary file has the following layout and parameters

The “Summary Deposits” standard layout will summarize all direct deposit payments for all employees that have the same PAY DATE to a single line item. This is to simplify bank reconciliation in the accounting software.

Parameters

              Direct Deposit Identifier – Positing identifier to replace the cheque number

Layout

Check_number

The user entered direct deposit identifier.

Blank

 

Payment Date

The payment date of the records

Batch Date

The posting date of the bank service records

Check Amount

$ amount of the deposits

Blank