[GNC] New Australian user questions

Stephen M. Butler kg7je at arrl.net
Mon Sep 9 19:32:03 EDT 2024


Sorry, I can't help with the Windows Version nor do I use the finance 
quote items.  I can respond to some of your other questions.

But first, do you really need to handle the exchange rates into those 
other currencies?  If there is no balance kept in Paypal and it handles 
all the currency conversion why not just record everything in AUD?

I have annotated other responses below (while snipping out a bunch of 
things.

On 9/7/24 20:40, Megan Tilley wrote:
> You all appear to have a good handle on GnuCash, but I am a brand newbie!!!
Welcome aboard.  Most of us started out as newbies also.
> Question 3: Can I not just reinstall over top of what I have already done?
I've heard that the Windows installer will handle the reinstall just 
fine.  I'm Linux based (Ubuntu) and try to avoid Windows as much as 
possible.  But, just try to install again and see if that works.
> Question 4: Which perspective should I adopt when looking at a transaction?
> I stand in my account and pay out using the Debit column, or I stand in the
> Coat account and use the debit column (correspondingly, the bank account is
> the credit column)?
Adopt the one that makes the most sense at the time.  Personally, I 
spent most of my transaction entry in Assets:Bank Name:Checking, since I 
have both a checking and savings account with them.  If I was recording 
the month-end interest earned for the savings account I would sit in 
Assets:Bank Name:Savings.

However, if I wanted to look at it from Income:Interest Received, I 
might sit there and enter both the checking and savings as a 
three-account transaction with the Asset accounts each getting a debit 
entry (Assets are debit accounts -- you own their value) and Income 
getting the total credit amount.  You might find this chart handy:

Debits

  * Debits increase asset accounts
  * Debits increase expense accounts
  * Debits decrease income accounts
  * Debits decrease equity accounts
  * Debits decrease liability accounts
  * Debits are always recorded on the left when a financial transaction
    occurs

Credits

  * Credits decrease asset accounts
  * Credits decrease expense accounts
  * Credits increase income accounts
  * Credits increase liability accounts
  * Credits increase equity accounts
  * Credits are always recorded on the right when a financial
    transaction occurs

> Further to this last, as I said, I use Paypal as a pass through conversion
> channel- my Aussie bank account is used to pay for an item in a US market
> (NOT an investment/shares/stocks) - say, a 'Reference Book'. I know that I
> have to have 3 entries in a transaction: origin (Aussie Bank account), into
> Paypal as AUD, conversion by Paypal to USD, payment to US company for my
> 'Reference Book'. Referring to Question 4 :-
Do you really need to track the exchange rates and US $ amount?  At the 
end of the day you paid out X AUD for the book.
I work with a non-profit that has a clinic in the Philippines and so 
does sent US $ over their which is transferred to Php (Philippine 
peso).  Even there, for the US books I just note how much US was sent (I 
do record the Php equivalent in the note/memo area).  So, since this is 
an expense:

Credit x AUD (cost of book) to Asset:Bank Name:Checking and Debit X AUD 
to Expense:Books.

Now, if you kept a balance in Paypal (I presume in AUD), you would need 
to set that up as an Asset account in AUD currency and now you would 
have to include it.
Then you would need to have a set of US Expense accounts that would 
record the US $ cost of the book.  That would get messy if you also 
bought books in AUD, CAD, SWE, as each would need their own expense 
account.  Since this is an expense:

Credit Asset:Bank Name:Checking for the AUD cost of the book
Debit Asset:Paypal for the AUD value transferred to Paypal
Debit Expense:USD:Books for the US$ value of the book cost  (GnuCash 
will ask what is the AUD value for the USD)
Credt Asset:Paypal for the AUD value of the funds converted to US $ 
transferred out.

Again I ask if this level of detail is really worth tracking for your 
situation.

> Question 5: which of the columns in the transaction should host my Aussie
> bank? Debit column or Credit Column?
Wrong perspective!  The Asset account would have both Debit and Credit 
values (deposits being Debit and expense entries being Credit).  But 
your Bank Account is an Asset to you.
> Question 6: which of the columns should reflect AUD into Paypal?
Paypal should be an Asset account (well, it could be set up as a 
Liability which would reverse the perspective).  So deposits would be a 
Debit.
> Question 7: which of the columns should reflect USD from Paypal to the Book
> company?
Payments going out will reduce the value of this Asset so would be a Credit.
> Question 8: which of the columns should reflect the Book company receiving
> my USD?
Do you really want to track the Book Company or just the expense of 
buying a book?  Expense are debits so an increase to an expense account 
is a Debit to that account.
> Question 9: should I bypass Paypal completely and just use my bank account
> and the Book company?
I would -- and if Paypal charges a fee for making the conversion that 
would be an Expense:Fees:Paypal and just another expense item (recorded 
in AUD)
In this case the entire transaction would be:
     Credit Assets:Bank Name:Checking for AUD value sent to Paypal
     Debit Expense:Fees:Paypal for the AUD value of the fee charged by 
Paypal
     Debit Expense:Books for the AUD equivalent of the US $ sent to the 
US Book company (I might note the US$ in the Description/Memo/Note field).
> Question 10: how often do I need to update my GC install? - am I notified
> of a new release or do I just watch this channel?
This distribution list is notified of new releases.  How often you 
update is really up to you.  I see folks here that are still on some 
flavor of v2 (current is v5.8).
> Question 11: how often do I need to update Strawberry Perl? and where do I
> find that?
I don't except as my O/S updates it.  Then I'm not using Finance Quote.  
I do use the OFX downloads offered by my CC company.  I tend to entry my 
bank transactions manually (many are set up as scheduled transactions).
> Question 12: do I need to anything else regularly with respect to GC and
> the 'subroutines' used within it (F::Q, etc.)?
I don't.  Others who do may weigh in here.
> Question 13: how is the update process managed? How do you do an update to
> GC? Download and run a new version?
For Windows just run the new installer version which you will download 
as needed.
For Ubuntu, I have to compile mine so I just grab the GIT clone and 
compile from there as needed.
> Thanks so much for taking the time to read all this...
Your welcome.  It does seem that you need a better understanding of 
accounting fundamentals and how double entry really works.
> Megan in Sydney, Australia
Steve in Battle Ground, Washington USA (where no battle was ever fought).


More information about the gnucash-user mailing list