TGP+ for Excel — live Dynamics GP data, 18 worksheet functions, and reports you ask for in plain English. Start free →
The modern layer for Microsoft Dynamics GP

LiveDynamics GPinside Excel.

TGP+ brings your Dynamics GP data straight into Excel — eighteen worksheet functions for single live values, SmartLists and SQL views for whole reports, AI that writes the query when you ask in plain English, and validated write-back when data has to go the other way.

15–30 minute install. Start free.

Works on your existing GP
No migration, no disruption
Cancel anytime
The TitaniumGP Morning Card: a personalized Dynamics GP operational briefing showing three items to act on now, four things worth knowing, what is coming in the next three days including month-end close, and an overall operational confidence score of 87 percent.
Analyzed overnight Operational confidence: 87% Click the card to read it full size

Trusted by finance & operations teams running Dynamics GP

Northwind Mfg Harbor Foods Cascade Dist. Meridian Group Optima Retail
The platform

Excel that talks to GP — and the tools around it

TGP+ for Excel is where most teams start — live GP data in the tool finance already lives in. Around it sit the scoring engine that watches every document, and the productivity suite that started it all.

TGP+ for Excel

Excel with AI

Pull live GP data into Excel and ask questions in plain English. Build reports at the speed of thought.

Learn more
TGP Sentry

Intelligence

Scores every PO, vendor and item against rules you tune — surfacing anomalies, cash insights and risk before they become problems, and always showing its working.

Learn more
The Foundation

Productivity Suite

Copy/Paste, Elastic Windows, The Button, Validate and more — the proven utilities GP users rely on every day.

See the suite
TGP+ · Excel with AI

Ask Excel. Get answers from GP.

Bring live GP data into Excel and ask for what you need in plain English. Templates, SmartLists, custom SQL and safe write-back — all inside the tool your finance team already loves.

Eighteen GP functions, right in the formula bar

Not just whole reports — single live values. Type =TGP and Excel lists them all. Drop a balance, a quantity or an aging bucket into a cell and let it take part in your own formulas, the same as SUM would.

Look anything up

  • TGPGetAny field from any GP table — or leave the table blank and it works out whether your value is an account, item, vendor, customer or asset

General ledger

  • TGPGLAccountBalancePeriod balance, beginning balance, net change, debits or credits — for one account, a masked range, a category or a column of cells
  • TGPGLBudgetThe budgeted amount from a named GP budget
  • TGPPeriodOpen or Closed, by series — a guard at the top of a posting sheet

Inventory

  • TGPItemQuantitiesAvailable, on hand, allocated, back-ordered, on order or sold — all sites or one
  • TGPItemCostCurrent or standard cost
  • TGPInventoryValueOn-hand quantity × unit cost
  • TGPGetDemandUnits consumed over the last N days
  • TGPGetPurchasesQuantity received on POs over the last N days

Sales & pricing

  • TGPSalesNet posted sales by customer, item or salesperson — amount, quantity, cost or margin
  • TGPGetCustomerPriceThe price a specific customer would actually get

Money in and out

  • TGPARBalanceOpen receivables — total or one aging bucket
  • TGPAPBalanceOpen payables — total or one aging bucket
  • TGPCheckbookBalanceThe current book balance of a checkbook

Is this sheet current?

  • TGPConnectedA live Connected / Disconnected indicator in a cell
  • TGPLastRefreshedWhen the GP data was last pulled — printable on the report
  • TGPVersionBuild, company and your module permissions
  • TGPDiagOne diagnostic line when something misbehaves
=TGPGLAccountBalance("?-1110-?",2026,9)      ' every cash account, every department
=TGPGLBudget("000-1110-00","2026 BUDGET")    ' budget vs actual, side by side
=TGPARBalance("ACME","91+")                  ' what ACME owes past 90 days
=TGPItemQuantities("CAP100","WAREHOUSE")     ' available at one site
=TGPSales("ACME","CUSTOMER",,,"MARGIN")      ' margin, year to date
=TGPGet(A2)                                  ' describe whatever is in A2
=TGPLastRefreshed()                          ' 9/22/2026 9:42 AM

An Insert Function wizard builds the call for you — coded arguments are dropdowns, and a searchable GP data dictionary sits underneath it, so you never have to guess a table or field name. Refresh GP Data re-pulls every function in the workbook and stamps the time. Values are read-only, passed as parameters, and your GP module permissions still apply.

The full function reference → Ask AI for a report →

TGP Sentry · Intelligence

Confidence on every transaction, as you work

TGP Sentry scores every PO, invoice, vendor and item as your team works — a clear confidence number, the issues that matter, and their exact dollar impact.

Elastic Windows · Your GP workspace

Your GP, with room to work

Elastic Windows gives your team space to work — dock panels, notes, files and related data right beside the Dynamics GP windows they use every day.

The foundation

The productivity suite GP users love

The everyday utilities that started it all — still saving your team clicks, keystrokes and headaches.

Every tool, in detail

What each one actually does

The suite above, one block per tool — what it removes, what you can do with it, and why people keep it switched on.

Copy / Paste

Paste a spreadsheet straight into Dynamics GP

Dynamics GP is a capable system, but entering data into it gets painful as the volume grows. Anyone who has keyed a hundred journal lines from a spreadsheet knows exactly how painful.

Copy/Paste reads the data on your clipboard, works out which GP field each column belongs in from your Excel headers, and fills the window. Two clicks: copy in Excel, paste in GP.

What you can do with it

  • Paste into over 80 Dynamics GP windows
  • Create multiple sales orders at once from a single sheet
  • Update existing records in bulk, not just create new ones
  • With Elastic Windows, edit fields GP normally won't let you touch

Why people keep it on

It turns an afternoon of keying into a minute of pasting, and it removes the transcription errors that come with the keying.

Works with Journal Entries · Purchase Orders · Receiving · SOP Entry · PM Transactions · Inventory Transactions · Inventory Transfer · Inventory Kits

Step-by-step guide →

Elastic Windows

GP windows that finally fit your monitor

Dynamics GP windows were sized for the monitors of twenty years ago. On a modern screen they sit in the middle as a small box, showing eight rows of a two-hundred-row document.

Elastic Windows lets you resize them, dock them, and reshape them so the space on your screen is actually used.

What you can do with it

  • Resize any GP window and keep the size next time you open it
  • Dock windows side by side instead of stacking them
  • See more rows without scrolling

Why people keep it on

Fewer scrolls, fewer misreads, and a GP that looks like it belongs on the machine it's running on.

Step-by-step guide →

A Dynamics GP window resized to fill a modern monitor
The Button

The routine GP chores, done in one click

Every GP site has a handful of jobs that someone does by hand, the same way, over and over. They are too small to justify a customization and too frequent to ignore.

The Button puts those jobs behind a single click, so the routine work stops being a routine interruption.

TGP Validate

Catch bad data at the keyboard, not at month-end

Bad data is cheap to fix at the moment it is keyed and expensive to fix once it has posted and been reported on.

TGP Validate applies your own data quality rules while the user is still in the window, so the correction happens before the record is saved rather than in a clean-up exercise weeks later.

TGP Remember

GP that remembers how you left it

Dynamics GP forgets. Every session starts from the same defaults, so the same people re-enter the same choices in the same windows, every morning.

TGP Remember keeps a user's preferences and defaults between sessions, so GP opens the way that person actually works instead of the way it shipped.

TGP Resources

The document everyone needs, where they already are

The procedure note, the price list, the approval matrix — the reference material a GP user needs is usually in a share, an inbox, or someone's head.

TGP Resources keeps that material in one place reachable from inside GP, so people stop hunting for it and stop working from stale copies.

TGP Safe

A second check on the actions you cannot undo

Some GP actions are consequential and easy to trigger by accident. GP's own permissions are all-or-nothing: a user either can do the thing or cannot.

TGP Safe adds protection around those sensitive actions, so the ones that warrant a deliberate confirmation get one.

NextID

Never look up the next customer number again

Creating a master record in Dynamics GP starts with a small, avoidable chore: working out which identifier to use next. Someone checks the last one, adds one, and hopes nobody else is doing the same thing at the same moment.

NextID fills that number in for you, in sequence, at the moment you create the record.

What you can do with it

  • Get the next available ID on the master-record windows you use most
  • Cover customers, vendors, items, employees and prospects
  • Avoid the collisions that come from two people picking a number at once
  • Avoid the gaps that come from a number being reserved and never used

Why people keep it on

It removes a small piece of friction that happens dozens of times a week, and it keeps your numbering sequences clean enough to trust.

Works with Customer Maintenance · Vendor Maintenance · Item Maintenance · Employee Maintenance · Prospect Maintenance

Step-by-step guide →

Where this is heading

An ERP that runs while you sleep

Every release moves more of the work off someone’s desk and into the night. The goal is simple: you arrive in the morning to decisions, not to a queue.

Analysis that happens overnight

Sentry scores your documents, vendors and inventory while nobody is at the keyboard, and the Morning Card is waiting when you sit down — what to act on, what to know, what is coming.

Reports that write themselves

Ask TGP+ for what you need in plain English. It drafts the SQL, shows you the SQL, explains what the answer contains and what it assumed — then puts the rows in your worksheet. Your question and the database structure are sent; your business data never is.

Numbers that refresh themselves

A balance, an available quantity or an aging bucket goes in a cell as a formula, not a paste. One click on Refresh GP Data re-pulls every one of them and stamps the sheet with the time, so whoever opens the workbook can see how current it is.

Autonomous where it can be, and always able to show its working. Nothing runs behind your back: every score, match and tie-out explains how it got there.

Why teams choose TitaniumGP

Keep the ERP you trust — add the powers you want

Modernize Dynamics GP on your terms: a quick install, a predictable subscription, and everything your team already knows stays exactly where it is.

15–30 minute install

A single-file install drops onto your existing GP and you're live the same afternoon. Start free.

Enterprise-grade security

Access controlled by GP credentials or Active Directory, with role-based permissions and audit trails throughout.

Predictable subscription

Modernize for one simple monthly price, and keep everything your team already knows about GP.

Pricing

One price. Everything included.

No modules to add on, no tiers to compare. Start with a free trial and cancel anytime.

All-in
TitaniumGP Suite
$449/month

Every tool we make, for your whole Dynamics GP site. Nothing is held back for a higher tier.

  • TGP+ for Excel — live GP data, 18 worksheet functions and AI reports
  • Full productivity suite — all 8 tools
  • TGP Sentry intelligence & dashboards
  • Priority support & onboarding
See plans & buy

Paying yearly works out cheaper — compare on the purchase page.

Secure checkout powered by Stripe · 30-day free trial · No credit card to start

Ready to make GP something to be proud of?

Join the finance and operations teams turning Dynamics GP into a modern, intelligent platform — in an afternoon. 15–30 minute install. Start free.

Contact us

Let's talk about your GP

Questions, a demo, or help getting started — we're a message away.

Office

San Diego, California

Prefer to chat?

Use the assistant in the corner for instant answers.

Opens your email app with your message ready to send. We reply within one business day.