Jobs and timesheets with external resources

(0) Share

Report

Posted on by Lukasz Sadownik

Domestic customer has two contracts:

1. Fixed price prepaid (calculated based on estimated usage)

2.Time&Material billed based on actual resource usage

There are two resources:

1.Employee with fixed salary in same currency

2.External contractor billing per hour in foreign currency

Each resource can allocate time to each contract.

Expected outcome:

Contract 1: only one invoice to customer, any cost allocated based on reported usage to monitor contract performance.

Contract 2: reported usage billed to customer based on contract pricing.

Time reported by contractor should account for exchange rate changes when allocating costs.

Contractor is filling in the timesheet that can have work for multiple customers and sending one consolidated invoice per each timesheet monthly. Payments are made in base currency and exchange rate gain/loss is posted to P&L.

I was hoping to use jobs and timesheets but I'm facing few issues:

1. External resource cost in foreign currency

2.Reflecting exchange rate gain/loss in contract cost allocation

3.VAT rates applied (will work on that once I can resolve 1&2)

I'd appreciate any suggestions on how and if this can be achieved with jobs and timesheets.

All responses (2)

Answers (0)

Suggested answer

Lukasz Sadownik 65 on at

Like (0)

Report

RE: Jobs and timesheets with external resources

Thanks for the suggestion. I think the end result is what I'd expect but there is still gap between matching invoice to actual timesheet which, so I'll have to do bit more exploring on this to come up with best solution.
Suggested answer

JAngle 33,159 on at

Like (1)

Report

RE: Jobs and timesheets with external resources

Given the extra considerations would it make more sense to process a purchase invoice instead? You can link the lines to the job and job task. Similar to timesheets you can transfer the created job ledger entries to job planning lines so you have a billable line. Resource records are blocked for this usage however. So it would be a case of using a resource record for planning only for externals.

You will get an invoice regardless so makes sense in that regard. Invoices allow you to manipulate currency rates and VAT too