PaySauce handles your Single Touch Payroll (STP) and superannuation filing automatically, but you'll still need to gather payroll data for other reporting requirements like your Business Activity Statement (BAS). The reporting feature in PaySauce gives you the flexibility to create custom reports based on your specific needs.
What PaySauce reports for you automatically
PaySauce automatically handles:
Single Touch Payroll (STP): Reported to the ATO with each pay run
Superannuation filing: Submitted to superannuation funds with each pay run
Annual STP finalisation: Coming soon
For all other reporting needs, you can use PaySauce's flexible reporting tools.
Payroll activity report
The payroll activity report allows you to gather payroll information for any time period with the specific data points you need. While designed with BAS reporting in mind, it's flexible enough to meet various reporting requirements.
Creating a payroll activity report
Step 1: Access reports
Select Reports from the navigation menu.
Step 2: Review the default report
By default, the report shows:
All employees
Tax and gross pay for each employee
Data for the current quarter (standard BAS requirements)
Customising your activity report
Selecting data columns
Use the Selected columns dropdown to choose which information to include in your report.
Available columns:
Net pay
Gross pay
Tax
Deductions
Child support
Super sacrifice
Child support garnishee
Base rate
OTE (ordinary time earnings)
Tax scale
Overtime pay
Medicare levy
Taxable income
Super guarantee
Tax treatment code
Sick leave accrued (hours)
Annual leave accrued (hours)
Student loan tax component
How to add or remove columns:
Open the Selected columns dropdown
Select (tick) any columns you want to include
Deselect (untick) any columns you want to remove
The report updates immediately to show your selected columns.
Set the time period
Use the Pay date in dropdown to select the reporting period:
Standard periods:
Current quarter: The current three-month BAS period
Last quarter: The previous three-month BAS period
Year to date: From July 1 to the current date
Custom period:
Select Custom range
Set your own start and end dates
Select employees
All employees are automatically included in reports by default.
To remove an employee from the report:
Locate the employee in the report list
Deselect (untick) the checkbox on the left of their row
The employee's data is immediately removed from the report.
Adding employees back
To include an employee you previously removed:
Locate the employee in the list
Select (tick) the checkbox on the left of their row
The employee's data is added back to the report.
Downloading your report
Once you've customised your report with the data you need:
Select Download report
The report downloads instantly as a CSV file
You can then open the CSV file in Excel, Google Sheets, or your accounting software.
Common reporting scenarios
BAS (Business Activity Statement) reporting
Default setup works for most BAS needs:
Time period: Current quarter
Columns: Tax and Gross pay
Employees: All employees
Simply download the default report each quarter for your BAS.
Year-end reporting
For annual financial reporting:
Change time period to "Year to date"
Add columns as needed for your accounts (Net pay, Gross pay, Tax, Super guarantee)
Download report
Leave liability reporting
For balance sheet reporting:
Deselect all columns except leave columns
Add: Sick leave accrued, Annual leave accrued
Set time period to "Year to date"
Download report
Superannuation reporting
For super verification:
Add columns: OTE, Super guarantee, Super sacrifice (if applicable)
Set time period as needed
Download report
Employee cost analysis
For budgeting or cost analysis:
Add columns: Gross pay, Tax, Super guarantee, Overtime pay
Set custom date range for your analysis period
Download report
Working with downloaded reports
Opening CSV files
The downloaded CSV file can be opened in:
Microsoft Excel
Google Sheets
Apple Numbers
Most accounting software packages
Using the data
Once downloaded, you can:
Import into your accounting software
Use for BAS preparation
Calculate leave liabilities
Analyse payroll costs
Create custom charts and graphs
Share with your accountant or bookkeeper
Report tips
Check your date range
Always verify your date range matches the period you're reporting on, especially for BAS reporting where quarters have specific start and end dates.
Include all relevant employees
Unless you have a specific reason to exclude employees, leave all employees selected to ensure your reports are comprehensive.
Download before changing settings
If you need multiple reports with different settings, download each one before changing your selections.
Common Questions
The report doesn't show recent pay runs
The report doesn't show recent pay runs
Make sure your date range includes the recent pay runs. If using "Current quarter," verify that the pay runs fall within the current quarter dates.
Some columns show zeros
Some columns show zeros
Not all employees will have values in all columns. For example, only employees with student loans will show student loan tax components. Zero values are normal for inapplicable columns.
I can't find the report I just downloaded
I can't find the report I just downloaded
Check your browser's default download location. CSV files typically download to your "Downloads" folder.
The CSV file looks scrambled when I open it
The CSV file looks scrambled when I open it
Different spreadsheet programs may format CSV files differently. Try opening the file in Excel or Google Sheets and adjusting the column widths if needed.
I need data that's not in the available columns
I need data that's not in the available columns
If you need specific data that's not available in the reporting columns, contact PaySauce support. We may be able to help you access the information or add new reporting options.
Need help?
If you have questions about which columns to include for specific reporting requirements, or need help interpreting the data in your reports, contact PaySauce support or your accountant.