Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

amending a suppliers balance?

Sage 50 general help forum - Free help and support for all general issues
Post Reply
sbrown1264
User
User
Posts: 81
Joined: 15 Apr 2015, 18:14
Sage Version: v2015 21 UK/Europe/Africa

amending a suppliers balance?

Post by sbrown1264 » 28 Oct 2021, 10:40

Hi

We have been using Sage for this financial year, previously using QBD, also previous bookkeeper made a mess and has now left! i took over this financial year and didn't enter any opening balances, we are waiting for these figures from the auditor. i entered opening balances for 2 suppliers (2 directors) for the purposes of making a payment to them, which leaves a balance o/s of £4000. The auditor has come back and said that he has found that they are both owed an extra £10000 each which the directors have now taken (£14000) how do i enter the extra £10000 each?

Regards
Stephen

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4618
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: amending a suppliers balance?

Post by brucedenney » 28 Oct 2021, 10:50

You post a bank payment of £10000 to each of them against the nominal code.

Not sure why you entered an opening balance, you would normally just pay them the £4k against the nominal code in the first place.

The only time an opening balance entry would be needed is if there was an adjustment by the auditors to the previous year.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

sbrown1264
User
User
Posts: 81
Joined: 15 Apr 2015, 18:14
Sage Version: v2015 21 UK/Europe/Africa

Re: amending a suppliers balance?

Post by sbrown1264 » 29 Oct 2021, 08:42

The 2 directors own other companies and invoice in to this company for their services. The previous bookkeeper had made many errors and when I took over I stated I would not enter any o/bs until the auditor had finished the year end, which he is still processing. He has now said that instead of £4000 been o/s to these 2 suppliers it is £14000. One of the directors will make the payments to himself and the other director (not happened yet) just not sure how to enter the payment without affecting the VAT and P&L.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4618
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: amending a suppliers balance?

Post by brucedenney » 29 Oct 2021, 10:01

Okay, so there is not 4000 outstanding there is £14,000

So set up a supplier account for each of the directors, pay them the money and get the invoices off them.

The invoices will need to be coded to a nominal code for their supply.

This is unusual, most directors do not invoice for their services, they take a dividend from the company and so avoid paying national insurance contributions on their earnings, in which case things are done very differently.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

sbrown1264
User
User
Posts: 81
Joined: 15 Apr 2015, 18:14
Sage Version: v2015 21 UK/Europe/Africa

Re: amending a suppliers balance?

Post by sbrown1264 » 29 Oct 2021, 10:27

If I post 2 dummy invoices, this will affect VAT and P&L. The 2 directors own other companies and invoice in to this company for their services. The previous bookkeeper had made many errors and when I took over I stated I would not enter any o/bs until the auditor had finished the year end, which he is still processing. He has now said that instead of £4000 been o/s to these 2 suppliers it is £14000. One of the directors will make the payments to himself and the other director (not happened yet) just not sure how to enter the payment without affecting the VAT and P&L.

I initially entered 2 o/b of £4000 which was then paid, so both accounts now show as zero. As I said the previous bookkeeper has made a right mess of the accounts, that is why I have not entered any o/bs yet until the auditor supplies them to me.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4618
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: amending a suppliers balance?

Post by brucedenney » 29 Oct 2021, 10:44

Payments to suppliers do not affect the P&L or the VAT, it is the invoices that do that.

Entering a £4000 o/b entry to make directors drawing "disappear" could be a problem, if they were invoiced in the previous year, then that invoice should be in Sage outstanding and ready to pay. If the invoice is not un the system then this is just a payment on account.

For now you can pay them the money against their supplier account even if you do not have the invoices yet.

Until they produce the invoices, their supplier accounts will have negative balances.

You should not post dummy invoices, you should post the real invoices from the directors later until then, they "owe" the money to the company.

When they produce the invoices, then the VAT will be accounted for and the cost will be allocated to the P&L.

I would reverse your earlier o/b entry and make it all payments on accounts against their supplier accounts.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests