General Ledger Account Mapping

General Ledger Mapping

The general ledger (GL) is the core of any financial management system. It encompasses the functions required to maintain a company’s books.

AdvanStaff HR provides a customized solution to streamline your accounting general ledger reporting to save you time, improve accuracy, and increase efficiency.

  • G/L mapping provides a customized report or import file that breaks out payroll, taxes, benefits, and other accounting items and allocates them to the appropriate account.
  • G/L Mapping increases efficiencies by eliminating the manual input of pertinent payroll information into your accounting system.
  • Specialized reports make your GL entries more accurate by eliminating manual errors.
  • Import files and GL reports are available “on demand” when a payroll is posted. 
  • Allocate by Employee Name, Employee Number and/or ID, Position, Department, Division or Location.  The AdvanStaff HR accounting department will assist in the setup of the process and workflow.
  • GL output files can be created in .txt, .csv and .iif formats. Please note – .iif format is just for Quickbooks Desktop. Quickbooks Online will only accept .csv files. 

Items Needed

  • Current chart of accounts from your accounting software.
  • Copy of the journal entry for your most recent payroll – this will allow us to cross check our output after the template is built.
  • Final output file format. The layout that your accounting software needs to upload from our system. 

Please get started by sending us a quick request or talk to your assigned payroll or human resources specialist.

Examples of file formats