Estimate Tracking - Billable Expenses vs Progress Invoicing?

I have a consulting company.  We create invoices with target hours of work at an agreed upon rate plus estimated travel expenses.   

When I create an invoice, I use progress invoicing again the estimate, which works great for the hours of work.   Each person has a line-item rate, so I can use what is pulled in from the estimate and enter how much of the estimate we "consumed".

Travel Expenses are the problem.   In the Estimate, I have one line item, entered as either Expenses or Travel Expenses.   In my list of Products/Services, I have this line item (Expenses, for example) set-up as a Service with the Income Account equal to "Billable Expense Income", and I have tried multiple settings with either "I purchase this Service" or without that setting.  When using it, I select the Account as Travel Expenses.

Now, must of my consultants are independent contractors, who submit their invoices to me for both labor and expenses.   Therefore, when I create invoices for my client, I pull the expenses into the invoice as Billable Expenses.

The invoice generates perfectly.

The problem I have is when I run tracking reports against the Estimate.   When I go back to view the invoice, I see the progress against the hourly labor, but the tracking against my travel expenses continues to show 0 against it.   If I look at total invoiced to the client, these expenses show up as expected.   But when I use any of the built in reporting to show Estimate Vs Actuals, the travel expenses (billable expenses) are completely left off the report.

So, what am I doing wrong, or what should I look at?   I suspect it is a problem with how I have set-up the travel expenses line item in the estimate, but I don't know.

A few other comments.   I have to pull the billable expenses in to the invoice (I can't just put a line item for the total) as my clients require adherence to their travel policies show I have to show each line item expense.    My estimates are for overall expenses, and are not broken into the various sub-categories of Travel Expenses that I use for the Billable Expenses (Airfare, Travel Meals, Taxi, etc.).

Now, I am an engineer, not an accountant.   So, I am very analytical, but I may need the explanation to be in simpler terms than some experts on this forum prefer.   This also means that suggestions may want to start with the simplistic troubleshooting questions (like, okay, is the computer plugged in).   

I have asked this same questions a couple different ways in the past, but hope I have painted a much clearer picture this time.   I appreciate any guidance. 


You asked this already, and that topic is here:

There is no reason to start from Scratch, again. It is already partly answered, and it helps if you Update the current topic where you already have provided info and gotten some help.

I will Close this Duplicate.

Was this answer helpful? Yes No

No answers have been posted

More Actions

People come to Accountants Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach: