Automate, Integrate, Customize.

Vista by Viewpoint Tools & Solutions

Customized Solutions & Expert Advice to help you get the most out of your Vista by Viewpoint Software

Payment Protection Plan

Customized Data Extraction & Reporting Integration

A customized PPP reporting solution that allows Vista by Viewpoint users to prepare applications for forgiveness using Excel capabilities that will extract data from vista, calculating accurate application information. 

 

Interactive Financial Statements

Generate & View Financials

This Power BI report allows clients to seamlessly generate, view and filter their financial statements. Review financial statements in real-time and report earnings.  

 

Projected Billings Report

Valid & Up-to-date Information

The Projected Billings Report assists clients in projecting the anticipated project billing amount. Project Managers can view contracts with a comprehensive breakdown of contract values and the projected monthly billing to the end of the contract.

 

This ensures that future cost projections are:

  1. Valid

  2. Contain the most up-to-date, relevant information  

The “Contract Summary” sheet provides contract value according to different calculations in Vista and includes different fields.  

  • Current Estimated Cost 

  • Projected Cost 

  • Original Contract Amount 

  • Pending Amount 

  • Approved/Interfaced Amount 

  • Change Orders 

  • Received Amount 

  • More (custom to your needs) 

The “Billings Detail” sheet compares the contract amount (from the “Contract Summary” sheet) to the billed amount. The Total Remaining Amount to Bill is automatically calculated, and depending on the scheduled contract end date, the projected billing per month is displayed.  

 

Productivity Tracker

Customizable, Real-Time Forecasting for Project Management 

Currently, Vista lacks the granular and real-time data to allow project managers to plan quickly and efficiently. Vista only allows for forecasting monthly, with no functionality for weekly views. This leads many Vista users to turn to create external solutions to see up-to-date data on a weekly basis. This approach is problematic as it causes repeat data entry and moves the system of recording outside of Vista into un-linked programs and applications like Excel.  

 

To have their finger on the pulse, project managers need to be able to access real-time data on a granular basis. The Productivity Tracker pulls the most recent information into one spot and allows for weekly views with the click of a button, all while keeping Vista the system of record

 

Vista Data Quality Dashboard

Customized, Automated Data Quality Report

  • Have you ever seen a report with incorrect data?

  • Have you ever been in a meeting where no one trusts the reports?

Unique requirements and specifications for data make flagging discrepancies important. Vista does not have a built-in solution to ensure data quality. Currently, this process is repetitive, tedious, and painful as there is no straightforward approach using Vista alone.  Data quality checks require the Vista by Viewpoint user to run a multitude of reports and manually flag any data quality errors 

Olsen Consulting had developed a fully customized, integrated data quality dashboard that allows Vista by Viewpoint users to inspect the health of data at a glance. 

 

Job Cost Progress Entry

Intuitive Job Progress Tracking Spreadsheet

  • Are you avoiding Progress Entries altogether due to the poor user experience in Vista?

  • Do PMs ever enter progress against phase codes with no costs?

  • Or do they ever forget to enter progress against phase codes with costs?

Using a direct connection between Excel and Vista, we pull cost and progress data from Vista, provide an optimized approach for users to enter their job progress and with the click of a button, the data is pushed and posted back into Vista.

The JC Progress Entry solution is set up in an easy-to-understand and intuitive layout so anyone with basic MS Excel skills can succeed. 

 
 

Vista Security Services 

ERP Data Integrity and Security

  • Are your Vista security settings configured to allow for an easy audit, streamlined setup for new employees or maintenance for existing employees?

Vista has a sophisticated security hierarchy that can help gatekeep access by group or user which protects the integrity of the system. Security can be set up with great depth and detail which can leave you feeling overwhelmed by the maintenance and upkeep of your Vista Security architecture.  

Olsen Consulting has consolidated all form and report security into one place to ensure that there are no gaps present when protecting precious information and data. Not only can audits and troubleshooting be completed in one consolidated location with discrepancies highlighted; all modifications and updates to user, group, form and report security can also be entered here. 

 

RECONCILIATION WORKBOOKS

Compile Essential Reconciliation Information

Olsen Consulting has created custom solutions that compile all essential reconciliation information into a single workbook that is directly integrated with Vista to allow for information to be updated in real-time. 

All of your company's financial information can be accessed within a single location. This eliminates the requirement of running, exporting, saving, and sharing reports for reconciliation purposes. Freeing up multiple hours of accounting professionals' time every month, minimizing audit risks, and helping to ensure that you and your team can rely on reported information coming out of Vista. 

Accounts Receivable Reconciliation Workbook 

Reconciles: 

  • AR Subledger to General Ledger  

  • AR Subledger to AR Aging Report 

  • AR Subledger to AR Aging by Contract 

Accounts Payable Reconciliation Workbook

Reconciles: 

  • AP Open Payables to GL Trial Balance  

  • AP Aged Open Payables Summary to AP Aged Open Payable report

  • AP Aged Open Payables by Subcontract report to AP Aged Open Payables  

  • AP Retainage Summary Drilldown report to AP Aged Open Payables report  

  • AP Hold Detail report to AP Aged Open Payables report 

Job Cost Reconciliation Workbook

Reconciles: 

  • Job Cost by Month to General Ledger  

  • Job Cost by Cost Type and Phase  

  • Total Job Cost by Month to General Ledger 

Power BI

Intuitive Reports And Dashboards

Microsoft Power BI is a business analytics solution for teams and individuals. It’s easy to use, intuitive reports and dashboards integrate seamlessly with the rest of your Microsoft accounts. 

 

This powerful solution allows you to visualize your data and share meaningful insights across your organization. Power BI is the leader in the magic quadrant, it's always being improved and is the best of the best.

Power BI offers a suite of solutions including:

  • Visualization or UX UI design 

  • Report Building 

  • Modeling 

  • Power Query Querying 

  • Publishing Data, Security and Data Governance 

Power BI Optimization

Performance Improvement & Cost Minimization

  • Do you ever find yourself asking "how do we speed up Power BI"?

Our experts are proficient in Power BI Optimization and are ready to help you get the most out of your business analytics solution

Performance improvement:

  •  Reduce the time to refresh data from a source;  

    • Scheduled refresh during non-business hours reduces the impact on your business. 

    • Using a data warehouse, (typically a copy of your OLTP system) ensures none of your precious data is lost. 

  • Increase the speed of navigation through Power BI report (visuals, filters, tables updating etc.) 

    • We do this by de-bugging and improving DAX queries, removing unused columns, performing incremental refresh operations and more.

Cost minimization:

  • We use Power BI Embedded to bypass individual licensing requirements.

  • We optimize the use/cost of various data sources (e.g. Synapse). 

GoCanvas

Eliminate Paper-Based Processes

  • Are you still using paper-based processes to collect and file important documents?

  • Struggling to keep everything organized?

 

Olsen Consulting created an integration between GoCanvas and Vista by Viewpoint to significantly improve your businesses' operation, increase productivity and reduce redundancies. 

 

GoCanvas is a mobile-based document management solution that helps you save time and money by eliminating paper-based processes and speeding up data collection

With this powerful tool, you can build, edit or customize your own GoCanvas Apps (mobile forms), assign them to others at your company to fill out via their smartphones or tablets; the data will immediately be collected and stored securely. GoCanvas gives you the power to gain valuable insights from your data by providing the functionality to analyze it with programs such as Power BI, Excel, Tableau and many more.

 
 
 

Stay In The Know

Olsen Consulting is using cutting-edge tech developments such as AI and Machine Learning to create innovative tools & solutions for high-performance companies like yours.

 

Subscribe for company and industry updates, free resources, tips, and tools.

Subscribe to Know

Get the most out of your accounting software

Learn how Olsen Consulting can help you with Vista by Viewpoint Automations, Integrations & Implementations