Tracking revenue is critical for all businesses, but this can be a challenging task when you have different subscription periods and billing cycles for your customers.

This article will help you track your pending, paid, and overdue Invoices in Planhat.

Like other data models, you can view Invoice data in the Data Explorer or in a Page (e.g. a Data Table Page) - examples of each shown below. You can manually create Invoices in both these places - just click the "+ Invoice" button.

Click the images to view them enlarged

If you'd like to view the Invoices associated with a particular Company, you can view them in the "Revenue" tab of a Company Full-Page Profile - specifically, in the "Invoice" tab within "Revenue". You can click "+ Invoice" here as well, if you'd like to manually create an Invoice.

It's also possible to have Planhat automatically create Invoices for you, rather than creating them yourself manually. To do this, set a License (which you can find in the same places as described above for Invoices, except Licenses have their own tab within Revenue in a Profile) so that its "Invoice Cycle" (a default/system/standard field) has a value such as "Monthly" - then Invoices will be created as appropriate.

Status

"Status" is a system (standard/default) field on the Invoice model. By default, this is set to "Pending". When you click an Invoice to edit it, you can mark it as Paid. If the due date has passed and the Invoice has not been marked as Paid, the Status will change to "Overdue".

In addition, when editing an Invoice you can add or remove Line Items. If you have any Sales (non-recurring revenue items) you can add them to an existing Invoice.

The screenshot below shows an example of an Invoice Preview, with both Status and Line Items visible.

Payment Terms

When creating an Invoice, the due date will be determined by your payment terms (default = 30 days). This can be changed in the "Settings" Global Tool, in the "Revenue Setup" section.

Click the image to view it enlarged

Custom Fields

Just like our other models, you can use custom fields, which allows you to add custom data to your Invoices. For example, you could add a checkbox to keep track of Invoices you've already sent, or you can add notes for your Finance team.

Fields are managed in the "Data" Global Tool.

In addition to all the standard Page types, there is a pre-configured "System Report" Page for Invoices. You can read about this in our separate article here.

Click the image to view it enlarged

You can create Automations in the App Center. There are a number of Automation Templates related to Invoices, as shown in the screenshot below.

Click the image to view it enlarged

If you integrate Planhat with another CRM (HubSpot or Salesforce, etc.) then Planhat can generate Invoices for any recurring Licenses you sync to Planhat. In order to do this, we just need to know the Invoice Cycle for the License (like we discussed above), so make sure you include this field within your field mapping in the integration.