Exporting payroll files (CSV)
Requirements
- Available on: Premium and above
- Device access: Web & mobile browser
- Permission: Owner or Manager
SalonHub360 prepares your pre-payroll worksheet: hours, commissions, tips and overtime for each pay period. It does not pay your team, withhold taxes or file anything, and it does not send anything to a payroll provider. You download a pay period's numbers as a CSV file, then you enter or import them in your payroll provider, which runs payroll.
There are three files, and four more that are named after a payroll provider:
| File | What it contains | When you can download it |
|---|---|---|
| Payroll worksheet (generic) | One row per person with every figure: pay type, rate, hours, straight-time pay, overtime premium, salary, commission, tips, bonus, corrections and deductions, earnings total, reimbursements and total to pay, plus warnings. | At any status. If adjustments changed since the pay period was last refreshed, refresh it first. Until the pay period is approved, the file name says DRAFT and the notes at the end of the file say what is still open. |
| Hours and other earnings | Hourly rate; regular, overtime and double-time hours; commission, tips to pay, bonus, and corrections and deductions, with their total; reimbursements in their own column; and two reference figures. It has no straight-time pay, overtime premium or salary amount. | Once the pay period is Approved or Paid. |
| Amounts | SalonHub360's calculated amounts for everyone: straight-time pay, overtime premium, salary, commission, tips to pay, bonus, corrections and deductions, earnings total, reimbursements and total to pay. Hours are included for reference only. | Once the pay period is Approved or Paid. |
| Provider-named files (QuickBooks Online, Gusto, ADP Run, Paychex Flex) | The Amounts content, with the columns named and ordered in SalonHub360's own way for each file. Unverified: see below. | Once the pay period is Approved or Paid. |
Provider-named files are unverified. These files use SalonHub360's own layout. We have not tested importing them into any payroll provider. Check every column against your provider's import template before you use one. In the export window and in Settings → Payroll each one is labelled:
- Unverified — not tested with QuickBooks Online
- Unverified — not tested with Gusto
- Unverified — not tested with ADP Run
- Unverified — not tested with Paychex Flex
The name of each of these files also contains
unverified.
Which file to use
- Your payroll provider works out hourly pay itself from hours and a rate: use Hours and other earnings. Do not also enter straight-time pay or the overtime premium from another file, or the same pay is counted twice.
- You enter amounts as SalonHub360 calculated them: use Amounts. Do not also have your provider calculate pay from the hours.
- You want everything in one place to review, or to hand to your accountant: use the Payroll worksheet (generic). It is not tied to any provider.
Two things are true wherever these figures appear, in a file or on screen:
- Reimbursements are not earnings. A reimbursement repays an expense the person covered. It has its own column, Reimbursements (not earnings), and it is not inside the earnings total. Earnings total + reimbursements = total to pay.
- The overtime premium is separate from straight-time pay. Overtime premium is a separate amount. It is not included in straight-time pay. Straight-time pay already includes the normal rate for overtime hours.
On screen, the pay period page and each pay statement show the same three figures: Earnings, Reimbursements (not earnings) and Total to pay. If a person's reimbursements can't be shown separately, that line is left blank with a note; nothing is estimated, and Total to pay is not affected.
How to download a file
- In the left menu, open Payroll and click a pay period.
- Click Export files. The Export Pre-Payroll Data window opens and lists the files for that pay period.
- Choose a file. A file that can't be downloaded yet is greyed out and says why underneath. Before you download, the window shows the file's name and its notes: for example who is left out of the Hours and other earnings file.
- For ADP Run, you can type an ADP Company Code (optional). It fills the Company Code column on every row. Leave it blank and the column reads
SALON. Use letters, numbers, spaces,_or-, up to 32 characters. - Click Download CSV. Your browser saves the file. If the download is refused, the reason shows inside the window and the window stays open.
Note: The payroll worksheet can be downloaded at any status, including for a draft and for a pay period that can't be approved. The other six files can be downloaded once the pay period is Approved or Paid. If adjustments changed after the period was last refreshed, nothing can be downloaded until you refresh the period, so stale numbers are never downloaded. See Running payroll & overtime worksheets.
If a person's figures don't add up. If the amounts stored for one person do not add up to their stored total, only the payroll worksheet can be downloaded. That person's row shows the stored figures as they are, with
FIGURES_DO_NOT_ADD_UPunder Warnings, and a note at the end of the file names them. The other six files say why they can't be created. Contact support if you see this.
The Hours and other earnings file
This file is for a payroll provider that works out hourly pay itself from hours and a rate.
Its columns: Staff, Staff ID, Pay type, Hourly rate, Regular hours, Overtime hours, Double-time hours, Commission, Tips to pay, Bonus, Corrections and deductions, Other earnings total, Reimbursements (not earnings), Overtime premium difference (reference - do not enter unless your provider does not include commission and bonuses in overtime), Rounding difference (reference).
- Other earnings total is Commission + Tips to pay + Bonus + Corrections and deductions. The two reference columns are not in it.
- Overtime premium difference is a reference figure, not an amount to pay. The file shows an 'Overtime premium difference' for reference. Some payroll providers already work this out from the commission and bonus amounts. Entering it as well would pay it twice. Ask your provider before you enter it.
- Rounding difference is also a reference figure. SalonHub360 rounds straight-time pay shift by shift, so hours × rate can differ from it by a few cents.
- People paid a salary or commission only are in the file with their other earnings and no hours. Their salary is not in this file.
Who is left out of the Hours and other earnings file
The file leaves a person out when their pay can't be shown as hours at one rate. It lists them before you download, the window says This file is not a complete import, and the file name contains partial. Use the Amounts file for those people. A person is left out when:
- They were paid at more than one hourly rate in the pay period.
- Part of their overtime premium is for overtime hours in an earlier pay period. This happens when one workweek falls in two pay periods and commission earned later in that week changes the week's overtime rate: the later pay period then also pays the difference for the earlier period's overtime hours (or pays less, when the earlier period already paid more). The hours in this file cannot show that amount.
- Their overtime record for the pay period is missing or doesn't match their overtime premium, so the file can't tell whether their overtime premium is only for this period's hours.
- Their pay can't be shown as hours at one hourly rate for another reason, for example someone paid by the hour and by salary in the same pay period.
Nobody is left out of the payroll worksheet, the Amounts file or the four provider-named files: those carry SalonHub360's calculated amounts for everyone.
The Amounts file
Its columns: Staff, Staff ID, Pay type, Straight-time pay (all hours at normal rate), Overtime premium (extra only - not in straight-time pay), Salary, Commission, Tips to pay, Bonus, Corrections and deductions, Earnings total, Reimbursements (not earnings), Total to pay, Total hours (reference - do not use to calculate pay), Regular hours (reference - do not use to calculate pay), Overtime hours (reference - do not use to calculate pay), Double-time hours (reference - do not use to calculate pay).
The hours columns are for reference only. If you enter the hours for your payroll provider to calculate pay and also enter these amounts, the same pay is counted twice.
What columns are in the other files
Every file has one row per staff member in the period. Hours have two decimals and money is a plain dollar amount with no currency symbol. Column names and notes use plain characters only (no special dashes or quotation marks); names are written exactly as you typed them.
Payroll worksheet (generic) (the most detailed): Staff, Pay type, Hourly rate, Rate note, Total hours, Regular hours, Overtime hours, Double-time hours, Straight-time pay (all hours at normal rate), Overtime premium (extra only - not in straight-time pay), Salary, Commission, Tips earned, Cash tips kept, Tips to pay, Bonus, Corrections and deductions, Earnings total, Reimbursements (not earnings), Total to pay, Warnings, Tip events recorded only, Proposed recovery not deducted.
The payroll worksheet has no staff ID column. Total hours is total payable hours (overtime hours included); Regular hours, Overtime hours and Double-time hours split it. If the pay period has notes of its own (for example a minimum-wage check that is pending or was not run), they are listed after the last person, below a blank row, in rows that start with Period note.
The four provider-named files are unverified (see the top of this article). Each has two layouts, depending on the Add a Cash Tips column to provider exports setting (see The Cash Tips column below). It is off by default.
QuickBooks Online (Unverified — not tested with QuickBooks Online): Employee Name, Employee ID, Regular Hours, Overtime Hours, Doubletime Hours, Hourly Rate, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary Pay, Commission, Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
With the Cash Tips column on: Employee Name, Employee ID, Regular Hours, Overtime Hours, Doubletime Hours, Hourly Rate, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary Pay, Commission, Tips, Cash Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
Gusto (Unverified — not tested with Gusto): Employee Name, Employee Email, Employee ID, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary, Commission, Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
With the Cash Tips column on: Employee Name, Employee Email, Employee ID, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary, Commission, Tips, Cash Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
ADP Run (Unverified — not tested with ADP Run): Company Code, Employee ID, Employee Name, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay Amount (all hours), Overtime Premium Amount (extra only), Salary Amount, Commission Amount, Tips Amount, Bonus Amount, Corrections and Deductions Amount, Earnings Total, Reimbursements Amount (not earnings), Total to Pay.
With the Cash Tips column on: Company Code, Employee ID, Employee Name, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay Amount (all hours), Overtime Premium Amount (extra only), Salary Amount, Commission Amount, Tips Amount, Cash Tips, Bonus Amount, Corrections and Deductions Amount, Earnings Total, Reimbursements Amount (not earnings), Total to Pay.
Paychex Flex (Unverified — not tested with Paychex Flex): Employee ID, Employee Name, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary, Commission, Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
With the Cash Tips column on: Employee ID, Employee Name, Regular Hours, Overtime Hours, Double Time Hours, Straight-Time Pay (all hours), Overtime Premium (extra only), Salary, Commission, Tips, Cash Tips, Bonus, Corrections and Deductions, Earnings Total, Reimbursements (not earnings), Total to Pay.
How to read the columns
- Employee ID is SalonHub360's own internal staff ID. There is no field for an external payroll or employee number, so match each person in your provider by name or by this ID.
- Straight-Time Pay is pay for all hours worked, overtime hours included, at the person's normal rate. Overtime Premium is only the extra amount on top of straight time, so the two never count the same pay twice. Overtime Hours and Double Time Hours are the hours that fall under your overtime rule.
- Earnings Total is Straight-Time Pay + Overtime Premium + Salary + Commission + Tips + Bonus + Corrections and Deductions. Reimbursements (repayments of an expense the person covered) are not earnings: they have their own column and are not inside the Earnings Total. Total to Pay is Earnings Total + Reimbursements.
- Tips (provider-named files) is the tips paid through payroll, net of any cash tips the person kept. It is never negative: in an unusual period where the person kept more cash tips than the tips allocated to them, Tips reads
0.00and the difference is taken off in Corrections and Deductions, so the row still adds up. In the payroll worksheet, Tips earned is the tips allocated to the person, Cash tips kept is the cash tips they kept, and Tips to pay is the net figure paid through payroll (it can be negative there, and the worksheet's corrections and deductions are not changed). - Cash Tips (provider-named files, only when the setting is on) is the cash tips the person kept on the day. It is not part of any total: Straight-Time Pay + Overtime Premium + Salary + Commission + Tips + Bonus + Corrections and Deductions = Earnings Total, Earnings Total + Reimbursements = Total to Pay, and Cash Tips is reported separately.
- Commission is the service and retail commission earned in the period. Bonus, Corrections and Deductions and Reimbursements come from the adjustments recorded on the period (a correction or deduction can be negative).
- No minimum-wage column. The files have no column for a minimum-wage make-up. If someone's pay for a week falls below the minimum wage you entered in Settings → Payroll, the period page lists them, and nothing is added to their pay unless you add a Bonus adjustment as a minimum-wage make-up (or correct the pay rate). A make-up you add appears in the Bonus column.
- Warnings, Tip events recorded only and Proposed recovery not deducted (payroll worksheet only): Warnings lists the review notes on the row; Tip events recorded only lists tip refunds or voids from other periods that were recorded but not taken out of pay; Proposed recovery not deducted is the commission recovery that was recorded but not deducted from pay.
The Cash Tips column (optional)
Some payroll providers need the cash tips staff kept so they can be reported for taxes. To add them to the provider-named files:
- Open Settings → Payroll, find the Tips card and check Add a Cash Tips column to provider exports.
- Click Save changes.
From then on, the QuickBooks, Gusto, ADP Run and Paychex files have a Cash Tips column right after Tips. Cash tips are already in the staff member's hands, so they are not part of Total to Pay; your provider can report them for taxes. Leave the box unchecked and the column is left out. The payroll worksheet is the same either way (it always has Cash tips kept). Changing this setting does not change anyone's pay and does not ask you to confirm the payroll setup again.
Example. Kai earned $50.00 commission, was allocated $10.00 of tips and kept $25.00 in cash. Tips paid through payroll would be -$15.00, so a provider-named file shows Tips 0.00 and Corrections and Deductions -15.00; Earnings Total and Total to Pay are 35.00 (50.00 + 0.00 - 15.00). With the setting on, Cash Tips shows 25.00, which is not added to any total.
Entering the numbers in your provider
- Download the file you chose as described above.
- Compare the columns with your provider's import template, and rename, reorder or remove columns in a spreadsheet if your provider needs a different layout. SalonHub360 has not tested importing any of these files into a payroll provider.
- Import or enter the numbers in your provider, then check their preview totals against SalonHub360's Total to Pay figures before you submit. Your provider handles tax withholding, direct deposit and filings.
- Mark the period Paid in SalonHub360 once your provider confirms the run, so your records match.
Related articles