Reconciliation completely fails – usually from a Payroll2Finance file

Issue :

Using Payroll2Finance, a file was created for import into your Finance Reconciliation Eg. 05G128AE.TXT. The file was imported into your Finance System but every single item rejected. The school deletes all the rejected items from suspense. The school creates a new file out of Payroll2Finance for import into your Finance System but when importing it they get the error ‘An attempt was made to re-import the file ….’

Reason:

A Payroll file from Payroll2Finance may completely fail reconciliation because the spreadsheet from County was incorrect when converted. So perhaps the Fund code was not correct or the ledger in the incorrect column

If the school corrects the spreadsheet and then uses Payroll2Finance to create a new file for import into your Finance System, the same file name will be generated 05G128AE.TXT and on import into your finance system an error is returned ‘An attempt was made to re-import the file …’

Solution :

Using File Manager. Rename the file inside and out. Leave the first digit the same (In the example above leave the ‘0’ as that denotes the year the file will be imported into, so in this instance ‘0’ denotes 2020). For the file above you would rename the file to 05G128XX.txt and on the top line inside the file, replace the text 05G128AE.TXT with 05G128XX.TXT. This newly named file will import into your Finance system without issue.

KB27134