Learn how to manage multiple budgets in Acumatica. We take an in-depth look at Acumatica's finance module.
"Acumatica just has a tremendous amount of flexibility when it comes to reporting. In the finance area, you have the ability to manage multiple budgets. So, if you have a revised budget (revised 1234), it's no problem you can get all of those budgets created throughout the year and include those in your financial reporting. So, let's see how you do that.
The first thing that we're going to do is go over to finance,and then we're going to go into the configuration area and I want to go to Ledger's. So, you can see in this company we have an actual and a budget set up and I want to create a revised budget. So, I’ll click on my plus sign and then I'm going to add “REVBUD” my revised budget.
And then I want to confirm that this is a budget set of buckets, rather than actual. We’ll click “Save” now you can see I’ve got my budget and my revised budget. So, rather than entering a revised budget from scratch, I can do a couple of things. I could take my actual ledger (or I could check my previous budget) and, rather than re-entering everything, I'm going to export it to excel. Make the adjustments that I know have happened through the year, and then I'm going to import it. That makes it a lot faster for managing those kind of mass changes.
Let's get our export done! And to accomplish that I'm going to go over to “work area” and then I'm going to go look at my budgets. And I'm going to bring in my original budget. And let's bring that in, we’ll pick 2013 for this example I know it's got a lot of data in it. Once I have this budget in front of me, then it's just as simple as clicking on the Excel button, and it's going to drop it out to an Excel spreadsheet. Where I can make the adjustments that I need quite easily—applying formulas or whatever makes sense.Once that's created, then all I do is just open up that spreadsheet. And in this case, let's change this number here on period two, and let's add in—let's say here another $500,000 onto this line item. So, we'll be looking for that land and buildings and period two to be up a half million dollars, and I'm going to reflect that in my total amount as well. And then all I do is I just save that work. So, I’m going to do a “File Save As”, we’ll call this “New Budget.”
Then the last thing I'm going to do, I’ll close this off, and now I want to get this budget import. And so I'm going to tell it that I want to create this revised budget bucket. The answer is yes. As you can see here it's sitting here without anything in it at all, and then I click on the “Upload”and choose my file. And I want that one that's called the new budget that we just created. Tell it to upload, take the defaults mapping is already established for me, because I started with an extract that always makes it faster for you. You can see up here it's processing through. And there we go, with our brand new budget, with a half million dollars in the landing building.
It's as simple as that! Acumatica just does a great job of letting you have these multiple budgets, and now I can make whatever adjustments I might want to add my financial reporting! And show this year actual to this year current budget, as well as this year revised budget. It’s your choice!"
Sheri Blaho is the Director of Marketing for CS3 Technology. Her education as an accountant combined with her years of system design and programming gives her a unique perspective that is a great advantage for all customers. While primarily focused on HR, Payroll and Time Collection systems, she can answer questions regarding ERP solutions too.