Help Center

Back to home

Help Center

PlanGuru Desktop (Windows)

PlanGuru Desktop (Windows)

Updates

Release Notes: PlanGuru Desktop v8.0.0.41

Release Notes: PlanGuru Desktop v8.0.0.40

Release Notes: PlanGuru Desktop v8.0.0.39

Release Notes: PlanGuru Desktop v8.0.0.38

Release Notes: PlanGuru Desktop v8.0.0.37

Release Notes: PlanGuru Desktop v8.0.0.36

Release Notes: PlanGuru Desktop v8.0.0.35

Release Notes: PlanGuru Desktop v8.0.0.34

Release Notes: PlanGuru Desktop v8.0.0.33

Release Notes: PlanGuru Desktop v8.0.0.32

Release Notes: PlanGuru Desktop v8.0.0.31

Release Notes: PlanGuru Desktop v8.0.0.30

Release Notes: PlanGuru Desktop v8.0.0.29

Release Notes: PlanGuru Desktop v8.0.0.28

Release Notes: PlanGuru Desktop v8.0.0.27

Release Notes: PlanGuru Desktop v8.0.0.26

Release Notes: PlanGuru Desktop v8.0.0.25

Release Notes: PlanGuru Desktop v8.0.0.21

See more

Getting Started

Getting Started - First Steps

Getting Started - Analysis Setup

Getting Started - Company Setup

Getting Started - Navigating PlanGuru

Navigating PlanGuru Desktop

Navigating PlanGuru - Top Menu Bar

Navigating PlanGuru - Side Menu Bar

Navigating PlanGuru - Data View Tabs

Navigating PlanGuru - Financial Statement Dialog

Navigating PlanGuru - The Grid

See more

Setup & Maintenance

Setup Method

Selecting a First Projected Year

Actual Results - what to choose during analysis setup

Using Seasonality Factors

Add Subtotal Grouping

Copying an Existing Analysis Structure into a blank new analysis file

Changing the First Projected Year

No Accounts showing up in Map Accounts screen

Working With Actual Results

Account Number, Account Mask & Consolidation Account Setup

Rollforward Utility - Push your analysis into the next fiscal year

See more

QuickBooks Online Import

Quickbooks Online Import Tips

QuickBooks Online files > Converting them to a desktop version QB Files

QuickBooks Desktop Import

The Mass Import for QuickBooks Desktop

QuickBooks Import: Error 13

QBFC10 Installer

Quickbooks Import Error Code : 2147220728

Minimum QuickBooks Version Requirements

QuickBooks Import Error -2147010895

All Equity Accounts assigned to Retained earnings

Capital Accounts are Automatically Mapping to Retained Earnings during QB Import

QuickBooks Import Utility - 'Import by Class' feature

Excel Import Utility for QuickBooks users

Quickbooks Import - Cash vs Accrual accounting

Importing from QuickBooks Error 80040154

QuickBooks Import Options

QuickBooks > PlanGuru Interface Requirements

QuickBooks Import - Chart of Accounts gets imported, but balances don't appear

Imported Results don't Reconcile to QuickBooks

QuickBooks Import Error - Make sure PlanGuru is not being run with Administrative Privileges

See more

Excel Import

Mass Import for Excel

Excel Import

Excel Import: P&L and Balance Sheet must be imported together

Excel Import - Chart of Accounts gets imported, but balances don't appear

Analysis Setup

Company Setup - Account Mask

Analysis Setup - First Projected Year Setup

Forecasting & Modeling

Accrued Expenses - Capturing their balance sheet and cash flow impact

Declaring Dividends in PlanGuru

Allowance For Doubtful Accounts & Bad Debt Expense

Performing Allocation / Linking Categories to values from another analysis file

Personnel and Payroll Planning

Line of Credit Tool

Percent of other Categories

Trend based on historical data

Formula Editor

Formula Builder Changes in v8.0.0.9

Link to Excel worksheet

Payroll Utility

Adding a Reference Line

About our Modeling Samples

Personnel and Payroll Planning - Forecast by Headcount

Income Tax Expense, Liability and Payment

A/R Calculation - Multiple customers with different payment terms

Personnel and Payroll Planning - Forecasting by Employee using Non-Financial Data

Variable Average Days to Collect / Pay

Deferred Revenue

A/R Modeling

Headcount > Employee related expenses

Inter-Company Eliminations during Consolidation

Personnel and Payroll Planning - Link to Excel Approach

See more

PlanGuru Desktop in Cloud Hosting

Moving PlanGuru files from your Local machine (or Network) to the Cloud

Using the Advanced Reporting Add-In in the Cloud

Saving Cloud Excel reports to your local machine

Logging into PlanGuru's Cloud Hosting

Technical Inquiries

PlanGuru has stopped working - Error received on startup

Access Driver - Download

Excel Import Issue : Database Error - The cross reference file could not be read

Windows 'Region and Language' settings

Error 50003

The firm information is not available - Error Message

Problems Installing application or Update: The contents of this file cannot be unpacked. The executable you are attempting to run has been corrupted

Totals are inaccurate: Analysis Recalculation

Excel Export: columns appear as numbers

Having trouble viewing embedded videos within Knowledge Base?

Excel Links don't refresh - Linked Workbook changes could cause this

Supporting Schedule total not showing on Financials - Historical & Actual periods

Consolidation Issue: Expense classes not added to consolidating income statement

Error msg: The Company File Cannot be added - Could not find... 'PGCompany.accdb'

Printing - Crystal Reports File Error

Connection Errors

See more

Installation

Activating your PlanGuru Account

Installing PlanGuru

Install using "Run as administrator" option

Updating PlanGuru - Issues running update

Network Edition Installation - NWConfig Permissions Error

Installing an Update in PlanGuru

Activating the Advanced Reporting Add-In inside Excel

Network Configuration Errors

Error 42

Running PlanGuru on a Mac

See more

Licensing

Switching licensed machines: deactivating your PlanGuru license

Deactivating PlanGuru on a licensed workstation

Manual Activation of PlanGuru

Licensing Activation - Error Code: 5008

Licensing Activation - Error Code: 5013

Cancel or Change Your PlanGuru Plan

See more

Managing your PlanGuru Files

Locating, sending and receiving PlanGuru Data Files

Changing the Location of your PlanGuru Data files

Restore Analysis Files

PlanGuru Data File Backup - Windows Backup and Restore utility

Using shared PlanGuru data files

Converting prior version analyses (PlanGuru 11 & PlanGuru 12)

Enabling Security

Problem Installing Trial - InstallShield Wizard "Error reading setup initialization file"

Tips for setting up multiple analyses (divisions)

See more

Reporting

Three Reporting Methods

Changing Report Options

Subtotal Reporting

Note Amortization Schedules - Reporting

Excel Report - 'Cannot be found', when printed from PlanGuru

See more