Billing Specific Clients A Flat-Rate On Per-Diem Meal Types
(Doc ID 2439400.1)
Last updated on AUGUST 27, 2018
Applies to:Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Misc Billing Issues
Billing Specific Clients a Flat-Rate on Per-Diem Meal Types
In Projects, per-diem meals are charged by employees to a project and then are billed back to the client. But because meals are tax-included, the adjusted cost base of the meal varies from province to province if there is a different tax basis.
1) Breakfast Per-Diem: $15/day (tax included)
2) Employee from Québec: Breakfast is then broken out to become $13.18/breakfast + $1.82 taxes = $15.00
3) We wish to bill a specific project a flat rate of $10.40/breakfast BEFORE taxes
4) In Bill Rates & Discount Overrides (See Note 1), for this specific project, we can define a markup% to rebill (See Note 2)
ENTERING BILL RATES FOR SPECIFIC PROJECTS:
Oracle --> Project Billing Super User --> Projects --> Number: (enter project #) --> Click "Find" --> Click "Open" --> Options: Option Name: Bill Rates and Discount Overrides: Non-Labor Bill Rate and Discount Overrides -->
= Original x (1 + MU%) = Bill Rate
= (1 + MU%) = (Bill Rate / Original)
= MU% = (Bill Rate / Original) - 1
= MU% = ($10.40 / $13.18) - 1
= MU% = -21.09%
Because "Original" amount can vary depending on sales tax of each province, there is no way to include a markup/discount rate that factors in tax rates into the equation. Is there a simple way to charge a flat rate per meal type? The other option the user could think of would be to create every single permutation of mark up % rate (i.e. (10 provinces + 3 territories) x 4 per diem meal types = 52 individual markup % bill rates for the project)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document