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

Select Salary Payments

Click on <Next> to continue

Step 6: Locate the Input file generated from the payroll

Click on 'Locate File…' and browse to the locate the .xls ASCII file generated in Step 2 and 3

Click <Next> to continue

Step 7: Complete Input Parameters

Enter the Company Bank Account number
Enter the Client Reference (Default = Salaries)
Enter the Beneficiary Reference (Default = Salary)
Select the Payment Date

Click <Next> to continue

Step 8: Select location where to generate and save the ACB bank file

Browse to the location where the bank file must be saved

NOTE: We do not recommend to save the file in you application folder

Click <Next> to continue

Step 9: ACB file generates

Once the file generation process is completed, the message "Done!" will display
The location where the data was exported to will display onscreen

Click <Finish> to complete

Step 10: Upload bank file to Investec Bank

The file generated can now be uploaded to your Investec Bank portal for payment to the employees

TIP: Save the 'Investec Bank File Generator' Excel file to save the input parameters.

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

Summary

Description

Resolution

SUPPORT & TRAINING

PARTNERS

COMPANY

FAQs