Supplier Payment

Thanks Kevin Will call you as close to 11 as I can.

No problem whatsoever.

I'm leaving early for sports day tomorrow and have a client in at 10 so anytime between say 11-12 would probably work quite well if that suits.

No promises on being able to help by the way but it's worth a look surely.

Hi Kevin can I take a rain check on that I have to be at a clients in 10 minutes, could you spare me some time tomorrow It really would be helpful to talk this over.

I'm in the office till 6.15 ish, number is 02476 980440. If you download https://www.teamviewer.com/en/index.aspx i'm more than happy to spend 10 mins seeing if we can find a solution together, two heads 'n all that...

I still think I must be missing something as I cant see on the statement anywhere that I can isolate the unpaid invoices by date and I am getting paid invoices Purchase orders and unpaid ones. Also there is no PDF option anyway.

If I could find a way to get her to do that I would love to. Its just that there is no way of her ticking off the invoices she wants to pay and then have a total appear in the bank payment box so that she doesnt have to add everything up. If you could do that then it would be simple she could just tick off the supplier statement to the unpaid bills press pay and it would go to the bank where she could email the supplier the remittance. As it is I am at a loss to find a way to show her how to do it easily. I love the software, this is the only thing that I am having trouble getting my clients to do. There is no straight forward way to get the amount payable to the bank for them to pick up. Its really great when they want to pay one invoice its the bulk payments that are the problem.

Doesn't like the CB logo? Wow - that's a new one eh?! ;-)

My first option was the statement, specifically the part that shows unpaid invoices.

Unless she's prepared to compromise a bit it's going to be fiddly i'm afraid. If it were me i'd go to Bills > Unpaid, set the end date as needed then copy and paste the entries over into Excel. It wouldn't take that long once you got into the swing of it, you could put each supplier on a separate tab if really needed, total them all up along the bottom and there wouldn't be a logo in sight!

Of course, in my mind most of that completely defeats the object of such wonderful software. It would be much quicker to try teaching how to use the system properly in the long run, it's all there at her fingertips once she knows how.

Yes Client has access trouble is we are talking about someone who has no accounting background and wants to just print out somthing that says she needs to pay this amount of money to these people and this is how it is made up. I thought that your first suggestion was the unpaid bill option. Maybe I am missing something where did you go to get the first suggestion. I have tried going to Suppliers > full statement but then I get all the purchase orders and paid invoices that will really confuse her and anyway again I cant see a PDF option. Then if I go to running balance it shows everything outstanding with no payment allocation from the date that you start at and the date you want to pay up to. The unpaid bill solution would work if you could print it out in the format that it is on the screen. I can do a screen print but that shows all the clear books logo etc and she doesnt like that. She does like the statement and I thought I wouldnt have a problem as of course the first month just showed what was outstanding to the end of the period she wanted to pay. Subsiquent months however do not get rid of paid items. They just bring the balance forward. It wouldnt matter if I could do it but she wants to do as much as she can herself to save money on my fees.

Does the client have access?

How about Bills > Unpaid then sorted into payment date order (and filtered by supplier if need be)?

If the client doesn't have access you could copy/paste into Excel or whatever, bit long winded but it would work.

Yes thats right although your suggestion gave me another place to go to its a pitty that this page can't be printed out as a PDF though it would save loads of time.

Ok sorry, misunderstood. It's a supplier contained within your client's bookkeeping and you client needs to see what bill are payable and when?

Thanks for that, it would work except for two things, my client has more than 200 bills to pay one supplier each month and likes to do the payment run herself. She also likes to see a printed remittance advice for her files. There are over 50 suppliers to pay each month as well the running balance would be fine if it showed the payment made for the previous period but because the payment is on the 60 day terms of course it doesnt go through the bank until later so doesnt show on the running balance.

This is what I get when I issue a client statement:

Is that what you see too? I'd have thought that was enough for any client to understand what's open and when each invoice needs paying by.

I'm not quite sure what you mean re 'the payment made for the outstanding balance brought forward' - it's been a long day though I admit.

Would the running balance option be more suitable?