How to export and convert my Salary Payments ACB file for Investec Bank BTB V1 layout from my payroll?

Summary

This article will provide you with the steps to export and covert the ACB data in the correct format for the Investec Bank BTB V1 layout from Sage VIP Classic and Sage VIP Premier.

Description

Investec Bank BTB V1 ACB is not a standard ACB interface on the payroll system.

This ACB layout requires you to generate a net salary report from your payroll (Reports and Maintenance menu), and then run an Excel conversion to align the file with the Investec Bank import layout.

The article will guide you to run the export file from your payroll for net salaries, and convert the files in the layout to import in your banking software.

Resolution

NOTE: Before you create the Salary Payment file, ensue to complete the following:

Main / Normal Payslips	Separate Payslips
A General Recalculation must be done Payslip must be printed to PDF or printer	A Separate Payslip General Recalculation must be done Separate payslip run must be frozen / printed to PDF or printer

Export payroll file

Step 1: Run the Investec Nett Salary Payment Report in you payroll company

From the Main Menu, navigate to Reports > Report and Maintenance
Locate and run the INV IBOL report (Real Number 401)

Step 2: Complete the file export selections for NetPayBank Reports

Select Print to ASCII

Enter a suitable name for you file (default name INV_IBOL_NETT.xls)

CAUTION: Do not change the file extension name, keep the file in .xls format

Select the folder to save the file

TIP: We do not recommend to save the file in your payroll application folder

Select <Yes> to continue

Step 3: Select the payslip option to export

For the Normal/Main payslip nett salary, you do not have to enter any selection (remain on zero)
For Separate Payslips (SP) nett salaries, enter the specific payslip run number to run (Separate Payslip 1 to 7)
Press <Enter> to continue

The .xls file is now generated in the selected location, ready to be imported and converted using the Investec Bank File Generator

Convert payroll file to Investec format

Step 4: Open Excel bank file converter and run Generation Wizard

Open the Investec Bank File Generator (Sage VIP) v2.1.xlsm file in Excel
Click on Generation Wizard in the Export in the Sage VIP menu option

NOTE: The Generation Wizard is located on the menu ribbon

Click here on how to check the Real numbers of the existing reports
This step will ensure that you do not overwrite existing reports
If the Report Real Number 401 already exist in your payroll, please contact Sage Customer Support for assistance.

CAUTION: If a report already exists with the same Report Real Number, the report will be overwritten when the ACB report is imported

Step 5: Select ACB file to generate