Excel-VB Poultry Farm Manager [UPGRADE] – Auto Generate Payments to Suppliers In Imprest Cash Book – Phone Suggestion by Nigerian Farm CEO Client/User

[views] The new set of videos I’m going to be doing – Demonstration Videos – are designed to be published on DiscoverCotonou Dot Com and the video channel for DiscoverCotonou Dot Com because as I travel I want to be able to communicate with buyers from in and out of Africa, who are Farm Business Owners using the application to run their businesses.

So at every point in time, I’d love to be able to take whatever input I get from each of them and share with the others, so that they can also get much richer and much more beneficial experience from using the software. And that’s why this video’s been done, because there’s a new improvement that has been made to the Poultry Farm Manager, based on input from or a suggestion by a Farm CEO based in Nigeria’s Ilorin in Kwara state.

And there’s an opportunity for us here to evolve a software solution that ultimately will continue to be low cost and at the same time boost a lot of the productivity you have in your Farm Business Enterprises. So, I welcome you to watch the video and if you have any inputs or any comments to make, let me know.

 

[Phone Conversation Transcript Excerpts]

Ol boy how now? I’m okay. Good morning. [Audio cut out for brevity] But I have one observation. In the Imprest Cashbook, but I think it should be linked with the Purchase Interface. So when you say you purchased a certain item. There is a column that says you paid so and so amount. Maybe like you bought so so number of something, then out of the value you bought, then you pay so so amount.

So that particular payment end of that particular interface, I guess automatically should link with the Imprest Cashbook. It should be able to tell us that out of this so so date, you paid to so so beneficiary. You know what? Let me take a look at it. Once I’ve studied it then I think it’s worth looking into. I’ll do that and get back to you.

24 hours later I’d made the changes – See SMS exchanges.

Video: Excel-VB Poultry Farm Manager [UPGRADE] – Auto Generate Payments to Suppliers In Imprest Cash Book

Okay this is Tayo Solagbade here, to quickly demonstrate a new feature that has been added to the Poultry Farm Manager. Like I keep telling every one of my buyers, the more people make use of it, the more ideas come about how we can improve it.

So what we have here is…I got a phone call from a relatively new user of the software.

A gentleman somewhere I think it’s in Ilorin, if I recall correctly

So he has a Poultry Farm, So he – I think he’s an accountant – so he’s been very diligent in making use of it and ehm he made the point that or let me quickly…well, for those of you who are already users of the application, you know that if you want to reflect the Purchase Expenses.

This is the Supplier Schedule by the way – where you post entries – just specifically for Feed Suppliers. So you know that when you want to reflect the Payments made to the Suppliers of your feed, you have to go from the Suppliers Schedule you go into the Imprest Cash Book.

Alright. And that was what you had to do in the original version of the application. And you would go to the Payments section of the Imprest Cash Book. So let me just rearrange my screen there.

Okay and you would actually have to come to this column here and make an entry for the TOTAL AMOUNT OF FEEDS PURCHASED. You wouldn’t be able to break it down and specify for individual suppliers and all that. And like I said you had to do it manually.

You had to come here and actually add up whatever the total amount of Feed was. You couldn’t break it down and you couldn’t do it automatically. Meanwhile all those values would already have been posted into the ehm Purchase Schedule or sorry the Suppliers Schedule.

Alright, so if you go back to the Purchases Interface and look at what I’ve now done, based on his comment – you would have listened to a section of the phone conversation where he was making the point and I told him I would check it out.

So it was a very valid point. Funny enough some of you know that I developed this application based on collaboration with some accountants over the years but this was an element…we decided to leave it this way because we felt it would be a bit difficult because reconciling the ehr Imprest Cash Book disbursements with the actual spend that would be done.

If you collected maybe N100,000 from the bank, you couldn’t be sure how much of that would get spent, so it’s only in the Payments section here when you reflect the actual amount that’s been paid that you’d actually know the total amount of the money you took in through the Imprest, that’d been spent.

And then you were now required to add up that number and then go and paste it under the Feed Purchases column in the Expense section or the Payment section of the Imprest Cash Book.

But the guy was making a point – very valid point – that since the entries had been made here, the system could automatically pick it and do the posting by itself for whatever the period and whichever individual, whichever supplier we’re talking about. Now that’s what’s now been done.
So what happens now if you look at these values here? Ehm this is the 1st of August for instance, you have…these are Demo Accounts – because I don’t want to use his own information.

So you have Taiye Livestock, which is just a demo something. Okay he supplies some bags of feed. You can see the amount 17bags at this price bla bla bla. So this is the TOTAL value of what has been received by “DEMO FARM” – this is the name of the farm “DEMO FARM” – just a demo account.
Now this is the PAYMENTS that’s been made. These amounts are the amounts that YOU as the owner of the farm have sent to this gentleman – this first gentleman – that’s eh Taiye Livestock with regard to this particular supply. And then particular Supplier of Broiler Feed you’ve sent him N11, 000 out of N37, 700.

So right now you look at the TOTAL you have sent to the guy is about ehm N76, 000 alright and he has given you material worth about N91, 000. So if you for those you know how to use the software. So you come to this end here.

So for this individual just put the cursor here, -just click this button here “ADD BAL (ANCE) FORMULA”. You can see it shows that you’re owing him now a balance of N15, 290. Okay.

That’s regarding his own status – you know, what’s his current situation with you. And you can generate a detailed report from here. But now in terms of reflecting the amount you’ve sent to him in your Imprest Cash Book, you go to the MAIN MENU, with the new improvement I’ve added to it now.

So what I’ve done, you come here in the Imprest Cash Book. So what happens is the period is 1st of August, so you come here – because these are other entries for 1st of August – but this 1st of August entry is specific for this gentleman, I think what’s his name now – that’s TAIYE LIVESTOCK okay.

So you choose the name. Once you’ve done that you click here – click the ADD FEEDS PURCHASE AMOUNT. You can see – it generates that. You can see that that’s N76, 000. Alright. If you want to generate for the other person…I think there was an entry for 4th ..so K. A Feeds is what I’m going to make entry of here.

So I generate…alright…so it’s just N7,400. So you can see it automatically adds it. Meanwhile if you were to go a blank row and try to make an entry, there’s some Error Validation provided. You can see “No Purchase Data entered on this row.

Click OK and enter Date of Purchase. So let’s assume you enter the Date of Purchase – let’s say you put 6th of August, and you go again and try to post the entry, it still says “No Supplier Name entered…”

So it insists that you put the Supplier Name before it would apportion an amount or assign a value to that cell. So you then put that value then you come here and say ADD FEEDS PURCHASE AMOUNT. you see it now brings the value for that particular individual. Alright.

So it’s been tidied up to make it kind of control the user, to prevent the user making mistakes , to prevent the user from making mistakes. And of course it’s much improved – you will see from what will appear on your screen, you will see SMS exchanges I’ve had with the gentleman and ehr, he’s naturally very pleased that this has happened.

But I’m showing this video to those of you who already have the application – I mean he’s been very diligent in getting back to me. As he’s using it he’s getting used to it, and at every point I’ve supported him.

And he’s very comfortable with it now. But he came up with this idea for improvement of the application and look we’re better off at the end of the day. My dream is that as we evolve this app we can get to a point I can then implement my ultimate plan of having a cloud based version that will be a Mobile Phone App.

So that’s the ultimate goal. But I don’t want to do that, I don’t want to get to that point, before I’ve tidied up some of the key features and make sure they work properly.

Right, so if you have any questions do let me know.

Click HERE to watch 16 Step-by-Step Screenshot Video Demonstration Tutorials of the Poultry Farm Manager in use

First Screenshot Demonstration Video of the PFM – Posted on YouTube on 9th Nov. 2013 [Over 23k views]

Click HERE to watch 16 Step-by-Step Screenshot Video Demonstration Tutorials of the Poultry Farm Manager in use

 

 

Join my Cost-Saving Farm Business Ideas club & Get YOUR Ration Formulator software, Livestock Feed Formulation Handbook & Poultry Farm Manager software! Signup at www.iff.tayosolagbade.com

Join my Cost-Saving Farm Business Ideas club & Get YOUR Ration Formulator software, Livestock Feed Formulation Handbook & Poultry Farm Manager software!. Signup at www.iff.tayosolagbade.com

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top