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.

  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 (2) at the bottom of the screen. 
      export_budget.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. 
      import_budget.jpg

 

 


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.