 0 Accounting Software 2023 Budgeted Income Statement Data Input Get ready to become an Accounting Hero with 0 2023 Here we are in our custom 0 home page going into the company file We set up in a prior presentation that's Get Great Guitars We're going to duplicate the tabs to put the reports in like we do every time Right-click in the tab up top so we can duplicate it Back to the tab to the middle Accounting drop-down, opening the balance sheet This is a comparative balance sheet if you don't have it Open the standard one Tab into the right, accounting to the drop-down Income to the statement This is a comparative income statement If you don't have it, you can open the standard one there as well In prior presentation We have downloaded information from 0 Basically a trial balance that we can then format into an income statement And then create a budgeted projective income statement in Excel Which we have done here Now what we would like to do is take that budgeted income statement And put it back into 0 using the budgeting tool Which is different than the normal data input process Because of course we're projecting out into the future The reason we want to do that Is because we want to be able to run reports within 0 That can do comparative reports So as time passes, say we budgeted in the past And we budgeted for January and February I can then run reports to compare what we thought was going to happen To what actually happened as time passes That's one of the great tools to have 0 To have to put it back into 0 So that we can have that information Now we have inputted into the 0 system Two months of data input for actual data input For January and February We used that as the baseline to then create our budget And we kind of imagined that this is information from the prior two months December and November of the prior year So that we can budget out project starting in January So the reason we want to do that Is now that I have January and February I'm going to put that into the system as well as all 12 months And we'll be able to run reports Which will show the actual and budget for January and February And then everything going forward from that We don't have any actual data to But in practice of course as time passes We can compare what actually happens to the budget Alright let's go to the first tab And see where the data input for the budget is It's under the accounting dropdown We go into the reports And then we're going to go on down Move on down to the budget manager The budget manager Now you could have multiple budgets if you wanted to This is the overall budget kind of the default budget You can add a new budget If you so choose and simply name the budget here We're just going to use the overall budget And we're going to start it on January So you could have different start dates If you wanted to The common budget is to project out on a 12 month basis But you can do different variations as you choose And then we've got the actuals So this is showing the actual numbers down here Which could be useful if you were trying to construct your budget Within zero But that's not what we recommend doing really And that's not what we did here What we did is we exported to Excel to construct the budget And now I just want to do the data input So what I would like to see is no actuals I'm going to say none And update So now we just have our data input fields down below And then the periods We could have 3 months, 6 months, 12 months, 24 months We're going to add a year's worth of budget So we're going to go for 12 months out And there's our budget information Now zero has a nice tool down here That we could import the budget So if I look at the import option Note that I could download the template here And say give me the template in Excel or CSV file And we could open this and populate it Now you could try to use this template As your budgeting tool Instead of building it like we did here But it would still be a little bit difficult to do Because you'd probably start off with your past data But also it might be a little bit faster If I was to take my data here And just copy and paste it into the template And then import the template So that's just a method that you might want to keep in mind We're not going to do it that way here Because I want to see how to actually put the data input into zero Without the template But that could be a useful tool to save some time So I'm going to go back on over I'm going to go back to the budget manager here And do the data input Down here we've got the import We've got the exporting, saving, and the cancel This is in like the non-wide screen It might be easiest if we go to widescreen Once you're ready to do the data input And that gives you just a little bit more space here So that you can see a little bit further out to the right It kind of locks in the screen Alright so let's just try to do this one line at a time It's a lot easier if you had Like two screens that you could use But we'll work with what we've got here So we've got the sales number Now we've got the account number over here That could be a little bit useful Sales number 29226 So I'm going to say alright Sales 29226 29226 That's account 4350 Now I want to count Hold on a second Make this whole thing green I want to count 4,000 4,000 Yeah 4226 Now if I hit this green button In the middle It gives me my compounding options So I can apply a fixed amount to each month If I want to just copy it across I can adjust by an amount each month Or I can adjust by percentage each month So what I want to do is adjust by that percentage Because that's what we did here We've increased it by 10% So 110% So I'm going to say adjust by percent each month And I'm going to say And I'm not sure if I put 110 or just 10% I'm going to say 10% And see what it does I'm going to say copy it across And so the next month should be 32149 Boom, looks good The total comes out to 624982 So 624982 624996 Slightly different What happened? Well maybe it's just a rounding difference It looks immaterial Let's keep it rolling I think that's good So we'll go to the next one Service Let's go and highlight this one This is account 4300 4250 So 4300 Back to January Data input 4250 Alright And then This one We increased by just a solid amount of $1,000 So I'm just going to say Let's go to the arrow And I want to adjust by an amount of just $1,000 Bring it up by $1,000 Each time period And apply it out So boom And that comes out to a total of 117000 117000 Let's see if that Is what we have here Yeah, looks good Moving B to the end Next one Alter of A We're going to say this one Goes up by 5% Rental income Account 4350 1130 Rental income Hold on A second Wait a second I put this one in the wrong box I knew it I knew I did something funny There It should that should be the service Item The whole thing The whole thing is messed up No, it's not stay calm Stay calm What I'll do is I'll put this one here 4250 And then That 4250 Was increased by the 1,000 Okay, I see what I did I see what I did So I'll put the 1,000 here And then Apply So I fixed it to this one And then this one