powerpoint presentation€¦ · •unit price transactions only. common billing issues –fixed...

49
CP-19: Costpoint Setups – Understanding How Proper Setups Affect Your Billing Katie Schlachter, The MIL Corporation Stacey McCarver, Deltek

Upload: others

Post on 20-May-2020

6 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

CP-19:Costpoint Setups –Understanding How Proper Setups Affect Your Billing

Katie Schlachter, The MIL CorporationStacey McCarver, Deltek

Page 2: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Introductions

• Stacey McCarver, Deltek• Select Care Advisor • Premium Support Services• 30 years experience with Government Contracting Software• 19 years at Deltek

• Katie Schlachter, MIL Corp• AP Manager/COSTPOINT Administrator• 17 years of GovCon experience• Contracts/Projects Set Up and Billing Expert• Time and Expense Administrator

Page 3: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Deltek Certifications

Page 4: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Take Away Goals:

• Help Solve the Annoying daily problems that slow down Billing

• Best Practices for Billing Formulas• Troubleshoot Billing

Page 5: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing formulas Available in Costpoint• Cost Incurred Plus Fee on Cost• Cost Incurred Plus Fee on Hours• Enter Bill Manually• LLR W/Fee Plus Non-Labor W/Burden W/Fee• Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)• Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Hours)• Loaded Labor Plus Non-Labor Plus Burden on Non-Labor• Loaded Labor Plus Non-Labor W/Burden W/Fee• Loaded Labor Rate• Loaded Labor Rate Plus Cost Incurred on Non-Labor (T&M)• Loaded Labor W/Burden W/Fee Plus Non-Labor W/Burden W/Fee• Manual Bills with Unbilled Detail• Progress Payment• Rate Scheduled Times Multiplier Plus Non-Labor Cost Times Multiplier• Unit Transactions Only

Page 6: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing formulas Available in Costpoint

Page 7: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing formulas chosen by MIL:

Page 8: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Most Used Billing Formulas by MIL

• CPFC – Cost Incurred Plus Fee on Cost• CPFH – Cost Incurred Plus Fee on Hours• LLRCINLB - Loaded Labor Plus Non-labor Plus Burden On Non-labor• LLRCINL - Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)• UNIT – Unit Price Transactions Only

Page 9: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup

Page 10: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup Screen

Page 11: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup Screen

Page 12: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup Screen

Page 13: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup Screen

Page 14: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Formulas

Page 15: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Cost Plus Billing Formulas

Page 16: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Cost Plus Billing Issues

• Incorrect Setup can cause over-accrual of fee• LOE – Cost Plus fee on Hours• CPFF- Cost Plus Fee on Cost

• Special considerations when changing Billing formulas• Delete Open Billing Detail• Double Billing will occur

• Handling unbillable cost• Set up Unbillable Charge code for Labor• Move ODC’s/Travel to non-billable GL Account

Page 17: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Most Common T&M Billing Formulas

• Loaded Labor Plus Non-labor Plus Burden On Non-labor• Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)

Page 18: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Most Common T&M Billing Issues

• Has the Define Rate Sequence Been Completed• Were Rates Entered in Link Project Labor Category Rates to Project• Complete The Load Labor Rates Process• Are the hours within the POP• How to check if the rates are loaded

Page 19: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&M

Has the Define Rate Sequence been Filled out?

Page 20: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&MAre your Bill rates the same for all projects? If so use this screen to set them up.

Page 21: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&MWere the Rates entered in Link Project Labor Category Rates to Project?

Page 22: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&MWere the Rates entered in Link PLC Rates to Employee/Vendor?

Page 23: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&M

Has the Load Labor Rates Process been completed for the correct Period?

Page 24: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&M

• Are the hours within the POP?

Page 25: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – T&M

Page 26: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Most Common Fixed Price Billing Formula

• Unit Price Transactions Only

Page 27: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – Fixed Price

• Scheduled Billing

• Milestone Billing

• Once Setup typically not a lot of issues

• The Bill Date

Page 28: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Common Billing Issues – Fixed Price

• Does the Schedule have the correct Dates?• Is the bill date on or after the Date to bill in Manage Project Billing

Information

• Is there travel cost incurred? If so, 2 ways to handle it• Add a line to the schedule for the travel amount

• Set up billing at the lowest level, so that you can bill the fixed price Labor and the travel/ODC with Burdens

Page 29: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Fixed Price Billing

• Unit Transactions

Page 30: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Fixed Price Billing

Page 31: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Non-Contract Type Specific

Page 32: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Billing Setup Issues

• Other Lines – How to correct

• Transactions Not showing in Open Billing Detail

• Project Ceilings

Page 33: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 34: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 35: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 36: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 37: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 38: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 39: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

OTHER Line

Page 40: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Transactions not in Open Billing Detail

Cause – Cost were posted before the billing formula was set up

How to fix it- Run Open Billing Detail Utility

Page 41: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Ceiling Issues

Are Ceilings on the Level with Funding?

Page 42: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

POP QUIZ!!

Page 43: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Other Line Showing on the Invoice

Page 44: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

T&M No Hours/Rates

Page 45: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Fixed Price – No Schedule Billing

Page 46: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Invoice is over Ceiling

Page 47: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of

Questions?

Page 48: PowerPoint Presentation€¦ · •Unit Price Transactions Only. Common Billing Issues –Fixed Price •Scheduled Billing •Milestone Billing •Once Setup typically not a lot of