Create a recurring AP supplier invoice

Automate your billing process with recurring AP supplier invoices. For example, if you pay the same AP supplier invoice regularly, such as a monthly rent AP supplier invoice—you can save time by having Sage Intacct create the AP supplier invoice automatically for you.

Intacct respects non-standard recurring transaction schedules and automatically enters and posts AP supplier invoices on the schedule you define. The transaction and GL posting date for an automatically generated AP supplier invoice are the same, but you can change either.

Recurring AP supplier invoices don't support custom fields, or custom fields defined in an AP supplier invoice. If you need to use a custom field in a recurring AP supplier invoice, configure the custom field as not required. For details about creating custom fields, see Define custom fields for business-specific data.

Looking to simplify AP supplier invoice entry? Let AP Automation handle it for you by creating AP supplier invoices from vendor documents via email or uploads. Discover more about how AP supplier invoice automation can streamline your process.

Enter header information

  1. Go to Accounts Payable > All > AP supplier invoices and select Add (circle) next to Recurring AP supplier invoices.

    Or, update an existing AP supplier invoice and make it recur:

    1. Go to Accounts Payable > All > AP supplier invoices.

    2. Find the AP supplier invoice you want to make recurring.

    3. Select More actionsEdit at the end of the row.

    4. From the More actions dropdown list, select Create recurring transaction.

    1. Go to Accounts Payable > All > AP supplier invoices.

    2. Select Edit next to the AP supplier invoice.

    3. From the More actions dropdown list, select Create recurring transaction.

    Is your organization set up with multiple base currencies? If so, you need to create recurring AP supplier invoices at the entity level.
  2. Select a Supplier.
  3. The Pay to and Return to fields default from the supplier record.

    Did you enter a different pay-to contact on the AP supplier invoice than what’s associated with the supplier record? Learn how to print that pay-to contact on the cheque.

  4. If Accounts Payable is configured to require AP supplier invoice numbers, enter a AP supplier invoice sequence number.

    Each recurrence of the AP supplier invoice automatically receives an incremented number from the defined sequence type. This number prints on the remittance stub, not on the cheque itself.

  5. Enter a Reference number.

    This is a number such as a purchase order or account number that might be useful in searches or reports on this AP supplier invoice. This number shows on the GL Details report and prints on the cheque and supplier stubs.

  6. Enter a Description.
  7. If the AP supplier invoice is a result of an ongoing contract, enter a Contract ID and a Contract description.
  8. Select a Term.

    If a default term was added to the supplier record, this field is automatically filled in.

  9. Enter an Attachment.
  10. For multi-currency companies, enter currency and exchange rate information in the Currency section.
    1. Select the Transaction currency to use.

      If this is not your company's base currency, continue with the next steps.

    2. Select an Exchange rate type such as Intacct daily rate or WSJ Published Rate.

      If you know the exchange rate for this transaction, or are contracted with the supplier on a set exchange rate, enter it in the Exchange rate field.

    3. Enter or select a date in Exchange rate date.

      The default is the current date, but you can override this. For example, you might want to change it to the date the transaction was issued, or the date you intend to pay the transaction.

      If you override the Date field, the Exchange rate date updates automatically.

Enter line items

In the Entries section, you can add values directly to each line item, or select Show defaults to define default values to autofill each line item. To set up a value as a default for each existing and new line item, select the dropdown beside the appropriate field and choose a value. You can override any default value on any line item. Learn more about setting default line items.

  1. Select an Account to receive the expense.

    If your company is set up to use account labels, enter an Account Label instead. If a default account or account label is set up in the supplier record, this is automatically filled in.

  2. If the supplier is set up for 1099 tracking and enabled for 1099 flag override, you can tag individual line items for 1099 treatment.
  3. Enter the line item Amount, even if the amount is zero.

    For multi-currency companies, enter the Transaction amount, which is the amount in the transaction currency. This calculates the Base Amount of the line item in your company's base currency according to the exchange rate defined in the header.

    Are you entering a negative line item as an inline credit?

  4. (Companies enabled for allocations) Select a transaction Allocation template for the line item to distribute the AP supplier invoice amount across specified dimensions.

    This selection overrides the allocation template in the Entries defaults section. Any default dimensions that you selected for those line items do not flow through to the transaction allocations table. Select Customize Allocation above the table to set values. You can select Show defaults and enter a default for all the line items in your allocation table. Learn more about how to Allocate AP supplier invoices, AR sales invoices, or journal entries.

  5. Type a Memo to appear on the cheque stub.

    This memo does not appear on the cheque face. Learn more about printing extra information on cheques and cheque stubs.

  6. Select the Department or Location for the line item.

    If you use additional dimensions, such as customer, employee, or item, and are assigning the expense to them, select the corresponding dimension dropdown list and select the value.

    Including a warehouse dimension on a transaction won’t affect Inventory values. It's only used for tracking and reporting purposes.

Define the recurring schedule

  1. On the Recurring AP supplier invoice page, select the Schedule tab.
  2. For Start date, enter the date when you want Sage Intacct to generate the first recurring AP supplier invoice.
    Next execution date is filled in automatically
  3. For Repeats, select the time interval when the AP supplier invoice recurs, then enter the number of intervals into Every.
    For weeks, months, and years, the AP supplier invoice recurs at the next interval on the same day as the start date. For example, if you set a start date on the 15th of the month and recur monthly, the AP supplier invoice generates each month on the 15th.
     
  4. For Ends, select the appropriate termination value for this AP supplier invoice.
    Recurring AP supplier invoice termination schedule
    EndsDescription

    Never

    Runs the recurring AP supplier invoice schedule until you deactivate or delete the recurring AP supplier invoice template. This is common for AP supplier invoices like ongoing services that have a set price.

    After ____ occurrences

    Runs the recurring AP supplier invoice for a set number of intervals. This setting is often used for debts that are being paid over time. Setting the number of occurrences eliminates the possibility of making payments after the debt is paid off.

    Example: If you are making 18 monthly payments to a supplier, Repeats are Month, Every is 1, and After ___ occurrences is 18.

    On ____

    Ends the recurring AP supplier invoice on a set date.

    Example: Say you know that your contracted obligation with the supplier ends on a set date. After the contract ends, it will be renegotiated and the billing terms might change. Create the recurring AP supplier invoice template for the current amounts and terms and enter the date when the last AP supplier invoice for the current contract will be generated. When the contract is renegotiated, create a new template to set up recurring AP supplier invoices.

  5. Select Save.

The recurring AP supplier invoice is added to the list of AP supplier invoices to generate automatically, on the schedule you specified.

Tips for scheduling recurring AP supplier invoices

For weeks, months, and years, the AP supplier invoice will recur at the next interval on the same day as the start date. For instance, if you set an AP supplier invoice to start on March 15th and recur monthly, the first AP supplier invoice will be created on March 15th. Subsequent AP supplier invoices recur on the 15th of each month after that.

Option for repeating How to use

Days

Enter the number of days until the AP supplier invoice should be repeated.

For example if the Start date is 1/1/2021 and you enter 5 days, the first AP supplier invoice will be created on 1/1/2021 and the next one 5 days later (on 1/6/2021). The AP supplier invoice will continue to be repeated every 5 days.

Weeks

Enter the number of weeks until the AP supplier invoice should be repeated.

For example, if the Start date is 1/1/2021 and you enter 1 week, the first AP supplier invoice will be created on 1/1/2021 and the next one 1 week later (on 1/8/2021). The AP supplier invoice will continue to be repeated every week.

Months

Enter the number of months until the AP supplier invoice should be repeated.

For example, if the Start date is 1/1/2021 and you enter 2 months, the first AP supplier invoice will be created on 1/1/2021 and the next one on 3/1/2021. The AP supplier invoice will continue to be repeated every two months.

Months with “End of Month” option

Select this option if you want the AP supplier invoice to be created at the end of the month, rather than on the same day as the start date.

For example, if the Start date is 1/1/2021 and you want to repeat the AP supplier invoice every month, the first AP supplier invoice will be created at the end of January, the next AP supplier invoice at the end of February, and so on.

Years

Enter the number of years until the AP supplier invoice should be repeated.

For example, if the Start date is 1/1/2021 and you enter 1 year, the first AP supplier invoice will be created on 1/1/2021, the next one on 1/1/2022, and so on, every year after.