[GNC] How to import PayPal transactions in to GC

Michael or Penny Novack stepbystepfarm at comcast.net
Tue Apr 11 10:30:49 EDT 2023


> As others have mentioned, you should read up on the rules of double entry
> bookkeeping. If GnuCash cannot identify the proper account, it puts it in
> the account call "Unbalanced" - this account should BTW always be ZERO!!!!
> Anything in "unbalanced" is a mistake somewhere.

A little closer to reality is that anything LEFT in Unbalanced/Imbalance 
is a mistake. But there only temporarily might be OK if :working on it".

For example, when entering a transaction you might realize that one 
component might more properly be an account not yet in your CoA. And 
while you could maybe deal with that "on the fly" I often find that IF 
that new account existed, OTHER (earlier) transactions should have 
referenced it.

For example, imagine an expense account X. It has been used as the debit 
account for a number of transaction all of which would be thought 
related to "x". But now I am entering a transaction where there is 
enough difference that it seems advisable to create a new account Y. But 
if the "y" category exists, some of the transactions now posted to X 
really should be in Y because more "y" lie than "x" like. So........ I'd 
allow the transaction I was entering to complete leaving the amount in 
Imbalance and finish the work of entering that stack of transactions. 
When done, I'd do what was needed to clear up anything left in 
Imbalance. Create the new account Y, possibly a placeholder parent for X 
and Y (if they weren't related in some way, wouldn't have had this 
problem). go through X to find all transactions that should really be in 
Y and do that, and then deal with the one in Imbalance << done last, 
because as long as there know "not done yet">>

IF you are in business ...... It is common or at least possible that a 
payment comes in that you are unsure about (what customer, what invoice, 
etc.). Good practice is not to sit on that check, deposit with the rest 
but the other side in an account with the name "Suspense". Again, 
anything left in there means something to be dealt with. In businesses 
of any size, might be a different worker bee who specializes in solving 
the mysteries << might require some days elapsed time, emailing or 
calling customers, etc. >> So just like Imbalance, anything remaining in 
"Suspense" means something needing work.


Michael D Novack




More information about the gnucash-user mailing list