Calxa provides the ability to Export and Import budgets from CSV or Excel files. It may make sense to budget in this way if:

  • you already have budgets in Excel. 
  • you have complex formulas or relationships that are best modelled in Excel. 
  • you want to delegate portions of the budget to people who may not have access to Calxa, such as department managers. 
  • you have a large number of business units that are easily summarised into a spreadsheet.
  • you just need to move large amounts of data between budgets.  


To export or import a budget, first open the Budgets & Actuals screen. Click on My Workspace -> Budgets & Actuals.


Open Budgets & Actuals screen to export


Contents


Export Budget


  1. Select the organisation containing the budget you want to export.

    Select organisation to export

  2. Click on the hamburger menu to open the sidebar navigation.

    Open Budgets sidebar navigation

  3. From the BUDGET TOOLS menu select Export Budget.

    Budget Tools - Export Budget

  4. Select the budget version you want to export from the drop-down at top left.

    Select Budget version to export

  5. Note budget exports can include multiple business units and multiple years. In the Export budget window, first select the business unit type you wish to export from the 2nd drop-down. Example of business unit types are project, department, organisation, job/category, tracking category, class/customer/location, etc.

    Select business unit type to export

  6. When you select any business unit type besides organisation, another drop-down menu will appear to the right. Click on this drop-down and select the business units you want to export by ticking the desired checkboxes.

    Business units export selection



  7. Now you will set the Budget type, File format, and Export format. 1. Select the Budget type you want to export (Profit and Loss, Balance Sheet, or All accounts). 2. Choose from Excel or CSV File format. 3. The Export format can be either Monthly or Annual.

    Budget Type, File format, Export format
    Note: Annual budgets will be divided evenly across all monthly periods when imported.



  8. Select the date range you would like to export from the Period range drop-downs.

    With a monthly export format, you can select any range of months you like, you are not restricted to a full financial year. Two examples of acceptable date ranges are shown below.

    Export period range 2 months   
    Export period range 18 months

    With the annual export format, select the year, or years, you want to export.

    Annual export - select years

  9. Toggle on the following Export Settings to enable them as needed. An option is enabled when the toggle is green.

    Export Settings

    1. Export comments enabled - allows you to export any comments you have inserted in your Calxa budgets. These and any new comments you enter while editing your export file can be imported back into Calxa, provided Import comments is selected.

    2. Export empty rows - enabling this option will export all accounts, even those without budget figures. This is what you should select to create a blank template for importing to Calxa.

    3. Export inactive accounts - you can choose to export accounts that are inactive in your accounting system. Note that you can import budgets for inactive accounts as well.


  10. Click on Export Budget to complete the export. The exported file will be sent to your browser downloads.


    When finished click CANCEL to close the Export budget window.



Import Budget


Budgets can be imported to Calxa from Excel and CSV files. If you plan to import your budget you should first export a budget template from Calxa. This will ensure you get the required format for importing.

If you have no budgets created in Calxa yet you can export a blank template in the correct format by selecting the Export empty rows Export settings option. 



  1. Select the organisation where you want to import a budget.

    Select organisation to import to

  2. Click on the hamburger menu to open the sidebar navigation.

    Open Budgets sidebar navigation - import

  3. From the BUDGET TOOLS menu select Import Budget.

    Budget Tools - Import Budget

  4. Click the file folder button to choose your import file.

    Browse for import file

  5. Navigate to the import file you want to import, then select it and click Open.

    Navigate to import file

  6. From the Budget drop-down, select the budget version you want to import into. Select the Sheet name of the workbook containing your import.

    If desired, check the Import comments import setting. Click Import Budget.

    Import budget screen

    Note: Please take care when selecting the budget version above. If you select the wrong version and the relevant financial year(s) is not locked, your import will overwrite the existing budget data in that version.

    *To that end, it is a good policy to lock all budget versions’ financial years where no changes should be made before importing budgets. See the Manage Budget Versions help note for more details.


  7. When the import completes you will see a message telling you the number of rows successfully imported. Click Cancel to close the Import a Budget window.

    Complete Import Budget

  8. For more information on formatting import files and troubleshooting import errors please refer to the Import Budgets - File Formatting and Error Reporting help note.