Stored Procedures - Using Sql to automatically create the following:
Journal Entries - Ideal for Allocations
(Similar to Oracle's "Mass Allocation")
1. Calculations to allocate costs by profit center.
2. Create journals to post STATS from Info Center Tables.
3. Calculations for DSO, Backlog Burn Rates etc.
Mass Allocations: A journal entry formula that allocates revenues or expenses across a group of cost centers, profit centers, departments, divisions or Companies (Orgs).
Use a Mass Allocation formula to automatically create journals, instead of manually calculating in a spreadsheet and then keying in or importing the journal for posting. A single formula can perform multiple allocations. These allocations are done via a SQL Stored Procedure. These are system shortcuts that can simplify your life, automate closing entries and take you out of spreadsheet calculations improving your monthly close time and reporting process. There is no limit for uses of a SQL Stored Procedure, Allocations of Corporate Overhead, Professional Liability Insurance, Fringe Benefit Costs, Rent, Other Expenses, WIP Adjustments and even Overtime Premium Costs not posted in timesheets just to name a few.
Mass Allocations versus Recurring Journals
Accounts Payable Batch - Ideal for Multi-Office
1. AP Imported from Spreadsheets.
2. AP Batch's Validated with Sql for duplicate invoices.
3. AP Validation for "lowest level" verification.
Accounts Payable ACH Payment Processing
1. ACH/Direct Deposits for Vendor Invoices & Expense Reports.
2. ACH/Direct Deposit Automated E-mails.
Cash Receipt Processing
1. Cash Receipt posting by Spreadsheet.
2. Electronically "linked" Spreadsheet to Data Base records.
Publication of Reports to "Intranet" WEB
1. Publishing to Intranet using Special Windows Applications.
Areas of Expertise in DELTEK VISION
- AP 1099 Processing
- AP ACH to Vendors,
- AP Electronic Payments
- BILLING Billing Refresh
- BILLING Billing Terms
- BILLING Invoice Templates
- BILLING Labor Categories
- BILLING Labor Codes
- BILLING Pre-Bills without Revenue Recognition
- BILLING Retainage
- BILLING Retainers
- CONFIGURATION Auto Accounting Rules, Time Analysis
- CONFIGURATION Dashboard Setup
- CONFIGURATION Org Setup, Auto Accounting Rules, Time Analysis
- CONFIGURATION Time Analysis
- EMPLOYEE Direct Deposit for Employees
- EMPLOYEE Expense Categories
- GL Cash Basis Accounting Mapping & Configuration (see my blog: http://www.deltekvisionconsultant.com/blog/cash-basis-accounting/ )
- GL GL Calendars, Standard or 4-4-5
- GL GL Periods, 12 or 13
- GL Tax Setup and Reporting
- HR Benefit Accruals and Setup
- PAYROLL Job Cost Variance
- PAYROLL Payroll Cycle vs. Timesheet Calendars
- PAYROLL Withholding Codes, Contribution Codes for automated Accruals.
- REPORTING Accounting
- REPORTING Balance Sheets
- REPORTING Employee
- REPORTING Income Statements
- REPORTING Project Reports
- REPORTING Report Configuration
- REPORTING Tax
- REV GEN reports to support the Balance Sheet (see my blog: http://www.deltekvisionconsultant.com/blog/revenue-recognition-rev-gen/ )
- REV GEN Revenue Methods as required for Project needs.
- SECURITY Roles, Security
- SECURITY Setup with Security, Required, Hidden and Locked Fields
- TS Adjusted Salary Job Costing (see my blog: http://www.deltekvisionconsultant.com/blog/adjusted-salary-job-costing/ )
- TS Labor Cross Charge, Reports Configured to support the Income Statement.
- TS Timesheet Categories with Automated Assignment by Employee Org
Month End Close - Automated Journal Entries can be created from a calculation. Ideas for use are:
Calculations for Allocations across departments. As an example, if you allocate Liability Insurance by Department based on their share of Revenue, Corporate Overhead by Department based on Wages or Headcount, WIP Adjustment by Department, or anything else a stored procedure can perform the calculation and Create the journal entry. You simply click “Post”. Look at all your closing entries, if there is a Spreadsheet involved followed by you creating a journal entry, a Stored Procedure could do that with one click of your mouse. Former users of Oracle may recognize this as the General Ledger Mass Allocation process, however this is NOT limited to Journal Entries. Another common need is Calculating and Posting the Overtime Premium if Overtime Hours NOT entered in timesheets.