1 / 32

Abra SQL Payroll – MAS 500 GL Interface Overview and Workflow

Abra SQL Payroll – MAS 500 GL Interface Overview and Workflow. General Ledger - 101. General Ledger 101 - General. The general ledger is the main accounting record of a business which uses double-entry bookkeeping. It will usually include accounts for such items as: Current assets

airlia
Download Presentation

Abra SQL Payroll – MAS 500 GL Interface Overview and Workflow

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Abra SQL Payroll – MAS 500 GL Interface Overview and Workflow

  2. General Ledger - 101

  3. General Ledger 101 - General The general ledger is the main accounting record of a business which uses double-entry bookkeeping. It will usually include accounts for such items as: • Current assets • Fixed assets • Liabilities • Revenue • Expenses • Gains • Losses The general ledger is where posting to the accounts occurs.

  4. General Ledger 101 – Chart of Accounts Peachtree Sage Sage SP Sage Pro Sage 100 MAS 90 MAS 200 Sage 200 Accpac ERP Sage Timberline MAS 500 Sage 1000

  5. General Ledger 101 - GL Segments 7250-12-300 Main Division Department 12-7250-6984 Division Main Project 6984 - HQ - 7250 - 12 Project Location Main Division 262 - 240 - 12 - 7250 Abra Training Channel Sales Airfare Expense

  6. General Ledger 101 The general ledger should include: • Date • Description • Amount for each account It is usually divided into at least seven main categories. These categories generally include: • Assets • Liabilities • Owner's equity • Revenue • Expenses • Gains • Losses

  7. General Ledger 101

  8. GL Setup in Abra SQL Payroll

  9. GL Setup in Abra SQL Payroll

  10. Pitfalls of GL Journal Entries • Manual GL Entries • Generate GL Report • Manual Entries to GL • Errors in Data Entry • GL Segments Mismatches GL Accts Payroll Expenses, Liabilities,…. • Importing GL Entries • Export File Format • Report Generation • Adjustments / Edits • GL Segments Mismatches

  11. Abra SQL Payroll Data – MAS 500 GL Workflow

  12. GL Interface Overview The Abra / MAS 500 GL Interface automates the preparation and transfer of activity from Abra SQL Payroll to the MAS 500 general ledger, eliminating the need to manually prepare and type journal entries. The Abra / MAS 500 GL Interface additional features include the ability to assemble data, create reports, audit, and prepare data for MAS 500. This intelligent interactive interface is a “back-end” program – meaning it is used after payroll. Under operator control, this interface extracts a batch of data from the payroll history, prepares it and reports it for audit and acceptance, and transfers the assembled batch in the prescribed manner for the GL to receive.

  13. Complete Solution MAS 500 Abra HRMS Abra ESS Accounts Payables Abra HR Accounts Receivables Abra Train Cash Management Abra Payroll General Ledger GL Abra Attendance Project Accounting Interface Abra BE/LE Inventory Management Abra eRecruiter Purchase Orders

  14. Workflow Diagram Abra SQL Payroll History Tables Abra SQL Payroll History Tables MAS 500 GL • Liabilities • Expenses Data Assembly • Report • Audits • Edits • Prep Import to MAS 500 GL Interface ABRA / MAS 500 GL Interface

  15. Data Flow Abra HRMS SQL Data Assembly GL Overrides Audits Reports Data Export Payroll History BAS GL Interface GL Accounts Salary Wages FICA FICA SOC FICA MED 401(k) Insurance Disability 1099 Exp Misc Earnings Unemployment Payroll Taxes GL Import MAS 500 ERP

  16. Benefits of Using the Abra MAS 500 Interface • Find errors before they reach GL • Identify errors on audit reports • Audits help ensure data integrity • Save time and reduces errors during data entry • Translation tables provide greater account creation flexibility • No need to change software just to achieve integration • Interface Abra Payroll system and your current MAS 500 General Ledger

  17. Abra SQL Payroll – MAS 500 GL Utility Overview

  18. GL Interface

  19. Assemble Data

  20. Reports

  21. GL Account Detail By Check

  22. GL Account Detail Report

  23. Report to Worksheet

  24. Report to CSV

  25. Transfer Data

  26. Data Export

  27. MAS 500 GL Data Import

  28. MAS 500 GL Data Import

  29. MAS GL Data Import

  30. Abra Payroll – MAS 500 GL In MotionProduct Demonstration

  31. GL Interface Product Overview

  32. Frequently Asked Questions What version of MAS 500 and Abra do I need? MAS 500 Versions 7.05 and 7.2. Where can I install this utility? The utility may be installed on the same application server as MAS500 and/or Abra. Is there training available? Installation and Implementation Training will be available on line. Will it work with other accounting apps? No Can I customize this interface to transfer other data? It will require a customization written by BAS.

More Related