The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
I can see how you could do thi if the accounting package is API friendly and so use such as Zappier to populate your Smartsheet row, then Merge to Google Template for writing the checks, but we would have to know more about your system to run a test.
I'm asking on behalf of someone who owns an excavation company and is looking for an easy-to-use software to track bids, jobs, inventory, invoicing, payroll and checkwriting. I think Smartsheet will do all but the latter, so I thought I'd check (pun!) for input on the community.
We work with lots of construction companies that have similar needs Loann and so your requirements list looks quite achievable in Smartsheet, probably easiest to achieve if they are a "Google House" as they can use the Merge to Google feature for Quotes & Invoices the rest is good content for Smartsheet use.
Building off of what Richard stated previously, there are some great third party integration platforms that can link your information from SmartSheet to various other APIs. One easy to use integration platform is Azuqua, for whom I work. Information can be integrated through the use of what we call FLOs. Through a simple drag and drop system, users can link SmartSheet to various other applications like Acumatica, Salesforce, Concur and others which can organize and track your data. There are plenty of functions that users can access which will manipulate and organize the data and then transfer the information to other applications to store. You can check it out herehttp://www.azuqua.com/ andtry a 14-day free trial to see if this platform is a good fit.
Thank you, Nic. This would be for a family-owned business, and once we start talking API's and such, it's beyond their realm.
However, I hope to be able (if they choose to go with Smartsheet) to go them to help get them set up. Maybe then I can help them navigate through these options - though API's are above my understanding at this point, too.
Be sure the \"Percentage\" column is formatted as a percentage. Positive numbers show that your total spend is under<\/strong> the [Contract amount]. Negative values show your total spend is over<\/strong>.<\/p>
You can use a similar formula to measure how far over\/under your [Labor $ (quoted)] amount is from your [Install Labor (actual)] amount.<\/p>