Create a Custom Journal Entry Report

Can I choose what to include in my Journal Entry report?

Purpose: This guide will explain our Custom Journal Entry builder which allows you to configure your Journal Entry Report, select the segmentation details you need, and input your specific General Ledger (GL) codes.



Would you like to watch a video about this topic?

Custom Journal Entry report

Journal Entry reports have made it easier than ever to transform your payroll data into a standard accounting format so that you can quickly import the necessary debit and credit information into your accounting software. We provide a standard Journal Entry report that can be segmented by department or division. However, if there is additional data you'd like to add, you can use our Custom Journal Entry builder to customize your report.

 

Creating the Report

If you've created a journal entry report before, navigate to Settings > Payroll > Journal Entry, then select the gear icon and click Add Another Report Configuration. Then, select the custom option under the Configuration Options and give your report a name. Please note that once you save your new report, you will not be able to change its name.

If this is the first journal entry report in your account, you will go through our setup modal. First, select Build a Custom Journal Entry under Step 1. Then, enter a name for your report. Be aware, after the report has been saved you will not be able to change the report's name.

To apply a grouping and add GL codes, simply click on one of the categories (Wages, Employee Deductions, etc.), to expand the folder. You can then group the categories by Department, Division, Employee Name, Employee Work Location and Employee Home Location. You may choose up to two groupings for each category. Once you've chosen a grouping, you'll see an indication of how many General Ledger Codes should be added.

Clicking Add Codes will open your report and show your categories and groupings. You can add your GL codes in the right-most column. You can also use the filtering option to add your codes smaller batches. When you're finished, you can click Save Codes.

Before publishing, make sure you review your report. You can filter by category, and by the groups you've created. You can only preview unpublished reports.

After previewing your report, you can select Publish Report, Save Draft, or Cancel. To see this custom report in the Reports tab, you must publish the report. If you select Publish report and you've left some codes blank, you'll see the warning below.

Viewing the Report

To view the report, navigate to the Reports tab > Payroll Reports > Pay Date Reports. Then, hover over Journal Entry Report and click the download button. If you have not yet published the report, it will not show up on the Payroll Reports tab!

Once you've clicked Download, select the name of your custom report, and click Download Report.