cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi, Can I import excel data which has normal weekdays & Penalty rate(Saturday rate and Sunday rate) to upload Payrun by customized excel?

 
2 Comments
Highlighted
QuickBooks Team

Re: Hi, Can I import excel data which has normal weekdays & Penalty rate(Saturday rate and Su...

Hi natsuko1,

 

You can upload these different pay categories in a pay run from Excel, however it needs to be categorised in a specific format.

 

To do this, export a current pay run to get the pay run template in Excel format, then import the pay run data into a new pay run.

 

To Export a Pay Run:

  1. Select a pay run you would like to export.
  2. Under Pay Run Actions, select Export Pay Run.
  3. Open the exported pay run in Excel, then replace the column contents with the information you would like to upload.

To Upload a Pay Run:

  1. Select New Pay Run, then create a pay run.
  2. Under Pay Run Actions, select Import Pay Run.
  3. Select if you want to clear the new pay run's existing data, or add to it. Also, select if you want to use the External ID for some columns if you have enabled those.
  4. Select the file you would to upload, then select Confirm Upload.

Here's an article that goes into the import process in more detail: https://support.yourpayroll.com.au/hc/en-au/articles/211012203-Importing-a-Pay-Run

 

Hope this helps!

 

Bonny

 

 

Not applicable

Re: Hi, Can I import excel data which has normal weekdays & Penalty rate(Saturday rate and Su...

Thanks for your advice, I will try to work out this!

 

Best regards,

Natsuko