[GNC] Cross Charging Suppliers

[Geoff Jankowski]

   Thanks David.

   I will take a look tomorrow (house building today).
   Geoff
   +33 6 22 93 00 53
   +44 7770 58 48 38

     On 10 Sep 2024, at 08:08, Geoff Jankowski <geoff.jankowski at me.com>
     wrote:

   

     Yes Murugan but that leaves an entry hanging in the bank account.

   Geoff
   +33 6 22 93 00 53
   +44 7770 58 48 38

     On 8 Sep 2024, at 20:11, Murugan Mariappan
     <m.muruganandam at hotmail.com> wrote:

   

   Did you try raising a debit note for the supplier for the partial
   amount for the materials

   Saludos Cordiales

   Murugan
       _______________________________________________________________

   From: gnucash-user
   <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf
   of Geoff Jankowski via gnucash-user <gnucash-user at gnucash.org>
   Sent: 08 September 2024 13:53
   To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
   Subject: [GNC] Cross Charging Suppliers

   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:
   [1]https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flis
   ts.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7Cca
   f9f044385d4298ad6208dcd026eac7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7
   C0%7C638614112785429012%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJ
   QIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=nk8%2BI5
   5ZCaSesYq4m1uZVSilwP%2BkTordyMNrkgSL%2FiA%3D&reserved=0
   -----
   Please remember to CC this list on all your replies.
   You can do this by using Reply-To-List or Reply-All.

References

   1. https://lists.gnucash.org/mailman/listinfo/gnucash-user