[GNC] Cross Charging Suppliers
David Cousens
davidcousens49 at gmail.com
Sun Sep 8 15:53:50 EDT 2024
Geoff,
Take a look at https://www.gnucash.org/docs/v5/C/gnucash-
guide/bus_ar.html particularly th reference to credit notes and
this https://gnucash-user.gnucash.narkive.com/zxaOcVl2/gnucash-credit-
notes from the mailing list archive. I am not sure but I think it is
likely the same process can be done with a vendor bill adapting the
entries as required to reverse the accounts payable transaction instead
of the accounts receivable. See
alo https://money.stackexchange.com/questions/120623/how-do-i-write-
off-an-invoice-in-gnucash re using the proces payment dialogue from the
menu rather than the pay button on the invoice. As you can issue
credit notes ofr a bill it should be symmettric with te credit note for
a customer. No sure if this will do the trick but its worth a try
David Cousens
On Sun, 2024-09-08 at 18:53 +0200, Geoff Jankowski via gnucash-user
wrote:
> Hi
>
> I have searched for a solution but not found one. The answer may lay
> in the General Ledger but I have not been able to get that to work
> and balance.
>
> I have two suppliers, one (A) is an installer the other (B) a
> materials supplier. The installer SHOULD organise his own materials
> but inevitable he runs short on site and use one of my accounts to
> purchase items he is short of. It is managing the cross charging of
> these purchases that is giving me a headache.
>
> Supplier B sends me an invoice and I enter it and analyse it to the
> appropriate expense ledger. I pay the invoice.
>
> Supplier A invoices me for the work and again I enter it and analyse
> it to the appropriate expense ledger. However, his invoice is based
> on a fixed [rice that included the supply of materials o when I
> analyse his invoice the expenses ledger is over valued by the amount
> of the materials I have bought on his behalf.
>
> So to remedy this I enter an entry that debits the expenses and
> credits his account. The balance I owe him is reduced by the value
> of the materials I have bought him.
>
> So now, Supplier A is paid and his ledger balanced, his invoice show
> PAID.
>
> The expenses ledger correctly states the value of work done as the
> duplicated item has been journaled (that old fashioned system!) out
> and cross charged to supplier B.
>
> Even supplier B’s account is correct and once I pay him a reduced sum
> his ledger balances to zero.
>
> NOW HERE IS THE PROBLEM
>
> When I try to record Supplier B’s invoice as PAID through the system
> it accepts the payments from the bank but will not allow me to pay
> supplier B with the cross charged entry, presumable because it is not
> seen as an asset account?
>
> Consequently my account all balance and are correct but I cannot
> record his invoice as paid in the Gnucash system and it annoyingly
> comes up as an unpaid entry every time I open the software or check
> for unpaid invoices.
>
> Can anyone offer me a solution please?
>
>
>
> Geoff Jankowski
> +44 20 7100 1092
> +44 7770 58 48 38
> +33 9 85 20 68 20
> +33 6 22 93 00 53
>
>
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list