Embedded Payroll with Gusto
  1. Help Center
  2. Embedded Payroll with Gusto

How to pull a General Ledger Report in GoCo

Payroll admins and accountants can now configure and run a general ledger report for their pay runs directly from GoCo. Keep reading to learn how!

GoCo's new General Ledger report will:

  • allows users to custom map their accounting codes to payroll earnings, deductions, reimbursements, garnishments and taxes.

  • allows users to split the GL report by Division, Department, Job, and Work Location

  • easily see payroll totals across the split dimensions

  • access the raw data for the General Ledger report so that they can slice and dice the data how they want.

To pull this report, you'll need to visit the Report's app. Use the navigation tabs on the left side of your screen to get there easily. 

Screen Shot 2024-01-10 at 10.27.19 AM

Locate the Payroll section of your Standard Reports. Expand this section & click on the "General Ledger". 

Screen Shot 2024-01-10 at 10.28.47 AM

Now you will be prompted to fill out some details about the report you'd like to pull. Starting with your "Payroll Schedule". Choose between a scheduled payroll & an off-cycle payrun. 

Screen Shot 2024-01-11 at 12.52.09 PM

After selecting your payroll schedule, select between a single pay period or a date range. 

Screen Shot 2024-01-11 at 1.03.56 PM

Depending on your selection, you will then either select your specific payroll period - 

Screen Shot 2024-01-11 at 1.07.00 PM

or the date range you want to pull from. 

Screen Shot 2024-01-11 at 1.07.51 PM

Next, you will decide how you want to split your journal entries. You can split by work groups including division, department, job, & work location. 

Screen Shot 2024-01-11 at 1.14.08 PM

After selecting your work groups, use the mapping tool to map your chart of accounts to journal entries in the General Ledger report. 

Screen Shot 2024-01-11 at 1.32.04 PM

A new window will appear with each selection you make allowing you to input any Codes you may have.  Keep in mind that fields do not need to be mapped. If a field is not mapped, the code column in the GL report is empty. Additionally, if no fields are mapped under a category (Division, Dept., Job, Location, Account) the “code” column does not appear in the GL report.

Screen Shot 2024-01-12 at 9.52.42 AM

If you do choose to input codes, note that you can select existing codes or you can import codes. You can also manage these existing codes & map multiple divisions at once. 

Screen Shot 2024-01-12 at 10.02.58 AM

Once you've completed inputting all of your desired information, hit the "Generate Payroll Receipt" button.  

Screen Shot 2024-01-12 at 10.08.13 AM

Your report will now generate! 

Screen Shot 2024-01-12 at 10.09.35 AM

Your report will be in XLS format & will download to your desktop.
Screen Shot 2024-01-12 at 10.10.19 AM

Your report will contain all fields & codes you selected. You can now manipulate this report however you wish! 

Screen Shot 2024-01-12 at 10.15.40 AM

Crash Course

 

If you have any additional questions, please reach out to your Payroll Specialist or email embeddedpayroll@goco.io for assistance. 

 

 

Happy Reporting! 📊

Published 1.12.24