[GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

Adrien Monteleone adrien.monteleone at lusfiber.net
Wed Jan 25 15:04:38 EST 2023


I'm not saying this is particularly necessary, (I'm not sure myself) but 
just for completeness of information:

Do you have Trading Accounts turned on?

Regards,
Adrien

On 1/25/23 1:29 PM, Dr. David Kirkby wrote:
> I have some issue with some non-GBP transactions showing as outstanding if
> I look at
> 
> Business -> Reports -> Payable Aging.
> Business -> Reports -> Receivable Ageing.
> 
> An amount of money appears to be payable on some transactions, despite I
> believe they are all paid.
> 
> I have the following structure
> 
> Assets :Accounts Receivable
> Assets :Accounts Receivable:Accounts Receivable (USD)
> Assets :Accounts Receivable:Accounts Receivable (EUR)
> 
> Assets :Accounts Receivable is *not* a placeholder account, but a GBP
> account. This means there are non-GBP accounts under a GBP account. Is that
> a bad idea?
> 
> I initially had
> Assets :Accounts Receivable (placeholder)
> Assets :Accounts Receivable:Accounts Receivable (GBP)
> Assets :Accounts Receivable:Accounts Receivable (USD)
> Assets :Accounts Receivable:Accounts Receivable (EUR)
> 
> but got fed up having to select Assets :Accounts Receivable:Accounts
> Receivable (GBP) for 99% of the transactions. So now Assets :Accounts
> Receivable is a GBP account, and is selected by default. I'm wondering if
> my layout is fundamentally flawed, having a non-GBP account as a
> sub-account of a GBP account.
> 
> I have the same issues on Liabilities: Accounts Payable. In that case there
> are USD and HKD accounts under a GBP account.
> 
> I have the attached transaction showing as owing $0.98 to Porkbun.com. The
> number 0.98 happens to be the difference between what this cost in USD
> ($6.90) and what it cost in pounds (£5.92).
> 
>   6.90-5.92=0.98.
> 
> So I'm starting to wonder if my accounts structure is wrong, and I should
> make Assets :Accounts Receivable and Liabilities: Accounts Payable into
> placeholder accounts,
> 
> If I have made a fundamental error, it would be good in GnuCash could spot
> these, and non allow sub-accounts like this. If I have not made an error,
> then I need to resolve why these transactions are appearing to have money
> outstanding, despite there is not.
> 
> Of course, the next problem is, if I should indeed have messed up, whether
> it's possible to recover. The GBP side of these has been reconciled, so
> deleting the transactions is probably not a good idea. Maybe setting up new
> accounts is possible, and changing the accounts things are debited or
> credited to.



More information about the gnucash-user mailing list