brouberol/grand-cedre

This project implements tools used in the administration of Le Grand Cèdre, a flexible working space welcoming alternative medicine practitioners, in the form of a web interface.

It allows to register clients base, import booking information from Google Calendars, define pricings, edit contracts, track expenses, generate invoices, monthly, quarterly and yearly balance sheets, upload documents to Google Drive, etc.

It was not designed as a generic tool, but rather an implementation of specific needs. The code was nevertheless made open-source for the sake of transparency.

Operations

Import pricings

When the app is running for the first time, run the following command to import the different pricings in database:

% flask import-fixtures

Import bookings

The bookings can regularly be imported from Google Calendar in an idempotent way by running

% flask import-bookings

Generate invoices

Invoices for the previous month (by default, which can be override with the --year and --month arguments) can be generated and uploaded to Google Drive by running

% flask generate-invoices

If the --no-commit flag is provided, the calendar events will be imported but nothing will be committed to the database. If the --no-upload flag is passed, the invoices will not be uploaded to Google Drive.

Create a balance sheet

A balance sheet (CSV file listing all paid invoices for the given period and all expenses) for the previous month (by default, which can be override with the --year and --month arguments) can be generated and uploaded to Google Drive by running

% flask create-balance-sheet

If the --no-upload flag is passed, the balance sheet will not be uploaded to Google Drive.

grand-cedre's Issues

Automatically generate the financial balance sheet for month m-1 at the start of month m

Daily booking duration is currently computed as a float

Use a decimal with at most 2 sub 0 digits instead to avoid nonsensical values being displayed.

Maybe humanize the display in the admin?

Detect and bill inactive clients

Detect that all active clients with modular indiviual contracts are present at least 1h / week. At the end of the month, if total booking time < 4h -> 4h will be billed. Mention it on the invoice.

Add documentation, comments, tests

That was developed in a rush and by one person, and it shows.

Charge clients inscription fees after a 3 month of trial period

Generate invoices for the previous month by default

As the invoice generation will be done on the first day of month n+1 for invoices for month n, we need that behaviour to be the default of the CLI.

Add an authentication layer

Right now, we have basic Auth setup at the reverse proxy level. We could use a login system with rbac, but this is very low prio for now, as this is currently used by one person.

Parse client's email in the booking description

If a Google calendar event has been created by the owner and an email address was added to the description, it means that the real beneficiary is the client with that email address and not the owner. The bill should be adressed to that client.

Recurring contracts should have a weekly hours, not monthly

There was a misunderstanding about recurring contracts: a client should sign up for a number of hours / week, which then gives a fixed rate.

We currently have a monthly number of hours bu the pricing was designed for weekly hours.

Harmonize __repr__ ouput across models

The debug representation of objects is heterogeneous, which makes debugging harder than it should,

Upload invoices to cold storage

Once the invoices are generated, we should upload them to some cloud storage service. As we already use Google agenda to store the booking information in the first place, to have the whole machinery (modulo the oauth token with the appropriate scope) to upload these to Google drive. The invoices are tiny anyway, and that would be convenient to retrieve.

Alert when a client is close to 0 remaining hours

Handle flat rate conracts at lower price

When a client has remaining hours at the end of the flat rate conract, a new contract can be created, valid for 6 months, with the remaining hours at a lower price

Track down invoices payments

Include a payment number (wire transfer reference / check number) and a payment date, so we can track down late payments and include/exclude invoices in monthly/quarterly reports.

Generate financial reports

Gather all paid invoices for a given period and generate an income report for that period.

Make period bounds part of the form to make it easy to generate custom reports?

Find out what format that report should have. Maybe a simple csv could do?

Allow owner to submit expenses

Track expenses:

• date
• price
• currency (?)
• label
• recurring T/F (if possible)

Export expenses in balance sheet

Generate contracts from the web UI

Client contracts could be generated from the interface, the same way we generate balance sheets or invoices.