Sage 100 Training and Tutorials: General Ledger
Welcome to our comprehensive training page for Sage 100 General Ledger! Whether you’re a small business owner trying to keep your finances in order, an accounting professional looking to improve your efficiency, or a new user hoping to master the complexities of this powerful software, you’ve come to the right place. Our training materials are designed to provide you with the knowledge and tools to fully leverage the capabilities of Sage 100’s General Ledger system. From understanding basic functionalities to exploring advanced features, we aim to enhance your proficiency, streamline your operations, and elevate your financial management to new heights.
How to Create a Standard Journal Entry in GL
What you can Expect to Learn:
- Standard journal entries in Sage 100 are used as templates for recurring entries with the same account numbers but different dollar amounts.
- Multiple standard journals can be saved for each Journal code.
- To create a standard journal entry, access the General Journal Entry, select the Source Journal, enter the posting date, comment, and GL accounts with debits and credits, and save it as a standard journal.
- Standard journal entries can be modified by accessing the standard journal without dollar amounts, adding or deleting GL account numbers.
- Users can also copy a standard journal entry to create a new one with similar account numbers, and unwanted standard journal entries can be deleted by selecting and clicking "delete."
How to Add New GL Value for GL Segment and Create Accounts
What you can Expect to Learn:
- The first segment in Sage 100 is the main segment, followed by multiple sub-accounts like Department and Location.
- The Account Structure Maintenance defines the account numbers and separators between segments.
- The Sub-Account Maintenance is used to set up new locations, with a short description field being crucial for auto-generating account numbers.
- The process involves using the "Generate Accounts" task under General Ledger and Utilities, with the option to apply it to specific income statement accounts and departments.
How to Import General Ledger Journal Entries with Visual Integrator
What you can Expect to Learn:
- Using a spreadsheet with four columns: GL account number, comments, debit, and credit.
- In Visual Integrator, an import job is created, using the "GL Journal header" table for the import.
- Setting up the import by specifying source journal, entry number, posting date, and other parameters.
- After testing and reviewing, the journal entries are successfully imported into Sage 100.
How to Make Copies of Company Data
What you can Expect to Learn:
- Copying company data is beneficial for year-end processing to avoid data purging.
- A copy company can be used as a test or play company to try out system changes before implementing them in the live company.
- It can also be utilized for training employees without affecting the live data.
- The process involves selecting the source and destination companies and choosing modules to copy, and it's essential to double-check these choices to avoid data loss.
How to Work with General Ledger Budgets
What you can Expect to Learn:
- Budgets can be created through General Ledger Account Maintenance.
- There are different ways to modify budgets, including changing amounts by percentage, copying budgets, or adjusting budgets by amounts or percentages.
- Budgets can be revised based on the original budget, and the Budget Revision Entry feature allows a detailed view of changes before updating.
- The Budget History Report helps identify accounts without budgets and can be filtered based on different criteria.
want more detailed training? Contact us today!
Resources
The DSD resource center is your one-stop shop for everything you need including whitepapers, brochures, webinars on-demand, customer testimonials, and more!
