[sims] FMS & RBS BACS Payments

[36Degrees]

Our Finance department have started to set up BACS payments but have hit a brick wall that the LEA say they can do nothing about. Although we are also contacting Capita and RBS again I wondered if there was anyone out there who can help?

 

The issue they are having is that RBS claim that the file created by FMS that is sent to them is not in the correct format (the LEA says it works fine for Lloyds and the Co-Op). The finance department believe that it is because FMS isn't separating certain data entries with a comma.

 

Has anyone else encountered this before? I find it difficult to believe that we are the only school in the country trying to make BACS payments to RBS through FMS!

[matt40k]

I think your LA needs have a word with Ian Romeo-Smith (IRS) about this, someone posted about this on SupportNet, I believe the problem is:

 

1. Bankline will only accept a file with a 'txt' extension, which FMS does not do. This means the filename needs editing before importing it.

 

2. FMS adds a carriage return after the trailer line in the file. This results in an extra, blank, line at the end of the file. Bankline does not expect any data after the trailer line, so rejects the file.

 

I believe no2 is resolved now, however no1 is still outstanding.

 

Last thing IRS said on SupportNet was:

I have sent an example file to Royal Bank of Scotland (Nat West is a bank within the Royal Bank of Scotland Group), and await their reply

 

 

So it's being looked at, at least.

[36Degrees]

Thanks Matt. From what I can see now I've had a chance to speak to them properly is that RBS need a comma delimited file and the one produced is tab delimited in some places and not delimited at all in others e.g. the bank's sort code has lots of other numbers after it (acct number, date, etc) in one long value.

[Edu-IT]

Did you get anywhere with this? Having the issue ourselves now.

[PhilNeal]

Do contact your support unit - I'm pretty sure all banks accept our formats now. If all else fails drop me a note and I'll get an expert onto it for you.

[Edu-IT]

Sorted it out myself yesterday afternoon, only by playing though. The tick box within FMS that we were told not to untick actually has to be unticked.

 

:-)

[ccamel]

Hi Edu-IT,

 

Do you remember what you did to sort this?

 

Thanks,

Tim

[ccamel]

Hi Phil,

 

Any chance you can get an expert onto this for us?

 

Thanks a lot,

Tim

[PhilNeal]

@ccamel - do drop me an email and I'll get someone onto it. [email protected]