The financial statements PDF works well for tabling a document at the assembly. It works much less well when your accountant wants to pick the figures back up. The Finances page now offers a second button, "Export Excel", beside the one that already produces the PDF.
Ten sheets, one per statement
The workbook takes the fiscal year you selected and lays it out across ten sheets:
- Metadata: the syndicate, the fiscal year and the period dates;
- Income statement;
- Balance sheet;
- Fund balances;
- Budget vs actual;
- Reserve fund;
- PCUR breakdown;
- Accounts receivable;
- Accounts payable;
- Set-offs.
Every amount lands in a numeric cell, not in a picture or a table rebuilt by hand. Formulas, sorting and pivot tables work the moment the file opens.
In the language of whoever exports it
Sheet names and column headers follow your interface language. A French-speaking board gets « État des résultats » and « Comptes fournisseurs »; an accountant working in English gets "Income statement" and "Accounts payable". The downloaded file is named to match.
What the export is, and what it is not
The workbook faithfully reproduces what your accounting register holds on the day you export it. It has been through no compilation, review or audit engagement by a chartered professional accountant. Where your declaration of co-ownership or a resolution of the assembly calls for such an engagement, this export feeds the CPA's work rather than replacing it.