Creating Recurring Sales Invoices

Setting up a repeating Sales Invoice for subsequent and continued re-use.

Written By Grainne Reidy (Super Administrator)

Updated at July 27th, 2024

Introduction

Recurring invoices can be used to invoice for services, maintenance, or frequent delivery. They can be set up to recur automatically at weekly, bi-weekly, monthly, quarterly, or yearly intervals. The system will remind you when recurring invoices are due to be generated. At this stage, you can change any details as needed.

See:

  Sales Recurring Invoices (3.3) - AIQ Academy

Sales Item Invoices‍ 

How do I Maintain Customer Master Records?‍ 

Delete

Creating a Recurring Sales Invoice

Step One: Complete the Item Invoice

  1. Go to Sales > Item InvoicesNew Item Invoice.


     
  2. Complete a Sales Item Invoice‍ as normal but check Save as Recurring Invoice
  3. To post the first Invoice now, click Save > Post & Print Invoice. This will also create a Recurring Invoice template. Alternatively, just click Save if you want to make changes and generate it later.

Step Two: Setting up the Recurrence

  1. On clicking Save, the System Recurring Transaction screen will open. Complete the header details as required:
    1. Name: Provide further detail for identification purposes.
    2. Account: The Customer Name will appear here.
    3. Frequency: Enter the Frequency of Invoice generation. If you select the Weekly Frequency option, then you must also provide the Day of the Week on which the forward Invoices are to occur.  
    4. Start Date: For non-weekly frequencies, Invoices will recur on the anniversary of the Start Date
    5. End Date: If the Invoice is for a limited time, such as if a SaaS Contract will expire, then you should enter an End Date either on or shortly after the date the last Recurring Invoice is due.
    6. Copy line details from the previous invoice: If you made changes in the previous Invoice that you want to carry forward, check this.

    7. Refresh List: Click to view a listing of the forward transactions for the next two or for the Start and End Dates selected. Recurring Invoices in green are past the Invoice date, allowing you to generate and post them. Invoices in yellow are the next scheduled for recurrence. 





  2.  Generate as many forward transactions as you wish by checking the relevant entries in the Generate column. 
  3. Click Process.

Using the Recurring Invoice Listing Grid

Actions using the listing grid

  • Generate a recurring invoice: Click Generate in the Recurring Invoice Grid. Clicking Generate here will produce an Invoice for the date listed in the Next Due Date column. 
  • Access the System Recurring Transaction Setting screen: Click the Recurring Invoice Name code in the Name column.
    Graphical user interfaceDescription automatically generated
  • Posting the Recurring Invoice: The generated Invoices have the status of New. They must be posted to update the General Ledger and need to be printed and/or emailed to the Customer as required. Filter the Due? column so only Recurring Invoices that are due are visible. In the Post column, check all relevant Recurring Invoices. Click Post Selected.

     

Recurring Invoice Notifications

You can view notifications in the top right of the window. The Recurring icon will notify you of Recurring Invoices that may be due for processing. Clicking the icon will open the Recurring Invoices grid.
 

Graphical user interface, text, application, chat or text messageDescription automatically generated

Delete

Cancelling and Discontinuing Recurring Invoices

Go to Sales > Recurring and find the relevant Invoice. Click on the Invoice code under the Name column to open the System Recurring Transactions Setting.

Cancelling a Recurring Invoice

  1. Cancel one or more Recurring Invoices by clicking on the icon in the Cancel column against the relevant Invoice.


     
  2. In the screen that appears, enter a reason for the cancellation and click Update if you wish to proceed, or else Cancel.

Discontinuing a Recurring Invoice

  1. To discontinue a Recurring Invoice, uncheck Active.



  2. Click Process. You will no longer be able to generate Invoices from the Actions dropdown in the Recurring Invoice grid or within that System Recurring Transactions Setting screen. However, this will not affect any saved or posted Recurring Invoices.



Delete

Editing Recurring Invoice Details

You can edit a Recurring Invoice when it is:

  • In a Processed state.
  • In a Pro forma state. 
  • Does not have a posted status.
  1. Go to Sales > Recurring and find the relevant Invoice. 
  2. Click on the Invoice code under the Name column to open the System Recurring Transactions Setting screen.
  3. Click the relevant Int No. to open the Sales Item Invoice screen.


     
  4. Edit the details as necessary. If you checked Copy Line details from the previous invoice, then future generated invoices will have the edited details.

Delete

EDI File Generation

If you operate or deal with supermarkets, you can generate an EDI file to send sales invoices in electronic soft copy format rather than PDF. Each debtor needs to be linked to a file format in their Customer Master Record‍ in the Finance Settings tab. 

  1. Create a Sales Invoice.
  2. Go to Sales > EDI File Generation and create and save the file to send to your debtor.
Delete