General Ledger Export

Kwik-Pay can create a journal file of payroll transactions to import into your accounting system. Each accounting system expects data to be in it's own proprietary format. Kwik-Pay creates the general ledger journal file when you print the Costing Report.

Select the format you need in the Costing Report Options screen.

QuickBooks

When creating the QuickBooks IIF format file, Kwik-Pay uses the expense code descriptions for the account names. The default expense code descriptions in Kwik-pay correspond to the standard account names in QuickBooks. Before importing your first Kwik-Pay journal file, make sure some basic accounts have been set up in QuickBooks:

Bank this should be a 'bank' account. Kwik-Pay will post the net pay for each employee here. If you have renamed your Bank account in QuickBooks, change the 'Bank' expense code description in Kwik-pay so it has the same name.
Tax Payable this should be an 'other current liability' account. Kwik-Pay will create sub accounts for each of the types of tax calculated by Kwik-pay.
Payroll Deductions another an 'other current liability' account. Kwik-Pay will post payroll deductions and superannuation contributions to this account.
Leave Accrual this should be an 'other current liability' account. Kwik-Pay will post the value of leave accruals to this account.
Payroll Expenses this should be an 'expense' account. Kwik-Pay will create sub accounts for each of the types of employee payments, such as wages, overtime, or company superannuation contributions.

MYOB

When creating the MYOB General Journal Import file, Kwik-Pay uses the expense codes for the account numbers. The default expense codes in Kwik-pay correspond to the standard account numbers in MYOB.

Note that you should leave out the hyphen(-) in the MYOB account number when editing Kwik-Pay's expense codes. MYOB will insert the hyphen when it imports the data.

If you have implemented cost codes in Kwik-Pay, they will be included in the MYOB General Journal Import file as 'Jobs'. The cost code defined in Kwik-Pay will be passed through to MYOB as a Job code. You will need to make sure that you have the same Job codes defined in MYOB.

Before importing your first Kwik-Pay journal file, make sure some basic accounts have been set up in MYOB:

1-1120 this should be a 'bank' account. Kwik-Pay will post the net pay for each employee here. If you use a different Bank account in MYOB, change the 'Bank' expense code in Kwik-pay so it has the same number.
1-2300 an 'other current asset' account. Kwik-Pay will post payroll net pay rounding brought and carried forward to this account. This is not a standard MYOB account you will need to create it in MYOB's Chart of Accounts.
2-1410 another an 'other current liability' account. Kwik-Pay will post payroll deductions and superannuation contributions to this account.
2-1420 this should be an 'other current liability' account. Kwik-Pay will post each of the types of tax calculated by Kwik-pay to the one account.
6-2030 this should be an 'expense' account. Kwik-Pay will create post each of the types of employee payments, such as wages, overtime, or company superannuation contributions and the value of leave accruals to this account.