Quick Tea Time figures question - baffling me
Discussion
Hi there,
Sorry looked at a spreadsheet for too long and it has blown my mind.
A company (lets say XYZ Ltd) invoices out work to the tune of £63277.60
The person the invoices are made out to (ABC Ltd) pays £42377.60 however £5000.00 of this is a loan (agreed by both parties).
Crucially (or not cannot make my mind up), the £5000 loan was never invoiced out from XYZ Ltd. Should it have been ?
Also XYZ Ltd has made no repayments on the loan.
How much is owed to XYZ Ltd ?
Regards
Tim
Sorry looked at a spreadsheet for too long and it has blown my mind.
A company (lets say XYZ Ltd) invoices out work to the tune of £63277.60
The person the invoices are made out to (ABC Ltd) pays £42377.60 however £5000.00 of this is a loan (agreed by both parties).
Crucially (or not cannot make my mind up), the £5000 loan was never invoiced out from XYZ Ltd. Should it have been ?
Also XYZ Ltd has made no repayments on the loan.
How much is owed to XYZ Ltd ?
Regards
Tim
Hi there,
Many thanks for the responses.
So should the correct way be as follows : -
Invoices issued - £63277.60
Payments received - £37377.60
Net amount owed - £25900.00
And then a separate account showing
Loan in - £5000
and then loan repaid of £5000 (which can be paid from the £25900 above) ?
This makes sense ?
Regards
Tim
Many thanks for the responses.
So should the correct way be as follows : -
Invoices issued - £63277.60
Payments received - £37377.60
Net amount owed - £25900.00
And then a separate account showing
Loan in - £5000
and then loan repaid of £5000 (which can be paid from the £25900 above) ?
This makes sense ?
Regards
Tim
Thanks.
So there is a normal trading relationship between the two businesses. That is fine and sales invoices should be raised in the normal way for normal sales activities between the two entities.
The loan is a different matter. That is nothing to do with money being exchanged in respect of goods or services supplied. Once the loan has been made, cash will end up in the bank account of the company receiving the loan.
However, a corresponding liability will be created in the borrowing company's balance sheet.
So, if £5,000 has been loaned by ABC to XYZ, the accounting transaction will be -
In XYZ Ltd Accounts
Debit bank account - £5,000
Credit Loan Account - £5,000
As the loan is gradually paid of, the repayments are offset against the £5,000 liability until the debt is cleared. If ABC is charging interest on the loan, then that element of the regular loan payments that relates to the interest is not offset against the loan balance but instead is posted (debited) to the profit and loss account as an interest charge.
The added complication in this case is that XYZ regularly sells stuff to ABC and therefore raises regular sales invoices to ABC Ltd. Therefore, at any given time, ABC Ltd may owe some money to XYZ Ltd in respect of unpaid sales invoices.
In theory, an offset arrangement could be agreed between the two companies whereby instead of XYZ making a particular loan repayment to ABC, XYZ and ABC agree between them that some or all of the normal trade debtor amount owed by ABC to XYZ be reduced or cancelled and offset against the loan debt owed by XYZ to ABC.
There is nothing wrong with doing this provided both parties agree and the accounting of the "contra" is properly carried out - in both companies.
One other point which may arise whether there are any "connections" between the two companies i.e. do they have common shareholders and/or common directors?
If they are "connected" in any such way, then there are legal requirements to disclose such details in the formal accounts of each company and there are also requirements to disclose in the accounts the size and nature of any financial arrangements made between them.
So there is a normal trading relationship between the two businesses. That is fine and sales invoices should be raised in the normal way for normal sales activities between the two entities.
The loan is a different matter. That is nothing to do with money being exchanged in respect of goods or services supplied. Once the loan has been made, cash will end up in the bank account of the company receiving the loan.
However, a corresponding liability will be created in the borrowing company's balance sheet.
So, if £5,000 has been loaned by ABC to XYZ, the accounting transaction will be -
In XYZ Ltd Accounts
Debit bank account - £5,000
Credit Loan Account - £5,000
As the loan is gradually paid of, the repayments are offset against the £5,000 liability until the debt is cleared. If ABC is charging interest on the loan, then that element of the regular loan payments that relates to the interest is not offset against the loan balance but instead is posted (debited) to the profit and loss account as an interest charge.
The added complication in this case is that XYZ regularly sells stuff to ABC and therefore raises regular sales invoices to ABC Ltd. Therefore, at any given time, ABC Ltd may owe some money to XYZ Ltd in respect of unpaid sales invoices.
In theory, an offset arrangement could be agreed between the two companies whereby instead of XYZ making a particular loan repayment to ABC, XYZ and ABC agree between them that some or all of the normal trade debtor amount owed by ABC to XYZ be reduced or cancelled and offset against the loan debt owed by XYZ to ABC.
There is nothing wrong with doing this provided both parties agree and the accounting of the "contra" is properly carried out - in both companies.
One other point which may arise whether there are any "connections" between the two companies i.e. do they have common shareholders and/or common directors?
If they are "connected" in any such way, then there are legal requirements to disclose such details in the formal accounts of each company and there are also requirements to disclose in the accounts the size and nature of any financial arrangements made between them.
Gassing Station | Business | Top of Page | What's New | My Stuff


