Recurring Payables

Overview

A Recurring Payable is a Payable template that allows you to create payable records that should be repeated during a defined future interval.

Note: After creating a Recurring Payable(s), if you would like to automate the process for running, refer to the Automated Jobs article to schedule the Recurring Payable job. 

Do you want to:

• Create a Recurring Payable
• Create Recurring Payable Lines
• Clone a Recurring Payable

Create a Recurring Payable

1. Navigate to Accounting Home and click the Setup tab. Then, under the Automations menu, click Recurring Payables.
2. Click New.
   Note: Setting up a Recurring Payable includes an Owner field that is populated with the login name. 
3. The following fields are required before the New Recurring Payable can be saved:
   
   • Recurring Payable Name: Any name can be used.
   • Vendor, Contact, or Employee name.
     Note: You must select one and only one of the three options.
     Note: If selecting a Contact or Employee, the resulting Payable created will have its Due Date set to the Issue Date.
     
   • Status: Determines if the Recurring Payable should still be used (defaults to Active, can be set to Inactive).
   • Payable Frequency defaults to Monthly but can be reset to:
     • • Weekly
       • Bi-weekly
       • Quarterly
       • Semi-Annual
       • Annual
         Note: Accounting Seed does not support the usage of custom frequencies.
         
   • Next Payable Date: Used to specify the creation date of the next Payable.
4. Complete the following optional fields, as necessary:
   • End Date: Used to specify the date until which Payables can be created from this Recurring Payable. If the Next Payable Date is equal to or greater than the End Date, the Status on the Recurring Payable will automatically be set to “Inactive.” If an attempt is made to create a Payable after the End Date, a message displays to indicate that “You cannot create a Payable from an inactive Recurring Payable record.”
     Note: The existing End Date can be manually changed and the Status can be reset to “Active,” if necessary.
     
   • Last Payable Date: This field is used for recording the date the last Payable was created from this Recurring Payable template. It is ignored when creating a new Payable.
5. Exit the New Recurring Payable screen by clicking:
   • Save: Saves the New Recurring Payable. 
   • Save & New: Saves the New Recurring Payable screen and offers another (blank) New Recurring Payable screen to populate (repeat this process until all required Recurring Payables have been created).
   • Cancel: Cancels the current New Recurring Payable.

Note: The Exclude from Automation checkbox is used in conjunction with scheduled jobs. By default, this is unchecked and the Recurring Payable record will be included in a scheduled job. When checked, the Recurring Payable record will be excluded from the scheduled job.

Return to top

Create Recurring Payable Lines

The Advanced Line Manager functionality that includes the data grid with expand/collapse drawer capabilities is available when creating a Recurring Payable Line.

Note: For information about the Advanced Line Manager, including functionality, refer to the Advanced Line Manager article. 

1. If you already have a Recurring Payable displayed, continue with step 2. Otherwise, navigate to Accounting Home and click the Setup tab. Then, under the Automations menu, click Recurring Payables. Do the following:
   
   1. Select a list view (other than the Recently Viewed list view).
   2. Select a desired Recurring Payable. Then, continue with step 2.
2. The initial row displays in the expand/collapse data grid. Click the Calendar icon to select and enter a Date, which is a required field. 
   
   
   Note: Click here to view the above image in full screen.   
   
   Note: If an amount is entered in the Total field, after you click Save, this same amount will automatically populate in the Unit Cost field and the Quantity will be 1. If the Total field is left blank, the Unit Cost is required.
   
   The amount that is entered in the Unit Cost field multiplied by the Quantity plus the Tax Amount will determine the Total. If the Total equals this equation (Quantity x Unit Cost + Tax Amount  = Total), then the Unit Cost and the Total can be entered simultaneously. If the Quantity field is blank, upon saving, a Quantity of one will auto-populate for the line.
   
   Best Practice: To ensure that the correct Quantity and Unit Cost are reflected on the Payable, it is strongly recommended that the Quantity and Unit Cost be entered on the Recurring Payable Line. If only the Total amount is entered, the Quantity will always be set to 1 once Save is clicked.
   
   Note: If an Expense GL Account has been included on the customer Account record or a Product was entered, which includes an Expense GL Account, this GL Account will automatically populate in the Expense GL Account field on the Recurring Payable Line after clicking Save.  Otherwise, the Expense GL Account is a required field.
   
3. (Optional) Complete the following fields, as necessary.
   
   1. Product
   2. Quantity
   3. Total
   4. GL Variable 1-4
   5. Project/Project Task
      Note: If a Project is selected, a Project Task must also be selected.
      
   6. Tax Amount - populates automatically upon saving the row. However, you can click the Pencil icon to modify the Tax Amount, if necessary.
   7. Tax Group - click the Lookup icon to search for and select the Tax Group.
      Note: If Header Level Posting (HLP) is enabled and using AS Native Tax calculation, the Tax Group field is available. For information about Tax Groups, refer to the Set up AS Native Tax article.
      Note: If the Tax Group on the line has the Tax Inclusive checkbox selected, and you need information about the tax calculation, refer to the Tax Group information above in this article.
      
   8. Internal Comment - enter comments that will only be seen internally. Customers will not see comments that are entered in this field.
4. Click Save.
5. (Optional) Click Add Row to include an additional row(s).

Note: The Recurring Payable Line limit is 500 lines/rows. However, if you have the Large Data Optimizer feature enabled, the line limit is up to 20,000.  

Return to top

Clone a Recurring Payable

1. Navigate to Accounting Home and click the Setup tab. Then, under the Automations menu, click Recurring Payables.
2. Select a list view (other than the Recently Viewed list view).
3. Click the Recurring Payable that you want to clone.
4. Click Clone w/Lines. The Clone with Lines dialog box displays.
   
   
   
   
5. (Optional) Update the Next Payable Date.
   Note: The Next Payable Date defaults to today’s date.
   
6. (Optional) Select the appropriate Currency from the drop-down list.
   Note: The Currency drop-down list only displays if Multi-currency is enabled.
7. Click Clone.
8. On the Edit dialog box, update the Recurring Payable information, as needed. 
9. Click Save.

Return to top

____________________

Spring '24 Release

Release Notes and Schedule

• The Tax Inclusive calculation is available if you are using Header Level Posting (HLP) with AS Native Tax as your tax method.

____________________

Summer '23 Release

Release Notes and Schedule

• Images and hyperlinks can be included in the Advanced Line Manager using formula fields.