1. Download and complete the Employee Details Table.csv Import File.
    1. How do I complete the Employee Employees Table Import File?
  2. Click File > Accounting Export (e-Port™) > Import Data.
  3. Select Employee EmployeesTable from the Select Database Table… drop-down menu.
  4. Select the following Available Database Fields, clicking  >>Add>> between selecting each item below.
    1. AccrualCommencementDate (Date)
    2. AddAmountToTax (Text, 10)
    3. AddressLine1 (Text, 38)
    4. AddressLine2 (Text, 38)
    5. AnnualLeaveAccrued (Number (Double))
    6. AustralianResident (Text, 1)
    7. AwardDBID (Number (Short))
    8. Birthdate (Date).
    9. Country (Text, 20)
    10. DateHired (Date)
    11. EmpClockID (Text, 8)
    12. FirstNames (Text, 50)
    13. FlatTaxPercent (Number (Single))
    14. GrossPayYTD (Number (Currency))
    15. HECSTaxOption (Yes/No)
    16. HomePhone (Text, 12)
    17. Internet1 (Text, 76)
    18. JobTitle (Text, 30)
    19. LabelInternet1 (Text, 1)
    20. LabelPhone1 (Text, 1)
    21. LeaveLoading (Yes/No)
    22. Locality (Text, 27)
    23. LongServiceAccrued (Number (Double))
    24. MemberFundID (Number (Interger))
    25. MemberFundNo (Text, 20)
    26. NetYTD (Number (Currency))
    27. NonReportableNonTaxAllow (Number (Currency))
    28. NonSuperSalarySacrificeYTD (Number (Currency))
    29. NonTaxableAllowancesYTD (Number (Currency))
    30. PAYGVoluntaryFlatTax (Text, 8)
    31. PayLocation (Text, 25)
    32. PaymentMethod (Text, 9)
    33. PayPeriod (Text, 1)
    34. PayRateList (Text, 113)
    35. PayrollTaxState (Text, 3)
    36. PostCode (Text, 4)
    37. PrimaryPaymentMethod (Text, 1)
    38. RDOsAccured (Number (Double)
    39. ReportableSuperYTD (Number (Currency)
    40. RESCPercentOrDollar (Text, 10)
    41. SalarySacrificeYTD (Number (Currency)
    42. Sex (Text, 1)
    43. SFSSTaxOption (Yes/No)
    44. SGLFundID (Number (Interger))
    45. SGLFundNo (Text, 20)
    46. SGLPercentOrDollar (Text, 20)
    47. SGLStartDate (Date)
    48. SickLeaveAccured (Number (Double))
    49. State (Text, 3)
    50. StateAwardType (Text, 3)
    51. Status (Text, 1)
    52. SurName (Text, 50)
    53. TaxableAllowancesYTD (Number (Currency)
    54. TaxAllowInGross (Number (Currency)
    55. TaxFileNumber (Text, 11)
    56. TaxFreeThreshold (Yes/No)
    57. TILAccured (Number (Double))
    58. TotalDeductionsYTD (Number (Currency)
    59. TotalTaxYTD (Number (Currency)
  5. Once all the Database Fields are added to Import Field Order, click Browse.
  6. Choose the location to import the Employees Banking details from (e.g. CSV on USB STICK or EXTERNAL HARD DRIVE).
  7. Click Open.
  8. Click Save if you wish to automatically load this location for future imports OR Click Don’t Save to manually select a different location for each import.
  9. Navigate to Import into Database;
    1. Select Clear Table then Add to add the new records after clearing (deletes ALL information stored in) the existing database.
    2. Select Append to Table to add the new records to an existing database without deleting any information stored in) the existing database.
  10. Click Settings.
    1. Under Fields, select Field Name Header and No Delimiter.
    2. Under Field Separator, select Comma.
    3. Under Date Order, select DD/MM/YYYY.
  11. Click OK.
  12. To begin importing, click Import.
  13. Once the Import has completed, click to continue then Exit.
Revision: 9
Last modified: 2020/03/03

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment