Finances
Owner: Management Last revision: 12.11.2021
This page describes the steps required in order to precisely report financial status internally, to accounting and to clients.
Monthly reporting#
We report unpaid billable hours and outstanding sums to our clients on a monthly basis. Later on, these reports will serve as the basis for invoicing and financial stats.
Use Productive’s time reports to generate a report of billable hours from the previous month.
// image (@TODO)
After finishing monthly reports, notify managing partner to sign-off on reports.
Legacy outstandings spreadsheets
Update the billable hours in the outstandings spreadsheet’s List
sheet, client by client. When updating a row, make sure you assign the values to the correct client/project/item. If not corresponding row exists, create one.
When working in the spreadsheet, make sure you colour code the rows / cells you edited, so other collaborators know which values were edited by which team member.
The Clients
sheet in the outstandings spreadsheet contains the rates, related tasks and instructions for each specific client.
Resources#
- Outstandings spreadsheet ↗
Timeline#
every first Monday of the month
Invoicing#
After getting approval on the monthly reports, invoices shall be created. Some clients need to sign-off on reports before invoicing, while other can be invoiced directly. You can find this information in the Clients
sheet of the outstandings spreadsheet.
We use different invoice templates based on the type of the client:
- Romania-based clients ↗
- EU clients with valid VAT number ↗
- EU clients without valid VAT number ↗
- Non-EU clients ↗
All created invoice shall be uploaded in Google Docs and PDF formats to the _emitted
folder on Google Drive. Upon sending invoice to client, invoice shall be moved to the _sent
folder.
Resources#
- Personalized invoice templates ↗
- VAT number lookup and validation ↗
_emitted
invoices ↗_sent
invoices ↗
Timeline#
every first Tuesday of the month
Accounting#
After invoicing is done, all financial documents for the previous month should be sent to accounting by email.
- Download account statement for previous month from internet banking UI
- upload account statement to Google Drive ↗
- Update incoming invoices spreadsheet based on account statement
- Print master copy of incoming invoices
- Send email to accounting, containing:
- account statement
- outgoing invoices
- incoming invoices
Resources#
Timeline#
first Friday after invoicing
Updating outstandings#
The List
sheet in the outstandings spreadsheet shall be updated every month, by removing the rows corresponding to the invoices that have been paid by clients. If row has been only partially paid, only update the Paid
column.
After updating the List
sheet, make sure you also update the Income
sheets. These sheets are used as a basis for our internal financial reports.
All paid invoices should be moved under the corresponding year subfolder in the Invoices
folder.
Resources#
Timeline#
first Friday after invoicing