In this article, we explain how to generate general ledger (GL) reports in Remote's Global Payroll product. These reports help you review payroll related costs and prepare accounting entries for your general ledger.
Before you begin
Before running a GL report, make sure:
- You have imported or created your chart of accounts in Remote, and
- Your pay items are mapped to general ledger accounts.
If these steps are not completed, the report will not return data. You will see a message prompting you to complete account mapping, and you will be guided to the relevant screen to do so.
Additional notes:
- If you notice formatting issues with non English characters in your download, use the XLSX (Excel) file format for better compatibility.
- Access to some reports may depend on your permissions (for example, reports showing individual salary data). If a template does not appear, check your access level.
GL report templates available
If a built-in report doesn’t fulfill your needs, you can create your custom report using these templates
- General Ledger - By Cost Center — Summary of all GL account activity grouped by the specific cost center where the corresponding employees are allocated.
- General Ledger - Employee detail — Detailed listing of employee pay items and the associated GL account activity.
- General Ledger - Summary — A comprehensive, high level summary of all GL account activity for every GL account across the entire organization.
How to run the report
- Go to Reports and open All reports.
- Select Create report in the top right corner.
3. On the Create a report screen, select Create with template. (You can also describe the report in the AI box, or choose Create manually.)
4. On the Choose a template screen, type GL in the search box, or scroll to the Payroll section.
5. Pick the template you need, then click Select template.
6. The report builder opens with a preview of your data. Set the report options at the top:
- Report period — choose how the report is grouped in time (for example, Month).
- Legal entity — select the legal entity you are reporting on.
- Period — set the date range for the report.
Optionally refine the report using the right hand panel: Columns, Filters, and Group by. You can switch between the Manual and AI tabs.
7. When you are ready, select Download report in the top right corner.
8. In the Download report window, set the file Name and choose a Format:
- CSV
- XLSX (Excel)
- XLS (Excel 1997-2003)
9. Confirm the download. A Report downloaded successfully message confirms your file is ready.
Troubleshooting and tips
- No GL template showing? Check that you have uploaded your chart of accounts and mapped your pay items to GL accounts.
- Report has no data or will not generate? Make sure you have selected a valid legal entity and period.
- Non English characters not displaying correctly? Download as XLSX (Excel) instead of CSV.
- Still stuck? Reach out to us via chat.
Comments
0 comments
Article is closed for comments.