Hey, what's up coach? Welcome back to the Six Figure Trainer Podcast. My name is Ben Neighbors and I promise if you watch this video all the way through, it's going to completely change how you run your business in the future. Today's episode is sponsored by MakeMoneyCoachingSports.com. Simply head over to MakeMoneyCoachingSports.com right now and access my free webinar where we break down exactly how to grow your company to six figures and beyond. Okay, if you want the most out of us, all you need to do is take a pen and piece of paper, jot down a couple notes here. And as soon as you get done watching this video, I want you to text me at this phone number right here. Just shoot me a text there. And that's how we can connect one on one. All right. So the two things that we need to write down, number one is organization. The second thing is importance of contacts. All right. And I'll explain what these two things are here in a second. So with organization, it's very different.  You don't have your contacts in one spot. Everything is kind of scattered. Your payments are scattered. You're doing Venmo, cash, checks. You don't have one centralized way of getting paid. And your business is kind of all over the place. Now I would tell you about 99% of coaches I know run their business that way. Everything is scattered. There's nothing that's just sitting in one dashboard. And if you want that one dashboard to have everything set up, email addresses, phone numbers, contacts, all the payment, your website, everything in one spot, then shoot me a text at this number here. And I'm going to show you something that we've built that's going to completely change your business. So organization is really key. So you're either organized or you're not. So if you're not organized, your business is going at the end of the day, it's going to lose money, especially when you try to run promotions for like Black Friday, Christmas, spring break, summer. If you don't have everything in one spot, then you're kind of just like blindly marketing because you don't have the reach that you should. So when you have everybody in one spot, it's very easy to make sales in your business, because everything is just sitting there and you're not losing a lot of time just looking for numbers here, looking for emails here, where did these people pay? When did they pay? Like those things should not be involved in your business ever. Right. So if you have that one dashboard, it's going to simplify everything. So organization is very, very key in your business. And again, you're either organized or you're not. Now the second thing that I want to cover here, to me, this is the most important detail of this training business, which is relationships. If you are good at building relationships in your business, that means you're going to have customers that stay with you for a long time. And it also means people who aren't customers yet are going to slowly become customers because of the relationships that you're building with them. And that could be through text marketing, that could be through social media marketing, that could be through email marketing, that could be through running a referral program. I mean, there's a lot of different ways to nurture your prospects to becoming customers. All right. But the thing that I know most coaches do is they overlook the value of one customer because the value of one customer is not just what they pay. It's what they end up doing throughout the whole year. And you got to be able to start tracking what do these customers do? How much are they spending? Who are they bringing into our business? Who are they telling about what we do? And if you have that tracked, like I said earlier, that's going to completely change how you operate your business. Because then you know this customer here, this is what the whole value of what they're bringing into our company, not just what they're spending, but what they're doing for us. And that's going to help you get a lot better at marketing, because then you know what certain people are doing or not doing. And if you don't have that tracked, again, that's on you, that's on you, you're the business owner. So having that sort of stuff tracked is really important. And the last thing that I'll tell you, all right, and I had someone tell me this a long time ago, and I didn't believe them until it happened to me. All right. But I used to run a bunch of free clinics. And the intent with the free clinics was to gather new information that I didn't have yet. So new leads, new phone numbers, new names, new email addresses. And I used to run these clinics with the YMCA. So they already had all of the contacts that I would ever want. So I partnered with them, I run the clinics, I would get new names, new numbers, new emails, and they would be added to my list. But the thing is at the very beginning, I didn't understand how valuable that new list was, because I was afraid to reach out to them. I was afraid to sell. And that was a self limiting belief that I had. And the only person that could get over that or get through that, that issue was me. So I had to look at every single lead individually and say, how can I best serve them, even though they're not in our program yet, I have them as a lead, what can I do to make this a really valuable experience for them by reading an email, by marketing to them, by getting on a call with them. And the thing is, these weren't like cold leads, because they already raised their hand saying, Hey, here's here's my email. All right. So you have to look at every single lead that you have, almost like you're like you're looking at them as a customer. Because if you treat them that way, they're going to want to do business with you. All right.  And again, you're either organized or you're not the coaches that we've worked with that are doing the best. Like, and I'm talking about coaches that at this point are making over a half a million dollars per year. What they do is they're just more organized with the little details in their business. And like I said, if you want to be more organized, you want to have one dashboard that has everything, send me a text right here. I'd love to get on a quick chat with you, show you what we have. It's not a sales call. I'm just going to show you what we have and see if it's a good fit. And if it is, you'll probably want it. That's it for today. Can't wait to see you again.


Good morning and welcome to everyone. Welcome to the panel on the challenges in Latin America. I'll do a short introduction. My name is Andres Martinez, and I'm the bureau chief for Bloomberg News here in Argentina.  We have the former president of the Dominican Republic, Mr. President, Lionel Hernandez. To my left is Rebecca Greenspan of the Secretary General of the Secretaría General Iberoamericana. We have Ricardo Hausman of Harvard, I think you all know. Felipe Lareng, the former finance minister of Chile and professor. And we have Daniel Saboto, the regional director for the Latin American, the Caribbean of the International Institute for Democracy and Electrical Assistance. We find ourselves right now meeting here really in sort of a cusp of tumultuous events across the region the last few weeks from Venezuela to Ecuador to Paraguay, even sometimes here in Argentina. In Argentina, we can't ignore the fact that there's a national strike today, the first day of the World Economic Forum, and it's causing some troubles. And so we'll obviously discuss that. And the key here I think is to identify what the challenges are and figure out where we're headed for the rest of the year, what happens in terms of elections, what defines these elections, how do these challenges impact that. In the next year, many of these countries will have these elections, and the crucial votes are going to help us determine a couple of things. Where politics head, will there be a resurgence in populism, a return to some previous behaviors that we thought we'd sort of avoided in the region, what will happen with retrade policies, and what new or old alliances will be born. So to start off, I'd like each panelist to maybe give us an overview of what the challenges in the region are for just a minute or two. Now we will speak in English, and if you want to listen in English or any other language, you can use your headphones, Mr. Chairman, in Spanish, yes. So I would say that in general terms, the challenges we face in the region, in Latin America, are the same global challenges. We are in economic and political cycles which are closely connected. We would say that both phenomena that impact the most are globalization in the first place, and in the second place, the international financial crisis which has turned into global recession, in as much as there has been a consolidation of this phenomenon and it has had a political impact. For Latin America, which had its golden decade from 2002 to 2010 or 2012, and had high economic growth in general terms, 5 or 5.2% per year. This has declined enormously. It has reached 0.5% due to the deceleration of the Chinese economy which has had an impact on Latin American exports to that part of the world, a great dependence on exports of commodities, of natural resources which will imply towards the future a diversification of economies in Latin America and the search for new export markets. So that situation of deceleration of Chinese economy impacted the growth of South American countries and has generated discontent which is reflected in elections. So the most affected countries have lost the elections regardless of their economic cycle. In as much as it has been possible to overcome the crisis, the electoral support goes down but is maintained slightly. The most recent case and the clearest one is Ecuador. Ecuador, a decade of political stability, a decade where there have been important changes, a development of infrastructure, but the last two years with recession the economy shrunk. There was social discontent but as they are not on the brink of a collapse, it is difficult for the ruling party to win. They went on the second round but that's the difference between collapse and a recession which has been managed. I will speak in headlines and I suppose we could talk about it afterwards. I believe the first challenge for the region is how to carry out the productive transformation at difficult times, a change that we didn't have in the boom years. How will we generate quality jobs for the most educated youth that we have ever had in the region when there is low international growth and there is also the risk of protectionism, a new cycle of protectionism and obviously with the industrial revolution at our doorstep which will save labour. That I believe is the first challenge. The second challenge is how to protect what we did do in the boom years which is to reduce poverty and inequality. We see reversions, 7 million people have gone below the poverty line in the last few years. And therefore we are losing what we achieved and this generates important tensions amongst in society. The third challenge is the democratic challenge which includes in my opinion the citizens security challenge the issue of violence in our cities and how institutions and the political system will come up today to respond to society's demands. What is happening with corruption is the result of a society which is far less tolerant with corruption. It is more demanding with its political systems and institutions and institutions are lagging behind society and I would say also behind the economy. Finally and nationally speaking we have the environmental challenge the world has which is a global challenge and to conclude I would say there are five points the challenge of integration. Now can we take advantage of this opportunity to have a far more integrated region. What do we do with lagging infrastructure to integrate what are we going to do with the movement of people and talent in the region will we be able to give a qualitative leap to integrate further. Ricardo I was talking to a colleague of mine Rafael Litala who is there in Harvard and he says that the governments do or what governments do depends on the set of belief the people have and part of the problem in Latin America is that that set of beliefs of narratives of representations are a reflection of our reality so what would Latin America need to grow to develop it has to believe in the future it has to believe that the future will be far better than the present and that in the future there will be companies representing us organizations representing us and that don't exist today so undertakings have to be open that we have to have an open frame of mind to immigration to solidarity to the creation of a state which supplements and stimulates all these transformations and not a state taking the place of society a state looking to remove society's power to take its place not that to generate that dynamic that environment that disposition to certain political reforms has to be based on a certain narrative and which is Latin America's narrative the narrative of a good part of Latin America beginning with Eduardo Cagliano and La Venus Xavier that's on all the rest is that we are a wealthy a very wealthy region but that wealth was taken by the wealthy or the corrupt and what we have to do is not build anything because we are already there the problem is a problem of distribution of a fight in distribution so we get stuck in these sort of issues the world is made up by two groups a homogenous good group whether or not many conflicts and that's the people and as people of Podemos say we have the other group the castes and what we want to do is give all the power to the leader of the people so that he or she can protect the people from the castes or castes and all these democratic formalities are an issuer barrier which prevents the leader from defending the people from all these tribes or castes so I am depressed about Latin America's reaction to Fidel Castro's death did you hear what was said about Fidel Castro we know that the economic model was an absolute failure it goes against development and it is forced agnation but in Latin America's mind he was a true leader who faced evil to defend the good people and that attitude has been the attitude of Latin America with the catastrophe of my country Venezuela where we had to understand that this was a good leader of the people who took the country to an unimaginable catastrophe only two years after the end of the largest oil boom in our history so my feeling is that while we don't change our narrative my Leagentine story is that they are not poor people who are being dispossessed and while we don't create a narrative that includes all of assassination only then will we be able to come out of these difficulties Daniel, yes, thank you Andrés good morning to you all I would like to emphasise the following at this precise moment in 2017 three important junctures come together on the one hand next year the region will celebrate its first 40 years of the beginning of the third democratic wave which began in 1978 in the Dominican Republic and in Ecuador so for the first time the region in general terms in different countries went at different times to democracy and it has the possibility of exercising democracies beyond its failures and has gone through democratic learning the second issue is that in this year 2017 we will begin a new election cycle with three elections, three presidential ones one we have just had in Ecuador November is Chile and then Honduras and a mid-term election of great importance in Argentina because to a large extent the governance of the second stage of President Macri's administration will be defined but in the next four years after 2017 all the region will have 18 presidential elections and we have to focus on those that will occur in 2018 there we have Venezuela, Mexico, Colombia and Brazil which together with Chile in 2017 will give us a feeling of the path to be followed by the region in the next four to five years and the third is the juncture what you pointed out at the beginning obviously we are holding this forum at a time when you open the newspaper one country after the other says crisis, crisis, crisis in Venezuela, in Brazil, in Ecuador, in Paraguay but I think we have to also make a distinction the region has had very important things last year which have been concealed by this immediacy the question of the peace process in Colombia that is fundamental, a structural issue in the region there are other good bits of news but many of the crisis affecting us now are of a different kind the crisis in Paraguay is a crisis created by President Cartes for a simple region he is another president deciding to change the rules of the game of when he was elected to remain in power that is one of the curses we have in Latin America re-elections and one of the problems we have in Latin America is that we have to begin to say very clearly so as not to be too diplomatic what has happened because due to this fact we have a tragedy that goes back years in Venezuela because we never wanted to say what it was actually it was a non-democratic system an authoritarian system which could fall into a dictatorship not a traditional dictatorship this is a new form of authoritarianism the crisis in Ecuador is a juncture one and the opposition losing the elections and what happened was what happens all over the place I will challenge the results if the person is right he will win or not he will lose so I believe the deep crisis in the region is the crisis in Venezuela and I do think the crisis in Brazil is important but we don't have to look at it only in terms of a crisis but also in terms of opportunities and I would like to close with the following all identifications made of challenges and risks are shared by me but I also share the three fundamental risks which the World Economic Forum has identified for the region and the first one in which all executives have agreed on are failures in governance we don't have the institutions as Rebecca said nor the political leadership to face the new agenda which is a middle class agenda and not a traditional one such as in previous years another question is a deep instability social instability and the strike in Argentina shows it today but it's not the only case and the third has to do with unemployment and precariousness of jobs not only going back in terms of poverty there is an elephant, a white elephant which is inequality and precariousness of jobs especially among young people Felipe, yes, good morning a pleasure to be here in the first place I would like to express my solidarity towards my friend Ricardo Hausmann because of the situation in Venezuela we are friends and colleagues and our friendship goes back many years and I have seen him fight for Venezuela he lived in Venezuela I'm happy that Venezuela is beginning to speak at the OAS and governments condemning the abuses of against democracy and the way out, the exit you know that's not easy at all my first point is in political terms regarding the fact that in my opinion populism has gone bankrupt in Latin America with the exception of the case of Ecuador mentioned by President Lionel Fernández with the exception of Ecuador all other countries in all other countries, all populist rulers who have gone to or who have voted or elected have lost and in the Ecuadorian case there was election we don't know whether they won something very curious happened yesterday of the 39,000 records 38,000 where there was an agreement and 1,000 of them which showed that the opposition won and that will have to be analyzed by the electoral council the national council I'm not quite sure whether that council if they show them the reports with errors will recognize the defeat of the ruling party I'm not very sure that that will happen but regarding the rest of the elections this year and I would like to say this to be transparent with the audience in the Chilean case I'm not an independent analyst I'm involved and only for those who are here in Chile we will have better times better times are ahead now regarding other topics if there's any interest we can talk about this during the question and answer session and other issues for the region income distribution, poverty in Latin America we must not forget about the fact that it has been successful in lifting many people out of poverty what happened in most of the last decade and the super cycle of commodities is that those people were lifted out of poverty and there is an enormous middle class so challenges are very big we must not stop fighting against poverty those are the most vulnerable people but this is politically complicated because today the challenges faced by the governments are middle class demands and in Chile one of the big issues today one of the most important political points is the demand of students who want a free higher education that is not a demand of the poor but of the middle class or higher middle class this has politically been very popular and these demands the demands of a middle class who is overwhelmed by debts in education are the demands that will have to be solved by politicians and let's hope they do this in a responsible way this question of a boom of the middle class is a different scenario from the one we have lived before in income distribution it is true that in Latin America we have the doubtful privilege of being the most unequal region in the world but obviously inequality has come down but it's still high although it has come down and regarding this subject I would also like to say because I believe another big challenge is the end of the commodities super cycle I believe that analyzing the region as a whole and saying we're all affected in the same way is not quite so because it's a question of seeing what commodities you export if you export oil and you depend 95% on oil you're far more complicated than if you export another commodity in my country copper has fallen we are greatly dependent on copper same as Peru but we import 98% of our oil so the analysis is a little more complex and it differs from country to country like in Colombia Colombia is quite the opposite of Colombia what it has is oil 50% of its exports are oil and if we add to that coal and other minerals it gets to 60% and this has had a very strong impact so terms of trade have been quite different in all the countries and what have we done in the super cycle there are countries who built adequate institutions and today survive better because what did they do they had sovereign funds structural fiscal rules fiscal councils which gave long term stability says autonomous central banks those countries are in far better conditions than the ones who did not get these institutions and what they spent as Ricardo said Venezuela at the height of the oil boom had a fiscal deficit now today the fiscal deficit are 30 points of the GDP or something to that effect so there is high inflation because there's no other way to fund that deficit so I believe that here what is applied is what Warren Buffett says when the tide is high everybody seems to be swimming properly when the tide comes down there we see who is swimming nude so this is what happens in Latin America and the last point I would like to submit to discussion is what is happening with Trump and Latin America and the question just to discuss it here did we seem to have disappeared from the USA debate except for Mexico the rest of Latin America doesn't seem to exist and what is our response as a region we must not just wait and see what Mr. Trump decides to do the next day or what he tweets I was very impressed as an economist when he said they said that one one night at 2am he woke up and called his national security advisor to ask him if a strong dollar was good or bad for the USA to call the national security advisor and ask him an economic question is really incredible so I believe there is another issue there in this globalized world where we are facing the paradox that China today speaks in favor of free trade and the USA turns into a protectionist power I believe one of the points underlined here is the question of institutions and what quality of institutions were created in the region in the last 10 to 15 years during this boom and the boom of commodities that has come to an end Daniel speaking perhaps about which institutions or countries have made progress are we seeing setbacks as Rebecca said or is it a collapse what are the countries we are most concerned about for reasons of setbacks and which are in collapse I believe some are obvious I think the key issue here is as Laraín said to look at the great diversity and heterogeneity in the region we don't have much time and it would be impossible but to speak about Latin America as a whole is no longer possible we need to break it down into countries if we took the the economist index on democracy you have almost four groups of countries one of a more consolidated democracy which used to have three, Uruguay, Chile and Costa Rica two of which fell, Chile and Costa Rica fell and only Uruguay remains have we fallen you fell fallen because of issues of governance and excessive fragmentation of the political party system you may agree or not but argue with the economist I don't agree with the economist you can write to the intelligence unit I will do so immediately I'm sorry I've hurt your Tika feelings and Chile hasn't fallen either we have our issues but they don't have to do with democracy the democracy of the political system because the index measures variables of the political system then there's another group the largest group of the so-called democracies in transition or flawed democracies which includes some 10 countries that differ quite greatly among them and then there are the so-called or rather liberal systems where you have Nicaragua or Alba when you say populism lost everywhere unfortunately in Nicaragua Daniel Ortega is still under a clearly authoritarian system and falsely called democratic with a family dynasty now because he's put his wife on the ticket so these are the issues we need to put on the table to clearly debate them you have all of Alba, Honduras, Guatemala Paraguay and finally a rather authoritarian system including Cuba I do believe that our success over the past one decade and a half of lifting more than 60 million people out of poverty and bringing them into the middle class and the fact that for the first time the 32 percent of people we have the middle class plus the vulnerable group for the first time we have more people there than living in poverty opens up a new society with a new agenda one that I call a middle class agenda which is requesting three things give me more public utilities give me better quality public utilities and give them to me now a new middle class with these demands is raising governance issues similar to what Huntington proposed 40 years ago in the first crisis of mature democracies why because we have governments that lack the capacity in many of these countries of responding with good public policies because we lack the necessary taxation we need to talk about that with an average of 21 percent although in other countries it is much higher it is not enough and because we have political systems which are also affected in many cases by a deep credibility crisis representation crisis the credibility crisis among the elites so similar to the case in Europe and the United States we need to be mindful of the fact that when the middle class is happy it is a fantastic political stability however when the middle class it doesn't see a good future for itself and fears a setback as Rebecca said because you've lifted them from poverty and they fear they will go back down or fear they will lose their jobs if you add insecurity to that combination and the new issue of corruption which unfortunately is here to stay political institutionality to impose changes to adjust to the new reality the big question is and that's why I agree with the analysis of the World Economic Forum in that the key issue is in the failures of governance we lack the degree of institutionality and political leadership in many of our countries today we have institutions that date back to the 18th and 19th centuries to respond to complex societies of the 21st century if we add social media technology etc it forces overall re-engineering Philippe you mentioned the middle class in your comment from the beginning and Daniel is stressing that point now considering the upcoming elections in Argentina in six months time how does the political world or institutions respond to middle class demands at a time of little growth and much fiscal pressure what's the response and what challenges should be considered in terms of the direction politicians will be taking I think here lies one of the most important tensions in our countries currently middle class demands organized middle class now quite vocal which organizes itself and goes out to the streets and there are governments and I believe we need to distinguish between governments ruling for the streets and those who listen to the people on the streets but make their decisions to benefit the well-being of the country let me give you an example we've had a discussion which is a typical middle class demand a very deep discussion or debate on free of charge services and the current government says and it's funny because the president took office and when she stepped down as a candidate and she says I think it's not good to give education free of charge because we'll be giving it to the rich as well but the streets demanded and some of the students are representatives in parliament currently they called for free of charge education so three weeks later the president says no now we will choose free of charge education and based on the calculations in our center the center I lead at the catholic university it costs five million dollars more than what we're currently spending at times when fiscal revenue has dropped so we are promising the people that when we make our calculations the possibility of providing higher education free of charge for all not only university but also technical and vocational professional training it becomes very difficult and by 2050 only could it be possible if the stars align themselves in a given way it's another way of telling people I'm offering or promising free of charge education but I can't provide it and there are also demands in healthcare and other kinds of demands from the public sector so the government made an adjustment of zero in real terms to public compensation because somebody has to pay and after having introduced a tax reform and there's a discussion there because it slowed down the economy significantly and weakened tax revenues rather than increasing them so the tensions are in that this middle class is exacerbating the rights where are my rights and these are the theories of some who are stressing social rights which is volunteerism in my opinion because if I stress the rights and neglect the duties or responsibilities people will say and in addition I include this in the constitutions of these welfare states we will have a problem because people will feel they have rights enshrined in the constitution that they are not receiving so they will appeal to the justice system and we will see litigation and social unrest or discontent because when you promise people something you cannot deliver this is a kind of reaction you get so I believe it would be better and the two options are one telling people out there that you will provide everything they demand but that's a recipe for future in my opinion and the other one because it's insatiable and the other option is to work responsibly and tell the truth and the risk there is losing the next election and I would rather lose an election telling people the truth than deceiving people by making false promises Rebecca you have a point two points firstly when we speak about the cycle and who's losing and winning actually I think what's happening in Latin America and most countries with the exceptions mentioned is that there are democratic cycles neither the populist are always losing nor the ones who did things right are always winning right in a democratic system there is alternance and I think we need to get used to the idea that in most of our countries we continue to be different political parties alternating in power and they will think differently relative to what needs to be done in terms of social and economic policies I think that's the first point because it's very easy to say it's not that the ones who did things wrong are losing but it is a relative a subjective thing because those who did things right will be losing too first of all I think we need to be a little Manichean in terms of who's in power and secondly in addition to being less Manichean the true issue is that we see high polarization in the region so it's very difficult to build shared project for societies although there are different political parties taking office we need to find some things on which we can have consensus in society that will take place or be implemented in the long term and I believe we are lacking that this long term vision of society where all governments have sort of a backbone but a common core despite their differences is something we do not see and that's where the future challenges lie as we say in my country somebody is eating the pineapple and somebody else feels the stomach ache and that's the problem for the long haul governments are making investments now which they will not be benefitting from until way into the future that's where we need a society and institutions that are capable of maintaining a long term vision in our countries because our issues will not be solved in the next election they will have to be solved over the next generation and I believe there is a problem in the political system of flow in the institutions because indeed society and the economy are moving much faster than the institutional system this system has not adjusted to be able to respond and I see that partly what we are seeing is the populations in satisfaction vis a vis the lack of responsiveness from the political system and institutions and my final point and I'm really concerned about this is the distance from youth to the political system I think we need to invest much more in an intergenerational dialogue with the youth for my generation democracy is not a fact it's a conquest and we bet on democracy because of its functionality and also because of its intrinsic value when you talk to young people they judge democracy based on its functionality rather than considering it an achievement at the same time we speak of political parties and that political system they no longer feel represents them or includes them I believe we need to hold this debate because we need to rebuild trust on a system that will solve both things if we choose one over the other we will face trouble in the region regarding the youth and then I will turn to the president who has a point the youth do not see the value in participating in the political system do we need to adjust the political system or should we find a way of teaching it with the values we had in the previous generation perhaps I think we need to do both we cannot waive our values because otherwise we would end up with nothing in terms of our vision of what kind of societies we want to build but on the other hand I believe they are right in detecting an issue whereby young people are not included in the system and political parties that's true I think nobody wants to leave and the space for new people young people to take on leadership positions are quite close in many places Mr. President I think to understand the political situation in the region it may be important to resort to history I think there are shared elements between Cuba and the Dominican Republic in the late fifties 1959 is a key year for Latin America why back then the collapse of the dictatorship of Marcos Perez in Venezuela had already taken place and as a result of the fall in Venezuela there was a long democratic cycle in Venezuela that we know as the fixed point covenant in Cuba Fidel Castro started his political career as a candidate for representative representing the province of Havana however Volkensio Batista gives a coup d'etat in 1952 and the response is the attack on Montal in 1953 and 59 Venezuela defined a democratic process and Cuba started a revolutionary one my country the Dominican Republic was ruled by a long dictatorship Rafael his dictatorship fell there were elections and leader in exile Juan Bosch won and he lasted only seven months in government there was a military coup d'etat two years later there was an attempt to reimpose that democratic government legitimately voted by the Dominican people and the reaction was a military intervention by the US in the sixties there were coup d'etats against the joint government in Brazil and there's certainly pessimism relative to feasibility of democracy in the region civil governments elected democratically overthrown by military dictatorships so back then in the sixties the discussion was revolution or democracy I think this was solved in the late seventies as Daniel said between the Dominican Republic and Ecuador there was alternance in power through elections starting in the eighties in that transition from authoritarian regimes to civil elected governments we started planting the seed of democracy and overcame the problem that used to be the big question what's the only legitimate source of power it's not a left wing we're killing that with a agreement in Colombia the left wing guerrillas are not a legitimate source of access to power neither are the right wing military coups so the only legitimate source of accession to power are elections universal vote and I think in the eighties we started that transition starting with a creation of independence now within democracy I think that has also created a significant mutation regarding institutions I think Daniel there have been significant changes here institutional strengthening based on the Latin American constitutionalism we've seen in the eighties so we have seen a transformation from model of representative democracies to models of participatory democracies there was a consolidation of civil and political rights in those constitutional texts and an expansion of new rights Felipe referred to the feasibility of delivering those rights because they no longer political and civil but economic social cultural and environmental rights as well and citizens are given the legal power to demand compliance with those rights through appeals for judicial review so judges need to determine the right of citizens to social and cultural and economic entitlements another fundamental thing within a representative democracy changing to a participatory one is the direct exercise of democracy with institutions we didn't know like plebiscites referendum not only in Venezuela but in many other countries as well and of course those forms of direct participation which exist currently in Latin American constitutionality which is renovation for the region and finally in terms of the cycle I insist historical cycles match economic and electoral cycles not only in Latin America the impact of the global recession has triggered in Europe for example from 2008 until 2016 17 elections 16 governments of which have lost the only ones who were saved was Angela Merkel who faces a new electoral challenge so the problem is who was in power when the crisis overcame if it was a left wing populism lost if it was a right wing those governments lost so the global crisis created an alteration of the political system that reflected in electoral cycles and in Latin America to conclude the boom of commodity prices matched the presence of left wing progressive governments in Latin America in as much as copper and oil and natural gas prices were high governments were re-elected however starting in 2014 a new era began a new stage where the slow down in the Chinese economy's growth from 12 to 6% brought commodity prices down and that reflected on the next elections and now it's up to more conservative governments to be in power so depending on the economic winds will be their possibilities to stay in political power I think the president made a good summary of the points we discussed here and the most important challenge is how will that translate into people's votes and one of the most important issues Felipe mentioned relative to the middle class Daniela and Rebecca middle class demands and at the same time the high corruption in the region we cannot overlook the degree of the level of the impact it has on countries like Brazil Peru where we see stagnated projects because tenders have to be put out again so considering all of this what's your vision for the upcoming elections and these factors playing as a combination very well let me answer in the following way in the first place I was impacted by what Daniel said on what the middle class says give me more, give me better, give me now and what came to my mind was the Kennedy school statement if don't ask what the country can do for you but what you can do for your country and which is a story of the country that we are building the country is built but I have not received from it and Felipe mentioned this as well where is our homework here we have to go to a narrative which states that we want to build a country a far better country than the one we have so that our children and our grandchildren have something that we never got to see but we would like them to have and how did we get that far in the context we have to get there with more education okay so let's have education to get there but it's not a question of give me a kind of indication we want to build a country second point elections well I don't know there were elections of the legislative assembly on December the 6th in Venezuela elections haven't changed anything at all and let us assume that there are elections and maduro wins people in Venezuela are not free to import nor are they free to sell nor are they free to hire nor are they free to do big things they have removed from society all the liberties it needs to undertake to create and that is supposedly a participatory democracy what it is in fact is in elimination not only of democracy but also of the necessary freedom to create and I would like to emphasize one point which shows that Latin America is an outlier in the world except for Costa Rica and Panama in the United States 14 percent of the population is made up by foreigners 30 percent of entrepreneurs are foreigners most Harvard professors are foreigners in Canada 25 percent of the population is made up of foreigners in Australia, New Zealand 25 percent in Singapore and everybody wants to compare to Singapore 40 percent of the population is made up of foreigners in countries like Mexico 0.4 percent of the population is made up of foreigners in Colombia 0.25 percent of the population is a foreign in Colombia there is one foreign for every 400 people in spite of the fact that there are 40 times more Colombians abroad than foreigners in Colombia and when facing the possibility of absorbing all the Venezuelan talent which is returning to the country they have created all kinds of hindrances and barriers in Chile one of the most difficult problems for the country is that they are getting full of foreigners and they're not that white so there is an attitude in the region to close themselves to immigration and even a popular demonstration vis-à-vis the arrival of Venezuelans in spite of the very general support that the Dominican Republic has given to the Venezuelan dictatorship but if we really believe we want to build a country we have to absorb the talent of the world but that is not our legislation and that is not our attitude I know that you all want to respond quickly but I want to see whether there are any questions and then I will allow you to answer don't answer just now all I would like to do is tell you that what Ricardo says is very interesting but if one makes a good analysis you have to distinguish between supply and demand factors in terms of immigration why are there so many foreigners who come into the United States you say 15% there are a large number they are trying to get into the United States but the demand for migration is in the country there is also an attitude in the country of welcoming them or not I don't see that in Chile we are worried about the color of the people arriving but although the percentage of foreigners is low have a look at the rate of increase of migration Chile has one of the largest rises in migration in the world after Germany obviously whose rate has increased enormously we have an immigration law which our government submitted to congress to encourage immigration which was at a standstill I don't see that attitude there might be some sectors who feel threatened because immigration will always be a threat especially in labor terms for certain sectors but the country's general attitude is a country of welcoming migrants who want to make a contribution not to those who want to enjoy the social security system regarding supply and demand I believe the Venezuelan cases a natural experiment because now all of a sudden there is an increase in demand we can see how countries react in the case of Chile its true immigration in Chile has gone up significantly and immigration policy in Chile is relatively open what is closed is the labor market and regulations in many sectors and regulations of doctors who cannot register because the medical doctors in Chile don't want migrant doctors in the case of Colombia its pathetic its a country where nobody has wanted to go and they say we haven't been attractive but when people do want to go they can't get in and then they don't get their visas and the regulation of visas changes so I think it is an issue that no country in Latin America has an active policy searching for talented migrants as it happens with Canadians or Australians on that side we haven't opened up but in the case of Panama Panama is the country that has grown the most in Latin America in the last 25 years and I think there is a lot to learn from Panama in Panama and Panama has led to a significant immigration which the law almost forbids so they have been looking for excuses to basic laws to allow immigration and what Panama shows is that to grow significantly you need to import talent because whenever we say here there is a scarcity of skills we have to improve education we have a scarcity of skills we have to open up to immigration that's the instant response and those migrants with those skills will train the next generation of people and the successful cases like Corta Rica who has benefited enormously from the absorption of foreign talent there you can that can be seen in the story of all Latin America the history of Argentina, Brazil, Chile companies existing today are companies that were founded by migrants three generations ago but this generation is not receiving that level of migrants and this is a reflection of the fact that we are not trying to create a nation I think we could spend an entire panel dealing with this topic but we've only got five minutes left would anybody like to ask questions here at the front please thank you good morning now me and Nandi's global shaper from Salvador and I think that several issues have been dealt with which I agree with entirely one is a political class which wants re-election who wants to remain permanently and thereafter a third term in the same position and also I think our generation has been called a generation with a lack of leadership in the sense that we want to change we are committed but we don't believe in the system because we haven't had examples of heroes doing the work providing service so how do we assess a hybrid model of young people who want to work and contribute to the country maybe not participating actively in politics and it would also be good to assess I would like to hear your perspective about whether it would be good to assess or ensure some minimum positions young people for young people in our institutions same likewise with gender equality to give women access it would be good to do that in our institutions with young people as well very well I agree with the hybrid model I think yes that has to be discussed what I find is we don't know a democracy without the parties as we know them today I'm a person who thinks you have to strengthen parties they have to be more open parties have to represent that which is the long term they have to have room for young people so that they join, they participate they debate but young people don't believe in the party system parties are the worst like when you look at what is rated the worst are political parties what are the new organizations within democracy that will play that role and they talk to me about movements which are movements that I think now are more short term movements they don't have the organization allowing the democratic system to work on far sounder structures but I do believe we have to have that discussion I think that to open up spaces is the most important thing and we are devoted to that right now to open spaces of participation for young people and not only political leadership in society, in undertakings leadership in companies and the question of quotas I defend them for women definitely because I believe in them I would be in agreement but within parties and a minimum amount of participation in decision making I don't think the space is open just yes to think about quotas in terms of electoral representation which I think would be something else I would keep the issue to within parties Ambassador first and foremost thank you very much to all the panel for being politically correct in your discussions which led to a dynamic debate there was a very interesting historic assessment by President Fernandez now a question what is the dynamic and the position towards new constitutionalism or in the case of no new constitutionalism between a representative democracy and a participative democracy I will answer immediately but I have to clarify one thing my distinguished friend to my friend Ricardo Hausmann the Dominican Republic never votes in favor of dictatorships we have a mediation policy and dialogue promotion as the Pope has as the UN Secretary General has and most countries in the region it's not the first time that we've resorted to it in the crisis between Venezuela Ecuador Columbia the Dominican Republic and the Rio summit based on the dialogue and the crisis was resolved in the crisis of Honduras and President we participated with an intermediation role in as much as possible and that is our participation in the specific case of Venezuela but we don't support dictatorships and professor Ricardo Hausmann is a distinguished friend who helped me a lot in the solution of the Dominican economic situation in 2004 knows that but these are different forms of participation and just an anecdote to consolidate this or to show you a little care of what I said when I visited the White House an official state visit President George W. Bush waited for me he was irritated because of what Hugo Chavez had said at the UN General Assembly when it was his turn to say that they're suffering and he was furious he thought I was Hugo Chavez he really made a mistake he confused me he said all sorts of things to me and at the end he says what do you think and I said look Mr. President the Dominican Republic a small country in the Caribbean feels a friend of the United States and personally we are friends of yours but the Dominican Republic has a long traditional friendship with Venezuela regardless of the President the mother of the Dominican Republic lived in exile in Venezuela died in Venezuela we received aid from Romulo Betancourt help from Romulo Caldera also from Hugo Chavez we are friends of Hugo Chavez just as we are friends of yours and as we have two friends what we can do is give you the possibility to come together and we offer you the Dominican Republic as the scenario obviously he laughed and the dialogue didn't take place but the attitude the role the communication can play is to act as an intermediary between friends who are fighting so we don't support authoritarian governments or dictatorships unfortunately we have to close we could carry on talking for another hour or two only talking about Venezuela and what it has received or what it hasn't received but regardless of you can but I would like to express my regret because of the fact that the efforts of President Lionel Fernández were wasted in a nefarious dialogue which boycotted Latin America's capacity to make valid the democratic charter I think we will have to continue our discussion outside of the panel with this I thank you all very much for this talk which was very honest and as the ambassador said it was very rich and I hope you enjoy it thank you very much


QuickBooks Desktop 2023. Generate reports after entering beginning balances. Let's do it within 2-its QuickBooks Desktop 2023. Support accounting instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. Here we are in QuickBooks Desktop get great guitars practice file we started up in a prior presentation going through the setup process we do every time maximizing the homepage to the gray area going to the view drop down noting we've got the hide icon bar open windows list checked off open windows open on the left hand side opening up the major two financial statement reports by going to the reports drop down company and financial looking at the profit and loss let's do a range change up top from 0101 2 2 to 12 3122 and let's go ahead and customize it as well and increase the font size as has been our custom to 12 so we can see it a little better yes and okay and then the other major financial statement report we've been opening every time is going to be that balance sheet report let's do the customization first and then change the range from 0101 2 2 to 12 3122 and then go to the fonts and numbers changing the font size bringing it up to 12 okay yes please and okay so the process we've been doing is imagining that we have another accounting system or had a prior accounting system we're changing to the QuickBooks system instead of importing all the data from the other system we're going to start after the cutoff and move forward from that point forward that being January 1st 2023 therefore we want to put our beginning balances which we got from this worksheet as of the prior period which is December 31st 2022 get those in place in our accounting software and and then be ready to move forward within QuickBooks for the next month of operation moving forward from that time frame so we're going to now run the reports and consider the reports for a couple different reasons one if you're following along with the practice problem we want to basically check our numbers with the reports and then two if there's any problems with the numbers we'll also run a transaction detail report and that's a great report to kind of drill down on and double check your numbers it's also a great report that you might use for billing status so we can kind of think about how we might charge somebody if we're entering transactions in a way that wouldn't just simply be hourly which is something I highly consider doing if you're a bookkeeper just to consider other options then just say an hourly kind of rate system and then we'll also think about how we might print some of these reports to give them to someone like a client at the end of the month or the end of a job and we also want to print those reports and possibly give them to you so that you could check your numbers that way as well if you so choose now obviously the major two financial statement reports are the balance sheet and the income statement these are the main two reports that we are constructing when we enter data into the system all other reports and note there are a lot of them so we got all these reports here can be quite overwhelming but almost all these other reports are giving you more detail about one or multiple line items on the major two financial statement reports of the balance sheet and the income statement so let's just kind of go through this I'm just going to scroll through so you can see the categorizations just give a quick recap of what we did when we entered these we entered the checking account basically into the register directly we still going to have to deal with outstanding checks possibly when we do the reconciliation which we'll do in the future accounts receivable we entered as we entered the customer the major subsidiary ledger to that will be accounts receivable broken out by customer and then we've got the inventory there's a major subsidiary report breaking out the inventory by item so we entered the inventory when we entered the items we entered the fixed assets of furniture and equipment and accumulated depreciation directly into the registers or the opening balances as we set up those accounts and then we entered the accounts payable which has a sub ledger of a vendor breaking out this detail by who we owe the money to we've got the visa account which is going to be our credit card account which we entered directly into the register or opening balance loan payable we entered directly into the register or opening balance no major sub ledger other than the amortization table which will typically be outside of quickbooks and then we had to make some adjustments to the owner's equity down below to account for the fact that they put some stuff into the opening balance equity remember that the net income here quickbooks is trying to tie in the net income from the income statement to show that it's related to the balance sheet that can be useful but it's also a bit confusing but how it's useful notice if I go to the income statement for January through December of 2022 I have this activity now this is activity that I'm not really caring about because it's for the prior year but it does show us that that these items are related to the balance sheet when I say it's for the prior year we entered this data to get these beginning balances in place and are not going to enter new detail into the system until January 1st of 2022 the reason this is kind of a problem down here or could be is because it doesn't work quite so well if you're not running a year end report like it rolls over year over year well but if you run a month by month report the net income doesn't give you net income for the month for example it gives the net income for the year generally and if you don't have a sole proprietorship but like a partnership and you need to be breaking the net income out into the capital accounts of multiple partners two or more partners that gets a little bit funny looking when you have the income down here as well in other words if I go to one day into the future of 2023 you can see it rolls into the equity account and because there's only one owner we've got that one equity account here so those are the the major two reports and and also just remember that if I I brought it back down to 2022 if I go to the income statement we really aren't going to have anything in the income statement when we start entering new data into the system this is really the prior year which I'm not concerned at with this report because I would be looking at the prior accounting system if I change this from 010123 to 123123 then we've got nothing in the income statement at that time but if you're checking your numbers 010122 to 123122 this is what we have for the data input the other great form is the trial balance we've been touching in on reports drop down and we're going to go to the accounting and taxes and the trial balance and this is just a really good 010122 to 123122 and we're going to customize this report fonts and numbers changing the font to 12 okay yes and okay great report to get used to we'll start to use it a little bit more and try to put it in a little bit more often because you could see everything in one place and that helped us to check our numbers to the trial balance here which was our data input field very nice and easy we can see down here that we have the income of statement accounts included and you can see how it rolls into equity here so this is very nice way to be able to see it as well because if I take this up to one more day in the future 010123 to 123123 you see those income statements accounts roll out and there's the 77896 which was the amount on our beginning balances okay so let's bring this back to 2022 010122 to 123122 now if your numbers don't match this you can drill down on the data and look at the at the transactions and you can drill down further to get to the source document that's the great thing about QuickBooks is it allows you to do the data input and then kind of do what you would do in like an audit process you go from the end result and then drill back down into the data input field but this gives you the data input I'm closing those out by account possibly you also want to take a look at it by the time you entered it so the other report that we want to take a look at reports drop down is going to be accounting and taxes and this is going to be the transaction detail the transaction detail by date so transaction list by date transaction list by date now you can also open the journal report but we're going to use this one transaction list by date here great report we're going to go from 010122 to 123122 great report to check your numbers let's see if I can customize it I can't bring it up to 12 but maybe like 11 let's try 11 12 might be a little too large for this report and I'm going to try to widen it out a bit so that we can see more of it and so this report you can use to to check your numbers because this is going to give us the detail that we have entered into the system during this time frame so this is a very nice report if you're a supervisor for example and you're trying to see how much someone else entered and in a certain time frame you can filter this report to try to filter by the transactions that someone else might be in charge of for example if you're an instructor or something like that reviewing work great report if you're checking your numbers to our numbers this is of course a great report because you can check out the trial balance if something doesn't tie out then if everything here ties out you would think the the trial balance has to tie out because we started at zero and this is the detail of all the transactions that were input in order to get to the end result this could also be a great report if you wanted to bill a client not based on hours but say if I do so many transactions or within a range of transactions then I'm going to bill you for whatever that range is which can be a little bit more concrete for both you and the billing process and the the customer so you can give you could show them the work you know in that way which is nice so you can go through each of these transactions and if there's something on our side that is not on your side then what you want to do typically is change the date range because oftentimes it's a date issue possibly you're working in the future maybe and you enter the date after after the date range here sometime after this date and therefore there's a date problem most of the time if people are not working in real time the problems with the data input are date problems so if it is a date problem you can expand the date range you can find the one that's out of sync double click on it get back to the source document and then change the date to whatever the date should be if it's a number if it's a miskey or something like that same thing you could double click on the transaction go into it and then adjust the detail within the transaction not necessarily something you want to do in practice unless you're very sure that that's what you want to do because you want to be careful about about adjusting things by by going back into the source form and adjusting it because like a bill might be connected to a pay bill for example so if you were working in transactions in real transactions and and they were linked together usually you want to try to fix things by adding instead of by by deleting but you can delete and change things in QuickBooks so that's something to be aware of so and then you can go through and and check these items off so that's the other major report now the other the other subsidiary reports the main subsidiary reports that we've looked at here with relation to the balance sheet accounts of accounts receivable remember is the reports drop down those are going to be under the customers and receivables like the customer balance summary report which gives us that that amount that adds up to the 20 000 for the three customers for the inventory has a major sub ledger account if you're tracking inventory within the QuickBooks system which can be found in inventory summary valuation report is the major one and so this is weighted on a weighted average method and we can see that if I change the date to 12 3122 that we've got the total of 2008 96 which should match out to the 2008 96 here and the other major sub led this one has a sub ledger report as well but it's often done in tax software breaking out this stuff by by category of property plants and equipment automobile furniture and fixture and the depreciation accounts payable has a sub ledger report the major report vendors let's look at the vendor balance summary all these reports typically have something to do with accounts payable vendor balance summary there's the 15 000 by who we owe it to we need that report in addition to if I double click on this report which only gives us the date of the transaction so for example up here it's a little bit more clear if I double click here I only see the date of the transaction I see the name here but if I had a lot of transactions this would only give it to me by date I want to see it also by customer I want to see this one also by the vendor now the sub ledger reports are usually going to be internal reports so we might not like print those out if we were to give them to someone else for example for month in reporting to say a client but you want to be aware of those kind of sub ledger reports and how they're how they're linked together how QuickBooks will impact the major financial statement reports and then those other reports will be will be related to them and QuickBooks should be able to do the data input or if we do the data input properly it will be able to maintain those major sub ledger reports as we do the data input okay so let's go ahead and think about just printing these out I'm going to imagine a couple ways we can print them I'm going to customize them we could memorize the reports if we so choose we could then print the reports to a printer or save as a pdf or use a pdf printer to save them if we so choose we could email them we can do that by saving as a pdf and then then attaching to an email or you can connect the QuickBooks email account but you got to be careful when you email the reports because you oftentimes want to email a bunch of reports and it can be somewhat tedious if you have a bunch of random attachments the the presentation is half of the battle not that we're fighting anyone but half the half the exercise here is to make something presentable because oftentimes you're trying to have the supervisor or your client be confident that you're doing the work so you know you will be there when they need you at the end of the year oftentimes when they're trying to do taxes we can also export to excel which might not be the format that we present the reports to the customers but that could be a great tool for us to further format if we want to add more formatting and it can also allow us to have the ground baseline for us to add more detailed reports different kinds of reports and we can use excel as well as a cute pdf printer or any pdf printer to try to get multiple reports on one in one area so what we'll do is we'll export all these reports as a pdf and then we'll also export them to excel and try to get them on one pdf to imagine how we might present these to a customer let's customize them first i'm going to customize and i'm going to do some standard customization i would typically go to the header and footer take off the date prepared time prepared report basis possibly put our name in the footer or something like that and then on the fonts and numbers i'm going to i got it at 12 here i'm going to take the parentheses for negative numbers make them red and i'm also that's going to be and then i'll take away the pennies for external reporting i don't really need the pennies i don't believe so i'm going to say okay now you might want to memorize that report memorize in the report here and you could save it to a category i'm not going to get into a lot of detail on the memorized reports we've got other sections to just focus in on memorized reports but you could do that uh in that that way you won't have to save them every time and then i'm going to go ahead and print and i'm going to save it as a pdf save it as a pdf i'm going to put it in the quickbooks i'm going to put it into the quickbooks reports and let's put it right here for now i'm going to call this the balance sheet for uh 12.31.22 for the date so we're going to say okay so there is that and then on the income statement let's take the income statement profit and loss i'll do the same thing report customize header and footer you might change the income statement i'll just change it to income statement just to show that you can do that if you would think that might be something that you want to do could differentiate your reports a little bit and then name in the footer maybe and then fonts and numbers and let's make parentheses let's get rid of the pennies red on the negative numbers so there we have that i'm going to say print and i'm going to say report save as a pdf and i'm going to call this an income statement for 12.31.22 save and then i'll also do the transaction list which you might not give to the customer often this is a more internal report but if you're billing based on this then you might then you might you know give it to the customer as evidence of your building process but we'll say reports print and i'm not print i'm going to save it as a pdf and then i'm going to say this is for the transaction list by date and we'll save that now also note there's many other reports that you could think about doing you you might do a summary balance sheet for example reports company and financial these are variants on the major financial statement reports like a balance sheet summary which basically is going to give you less detail not that less detail let's see 12.31.22 something like that so it's a little bit shorter of a report oftentimes this is a good intro report when we add more data then you also have a bunch of comparative reports that you could put together like a month by month comparison for the balance sheet and the income statement so then you have a bunch of different time frame reports that you could run and we might talk more about that in the future when we do the next couple months but for now this is what we'll have i'm going to go into my reports here so i put them into my reports now we could then there's only three of them so if we gave just three attachments that wouldn't be too bad i can attach them to one email but it's it's still you know we might want to put them in a zipped file so i could say let's say new let's add another file and let's say this is going to be so let's say this is going to be uh 12.31.22 reports reports and let's add those in here and so then i can right click on this and i could compress it i could zip it where's my zipping option where's my zipping option copy path compressed to a zipped file so there it is now your zipped file might look different than this one right but i just have a zipper on it but you can upload this then to to an email which might be a little bit easier it might be a little bit shorter or smaller you can also use a cloud drive like a one drive to give the files as well we can also try to put all the files on one document so and we can use quickbooks to do that we can use excel to do that and quickbooks so this is what the report looks like here let's put it let's try to put it on one document i'm going to close close the tabs this way and to do this i'm going to i'm going to use the exporting feature that's not quickbooks exporting feature let's go to the balance sheet again and now let's export it to excel i'm going to export all of them to excel and then use excel to make one pdf with all the reports along with a free pdf printer i use cute pdf printer to do it i'm not i'm not advertising for them but i think it's a free option so i'm going to say create new worksheet create a new worksheet and you you do need excel in order to do this option and so then i'm going to say i'm going to adjust my options here fonts space between columns colors auto fit so freeze panes i want to get rid of that and show grid lines auto outline auto filtering include quickbooks and i don't want this to show up i'm going to change those two options otherwise i'm going to have an extra tab and it's going to freeze the panes which is kind of annoying and then you got to adjust it so i'm going to say okay and then let's say export send a new so it's going to open up excel make a new worksheet within the new excel workbook there it is i'm just i'm just going to check that it fits on one page wide so it does there's the title and so i'm going to double click and call this the balance sheet and then i'm going to save this file save as i'm going to put this in our our reports desktop quickbooks and reports and i'll put that i'll just put it i'll put it into the reports and this is going to be i'm just going to call it 12 31 22 reports because i'm it's going to i'm going to add the other reports to it as well not just the balance sheet so i'll save it then i'll close it and i'm going to do the same for the profit and loss except that i'm going to add it to that same tab so excel create new worksheet but it's going to go to an existing workbook i'm going to find that workbook and that's going to be under the reports there it is and then i'm going to say export and it should open up the selected workbook add a new worksheet to that workbook so if i maximize this there it is i'm going to click on it drag it to the right i'm going to check the title by going here title looks good fits on one page double click on it i'm going to call this the income statement now if i wanted to print both of these as a pdf i can go to the file tab i can go to the print option and i can use a pdf printer i use the cute pdf printer to do so now note you could adjust the formatting because it's kind of left aligned the way it is so there are there are some pros and cons to use in this format but then i can print the entire workbook and i can export this to a pdf so i have one pdf with everything on it that's the advantage i'm going to close it out and add the one last report transaction list by date and let's go ahead and export this one to excel as well create new worksheet and we're going to put it into an existing workbook should be picking the right one at this point and then i'm going to export it now this one is likely going to be a little bit wide so exporting it to excel can be quite nice because it's a little bit easier possibly to format this to fit on one page one page wide so i'm going to grab it i'm going to drag it to the right and i'm going to say this is transaction detail or something like that i'm going to go to the second tab here it doesn't fit on one page now if it doesn't fit on one page wide that's a problem if it doesn't fit on one page long that's okay generally how do you fix this well i'm going to try to format the cells first if that doesn't work then i'll put it into landscape if that doesn't work and i still need to do something else i can go within the printing options and try to force it to fit on one page using the scaling options fit all columns on one page fit all columns on one page right so but i don't want to do that that's the last resort because it will change the font sizes which i don't really want to do so i'm going to say all right i can i don't really do i really need the date over here i don't think i even need the date and i don't need these skinny columns so i'm going to delete these and see what happens i'm going to say delete put my cursor on b i'm holding down control d e all the skinny columns i don't need i don't think so i'm just going to check all those off and then right click on one of the skinnies and delete them so that looks good that's pretty close i'm probably not going to get down to it being able to fit on one page without going to landscape so i'm going to go to the page layout orientation landscape that's pretty close not quite there yet and then could i make this one a little bit smaller maybe and then i'm going to make this one the memo maybe i don't need the whole wording on the memo make that a little smaller almost there the split there we go so now it fits on one page wide and that looks pretty good so there's the process now the fact that it's landscape not as much of a problem if they open it as a pdf because it still shows vertically but if they print it then you've got that issue where the the thing's going to stick out sideways and you're going to have to say do you want to how you're going to staple the thing in there and whatnot drives you crazy but since everything's digital these days maybe that's not as much of an issue most of the time then i'm going to go to the file time we're going to say print it and i'm going to print the entire workbook using the cute pdf printer which i believe you could find for free if you just search your favorite browser i'm not going to do any other editing let's just keep it basically as is although you could do other editing to it of course as well and it looks good looks like it all fits on one page wide so let's print it which will save it as a pdf and then i'm going to say let's save that that looks good let's put it right there and okay save it so then if i go in actually i put it to the wrong place so i'm going to move it it will i put it here in rock castle and it needs to be over here and get great guitars get it straight man so we'll put it right there okay so then if i if i open up let's make this if i open that up then i can put this one thing as an attachment which could make it look a little bit nicer in some ways right if you had a whole bunch of reports putting them all on one page can kind of be nice so that's what that looks like notice it's a little bit different on the formatting as if you printed them out one at a time out of quickbooks on a pdf which looks like this a little bit more centered you can use excel to further format to whatever format you would like but those are basically your options so we can give this to somebody using a cloud drive and attach these in the cloud drive which means we might still want to put them in order or number them maybe to give them a suggestion on which one they want to open first we might give them the excel file we might attach them to emails one at a time we might give it to them in an email with a zipped drive so they only have one attachment or we might use excel to create one pdf with all the stuff on it so they got one file and then they don't have to organize all the different files and you can sort the reports then top to bottom the ones that you want them to read first or think are most important on top to bottom


Yes, and that was Irelz and Spears. He is not a guest to the show. He's been here before and if you are a fan of this particular show then Bati ume muwana before, he is an Afro dancehall artist who is doing amazing things and we'll get to know him for those who don't know him. Yes, how are you? How are you? I'm fine, how are you? How are you? I'm fine, I'm fine. I'm fine, I'm fine. You look like a very good, like a good a good child. You know, she does any problems and you know, unproblematic. She will be your official prince at any point. I was right. Online? Wow! Get out of here. Morauna shtuka. Adom preset. Morauna shtuka. Adom preset. He's done. He's left the conversation. I'm a maliza. No, I was a good kid.  So, who came here at any point? Tifo, Abadri. Okay. The bad and the good as well. So, who knows to you for being a good child? Nani ni kwa gomo. Nani ni kwa gomo. Nani fanya kwa, I know. He's our boss. You expect her to... You are Rui. Apana kuna... Apana kuna... But you are not. Congratulations. Anyway, that was our question of today. Nani ni nili fanya wu kengia kwa ofisiya printi. Basasahut. Ulingia for the good reason. Ulu konam salimia. Which school are you in? Ni kwa you kanveli kwa tigoni. Really? Okay. We should talk more after this. Anyway. Kindly introduce yourself to the people. Who is Arozen Spears? Arozen Spears is an Afro dance artist from Kenya doing amazing things. We're just getting started. Vibes motomotosiko on the way. Just support the music. Enjoy the vibes and good music. Alright. The last time we met with you was at beautiful people events. Concerts. Yes. And I remember when I introduced you while performing. What has that done for you in your music career? I think it has done for me. I think it's just being put on that same level with somebody like that. It's just a plus. People have seen this kid has this to offer. And it's a long way to go. We're just getting started, but just getting the acknowledgement from somebody like Waere. That's a legend. So it shows if you continue doing good work, good music, things will fall into place. So bija na pali, push, push, push. Or to reach out. Namka fanya song. It was a home haziwezi. So it's a YouTube video. So it's a good song. What is the song you sang when you were in Georgia? Not really. Which is the song you sang when you bring traction to you? I think I cannot pinpoint one song because if you sing a song you can't tell what it is. But if you sing a song you can't tell it is a song. I think I'm a vapefula and I think when I'm singing a song I can relate to it because he's a common condition in releasing a video in Kenya. I'm sure he'll have the same kind of support. So I think even if it's a song it plays a role by the way. Because the song is a good song but try to look and see So, I think that one has shown me one or two things about the industry. Omsani kuna elevi bini gependa, lakini the listeners or the fans, or my DJ, kuna song matapatiya rotation mo. I say to muziki ni imbaya, but nwa jovenya, iksonga kia kakupaliwa kwa dance, fulama kwa club, wato na mufunai. So that's what I'm getting to learn. At the end of the day, it's a learning process, you know, continue growing and improving. What would you say is your biggest strength as an Afrodansal artist? I would say my biggest strength, I think for me because it comes naturally, that's the one I love the most. I'm a more versatile artist. Season, song, tattoos and mefanya, definitely different. I cannot box myself, or I'm only this type of vibe, or my strength is that. I think my strength is just being able to flow into any type of beat. And at the end of the day, being conscious, giving positive music at the end of the day, I think that goes a long way, career-wise. I think that along the journey. What kind of box do you want? What kind of box do you want? I don't know. Let me ask you. That's really important. We have a lot of skills. You've done some other collaborations other than with Wairi. Are you planning to do more collaborations when a single spekiaa kukidogo? At the moment, I think when a good collaboration comes along in the way, I will not dismiss it, but right now I'm just focused on building my brand. Put the name outside there. I have a lot of work to do in terms of putting more content, releasing more videos. So people can get acquainted with who they are, who they are, to show the people to a wide industry. Right now I'm really focused on putting more material out. I have more songs coming out. Consistency is key in any industry. That's true. We have so many talented artists. And the talented ones, they are not consistent. When you own to a wazi, not to imagine to a wazi, but to be consistent. Hard work beats talent any day. So if you have the talent, you may be a footballer, but when it is easy, you may be able to play a game, you may be able to eat. So talent is something I will do and I will work on it. New hard work, consistency, and discipline at the end of the day. Speaking of consistency, you have a new song, Mada Me. I know it's called Mada Me. I know it's called Mada Me. Can you tell us a bit about the song? I have a vibe about it because I think people are expecting if I remember it, something similar. But no, I'm not like that. At the end of the day, I love music, I love the creativity process. I cannot box myself. So let me just give them music. I'm sure we can depend on the vibe and as an artist, the most important thing is keep on content quality music. So Mada Me is really quality. We are not talking about Mada Me. I know it's called Mada Me. Mada Me is a vibe to investigate the vibe of the international. So at the end of the day, we are trying to show people Kenya kuna talent bana. So if you were to do a collaboration right now with an international artist, who would you pick? Right now, you have a chance to and they will do it. I am here. We will do this. I am here. I am here. I am here. I am here. I am here. I am here. We are international artist. Actually, I would not want to do international right now. I really want to do the local. I give you one international one local. So international is easy? That one is easy.  If I can get娼uki on a track Right now flatup boy than business was internationally vibe. Musuki stone stop. so that will be one of them just to put me on that international level so we know Africa PL but we are putting the African brand on so I will go with either Wiscord or Bunnaboy and Kenya wakom ingi ban wakom ingi tago moja? Saii, mii ni chikia watu I think my fibers and baby's are Otile Otile? okay interesting Hanya kwa kimiwa, hanyu kwa hanyu kwa hanyu kwa hanyu kwa hanyu. Kwa hanyu kwa hanyu kwa hanyu, I hanyu inina kما hanyu iiikati. Hanyu kwa hanyu, hanyu hanyu. So I'm just taking a niki dog and then after a few weeks or months we will release another song. So what do you think people find unconditional love? Mombasa raha? Madami? Everything is on YouTube, on Spotify, Tidal and all digital platforms. Streaming platforms will find Arozin Spear, that is A, WRO, WRS. S-P-E-A-R-Z, R-S-N-S-P-E-S with the Z at the end. To kupali YouTube, support, subscribe, just share them. If you love the vibes, share. Alright, so thank you so much for coming in. Any shoutouts? Ya, nipenokom bia, ma fans na washkuru sana, for pushing the music, I appreciate you so much. Ma youth watu anyu na fanyamziki manzei. Don't give up, keep on pushing. It's possible, just see your consistency and quality goes a long way. Ya, alright. So once again, thank you so much for coming through. We appreciate it. Pleasure. Ya, so I hope to see you here some more with more different vibes. Shala. Ya, so up next is Arozin Spear's Madami.


Good morning.  Hi. Good morning and welcome to day two. I just took this little stinky buns on a walk and it's time for his cheese. Doyle gets pills too. Very exciting. That's like the best time of the day.  So he hasn't had one in a really long time. Wow, this is like, wow, okay. So anyways, he gets some pills in the morning and in the night, so good times. But the pills work, so that's all that matters. Oh, wow, wow. So yeah. But anyway, nothing else exciting happened really last night. Talked to my mom for a little bit. She gave me to order her a book on the Amazons. So I did that and caught up a little bit and now I'm just trying to figure out what I want to eat. Maybe I'll eat some oatmeal maybe. It's like, I normally don't eat like a lot of bread but when I have bread, I eat it because you know, it's just me and I don't want it to like get moldy and stuff. I'd rather consume it. That's the point. So yeah, but I think I'm going to, yeah, I'll have, I'll have some oatmeal because, oh wow, I have a bunch of stuff in here. Oh, because I ran that last night. I am going to eat a little bit of oatmeal and make my lunch. And I think I'm going to have another tuna fish sandwich. So I mean, it's like breaking news over here. It seemed to hit the spot yesterday and I'm actually going to have. I brought this yesterday too, but I forgot to tell you guys. But I have some rice, so I'll bring some rice too. I mean, I know that's like super odd lunch, but I'm a super odd person. So I guess it works out. So anyway, I am going to get to my morning, making the things.  Um, I am going to say goodbye for now, but my hair says hello. Look at that. Look at that. That wave. What's going on? Wow. All right. Where's the doile dog? Oh, he, he already went back upstairs. He's like, I don't want any of this. Anyway, okay. I will see you guys in just a moment. Good evening and welcome back to the vlog. I just took poopy little doile out and it's really wet. So I don't know. It's not like storming out, which is good, but it's just like very drizzly, if you will. By the way, today was a really long day at the office. I normally like, so my normal workday is I, you know, get into work. I get into work anywhere from like seven to eight 30. I have a flex schedule, so it doesn't really matter when I come in, unless I have like a meeting. But to be honest, I don't have to go to a lot of meetings, which is like hella awesome. Um, but anyway, so I got in at like seven, 15, seven, 30 or something today and I stayed till six o'clock. Um, I was just trying to get this order out and like, I don't know about you guys, but like I like to finish a project at the end of the day. Like I don't want to come back to it because what I do, well, I guess it's not like complicated. It just like once you're in the zone, you're in the zone and then like once you leave it for a day or a weekend and then you come back, it like takes a lot more brain power to figure out like where you left off. I hope that makes a little bit of sense. So anyways, so yeah, I had just a really long day at the office, but then I have like really short days. So yeah, but I normally get home like it's seven oh six right now and we went on a really short walk. Um, but yeah, normally I get home anywhere from like four to like five thirty is like my normal time. So anyway, that's what's going on here. I did get a shipment from Zulily. I, well, I'll turn my light on over here so you guys can see a little bit better. Um, I finally got, um, I really wanted a comforter, but it's just been so hard to try to find one. Like either I wanted like a gray and white stripe or a like dark charcoal gray and white stripe, but all the charcoal ones that I saw were never white. They said they were white, but they're not. They were like more of a cream and I don't like that. So anyway, I found this one on Zulily and I was like, yes, please, I think this is going to be right. And it's bright white. I'm so excited. Let me turn you guys around and I'll show you. So this is the, it's a quilt, which is still just fine with me. And, um, yeah, I'm really excited. It comes with the two shams. I haven't opened it up yet. I'm going to put this in the laundry in the next couple of days, and then I'll make my bed all fancy. But it's by Levtech's home luxury quilt set. It is a king. And then, you know, I have a king quilt and then the two shams. I don't really know if I'm going to use the shams or not. Um, maybe I will. I have no idea, but, um, I'm really excited about this. As soon as I opened the box, I was like, okay, is it white or is it cream? And it's definitely white, so I'm very excited. So that's the big news here, you know, getting a new quilt finally. It's been a while. I've actually been on the search for about a year and a half now, and I just couldn't find what I wanted. And I don't know. Sometimes it's just hard because you have something in your mind of what you want and the world just does not have it to offer. I have my rice container that is empty because my body ate it all. And then I'm going to put this away. These are from Erin Conron. If you guys are interested, there's a link below. And then I actually have two of them. I have the blue one and then I have the white one as well. So every once in a while, I forget my bag. At the office or somewhere, and I have to, you know, use another one. So I was like, maybe I should get two. So I have two now. I did have the smaller one, but then I ended up giving that away because I found that they don't even have the small ones anymore. They have the ones that are that size, which is a great size because you can fit like, you know, a good size container. I could fit a couple of these in there, no problem. But the smaller ones, oh, they were just, they were too small. Especially if you want to use like glass containers like I like to use. I use mostly glass.  Like it's so hard. But I do have, these are really nice. I don't even remember the brand. I think they're Rubbermaid. I got them from Target. They're really, really good for the like sauces and stuff. So if you have like some salad dressing or like hummus or ranch or something for dipping, this is really good. So I got some of those, but those are plastic. Everything else is pretty much glass for the most part. Don't mind my new cupcake tray over here. I'll be actually be using that in vlogtober. And I will show you guys the cupcakes I'm going to make at some point. It will be fun.  I don't care. I'm going to put a different sweatshirt on that's not wet. That's key. And I am going to also put some sweatpants on because that's just how I roll. This is the Doyle dog. What are you doing? He's so gross. He's got his little bone. He's ready to go. I got my water bill in the mail. So I'm going to pay that. And yeah. Oh my God. Doyle. Two days in a row. You guys. Two, oh my, oh my gosh. Doyle. I'm not going to show you guys because it's absolutely disgusting. Doyle, what do you have to say for yourself? Oh my God. This is a mess. Way worse than yesterday. Doyle, what did you do? What did you do? Are you guilty? Who did that? Who did that over there? Who did that over there? Did you do that? Did you?   I said the magic word. He went running. Nope. He won't come in here. Oh my gosh. Okay. So I'm going to clean again. I think tomorrow I'm going to need to put him in his cage if I can because this is getting a little ridiculous. So yeah, good times. Oh, my pants are still here. They're dry now but it takes me a few minutes. All right, I'm going to, I'll come back in here in just a moment and clean up but I am going to change and I will see you guys in just a little bit. Okay, I've calmed down a bit. I was a little dramatic with the dog earlier. So anyways, I cleaned up as much as I could.  Like I don't, I don't know how he can produce that much poop. He's only so big. But to be fair, I am gone for a long time. And this past weekend, he had diarrhea. So he had like really a funny tummy. So I've been giving him stuff to help with that. But you know, he's older. So it takes a little while longer for those kind of things to like go through his digestive system. So yeah, I was a little like wanting to put up a dog for adoption for just, just a split second, just a split second. And I know a few of you out there would probably take him.  But I'm sure you guys know that. So anyway, I took my makeup off. I put on a sweatshirt that is not soaking wet. And now I'm going to, I don't know, make something for dinner, but I don't know what. And like, it's days like this where it's now like 7.30. It's like, oh, what do I eat? What isn't going to upset my stomach? I don't know. I don't know. Maybe I'll just have like peanut butter and toast or something. And just get all bicec up in there. But I am going to have some water right now. I'll figure out what I'll eat in just a few moments here. But yeah, I just wanted to give you guys a little update of like Doyle isn't going to, you know, sit outside in the rain all night. He's just hanging out, being weird. Okay. Well, I'm going to go for it the second, but I will check in with you guys in a little while. So Doyle is getting some rice. Yeah, you are, bud. He's getting some rice for dinner. He's just kind of finishing up my leftovers. And then I decided to go with some soup. One of my favorite things, which it's like, I don't know, nostalgia childhood, is Campbell's vegetarian vegetable soup. I always loves like the little noodles that have the, you know, the letters on them. Just, I don't know. I like them. I think it's fun. So anyway, I'm going to eat this. Doyle is going to finish his little rice right there. And we're just going to hang out. I'm back on the sofa again. It's like every day is this way. Just to let you guys know, Doyle is right here. Mm-hmm. I started talking and he's opened his eyeball, but when I'm not talking, he doesn't have his eyeball open. So anyway, yeah, so I'm going to cut it short here. This has been like probably really boring vlog, but you know what? You watched it. So anyway, yeah, but I am going to jet. I'm going to go, I think I'm just going to have like an early night because it was a long day at work and I'm really tired and Doyle is clearly tired. He's got his eyes closed again. He's so cute. He's just one of those cute dogs. Good thing you're cute, bud. After all the poop I cleaned up today, good thing he is cute. I don't know what I am. But yeah, so I will see you guys tomorrow for day three. If you liked the video, make sure to give it a thumbs up. Feel free to subscribe. My Instagram is down below. Feel free to follow that because that's where you get like all the real-time updates of all the things, you know. There's lots of Doyle pictures on there too. So feel free to create. So I'm going to head to bed and I will see you guys tomorrow. Bye guys.