User Tools

Site Tools


gl_-_payroll_imports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
gl_-_payroll_imports [2008/01/22 10:30 (16 years ago)] craiggl_-_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/mm/yyyy**__ layout in order for System Five™ to properly import the information. \\
 +The two types of date formatting are shown below: \\
 +Below are examples of 'July 14/2004' represented in the two acceptable date formats that System Five™ understands. \\
 +  * Format 1 - 14/07/2004 
 +  * 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 =====
Line 8: Line 21:
  
 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.\\
 +
 +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/description 
 +  * 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.1201026654.txt.gz · Last modified: 2008/01/22 10:30 (16 years ago) by craig