Skip to main content
September 6, 2021
Question

Can expenses be split across all projects based on total revenue?

  • September 6, 2021
  • 1 reply
  • 0 views

We are a pavement company that does a lot of line painting. We use recurring items throughout the year - railroad chalk ($300 annually), touch up paint cans ($200 annually), etc. Is there a way to put these on ALL annual projects based on a percentage of revenue? Or is this typically too granular of job costing?

 

Example: If we doo 100 projects a year, ranging from $1000 revenue (smallest project) to $100,000 revenue (largest project) - Can we split a recurring item, such as railroad chalk, every month/quarter/annually without MANUALLY splitting it on every project - but prorate it so that the larger projects take a higher cost of the expense?


We do over 100 projects a year so trying to manually split would be time consuming.

 

Thanks! Alternative suggestions welcome.

1 reply

September 7, 2021

Hi CamaLama.

 

Being able include an expense to a project based on a percentage of revenue is a great idea to save you time on projects. I'd be happy to go over projects with you in QuickBooks Online.

 

QuickBooks Online makes entering and tracking your expenses for a job easy with the projects feature. At this time there is no way to set up a recurring item for a project to charge for a percentage of the revenue. If you wish to have it tracked this way you'll need to manually enter the amounts. If this is a feature you wish to have in QuickBooks Online I recommend sending feedback to our development team by following these steps: 

 

  1. Select the Gear icon at the top, then Feedback.
  2. Enter your comments or product suggestions. Then select Next to submit feedback.

Once they receive your product suggestion they'll look into ways to possibly add this feature in future updates.

 

If you have any questions let us know and we'd be happy to help.