Report Writing for General Ledger and Accounts Payable Staff Course number: RW203

Overview Learn how to create reports of general ledger and accounts payable information. Participants are encouraged to bring samples of reports they need to create. Workshop time will be allotted to create some of these reports.

In order for participants to gain an in-depth understanding of General Ledger and Accounts Payable files used for report writing, this course focuses heavily on files and database relationships. Query/400, using account payable detail data, will be taught as the reporting tool to access these files and to write reports. Participants will also learn how to “package” groups of queries together and to alter standard BTI/HSS menus to include newly created reports.

Prerequisites Knowledge of agency’s chart of accounts, financial statements, and fiscal reporting needs and requirements. Operational knowledge of General Ledger and Accounts Payable functions.

Intended Audience Accountants, Controllers, Chief Financial Officers, accounting personnel that are responsible for compiling accounting data for management review, and MIS staff responsible for producing reports containing payable and/or ledger information.

Content Intermediate

Agenda Day One:
* General Ledger detail files
* Accounts Payable detail files
* Files with Chart of Account information
* Creating Reports for Accounts Payable with Query/400
- The Basics of Query using the “Paid Invoices” file
- Working with more than one file
* Query Workshop


Day Two
* Creating reports for General Ledger with Query/400
- “Packaging” queries using Run Lists
- Menu Design: adding your reports to BTI menus

Optional: Private consultation is available following the course to assist with individual needs. Extra fees apply.

Logistics • Courses are held at BTI’s office in Vineland, New Jersey.
• Beverages and lunch are provided for each full classroom day.
• Morning and evening meals are the responsibility of attendees.
• We are within convenient driving distance from both Philadelphia and Atlantic City airports and attractions.
• Attendees are responsible for providing their own hotel and travel accommodations.
• A listing of local hotels, restaurants, and directions will be provided upon course registration.
• We reserve the right to cancel or change scheduled course dates based on minimum attendance requirements.

Availability This course is usually scheduled to immediately follow GL101 - General Maintenance and Operations. Course dates will be scheduled upon request.

Cost $ 250 Individual
$ 200 Two or More

Private consultation is available following the course - $500/day