Invoice credit for wire transfer fees?

Michael D. Crawford crawford at goingware.com
Wed Mar 23 11:49:21 EST 2005


I am preparing to switch my business bookkeeping from QuickBooks 99 to 
gnucash because I'm about to receive a check for my consulting fees that 
for the first time ever won't be in U.S. dollars - I moved to Canada a 
year ago, and now have clients in both countries.  Up until now I have 
done all my banking in the U.S., but soon I will also have an account at 
a bank here in Truro, Nova Scotia under the local currency.

Maybe the latest version of QuickBooks supports multiple currencies but 
my experience with Intuit's determination to nickle-and-dime me to death 
makes me determined never to use another Intuit product, not even if 
they were to offer me bug fixes for free.  (Let that be a warning to all 
software developers: if your user's first experience is bad enough, he 
won't give your application a second chance.)

I have been using gnucash for my personal accounts for over a year and 
have been very happy with it.  I'm ready to take the plunge and use it 
for all of my financial records.  But I have an question about an 
accounting problem I have never been able to solve in Quickbooks:

I often ask my clients to pay me by wire transfer.  They usually agree, 
but it is inconvenient for them because they have to go to the bank to 
sign the wire order, and there is a fee that ranges from $25 to $35.

To encourage their enthusiasm, I always write on my invoices that they 
can deduct the wire fee from the amount due.  Most of the time the wires 
arrive in my checking account with $25 to $35 less than the amount 
recorded in QuickBooks' invoices.  It's worth it to me to not have to 
pay to FedEx my check to my bank in the US.

Each time I fill in QuickBooks' Recieve Payments dialog, the wire never 
fully covers the invoices, with the amount QuickBooks thinks is past due 
growing larger as my relationship with my client lasts longer.  If I 
receive a wire every two weeks, then the total past due amount for all 
my clients grows by $600 each year.  I estimate that QuickBooks now 
thinks my clients have stiffed me for over two thousand dollars.

How do I account for my wire fees in gnucash?

I'm still a little puzzled by double-entry accounting, but I think it's 
a good idea and that it's worth my while to fully understand it.

I expect there would be an account from which the wire fees would come, 
and an account for each client's balance.  When I generate an invoice, 
my fee would be deducted from the client's account, and when they paid, 
their wire would be credited to it.  I would then deduct the wire fee 
from my wire fee account and credit it to my client's account, so their 
invoice would be fully balanced.

What I don't understand is where the money in the wire fee account would 
come from.  It's  that it's costing me real money that I pay by mailing 
a check to my client.  I handle it by earning a little less than what I 
invoice.  But I am paying a fee for a genuine service provided by my 
client, and a valuable one too: sometimes my fees are for thousands of 
dollars, and getting a wire saves me days of anxiety waiting by the mailbox.

I expect I'll have other questions, but I should be able to figure out 
most of what I need to know on my own.  I'm going to spend the rest of 
my day working on my books and setting up gnucash.

As soon as I reconcile my outstanding bank statements in QuickBooks, I'm 
going to start gnucash on January 1st of this year and enter all my 
transactions since then by hand.  I don't have so many that it's worth 
trying to get an import to work right.  It's probably better not too, I 
expect there will be other errors I can fix with my fresh start.

Thanks for your help!

Michael D. Crawford
crawford at goingware.com

     Read "GoingWare's Bag of Programming Tricks" at:
              http://www.goingware.com/tips/


More information about the gnucash-user mailing list