<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/85fcda2e-a8ec-4620-a4d4-778db95ea0e7/home-icon-silhouette.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/85fcda2e-a8ec-4620-a4d4-778db95ea0e7/home-icon-silhouette.png" width="40px" /> Help homepage

</aside>

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/3f00873c-6864-4825-80c9-928d7fd0775d/right-arrow.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/3f00873c-6864-4825-80c9-928d7fd0775d/right-arrow.png" width="40px" /> You can use Notion Invoice with your own Notion databases.

3 databases are required for it to work, follow the guide below and then re-run the setup in Notion Invoice to point to your databases. Re run the set up in Settings

</aside>

Databases needed in your Notion workspace:

  1. A database of client information including invoice address, email and customer name.
  2. An invoice database containing all invoices, one invoice per row
  3. A line items database containing line items for all invoices, one row per line items.

flow chart.png

1. Client Information Database

Contains client information that will be used on the invoice and to email the invoice from Notion Invoice. Each invoice is related to a line in this database.

The properties do not have to have a specific names as you will select them in the set up process.

Column Type Description Required
Text or Formula The name and address that will show up on the PDF invoice. Format it how you wish it to appear on the invoice.

Example format with a new line for each element:

SH Education Ltd The House 1 Church Street London | Yes | | Email | The default email used when emailing the PDF invoice from Notion Invoice. | Yes | | Text or Formula | Customer name Use in the email body when you email the invoice directly from Notion Invoice | Optional |

Invoices database

Contains all invoices, one invoice per row.

The database needs to be related to the client database and the line item database.

Column name Column Type Description Required
Doesn’t require a specific name Relation to Invoice Items database This links to the line items database, there can be one or more lines related per invoice.

*Make sure the “Show on…” option is turned on when you set up the relation | Yes | | Doesn’t require a specific name | Relation to Clients database | This is a relation to the client for this invoice.

*Make sure the “Show on…” option is turned on when you set up the relation see image below for correct set-up | Yes | | Status | Single select with the following options:

Ready Created Sent Paid | Notion Invoice uses this to determine which invoices are ready to be created

Set this to Ready when the you're ready to create the PDF invoice in Notion Invoice.

Once created in Notion Invoice this field will automatically be set to Created.

All other values will be ignored, so you can add additional options | Yes, the property title has to be ‘Status’ | | Total | Number, Formula or Roll up | This is the invoice’s total that your client has to pay.

In the Notion Invoice starter template this property is a formula that gets the line items totals and adds on the tax. | Yes, the property title has to be ‘Total’ |

*Correct set-up for client relation property. Make sure the “Show on…” option is turned on

Untitled

Invoice Items database

Contains the line items that go into an invoice, one line item per row