Processing payroll by importing into bank payments

Owned by Carolynne Robertson-Dunn (Deactivated)
Last updated: Jul 22, 2019 by Diane Partridge
3 min read

Overview

Readysell provides the capability to import files from your payroll system into Bank Payments. Doing so will ensure that your general ledger and cashbook are automatically updated with correct payroll figures without having to manually key in payroll figures.

We currently support imports from the following systems:


Setup Required

Before you can use the payroll import feature, you must ensure that you've set up your accounts in your payroll system. See Setting up Readysell Payroll.

Also be careful when importing that you select the right file. Currently the import does not only display the file that has not been imported.

Procedure

  1. In your payroll system:
    1. Create a pay run
    2. Adjust employee work times and additions
    3. Send employee notification payslips
    4. Extract the ABA pay file (ifn applicable)
    5. Extract and submit superannuation to clearing facility (if applicable)
  2. At your online banking site:
    1. Import the ABA file to your bank account, through Internet Banking (if applicable)
  3. Export pay run journal details and save them in a folder on your system
  4. Import journals into Readysell

How to Import a Payroll Journal into Readysell

This an be handled one of two ways.
By either creating a bank payment from within a Bank reconciliation or just a manual bank payment.

Bank Payment Process

  1. Log onto readysell
  2. Select Financials >  Bank Payments
  3. Click On New > the bank payment window will open

  4. From the top Ribbon Click on 'Import Payroll'.
    A list of Payrun Journals with a date will appear in the list
    Select the one you are after and click on OK

     Show Me

     Click here to expand...



  5. Check the Imported Payrun Details>date>Payment reference>lines and Value etc and Taxcodes .
    If you are using sub department general ledger, please ensure that the journal has been dissected against each general ledger account.

  6. Click on Finalise
  7. The bank payment will appear on the bank statement you can either manually mark it or if you are using the importing of the bank statement , it will auto mark. Check


Bank Payment from within a Bank reconciliation

If you are currently doing a Bank reconciliation and the payment for stands for Salary and Wages is on your bank statement but you have not accounted for it yet in Readysell and you are using Keypay then follow the steps below:

  1. Currently in Bank Reconciliation

  2. From the top Ribbon, drop the New Banking action button

     Click here to expand...

  3. Select Bank Payment

  4. Click on Import Payroll action button
    A list of the payrun journals appear in the list view
    Select the appropriate one
    Click on OK

     Click here to expand...

  5. When the journal appears check all lines on are correct
    Check the Imported Payrun Details>date>Payment reference>lines and Value etc and Taxcodes.
    If you are using sub department general ledger, please ensure that the journal has been dissected against each general ledger account.
  6. Click on Finalise
  7. The bank payment will appear on the bank statement you can either manually mark it or if you are using the importing of the bank statement , it will auto mark. Check