All Collections
Getting Started
QuickBooks Online
Configuring QuickBooks Automations
Configuring QuickBooks Automations

How to configure ProRata to pull in your transactions from QuickBooks for revenue recognition and deferred revenue calculations

Rob Farmer avatar
Written by Rob Farmer
Updated over a week ago

First navigate to the Settings area by clicking on your company name in the upper right, then select Settings.

In the gray navigation area on the left, choose QuickBooks Automations.

Invoices

Automation Preference

  • Disabled - ProRata will not pull over invoices from QuickBooks

  • Semi-automated - ProRata will periodically check for new invoices in QuickBooks but subscriptions and revenue will have to be imported manually in ProRata.

  • Automated - ProRata will periodically check for new invoices and when possible, import subscriptions and revenue into ProRata.

Date Preference

ProRata will try to determine the start date of the subscription using various fields from QuickBooks.

  • Manual - You will need to manually enter the start and end dates in ProRata.

  • Service date then invoice date - ProRata will look for the Service Date and use it for the start date. If the service date is not present, ProRata will use the invoice date.

  • Service date then due date - ProRata will look for the Service Date and use it for the start date. If the service date is not present, ProRata will use the due date.

  • Invoice date - Always use the invoice date

  • Due date - Always use the due date

  • First of next month - It will always use the first of the month following the invoice date.

  • Parse description - ProRata will look at each line item for dates in the format of: (m/d/yyyy , d/m/yyy , m-d-yyyy , d-m-yyyy or 1-Jan-2017) . The first date found will be the start date and the second will be the end date.

Sales Receipts

Automation Preference

  • Disabled - ProRata will not pull over invoices from QuickBooks

  • Semi-automated - ProRata will periodically check for new sales receipts in QuickBooks but subscriptions and revenue will have to be imported manually in ProRata.

  • Automated - ProRata will periodically check for new sales receipts and when possible, import subscriptions and revenue into ProRata.

Date Preference

ProRata will try to determine the start date of the subscription using various fields from QuickBooks.

  • Manual - You will need to manually enter the start and end dates in ProRata.

  • Service date then sales receipt date - ProRata will look for the Service Date and use it for the start date. If the service date is not present, ProRata will use the sales receipt date.

  • Sales receipt date - ProRata will always use the sales receipt date.

Credit Memos & Refund Receipts

Automation Preference

  • Disabled - ProRata will not pull over invoices from QuickBooks

  • Semi-automated - ProRata will periodically check for new adjustments in QuickBooks but adjustments must be applied manually.

  • Automated - ProRata will periodically check for new adjustments and when possible apply them automatically.

Application Period

Adjustments must be applied over a period of time to an existing subscription.

  • Match subscription period - The adjustment will be applied over the same period as the subscription.

  • Service date through period end - The adjustment will be applied starting on the service date and through the end of the period for the chosen subscription.

Default Type

There are two types of adjustments: adjustments and churn. Churn should be selected if a customer cancelled the subscription and you would like to mark that subscription as churned.

Churn Date

Default date to use for churned subscriptions.

  • Service date then transaction date - ProRata will look for the Service Date and use it for the start date. If the service date is not present, ProRata will use the transaction date.

  • Transaction date - ProRata will always use the transaction date.

Additional Options

Automatically skip transactions on or before

If set, ProRata will "Skip" any transaction with a date on or prior to the selected date.
โ€‹

Click Save when your done!

Did this answer your question?