Create Invoice Based on Time Tracked in Given Period

Current Quotes & Invoices tool is too bare bones for a creative agency with a retainer relationship with clients. It also requires manual creation of each line item in the invoice. Seeking capability for the following functions:

  • Create invoice based on all items in board
  • Create invoice based on all items in board with time tracked in a given period (this month, last month, last quarter, user defined custom date range)
  • Set default billing rate for time tracked
  • Set custom billing rates for different types of work. E.g., time tracked as a Designer = $50/hour and time tracked as Developer = $75/hour. Custom billing rates could be a column, or tag, not tied to the user because one user could do different types of work or have different billing rates for different clients.
  • Option to pull in items from other boards (maybe one client is connected to multiple boards, would be helpful to make one invoice for all items for that client, grouped by board).

@mrautomation - Do you think the planned roadmap for Automated Invoice Tracker might handle all of these requirements, for automatic billing through QBO in 2022?

~ Deb Cinkus, PMP
Certified monday․com Partner
CEO & Principal Consultant, Polished Geek

Book a Consultation with a monday․com expert: https://meet.polishedgeek.com/more-with-monday

:houses: Want to chat live with other monday․com fans & users?
Join our unofficial community chat on Discord: The Monday Neighborhood

Hi @tangerine ,

Which tool are you using to create an invoice?

Currently using ActiveCollab.

Hi @tangerine ,

It can be done through custom integration development with ActiveCollab.

I have been using the time tracking columns within Monday.com (which constantly have issues) and then manually recording the hours to a text column which then gets pulled into a word doc template via DocuGen integration with Monday.com. I am also using General Caster to make a lot of this happen too since formulas aren’t supported by DocuGen.

It’s a pain in the butt and there should definitely be native support for this kind of stuff within Monday.com

So, true, that’s exactly what I need !

Hey @tangerine @aquibk @Pabsdev @PPI

Using a series of monday automations and the Integration for QuickBooks you may be able to accomplish this.

https://monday.com/marketplace/10000070

Install our app and do the free trial. We would love to hear about how you are innovating your company’s processes using our app!