Excel Integration
Spreadsheets are powerful and familiar, but are not optimal for storing data. We leverage a combination of Excel, web services, and SQL Server to provide powerful unique solutions that utilize Excel as an interface with SQL Server as a back end. Doing so gives you all of the strengths of Excel without the weaknesses.
Reporting and Dashboards
There are lots of great reporting tools available, but more often than not, the data you want is spread across multiple tables with data types that don't match, and naming conventions that are confusing, making the information you want inaccessible. TC Business Solutions has spent decades working with Spectrum® and are uniquely qualified to extract that data. We have compiled dozens of unique SQL views and objects that unlock your data and make it easily accessible.
API Integration
Whether you want to transfer data using SOAP API's, REST API's, XML, or comma delimited files TC Business Solutions are experts in data transfers.
TCBS Portal
The TCBS portal is a software-as-a-service (SAAS) integration platform. Its powerful code engine leverages Spectrum® SDX services and proprietary TCBS SQL Views to provide secure web, mobile, and Excel solutions that provide real time data without syncing requirements.
- Excel Reporting
- Time Card Entry
- Check Stubs
- AP Invoice Submission
- 3rd Party Integrations to Spectrum®
While some companies like to tout how their solutions auto-magically know your business requirements via artificial intelligence, our solutions have evolved from decades of hard earned experience related specifically to construction accounting and the Spectrum® Construction Accounting software.
Call 206-276-7811 or email tomc@tcbusiness-solutions.com for a demo and pricing
Our Solutions
Financial Statements
We offer a dynamic Excel based tool to build your Financial Statements and display them immediately with drill down and customized parameters.
Time Card
Collecting time cards can be a time consuming data entry process. We make web, mobile, and Excel based interfaces that allow you to collect, review, and import to Spectrum® in a way that matches how your business works.
AP Invoice
Processing invoices is a time consuming process. Electronic delivery is challenging because often the vendor does not have all the information Spectrum® requires. We provide solutions that allow for vendors to submit invoices via the web, with review capabilities to fill in the missing information, and one touch import, streamlining the process and requiring less re-keying of data.
Work In Progress
Managing the cost of your jobs is always a challenging endeavor. Our Work In Progress solutions can show you the information you need and help with minimize time consuming data entry.
Mobile Apps
Do you require your employees to do data collection on site? Whether it is equipment, time card, material use, we can create web, Android or iOS apps that allow your employees to collect data from their mobile device.