<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 Pop 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 Pop 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 Pop 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 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 Pop Invoice. | Yes | | Text or Formula | Customer name Use in the email body when you email the invoice directly from Pop 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 | Pop 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 Pop Invoice.

Once created in Pop 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 Pop 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