<aside> <img src="/icons/help-alternate_gray.svg" alt="/icons/help-alternate_gray.svg" width="40px" /> Contact us at [email protected] if you need help setting up your databases.
</aside>
Pop Invoice integrates with your existing Notion setup, allowing you to manage invoices without disrupting your current workflows.
If you don’t have any databases set up yet, don’t worry—you can get started quickly with one of the templates specifically created to work with Pop Invoice. Get get them here.
To use your own databases with Pop Invoice, you'll need:
Once these databases are set up, use the centralised settings page in Pop Invoice to link them and specify the relevant properties.
The diagram below illustrates how these databases relate to each other
Below are the minimum requirements your databases must meet for Pop Invoice to function correctly👇
| Column Type | Description | Required |
|---|---|---|
| Status or Single Select | The status used by Pop Invoice to track and update the invoice throughout it’s lifecycle. |
Recommended options:
Ready - to tell Pop Invoice the invoice is ready to be created. Created - automatically set to this status when the PDF is created. Sent - automatically set to this status if you email the invoice from Pop Invoice. Paid - automatically set to this status if you mark the invoice as paid in Pop Invoice
*they can be called anything as you will define the names in the centralised settings page | Yes | | Relation to Client database | Relation to the client for this invoice, so you can select who the invoice is for.
*Make sure the “Show on…” option is turned on in the relation property set-up | Yes | | A formula or number | The total amount the 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. | Recommended | | Relation to Line Items database | If your invoices typically have more than 1 item you should use a Line Items database - this property is a relation to that database
*Make sure the “Show on…” option is turned on in the relation | Optional |
| Column Type | Description | Required |
|---|---|---|
| Text or Formula | The client’s address used 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 | Client’s email - used if you want to send the invoice from within Pop Invoice. | Recommended | | Text or Formula | Customer name - used in the invoice template and when you email the invoice directly from Pop Invoice | Recommended | | Relation to Invoice database | This will automatically appear when you relate to this database from the invoice database | Yes |