Payroll2FMS – File not showing to import into Payroll2FMS.

UPDATE: Version 1.1.0.42 has been updated to accept Office 2010 (xlsx) spreadsheets, this will require that the computer have Office 2010 installed.

Payroll2FMS – File not showing to import into payroll2FMS.

The Excel file has been saved in F:public\payroll2fms folder and can be viewed when in file manager but when importing by browsing to that location in the payroll2fms software cannot be located.

The Cost Analysis Detail file required will not import if created in Excel 2010 as the software is not compatible.

Open the document and file>save as >save as type>Excel 97-2003workbook.

The file will then import to be converted into payroll2fms.

 

 

Reviewed on 24/10/2016

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

What is Payroll 2 FMS?

Byadmin

Payroll 2 FMS is an application to convert spreadsheet data into an FMS automatic reconciliation file.

Can I set a password on an Excel Spreadsheet? (Excel 2010)

ByLiam Motevali

Before setting the password it is important to remember that if you lose or forget the password, it cannot be recovered.  Also remember that passwords are case sensitive. Click the File Button , click Save As, and on the bottom of the Save As dialog, click Tools. On the Tools menu, click General Options. Under File…

New Licence for Payroll2FMS

Byjanet.demaine

When trying to access Payroll2FMS you will see the following window as your licence will have expired on 30th September.  Enter the details exactly as shown in the email that you have been sent.  All details are case sensitive.  Once the details have been entered click on “Validate Licence”  and the “Licence Code is Invalid” should…

Unable to format dates in Excel reports

ByLiam Motevali

To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…

Exporting Attendance or Lesson Monitor reports to Excel

ByLiam Motevali

The inbuilt Attendance and Lesson Monitor reports are designed to output to a web browser such as Internet Explorer. It is possible to export the data from the web browser to Microsoft Excel. After running your report it will open a new window and you will see your information. If you right click on the…

The edit options are greyed out on my report

ByscomisWR

When saving reports from Sims .net the edit options such as Data sort are greyed out – this is in Excel 2010. If the header bar, besides giving the file name, also says Group:- 1. Right click on the ‘Sheet 1’ tab at the bottom 2. Choose Ungroup KB6568     Reviewed 29/04/2015 How useful…