[GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?
Dr. David Kirkby
drkirkby at kirkbymicrowave.co.uk
Wed Jan 25 14:29:31 EST 2023
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2023-01-25 18-36-55.png
Type: image/png
Size: 69303 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230125/42f97b63/attachment-0001.png>
More information about the gnucash-user
mailing list