# Transparent Budget

## Inside the platform

Collectives have transparent budgets, where all transactions are automatically reported. Everyone can see where money comes from and what it's spent on.

![](https://2682340432-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LnScH_KG1YJixOv0LJB%2F-LrtZDhGbYm2tRxhPmkZ%2F-LrtZFvZc1aOelbmGDOC%2Fscreen-shot-2019-02-04-at-8.58.35-pm.png?generation=1571850103453708\&alt=media)

Private information is hidden. For example, email addresses and attachments (which may contain personal information).

The expenses view shows what the Collective has spent money on. You can see individual expenses and the top categories and people the budget has gone toward.

![](https://2682340432-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LnScH_KG1YJixOv0LJB%2F-LrtZDhGbYm2tRxhPmkZ%2F-LrtZFvaJUfJ_4BMWaNE%2Fscreen-shot-2019-02-04-at-9.01.36-pm.png?generation=1571850104005562\&alt=media)

The transactions view shows the budget lines, and you can filter by credits and debits, or export via CSV.

![](https://2682340432-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LnScH_KG1YJixOv0LJB%2F-LrtZDhGbYm2tRxhPmkZ%2F-LrtZFvca7AbrdYTsMZV%2Fscreen-shot-2019-02-04-at-9.03.41-pm.png?generation=1571850103157036\&alt=media)

## Migrating your transactions to a spreadsheet

## Step 1

### Download CSV

Download CSV file from /transactions page inside your collective.

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565897884171_Annotation+on+2019-08-15+at+14-37-36.png)

## Step 2

### Copy the template

Copy the transactions template into your Google Drive

{% hint style="info" %}
### [Click here to copy the template](https://docs.google.com/spreadsheets/u/2/d/1vyR75xft45EBhQ2zKJD3JSsn59eaKjrL0soRNt5t724/copy)
{% endhint %}

## Step 3

### Go to RAW FILE tab

Open the “RAW FILE” tab inside the file.

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565898315516_Screen+Shot+2019-08-15+at+14.45.05.png)

### Import CSV

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565898598555_Screen+Shot+2019-08-15+at+14.49.48.png)

**Make sure to check these settings are applied:**

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565983068990_Schermata+2019-08-16+alle+14.16.44.png)

You will see something like this: _\*\*_&#x4E;ow, you will have to do some tweaks to the data before we can use it…

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565983259029_Schermata+2019-08-16+alle+14.20.15.png)

## Step 4

### Change all points for commas

1. Click Cmd+F
2. Select only the numeric values (From column G to K)
3.  Click on the three dots on the “Find in sheet” instance

    This will open the “Find and replace window”, type a point (.) in “Find” and a comma (,) in replace with, mark the “Match case” option, then click “Replace all”

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566005487950_Screen+Shot+2019-08-16+at+20.31.16.png)

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1565986227896_Screen+Shot+2019-08-16+at+15.09.04.png)

### Change format

To change number formatting to US Dollars. Go to menu item “Format” → “Number” → “US Dollar”.

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566165541960_Screen+Shot+2019-08-18+at+16.58.55.png)

### Sort by oldest to newest

Since the dates of the file run from newest to oldest, it’s better to invert that order, thus being able to add new entries without the need of adding new rows.To do that, first select column “D” (This is where the date data is listed)Then go to menu item “Data” → “Sort sheet by column D, A → Z”

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566165987231_Screen+Shot+2019-08-18+at+17.06.17.png)

## Step 5

### Copy and paste values in the template

Select all values except the With cell A6 selected:Right click → “Paste special” → “Paste values only”\
**Voilà!**&#x59;ou will have your totals for expenses and contributions into a nice and visible balance chart. Plus individual transactions sorted by date and differentiated by color codes.

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566167201844_Screen+Shot+2019-08-18+at+17.26.30.png)

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566166280964_Schermata+2019-08-18+alle+17.09.39.png)

## Personalization and publishing (Extra step)

You can personalize the collective banner by using the function “Insert” → “Image” → “Image in cell”. We are using a PNG of 1920x400. We recommend changing the color of that specific cell to match the collective banner background.

### Publishing

If you go under “File” → “Publish to the web” it will pop out a settings window for this to happen.You decide if you just only publish the URL to access and read(only) the file or embed it.

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566168125167_Screen+Shot+2019-08-18+at+17.41.59.png)

![](https://paper-attachments.dropbox.com/s_D19E76E8026880734906183F5F67A13D8F5770AC8212DCC2B79CE9738C72C087_1566168397413_Screen+Shot+2019-08-18+at+17.46.27.png)
