Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Download budget file as an Excel file #27

Open
sachsk opened this issue Aug 10, 2022 · 1 comment
Open

Download budget file as an Excel file #27

sachsk opened this issue Aug 10, 2022 · 1 comment
Assignees

Comments

@sachsk
Copy link
Contributor

sachsk commented Aug 10, 2022

Requirements:

The budget file will need to be created in excel and available for download.
Should be created in the format similar to the attached file.

Budget Brief Tool 2022-23_Sinnar Mun Council_SS.xlsx

Requirements:

Refer https://docs.google.com/spreadsheets/d/12ysJ1bBzGspfUzHx04MWB7XcblwZGfLFyLZgAm30Q9g/edit#gid=0
3 types of excel downloads options would be

  • Budgeted (Budgeted columns)
  • Estimates (Estimates+ Budgeted columns)
  • Actuals (Actuals+ Revised+ Budgeted columns)
    Refer above link for info on columns to be included in those reports

Tasks:

  1. Support translations
  2. Include Opening balance for all years
  3. Add Municipality information and following heading at the top of the report:
    ${Municipality} Budget Estimate of the Receipts and Payments for the financial year 2022-23
    (Form No. 84) (See Rule No. 406)
  4. Include data rows (Entries and totals)
  5. Introduce Download Button as a drop-down to select type of excel report for the year and download the file
  6. Generate Report for different AmountTypes
@himeshr himeshr changed the title Download budget as pdf Download budget file as an Excel file Aug 12, 2022
@sachsk sachsk self-assigned this Aug 12, 2022
@sachsk
Copy link
Contributor Author

sachsk commented Aug 12, 2022

library https://www.npmjs.com/package/xlsx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Deployed to QA
Development

No branches or pull requests

1 participant