gl_-_payroll_imports
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
gl_-_payroll_imports [2008/01/22 10:30 (16 years ago)] – craig | gl_-_payroll_imports [2008/01/22 10:45 (16 years ago)] (current) – craig | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Payroll Imports ====== | ====== Payroll Imports ====== | ||
+ | |||
+ | |||
+ | ===== Problem importing Simply Accounting ===== | ||
+ | |||
+ | **Incorrect Date Format**\\ | ||
+ | |||
+ | Simply Payroll will export the Date in one of two possible formats. System Five™ can import either, however the date information must follow the following format __**dd-mm-yy**__ or __**dd/ | ||
+ | The two types of date formatting are shown below: \\ | ||
+ | Below are examples of 'July 14/ | ||
+ | * Format 1 - 14/ | ||
+ | * Format 2 - 14-07-04 | ||
+ | The export date format may depend on date settings within Simply Accouting, or your computer date format in the regional settings within your control panel. | ||
+ | |||
===== Problem importing Simply Accounting 2008 ===== | ===== Problem importing Simply Accounting 2008 ===== | ||
**SIMPLY PAYROLL IMPORT: The import file does not have the correct number of columns**.\\ | **SIMPLY PAYROLL IMPORT: The import file does not have the correct number of columns**.\\ | ||
+ | |||
+ | Simply version 2008 export has dropped a column from the export. We are currently working on a change for this, but in the meantime you can edit the export file in excel, and add a blank column just prior to the " | ||
The procedure for exporting from Simply Accounting is detailed in the help file under Simply Accounting Payroll Import.\\ | The procedure for exporting from Simply Accounting is detailed in the help file under Simply Accounting Payroll Import.\\ | ||
- | Simply version 2008 export has dropped a column from the export. We are currently working on a change for this, but in the meantime you can edit the export file in excel, and add a blank column just prior to the " | ||
+ | The file format System Five is expecting is:\\ | ||
+ | * Unordered List Item | ||
+ | * column 1 Cheque Date | ||
+ | * column 2 Journal Number | ||
+ | * column 3 Cheque Number | ||
+ | * column 4 Cheque Name | ||
+ | * column 5 Blank or G/L account number (this column, usually blank, is missing in 2008) | ||
+ | * column 6 G/L account number/ | ||
+ | * column 7 Debits | ||
+ | * column 8 Credits | ||
+ | |||
+ | If column 5 is blank, the G/L account number and account description is in column 6.\\ | ||
+ | If column 5 contains the account number, then column 6 contains just the description. | ||
gl_-_payroll_imports.1201026614.txt.gz · Last modified: 2008/01/22 10:30 (16 years ago) by craig