• About

j.matthew.turner

~ Director. Videographer. Editor. Geek.

Monthly Archives: February 2015

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!

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

Miquel Parejo on Premiere Pro’s Project M…
Meny on Premiere Pro’s Project M…
dnn on Project Euler #6: Sum Square…
jmatthewturner on Premiere Pro Audio Synching Pi…
Kalyan on Premiere Pro Audio Synching Pi…

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 feed
  • Comments feed
  • WordPress.com

Blog at WordPress.com.

Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy