Home Budget Writeback: create your budget in Excel, upload it back to Acumatica or MYOB Advanced in one click!

Budget Writeback: create your budget in Excel, upload it back to Acumatica or MYOB Advanced in one click!

Excel
Tips & Tricks
22.01.2019
10 min

This is the 4th instalment of our articles explaining what lies ahead for Velixo. We finished the year with a look back at 2018 for Velixo and our popular Acumatica / MYOB Advanced financial and project reporting tool, and continued with detailed articles on new features in our upcoming release, Velixo Reports 4.0:

Today, I’d like to introduce another major enhancement in our product, Budget Writeback. Just like everything else in the product, Budget Writeback was built from the ground up with Acumatica and MYOB Advanced users in mind.

With Velixo Reports 4.0 and Budget Writeback, you can:

Budgets in Acumatica and MYOB Advanced are managed using , and the system allows you to create as many ledgers (or versions of a budget) as you need. After the release of the budget, the budget amounts are available for reports and for comparison with actual figures or other budgets, whether it’s from Excel or from your ERP.

How to use the new Budget Writeback feature

Easy! From any spreadsheet, first, start by creating a blank budget entry worksheet. We take care of that process for you when you click on Budget Writeback -> New Budget Worksheet

Budget Writeback Menu

The Budget Writeback menu allows you to create a new worksheet with all the fields you need.

You will be asked to select the connection (tenant) and the financial year for which you want to create a budget worksheet:

New Budget Worksheet

We need this information to determine the number of financial periods (and columns) needed for your budget. What you will then see is a spreadsheet that looks (a lot) like the Budget entry screen in Acumatica and MYOB Advanced:

A Blank Budget Worksheet

As you may have guessed, all you have to do at this point is fill in the blanks and enter your budget. Here’s a description of all the different settings:

An Excel workbook can contain multiple budget worksheets, so if you have multiple tenants, business units or budgets versions, you’ll likely want to have different tabs with different names.

Your budget can leverage the such as , and . You can even use , or any of the standard Excel functions.

Putting it all together

Here’s a completed, albeit quite simple, example:

A few columns and formulas were added to this budget:

Finally, a chart that shows us the forecasted revenue and gross margin was added at the bottom of the sheet.

To import the budget, click on “Import Budget Worksheet” in the Excel toolbar. If you only want to import specific rows, select them and use the “Import Budget Worksheet (Selected Rows Only)” option.

Upgrading

Existing customers will get an upgrade notification when they open Excel. The roll-out will start at the end of January. If you’re not a Velixo Reports Pro user and would like to buy a license, please contact your partner or visit our web site at for more information.


Sign up for a Velixo Reports webinar — be happy

If is important to your organization, then the choice is obvious: Velixo is the only reporting-tool of its kind designed for Acumatica, by Acumatica experts. You can be up and running within a few minutes.

Visit our web site at to learn more about Velixo Reports or sign up for one of our upcoming webinars and see why so many Acumatica customers trust Velixo for all their financial and project reporting needs.

Velixo Newsletter

Subscribe to our newsletter to receive news and announcements.