There are some standard rules of thumb to successfully import batches into Adagio Ledger. The following are tips that we have received from Dealers who are familiar with Paymate (as we can only provide support for Adagio).

- All accounts and departments must be set up exactly the same in Paymate as they are in Adagio Ledger.
- You can only export posted payroll from Paymate. The figures for export are taken from employee history. You can export any time frame that you want and if required you can export by department or pay group. (They suggest leaving the groups to include blank that way you are sure of getting everything.)

In addition to this:
1. This may obvious, but make sure both the Account and Department (if used) are filled in on the Paymate "Accounts and Departments" screen for EVERY Paymate account that will be exported.

2. Check that ?Adagio Accounting (single currency)? is selected as the export type in Paymate.

3. In Adagio Ledger, source codes display as "GL- 4" or "GL-PR" but are really stored as "GL 4" and "GLPR" so they must be entered that way in the Source Code box in Paymate. Note the space before the "4" - it is needed if there is only one character in the second segment of the source code. (And, of course, double check that the source code is already defined in Ledger.)

4. It is surprisingly easy to select the wrong file and therefore get an import failure. One way to avoid this is to use Windows' cut and paste. Highlight the complete export filename and path in Paymate and press CTRL-C, then highlight the import filename and path in Adagio Ledger and press CTRL-V. Sounds silly, but at least you cannot mis-type it.

(For best results, you may want to export the file as .csv format, not .txt - which is the default in Paymate.)
------------------------

If that advice has all checked out, then we can go further on the Adagio side, but I am not sure what you mean by your 'options are not the same'? Not the same as what?

In Adagio Ledger, you want to import the batch as 'Detail Only'. From the main 'File Information' tab in the Adagio Import screen, make sure the path and filename are the same as what you exported from Paymate.

You should be able to use the default Adagio Import Template for Details Only to import your Paymate batch successfully. In the 'Import Field Selection' tab, you can then select 'Save as' to save this template as your new Paymate default. It contains all the fields you need:
Record Type
Entry Number
Fiscal Date
Fiscal Period
Account Code
Department Code
Source Code
Reference
Transaction Date
Description
Amount

In this screen when you select each field on the right Import file fields, you can see it's properties in the bottom section of this screen. Your import file fields should match what is defined here.

Hope this helps.

As we indicated in our previous post, we cannot provide support on Paymate Payroll. For this, you need to contact your Dealer or AK Micro, the Developer of Paymate.

Re: 3. Regarding Adagio Ledger, to find out for sure if the Source Code "GL 2" that Paymate has automatically 'put in' matches those set up in Ledger, open Ledger, then select Edit-Source Codes from the main toolbar menu options. If GL-02 does not exist, you must create it, if this is in fact the source code you wish to use for Payroll entries.

Re: 4. Again, I cannot instruct you on Paymate, however, to highlight/select the import filename and path in Adagio Ledger, you would select:
- File
- Import
- Batches
- Detail Only
- Select Yes to continue

You should now be on the default 'File Information' screen/tab in Adagio Ledger's Import area.

A. Beside 'File format', select ASCII (Delimited) as the file format.
B. Beside 'File name', you would select the whole path and replace it with the path from the copied Paymate export file path & name. If you only find a filename in Paymate, then you would have to find out where the Paymate export file is located, then ensure that you enter this path into this 'File name' field in Adagio Ledger.

To export the Paymate file as .csv instead of .txt, there should be a selection to do so in Paymate. If there isn't, then perhaps just renaming the file to have a '.csv' file extension is all that is required...again, I am not familiar with Paymate. You should consult with someone that knows the program if you cannot find out how to do this on your own, or from the Paymate documentation/help.

Alternatively, if the Paymate file cannot be exported/renamed to .csv, then leave it as it is, and just follow the first step (A.) above in Adagio Ledger, leaving the actual Paymate export filename as it is, with the .txt extension. This should work as well.

Regarding the 'options' question - are you speaking of them not being the same as the printed out Help file information? This could be - perhaps you should be looking at the Adagio Ledger 'Addendum' in case the options here have changed in your newer release. In the current version, the options in the Adagio Import screen 'File Information' should be:
- Use 4 digit years?
- Use extended character set?
- Delete import file on success?
- Validate before importing?
- Separator (default of "," comma)

If you are still having problems, then I would strongly suggest calling your Dealer, who is experienced with Adagio and should also be familiar with Paymate as well.

There are no known issues with importing a file from Paymate.

Regards,

The electronic help has an old screen shot. We removed those options from the import batch as they were intended to only apply when you were importing account information. I've made a note to fix that in the next release. In the interim, you can ignore the documentation regarding those options.

This import should "just work" if you leave the options unchanged and just point the import at the file created when you export the transactions from Paymate.

Did you load the export file into another program to "look at it" before you imported it into Ledger? Might you have saved it back and altered its format inadvertantly?

Could you let us know exactly which version of Ledger you are running? Fixes have been made to importing transactions as we have created new releases. The version information is found in the "Help | About" selection in Ledger.

Thanks (and Happy New Year)