• About

j.matthew.turner

~ Director. Videographer. Editor. Geek.

Tag Archives: invoicing

GnuCash: Show Outstanding Invoices

25 Wednesday Feb 2015

Posted by jmatthewturner in Linux

≈ Leave a comment

Tags

freelance, GnuCash, invoicing, linux

GnuCash Accounts Tab

GnuCash Accounts Tab

UPDATED BELOW 2015-04-06

I recently switched to GnuCash for invoicing. While it’s quite powerful, it does have a bit of a learning curve. And while I’ve mostly been able to figure out what I need to know with the googles, one feature has eluded me: how to get GnuCash to show me a list of outstanding invoices.

It seems like a pretty obvious feature, but my searches for it always ended on a message board with someone telling me that it simply can’t be done. And while that may technically be true, I stumbled on a trick last night that is definitely close enough for funk.

And here’s the trick: it’s a two-step process. The menu item you need is only available from a certain tab. So:

GnuCash Customers Tab

GnuCash Customers Tab

Start on your Accounts tab. Click Business->Customers->Customer Overview. This will open the Customers tab. Now, with the Customers tab selected, click  Reports->Customer Listing.

This will open the Customer Listing tab, which shows you all of your clients and what they owe. It’s easy enough to ignore the clients with $0.00 next to their names, and that leaves you with a list of clients who have at least one outstanding invoice. Mind you, it still doesn’t show a breakdown of specific invoices – but you can click on the hyperlinked outstanding amount to see a breakdown of invoices for each client.

GnuCash Customer Listing Tab

GnuCash Customer Listing Tab

It’s not ideal – I would really like a one-click solution that simply shows me every currently unpaid invoice – but it’s whole lot better than “it can’t be done.”

2015-04-06 – UPDATE

Reader Rich T. emailed me to suggest a further improvement to this method:

You stumbled on the same thing I did.  It might help to:  1. On the options dialog there is a checkbox to ignore zero balances.  2. "Save -> save report config as" will let you give it a name and recall it as needed.

Edit report options dialogue

Edit report options

So, picking up from where we left off above with the Customer Listing tab active, there is a button in the toolbar called Edit report options. Click this, deselect “Show zero balance items” toward the bottom of the dialogue, and give it a “Report name” up top. Click Ok, then go to File->Save Report As… and give your new report a name.

Now, you can simply click Reports->Preconfigured reports and choose your customized report. Even better, it will only show clients with outstanding balances. So much simpler!

Thanks, Rich T., for the suggestion!

Advertisements

Recent Posts

  • Premiere Pro’s Project Manager Can’t Handle Double-Nests
  • Encrypt Your Dropbox Files with VeraCrypt
  • Mortal Kombat and Enter the Dragon Are the Same Movie
  • 16×9 Linux VMs Inside VirtualBox
  • Adobe Releases Creative Cloud 2015

Categories

  • Advertising
  • Apple
  • C++
  • Creative Cloud
  • Editing
  • Film
  • Geekery
  • Linux
  • Mac
  • Marketing
  • Organization
  • Panasonic
  • Premiere Pro
  • Programming
  • Project Euler
  • Python
  • SEO
  • Shooting
  • Uncategorized
  • Yosemite

Recent Comments

dnn on Project Euler #6: Sum Square…
jmatthewturner on Premiere Pro Audio Synching Pi…
Kalyan on Premiere Pro Audio Synching Pi…
123 hp setup on Installing an HP Wireless Prin…
Encrypt Your Dropbox… on Simple, Efficient Backup for…

Archives

  • June 2017
  • July 2016
  • July 2015
  • June 2015
  • April 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • May 2014
  • September 2013

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.com
Advertisements

Blog at WordPress.com.

Cancel