PSA L&P - Budgets: How to create next year's budget using the export/import method

How to create next year's budget using the export/import method 

Go into Ledger & Payables → Process → Budget Entry → .... Budget (where ... stands for either Current, Next Year or Next Year +1)   The example here will show Next Year's Budget but they all work essentially the same. 

If you export from the Next Year Budget option, make sure you only update the excel file with Next Year Budget figures. When you import from this spreadsheet, it will import to the Next Year Budget. The same logic applies to the other two budget years. See information on the exception here.


  1. Export the full budget or only a portion of the budget using filters.
    • Once you have selected which accounts you want to export, click the Export button at the bottom of the screen.
      budget_filetr.jpg
  2. Update the numbers in the spreadsheet. You may not edit or remove any gray lines from an exported Budget Spreadsheet. You must leave all gray cells alone. If you change the gray cells, the Budget will not import.
  3. Import the Budget: Process → Import Processes → Import Budget
    • Before importing you must file your Budget Workbook as an xlsx Workbook.
    • Importing the budget will overwrite all existing values for all accounts listed on the spreadsheet for the budget year you originally exported.
    • If you are in the 2018-2019 year and export the Next Year budget, 2019-2020, then run End of Year it will update the Current Year Budget because that is now the 2019-2020 year. Click here for a visual.
      import_budget.jpg

 

How closing the year affects the import of the budget you exported beforehand

 

Calendar Year: 2019; Accounting Year 2018
 
Current Year Budget:   2018-2019
 
Next Year Budget:       2019 - 2020   Action: Export this Budget
 
Next Year Budget + 1: 2020 - 2021
 
Action: Close Year
Calendar Year: 2019; Accounting Year 2019
 
Current Year Budget:   2019-2020   ActionImport Budget it will overwrite this one
 
Next Year Budget:      2020 - 2021
 
Next Year Budget + 1: 2021 - 2022

 

 


Related Articles

Budget: About Budget Entry (FAQ)

Budget Entry: (Part I) Enter, Export & Import (Videos) 

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.