Reports

VOGSY can generate a suite of reports to help you with your business planning and analysis. These reports are created as Google Sheets, and therefore the raw data that powers them is available to you as well. You can use this data to create your own reports, or feed it into whatever third-party numbers-crunching software you prefer.

You must have the Support staff role to view these reports, which are generated from the VOGSY back office.

When generating your custom sheets or pivot tables, do not use the VOGSY Data sheet or the Details sheet. The data on these sheets are subject to unannounced updates and, because your custom sheets and pivot tables are not automatically updated, they will not be accurate after the locked sheet is updated.

Instead, use named ranges to create your custom sheets or pivot tables.

Most of the reports that VOGSY can generate fit nicely into the Quote to Cash cycle:

  • Find and win the opportunity

    • Customers - Lists all of the organizations that have ever been configured as customers.

    • Contacts - Lists all of the contacts that have ever been created in VOGSY.

    • Suppliers - Lists all of the organizations that have ever been configured as suppliers.

    • Opportunities - Lists all of the opportunities that have ever been created in VOGSY.

  • Staff up and do the work

    • Projects - Lists all projects that have ever been created in VOGSY. This report contains an extra sheet called ‘Current Projects’ that lists the company’s currently active projects.

    • Deliverables - Lists all deliverables that have ever been created in VOGSY.

    • Calculations - Lists all calculations that have ever been created in VOGSY.

    • Expenses - Lists all expenses that have ever been recorded in VOGSY.

    • Planned vs Actual - Displays the hours planned and submitted per week, per employee, and per activity, as well as the difference between the planned hours and actual hours.

  • Track the time

    • Time entries - Lists all time entries that have ever been added in VOGSY. This report can be filtered by week, year, activity, and employee.

    • Billability employees - Lists all available billability data by month for each employee in your company. VOGSY also uses the same information from this report to generate three seperate charts: Billability per month, Billability per employee, and Project billabillity per department.

    • Working hours vs Submitted hours - Lists submitted hours vs work hours for each employee or contractor, sorted by week. With this report you can easily see if an employee’s submitted hours match their available work hours. Maybe they have some hours available to take on an extra activity!

    • Draft invoices - Lists all draft invoices that are awaiting project manager approval. This is a necessary step before you can send the invoice to the customer.

  • Submit the invoice and collect the revenue

    • Outstanding Invoices - Lists all invoices that are currently out to customers for payment.

    • Accounts payable - Lists all of your outstanding purchase invoices that you have received from suppliers. You can filter this report by year and by period.

    • Accounts receivable - Lists all invoices that were generated from projects.

    • Revenue - Lists all revenue over previous, current, and future months for each active project.

VOGSY can also generate a few reports that fall outside of the Quote to Cash cycle:

  • Financial KPIs - Lists the results of KPI calculations. VOGSY uses the same data from this report to generate the Financial KPIs chart.

  • Audit Trails - This report records the history of the changes in roles and permissions granted to users.

  • Trial balance - Lists the ledger accounts data (credits and debits) for each organization. Each organization gets its own sheet. Allows you to track your balances over time.

  • Financial transactions - Lists all financial transactions that have ever been created in VOGSY.

  • Forward looking invoicing - Lists the estimated total amount of all invoices for each month, starting with the current month and projecting forward for twelve months.

  • Project invoices - Lists all invoices ever created in VOGSY.

  • Resource planned hours - Lists all planned hours that have ever been added in VOGSY.

How to refresh data

The reports do not update automatically, but refreshing the data is easy:

  • Google Sheets: Go to Extensions  VOGSY  Refresh report.

  • Microsoft Excel: On the Home tab, click Refresh report. If you do not have the add-in, see Install the Microsoft Excel add-in.