7shifts Payroll Accounting Summary report
7shifts Payroll provides a double-entry accounting summary report to help you reconcile your books with precision by categorizing payroll data into debits and credits.
Things to know
Important: Only users with Admin permissions can access and generate the Payroll Accounting Summary report.
- The report can include data for Regular and/or Off-cycle Payroll runs that are currently in processing or paid states.
- Exported files are provided in CSV and XLSX (Excel) format for easy use within accounting software.
Generate a payroll accounting summary report
From the Payroll page:
- Log in to 7shifts as an Admin.
- In the left navigation bar, select Payroll > Reports.
- Select Payroll Accounting Summary.
- Use the drop down menu to select Business entity (if more than one).
- Choose how to Break the report earnings by: Location, Department, or Role.
- Set the desired Payroll year and select the Regular and/or Off-cycle Payroll runs you would like to include in the report.
- Select Report Type (CSV or XLSX).
-
Click Download Report.
From the Reports page:
- Log in to 7shifts as an Admin.
- In the left navigation bar, select Reports > Payroll reports.
- Use the drop down menu to select Report type > Payroll Accounting Summary.
- Use the drop down menu to select Business entity (if more than one).
- Choose how to Break the report earnings by: Location, Department, or Role.
- Set the desired Payroll year and select the Regular and/or Off-cycle Payroll runs you would like to include in the report.
- Select Report Type (CSV or XLSX).
-
Click Download Report.
Note: Selecting only Location will exclude finer details like specific department and roles from the final export. While you can view earnings and true cost visibility at the department and role levels, please note that taxes and deductions are not broken down by these specific filters.
Understand the accounting summary export
The payroll accounting summary uses a double-entry ledger format where total debits and credits always match to ensure the account balance equals zero.
- Debits: These represent the total cost to the employer, including employee wages and taxes paid by the business.
- Credits: These show the breakdown of liabilities, such as tax withholdings and net pay to employees.
- The report export includes columns for Category, Description, Location, Dept (if filtered in), Role (in filtered in), Debit, and Credit.
Related articles
7shifts Payroll Reports
7shifts Payroll Summary/Journal Reports